I_PUBSECCTRLOBJCMTMTACTLCUBE

CDS View
96 Fields 2 CDS Views

Commitment / Actual Control Object Items Cube

I_PUBSECCTRLOBJCMTMTACTLCUBE is a CDS View in S/4HANA. Commitment / Actual Control Object Items Cube. It contains 96 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PubSecCtrlObjCmtmtActl view from CONSUMPTION Commitment/Actual Control Object Items Analysis
I_PubSecBdgtConsumedAnalysis view from COMPOSITE Public Sector Budget Consumed Analysis

Fields (96)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentType AccountingDocumentType 2
KEY AvailabilityControlProfile AvailabilityControlProfile 2
KEY BusinessArea BusinessArea 2
KEY CompanyCode CompanyCode 2
KEY ControllingArea ControllingArea 2
KEY CostCenter CostCenter 2
KEY CtrlObjForBdgtValidityNmbr CtrlObjForBdgtValidityNmbr 2
KEY CtrlObjForBudgetAccount CtrlObjForBudgetAccount 2
KEY CtrlObjForBudgetPeriod CtrlObjForBudgetPeriod 2
KEY CtrlObjForCostCenter CtrlObjForCostCenter 2
KEY CtrlObjForFunctionalArea CtrlObjForFunctionalArea 2
KEY CtrlObjForFund CtrlObjForFund 2
KEY CtrlObjForGrant CtrlObjForGrant 1
KEY CtrlObjForSponsoredClass CtrlObjForSponsoredClass 2
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 2
KEY CtrlObjForWBSElement CtrlObjForWBSElement 2
KEY Customer Customer 2
KEY FinancialAccountType FinancialAccountType 2
KEY FinancialManagementArea FinancialManagementArea 2
KEY FiscalYear FiscalYear 2
KEY FunctionalArea FunctionalArea 2
KEY Fund Fund 2
KEY GLAccount GLAccount 2
KEY GlobalCurrency GlobalCurrency 2
KEY GrantID GrantID 2
KEY GteeMBudgetValidityNumber GteeMBudgetValidityNumber 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY ProfitCenter ProfitCenter 2
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 2
KEY PubSecBudgetAccount PubSecBudgetAccount 2
KEY Segment Segment 2
KEY SourceLedger SourceLedger 1
KEY SponsoredClass SponsoredClass 2
KEY SponsoredProgram SponsoredProgram 2
KEY Supplier Supplier 2
_AccountingDocumentType _AccountingDocumentType 1
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_CtrlObjBdgtAccount _CtrlObjBdgtAccount 1
_CtrlObjBdgtPeriod _CtrlObjBdgtPeriod 1
_CtrlObjCostCenter _CtrlObjCostCenter 1
_CtrlObjFuncArea _CtrlObjFuncArea 1
_CtrlObjFund _CtrlObjFund 1
_CtrlObjGrant _CtrlObjGrant 1
_CtrlObjSpnsrdClass _CtrlObjSpnsrdClass 1
_CtrlObjSpnsrdProg _CtrlObjSpnsrdProg 1
_CtrlObjWBSElement _CtrlObjWBSElement 1
_CurrentCostCenter _CurrentCostCenter 2
_CurrentProfitCenter _CurrentProfitCenter 1
_Customer _Customer 1
_FinancialAccountType _FinancialAccountType 1
_FinancialManagementArea _FinancialManagementArea 2
_FiscalYear _FiscalYear 1
_Fund _Fund 2
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_GlobalCurrency _GlobalCurrency 1
_Grant _Grant 2
_ProfitCenter _ProfitCenter 1
_PubSecAvailyCtrlProfile _PubSecAvailyCtrlProfile 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
_PubSecBudgetAccount _PubSecBudgetAccount 1
_PubSecBudgetAccountHier _PubSecBudgetAccountHier 1
_PubSecBudgetPeriodHier _PubSecBudgetPeriodHier 1
_PubSecCostCenterHier _PubSecCostCenterHier 1
_PubSecFunctionalAreaHier _PubSecFunctionalAreaHier 1
_PubSecFundHier _PubSecFundHier 1
_PubSecGrantHier _PubSecGrantHier 1
_PubSecSpnsrdClassHier _PubSecSpnsrdClassHier 1
_PubSecSpnsrdProgHier _PubSecSpnsrdProgHier 1
_PubSecWBSElementHier _PubSecWBSElementHier 1
_Segment _Segment 1
_SponsoredClass _SponsoredClass 1
_SponsoredProgram _SponsoredProgram 1
_Supplier _Supplier 1
BudgetPeriod BudgetPeriod 1
EarmarkedFundsDocument EarmarkedFundsDocument 1
FundType FundType 1
GrantHierarchy GrantHierarchy 2
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 2
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 2
HierarchyIDForCostCenter HierarchyIDForCostCenter 2
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 2
HierarchyIDForFund HierarchyIDForFund 2
HierarchyIDForWBSElement HierarchyIDForWBSElement 2
IsCommitment IsCommitment 1
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType 1
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate 1
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 1
PurchaseOrder PurchaseOrder 1
PurchaseRequisition PurchaseRequisition 1
SponsoredClassHierarchy SponsoredClassHierarchy 2
SponsoredProgramHierarchy SponsoredProgramHierarchy 2

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.

-- Commitment / Actual Control Object Items Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECCTRLOBJCMTMTACTLCUBE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    AVAILABILITYCONTROLPROFILE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CTRLOBJFORBDGTVALIDITYNMBR,
    CTRLOBJFORBUDGETACCOUNT,
    CTRLOBJFORBUDGETPERIOD,
    CTRLOBJFORCOSTCENTER,
    CTRLOBJFORFUNCTIONALAREA,
    CTRLOBJFORFUND,
    CTRLOBJFORGRANT,
    CTRLOBJFORSPONSOREDCLASS,
    CTRLOBJFORSPONSOREDPROGRAM,
    CTRLOBJFORWBSELEMENT,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FISCALYEAR,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    LEDGER,
    LEDGERGLLINEITEM,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    SEGMENT,
    SOURCELEDGER,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUPPLIER,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CTRLOBJBDGTACCOUNT,
    _CTRLOBJBDGTPERIOD,
    _CTRLOBJCOSTCENTER,
    _CTRLOBJFUNCAREA,
    _CTRLOBJFUND,
    _CTRLOBJGRANT,
    _CTRLOBJSPNSRDCLASS,
    _CTRLOBJSPNSRDPROG,
    _CTRLOBJWBSELEMENT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUND,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _PROFITCENTER,
    _PUBSECAVAILYCTRLPROFILE,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTHIER,
    _PUBSECBUDGETPERIODHIER,
    _PUBSECCOSTCENTERHIER,
    _PUBSECFUNCTIONALAREAHIER,
    _PUBSECFUNDHIER,
    _PUBSECGRANTHIER,
    _PUBSECSPNSRDCLASSHIER,
    _PUBSECSPNSRDPROGHIER,
    _PUBSECWBSELEMENTHIER,
    _SEGMENT,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    _SUPPLIER,
    BUDGETPERIOD,
    EARMARKEDFUNDSDOCUMENT,
    FUNDTYPE,
    GRANTHIERARCHY,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORWBSELEMENT,
    ISCOMMITMENT,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNTYPE,
    PURCHASEORDER,
    PURCHASEREQUISITION,
    SPONSOREDCLASSHIERARCHY,
    SPONSOREDPROGRAMHIERARCHY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, AVAILABILITYCONTROLPROFILE, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, CTRLOBJFORBDGTVALIDITYNMBR, CTRLOBJFORBUDGETACCOUNT, CTRLOBJFORBUDGETPERIOD, CTRLOBJFORCOSTCENTER, CTRLOBJFORFUNCTIONALAREA, CTRLOBJFORFUND, CTRLOBJFORGRANT, CTRLOBJFORSPONSOREDCLASS, CTRLOBJFORSPONSOREDPROGRAM, CTRLOBJFORWBSELEMENT, CUSTOMER, FINANCIALACCOUNTTYPE, FINANCIALMANAGEMENTAREA, FISCALYEAR, FUNCTIONALAREA, FUND, GLACCOUNT, GLOBALCURRENCY, GRANTID, GTEEMBUDGETVALIDITYNUMBER, LEDGER, LEDGERGLLINEITEM, PROFITCENTER, PUBSECBDGTACCTREVNEXPNCODE, PUBSECBUDGETACCOUNT, SEGMENT, SOURCELEDGER, SPONSOREDCLASS, SPONSOREDPROGRAM, SUPPLIER)
);

Learn More