I_AllocTopDwnDistrSimulation

DDL: I_ALLOCTOPDWNDISTRSIMULATION SQL: ALOTDDSIMUL Type: view BASIC
5 Fields 1 Data Sources 1 Associations

TDD Simulation

I_AllocTopDwnDistrSimulation is a Basic CDS View that provides data about "TDD Simulation" in SAP S/4HANA. It reads from 1 data source (alloc_tdd_simul) and exposes 5 fields with key fields AllocationSimulationUUID, FiscalYearPeriod, AllocationSenderReferenceValue. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
alloc_tdd_simul alloc_tdd_simul from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AllocSndrRefValTxt _AllocSndrRefValTxt $projection.AllocationSenderReferenceValue = _AllocSndrRefValTxt.AllocationSenderReferenceValue

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ALOTDDSIMUL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
EndUserText.label TDD Simulation view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AllocationSimulationUUID uuid Waste Partner UUID
KEY FiscalYearPeriod Fiscal Year/Period
KEY AllocationSenderReferenceValue data_type Type
NumberOfItems cnt Number of Records
_AllocSndrRefValTxt _AllocSndrRefValTxt

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_AllocTopDwnDistrSimulation.
-- 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: ALOTDDSIMUL

CREATE VIEW I_AllocTopDwnDistrSimulation AS
SELECT
  uuid AS AllocationSimulationUUID,
  cast(fisperiod as fins_fyearperiod) AS FiscalYearPeriod,
  data_type AS AllocationSenderReferenceValue,
  cnt AS NumberOfItems
FROM alloc_tdd_simul
LEFT OUTER JOIN I_AllocSndrRefValTxt AS _AllocSndrRefValTxt ON AllocationSenderReferenceValue = _AllocSndrRefValTxt.AllocationSenderReferenceValue  -- association [0..*]
;

Learn More