SAP Table OIFSPBLT

Physical Business Location Type

OIFSPBLT (Physical Business Location Type) 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 OIFSPBLT to other SAP tables.

OIFSPBLT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PBLTYP Business Location Type (IS-Oil MRN) OIF_PBLTYP CHAR 4 0
NUMRI ID for Internal Number Range OIF_NUMRI CHAR 2 0
NUMRE ID for External Number Range OIF_NUMRE CHAR 2 0
FLAG1 Indicator 1 OIF_SFLAG1 CHAR 1 0
X Yes
NULL No
FLAG2 Indicator 2 OIF_SFLAG2 CHAR 1 0
X Yes
NULL No
FLAG3 Indicator 3 OIF_SFLAG3 CHAR 1 0
X Yes
NULL No
FLAG4 Indicator 4 OIF_SFLAG4 CHAR 1 0
X Yes
NULL No
ERDAT Date Record Created on (Date) OIF_ERDAT DATS 8 0
ERZEIT 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
AEZEIT Time when Record Was Changed OIF_AEZEIT TIMS 6 0
AENAM User who Changed Record OIF_AENAM CHAR 12 0
FLAG_COMP Competitor location (flag) OIRB_FLAG_COMP CHAR 1 0
X Yes
NULL No
PLANIND Planning location flag OIJ_PLANIN CHAR 1 0
X Yes
NULL No
REFIND OIL-TSW: Refinery indicator OIJ_REFIND CHAR 1 0
X Yes
NULL No
ODINDO OIL-TSW: Location is origin flag OIJ_ODINDO CHAR 1 0
X Yes
NULL No
ODINDD OIL-TSW: Location destination flag OIJ_ODINDD CHAR 1 0
X Yes
NULL No

OIFSPBLT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIFSPBLT MANDT OIFSPBLT MANDT T000 Clients MANDT