SAP table PLAB (Relationships)

SAP table PLAB has 11 primary key fields being MANDT,PLNTY,PLNNR,PLNAL,PLNKN,PLNRN,ALNRN,KNNRN,AOBAR,MIMAX,ZAEHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PLNTY Task List Type CHAR 1 0 PLNTY
PLNNR Number of the Standard Network CHAR 8 0 AOB_PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
PLNRN Number of the Standard Network CHAR 8 0 AOB_PLNNR
ALNRN Group Counter CHAR 2 0 PLNAL
KNNRN Number of the Task List Node NUMC 8 0 PLNKN
AOBAR Type of relationship CHAR 2 0 AOBAR
MIMAX Indicates whether maximum time interval will be considered CHAR 1 0 DAUMIMAX
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-from date DATS 8 0 CIM_DATE
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
ZEINH Unit for the time interval between relationships UNIT 3 0 T006 AOBDAUEH
DAUER Time Interval Between Relationships QUAN 5 1 AOBDAUER
DAUKZ Indicator for the duration of the relationship CHAR 1 0 AOBDAUKZ
VORNC Indicator: maintained after successor CHAR 1 0 VORG_NACH
NCVOR Indicates whether data after predecessor is maintained CHAR 1 0 NACH_VORG
LOEKZ Asset class marked for deletion CHAR 1 0 LOEKZ
KALID Factory Calendar CHAR 2 0 TFACD WFCID
PRZNT % used to calc. time interval between predecessor/successor NUMC 3 0 AOB_PRZNT
PROVG Key for defining time intervals in a relationship CHAR 1 0 AOB_PROVG
Absolute (standard)
1 % duration of predecessor
2 % duration of successor
ARBID Object ID NUMC 8 0 OBJEKTID
WERKS Plant CHAR 4 0 T001W WERKS_D
ANDAT Date Record Created On DATS 8 0 ANDAT
ANNAM User who created record CHAR 12 0 ANNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
DAUERMAX Maximum time interval for relationship QUAN 5 1 AOBDAUERM
VALID_TO Valid-to date DATS 8 0 DATUB
LOEKZ_INHERITED Deletion Indicator CHAR 1 0 LKENZ

PLAB foreign key relationships

Table Field Check Table Check Field
0 PLAB AENNR AENR Change Master AENNR
1 PLAB MANDT T000 Clients MANDT
0 PLAB WERKS T001W Plants/Branches MANDT
0 PLAB WERKS T001W Plants/Branches WERKS
1 PLAB ZEINH T006 Units of Measurement MANDT