I_FUNDSMGMTCTRLGDOCUMENTITEM

CDS View
47 Fields 4 CDS Views

FM Controlling Document Item

I_FUNDSMGMTCTRLGDOCUMENTITEM is a CDS View in S/4HANA. FM Controlling Document Item. It contains 47 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_FundsMgmtCtrlgDocItmCube view from COMPOSITE Funds Mgmt Controlling Items - Cube
P_FundsMgmtJournalEntryItem view union_all COMPOSITE

Fields (47)

KeyField CDS FieldsUsed in Views
KEY BusinessTransactionType BusinessTransactionType 3
KEY FinancialManagementArea FinancialManagementArea 1
KEY FundsMgCarryForwardLevel FundsMgCarryForwardLevel 3
KEY FundsMgmtAmountType FundsMgmtAmountType 3
KEY FundsMgmtCtrlgDocumentItem FundsMgmtCtrlgDocumentItem 1
KEY FundsMgmtLongSequenceNumber FundsMgmtLongSequenceNumber 1
KEY FundsMgmtValueType FundsMgmtValueType 3
KEY IsStatisticalItem IsStatisticalItem 3
KEY Ledger Ledger 3
KEY ProfitCenter FndsMgmtRptgPrftCtrForHier,ProfitCenter 2
_FinMgmtArea _FinMgmtArea 1
_LogicalSystem _LogicalSystem 1
_ReferenceDocumentType _ReferenceDocumentType 1
_TransactionCurrency _TransactionCurrency 1
BudgetPeriodAuthznGrp BudgetPeriodAuthznGrp 1
BusinessArea BusinessArea 3
CmtmtItemFinMgmtAreaForAuthzn CmtmtItemFinMgmtAreaForAuthzn 1
CommitmentItemAuthznGrp CommitmentItemAuthznGrp 1
CompanyCode CompanyCode 3
ControllingArea ControllingArea 2
FinancialManagementAreaCrcy FinancialManagementAreaCrcy 1
FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear 1
FinMgmtAreaPeriod FinMgmtAreaPeriod 3
FndsCenterFinMgmtAreaForAuthzn FndsCenterFinMgmtAreaForAuthzn 1
FunctionalAreaAuthznGrp FunctionalAreaAuthznGrp 1
FundAuthznGrp FundAuthznGrp 1
FundedPgmFinMgmtAreaForAuthzn FundedPgmFinMgmtAreaForAuthzn 1
FundedProgramAuthznGrp FundedProgramAuthznGrp 1
FundFinMgmtAreaForAuthzn FundFinMgmtAreaForAuthzn 1
FundsCenterAuthznGrp FundsCenterAuthznGrp 1
FundsManagementStatisticalType FundsManagementStatisticalType 1
GLAccount GLAccount 3
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
ReferenceDocument ControllingDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 1
Segment FndsMgmtRptgSegmentForHier,Segment 2
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 Controlling Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FUNDSMGMTCTRLGDOCUMENTITEM (
    BUSINESSTRANSACTIONTYPE,
    FINANCIALMANAGEMENTAREA,
    FUNDSMGCARRYFORWARDLEVEL,
    FUNDSMGMTAMOUNTTYPE,
    FUNDSMGMTCTRLGDOCUMENTITEM,
    FUNDSMGMTLONGSEQUENCENUMBER,
    FUNDSMGMTVALUETYPE,
    ISSTATISTICALITEM,
    LEDGER,
    PROFITCENTER,
    _FINMGMTAREA,
    _LOGICALSYSTEM,
    _REFERENCEDOCUMENTTYPE,
    _TRANSACTIONCURRENCY,
    BUDGETPERIODAUTHZNGRP,
    BUSINESSAREA,
    CMTMTITEMFINMGMTAREAFORAUTHZN,
    COMMITMENTITEMAUTHZNGRP,
    COMPANYCODE,
    CONTROLLINGAREA,
    FINANCIALMANAGEMENTAREACRCY,
    FINMGMTAREAFISCALYEAR,
    FINMGMTAREAPERIOD,
    FNDSCENTERFINMGMTAREAFORAUTHZN,
    FUNCTIONALAREAAUTHZNGRP,
    FUNDAUTHZNGRP,
    FUNDEDPGMFINMGMTAREAFORAUTHZN,
    FUNDEDPROGRAMAUTHZNGRP,
    FUNDFINMGMTAREAFORAUTHZN,
    FUNDSCENTERAUTHZNGRP,
    FUNDSMANAGEMENTSTATISTICALTYPE,
    GLACCOUNT,
    GRANTAUTHZNGRP,
    GRANTLIFECYCLESTATUS,
    POSTEDBUDGETPERIOD,
    POSTEDCOMMITMENTITEM,
    POSTEDFUNCTIONALAREA,
    POSTEDFUND,
    POSTEDFUNDEDPROGRAM,
    POSTEDFUNDSCENTER,
    POSTEDGRANTID,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    SEGMENT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUSINESSTRANSACTIONTYPE, FINANCIALMANAGEMENTAREA, FUNDSMGCARRYFORWARDLEVEL, FUNDSMGMTAMOUNTTYPE, FUNDSMGMTCTRLGDOCUMENTITEM, FUNDSMGMTLONGSEQUENCENUMBER, FUNDSMGMTVALUETYPE, ISSTATISTICALITEM, LEDGER, PROFITCENTER)
);

Learn More