Menu

SAP Table OIFSPBL

Physischer Standort - Stammdaten

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