DFS_MC_FE_FORCE

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_MC_FE_FORCE (
    MANDT,                           -- Client [MANDT]
    DFSMODELFRCELMNTORGUUID,         -- Dfs Mdl Frc Elm UUID [DFS_MODEL_FRCELMNT_UUID]
    FORCEELEMENTORGID,               -- Object ID [HROBJID]
    DEFENSEMODELUUID,                -- Model UUID [DFS_MODEL_UUID]
    DFSMODELREFERENCEFRCELMNTORGID,  -- Object ID [HROBJID]
    FRCELMNTORGVALDTYSTARTDATE,      -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATE,        -- End Date [ENDDATUM]
    NUMBEROFFORCEELEMENTORG,         -- Counter [/ISDFPS/FORCE_CNT]
    FRCELMNTORGPLANVERSION,          -- Plan version [PLVAR]
    FRCELMNTORGTYPE,                 -- Object type [OTYPE]
    FRCELMNTORGSTOCKPLANT,           -- Plant [WERKS_D]
    FRCELMNTORGMRPSTOCKAREA,         -- MRP Stock Area [/ISDFPS/BERID_S]
    FRCELMNTORGISACCOUNTABLE,        -- Accountable [/ISDFPS/ACNTABLE_S]
    FRCELMNTORGPROVISIONSPLANT,      -- Plant [WERKS_D]
    FRCELMNTORGPRVSNMRPAREA,         -- Provis MRP Area [/ISDFPS/BERID_P]
    FRCELMNTORGISSTOCKHOLDING,       -- Stockholding [/ISDFPS/ACNTABLE_P]
    FRCELMNTORGINITSUPSTS,           -- Initial Supply Sts [/ISDFPS/FORCE_MATSTAT]
    FRCELMNTORGPURGORG,              -- Purchasing Org. [EKORG]
    FRCELMNTORGPURGGROUP,            -- Purch. Group [EKGRP]
    FRCELMNTORGSTOCKSTORAGELOC,      -- Location [LGORT_D]
    FRCELMNTORGMATLRDNSSPCT,         -- Readiness (Material) [/ISDFPS/STATUS_MAT]
    FRCELMNTORGPRSNLRDNSSPCT,        -- Readiness (Prsnl) [/ISDFPS/STATUS_PERS]
    FRCELMNTORGTRNGRDNSSPCT,         -- Readiness (Training) [/ISDFPS/STATUS_TRAI]
    FRCELMNTORGPRIORITY,             -- Organizational Prio. [PRIO_ORG]
    FRCELMNTORGLASTCHGDDTETME,       -- Time Stamp [/ISDFPS/TIMSTMP]
    FRCELMNTORGLOGSLEVEL,            -- Log. Level [/ISDFPS/LOGLEV]
    FRCELMNTORGINFRSTRUCPLANT,       -- Plant [WERKS_D]
    FRCELMORGINFRMRPAREA,            -- Infra. MRP Area [/ISDFPS/BERID_RE]
    FRCELMORGINFRSTORLOC,            -- Location [LGORT_D]
    FRCELMNTORGLASTCHGDBYUSER,       -- Changed by [/ISDFPS/CHNGBY]
    FRCELMNTORGLASTCHGDDATE,         -- Changed on [/ISDFPS/CHNGDAT]
    FRCELMNTORGCREATEDBYUSER,        -- Created by [/ISDFPS/CREABY]
    FRCELMNTORGCREATIONDATE,         -- Created On [/ISDFPS/CREADAT]
    FRCELMNTORGLOGICALSYSTEM,        -- Logical System [/ISDFPS/LOGSYS]
    FRCELMNTORGISREFFRCELMNTORG,     -- RFE Indicator [DFS_RFE_INDICATOR]
    FRCELMNTORGNAMEFOREDIT,          -- Name [STEXT]
    FRCELMNTORGSHORTNAMEFOREDIT,     -- Object abbr. [SHORT_D]
    FRCELMNTORGVALDTYSTARTDATEFOED,  -- Start date [BEGDATUM]
    FRCELMNTORGVALDTYENDDATEFOED,    -- End Date [ENDDATUM]
    FRCELMNTORGPLNGSTATUSFOREDIT,    -- Planning status [ISTAT_D]
    FRCELMNTORGCOUNTRYFOREDIT,       -- Country/Reg. [LAND1]
    FRCELMNTORGAREAFOREDIT,          -- Org. Area [/ISDFPS/SERVICE_ID]
    FRCELMNTORGSTRUCTYPEFOREDIT,     -- Structure Type [/ISDFPS/FORCE_LEVEL]
    FRCELMNTORGBRANCHFOREDIT,        -- Branch [/ISDFPS/BRANCH_ID]
    FRCELMNTORGBRANCHADDITIONFOED,   -- BA [/ISDFPS/BRANCHS_ID]
    FRCELMNTORGISAGENCYFOREDIT,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    FRCELMNTORGUSAGETYPEFOREDIT,     -- Usage Type [/ISDFPS/CASE_TYPE]
    FRCELMNTORGSTRUCLEVELFOREDIT,    -- Strct. Level [/ISDFPS/LEVEL_GROUP]
    FRCELMNTORGAREATYPEFOREDIT,      -- OrgArType [/ISDFPS/SERVICE_TYPE]
    FRCELMNTORGAREADESCFOREDIT,      -- Description [/ISDFPS/SERVICE_DESC]
    FRCELMNTORGSTRUCPARENTID,        -- Object ID [HROBJID]
    FRCELMNTORGSTRUCVALDTYSTRTDTE,   -- Start date [BEGDATUM]
    FRCELMNTORGSTRUCVALDTYENDDTE,    -- End Date [ENDDATUM]
    FRCELMNTORGWARTIMEPARENTID,      -- Object ID [HROBJID]
    FRCELMNTORGWARTMEVALDTYSTRTDTE,  -- Start date [BEGDATUM]
    FRCELMNTORGWARTMEVALDTYENDDTE,   -- End Date [ENDDATUM]
    FRCELMNTORGPEACETIMEPARENTID,    -- Object ID [HROBJID]
    FRCELMNTORGPEACETMESTRTDTE,      -- Start date [BEGDATUM]
    FRCELMNTORGPEACETMEENDDTE,       -- End Date [ENDDATUM]
    FRCELMNTORGASSGMTSTARTDATE,      -- Start date [BEGDATUM]
    FRCELMNTORGASSGMTENDDATE,        -- End Date [ENDDATUM]
    FRCELMNTORGMEASUREUUID,          -- Case Key [SCMG_CASE_GUID]
    FRCELMNTORGMEASURETYPE,          -- Measure Type [/ISDFPS/ORGM_TYPE]
    FRCELMNTORGMEASUREDESC,          -- Ty. [/ISDFPS/ORGM_TYPE_TEXT]
    FRCELMNTORGSHORTNAME,            -- Object abbr. [SHORT_D]
    FRCELMNTORGNAME,                 -- Name [STEXT]
    FRCELMNTORGLANGUAGEFOED,         -- Language [LANGU]
    FRCELMNTORGINFOTYPE,             -- Infotype [INFOTYP]
    FRCELMNTORGPLNGSTATUS,           -- Planning status [ISTAT_D]
    FRCELMNTORGCOUNTRY,              -- Country/Reg. [LAND1]
    FRCELMNTORGAREA,                 -- Org. Area [/ISDFPS/SERVICE_ID]
    FRCELMNTORGSTRUCTYPE,            -- Structure Type [/ISDFPS/FORCE_LEVEL]
    FRCELMNTORGSTRUCLEVEL,           -- Strct. Level [/ISDFPS/LEVEL_GROUP]
    FRCELMNTORGBRANCH,               -- Branch [/ISDFPS/BRANCH_ID]
    FRCELMNTORGUSAGETYPE,            -- Usage Type [/ISDFPS/CASE_TYPE]
    FRCELMNTORGISAGENCY,             -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    FRCELMNTORGAREATYPE,             -- OrgArType [/ISDFPS/SERVICE_TYPE]
    FRCELMNTORGBRANCHADDITION,       -- BA [/ISDFPS/BRANCHS_ID]
    FRCELMNTORGSYMBOL,               -- SC [/ISDFPS/SC]
    FRCELMNTORGUIC,                  -- Unit Idn Code [DFS_UIC]
    FRCELMNTORGREFERENCEID,          -- Object ID [HROBJID]
    FRCELMNTORGCONCATENATEDID,       -- Obj.type/obj.ID [OTJID]
    FRCELMNTORGSENSITIVITY,          -- Sensitivity for Char [DFS_SENSITIVITY_KEY]
    FRCELMNTORGSENSITIVITYPRIO,      -- Priority Char [DFS_PRIORITY_KEY]
    FRCELMNTORGACTIVITY,             -- Activity Code Char [DFS_ACTIVITY_CODE]
    FRCELMNTORGSERVICETYPE,          -- Service Type [DFS_SERVICE_TYPE]
    DFSMODELCHANGETYPE,              -- Change Type [DFS_MOD_CHNG_TYPE]
    DFSMODELCREATEDBYUSER,           -- Created By [DFS_CREATEDBY]
    DFSMODELCREATIONDATETIME,        -- Created On [DFS_CREATEDON]
    DFSMODELLASTCHANGEDBYUSER,       -- Changed By [DFS_CHANGEDBY]
    DFSMODELLASTCHANGEDDATETIME,     -- Changed On [DFS_CHANGEDON]
    PRIMARY KEY (MANDT, DFSMODELFRCELMNTORGUUID)
);