OIJRRA

Transparent Table Application Table
14 Fields 4 CDS Views

OIL-TSW: Partner roles

OIJRRA is an SAP database table in S/4HANA. OIL-TSW: Partner roles. It contains 14 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/dmbe/c_CrossStrategyLocation view inner Cross Strategy Location Filter
/dmbe/I_Oil_Partner_Roles view from OIL-TSW: Partner roles
I_ACMPlantSearchVH view inner BASIC Plant Search Help
I_LocationPartnerPlant view from BASIC TSW Location Partner Plant

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kunnr kunnr Customer
KEY lifnr lifnr Supplier
KEY werk werks_d Plant
KEY lgort lgort_d Location
KEY rtype oij_rtype Role type
KEY rdiff oij_rdiff Role different.
rpart oij_rpart Role part. type
cparid oij_partnr Loc.partner
parnm oij_parnm Common partner
tsyst oij_tsyst Trans system
locid oij_locid Location ID
ruleid oij_rule Tick.nr.rule
tsparid oij_tsparid Pipe prtnr.code

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.

-- OIL-TSW: Partner roles
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJRRA (
    MANDT,    -- Client [mandt]
    KUNNR,    -- Customer [kunnr]
    LIFNR,    -- Supplier [lifnr]
    WERK,     -- Plant [werks_d]
    LGORT,    -- Location [lgort_d]
    RTYPE,    -- Role type [oij_rtype]
    RDIFF,    -- Role different. [oij_rdiff]
    RPART,    -- Role part. type [oij_rpart]
    CPARID,   -- Loc.partner [oij_partnr]
    PARNM,    -- Common partner [oij_parnm]
    TSYST,    -- Trans system [oij_tsyst]
    LOCID,    -- Location ID [oij_locid]
    RULEID,   -- Tick.nr.rule [oij_rule]
    TSPARID,  -- Pipe prtnr.code [oij_tsparid]
    PRIMARY KEY (MANDT, KUNNR, LIFNR, WERK, LGORT, RTYPE, RDIFF)
);

Learn More