DFS_FE_RELSHP_D

Transparent Table Application Table

I_FRCELMNTORGEXTERNALRELSHPTP I_FRCELMNTORGEXTERNALRELSHPTP

DFS_FE_RELSHP_D is an SAP database table in S/4HANA. I_FRCELMNTORGEXTERNALRELSHPTP I_FRCELMNTORGEXTERNALRELSHPTP. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntOrgExtRelshpDraft view from BASIC Interface view for the External Relationship Draft

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
frcelmntorgconcatenatedid OTJID Obj.type/obj.ID
frcelmntorgrelatedorgid SOBID ID rel.object
frcelmntorgvaldtystartdate BEGDATUM Start date
frcelmntorgvaldtyenddate ENDDATUM End Date
frcelmntorgsubtype SUBTYP Subtype
frcelmntorgplngstatus ISTAT_D Planning status
frcelmntorgdraftuuid SYSUUID_X UUID
forceelementorgid HROBJID Object ID
frcelmntorgplngstatusfoed abap.int1
frcelmntorgplanversion PLVAR Plan version
frcelmntorgtype OTYPE Object type
numberofforceelementorg SEQNR IT record no.
frcelmntorginfotype INFOTYP Infotype
frcelmntorgrelatedorgtype SCLAS Rel.obj.type
frcelmntorgrelshppriority PRIOX Priority
frcelmntorgcnctntdrelshpname abap.char
frcelmntorgrelshpdesc /ISDFPS/RELAT_DESC Relationship
frcelmntorglastchgdbyusername USRNAME User Name
forceelementorgidforedit HROBJID Object ID
frcelmntorgrelatedorgidforedit SOBID ID rel.object
frcelmntorgvaldtystartdatefoed BEGDATUM Start date
frcelmntorgvaldtyenddatefoed ENDDATUM End Date
frcelmntorgplngstatusforedit ISTAT_D Planning status
frcelmntorgsubtypeforedit SUBTYP Subtype
frcelmntorgtechnicalstatusname abap.numc
criticality abap.int1
frcelmntorgname STEXT Name
frcelmntorglanguage LANGU Language
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_FRCELMNTORGEXTERNALRELSHPTP I_FRCELMNTORGEXTERNALRELSHPTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FE_RELSHP_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    FRCELMNTORGCONCATENATEDID,       -- Obj.type/obj.ID [OTJID]
    FRCELMNTORGRELATEDORGID,         -- ID rel.object [SOBID]
    FRCELMNTORGVALDTYSTARTDATE,      -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATE,        -- End Date [ENDDATUM]
    FRCELMNTORGSUBTYPE,              -- Subtype [SUBTYP]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [ISTAT_D]
    FRCELMNTORGDRAFTUUID,            -- UUID [SYSUUID_X]
    FORCEELEMENTORGID,               -- Object ID [HROBJID]
    FRCELMNTORGPLNGSTATUSFOED,       -- abap.int1
    FRCELMNTORGPLANVERSION,          -- Plan version [PLVAR]
    FRCELMNTORGTYPE,                 -- Object type [OTYPE]
    NUMBEROFFORCEELEMENTORG,         -- IT record no. [SEQNR]
    FRCELMNTORGINFOTYPE,             -- Infotype [INFOTYP]
    FRCELMNTORGRELATEDORGTYPE,       -- Rel.obj.type [SCLAS]
    FRCELMNTORGRELSHPPRIORITY,       -- Priority [PRIOX]
    FRCELMNTORGCNCTNTDRELSHPNAME,    -- abap.char
    FRCELMNTORGRELSHPDESC,           -- Relationship [/ISDFPS/RELAT_DESC]
    FRCELMNTORGLASTCHGDBYUSERNAME,   -- User Name [USRNAME]
    FORCEELEMENTORGIDFOREDIT,        -- Object ID [HROBJID]
    FRCELMNTORGRELATEDORGIDFOREDIT,  -- ID rel.object [SOBID]
    FRCELMNTORGVALDTYSTARTDATEFOED,  -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATEFOED,    -- End Date [ENDDATUM]
    FRCELMNTORGPLNGSTATUSFOREDIT,    -- Planning status [ISTAT_D]
    FRCELMNTORGSUBTYPEFOREDIT,       -- Subtype [SUBTYP]
    FRCELMNTORGTECHNICALSTATUSNAME,  -- abap.numc
    CRITICALITY,                     -- abap.int1
    FRCELMNTORGNAME,                 -- Name [STEXT]
    FRCELMNTORGLANGUAGE,             -- Language [LANGU]
    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)
);