OIFOCEPC_D

Transparent Table Application Table
20 Fields 1 CDS Views

Draft table for entity R_OIL_BUSINESSLOCPROFITCTRTP

OIFOCEPC_D is an SAP database table in S/4HANA. Draft table for entity R_OIL_BUSINESSLOCPROFITCTRTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_OIL_LocationProfitCenterDrft view_entity from BASIC Location Profit Center - Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesslocationidentifier OIF_PBLNR Location ID
KEY objectsequence OIF_OBJPOS Object counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
creationdate OIF_ERDAT Created on
creationtime OIF_ERZEIT Created at
createdbyuser OIF_ERNAM by
lastchangedate OIF_AEDAT Changed on
lastchangetime OIF_AEZEIT Changed at
lastchangedbyuser OIF_AENAM Changed by
controllingarea KOKRS CO Area
profitcenter PRCTR Profit Center
profitcentervalidityenddate DATBI Valid To
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_OIL_BUSINESSLOCPROFITCTRTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIFOCEPC_D (
    MANDT,                          -- Client [MANDT]
    BUSINESSLOCATIONIDENTIFIER,     -- Location ID [OIF_PBLNR]
    OBJECTSEQUENCE,                 -- Object counter [OIF_OBJPOS]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    CREATIONDATE,                   -- Created on [OIF_ERDAT]
    CREATIONTIME,                   -- Created at [OIF_ERZEIT]
    CREATEDBYUSER,                  -- by [OIF_ERNAM]
    LASTCHANGEDATE,                 -- Changed on [OIF_AEDAT]
    LASTCHANGETIME,                 -- Changed at [OIF_AEZEIT]
    LASTCHANGEDBYUSER,              -- Changed by [OIF_AENAM]
    CONTROLLINGAREA,                -- CO Area [KOKRS]
    PROFITCENTER,                   -- Profit Center [PRCTR]
    PROFITCENTERVALIDITYENDDATE,    -- Valid To [DATBI]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BUSINESSLOCATIONIDENTIFIER, OBJECTSEQUENCE, DRAFTUUID)
);

Learn More