P_FUNDSMGMTCMTMTENTRYITEM

CDS View

P_FUNDSMGMTCMTMTENTRYITEM is a CDS View in S/4HANA. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPS_PurchasingDocumentBudget view_entity from BASIC Purchasing Document Budget Basic

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CashEffectivityFiscalYear CashEffectivityFiscalYear 1
KEY FinancialManagementArea FinancialManagementArea 1
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear 1
KEY FundsMgmtAmountType FundsMgmtAmountType 1
KEY FundsMgmtRefDocScheduleLine FundsMgmtRefDocScheduleLine 1
KEY FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory 1
KEY FundsMgmtReferenceDocumentItem FundsMgmtReferenceDocumentItem 1
KEY FundsMgmtSequenceNumber FundsMgmtSequenceNumber 1
KEY Ledger Ledger 1
KEY RefDocAccountAssignment RefDocAccountAssignment 1
KEY RefDocPricingElementContent RefDocPricingElementContent 1
KEY ReferenceDocument ReferenceDocument 1
KEY ReferenceDocumentContext ReferenceDocumentContext 1
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
KEY ReferenceDocumentType ReferenceDocumentType 1
PostedAmountInTransCrcy PostedAmountInTransCrcy 1
TransactionCurrency TransactionCurrency 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FUNDSMGMTCMTMTENTRYITEM (
    CASHEFFECTIVITYFISCALYEAR,
    FINANCIALMANAGEMENTAREA,
    FINMGMTAREAFISCALYEAR,
    FUNDSMGMTAMOUNTTYPE,
    FUNDSMGMTREFDOCSCHEDULELINE,
    FUNDSMGMTREFDOCUMENTCATEGORY,
    FUNDSMGMTREFERENCEDOCUMENTITEM,
    FUNDSMGMTSEQUENCENUMBER,
    LEDGER,
    REFDOCACCOUNTASSIGNMENT,
    REFDOCPRICINGELEMENTCONTENT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    POSTEDAMOUNTINTRANSCRCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CASHEFFECTIVITYFISCALYEAR, FINANCIALMANAGEMENTAREA, FINMGMTAREAFISCALYEAR, FUNDSMGMTAMOUNTTYPE, FUNDSMGMTREFDOCSCHEDULELINE, FUNDSMGMTREFDOCUMENTCATEGORY, FUNDSMGMTREFERENCEDOCUMENTITEM, FUNDSMGMTSEQUENCENUMBER, LEDGER, REFDOCACCOUNTASSIGNMENT, REFDOCPRICINGELEMENTCONTENT, REFERENCEDOCUMENT, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTTYPE)
);