SAP 各种表的用法

SAP各种表的用法AllpersonneladministrationtablesstartwithPAandtheinfotypenumberbehindit.所有职员的管理table是以PA打头并有相应的infotype加在其后的.Allpersonneldevelopment/OMtablesstartwithHRPandinfotype(e.g.1000)behindit.所有职员的development/OMtable是以HRP打头并有相应的infotype加在其后的.AllrecruitmenttablesstartwithPBandinfotypenumberbehindit.所有招聘的人员的表是以PB打头,并以相应的infotype号结尾的.TherealsoareHRtablesthatstartwithHRA,HPD,HRT,etc.TheeasywaytogetalististouseSAP's'ApplicationHierarchy',transactionSE81(selectallHRmodesinthetreethatyouarewantalistoftablesfor,clickonthe'InformationSystem'button,underAbapDictionary--BasicObjs,doubleclickon'databasetables',increaseyour'maximunno.ofhits'andexecute).同样,有HRA,HPD,HRT等等打头的表也是HR里的,有一种获取的方便方法,事务'SE81'中,(在右边的树结构里,选择所有HR有关的modes,点击工具栏上的'InformationSystem'按纽,在AbapDictionary中选BasicObjs,双击'databasetables',输入'maximunnoofhits'后执行.Usetransactionse11...typeinPA*dodropdownandenter,dothesameforHRP*andyouwillhavemostoftheHRtransaparentTables.ToaccessthemlookforRP_read_*andRP_provide*inTableTRMACtoreadainfotypeorusethe'select'statementtoaccesstheTransparenttable.TransactionSE16(databrowser)isalsouseful.Asmentionedabove,thePAinfotypetablesallbeginwithPAandarefollowedbytheinfotypenumbere.g.PA0001fortheOrgManinfotype.用事务se11,输入PA*后按F4,同样输入HRP*,你会看见大多HR用的transaparentTables,在表TRMAC中访问RP_read_*和RP_provide*打头的去读取一个infotype.或是用select语句访问这些表.PA*-PAinfotypetablesPCL*-HRclustersPB*-recruitmenttablesPCERT-payrollpostingrunsAnotherusefultableisCATSDBforCATS,andPTEX2000fortheCATStransfertableforinfotype2001/2002.TherestoftheHRTablesareasfollows:DD01LDomainsDD02LSAPtablesDD03LTableFieldsDD03TDD:Textsforfields(languagedependent)DD04LDataelementsDD04TR/3DD:DataelementtextsDD05SForeignkeyfieldsDD06LPool/clusterstructuresDD20LMatchcodeIdsDD24SFieldsofamatchcodeIDT000ClientsT001CompanyCodesT001ECompanycode-dependentaddressdataT001PPersonnelAreas/SubareasT012HousebanksT012KHousebankaccountsT012THousebankaccountnamesT500LPersonnelCountryGroupingT500PPersonnelAreasT500TPersonnelCountryGroupingsT501EmployeeGroupT501TEmployeeGroupNamesT502TMaritalStatusDesignatorsT503EmployeeGroups/SubgroupsT503KEmployeesubgroupT503TEmployeeSubgroupNamesT504ABenefits-DefaultValues(NA)T504BBenefitOptionTexts(NorthAmerica)T504CBenefitType(NA)T504DBenefitCreditGroupAmountT504EBenefitAmountT504FBenefitCostsT508AWorkScheduleRulesT508TTextsforEmployeeSubgroupGroupingsforWorkSchedulesT510PayScaleGroupsT510APayScaleTypesT510FAssignPayScaleTimeUnit,CurrencyT510GPayScaleAreasT510HPayrollConstantswithRegardtoTimeUnitT510IStandardWorkingHoursT510JConstantValuationsT510LLevelsT510MValuationofpayscalegroupsacc.tohiringdateT510NPayScalesforAnnualSalaries(NA)T510STimeWageTypeSelectionRuleT510UPayScaleGroupsT510YSpecialRulesforWageTypeGenerationT511WageTypesT512RCumulationWageTypesinFormsT512STextsforCumulationWageTypesinFormsT512TWageTypeTextsT512WWageTypeValuationT512ZPermissibilityofWageTypesperInfotypeT513JobsT514STableNameTextsT514TFieldNameTextsT51D2WageTypeClassesT51D3ReductionRulesT51D4CumulationRulesT527XOrganizationalUnitsT528BPositions-WorkCentersT528CWageTypeCatalogT528TPositionTextsT529APersonnelEventT529FFastDataEntryforEventsT529TPersonnelEventTextsT52BTTextsForHRObjectsT52C0PayrollSchemasT52C1PayrollSchemasT52C2TextsforPersonnelCalculationSchemasT52C3TextsforPersonnelCalculationSchemasT52C5PersonnelCalculationRulesT52CCSchemaDirectoryT52CDSchemaDirectoryT52CEDirectoryofPersonnelCalculationRulesT52CTTextElementsT52CXCrossReferencesviaGeneratedSchemasT52D1ValidProcessingClassesT52D2ValidValuesforProcessingClassesT52D3ValidEvaluationClassesT52D4PermittedValuesforEvaluationClassesT52D5WageTypeGroupsT52D6WageTypeGroupTextsT52D7AssignWageTypestoWageTypeGroupsT52D8ValidProcessingClasses-TextsT52D9ValidValuesforProcessingClasses-TextsT530ReasonsforEventsT530EReasonsforChangesT530FReasonsforChangesT530LWageTypesforSpecialPaymentsT530TEventReasonTextsT531DeadlineTypesT531SDeadlineTypeTextsT533LeaveTypesT533TLeaveTypeTextsT539ADefaultWageTypesforBasicPayT539JBaseWageTypeValuationT539REventsforStandardWageMaintenanceT539SWageTypesforStandardWageMaintenanceT548DateTypesT548SDateConversionT548TDateTypesT548YDateTypesT549APayrollAreasT549BCompanyFeaturesT549CDecisionTreesforFeatures(Customers)T549DFeatureDirectoryT549LDatemodifiersT549MMonthlyAssignment:PayrollPeriodT549NPeriodModifiersT549OTextfordatemodifierT549PValidTimeUnitsforPayrollAccountingT549QPayrollPeriodsT549RPeriodParametersT549SPayrolldatetypesT549TPayrollAreasT549MMonthlyAssignment:PayrollPeriodT549NPeriodModifiersT549OTextfordatemodifierT549PValidTimeUnitsforPayrollAccountingT549QPayrollPeriodsT549RPeriodParametersT549SPayrolldatetypesT549TPayrollAreasT554SAbsenceandAttendanceTypesT554TAbsenceandAttendanceTextsT554VDefaultsforAbsenceTypesT554YTimeConstraintsinHRTIMET555ATimeTypesT555BTimeTypeDesignationsT559AWorkingWeeksT559BNameofWorkingWeekT572FEventTextsT572GAllowedValuesforEventsT572HEventValueTextsT582AInfotypesT582BInfotypesWhichAreCreatedAutomaticallyT582SInfotypeTextsT582VAssignmentofInfotypestoViewsT582WAssignsInfo