P_FUNDSMGMTJOURNALENTRYITEM

CDS View
33 Fields 6 CDS Views

P_FUNDSMGMTJOURNALENTRYITEM is a CDS View in S/4HANA. It contains 33 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_FundsMgmtJournalEntryItem view from COMPOSITE Funds Management Document Journal Item
P_FndsMgmtAnnBdgtActlDets view inner BASIC
P_MyFMAnnualAlertDrillPost view inner BASIC
P_MyFMAnnualBdgtDrillPost view inner BASIC
P_MyFMOvrlAlertDrillPost view inner BASIC
P_MyFMOvrlBdgtDrillPost view inner BASIC

Fields (33)

KeyField CDS FieldsUsed in Views
KEY FundsMgmtAmountType FundsMgmtAmountType 5
KEY FundsMgmtJournalEntry FundsMgmtJournalEntry 5
KEY FundsMgmtJournalEntryItem FundsMgmtJournalEntryItem 5
KEY FundsMgmtLongSequenceNumber FundsMgmtLongSequenceNumber 5
KEY FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory 5
KEY Ledger Ledger 5
KEY RefDocAccountAssignment RefDocAccountAssignment 5
KEY RefDocPricingElementContent RefDocPricingElementContent 5
KEY ReferenceDocumentContext ReferenceDocumentContext 5
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 5
KEY ReferenceDocumentScheduleLine ReferenceDocumentScheduleLine 5
KEY ReferenceDocumentType ReferenceDocumentType 5
BusinessArea BusinessArea 5
BusinessTransactionType BusinessTransactionType 5
CashEffectivityFiscalYear CashEffectivityFiscalYear 5
CompanyCode CompanyCode 5
ControllingArea ControllingArea 5
FinMgmtAreaPeriod FinMgmtAreaPeriod 5
FundsMgCarryForwardLevel FundsMgCarryForwardLevel 5
FundsMgmtValueType FundsMgmtValueType 5
GLAccount GLAccount 5
IsStatisticalItem IsStatisticalItem 5
PostedAmountInFMACrcy PostedAmountInFMACrcy 5
PostedBudgetPeriod PostedBudgetPeriod 5
PostedCommitmentItem PostedCommitmentItem 5
PostedFunctionalArea PostedFunctionalArea 5
PostedFund PostedFund 5
PostedFundedProgram PostedFundedProgram 5
PostedFundsCenter PostedFundsCenter 5
PostedFundsMgmtCustomerField PostedFundsMgmtCustomerField 5
PostedGrantID PostedGrantID 5
ProfitCenter ProfitCenter 5
Segment Segment 5

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_FUNDSMGMTJOURNALENTRYITEM (
    FUNDSMGMTAMOUNTTYPE,
    FUNDSMGMTJOURNALENTRY,
    FUNDSMGMTJOURNALENTRYITEM,
    FUNDSMGMTLONGSEQUENCENUMBER,
    FUNDSMGMTREFDOCUMENTCATEGORY,
    LEDGER,
    REFDOCACCOUNTASSIGNMENT,
    REFDOCPRICINGELEMENTCONTENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTSCHEDULELINE,
    REFERENCEDOCUMENTTYPE,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CASHEFFECTIVITYFISCALYEAR,
    COMPANYCODE,
    CONTROLLINGAREA,
    FINMGMTAREAPERIOD,
    FUNDSMGCARRYFORWARDLEVEL,
    FUNDSMGMTVALUETYPE,
    GLACCOUNT,
    ISSTATISTICALITEM,
    POSTEDAMOUNTINFMACRCY,
    POSTEDBUDGETPERIOD,
    POSTEDCOMMITMENTITEM,
    POSTEDFUNCTIONALAREA,
    POSTEDFUND,
    POSTEDFUNDEDPROGRAM,
    POSTEDFUNDSCENTER,
    POSTEDFUNDSMGMTCUSTOMERFIELD,
    POSTEDGRANTID,
    PROFITCENTER,
    SEGMENT,
    PRIMARY KEY (FUNDSMGMTAMOUNTTYPE, FUNDSMGMTJOURNALENTRY, FUNDSMGMTJOURNALENTRYITEM, FUNDSMGMTLONGSEQUENCENUMBER, FUNDSMGMTREFDOCUMENTCATEGORY, LEDGER, REFDOCACCOUNTASSIGNMENT, REFDOCPRICINGELEMENTCONTENT, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTLOGICALSYSTEM, REFERENCEDOCUMENTSCHEDULELINE, REFERENCEDOCUMENTTYPE)
);

Learn More