I_SupDmndComponentBasic

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_SupDmndComponentBasic.
-- 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_SupDmndComponentBasic AS
SELECT
  '' AS PurchasingDocument,
  '00000' AS PurchasingDocumentItem,
  resb.bdmng * DIV(resb.umrez,resb.umren) AS OpenDemandQuantity,
  resb.bdter AS RequirementDate,
  resb.sgt_rcat AS RequirementSegment,
  resb.matnr AS Material,
  resb.werks AS Plant,
  resb.lgort AS StorageLocation,
  resb.bdart AS RequirementType,
  resb.charg AS Batch,
  resb.meins AS BaseUnit,
  resb.umrez AS OrderItemQtyToBaseQtyNmrtr,
  resb.umren AS OrderItemQtyToBaseQtyDnmntr,
  resb.rsnum AS RequirementDocumentNumber,
  resb.rspos AS RequirementDocumentItem,
  resb.aufnr AS OrderID,
  resb.bdter AS RequestedDate,
  resb.bdter AS ProductAvailabilityDate,
  resb.sgt_scat AS StockSegment,
  item.fsh_season_year AS ProductSeasonYear,
  item.fsh_season AS ProductSeason,
  item.fsh_collection AS ProductCollection,
  item.fsh_theme AS ProductTheme
FROM resb
INNER JOIN afpo AS item ON /* join condition not captured in parsed metadata */
;