SAP ABAP Table OIFSPBL (Physical Location - Master Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
LO (Application Component) Logistics - General
⤷
OILF (Package) IS-Oil Marketing Retail Network MRN (standard objects)

⤷

⤷

Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIFSPBL |
![]() |
Short Description | Physical Location - Master Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
![]() |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | ||
3 | ![]() |
OIF_PBNAM1 | CHAR35 | CHAR | 35 | 0 | Internal name field | ||
4 | ![]() |
0 | 0 | Business location property data (IS-Oil MRN demo APPEND) | |||||
5 | ![]() |
0 | 0 | MRN business location - Real estate property data (demo) | |||||
6 | ![]() |
OIF_SGRNDB | OIF_SGRNDB | NUMC | 8 | 0 | Land Register Number (IS-Oil MRN Demo APPEND) | ||
7 | ![]() |
OIF_UTILTP | OIF_UTILTP | CHAR | 2 | 0 | Usage Type of Property (IS-Oil MRN Demo APPEND) | ||
8 | ![]() |
OIF_GRTYP | OIF_GRTYP | NUMC | 3 | 0 | Property Type (IS-Oil MRN Demo APPEND) | ||
9 | ![]() |
OIF_GRQAL | OIF_GRQAL | NUMC | 3 | 0 | Quality of Business Location (IS-Oil MRN Demo APPEND) | ||
10 | ![]() |
OIF_GRFRM | OIF_GRFRM | NUMC | 3 | 0 | Property Type (IS-Oil MRN Demo APPEND) | ||
11 | ![]() |
OIF_GRGZS | OIF_GRGZS | NUMC | 3 | 0 | Overall Condition of Property (IS-Oil MRN Demo APPEND) | ||
12 | ![]() |
OIF_DAKTB | OIF_DAKTB | DATS | 8 | 0 | Date Active in Inventory (IS-Oil MRN Demo APPEND) | ||
13 | ![]() |
0 | 0 | Oil fields OIFSPBL | |||||
14 | ![]() |
OIF_PBLTYP | OIF_PBLTYP | CHAR | 4 | 0 | Business Location Type (IS-Oil MRN) | OIFSPBLT | |
15 | ![]() |
OIF_ADNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address No. in ADRC | OIFSMCADDR | |
16 | ![]() |
OIF_ERDAT | DATS | DATS | 8 | 0 | Date Record Created on (Date) | ||
17 | ![]() |
OIF_ERZEIT | TIME | TIMS | 6 | 0 | Time Record Created at (Time) | ||
18 | ![]() |
OIF_ERNAM | USNAM | CHAR | 12 | 0 | User who Created Record | ||
19 | ![]() |
OIF_AEDAT | DATS | DATS | 8 | 0 | Date Record Changed on (Date) | ||
20 | ![]() |
OIF_AEZEIT | TIME | TIMS | 6 | 0 | Time when Record Was Changed | ||
21 | ![]() |
OIF_AENAM | USNAM | CHAR | 12 | 0 | User who Changed Record | ||
22 | ![]() |
OIF_BLOIND | XFELD | CHAR | 1 | 0 | Block Indicator | ||
23 | ![]() |
OIF_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
24 | ![]() |
OIF_BLCD | OIF_BLCD | CHAR | 2 | 0 | Business Location Blocking Indicator (IS-Oil MRN) | OIFSBLCD | |
25 | ![]() |
J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
26 | ![]() |
0 | 0 | Business location enhancement for OIFSPBL (IS-OIL SSR) | |||||
27 | ![]() |
OIRB_BRAND | OIRB_BRAND | CHAR | 5 | 0 | Location brand | OIRBBRAND | |
28 | ![]() |
OIRB_VAL | OIRB_VAL | CHAR | 2 | 0 | Relative location value | OIRBPBLVAL | |
29 | ![]() |
OIRB_LOCVDIFF | OIRB_LOCVDIFF | CHAR | 2 | 0 | Location value differentiator | OIRBPBLVALD | |
30 | ![]() |
OIRB_LAA | OIRB_LAA | CHAR | 5 | 0 | Location area assignment | OIRBLAA | |
31 | ![]() |
OIRC_KALKS | OIRC_KALKS | CHAR | 1 | 0 | SSR Pricing - Margins procedure assigned to this location | OIRCTVKD | |
32 | ![]() |
OIRA_PCG | OIRA_PCG | CHAR | 10 | 0 | Process control group | OIRAPCG | |
33 | ![]() |
OIRB_AUTGR | CHAR4 | CHAR | 4 | 0 | Authorization group | ||
34 | ![]() |
OIREVALGROUP | OIREVALGROUP | CHAR | 2 | 0 | SSR PC: Upload validation group | OIREVALGP | |
35 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
36 | ![]() |
OIRI_PGRP | OIRI_PGRP | CHAR | 2 | 0 | SSR SD/FI Invoice posting group | ||
37 | ![]() |
0 | 0 | Conversion Group Structure-Field Conversion(IS-OIL, SSR) | |||||
38 | ![]() |
OIRH_CONVGR | CHAR4 | CHAR | 4 | 0 | SSR Interface conversion group definition (IS-Oil, SSR) | OIRHCVGRDEFC | |
39 | ![]() |
OIRH_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system for EDI | TBDLS |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | OIFSPBL | ADDRNUM | ![]() |
![]() |
REF | ||
2 | OIFSPBL | BLCODE | ![]() |
![]() |
REF | ||
3 | OIFSPBL | BRAND | ![]() |
![]() |
REF | ||
4 | OIFSPBL | BUKRS | ![]() |
![]() |
|||
5 | OIFSPBL | CONVGR | ![]() |
![]() |
|||
6 | OIFSPBL | LOCAA | ![]() |
![]() |
|||
7 | OIFSPBL | LOCMP | ![]() |
![]() |
KEY | ||
8 | OIFSPBL | LOCVALUE | ![]() |
![]() |
REF | ||
9 | OIFSPBL | LOCVDIFF | ![]() |
![]() |
REF | ||
10 | OIFSPBL | LOGSYS | ![]() |
![]() |
|||
11 | OIFSPBL | MANDT | ![]() |
![]() |
1 | CN | |
12 | OIFSPBL | PBLTYP | ![]() |
![]() |
REF | ||
13 | OIFSPBL | PCGROUP | ![]() |
![]() |
REF | 1 | CN |
14 | OIFSPBL | VALGP | ![]() |
![]() |
REF |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |