FCO_OVHD_STADR

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_RUNOVERHEADSTATISTICTP I_RUNOVERHEADSTATISTICTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCO_OVHD_STADR (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    CONTROLLINGOBJECT,               -- Object number [j_objnr]
    CONTROLLINGOVERHEADDRAFTUUID,    -- GUID 16 [guid_32]
    NUMBEROFSENDERSWITHOVERHEAD,     -- Overhead Calculated [fco_ovhd_numof_executed]
    NUMBEROFNOTRELEVANTSENDERS,      -- Not Relevant [fco_ovhd_numof_notrelevant]
    NUMBEROFSENDERSWITHERROR,        -- Error [fco_ovhd_numof_error]
    NUMBEROFSELECTEDSENDERS,         -- Number of selected senders [fco_ovhd_numof_selected]
    NUMBEROFSENDERSWITHWRONGSTATUS,  -- Inappropriate Status [fco_ovhd_numof_inappstatus]
    NUMBEROFSENDERSWITHOUTCHANGE,    -- Number of unchanged senders [fco_ovhd_numof_notchanged]
    ORDERID,                         -- Order [aufnr]
    MAINTENANCEORDER,                -- Order [aufnr]
    PROJECTINTERNALID,               -- Project Def. [ps_s4_proj_pspnr]
    SERVICEDOCUMENTITEM,             -- Service Doc. Item [fco_srvdoc_item_id]
    WBSELEMENTINTERNALID,            -- WBS Element [ps_posnr1]
    PROJECTEXTERNALID,               -- Project def. [ps_pspid_edit]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COMPANYCODE,                     -- Company Code [bukrs]
    COMPANYCODEPARAMLISTVALUE,       -- Overhead Company Code parametr list [fco_ovhd_listof_bukrs]
    CTRLGOVERHEADHASHIERARCHY,       -- With hierarchy [ps_hiera]
    CONTROLLINGOVERHEADHASORDERS,    -- With orders [ps_incor]
    FISCALYEAR,                      -- Fiscal Year [gjahr]
    LEDGER,                          -- Ledger [fins_ledger]
    POSTINGPERIOD,                   -- Posting Period [cobu_perio]
    POSTINGDATE,                     -- Posting Date [co_budat]
    VALUEDATE,                       -- Value Date [wsdat]
    CONTROLLINGOVERHEADISEXECUTED,   -- Sel. Main Crit. [xfld]
    CTRLGOVERHEADREVERSEISEXECUTED,  -- Sel. Main Crit. [xfld]
    CONTROLLINGOVERHEADISTESTRUN,    -- Test Run [testlauf]
    CONTROLLINGOVERHEADRUNMODE,      -- Overhead run mode [fco_ovhd_run_mode]
    CTRLGOVERHEADOVERALLSTATUS,      -- Overall Status of Overhead [fco_ovhd_ovrl_status]
    CTRLGOVERHEADSTATUSCRITICALITY,  -- Status Criticality [fco_ovhd_ovrl_sts_criticality]
    CONTROLLINGOBJECTEXTERNALID,     -- WBS Element [ps_posid_edit]
    CONTROLLINGOVERHEADDOCUMENT,     -- Document Number [co_belnr]
    CREATIONDATE,                    -- Date Overhead document was created [fco_ovhd_run_on]
    ACCOUNTINGDOCCREATEDBYUSER,      -- User which created overhead document [fco_ovhd_run_by]
    CTRLGOVERHEADREVERSEDDOCUMENT,   -- Reversed Doc. [aa_stbel]
    CTRLGOVERHEADSENDEROBJECT,       -- Sender [fco_ovhd_sender_id_out]
    CTRLGOVERHEADSENDERTYPETEXT,     -- Sender Type [fco_ovhd_snd_type_text]
    CTRLGOVERHEADREVERSALDOCUMENT,   -- Document Number [aa_belnr]
    CTRLGOVERHEADRVSLDOCCRTNDATE,    -- Date of reversal [fco_ovhd_reversed_on]
    PUBLICSECTORISENABLED,           -- PSM Enabled [fco_stlmt_psm_enabled]
    NUMBEROFRUNMESSAGES,             -- INT4 [int4]
    NUMBEROFRUNRESULTS,              -- INT4 [int4]
    NUMBEROFPOSTEDJOURNALENTRIES,    -- INT4 [int4]
    CONTROLLINGOBJECTTYPE,           -- Object Type [j_obart]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);