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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
FLAG2
Indicator 2
|
OIF_SFLAG2 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLAG3
Indicator 3
|
OIF_SFLAG3 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FLAG4
Indicator 4
|
OIF_SFLAG4 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
PLANIND
Planning location flag
|
OIJ_PLANIN |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
REFIND
OIL-TSW: Refinery indicator
|
OIJ_REFIND |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ODINDO
OIL-TSW: Location is origin flag
|
OIJ_ODINDO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ODINDD
OIL-TSW: Location destination flag
|
OIJ_ODINDD |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
OIFSPBLT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIFSPBLT | MANDT | OIFSPBLT | MANDT |
T000
Clients
|
MANDT |