I_ProjectBudgetAnnualData

DDL: I_PROJECTBUDGETANNUALDATA Type: view_entity BASIC
10 Fields 1 Data Sources 1 Associations

Annual Budget data for Project

I_ProjectBudgetAnnualData is a Basic CDS View that provides data about "Annual Budget data for Project" in SAP S/4HANA. It reads from 1 data source (bpja) and exposes 10 fields with key fields ProjectObjectNode, ControllingValueType, FiscalYear, ProjectBudgetType, TransactionCurrency. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
bpja bpja from

Associations (1)

CardinalityTargetAliasCondition
[1] I_ProjectBudgetPlanningLedger _PlanningLedger _PlanningLedger.ProjectBudgetPlanningLedger = bpja.lednr

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Annual Budget data for Project view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectNode objnr Val. Obj. No.
KEY ControllingValueType wrttp Value Type
KEY FiscalYear Settlement Year
KEY ProjectBudgetType vorga Transfer proc.
KEY TransactionCurrency Trans. Currency
AmountInTransactionCurrency wtjhr Year
ProjectAmountInLedgerCurrency wljhr Year
DistrdAmtInTransactionCurrency wtjhv Year
ProjDistrdAmtInLedgerCurrency wljhv Year
GLAccountCurrency _PlanningLedger GLAccountCurrency 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_ProjectBudgetAnnualData.
-- 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.

CREATE VIEW I_ProjectBudgetAnnualData AS
SELECT
  objnr AS ProjectObjectNode,
  wrttp AS ControllingValueType,
  cast(gjahr as fis_gjahr_no_conv) AS FiscalYear,
  vorga AS ProjectBudgetType,
  cast(twaer as twaer preserving type) AS TransactionCurrency,
  wtjhr AS AmountInTransactionCurrency,
  wljhr AS ProjectAmountInLedgerCurrency,
  wtjhv AS DistrdAmtInTransactionCurrency,
  wljhv AS ProjDistrdAmtInLedgerCurrency,
  _PlanningLedger.GLAccountCurrency AS GLAccountCurrency
FROM bpja
LEFT OUTER JOIN I_ProjectBudgetPlanningLedger AS _PlanningLedger ON _PlanningLedger.ProjectBudgetPlanningLedger = bpja.lednr  -- association [1]
;

Learn More