SAP Table OIFSPBL
Physischer Standort - Stammdaten
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table OIFSPBL (Physischer Standort - Stammdaten) is a standard table in SAP ERP. It belongs to the package OILF.
Technical Information
| Table | OIFSPBL |
| Short Text | Physischer Standort - Stammdaten |
| Package | OILF |
| Table Type | Transparent Table |
Fields for Table OIFSPBL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| PBLNR | ✔ | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | |
| NAME1 | Internal name field | OIF_PBNAM1 | CHAR | 35 | ||
| A1_SGRNDB | Land Register Number (IS-Oil MRN Demo APPEND) | OIF_SGRNDB | NUMC | 8 | ||
| A1_UTILTP | Usage Type of Property (IS-Oil MRN Demo APPEND) | OIF_UTILTP | CHAR | 2 | ||
| A1_GRTYP | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRTYP | NUMC | 3 | ||
| A1_GRQAL | Quality of Business Location (IS-Oil MRN Demo APPEND) | OIF_GRQAL | NUMC | 3 | ||
| A1_GRFRM | Property Type (IS-Oil MRN Demo APPEND) | OIF_GRFRM | NUMC | 3 | ||
| A1_GRGZS | Overall Condition of Property (IS-Oil MRN Demo APPEND) | OIF_GRGZS | NUMC | 3 | ||
| A1_DAKTB | Date Active in Inventory (IS-Oil MRN Demo APPEND) | OIF_DAKTB | DATS | 8 | ||
| PBLTYP | Business Location Type (IS-Oil MRN) | OIF_PBLTYP | CHAR | 4 | OIFSPBLT | |
| ADDRNUM | Address No. in ADRC | OIF_ADNUM | CHAR | 10 | OIFSMCADDR | |
| ERDAT | Date Record Created on (Date) | OIF_ERDAT | DATS | 8 | ||
| ERZEIT | Time Record Created at (Time) | OIF_ERZEIT | TIMS | 6 | ||
| ERNAM | User who Created Record | OIF_ERNAM | CHAR | 12 | ||
| AEDAT | Date Record Changed on (Date) | OIF_AEDAT | DATS | 8 | ||
| AEZEIT | Time when Record Was Changed | OIF_AEZEIT | TIMS | 6 | ||
| AENAM | User who Changed Record | OIF_AENAM | CHAR | 12 | ||
| BLOIND | Block Indicator | OIF_BLOIND | CHAR | 1 | ||
| DELIND | Deletion indicator | OIF_DELIND | CHAR | 1 | ||
| BLCODE | Business Location Blocking Indicator (IS-Oil MRN) | OIF_BLCD | CHAR | 2 | OIFSBLCD | |
| OBJNR | Object number | J_OBJNR | CHAR | 22 | * | |
| BRAND | Location brand | OIRB_BRAND | CHAR | 5 | OIRBBRAND | |
| LOCVALUE | Relative location value | OIRB_VAL | CHAR | 2 | OIRBPBLVAL | |
| LOCVDIFF | Location value differentiator | OIRB_LOCVDIFF | CHAR | 2 | OIRBPBLVALD | |
| LOCAA | Location area assignment | OIRB_LAA | CHAR | 5 | OIRBLAA | |
| LOCMP | SSR Pricing - Margins procedure assigned to this location | OIRC_KALKS | CHAR | 1 | OIRCTVKD | |
| PCGROUP | Process control group | OIRA_PCG | CHAR | 10 | OIRAPCG | |
| AUTGR | Authorization group | OIRB_AUTGR | CHAR | 4 | ||
| VALGP | SSR PC: Upload validation group | OIREVALGROUP | CHAR | 2 | OIREVALGP | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
| OIRIPGRP | SSR SD/FI Invoice posting group | OIRI_PGRP | CHAR | 2 | ||
| CONVGR | SSR Interface conversion group definition (IS-Oil, SSR) | OIRH_CONVGR | CHAR | 4 | OIRHCVGRDEFC | |
| LOGSYS | Logical system for EDI | OIRH_LOGSYS | CHAR | 10 | TBDLS | |
| TPLST | Transportation planning point | TPLST | CHAR | 4 | TTDS | |
| TPLST_TXT | Description of transportation planning point | TPLST_TXT | CHAR | 20 | ||
| LONGITUDE | Geo location longitude | GEOLON | DEC | 15 | ||
| LATITUDE | Geo location latitude | GEOLAT | DEC | 15 | ||
| TIME_TO_ADD | Duration to Add at Base Location (in hours:minutes) | OIO_TIME_TO_ADD | DEC | 11 | ||
| AVRG_STAYT | Duration of Stay at Remote Location (in hours:minutes) | OIO_AVRG_STAYT | DEC | 11 | ||
| KNOTE | Transportation Connection Points | KNOTE | CHAR | 10 | TVKN | |
| KNOTE_BEZ | Node name | KNOTE_BEZ | CHAR | 30 | ||
| ROUTE | Shipment route | ROUTR | CHAR | 6 | TVRO | |
| TXROU | Description of Route | ROUTBEZ | CHAR | 40 | ||
| R_CON_POINT | Radiobutton for connection point in RLM VMIS location | OIO_VMIS_C | CHAR | 1 | ||
| R_ROUTE | Radiobutton for shipment route in RLM VMIS location | OIO_VMIS_R | CHAR | 1 | ||
| XCOOR | X coordinate | OIRB_COOR_X | FLTP | 16 | ||
| YCOOR | Y coordinate | OIRB_COOR_Y | FLTP | 16 |