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

SAP table OIRBPBLB has 3 primary key fields being MANDT,PBLNR,RNBT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PBLNR Business location identifier (IS-Oil MRN) CHAR 10 0 OIFSPBL OIF_PBLNR
RNBT Business type CHAR 4 0 OIRARNBT OIRA_RNBT
BRAND Location brand CHAR 5 0 OIRBBRAND OIRB_BRAND
LOCVALUE Relative location value CHAR 2 0 OIRBPBLVAL OIRB_VAL
LOCVDIFF Location value differentiator CHAR 2 0 OIRBPBLVALD OIRB_LOCVDIFF
STD_STYP Standard service type CHAR 4 0 OIRASTYP OIRA_STD_STYP
LOCAA Location area assignment CHAR 5 0 OIRBLAA OIRB_LAA
PR_AUTGR SSR Pricing - Authorization group CHAR 4 0 OIRC_PR_AUTGR
LPRCLU SSR Pricing - Location price cluster CHAR 10 0 OIRCLPC OIRC_LPRCLU
SFDIFFGR SSR Pricing - service type difference price group CHAR 10 0 OIRCSDPG OIRC_SFDIFFGR
MDIFFGR SSR Pricing - material difference price group CHAR 10 0 OIRCMDPG OIRC_MDIFFGR
F_PR SSR - processing profile ID CHAR 2 0 OIRC_FUELS_PR OIRC_F_PR
INV_BLOCK SSR Meters - invoicing block indicator CHAR 1 0 OIRC_IND_IBL
Invoicing not blocked
X Invoicing blocked
BL_DATE_FROM SSR Meters - Invoicing block date from DATS 8 0 OIRC_IB_D_FROM
BL_TIME_FROM SSR Meters - Invoicing block time from TIMS 6 0 OIRC_IB_T_FROM
BL_DATE_TO SSR Meters - Invoicing block date to DATS 8 0 OIRC_IB_D_TO
BL_TIME_TO SSR Meters - Invoicing block time to TIMS 6 0 OIRC_IB_T_TO
ACC_GROUP SSR Meters - meter access profile ID CHAR 2 0 OIRC_ACCGR OIRC_ACC_GR
MATHANDGRP Material handling group (IS-Oil SSR) CHAR 2 0 OIRAMATHANDGRPD OIRA_MATHANDGRP
CONVGR SSR Interface conversion group definition (IS-Oil, SSR) CHAR 4 0 OIRHCVGRDEFC OIRH_CONVGR
LOGSYS Logical system for EDI CHAR 10 0 TBDLS OIRH_LOGSYS
ERDAT Date Record Created on (Date) DATS 8 0 OIF_ERDAT
ERZEIT Time Record Created at (Time) TIMS 6 0 OIF_ERZEIT
ERNAM User who Created Record CHAR 12 0 OIF_ERNAM
AEDAT Date Record Changed on (Date) DATS 8 0 OIF_AEDAT
AEZEIT Time when Record Was Changed TIMS 6 0 OIF_AEZEIT
AENAM User who Changed Record CHAR 12 0 OIF_AENAM
BLOIND Block Indicator CHAR 1 0 OIF_BLOIND
DELIND Deletion indicator CHAR 1 0 OIF_DELIND

OIRBPBLB foreign key relationships

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