I_BUDGETCHANGEDOCUMENTBASIC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA