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