SAP table OIRBPBLSTAT (Location Status definition (IS-Oil SSR))

SAP table OIRBPBLSTAT has 4 primary key fields being MANDT,PBLNR,RNBT,FTMSTM.

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
PBLNR Business location identifier (IS-Oil MRN) CHAR 10 0 OIFSPBL OIF_PBLNR
RNBT Business type CHAR 4 0 OIRBPBLB OIRA_RNBT
FTMSTM Start of partner function validity period: time stamp NUMC 14 0 OIF_FTMSTM
TTMSTM End of partner function validity period - timestamp NUMC 14 0 OIF_TTMSTM
STATUS Location status CHAR 2 0 OIRBSTATDEF OIRB_STATUS
ERDAT Date Record Created on (Date) DATS 8 0 OIF_ERDAT
ERTIM Time Record Created at (Time) TIMS 6 0 OIF_ERZEIT
ERNAM User who Created Record CHAR 12 0 OIF_ERNAM
AEDAT Date Record Changed on (Date) DATS 8 0 OIF_AEDAT
AETIM Time when Record Was Changed TIMS 6 0 OIF_AEZEIT
AENAM User who Changed Record CHAR 12 0 OIF_AENAM

OIRBPBLSTAT foreign key relationships

Table Field Check Table Check Field
0 OIRBPBLSTAT MANDT T000 Clients MANDT
1 OIRBPBLSTAT PBLNR OIFSPBL Physical Location - Master Data PBLNR
0 OIRBPBLSTAT RNBT OIRBPBLB Business location at business type level (IS-OIL SSR) MANDT
0 OIRBPBLSTAT RNBT OIRBPBLB Business location at business type level (IS-OIL SSR) PBLNR
0 OIRBPBLSTAT RNBT OIRBPBLB Business location at business type level (IS-OIL SSR) RNBT
1 OIRBPBLSTAT STATUS OIRBSTATDEF Location Status definition (IS-Oil SSR) MANDT
1 OIRBPBLSTAT STATUS OIRBSTATDEF Location Status definition (IS-Oil SSR) STATUS