I_ProdPlntInptAssistant

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_ProdPlntInptAssistant.
-- 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: IPRDPLNTIA

CREATE VIEW I_ProdPlntInptAssistant AS
SELECT
  mara.matnr AS Product,
  v_marc_md.werks AS Plant,
  mtart AS ProductType,
  matkl AS ProductGroup,
  meins AS BaseUnit,
  begru AS AuthorizationGroup,
  dismm AS MRPType,
  dispo AS MRPController,
  disgr AS MRPGroup,
  disls AS LotSizingProcedure,
  bstmi AS MinimumLotSizeQuantity,
  fxhor AS PlanningTimeFence,
  shzet AS SafetyDuration,
  webaz AS GoodsReceiptDuration
FROM v_marc_md
INNER JOIN mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitOfMeasureText ON BaseUnit = _BaseUnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_Producttype AS _ProductType ON ProductType = _ProductType.ProductType  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeName ON ProductType = _ProductTypeName.ProductType  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON ProductGroup = _ProductGroupText.ProductGroup  -- association [0..*]
;