OIFOCOAS

Transparent Table Application Table
12 Fields 1 CDS Views

Object links - CO order (IS-Oil MRN)

OIFOCOAS is an SAP database table in S/4HANA. Object links - CO order (IS-Oil MRN). It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_LocationWorkOrder view_entity from BASIC Business Location Work Order

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pblnr OIF_PBLNR Location ID
KEY objpos OIF_OBJPOS Object counter
erdat OIF_ERDAT Created on
erzeit OIF_ERZEIT Created at
ernam OIF_ERNAM by
aedat OIF_AEDAT Changed on
aezeit OIF_AEZEIT Changed at
aenam OIF_AENAM Changed by
bloind OIF_BLOIND Blocked
delind OIF_DELIND Will be Deleted
aufnr AUFNR Order

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.

-- Object links - CO order (IS-Oil MRN)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIFOCOAS (
    MANDT,   -- Client [MANDT]
    PBLNR,   -- Location ID [OIF_PBLNR]
    OBJPOS,  -- Object counter [OIF_OBJPOS]
    ERDAT,   -- Created on [OIF_ERDAT]
    ERZEIT,  -- Created at [OIF_ERZEIT]
    ERNAM,   -- by [OIF_ERNAM]
    AEDAT,   -- Changed on [OIF_AEDAT]
    AEZEIT,  -- Changed at [OIF_AEZEIT]
    AENAM,   -- Changed by [OIF_AENAM]
    BLOIND,  -- Blocked [OIF_BLOIND]
    DELIND,  -- Will be Deleted [OIF_DELIND]
    AUFNR,   -- Order [AUFNR]
    PRIMARY KEY (MANDT, PBLNR, OBJPOS)
);

Learn More