DFS_MC_FE_RELSHP

Transparent Table Application Table
35 Fields 1 CDS Views

Defense Model Force Element Relationship

DFS_MC_FE_RELSHP is an SAP database table in S/4HANA. Defense Model Force Element Relationship. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DfsModelFrcElmntRelshpBasic view from BASIC Basic View For Defense Model Force Element Relationship

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dfsmodelfrcelmntorgrelshpuuid dfs_model_frcrel_uuid Dfs Mdl Frc Rel UUID
dfsmodelfrcelmntorguuid dfs_model_frcelmnt_uuid Dfs Mdl Frc Elm UUID
defensemodeluuid dfs_model_uuid Model UUID
forceelementorgid hrobjid Object ID
frcelmntorgvaldtystartdate begdatum Start date
frcelmntorgvaldtyenddate enddatum End Date
dfsmodelreltdfrcelmntorguuid dfsmod_reltduuid Related UUID
frcelmntorgrelatedorgid sobid ID rel.object
frcelmntorgconcatenatedid otjid Obj.type/obj.ID
frcelmntorgplngstatus istat_d Planning status
frcelmntorgname stext Name
frcelmntorgplanversion plvar Plan version
frcelmntorgplngstatusfoed abap.int1
frcelmntorgrelshpspec rsign Relationship
frcelmntorgrelshpbtwnobj relat Relnship
frcelmntorgrelshppriority priox Priority
frcelmntorgtype otype Object type
numberofforceelementorg seqnr IT record no.
frcelmntorginfotype infotyp Infotype
frcelmntorgsubtype subtyp Subtype
frcelmntorgrelatedorgtype sclas Rel.obj.type
frcelmntorgrelshpdesc /isdfps/relat_desc Relationship
frcelmntorgcnctntdrelshptext abap.char
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
frcelmntorgtechnicalstatusname abap.numc
dfsmodelrelshpcrtndtetme dfs_createdon Created On
dfsmodelrelshpcrtedbyusr dfs_createdby Created By
dfsmodelrelshplastchgddtetme dfs_changedon Changed On
dfsmodelrelshplastchgdbyuser dfs_changedby Changed By

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.

-- Defense Model Force Element Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_MC_FE_RELSHP (
    MANDT,                           -- Client [mandt]
    DFSMODELFRCELMNTORGRELSHPUUID,   -- Dfs Mdl Frc Rel UUID [dfs_model_frcrel_uuid]
    DFSMODELFRCELMNTORGUUID,         -- Dfs Mdl Frc Elm UUID [dfs_model_frcelmnt_uuid]
    DEFENSEMODELUUID,                -- Model UUID [dfs_model_uuid]
    FORCEELEMENTORGID,               -- Object ID [hrobjid]
    FRCELMNTORGVALDTYSTARTDATE,      -- Start date [begdatum]
    FRCELMNTORGVALDTYENDDATE,        -- End Date [enddatum]
    DFSMODELRELTDFRCELMNTORGUUID,    -- Related UUID [dfsmod_reltduuid]
    FRCELMNTORGRELATEDORGID,         -- ID rel.object [sobid]
    FRCELMNTORGCONCATENATEDID,       -- Obj.type/obj.ID [otjid]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [istat_d]
    FRCELMNTORGNAME,                 -- Name [stext]
    FRCELMNTORGPLANVERSION,          -- Plan version [plvar]
    FRCELMNTORGPLNGSTATUSFOED,       -- abap.int1
    FRCELMNTORGRELSHPSPEC,           -- Relationship [rsign]
    FRCELMNTORGRELSHPBTWNOBJ,        -- Relnship [relat]
    FRCELMNTORGRELSHPPRIORITY,       -- Priority [priox]
    FRCELMNTORGTYPE,                 -- Object type [otype]
    NUMBEROFFORCEELEMENTORG,         -- IT record no. [seqnr]
    FRCELMNTORGINFOTYPE,             -- Infotype [infotyp]
    FRCELMNTORGSUBTYPE,              -- Subtype [subtyp]
    FRCELMNTORGRELATEDORGTYPE,       -- Rel.obj.type [sclas]
    FRCELMNTORGRELSHPDESC,           -- Relationship [/isdfps/relat_desc]
    FRCELMNTORGCNCTNTDRELSHPTEXT,    -- abap.char
    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]
    FRCELMNTORGTECHNICALSTATUSNAME,  -- abap.numc
    DFSMODELRELSHPCRTNDTETME,        -- Created On [dfs_createdon]
    DFSMODELRELSHPCRTEDBYUSR,        -- Created By [dfs_createdby]
    DFSMODELRELSHPLASTCHGDDTETME,    -- Changed On [dfs_changedon]
    DFSMODELRELSHPLASTCHGDBYUSER,    -- Changed By [dfs_changedby]
    PRIMARY KEY (MANDT, DFSMODELFRCELMNTORGRELSHPUUID)
);

Learn More