OIRBLAA

Transparent Table Customizing Table
7 Fields 1 CDS Views

Location area assignment (IS-OIL SSR)

OIRBLAA is an SAP database table in S/4HANA. Location area assignment (IS-OIL SSR). It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocationAreaAssignmentVH view_entity from BASIC Location Area Assignment

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rnbt OIRA_RNBT Business type
KEY locaa OIRB_LAA Loc.a.assign.
KEY locaactry LAND1 Country/Reg.
locreg OIRB_REGION Loc. Region
locarea OIRB_AREA Location area
locsarea OIRB_SAREA Loc. sub area

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.

-- Location area assignment (IS-OIL SSR)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIRBLAA (
    MANDT,      -- Client [MANDT]
    RNBT,       -- Business type [OIRA_RNBT]
    LOCAA,      -- Loc.a.assign. [OIRB_LAA]
    LOCAACTRY,  -- Country/Reg. [LAND1]
    LOCREG,     -- Loc. Region [OIRB_REGION]
    LOCAREA,    -- Location area [OIRB_AREA]
    LOCSAREA,   -- Loc. sub area [OIRB_SAREA]
    PRIMARY KEY (MANDT, RNBT, LOCAA, LOCAACTRY)
);

Learn More