SAP Table P0511

Infotype Cost-of-Living Allowance/Office (0511)

P0511 (Infotype Cost-of-Living Allowance/Office (0511)) 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 P0511 to other SAP tables.

Source: P0511 (Infotype Cost-of-Living Allowance/Office (0511))

P0511 table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY T582A CHAR 4 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
PGMDW Municipality key (city of residence) P02_PGMDW T5C4A NUMC 4 0
GMDTW District key (city of residence) P02_GMDTW T5CPBS04 CHAR 2 0
PGMDD Municipality key (employment location) P02_PGMDD T5C4A NUMC 4 0
GMDTD District key (employment location) P02_GMDTD T5CPBS04 CHAR 2 0
OZSTF Cost of living allowance level P02_OZSTF T5CPBS05 NUMC 2 0
OZRGL Cost-of-living allowance: Rules P02_OZRGL CHAR 2 0
WD City of residence and employment location rule
GR Guarantee rules
KA Not entitled
13 Cost-of-living allowance level 13
WO City of residence
DO Employment location
SO Other
AMTKY Employee activity key P02_AMTKY T5CPBS01 CHAR 3 0

P0511 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0511 AMTKY P0511 AMTKY T5CPBS01 Employee Activity Key AMTKY
P0511 AMTKY PSYST MANDT T5CPBS01 Employee Activity Key MANDT
P0511 GMDTD * T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl ENDDA
P0511 GMDTD P0511 GMDTD T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl GMDTL
P0511 GMDTD P0511 PGMDW T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl GEMND
P0511 GMDTD PSYST MANDT T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl MANDT
P0511 GMDTW * T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl ENDDA
P0511 GMDTW P0511 GMDTW T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl GMDTL
P0511 GMDTW P0511 PGMDW T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl GEMND
P0511 GMDTW PSYST MANDT T5CPBS04 Assgt Municipality (Distr) -> Cost-of-Living Level Allow.Lvl MANDT
P0511 INFTY P0511 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0511 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0511 OZSTF * T5CPBS05 Cost-of-Living Allowance Levels and Amounts ENDDA
P0511 OZSTF P0511 OZSTF T5CPBS05 Cost-of-Living Allowance Levels and Amounts OZSTF
P0511 OZSTF PSYST MANDT T5CPBS05 Cost-of-Living Allowance Levels and Amounts MANDT
P0511 PGMDD P0511 PGMDD T5C4A Municipality GEMND
P0511 PGMDD PSYST MANDT T5C4A Municipality MANDT
P0511 PGMDW P0511 PGMDW T5C4A Municipality GEMND
P0511 PGMDW PSYST MANDT T5C4A Municipality MANDT
P0511 PREAS P0511 PREAS T530E Reasons for Changes PREAS
P0511 PREAS P0511 INFTY T530E Reasons for Changes INFTY
P0511 PREAS SYST MADNT T530E Reasons for Changes MANDT