SAP table PLOG (Planning and Organization File)

SAP table PLOG has 12 primary key fields being MANDT,PLVAR,OTYPE,OBJID,INFTY,SUBTY,ISTAT,PRIOX,BEGDA,ENDDA,VARYF,SEQNR.

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
PLVAR Plan Version CHAR 2 0 T778P PLVAR
OTYPE Object Type CHAR 2 0 T778O OTYPE
OBJID Object ID NUMC 8 0 PLOGI HROBJID
INFTY Infotype CHAR 4 0 T778T INFOTYP
SUBTY Subtype CHAR 4 0 T778U SUBTYP
ISTAT Planning Status CHAR 1 0 T778S ISTAT_D
PRIOX Priority CHAR 2 0 PRIOX
BEGDA Start Date DATS 8 0 BEGDATUM
ENDDA End Date DATS 8 0 ENDDATUM
VARYF Variation Field for File PLOG CHAR 10 0 VARYF
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Changed on DATS 8 0 AEDTM
UNAME User Name CHAR 12 0 USRNAME
REASN Reason CHAR 2 0 REASN
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXNR Text Module for Infotype NUMC 8 0 ITXNR
VDATA Data Field PLOG RAW 250 0 VDATAR

PLOG foreign key relationships

Table Field Check Table Check Field
0 PLOG INFTY T778T Infotypes MANDT
0 PLOG INFTY T778T Infotypes INFTY
1 PLOG ISTAT T778S Planning Status MANDT
0 PLOG MANDT T000 Clients MANDT
1 PLOG OBJID PLOGI Table Index HRP* MANDT
1 PLOG OBJID PLOGI Table Index HRP* PLVAR
1 PLOG OBJID PLOGI Table Index HRP* OTYPE
1 PLOG OBJID PLOGI Table Index HRP* OBJID
0 PLOG OTYPE T778O Object Types MANDT
0 PLOG OTYPE T778O Object Types OTYPE
1 PLOG PLVAR T778P Plan Versions MANDT
0 PLOG SUBTY T778U Subtypes MANDT
0 PLOG SUBTY T778U Subtypes INFTY
0 PLOG SUBTY T778U Subtypes SUBTY