I_FUNDSMANAGEMENTDOCUMENTITEM

CDS View
58 Fields 4 CDS Views

FM Document Item

I_FUNDSMANAGEMENTDOCUMENTITEM is a CDS View in S/4HANA. FM Document Item. It contains 58 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CommitmentActualsAnalysis view union_all COMPOSITE Commitments / Actuals Documents
I_FndsMgmtCmtmtActualCube view union_all COMPOSITE Commitments / Actuals Documents
I_FundsMgmtDocItmCube view from COMPOSITE Funds Management Actual Items - Cube
P_FundsMgmtJournalEntryItem view from COMPOSITE

Fields (58)

KeyField CDS FieldsUsed in Views
KEY BusinessTransactionType BusinessTransactionType 3
KEY FinancialManagementArea FinancialManagementArea 1
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear 1
KEY FundsManagementDocument FundsManagementDocument 1
KEY FundsManagementDocumentItem FundsManagementDocumentItem 1
KEY FundsMgCarryForwardLevel FundsMgCarryForwardLevel 3
KEY FundsMgmtAmountType FundsMgmtAmountType 3
KEY FundsMgmtFinDocItem FundsMgmtFinDocItem 2
KEY FundsMgmtFinDocNumber AccountingDocument,FundsMgmtFinDocNumber 3
KEY FundsMgmtSequenceNumber FundsMgmtSequenceNumber 2
KEY FundsMgmtTransactionNumber FundsMgmtTransactionNumber 2
KEY FundsMgmtValueType FundsMgmtValueType 3
KEY IsStatisticalItem IsStatisticalItem 3
KEY Ledger Ledger 3
KEY ProfitCenter FndsMgmtRptgPrftCtrForHier,ProfitCenter 2
_FinMgmtArea _FinMgmtArea 1
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea 1
_Header _Header 1
BudgetPeriodAuthznGrp BudgetPeriodAuthznGrp 1
BusinessArea BusinessArea 1
CmtmtItemFinMgmtAreaForAuthzn CmtmtItemFinMgmtAreaForAuthzn 1
CommitmentItemAuthznGrp CommitmentItemAuthznGrp 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 2
FinancialManagementAreaCrcy FinancialManagementAreaCrcy 1
FinMgmtAreaPeriod FinMgmtAreaPeriod 2
FndsCenterFinMgmtAreaForAuthzn FndsCenterFinMgmtAreaForAuthzn 1
FunctionalAreaAuthznGrp FunctionalAreaAuthznGrp 1
FundAuthznGrp FundAuthznGrp 1
FundedPgmFinMgmtAreaForAuthzn FundedPgmFinMgmtAreaForAuthzn 1
FundedProgramAuthznGrp FundedProgramAuthznGrp 1
FundFinMgmtAreaForAuthzn FundFinMgmtAreaForAuthzn 1
FundsCenterAuthznGrp FundsCenterAuthznGrp 1
FundsManagementStatisticalType FundsManagementStatisticalType 1
FundsMgmtFinDocFiscalYear FiscalYear,FundsMgmtFinDocFiscalYear 3
FundsMgmtObjectNumber FundsMgmtObjectNumber 1
FundsMgmtPaytDocFiscalYear FundsMgmtPaytDocFiscalYear 2
FundsMgmtPaytDocItem FundsMgmtPaytDocItem 3
FundsMgmtPaytDocNumber FundsMgmtPaytDocNumber 3
FundsMgmtPredecessorAcctAssgmt FundsMgmtPredecessorAcctAssgmt 1
FundsMgmtPredecessorDocCat FundsMgmtPredecessorDocCat 1
FundsMgmtPredecessorDocItem FundsMgmtPredecessorDocItem 1
FundsMgmtPredecessorDocNumber FundsMgmtPredecessorDocNumber 1
FundsMgmtPredecessorDocOrg FundsMgmtPredecessorDocOrg 1
FundsMgmtTradingPartnerCoId FundsMgmtTradingPartnerCoId 1
FundsMgmtUpdateDate FundsMgmtUpdateDate 3
GLAccount GLAccount 1
GrantAuthznGrp GrantAuthznGrp 1
GrantLifecycleStatus GrantLifecycleStatus 1
PostedBudgetPeriod FndsMgmtRptgBdgtPerdForHier 1
PostedCommitmentItem FndsMgmtRptgCmtmtItemForHier 1
PostedFunctionalArea FndsMgmtRptgFctArForHierarchy 1
PostedFund FndsMgmtRptgFundForHierarchy 1
PostedFundedProgram FndsMgmtRptgFnddPgmForHier 1
PostedFundsCenter FndsMgmtRptgFndsCtrForHier 1
PostedGrantID FndsMgmtRptgGrantIDForHier 1
Segment FndsMgmtRptgSegmentForHier,Segment 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.

-- FM Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FUNDSMANAGEMENTDOCUMENTITEM (
    BUSINESSTRANSACTIONTYPE,
    FINANCIALMANAGEMENTAREA,
    FINMGMTAREAFISCALYEAR,
    FUNDSMANAGEMENTDOCUMENT,
    FUNDSMANAGEMENTDOCUMENTITEM,
    FUNDSMGCARRYFORWARDLEVEL,
    FUNDSMGMTAMOUNTTYPE,
    FUNDSMGMTFINDOCITEM,
    FUNDSMGMTFINDOCNUMBER,
    FUNDSMGMTSEQUENCENUMBER,
    FUNDSMGMTTRANSACTIONNUMBER,
    FUNDSMGMTVALUETYPE,
    ISSTATISTICALITEM,
    LEDGER,
    PROFITCENTER,
    _FINMGMTAREA,
    _FISCALYEARFORFINMGMTAREA,
    _HEADER,
    BUDGETPERIODAUTHZNGRP,
    BUSINESSAREA,
    CMTMTITEMFINMGMTAREAFORAUTHZN,
    COMMITMENTITEMAUTHZNGRP,
    COMPANYCODE,
    CONTROLLINGAREA,
    FINANCIALMANAGEMENTAREACRCY,
    FINMGMTAREAPERIOD,
    FNDSCENTERFINMGMTAREAFORAUTHZN,
    FUNCTIONALAREAAUTHZNGRP,
    FUNDAUTHZNGRP,
    FUNDEDPGMFINMGMTAREAFORAUTHZN,
    FUNDEDPROGRAMAUTHZNGRP,
    FUNDFINMGMTAREAFORAUTHZN,
    FUNDSCENTERAUTHZNGRP,
    FUNDSMANAGEMENTSTATISTICALTYPE,
    FUNDSMGMTFINDOCFISCALYEAR,
    FUNDSMGMTOBJECTNUMBER,
    FUNDSMGMTPAYTDOCFISCALYEAR,
    FUNDSMGMTPAYTDOCITEM,
    FUNDSMGMTPAYTDOCNUMBER,
    FUNDSMGMTPREDECESSORACCTASSGMT,
    FUNDSMGMTPREDECESSORDOCCAT,
    FUNDSMGMTPREDECESSORDOCITEM,
    FUNDSMGMTPREDECESSORDOCNUMBER,
    FUNDSMGMTPREDECESSORDOCORG,
    FUNDSMGMTTRADINGPARTNERCOID,
    FUNDSMGMTUPDATEDATE,
    GLACCOUNT,
    GRANTAUTHZNGRP,
    GRANTLIFECYCLESTATUS,
    POSTEDBUDGETPERIOD,
    POSTEDCOMMITMENTITEM,
    POSTEDFUNCTIONALAREA,
    POSTEDFUND,
    POSTEDFUNDEDPROGRAM,
    POSTEDFUNDSCENTER,
    POSTEDGRANTID,
    SEGMENT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUSINESSTRANSACTIONTYPE, FINANCIALMANAGEMENTAREA, FINMGMTAREAFISCALYEAR, FUNDSMANAGEMENTDOCUMENT, FUNDSMANAGEMENTDOCUMENTITEM, FUNDSMGCARRYFORWARDLEVEL, FUNDSMGMTAMOUNTTYPE, FUNDSMGMTFINDOCITEM, FUNDSMGMTFINDOCNUMBER, FUNDSMGMTSEQUENCENUMBER, FUNDSMGMTTRANSACTIONNUMBER, FUNDSMGMTVALUETYPE, ISSTATISTICALITEM, LEDGER, PROFITCENTER)
);

Learn More