OIRARNBT

Transparent Table Customizing Table
14 Fields 2 CDS Views

Retail Network Business Types

OIRARNBT is an SAP database table in S/4HANA. Retail Network Business Types. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_NominationBusinessTypeVH view from BASIC Nomination Business Type
I_OIL_BusinessTypeVH view_entity from BASIC Retail Network Business Types

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rnbt OIRA_RNBT Business type
kalvg OIRC_KALVG BT.margin proc.
appbk OIRA_APPBK Bulk applic.
appmc OIRA_APPMC Merchand. app.
appcw OIRA_APPCW Car wash app.
appnn OIRA_APPNN No applic.
iconname OIRA_RNBTICON Icon name
rfcdest_rem OIRA_RFCDEST_NO_USR Destination
rfcdest OIRA_RFCDEST Destination
url OIRH_WGURL URL
use_hr_retail OIRH_LOG Log-on info.
orgstr_check OIRB_ORGSTR Org. str.
ext_pric_tool OIRB_EXTPRICETOOL Ext.Price Optim

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Retail Network Business Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIRARNBT (
    MANDT,          -- Client [MANDT]
    RNBT,           -- Business type [OIRA_RNBT]
    KALVG,          -- BT.margin proc. [OIRC_KALVG]
    APPBK,          -- Bulk applic. [OIRA_APPBK]
    APPMC,          -- Merchand. app. [OIRA_APPMC]
    APPCW,          -- Car wash app. [OIRA_APPCW]
    APPNN,          -- No applic. [OIRA_APPNN]
    ICONNAME,       -- Icon name [OIRA_RNBTICON]
    RFCDEST_REM,    -- Destination [OIRA_RFCDEST_NO_USR]
    RFCDEST,        -- Destination [OIRA_RFCDEST]
    URL,            -- URL [OIRH_WGURL]
    USE_HR_RETAIL,  -- Log-on info. [OIRH_LOG]
    ORGSTR_CHECK,   -- Org. str. [OIRB_ORGSTR]
    EXT_PRIC_TOOL,  -- Ext.Price Optim [OIRB_EXTPRICETOOL]
    PRIMARY KEY (MANDT, RNBT)
);

Learn More