V_OIJRRA

23 Fields 3 CDS Views

Generated Table for View

V_OIJRRA is an SAP database table in S/4HANA. Generated Table for View. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_VisualLocations view left_outer COMPOSITE Location Master Data
I_VisualNominations view left_outer COMPOSITE Visual Nominations
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization

Fields (23)

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
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_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]
    ERDAT,      -- Created On [ERDAT]
    ERZEIT,     -- Created [OI0_ERTIM]
    ERNAM,      -- Created By [ERNAM]
    AEDAT,      -- Changed On [AEDAT]
    AEZEIT,     -- Changed [OI0_AETIM]
    AENAM,      -- Changed By [AENAM]
    BLOIND,     -- Blocking ind. [OIJ_BLOIND]
    DELIND,     -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,  -- Flag to Select Tkt [OIJ_TKTSELECT]
    PRIMARY KEY (MANDT, KUNNR, LIFNR, WERK, LGORT, RTYPE, RDIFF)
);

Learn More