I_CurrentBudgetPerBdgtType

DDL: I_CURRENTBUDGETPERBDGTTYPE SQL: IFMCURRBDGT Type: view COMPOSITE
20 Fields 1 Data Sources 3 Associations

Current Budget for Posted Value

I_CurrentBudgetPerBdgtType is a Composite CDS View that provides data about "Current Budget for Posted Value" in SAP S/4HANA. It reads from 1 data source (I_BdgtForPostdValPerBudgetType) and exposes 20 fields with key fields FinancialManagementArea, FinMgmtAreaFiscalYear, BudgetCategory, BudgetedFund, BudgetedFundsCenter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BdgtForPostdValPerBudgetType I_BdgtForPostdValPerBudgetType from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_FundsManagementKeyFigure _KeyFigureDefinition _KeyFigureDefinition.FundsMgmtKeyFigureID = 'CURRENT_BDGT_BT'
[0..1] I_Currency _Currency $projection.FinancialManagementAreaCrcy = _Currency.Currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFMCURRBDGT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Current Budget for Posted Value view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
KEY BudgetCategory BudgetCategory Plan Category
KEY BudgetedFund BudgetedFund Fund
KEY BudgetedFundsCenter BudgetedFundsCenter Funds Center
KEY BudgetedCommitmentItem BudgetedCommitmentItem Commitment Item
KEY BudgetedFunctionalArea BudgetedFunctionalArea Functional Area
KEY BudgetedGrantID BudgetedGrantID Grant
KEY BudgetedFundedProgram BudgetedFundedProgram Funded Program
KEY BudgetedBudgetPeriod BudgetedBudgetPeriod Budget Period
KEY BudgetedFundsMgmtCustomerField BudgetedFundsMgmtCustomerField Customer Field
KEY BdgtCashEffectivityFiscalYear BdgtCashEffectivityFiscalYear
KEY BudgetType BudgetType
KEY BudgetVersion BudgetVersion Version
KEY FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
BudgetAmountInFMACrcy
FundsMgmtKeyFigureAuthznGrp _KeyFigureDefinition FundsMgmtKeyFigureAuthznGrp
_FinMgmtArea _FinMgmtArea
_KeyFigureDefinition _KeyFigureDefinition
_Currency _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_CurrentBudgetPerBdgtType.
-- 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: IFMCURRBDGT

CREATE VIEW I_CurrentBudgetPerBdgtType AS
SELECT
  FinancialManagementArea,
  FinMgmtAreaFiscalYear,
  BudgetCategory,
  BudgetedFund,
  BudgetedFundsCenter,
  BudgetedCommitmentItem,
  BudgetedFunctionalArea,
  BudgetedGrantID,
  BudgetedFundedProgram,
  BudgetedBudgetPeriod,
  BudgetedFundsMgmtCustomerField,
  BdgtCashEffectivityFiscalYear,
  BudgetType,
  BudgetVersion,
  FinancialManagementAreaCrcy,
  BudgetAmountInFMACrcy * ( -1 ) AS BudgetAmountInFMACrcy,
  _KeyFigureDefinition.FundsMgmtKeyFigureAuthznGrp AS FundsMgmtKeyFigureAuthznGrp
FROM I_BdgtForPostdValPerBudgetType
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FundsManagementKeyFigure AS _KeyFigureDefinition ON _KeyFigureDefinition.FundsMgmtKeyFigureID = 'CURRENT_BDGT_BT'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON FinancialManagementAreaCrcy = _Currency.Currency  -- association [0..1]
;

Learn More