SAP Table P0001 stores HR Master Record: Infotype 0001 (Org. Assignment)data

  

In this post, I will try and describe everything you need to know about the SAP p0001 table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for P0001 what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from P0001....Right lets get started!


SAP P0001 dictionary attributes

Object Name: P0001
Dictionary Type: Structure
Description: HR Master Record: Infotype 0001 (Org. Assignment)


P0001 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
PERNRPERNR_DNUMC8(0) Personnel NumberPERNRPERPB
INFTYINFTYCHAR4(0) T582AInfotypeINFOTYPITPPINF
SUBTYSUBTYCHAR4(0) SubtypeSUBTYSUBPINF
OBJPSOBJPSCHAR2(0) Object IdentificationOBJPSOPSPINF
SPRPSSPRPSCHAR1(0) Lock Indicator for HR Master Data RecordSPRPSPINF
ENDDAENDDADATS8(0) End DateDATUMPB
BEGDABEGDADATS8(0) Start DateDATUMPB
SEQNRSEQNRNUMC3(0) Number of Infotype Record with Same KeyNUM03PP
AEDTMAEDATDATS8(0) Changed OnDATUMSAP
UNAMEAENAMCHAR12(0) Name of Person Who Changed ObjectUSNAMSAP
HISTOHISTOCHAR1(0) Historical Record FlagCHAR1PP
ITXEXITXEXCHAR1(0) Text Exists for InfotypeXFELD
REFEXPRFEXCHAR1(0) Reference Fields Exist (Primary/Secondary Costs)XFELD
ORDEXORDEXCHAR1(0) Confirmation Fields ExistXFELD
ITBLDITBLDCHAR2(0) Infotype Screen ControlCHAR2PSTA
PREASPREASCHAR2(0) T530EReason for Changing Master DataPREASPB
FLAG1NUSEDCHAR1(0) Reserved Field/Unused FieldNUSEDPLOH
FLAG2NUSEDCHAR1(0) Reserved Field/Unused FieldNUSEDPLOH
FLAG3NUSEDCHAR1(0) Reserved Field/Unused FieldNUSEDPLOH
FLAG4NUSEDCHAR1(0) Reserved Field/Unused FieldNUSEDPLOH
RESE1NUSED2CHAR2(0) Reserved Field/Unused Field of Length 2NUSED2PLOH
RESE2NUSED2CHAR2(0) Reserved Field/Unused Field of Length 2NUSED2PLOH
GRPVLPCCE_GPVALCHAR4(0) Grouping Value for Personnel AssignmentsPCCE_GPVAL
BUKRSBUKRSCHAR4(0) T001Company CodeBUKRSBUKFBC_T001BUKRS
WERKSPERSACHAR4(0) T500PPersonnel AreaPERSAPBR
PERSGPERSGCHAR1(0) T501Employee GroupPERSGPRGPSTA
PERSKPERSKCHAR2(0) T503KEmployee SubgroupPERSKPKRPSTA
VDSK1VDSK1CHAR14(0) T527OOrganizational KeyVDSK1PSTA
GSBERGSBERCHAR4(0) TGSBBusiness AreaGSBERGSBFB
BTRTLBTRTLCHAR4(0) T001PPersonnel SubareaBTRTLPBSPAST
JUPERJUPERCHAR4(0) Legal PersonJUPERPAST
ABKRSABKRSCHAR2(0) T549APayroll AreaABKRSABKPABR
ANSVHANSVHCHAR2(0) T542AWork ContractANSVHPSTA
KOSTLKOSTLCHAR10(0) CSKSCost CenterKOSTLKOSKS
ORGEHORGEHNUMC8(0) T527XOrganizational UnitORGEHPSTA
PLANSPLANSNUMC8(0) T528BPositionPLANSPINF
STELLSTELLNUMC8(0) T513JobSTELLPSTA
MSTBRMSTBRCHAR8(0) Supervisor AreaMSTBRPINF
SACHASACHACHAR3(0) T526Payroll AdministratorSACHAPSTA
SACHPSACHPCHAR3(0) T526Administrator for HR Master DataSACHAPSTA
SACHZSACHZCHAR3(0) T526Administrator for Time RecordingSACHAPSTA
SNAMESMNAMCHAR30(0) Employee's Name (Sortable by LAST NAME FIRST NAME)CHAR30PINF
ENAMEEMNAMCHAR40(0) Formatted Name of Employee or ApplicantTEXT40PINF
OTYPEOTYPECHAR2(0) T778OObject TypeOTYPEPOTPP
SBMODSBMODCHAR4(0) Administrator GroupCHAR4SGR
KOKRSKOKRSCHAR4(0) TKA01Controlling AreaCACCDCACKS
FISTLFISTLCHAR16(0) *Funds CenterFISTLFIS
GEBERBP_GEBERCHAR10(0) *FundBP_GEBERFIC
FKBERFKBERCHAR16(0) *Functional AreaFKBERFBE
GRANT_NBRGM_GRANT_NBRCHAR20(0) GrantGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERICGRANT_NUMBER
SGMNTFB_SEGMENTCHAR10(0) *Segment for Segmental ReportingFB_SEGMENT
BUDGET_PDFM_BUDGET_PERIODCHAR10(0) *FM: Budget PeriodFM_BUDGET_PERIODBUDPER