I_BudgetEntryPeriod14

DDL: I_BUDGETENTRYPERIOD14 SQL: IFMBDGECD14 Type: view COMPOSITE

Bdgt Entry Change Doc Items in Period 14

I_BudgetEntryPeriod14 is a Composite CDS View that provides data about "Bdgt Entry Change Doc Items in Period 14" 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 IFMBDGECD14 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 14 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 Perd14BdgtAmtInTransacCrcy Transactn curr.
BudgetAmountInFMACrcy I_BudgetChangeDocumentBasic Period14BudgetAmountInFMACrcy 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_BudgetEntryPeriod14.
-- 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: IFMBDGECD14

CREATE VIEW I_BudgetEntryPeriod14 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.Perd14BdgtAmtInTransacCrcy AS BudgetAmountInTransactionCrcy,
  Bdgt.Period14BudgetAmountInFMACrcy AS BudgetAmountInFMACrcy,
  '014' 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
;