I_BDGTENTRANDCHGDOCWTHPERDBSC

CDS View

Budget Entry and Change Doc Items Basic

I_BDGTENTRANDCHGDOCWTHPERDBSC is a CDS View in S/4HANA. Budget Entry and Change Doc Items Basic. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BudgetEntrAndChgDocWthPeriod view from COMPOSITE Budget Entry and Change Document Items

Fields (32)

KeyField CDS FieldsUsed in Views
KEY BudgetCategory BudgetCategory 1
KEY BudgetChangeDocument BudgetChangeDocument 1
KEY BudgetChangeDocumentItem BudgetChangeDocumentItem 1
KEY FinancialManagementArea FinancialManagementArea 1
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear 1
KEY FinMgmtAreaPeriod FinMgmtAreaPeriod 1
BdgtCashEffectivityFiscalYear BdgtCashEffectivityFiscalYear 1
BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
BudgetAmountInTransactionCrcy BudgetAmountInTransactionCrcy 1
BudgetChangeDocCreationDate BudgetChangeDocCreationDate 1
BudgetedBudgetPeriod BudgetedBudgetPeriod 1
BudgetedCommitmentItem BudgetedCommitmentItem 1
BudgetedFunctionalArea BudgetedFunctionalArea 1
BudgetedFund BudgetedFund 1
BudgetedFundedProgram BudgetedFundedProgram 1
BudgetedFundsCenter BudgetedFundsCenter 1
BudgetedFundsMgmtCustomerField BudgetedFundsMgmtCustomerField 1
BudgetedGrantID BudgetedGrantID 1
BudgetType BudgetType 1
BudgetValueType BudgetValueType 1
BudgetVersion BudgetVersion 1
BudgetWorkFlowStatus BudgetWorkFlowStatus 1
CommitmentItemCategory CommitmentItemCategory 1
FinancialManagementAreaCrcy FinancialManagementAreaCrcy 1
InternalBudgetingProcess InternalBudgetingProcess 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 1
ReferenceDocumentItem ReferenceDocumentItem 1
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
ReferenceDocumentType ReferenceDocumentType 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.

-- Budget Entry and Change Doc Items Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BDGTENTRANDCHGDOCWTHPERDBSC (
    BUDGETCATEGORY,
    BUDGETCHANGEDOCUMENT,
    BUDGETCHANGEDOCUMENTITEM,
    FINANCIALMANAGEMENTAREA,
    FINMGMTAREAFISCALYEAR,
    FINMGMTAREAPERIOD,
    BDGTCASHEFFECTIVITYFISCALYEAR,
    BUDGETAMOUNTINFMACRCY,
    BUDGETAMOUNTINTRANSACTIONCRCY,
    BUDGETCHANGEDOCCREATIONDATE,
    BUDGETEDBUDGETPERIOD,
    BUDGETEDCOMMITMENTITEM,
    BUDGETEDFUNCTIONALAREA,
    BUDGETEDFUND,
    BUDGETEDFUNDEDPROGRAM,
    BUDGETEDFUNDSCENTER,
    BUDGETEDFUNDSMGMTCUSTOMERFIELD,
    BUDGETEDGRANTID,
    BUDGETTYPE,
    BUDGETVALUETYPE,
    BUDGETVERSION,
    BUDGETWORKFLOWSTATUS,
    COMMITMENTITEMCATEGORY,
    FINANCIALMANAGEMENTAREACRCY,
    INTERNALBUDGETINGPROCESS,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUDGETCATEGORY, BUDGETCHANGEDOCUMENT, BUDGETCHANGEDOCUMENTITEM, FINANCIALMANAGEMENTAREA, FINMGMTAREAFISCALYEAR, FINMGMTAREAPERIOD)
);