P_SI4_TrainingData10

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 P_SI4_TrainingData10.
-- 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: PSDSI4TD10

CREATE VIEW P_SI4_TrainingData10 AS
SELECT
  YearMonth,
  PartOfMonth,
  SoldToParty,
  TD9.SalesOrganization AS SalesOrganization,
  DistributionChannel,
  TD9.Division AS Division,
  Material,
  MaterialGroup,
  CustomerGroup,
  cast( '' as md_customer_name ) AS CustomerName,
  C.CreatedByUser AS CreatedByUser,
  C.CustomerClassification AS CustomerClassification,
  C.CustomerAccountGroup AS CustomerAccountGroup,
  C.IsOneTimeAccount AS IsOneTimeAccount,
  C.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  C.Industry AS Industry,
  C.Country AS Country,
  C.CityName AS CityName,
  P.ProductType AS ProductType,
  SO.CompanyCode AS CompanyCode,
  SO.IntercompanyBillingCustomer AS IntercompanyBillingCustomer,
  PartOfQuarter,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  TargetAmount,
  CntByPOM AS CountByPOM,
  SumAmtByPOM,
  MaxAmtByPOM,
  MinAmtByPOM,
  CntByPOQ AS CountByPOQ,
  SumAmtByPOQ,
  MaxAmtByPOQ,
  MinAmtByPOQ,
  CntByPre1Month AS CountByPre1Month,
  SumAmtByPre1Month,
  MaxAmtByPre1Month,
  MinAmtByPre1Month,
  CntByPre1Quarter AS CountByPre1Quarter,
  SumAmtByPre1Quarter,
  MaxAmtByPre1Quarter,
  MinAmtByPre1Quarter,
  cast( CntByPOM - CntByPre1Month as int4) AS DiffCountByPOM,
  cast( SumAmtByPOM - SumAmtByPre1Month as netwr) AS DiffSumAmtByPOM,
  cast( MaxAmtByPOM - MaxAmtByPre1Month as netwr) AS DiffMaxAmtByPOM,
  cast( MinAmtByPOM - MinAmtByPre1Month as netwr) AS DiffMinAmtByPOM,
  cast( CntByPOQ - CntByPre1Quarter as int4) AS DiffCountByPOQ,
  cast( SumAmtByPOQ - SumAmtByPre1Quarter as netwr) AS DiffSumAmtByPOQ,
  cast( MaxAmtByPOQ - MaxAmtByPre1Quarter as netwr) AS DiffMaxAmtByPOQ,
  cast( MinAmtByPOQ - MinAmtByPre1Quarter as netwr) AS DiffMinAmtByPOQ,
  cast( 0 as netwr) AS AvgCountByPOM,
  cast( 0 as netwr) AS AvgCountByPOQ,
  cast( 0 as netwr) AS SumAmtByPre2Month,
  cast( 0 as netwr) AS SumAmtByPre3Month,
  cast( 0 as netwr) AS SumAmtByPre4Month,
  cast( 0 as netwr) AS SumAmtByPre5Month,
  cast( 0 as netwr) AS SumAmtByPre6Month,
  cast( 0 as netwr) AS DeltaAmtByMoM1,
  cast( 0 as netwr) AS DeltaAmtByMoM2,
  cast( 0 as netwr) AS DeltaAmtByMoM3,
  cast( 0 as netwr) AS DeltaAmtByMoM4,
  cast( 0 as netwr) AS DeltaAmtByMoM5,
  cast( 0 as netwr) AS DeltaAmtByMoM6,
  cast( 0 as netwr) AS DeltaAmtByYoY1,
  cast( 0 as netwr) AS DeltaAmtByYoY2,
  cast( 0 as netwr) AS DeltaAmtByYoY3,
  cast( 0 as netwr) AS DeltaAmtByYoY4,
  cast( 0 as netwr) AS DeltaAmtByYoY5,
  cast( 0 as netwr) AS DeltaAmtByYoY6,
  cast( 0 as netwr) AS AvgAmtByLast2Month,
  cast( 0 as netwr) AS AvgAmtByLast3Month,
  cast( 0 as netwr) AS SumAmtRatioByLast3Month1,
  cast( 0 as netwr) AS SumAmtRatioByLast3Month2,
  cast( 0 as netwr) AS SumAmtRatioByLast3Month3,
  cast( 0 as netwr) AS DiffAmtByPOM1,
  cast( 0 as netwr) AS DiffAmtByPOM2,
  Period.CurrentYearMonth AS CurrentYearMonth,
  Period.NextYearMonth AS NextYearMonth
FROM P_SI4_TrainingData09 AS TD9
LEFT OUTER JOIN I_Customer AS C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS P ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrganization AS SO ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SI4_Period AS Period ON /* join condition not captured in parsed metadata */
;