C_InvtryTurnoverTimeSers

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 C_InvtryTurnoverTimeSers.
-- 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.
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_PeriodType : char_01

CREATE VIEW C_InvtryTurnoverTimeSers AS
SELECT
  series.StartDate AS StartDate,
  series.EndDate AS EndDate,
  series.Material AS Material,
  series.Plant AS Plant,
  series.MaterialBaseUnit AS MaterialBaseUnit,
  case when _MatlDocArchivingDate.LatestMatlDocArchivingDate >= $parameters.P_StartDate then _MatlDocArchivingDate.LatestMatlDocArchivingDate else cast('00010101' as abap.dats) end as LatestMatlDocArchivingDate AS datsendasLatestMatlDocArchivingDate,
  cast( MatlWrhsStkQtyInMatlBaseUnit as invtryto_mat_stk_qty) AS MatlWrhsStkQtyInMatlBaseUnit,
  cast (MatlCnsmpnQtyInMatlBaseUnit as invtryto_mat_cons_qty) AS MatlCnsmpnQtyInMatlBaseUnit,
  cast(MatlStkDecrQtyInMatlBaseUnit as invtryto_stk_decr) AS MatlStkDecrQtyInMatlBaseUnit,
  cast(MatlStkIncrQtyInMatlBaseUnit as invtryto_stk_incr) AS MatlStkIncrQtyInMatlBaseUnit,
  Currency,
  MatlStkAmountInCompanyCrcy,
  CompanyCode
FROM P_InvtryTurnoverTmeSersAggrgnC
LEFT OUTER JOIN I_MatlDocArchivingDate AS _MatlDocArchivingDate ON Material = _MatlDocArchivingDate.StockIdentifyingMaterial AND Plant = _MatlDocArchivingDate.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON MaterialBaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;