SAP Table OIFSPBL
Physical Location - Master Data
OIFSPBL (Physical Location - Master Data) 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 OIFSPBL to other SAP tables.
OIFSPBL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PBLNR
Business location identifier (IS-Oil MRN)
|
OIF_PBLNR |
CHAR
|
10 | 0 | ||||||||||
|
NAME1
Internal name field
|
OIF_PBNAM1 |
CHAR
|
35 | 0 | ||||||||||
|
A1_SGRNDB
Land Register Number (IS-Oil MRN Demo APPEND)
|
OIF_SGRNDB |
NUMC
|
8 | 0 | ||||||||||
|
A1_UTILTP
Usage Type of Property (IS-Oil MRN Demo APPEND)
|
OIF_UTILTP |
CHAR
|
2 | 0 | ||||||||||
|
A1_GRTYP
Property Type (IS-Oil MRN Demo APPEND)
|
OIF_GRTYP |
NUMC
|
3 | 0 | ||||||||||
|
A1_GRQAL
Quality of Business Location (IS-Oil MRN Demo APPEND)
|
OIF_GRQAL |
NUMC
|
3 | 0 | ||||||||||
|
A1_GRFRM
Property Type (IS-Oil MRN Demo APPEND)
|
OIF_GRFRM |
NUMC
|
3 | 0 | ||||||||||
|
A1_GRGZS
Overall Condition of Property (IS-Oil MRN Demo APPEND)
|
OIF_GRGZS |
NUMC
|
3 | 0 | ||||||||||
|
A1_DAKTB
Date Active in Inventory (IS-Oil MRN Demo APPEND)
|
OIF_DAKTB |
DATS
|
8 | 0 | ||||||||||
|
PBLTYP
Business Location Type (IS-Oil MRN)
|
OIF_PBLTYP | OIFSPBLT |
CHAR
|
4 | 0 | |||||||||
|
ADDRNUM
Address No. in ADRC
|
OIF_ADNUM | OIFSMCADDR |
CHAR
|
10 | 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 | ||||||||||
|
BLOIND
Block Indicator
|
OIF_BLOIND |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
DELIND
Deletion indicator
|
OIF_DELIND |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
BLCODE
Business Location Blocking Indicator (IS-Oil MRN)
|
OIF_BLCD | OIFSBLCD |
CHAR
|
2 | 0 | |||||||||
|
OBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||||
|
BRAND
Location brand
|
OIRB_BRAND | OIRBBRAND |
CHAR
|
5 | 0 | |||||||||
|
LOCVALUE
Relative location value
|
OIRB_VAL | OIRBPBLVAL |
CHAR
|
2 | 0 | |||||||||
|
LOCVDIFF
Location value differentiator
|
OIRB_LOCVDIFF | OIRBPBLVALD |
CHAR
|
2 | 0 | |||||||||
|
LOCAA
Location area assignment
|
OIRB_LAA | OIRBLAA |
CHAR
|
5 | 0 | |||||||||
|
LOCMP
SSR Pricing - Margins procedure assigned to this location
|
OIRC_KALKS | OIRCTVKD |
CHAR
|
1 | 0 | |||||||||
|
PCGROUP
Process control group
|
OIRA_PCG | OIRAPCG |
CHAR
|
10 | 0 | |||||||||
|
AUTGR
Authorization group
|
OIRB_AUTGR |
CHAR
|
4 | 0 | ||||||||||
|
VALGP
SSR PC: Upload validation group
|
OIREVALGROUP | OIREVALGP |
CHAR
|
2 | 0 | |||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||
|
OIRIPGRP
SSR SD/FI Invoice posting group
|
OIRI_PGRP |
CHAR
|
2 | 0 | ||||||||||
|
CONVGR
SSR Interface conversion group definition (IS-Oil, SSR)
|
OIRH_CONVGR | OIRHCVGRDEFC |
CHAR
|
4 | 0 | |||||||||
|
LOGSYS
Logical system for EDI
|
OIRH_LOGSYS | TBDLS |
CHAR
|
10 | 0 | |||||||||
|
TPLST
Transportation planning point
|
TPLST | TTDS |
CHAR
|
4 | 0 | |||||||||
|
TPLST_TXT
Description of transportation planning point
|
TPLST_TXT |
CHAR
|
20 | 0 | ||||||||||
|
LONGITUDE
Geo location longitude
|
GEOLON |
DEC
|
15 | 12 | ||||||||||
|
LATITUDE
Geo location latitude
|
GEOLAT |
DEC
|
15 | 12 | ||||||||||
|
TIME_TO_ADD
Duration to Add at Base Location (in hours:minutes)
|
OIO_TIME_TO_ADD |
DEC
|
11 | 0 | ||||||||||
|
AVRG_STAYT
Duration of Stay at Remote Location (in hours:minutes)
|
OIO_AVRG_STAYT |
DEC
|
11 | 0 | ||||||||||
|
KNOTE
Transportation Connection Points
|
KNOTE | TVKN |
CHAR
|
10 | 0 | |||||||||
|
KNOTE_BEZ
Node name
|
KNOTE_BEZ |
CHAR
|
30 | 0 | ||||||||||
|
ROUTE
Shipment route
|
ROUTR | TVRO |
CHAR
|
6 | 0 | |||||||||
|
TXROU
Description of Route
|
ROUTBEZ |
CHAR
|
40 | 0 | ||||||||||
|
R_CON_POINT
Radiobutton for connection point in RLM VMIS location
|
OIO_VMIS_C |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
R_ROUTE
Radiobutton for shipment route in RLM VMIS location
|
OIO_VMIS_R |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XCOOR
X coordinate
|
OIRB_COOR_X |
FLTP
|
16 | 16 | ||||||||||
|
YCOOR
Y coordinate
|
OIRB_COOR_Y |
FLTP
|
16 | 16 | ||||||||||
OIFSPBL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIFSPBL | ADDRNUM | OIFSPBL | MANDT |
OIFSMCADDR
Link Table Between OIFSPBL and ADRC for Matchcode
|
MANDT |
| OIFSPBL | ADDRNUM | OIFSPBL | PBLNR |
OIFSMCADDR
Link Table Between OIFSPBL and ADRC for Matchcode
|
PBLNR |
| OIFSPBL | ADDRNUM | OIFSPBL | ADDRNUM |
OIFSMCADDR
Link Table Between OIFSPBL and ADRC for Matchcode
|
ADDRNUM |
| OIFSPBL | BLCODE | OIFSPBL | MANDT |
OIFSBLCD
Blocking Indicator for Business Locations
|
MANDT |
| OIFSPBL | BLCODE | OIFSPBL | BLCODE |
OIFSBLCD
Blocking Indicator for Business Locations
|
BLCODE |
| OIFSPBL | BRAND | * |
OIRBBRAND
Location Brand (IS-OIL SSR)
|
MANDT | |
| OIFSPBL | BRAND | OIFSPBL | BRAND |
OIRBBRAND
Location Brand (IS-OIL SSR)
|
BRANDID |
| OIFSPBL | BUKRS | OIFSPBL | BUKRS |
T001
Company Codes
|
BUKRS |
| OIFSPBL | BUKRS | * |
T001
Company Codes
|
MANDT | |
| OIFSPBL | CONVGR | * |
OIRHCVGRDEFC
Conversion Group Definitions(IS-Oil, SSR)
|
MANDT | |
| OIFSPBL | CONVGR | OIFSPBL | CONVGR |
OIRHCVGRDEFC
Conversion Group Definitions(IS-Oil, SSR)
|
CONVGR |
| OIFSPBL | KNOTE | OIFSPBL | KNOTE |
TVKN
Routes: Transportation Connection Points
|
KNOTE |
| OIFSPBL | KNOTE | OIFSPBL | MANDT |
TVKN
Routes: Transportation Connection Points
|
MANDT |
| OIFSPBL | LOCAA | SY | MANDT |
OIRBLAA
Location area assignment (IS-OIL SSR)
|
MANDT |
| OIFSPBL | LOCAA | ' ' |
OIRBLAA
Location area assignment (IS-OIL SSR)
|
RNBT | |
| OIFSPBL | LOCAA | OIFSPBL | LOCAA |
OIRBLAA
Location area assignment (IS-OIL SSR)
|
LOCAA |
| OIFSPBL | LOCAA | * |
OIRBLAA
Location area assignment (IS-OIL SSR)
|
LOCAACTRY | |
| OIFSPBL | LOCMP | * |
OIRCTVKD
SSR Pricing - Location Margin Procedure
|
MANDT | |
| OIFSPBL | LOCMP | OIFSPBL | LOCMP |
OIRCTVKD
SSR Pricing - Location Margin Procedure
|
KALKS |
| OIFSPBL | LOCVALUE | OIFSPBL | LOCVALUE |
OIRBPBLVAL
Relative Location Value (IS-OIL SSR)
|
LOCVALUE |
| OIFSPBL | LOCVALUE | * |
OIRBPBLVAL
Relative Location Value (IS-OIL SSR)
|
MANDT | |
| OIFSPBL | LOCVDIFF | * |
OIRBPBLVALD
Location Value differentiator (IS-OIL SSR)
|
MANDT | |
| OIFSPBL | LOCVDIFF | OIFSPBL | LOCVDIFF |
OIRBPBLVALD
Location Value differentiator (IS-OIL SSR)
|
LOCVDIFF |
| OIFSPBL | LOGSYS | OIFSPBL | LOGSYS |
TBDLS
Logical system
|
LOGSYS |
| OIFSPBL | MANDT | OIFSPBL | MANDT |
T000
Clients
|
MANDT |
| OIFSPBL | PBLTYP | OIFSPBL | PBLTYP |
OIFSPBLT
Physical Business Location Type
|
PBLTYP |
| OIFSPBL | PBLTYP | OIFSPBL | MANDT |
OIFSPBLT
Physical Business Location Type
|
MANDT |
| OIFSPBL | PCGROUP | * |
OIRAPCG
Process Control Group (IS-OIL SSR)
|
CLIENT | |
| OIFSPBL | PCGROUP | OIFSPBL | PCGROUP |
OIRAPCG
Process Control Group (IS-OIL SSR)
|
PCGROUP |
| OIFSPBL | ROUTE | OIFSPBL | MANDT |
TVRO
Routes
|
MANDT |
| OIFSPBL | ROUTE | OIFSPBL | ROUTE |
TVRO
Routes
|
ROUTE |
| OIFSPBL | TPLST | OIFSPBL | MANDT |
TTDS
Organizational Unit: Transportation Scheduling Point
|
MANDT |
| OIFSPBL | TPLST | OIFSPBL | TPLST |
TTDS
Organizational Unit: Transportation Scheduling Point
|
TPLST |
| OIFSPBL | VALGP | OIFSPBL | VALGP |
OIREVALGP
SSR PC: Upload Validation Group
|
VALGP |
| OIFSPBL | VALGP | * |
OIREVALGP
SSR PC: Upload Validation Group
|
MANDT |