I_PUBSECCMTMTACTLITEMCUBE

CDS View
116 Fields 8 CDS Views

Commitment and Actual Items - Cube

I_PUBSECCMTMTACTLITEMCUBE is a CDS View in S/4HANA. Commitment and Actual Items - Cube. It contains 116 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_PubSecCmtmtActlItem view from COMPOSITE Commitment and Actual Items
C_PubSecCmtmtActlAnalyses view from CONSUMPTION Commitment/Actual Items Analyses
I_PubSecCmtmtAgingGroup view from COMPOSITE Open commitment aging grouping view
I_PubSecCtrlObjCmtmtActlCube view from COMPOSITE Commitment / Actual Control Object Items Cube
I_PubSecPeriodicCmtmtAdj view from COMPOSITE Periodic Commitment Adjustments
I_RIBRevenueItemCube view_entity from COMPOSITE Revenue Control Object Items - Cube
P_GteeMIndrctCostLbltyActLItem view from COMPOSITE
P_PubSecGrantCostSharingItems view from COMPOSITE

Fields (116)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 5
KEY FiscalYear FiscalYear 5
KEY GrantID GrantID 4
KEY Ledger Ledger 5
KEY LedgerGLLineItem LedgerGLLineItem 3
KEY SourceLedger SourceLedger 2
KEY SponsoredClass SponsoredClass 3
KEY SponsoredProgram SponsoredProgram 3
_AccountingDocumentType _AccountingDocumentType 1
_BudgetPeriod _BudgetPeriod 2
_BusinessArea _BusinessArea 1
_ChartOfAccountsText _ChartOfAccountsText 1
_CompanyCode _CompanyCode 3
_CompanyCodeCurrency _CompanyCodeCurrency 1
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 3
_CurrentCostCenter _CurrentCostCenter 3
_CurrentProfitCenter _CurrentProfitCenter 2
_Customer _Customer 1
_FinancialAccountType _FinancialAccountType 1
_FinancialManagementArea _FinancialManagementArea 3
_FiscalYear _FiscalYear 3
_FunctionalArea _FunctionalArea 3
_Fund _Fund 3
_FundType _FundType 2
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 3
_GlobalCurrency _GlobalCurrency 3
_Grant _Grant 2
_JournalEntry _JournalEntry 2
_Ledger _Ledger 2
_ProfitCenter _ProfitCenter 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
_PubSecBdgtCnsmpnAmtType _PubSecBdgtCnsmpnAmtType 1
_PubSecBdgtCnsmpnType _PubSecBdgtCnsmpnType 3
_PubSecBudgetAccount _PubSecBudgetAccount 1
_Segment _Segment 2
_SourceLedger _SourceLedger 2
_SourceReferenceDocumentType _SourceReferenceDocumentType 2
_SponsoredClass _SponsoredClass 1
_SponsoredProgram _SponsoredProgram 1
_Supplier _Supplier 1
_TransactionCurrency _TransactionCurrency 1
_WBSElementBasicData _WBSElementBasicData 1
_WBSElementExternalID _WBSElementExternalID 3
AccountAssignmentNumber AccountAssignmentNumber 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 3
AmountInTransactionCurrency AmountInTransactionCurrency 1
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 1
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 2
ControllingArea ControllingArea 3
CostCenter CostCenter 4
Customer Customer 1
EarmarkedFundsDocument EarmarkedFundsDocument 2
FinancialAccountType FinancialAccountType 1
FinancialManagementArea FinancialManagementArea 4
FiscalPeriod FiscalPeriod 1
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 4
Fund Fund 4
FundType FundType 2
GLAccount GLAccount 4
GlobalCurrency GlobalCurrency 5
GteeMBudgetValidityNumber GteeMBudgetValidityNumber 2
IsCommitment IsCommitment 1
LedgerFiscalYear LedgerFiscalYear 1
PartnerBudgetPeriod PartnerBudgetPeriod 1
PartnerFunctionalArea PartnerFunctionalArea 1
PartnerFund PartnerFund 1
PartnerGrant PartnerGrant 1
ProfitCenter ProfitCenter 3
PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 3
PubSecBudgetAccount PubSecBudgetAccount 3
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 1
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType 2
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate 2
PubSecBudgetCnsmpnFsclPeriod PubSecBudgetCnsmpnFsclPeriod 1
PubSecBudgetCnsmpnFsclYear PubSecBudgetCnsmpnFsclYear 2
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 5
PubSecBudgetIsRelevant PubSecBudgetIsRelevant 2
PubSecExpnActlAmtInCoCodeCrcy PubSecExpnActlAmtInCoCodeCrcy 1
PubSecExpnActlAmtInGlobalCrcy PubSecExpnActlAmtInGlobalCrcy 2
PubSecExpnActlAmtInTransCrcy PubSecExpnActlAmtInTransCrcy 1
PubSecExpnCmtmtAmtInCoCodeCrcy PubSecExpnCmtmtAmtInCoCodeCrcy 1
PubSecExpnCmtmtAmtInGlobalCrcy PubSecExpnCmtmtAmtInGlobalCrcy 2
PubSecExpnCmtmtAmtInTransCrcy PubSecExpnCmtmtAmtInTransCrcy 1
PubSecRevnActlAmtInCoCodeCrcy PubSecRevnActlAmtInCoCodeCrcy 1
PubSecRevnActlAmtInGlobalCrcy PubSecRevnActlAmtInGlobalCrcy 3
PubSecRevnActlAmtInTransCrcy PubSecRevnActlAmtInTransCrcy 1
PubSecRevnCmtmtAmtInCoCodeCrcy PubSecRevnCmtmtAmtInCoCodeCrcy 1
PubSecRevnCmtmtAmtInGlobalCrcy PubSecRevnCmtmtAmtInGlobalCrcy 3
PubSecRevnCmtmtAmtInTransCrcy PubSecRevnCmtmtAmtInTransCrcy 1
PurchaseOrder PurchaseOrder 2
PurchaseRequisition PurchaseRequisition 2
PurchasingDocument PurchasingDocument 3
PurchasingDocumentItem PurchasingDocumentItem 3
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory 2
Segment Segment 3
SourceLogicalSystem SourceLogicalSystem 2
SourceReferenceDocSubitem SourceReferenceDocSubitem 2
SourceReferenceDocument SourceReferenceDocument 2
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 2
SourceReferenceDocumentItem SourceReferenceDocumentItem 2
SourceReferenceDocumentType SourceReferenceDocumentType 2
Supplier Supplier 1
TransactionCurrency TransactionCurrency 2
WBSElementExternalID WBSElementExternalID 4
WBSElementInternalID WBSElementInternalID 3

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 and Actual Items - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECCMTMTACTLITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    GRANTID,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUDGETPERIOD,
    _BUSINESSAREA,
    _CHARTOFACCOUNTSTEXT,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _FUND,
    _FUNDTYPE,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _JOURNALENTRY,
    _LEDGER,
    _PROFITCENTER,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _PUBSECBDGTCNSMPNAMTTYPE,
    _PUBSECBDGTCNSMPNTYPE,
    _PUBSECBUDGETACCOUNT,
    _SEGMENT,
    _SOURCELEDGER,
    _SOURCEREFERENCEDOCUMENTTYPE,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUDGETPERIOD,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    EARMARKEDFUNDSDOCUMENT,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FISCALPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    FUND,
    FUNDTYPE,
    GLACCOUNT,
    GLOBALCURRENCY,
    GTEEMBUDGETVALIDITYNUMBER,
    ISCOMMITMENT,
    LEDGERFISCALYEAR,
    PARTNERBUDGETPERIOD,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNFSCLPERIOD,
    PUBSECBUDGETCNSMPNFSCLYEAR,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    PUBSECEXPNACTLAMTINCOCODECRCY,
    PUBSECEXPNACTLAMTINGLOBALCRCY,
    PUBSECEXPNACTLAMTINTRANSCRCY,
    PUBSECEXPNCMTMTAMTINCOCODECRCY,
    PUBSECEXPNCMTMTAMTINGLOBALCRCY,
    PUBSECEXPNCMTMTAMTINTRANSCRCY,
    PUBSECREVNACTLAMTINCOCODECRCY,
    PUBSECREVNACTLAMTINGLOBALCRCY,
    PUBSECREVNACTLAMTINTRANSCRCY,
    PUBSECREVNCMTMTAMTINCOCODECRCY,
    PUBSECREVNCMTMTAMTINGLOBALCRCY,
    PUBSECREVNCMTMTAMTINTRANSCRCY,
    PURCHASEORDER,
    PURCHASEREQUISITION,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REFERENCEPURCHASEORDERCATEGORY,
    SEGMENT,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, GRANTID, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, SPONSOREDCLASS, SPONSOREDPROGRAM)
);

Learn More