SAP Table PA0318

HR Master Record: Infotype Family data for Indonesia (0318)

PA0318 (HR Master Record: Infotype Family data for Indonesia (0318)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PA0318 to other SAP tables.

PA0318 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PERNR Personnel number PERSNO PA0003 NUMC 8 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
PASNR Passport Number PID_PASNR CHAR 30 0
PASTY Passport Type PID_PASTY CHAR 20 0
ISSUE Date of issue of Passport (Indonesia) PID_ISSUE DATS 8 0
EXPIR Date of expiry of Passport (Indonesia) PID_EXPIR DATS 8 0
PLACE Place of Issue of Passport PID_PLACE CHAR 25 0
CNTRY Country Key LAND1 T005 CHAR 3 0
TELNR Telephone Number TELNR CHAR 14 0
JOBTL Job Title STLTX CHAR 25 0
SPEMS Employer of family member (Indonesia) PID_SPEMS CHAR 40 0
STRAS House number and street STRAS CHAR 30 0
LOCAT 2nd Address Line LOCAT CHAR 30 0
ORT01 City ORT01 CHAR 25 0
PSTLZ Postal Code PSTLZ_HR CHAR 10 0
ORT02 District ORT02 CHAR 25 0
LAND1 Country Key LAND1 T005 CHAR 3 0
DEPTX Dependent for Tax purposes (Yes/No) (Indonesia) PID_DEPTX CHAR 1 0
X Yes
NULL No
DEPSI Dependent for SI Purposes (Yes / No) (Indonesia) PID_DEPSI CHAR 1 0
X Yes
NULL No
BENFT Entitled For Benefits (Yes / No) (Indonesia) PID_BENFT CHAR 1 0
X Yes
NULL No
MARCT Marriage certificate PID_MARCT CHAR 25 0
IDNUM Identity Card Number PID_IDNUM CHAR 30 0
IDCTY Type of Identity Card (Indonesia) PID_IDCTY CHAR 5 0
IDDAT Date of Issue of Identity Card (Indonesia) PID_IDDAT DATS 8 0
IDEXP Expiry Date of Identity Card (Indonesia) PID_IDEXP DATS 8 0
IDPLA Place of Issue of Identity Card PID_IDPLA CHAR 30 0

PA0318 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PA0318 CNTRY SYST MANDT T005 Countries MANDT
PA0318 CNTRY PA0318 CNTRY T005 Countries LAND1
PA0318 LAND1 PA0318 LAND1 T005 Countries LAND1
PA0318 LAND1 SYST MANDT T005 Countries MANDT
PA0318 MANDT PA0318 MANDT T000 Clients MANDT
PA0318 PERNR SYST MANDT PA0003 HR Master Record: Infotype 0003 (Payroll Status) MANDT
PA0318 PERNR PA0318 PERNR PA0003 HR Master Record: Infotype 0003 (Payroll Status) PERNR
PA0318 PREAS SYST MANDT T530E Reasons for Changes MANDT
PA0318 PREAS PSKEY INFTY T530E Reasons for Changes INFTY
PA0318 PREAS PA0318 PREAS T530E Reasons for Changes PREAS