OIFSPBL

Physical Location - Master Data

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table OIFSPBL.

SAP table OIFSPBL has 2 primary key fields: MANDT,PBLNR.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

OIFSPBL fields.

27 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key PBLNR Business location identifier (IS-Oil MRN)CHAR100 OIF_PBLNR
NAME1 Internal name fieldCHAR350 OIF_PBNAM1
PBLTYP Business Location Type (IS-Oil MRN)CHAR40 OIFSPBLT OIF_PBLTYP
ADDRNUM Address No. in ADRCCHAR100 OIFSMCADDR OIF_ADNUM
ERDAT Date Record Created on (Date)DATS80 OIF_ERDAT
ERZEIT Time Record Created at (Time)TIMS60 OIF_ERZEIT
ERNAM User who Created RecordCHAR120 OIF_ERNAM
AEDAT Date Record Changed on (Date)DATS80 OIF_AEDAT
AEZEIT Time when Record Was ChangedTIMS60 OIF_AEZEIT
AENAM User who Changed RecordCHAR120 OIF_AENAM
BLOIND Block IndicatorCHAR10 OIF_BLOIND
DELIND Deletion indicatorCHAR10 OIF_DELIND
BLCODE Business Location Blocking Indicator (IS-Oil MRN)CHAR20 OIFSBLCD OIF_BLCD
OBJNR Object numberCHAR220 * J_OBJNR
BRAND Location brandCHAR50 OIRBBRAND OIRB_BRAND
LOCVALUE Relative location valueCHAR20 OIRBPBLVAL OIRB_VAL
LOCVDIFF Location value differentiatorCHAR20 OIRBPBLVALD OIRB_LOCVDIFF
LOCAA Location area assignmentCHAR50 OIRBLAA OIRB_LAA
LOCMP SSR Pricing - Margins procedure assigned to this locationCHAR10 OIRCTVKD OIRC_KALKS
PCGROUP Process control groupCHAR100 OIRAPCG OIRA_PCG
AUTGR Authorization groupCHAR40 OIRB_AUTGR
VALGP SSR PC: Upload validation groupCHAR20 OIREVALGP OIREVALGROUP
BUKRS Company CodeCHAR40 T001 BUKRS
OIRIPGRP SSR SD/FI Invoice posting groupCHAR20 OIRI_PGRP
CONVGR SSR Interface conversion group definition (IS-Oil, SSR)CHAR40 OIRHCVGRDEFC OIRH_CONVGR
LOGSYS Logical system for EDICHAR100 TBDLS OIRH_LOGSYS

OIFSPBL relationships.

23 relationships
TableFieldCheck tableDescriptionCheck field
OIFSPBLADDRNUMOIFSMCADDRLink Table Between OIFSPBL and ADRC for MatchcodeMANDT
OIFSPBLADDRNUMOIFSMCADDRLink Table Between OIFSPBL and ADRC for MatchcodePBLNR
OIFSPBLBLCODEOIFSBLCDBlocking Indicator for Business LocationsMANDT
OIFSPBLBLCODEOIFSBLCDBlocking Indicator for Business LocationsBLCODE
OIFSPBLBRANDOIRBBRANDLocation Brand (IS-OIL SSR)MANDT
OIFSPBLBUKRST001Company CodesBUKRS
OIFSPBLCONVGROIRHCVGRDEFCConversion Group Definitions(IS-Oil, SSR)MANDT
OIFSPBLCONVGROIRHCVGRDEFCConversion Group Definitions(IS-Oil, SSR)CONVGR
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)MANDT
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)RNBT
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)LOCAACTRY
OIFSPBLLOCMPOIRCTVKDSSR Pricing - Location Margin ProcedureMANDT
OIFSPBLLOCVALUEOIRBPBLVALRelative Location Value (IS-OIL SSR)MANDT
OIFSPBLLOCVALUEOIRBPBLVALRelative Location Value (IS-OIL SSR)LOCVALUE
OIFSPBLLOCVDIFFOIRBPBLVALDLocation Value differentiator (IS-OIL SSR)MANDT
OIFSPBLLOCVDIFFOIRBPBLVALDLocation Value differentiator (IS-OIL SSR)LOCVDIFF
OIFSPBLLOGSYSTBDLSLogical systemLOGSYS
OIFSPBLMANDTT000ClientsMANDT
OIFSPBLPBLTYPOIFSPBLTPhysical Business Location TypeMANDT
OIFSPBLPBLTYPOIFSPBLTPhysical Business Location TypePBLTYP
OIFSPBLPCGROUPOIRAPCGProcess Control Group (IS-OIL SSR)PCGROUP
OIFSPBLVALGPOIREVALGPSSR PC: Upload Validation GroupMANDT
OIFSPBLVALGPOIREVALGPSSR PC: Upload Validation GroupVALGP