SAP Table OIRBPBLB

Business location at business type level (IS-OIL SSR)

OIRBPBLB (Business location at business type level (IS-OIL SSR)) 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 OIRBPBLB to other SAP tables.

OIRBPBLB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR OIFSPBL CHAR 10 0
RNBT Business type OIRA_RNBT OIRARNBT CHAR 4 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
STD_STYP Standard service type OIRA_STD_STYP OIRASTYP CHAR 4 0
LOCAA Location area assignment OIRB_LAA OIRBLAA CHAR 5 0
PR_AUTGR SSR Pricing - Authorization group OIRC_PR_AUTGR CHAR 4 0
LPRCLU SSR Pricing - Location price cluster OIRC_LPRCLU OIRCLPC CHAR 10 0
SFDIFFGR SSR Pricing - service type difference price group OIRC_SFDIFFGR OIRCSDPG CHAR 10 0
MDIFFGR SSR Pricing - material difference price group OIRC_MDIFFGR OIRCMDPG CHAR 10 0
F_PR SSR - processing profile ID OIRC_F_PR OIRC_FUELS_PR CHAR 2 0
INV_BLOCK SSR Meters - invoicing block indicator OIRC_IND_IBL CHAR 1 0
X Invoicing blocked
NULL Invoicing not blocked
BL_DATE_FROM SSR Meters - Invoicing block date from OIRC_IB_D_FROM DATS 8 0
BL_TIME_FROM SSR Meters - Invoicing block time from OIRC_IB_T_FROM TIMS 6 0
BL_DATE_TO SSR Meters - Invoicing block date to OIRC_IB_D_TO DATS 8 0
BL_TIME_TO SSR Meters - Invoicing block time to OIRC_IB_T_TO TIMS 6 0
ACC_GROUP SSR Meters - meter access profile ID OIRC_ACC_GR OIRC_ACCGR CHAR 2 0
MATHANDGRP Material handling group (IS-Oil SSR) OIRA_MATHANDGRP OIRAMATHANDGRPD 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
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
X Yes
NULL No
DELIND Deletion indicator OIF_DELIND CHAR 1 0
X Yes
NULL No
A1_SHELFSIZE Shelf size OIRB_SHELFSIZE QUAN 13 3
A1_SHELFSIZEUOM Business location unit of measure (general) OIRB_UOM T006 UNIT 3 0
A1_REFRIGAREA Business location shop - refrigeration area OIRB_REFRIGAREA QUAN 13 3
A1_REFRIGAREAUOM Business location unit of measure (general) OIRB_UOM T006 UNIT 3 0
A1_PUMPS Business location fuels: number of pumps OIRB_PUMPS NUMC 2 0
A1_AREASIZE Business location area per business type OIRB_AREASIZE QUAN 13 3
A1_AREASIZEUOM Business location unit of measure (general) OIRB_UOM T006 UNIT 3 0

OIRBPBLB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIRBPBLB A1_AREASIZEUOM * T006 Units of Measurement MANDT
OIRBPBLB A1_AREASIZEUOM OIRBPBLB A1_AREASIZEUOM T006 Units of Measurement MSEHI
OIRBPBLB A1_REFRIGAREAUOM * T006 Units of Measurement MANDT
OIRBPBLB A1_REFRIGAREAUOM OIRBPBLB A1_REFRIGAREAUOM T006 Units of Measurement MSEHI
OIRBPBLB A1_SHELFSIZEUOM * T006 Units of Measurement MANDT
OIRBPBLB A1_SHELFSIZEUOM OIRBPBLB A1_SHELFSIZEUOM T006 Units of Measurement MSEHI
OIRBPBLB ACC_GROUP OIRBPBLB MANDT OIRC_ACCGR SSR Meters - Meter access profile MANDT
OIRBPBLB ACC_GROUP OIRBPBLB ACC_GROUP OIRC_ACCGR SSR Meters - Meter access profile ACCGR
OIRBPBLB BRAND OIRBPBLB MANDT OIRBBRAND Location Brand (IS-OIL SSR) MANDT
OIRBPBLB BRAND OIRBPBLB BRAND OIRBBRAND Location Brand (IS-OIL SSR) BRANDID
OIRBPBLB CONVGR * OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) MANDT
OIRBPBLB CONVGR OIRBPBLB CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) CONVGR
OIRBPBLB F_PR OIRBPBLB MANDT OIRC_FUELS_PR SSR - Processing profile MANDT
OIRBPBLB F_PR OIRBPBLB F_PR OIRC_FUELS_PR SSR - Processing profile F_PR
OIRBPBLB LOCAA OIRBPBLB LOCAA OIRBLAA Location area assignment (IS-OIL SSR) LOCAA
OIRBPBLB LOCAA * OIRBLAA Location area assignment (IS-OIL SSR) LOCAACTRY
OIRBPBLB LOCAA OIRBPBLB MANDT OIRBLAA Location area assignment (IS-OIL SSR) MANDT
OIRBPBLB LOCAA OIRBPBLB RNBT OIRBLAA Location area assignment (IS-OIL SSR) RNBT
OIRBPBLB LOCVALUE OIRBPBLB MANDT OIRBPBLVAL Relative Location Value (IS-OIL SSR) MANDT
OIRBPBLB LOCVALUE OIRBPBLB LOCVALUE OIRBPBLVAL Relative Location Value (IS-OIL SSR) LOCVALUE
OIRBPBLB LOCVDIFF OIRBPBLB LOCVDIFF OIRBPBLVALD Location Value differentiator (IS-OIL SSR) LOCVDIFF
OIRBPBLB LOCVDIFF OIRBPBLB MANDT OIRBPBLVALD Location Value differentiator (IS-OIL SSR) MANDT
OIRBPBLB LOGSYS OIRBPBLB LOGSYS TBDLS Logical system LOGSYS
OIRBPBLB LPRCLU OIRBPBLB MANDT OIRCLPC SSR Pricing - Location price cluster MANDT
OIRBPBLB LPRCLU OIRBPBLB LPRCLU OIRCLPC SSR Pricing - Location price cluster LPRCLU
OIRBPBLB MANDT OIRBPBLB MANDT T000 Clients MANDT
OIRBPBLB MATHANDGRP OIRBPBLB MANDT OIRAMATHANDGRPD Material handling group definition (IS-Oil SSR) MANDT
OIRBPBLB MATHANDGRP OIRBPBLB MATHANDGRP OIRAMATHANDGRPD Material handling group definition (IS-Oil SSR) MATHANDGRP
OIRBPBLB MATHANDGRP OIRBPBLB RNBT OIRAMATHANDGRPD Material handling group definition (IS-Oil SSR) RNBT
OIRBPBLB MDIFFGR OIRBPBLB MANDT OIRCMDPG SSR Pricing - Material difference price group MANDT
OIRBPBLB MDIFFGR OIRBPBLB MDIFFGR OIRCMDPG SSR Pricing - Material difference price group MDIFFGR
OIRBPBLB PBLNR OIRBPBLB MANDT OIFSPBL Physical Location - Master Data MANDT
OIRBPBLB PBLNR OIRBPBLB PBLNR OIFSPBL Physical Location - Master Data PBLNR
OIRBPBLB RNBT OIRBPBLB MANDT OIRARNBT Retail Network Business Types MANDT
OIRBPBLB RNBT OIRBPBLB RNBT OIRARNBT Retail Network Business Types RNBT
OIRBPBLB SFDIFFGR OIRBPBLB SFDIFFGR OIRCSDPG SSR Pricing - Service type difference price group SFDIFFGR
OIRBPBLB SFDIFFGR OIRBPBLB MANDT OIRCSDPG SSR Pricing - Service type difference price group MANDT
OIRBPBLB STD_STYP OIRBPBLB STD_STYP OIRASTYP Service type (IS-OIL SSR) STYP
OIRBPBLB STD_STYP OIRBPBLB MANDT OIRASTYP Service type (IS-OIL SSR) MANDT