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)
);