Sadl_Rs_Temporal_Budget

DDL: SADL_RS_BUDGET SQL: SADLRSBUDGET Type: view
5 Fields 1 Data Sources 1 Associations

Temporal Budget

Sadl_Rs_Temporal_Budget is a CDS View that provides data about "Temporal Budget" in SAP S/4HANA. It reads from 1 data source (Sadl_Rs_I_Budget) and exposes 5 fields with key fields department, validfrom. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
Sadl_Rs_I_Budget Sadl_Rs_I_Budget from

Associations (1)

CardinalityTargetAliasCondition
[1..*] Sadl_Rs_Temporal_Department _Department _Department.identifier = $projection.department

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSBUDGET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Temporal Budget view
Consumption.filter.businessDate.at false view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY department department Department
KEY validfrom validfrom Vers.Valid From
validto validto Vers.Valid To
budget budget Periodicity Budget
_Department _Department

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 Sadl_Rs_Temporal_Budget.
-- 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: SADLRSBUDGET

CREATE VIEW Sadl_Rs_Temporal_Budget AS
SELECT
  department,
  validfrom,
  validto,
  budget
FROM Sadl_Rs_I_Budget
LEFT OUTER JOIN Sadl_Rs_Temporal_Department AS _Department ON _Department.identifier = department  -- association [1..*]
;

Learn More