SAP Table OIRARNBT (Retail Network Business Types)
SAP table OIRARNBT has 2 primary key fields being MANDT,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
Client
CLNT
3
0
T000
MANDT
Business type
CHAR
4
0
OIRA_RNBT
KALVG
SSR Pricing - Margins procedure assigned to business type
CHAR
1
0
OIRCTVKV
OIRC_KALVG
APPBK
Application flag: Business type relates to bulk business
CHAR
1
0
OIRA_APPBK
APPMC
Application flag: Business type relates to merchandising bus
CHAR
1
0
OIRA_APPMC
APPCW
Application flag: Business type relates to car wash business
CHAR
1
0
OIRA_APPCW
APPNN
Application flag : Business type not related to a business
CHAR
1
0
OIRA_APPNN
ICONNAME
Icon name for retail network business type
CHAR
25
0
OIRA_RNBTICON
RFCDEST_REM
RFC dest. (Retail system) with remote user
CHAR
32
0
RFCDES
OIRA_RFCDEST_NO_USR
RFCDEST
RFC destination (Retail system)
CHAR
32
0
RFCDES
OIRA_RFCDEST
URL
IS-Oil SSR - Store Workbench WebGate URL
CHAR
132
0
OIRH_WGURL
USE_HR_RETAIL
Login for system; "URL" is (x = EQ, ' ' = NE) as in oil
CHAR
1
0
OIRH_LOG
ORGSTR_CHECK
Organization structure check (1=No, 2=Oil, 3=Retail)
CHAR
1
0
OIRB_ORGSTR
Possible values
1
No check for site
2
Check site within Oil system (Site in Retail = Plant in Oil)
3
Check site within Retail system
EXT_PRIC_TOOL
External Price Optimizer Active
CHAR
1
0
OIRB_EXTPRICETOOL
OIRARNBT foreign key relationships
Table
Field
Check Table
Check Field
0 OIRARNBT
KALVG
OIRCTVKV SSR Pricing - Business type Margin Procedure
MANDT
1 OIRARNBT
MANDT
T000 Clients
MANDT