C_ProductPlantESPP

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_ProductPlantESPP.
-- 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 C_ProductPlantESPP AS
SELECT
  Product,
  Plant,
  ESPPIsUsed,
  ProductAlertRelevanceCode,
  LocProdGoodsReceiptProcHours,
  LocProdGoodsRcptProcHoursCalc,
  LocProdGoodsIssueProcHours,
  LocProdGoodsIssueProcHoursCalc,
  SrvcPartsThroughputTimeDurn,
  SrvcPartsThroughputTmeDurnCalc,
  ThirdPartyOrderProcessing,
  ParLocSafetyStockQuantity,
  RepairSafetyStockQuantity,
  VCLSafetyStockQuantity,
  VCLParLocSafetyStockQuantity,
  VCLRepairSafetyStockQuantity,
  VCLReorderPointQuantity,
  VCLMaximumStockQuantity,
  CostFactorForStockHoldingVal,
  ProductProcurementCostsVal,
  GoodsReceiptHandlingCost,
  GoodsIssueHandlingCost,
  BaseUnit,
  cast ('' as goodsreceiptdurationunit ) AS GoodsReceiptDurationUnit,
  cast ('' as goodsissueprocgdurationunit ) AS GoodsIssueProcgDurationUnit,
  cast ('' as msehi ) AS SrvcPartsThroughputTmeDurnUnit
FROM I_ProductPlantESPPTP
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productplant AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductAlertText AS _ProductAlertRelevanceCodeText ON ProductAlertRelevanceCode = _ProductAlertRelevanceCodeText.ProductAlert  -- association [0..*]
LEFT OUTER JOIN I_ThirdPartyOrderProcessingT AS _ThirdPartyOrderProcessingText ON ThirdPartyOrderProcessing = _ThirdPartyOrderProcessingText.ThirdPartyOrderProcessing  -- association [0..*]
;