I_BUDGETCHANGEDOCUMENTBASIC

CDS View

Budget Change Document

I_BUDGETCHANGEDOCUMENTBASIC is a CDS View in S/4HANA. Budget Change Document. It contains 65 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_BudgetEntryPeriod01 view from COMPOSITE Bdgt Entry Change Doc Items in Period 01
I_BudgetEntryPeriod02 view from COMPOSITE Bdgt Entry Change Doc Items in Period 02
I_BudgetEntryPeriod03 view from COMPOSITE Bdgt Entry Change Doc Items in Period 3
I_BudgetEntryPeriod04 view from COMPOSITE Bdgt Entry Change Doc Items in Period 4
I_BudgetEntryPeriod05 view from COMPOSITE Bdgt Entry Change Doc Items in Period 5
I_BudgetEntryPeriod06 view from COMPOSITE Bdgt Entry Change Doc Items in Period 6
I_BudgetEntryPeriod07 view from COMPOSITE Bdgt Entry Change Doc Items in Period 7
I_BudgetEntryPeriod08 view from COMPOSITE Bdgt Entry Change Doc Items in Period 8
I_BudgetEntryPeriod09 view from COMPOSITE Bdgt Entry Change Doc Items in Period 9
I_BudgetEntryPeriod10 view from COMPOSITE Bdgt Entry Change Doc Items in Period 10
I_BudgetEntryPeriod11 view from COMPOSITE Bdgt Entry Change Doc Items in Period 11
I_BudgetEntryPeriod12 view from COMPOSITE Bdgt Entry Change Doc Items in Period 12
I_BudgetEntryPeriod13 view from COMPOSITE Bdgt Entry Change Doc Items in Period 13
I_BudgetEntryPeriod14 view from COMPOSITE Bdgt Entry Change Doc Items in Period 14
I_BudgetEntryPeriod15 view from COMPOSITE Bdgt Entry Change Doc Items in Period 15
I_BudgetEntryPeriod16 view from COMPOSITE Bdgt Entry Change Doc Items in Period 16

Fields (65)

KeyField CDS FieldsUsed in Views
KEY BudgetCategory BudgetCategory 16
KEY BudgetChangeDocument BudgetChangeDocument 16
KEY BudgetChangeDocumentItem BudgetChangeDocumentItem 16
KEY FinancialManagementArea FinancialManagementArea 16
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear 16
_Currency _Currency 16
_FinMgmtArea _FinMgmtArea 16
_TransactionCurrency _TransactionCurrency 16
BdgtCashEffectivityFiscalYear BdgtCashEffectivityFiscalYear 16
BudgetChangeDocCreationDate BudgetChangeDocCreationDate 16
BudgetedBudgetPeriod BudgetedBudgetPeriod 16
BudgetedCommitmentItem BudgetedCommitmentItem 16
BudgetedFunctionalArea BudgetedFunctionalArea 16
BudgetedFund BudgetedFund 16
BudgetedFundedProgram BudgetedFundedProgram 16
BudgetedFundsCenter BudgetedFundsCenter 16
BudgetedFundsMgmtCustomerField BudgetedFundsMgmtCustomerField 16
BudgetedGrantID BudgetedGrantID 16
BudgetType BudgetType 16
BudgetValueType BudgetValueType 16
BudgetVersion BudgetVersion 16
BudgetWorkFlowStatus BudgetWorkFlowStatus 16
CommitmentItemCategory CommitmentItemCategory 16
CommitmentItemFiscalYear CommitmentItemFiscalYear 16
FinancialManagementAreaCrcy FinancialManagementAreaCrcy 16
InternalBudgetingProcess InternalBudgetingProcess 16
Perd01BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd02BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd03BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd04BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd05BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd06BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd07BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd08BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd09BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd10BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd11BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd12BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd13BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd14BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd15BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Perd16BdgtAmtInTransacCrcy BudgetAmountInTransactionCrcy 1
Period01BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period02BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period03BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period04BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period05BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period06BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period07BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period08BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period09BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period10BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period11BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period12BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period13BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period14BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period15BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
Period16BudgetAmountInFMACrcy BudgetAmountInFMACrcy 1
ReferenceDocument ReferenceDocument 16
ReferenceDocumentContext ReferenceDocumentContext 16
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 16
ReferenceDocumentItem ReferenceDocumentItem 16
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 16
ReferenceDocumentType ReferenceDocumentType 16
TransactionCurrency TransactionCurrency 16

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 Change Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUDGETCHANGEDOCUMENTBASIC (
    BUDGETCATEGORY,
    BUDGETCHANGEDOCUMENT,
    BUDGETCHANGEDOCUMENTITEM,
    FINANCIALMANAGEMENTAREA,
    FINMGMTAREAFISCALYEAR,
    _CURRENCY,
    _FINMGMTAREA,
    _TRANSACTIONCURRENCY,
    BDGTCASHEFFECTIVITYFISCALYEAR,
    BUDGETCHANGEDOCCREATIONDATE,
    BUDGETEDBUDGETPERIOD,
    BUDGETEDCOMMITMENTITEM,
    BUDGETEDFUNCTIONALAREA,
    BUDGETEDFUND,
    BUDGETEDFUNDEDPROGRAM,
    BUDGETEDFUNDSCENTER,
    BUDGETEDFUNDSMGMTCUSTOMERFIELD,
    BUDGETEDGRANTID,
    BUDGETTYPE,
    BUDGETVALUETYPE,
    BUDGETVERSION,
    BUDGETWORKFLOWSTATUS,
    COMMITMENTITEMCATEGORY,
    COMMITMENTITEMFISCALYEAR,
    FINANCIALMANAGEMENTAREACRCY,
    INTERNALBUDGETINGPROCESS,
    PERD01BDGTAMTINTRANSACCRCY,
    PERD02BDGTAMTINTRANSACCRCY,
    PERD03BDGTAMTINTRANSACCRCY,
    PERD04BDGTAMTINTRANSACCRCY,
    PERD05BDGTAMTINTRANSACCRCY,
    PERD06BDGTAMTINTRANSACCRCY,
    PERD07BDGTAMTINTRANSACCRCY,
    PERD08BDGTAMTINTRANSACCRCY,
    PERD09BDGTAMTINTRANSACCRCY,
    PERD10BDGTAMTINTRANSACCRCY,
    PERD11BDGTAMTINTRANSACCRCY,
    PERD12BDGTAMTINTRANSACCRCY,
    PERD13BDGTAMTINTRANSACCRCY,
    PERD14BDGTAMTINTRANSACCRCY,
    PERD15BDGTAMTINTRANSACCRCY,
    PERD16BDGTAMTINTRANSACCRCY,
    PERIOD01BUDGETAMOUNTINFMACRCY,
    PERIOD02BUDGETAMOUNTINFMACRCY,
    PERIOD03BUDGETAMOUNTINFMACRCY,
    PERIOD04BUDGETAMOUNTINFMACRCY,
    PERIOD05BUDGETAMOUNTINFMACRCY,
    PERIOD06BUDGETAMOUNTINFMACRCY,
    PERIOD07BUDGETAMOUNTINFMACRCY,
    PERIOD08BUDGETAMOUNTINFMACRCY,
    PERIOD09BUDGETAMOUNTINFMACRCY,
    PERIOD10BUDGETAMOUNTINFMACRCY,
    PERIOD11BUDGETAMOUNTINFMACRCY,
    PERIOD12BUDGETAMOUNTINFMACRCY,
    PERIOD13BUDGETAMOUNTINFMACRCY,
    PERIOD14BUDGETAMOUNTINFMACRCY,
    PERIOD15BUDGETAMOUNTINFMACRCY,
    PERIOD16BUDGETAMOUNTINFMACRCY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REFERENCEDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUDGETCATEGORY, BUDGETCHANGEDOCUMENT, BUDGETCHANGEDOCUMENTITEM, FINANCIALMANAGEMENTAREA, FINMGMTAREAFISCALYEAR)
);