I_BudgetEntryPeriod08

DDL: I_BUDGETENTRYPERIOD08 SQL: IFMBDGECD08 Type: view COMPOSITE

Bdgt Entry Change Doc Items in Period 8

I_BudgetEntryPeriod08 is a Composite CDS View that provides data about "Bdgt Entry Change Doc Items in Period 8" in SAP S/4HANA. It reads from 1 data source (I_BudgetChangeDocumentBasic) and exposes 36 fields with key fields BudgetChangeDocument, FinMgmtAreaFiscalYear, FinancialManagementArea, BudgetCategory, BudgetChangeDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_BudgetChangeDocumentBasic Bdgt from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFMBDGECD08 view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bdgt Entry Change Doc Items in Period 8 view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY BudgetChangeDocument I_BudgetChangeDocumentBasic BudgetChangeDocument
KEY FinMgmtAreaFiscalYear I_BudgetChangeDocumentBasic FinMgmtAreaFiscalYear Fiscal Year
KEY FinancialManagementArea I_BudgetChangeDocumentBasic FinancialManagementArea FM Area
KEY BudgetCategory I_BudgetChangeDocumentBasic BudgetCategory Plan Category
KEY BudgetChangeDocumentItem I_BudgetChangeDocumentBasic BudgetChangeDocumentItem
BudgetedFund I_BudgetChangeDocumentBasic BudgetedFund Fund
BudgetedFundsCenter I_BudgetChangeDocumentBasic BudgetedFundsCenter Funds Center
BudgetedCommitmentItem I_BudgetChangeDocumentBasic BudgetedCommitmentItem Commitment Item
BudgetedFunctionalArea I_BudgetChangeDocumentBasic BudgetedFunctionalArea Functional Area
BudgetedGrantID I_BudgetChangeDocumentBasic BudgetedGrantID Grant
BudgetedFundedProgram I_BudgetChangeDocumentBasic BudgetedFundedProgram Funded Program
BudgetedBudgetPeriod I_BudgetChangeDocumentBasic BudgetedBudgetPeriod Budget Period
BudgetedFundsMgmtCustomerField I_BudgetChangeDocumentBasic BudgetedFundsMgmtCustomerField Customer Field
TransactionCurrency I_BudgetChangeDocumentBasic TransactionCurrency Transaction Currency
FinancialManagementAreaCrcy I_BudgetChangeDocumentBasic FinancialManagementAreaCrcy FM Area Currency
BudgetAmountInTransactionCrcy I_BudgetChangeDocumentBasic Perd08BdgtAmtInTransacCrcy Transactn curr.
BudgetAmountInFMACrcy I_BudgetChangeDocumentBasic Period08BudgetAmountInFMACrcy Total transactions in the period in local currency (curr 2)
FinMgmtAreaPeriod
CommitmentItemCategory I_BudgetChangeDocumentBasic CommitmentItemCategory Commitment Item Cat.
BdgtCashEffectivityFiscalYear I_BudgetChangeDocumentBasic BdgtCashEffectivityFiscalYear
BudgetValueType I_BudgetChangeDocumentBasic BudgetValueType BCS Value Type
BudgetWorkFlowStatus I_BudgetChangeDocumentBasic BudgetWorkFlowStatus Workflow Status
InternalBudgetingProcess I_BudgetChangeDocumentBasic InternalBudgetingProcess Budgeting Process
BudgetType I_BudgetChangeDocumentBasic BudgetType Budget Type
BudgetVersion I_BudgetChangeDocumentBasic BudgetVersion Version
BudgetChangeDocCreationDate I_BudgetChangeDocumentBasic BudgetChangeDocCreationDate
ReferenceDocument I_BudgetChangeDocumentBasic ReferenceDocument Reference Document
ReferenceDocumentFiscalYear I_BudgetChangeDocumentBasic ReferenceDocumentFiscalYear Year Cur.Period
ReferenceDocumentItem I_BudgetChangeDocumentBasic ReferenceDocumentItem Reference item
ReferenceDocumentType I_BudgetChangeDocumentBasic ReferenceDocumentType Reference Document Type
ReferenceDocumentContext I_BudgetChangeDocumentBasic ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem I_BudgetChangeDocumentBasic ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
CommitmentItemFiscalYear I_BudgetChangeDocumentBasic CommitmentItemFiscalYear Commit. Item FY
_TransactionCurrency I_BudgetChangeDocumentBasic _TransactionCurrency
_FinMgmtArea I_BudgetChangeDocumentBasic _FinMgmtArea
_Currency I_BudgetChangeDocumentBasic _Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BudgetEntryPeriod08.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFMBDGECD08

CREATE VIEW I_BudgetEntryPeriod08 AS
SELECT
  Bdgt.BudgetChangeDocument AS BudgetChangeDocument,
  Bdgt.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Bdgt.FinancialManagementArea AS FinancialManagementArea,
  Bdgt.BudgetCategory AS BudgetCategory,
  Bdgt.BudgetChangeDocumentItem AS BudgetChangeDocumentItem,
  Bdgt.BudgetedFund AS BudgetedFund,
  Bdgt.BudgetedFundsCenter AS BudgetedFundsCenter,
  Bdgt.BudgetedCommitmentItem AS BudgetedCommitmentItem,
  Bdgt.BudgetedFunctionalArea AS BudgetedFunctionalArea,
  Bdgt.BudgetedGrantID AS BudgetedGrantID,
  Bdgt.BudgetedFundedProgram AS BudgetedFundedProgram,
  Bdgt.BudgetedBudgetPeriod AS BudgetedBudgetPeriod,
  Bdgt.BudgetedFundsMgmtCustomerField AS BudgetedFundsMgmtCustomerField,
  Bdgt.TransactionCurrency AS TransactionCurrency,
  Bdgt.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  Bdgt.Perd08BdgtAmtInTransacCrcy AS BudgetAmountInTransactionCrcy,
  Bdgt.Period08BudgetAmountInFMACrcy AS BudgetAmountInFMACrcy,
  '008' AS FinMgmtAreaPeriod,
  Bdgt.CommitmentItemCategory AS CommitmentItemCategory,
  Bdgt.BdgtCashEffectivityFiscalYear AS BdgtCashEffectivityFiscalYear,
  Bdgt.BudgetValueType AS BudgetValueType,
  Bdgt.BudgetWorkFlowStatus AS BudgetWorkFlowStatus,
  Bdgt.InternalBudgetingProcess AS InternalBudgetingProcess,
  Bdgt.BudgetType AS BudgetType,
  Bdgt.BudgetVersion AS BudgetVersion,
  Bdgt.BudgetChangeDocCreationDate AS BudgetChangeDocCreationDate,
  Bdgt.ReferenceDocument AS ReferenceDocument,
  Bdgt.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  Bdgt.ReferenceDocumentItem AS ReferenceDocumentItem,
  Bdgt.ReferenceDocumentType AS ReferenceDocumentType,
  Bdgt.ReferenceDocumentContext AS ReferenceDocumentContext,
  Bdgt.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  Bdgt.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  Bdgt._TransactionCurrency AS _TransactionCurrency,
  Bdgt._FinMgmtArea AS _FinMgmtArea,
  Bdgt._Currency AS _Currency
FROM I_BudgetChangeDocumentBasic AS Bdgt
;