DFS_FETOOPEXER_D

Transparent Table Application Table
34 Fields 1 CDS Views

I_FRCELMNTTOOPEXERRELSHPTP I_FRCELMNTTOOPEXERRELSHPTP

DFS_FETOOPEXER_D is an SAP database table in S/4HANA. I_FRCELMNTTOOPEXERRELSHPTP I_FRCELMNTTOOPEXERRELSHPTP. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntToOpExerRelshpDrft view from BASIC Interface view for Operation/Exercise relshp with draft

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
forceelementorgid HROBJID Object ID
frcelmntorgrelatedorgid SOBID ID rel.object
frcelmntorgplngstatus ISTAT_D Planning status
frcelmntorgvaldtystartdate BEGDATUM Start date
frcelmntorgvaldtyenddate ENDDATUM End Date
frcelmntorgsubtype SUBTYP Subtype
frcelmntorgplanversion PLVAR Plan version
frcelmntorgtype OTYPE Object type
frcelmntorgvariationid VARYF Variation field
numberofforceelementorg SEQNR IT record no.
frcelmntorginfotype INFOTYP Infotype
frcelmntorgconcatenatedid OTJID Obj.type/obj.ID
frcelmntorgrelatedorgtype SCLAS Rel.obj.type
frcelmntorgrelshppriority PRIOX Priority
frcelmntorgopexerciseid /ISDFPS/OPERATION_ID Op./Exercise ID
frcelmntorgrotationkey /ISDFPS/CON_ID Contingent Key
frcelmntorgforceproviderid HROBJID Object ID
frcelmntorginitialmatlsuplrid HROBJID Object ID
frcelmntorginitialperssuplrid HROBJID Object ID
frcelmntorgcnctntdrelshpname abap.char
frcelmntorgrelshpdesc /ISDFPS/RELAT_DESC Relationship
forceelementorgidfoed HROBJID Object ID
frcelmntorgrelatedorgidfoed SOBID ID rel.object
frcelmntorgvaldtystartdatefoed BEGDATUM Start date
frcelmntorgvaldtyenddatefoed ENDDATUM End Date
frcelmntorgplngstscritlty abap.int1
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation 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.

-- I_FRCELMNTTOOPEXERRELSHPTP I_FRCELMNTTOOPEXERRELSHPTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FETOOPEXER_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    FORCEELEMENTORGID,               -- Object ID [HROBJID]
    FRCELMNTORGRELATEDORGID,         -- ID rel.object [SOBID]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [ISTAT_D]
    FRCELMNTORGVALDTYSTARTDATE,      -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATE,        -- End Date [ENDDATUM]
    FRCELMNTORGSUBTYPE,              -- Subtype [SUBTYP]
    FRCELMNTORGPLANVERSION,          -- Plan version [PLVAR]
    FRCELMNTORGTYPE,                 -- Object type [OTYPE]
    FRCELMNTORGVARIATIONID,          -- Variation field [VARYF]
    NUMBEROFFORCEELEMENTORG,         -- IT record no. [SEQNR]
    FRCELMNTORGINFOTYPE,             -- Infotype [INFOTYP]
    FRCELMNTORGCONCATENATEDID,       -- Obj.type/obj.ID [OTJID]
    FRCELMNTORGRELATEDORGTYPE,       -- Rel.obj.type [SCLAS]
    FRCELMNTORGRELSHPPRIORITY,       -- Priority [PRIOX]
    FRCELMNTORGOPEXERCISEID,         -- Op./Exercise ID [/ISDFPS/OPERATION_ID]
    FRCELMNTORGROTATIONKEY,          -- Contingent Key [/ISDFPS/CON_ID]
    FRCELMNTORGFORCEPROVIDERID,      -- Object ID [HROBJID]
    FRCELMNTORGINITIALMATLSUPLRID,   -- Object ID [HROBJID]
    FRCELMNTORGINITIALPERSSUPLRID,   -- Object ID [HROBJID]
    FRCELMNTORGCNCTNTDRELSHPNAME,    -- abap.char
    FRCELMNTORGRELSHPDESC,           -- Relationship [/ISDFPS/RELAT_DESC]
    FORCEELEMENTORGIDFOED,           -- Object ID [HROBJID]
    FRCELMNTORGRELATEDORGIDFOED,     -- ID rel.object [SOBID]
    FRCELMNTORGVALDTYSTARTDATEFOED,  -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATEFOED,    -- End Date [ENDDATUM]
    FRCELMNTORGPLNGSTSCRITLTY,       -- abap.int1
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More