SAP Table OIRBPBLSTAT
Location Status definition (IS-Oil SSR)
OIRBPBLSTAT (Location Status definition (IS-Oil SSR)) 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 OIRBPBLSTAT to other SAP tables.
Source: OIRBPBLSTAT (Location Status definition (IS-Oil SSR))
OIRBPBLSTAT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | OIFSPBL | CHAR | 10 | 0 | ||
| RNBT | Business type | OIRA_RNBT | OIRBPBLB | CHAR | 4 | 0 | ||
| FTMSTM | Start of partner function validity period: time stamp | OIF_FTMSTM | NUMC | 14 | 0 | |||
| TTMSTM | End of partner function validity period - timestamp | OIF_TTMSTM | NUMC | 14 | 0 | |||
| STATUS | Location status | OIRB_STATUS | OIRBSTATDEF | CHAR | 2 | 0 | ||
| ERDAT | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | 0 | |||
| ERTIM | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | 0 | |||
| ERNAM | User who Created Record | OIF_ERNAM | CHAR | 12 | 0 | |||
| AEDAT | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | 0 | |||
| AETIM | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | 0 | |||
| AENAM | User who Changed Record | OIF_AENAM | CHAR | 12 | 0 | |||
OIRBPBLSTAT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIRBPBLSTAT | MANDT | OIRBPBLSTAT | MANDT | T000 | Clients | MANDT |
| OIRBPBLSTAT | PBLNR | OIRBPBLSTAT | MANDT | OIFSPBL | Physical Location - Master Data | MANDT |
| OIRBPBLSTAT | PBLNR | OIRBPBLSTAT | PBLNR | OIFSPBL | Physical Location - Master Data | PBLNR |
| OIRBPBLSTAT | RNBT | OIRBPBLSTAT | MANDT | OIRBPBLB | Business location at business type level (IS-OIL SSR) | MANDT |
| OIRBPBLSTAT | RNBT | OIRBPBLSTAT | PBLNR | OIRBPBLB | Business location at business type level (IS-OIL SSR) | PBLNR |
| OIRBPBLSTAT | RNBT | OIRBPBLSTAT | RNBT | OIRBPBLB | Business location at business type level (IS-OIL SSR) | RNBT |
| OIRBPBLSTAT | STATUS | OIRBPBLSTAT | MANDT | OIRBSTATDEF | Location Status definition (IS-Oil SSR) | MANDT |
| OIRBPBLSTAT | STATUS | OIRBPBLSTAT | STATUS | OIRBSTATDEF | Location Status definition (IS-Oil SSR) | STATUS |
