I_Productstorage

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_Productstorage.
-- 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_Productstorage AS
SELECT
  mara.matnr AS Product,
  mara.raube AS StorageConditions,
  mara.tempb AS TemperatureConditionInd,
  mara.stoff AS HazardousMaterialNumber,
  mara.wesch AS NmbrOfGROrGISlipsToPrintQty,
  mara.etiar AS LabelType,
  mara.etifo AS LabelForm,
  mara.mhdrz AS MinRemainingShelfLife,
  mara.sled_bbd AS ExpirationDate,
  mara.behvo AS StorageBinInstruction,
  mara.mhdlp AS TotalShelfLifeStoragePercent,
  cast(mara.iprkz as shelflifeexpirationdateperiod preserving type ) AS ShelfLifeExpirationDatePeriod,
  mara.rdmhd AS ShelfLifeExprtnDateRndingRule,
  mara.begru AS AuthorizationGroup,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  mara.mhdhb AS TotalShelfLife,
  mara.meins AS BaseUnit
FROM mara
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN E_Product AS _ProdStorageExt ON Product = _ProdStorageExt.Product  -- association [0..1]
LEFT OUTER JOIN I_Storagecondition AS _Storagecondition ON StorageConditions = _Storagecondition.StorageConditions  -- association [0..1]
LEFT OUTER JOIN I_Tempindcndn AS _TemperatureConditionInd ON TemperatureConditionInd = _TemperatureConditionInd.TemperatureConditionInd  -- association [0..1]
LEFT OUTER JOIN I_Tempindcndntext AS _TemperatureConditionText ON TemperatureConditionInd = _TemperatureConditionText.TemperatureConditionInd  -- association [0..*]
LEFT OUTER JOIN I_ShelfLifeExprtnDateRndngRule AS _ShelfLifeExprtnDateRndngRule ON ShelfLifeExprtnDateRndingRule = _ShelfLifeExprtnDateRndngRule.ShelfLifeExprtnDateRndngRule  -- association [0..1]
LEFT OUTER JOIN I_CtnRqmtsForProduct AS _StorageBinInstruction ON StorageBinInstruction = _StorageBinInstruction.StorageBinInstruction  -- association [0..1]
LEFT OUTER JOIN I_LabelForm AS _LabelForm ON LabelForm = _LabelForm.LabelForm  -- association [0..1]
LEFT OUTER JOIN I_ProdShelfLifeExprtnDtePerdVH AS _ShelfLifeExpirationDatePeriod ON ShelfLifeExpirationDatePeriod = _ShelfLifeExpirationDatePeriod.ShelfLifeExpirationDatePeriod  -- association [0..1]
LEFT OUTER JOIN I_LabelType AS _LabelType ON LabelType = _LabelType.LabelType  -- association [0..1]
LEFT OUTER JOIN I_ProductExpirationDateCode AS _ProductExpirationDateCode ON ExpirationDate = _ProductExpirationDateCode.ProductExpirationDateCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;