P_ProductStorageWD

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_ProductStorageWD.
-- 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: PPRDSTORAGEWD

CREATE VIEW P_ProductStorageWD AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS Draftkey,
  ActiveDocument.Product AS ActiveProduct,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS ParentDraftKey,
  ActiveDocument.Product AS Product,
  ActiveDocument.StorageConditions AS StorageConditions,
  ActiveDocument.TemperatureConditionInd AS TemperatureConditionInd,
  ActiveDocument.HazardousMaterialNumber AS HazardousMaterialNumber,
  ActiveDocument.NmbrOfGROrGISlipsToPrintQty AS NmbrOfGROrGISlipsToPrintQty,
  ActiveDocument.LabelType AS LabelType,
  ActiveDocument.LabelForm AS LabelForm,
  ActiveDocument.MinRemainingShelfLife AS MinRemainingShelfLife,
  ActiveDocument.ExpirationDate AS ExpirationDate,
  ActiveDocument.StorageBinInstruction AS StorageBinInstruction,
  ActiveDocument.TotalShelfLifeStoragePercent AS TotalShelfLifeStoragePercent,
  ActiveDocument.ShelfLifeExpirationDatePeriod AS ShelfLifeExpirationDatePeriod,
  ActiveDocument.ShelfLifeExprtnDateRndingRule AS ShelfLifeExprtnDateRndingRule,
  cast( 'X' as boole_d ) AS IsActiveEntity,
  cast( ' ' as boole_d ) AS HasActiveEntity,
  cast(DraftDocument.ParentDraftKey as sysuuid_x ) as DraftAdministrativeDataUUID AS DraftKeyasDraftKey,
  cast( ' ' as boole_d ) AS HasDraftEntity,
  cast(DraftDocument.ParentDraftKey as sysuuid_x ) AS DraftAdministrativeDataUUID
FROM I_Productstorage AS ActiveDocument
LEFT OUTER JOIN P_Productstoraged AS DraftDocument ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProductD AS DraftRootDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_DraftAdministrativeData AS DraftAdministrativeData ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Productstoraged
;