P_EWM_AvailableStock

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_EWM_AvailableStock.
-- 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 P_EWM_AvailableStock AS
SELECT
  EWMWarehouse,
  _Material.Product AS Product,
  Batch,
  EWMStockOwner,
  EntitledToDisposeParty,
  EWMStockType,
  EWMStockUsage,
  EWMDocumentCategory,
  StockDocumentCategory,
  HandlingUnitNumber AS HandlingUnitExternalID,
  EWMStorageBin,
  EWMResource,
  TranspUnitInternalNumber,
  EWMBatchIsInRestrictedUseStock,
  EWMStorageType,
  AvailableEWMStockQty,
  EWMStockQuantityBaseUnit,
  _UnitOfMeasure[1: UnitOfMeasure = EWMStockQuantityBaseUnit].UnitOfMeasureISOCode AS EWMStockQtyBaseUnitISOCode,
  StockKeepingAlternativeUoM,
  _UnitOfMeasure[1: UnitOfMeasure = StockKeepingAlternativeUoM].UnitOfMeasureISOCode AS StockKeepingAltvUnitISOCode,
  GoodsReceiptUTCDateTime,
  ShelfLifeExpirationDate,
  EWMStockIsBlockedForInventory,
  CountryOfOrigin,
  HandlingUnitOpenTaskInd AS EWMHUHasOpenWarehouseTask,
  WhseQualityInspectionType,
  _EWMQualityInspection_emb.QualityInspectionDocument AS QualityInspectionDocument,
  ParentHandlingUnitUUID,
  StockItemUUID
FROM P_EWM_AvailableStock_Base AS _AvailableStock
LEFT OUTER JOIN I_Product AS _Material ON _AvailableStock.ProductUUID = _Material.ProductUUID AND _Material.ProdSupChnMgmtUUID22 is not initial  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON _AvailableStock.StockDocumentCategory = 'PJS' AND _AvailableStock.StockDocumentNumber = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WBSElementDecentralized AS _WBSElementDecentralized ON _AvailableStock.StockDocumentCategory = 'PJS' AND _AvailableStock.WarehouseSystemIsDecentralized = 'X' AND _AvailableStock.StockDocumentNumber = _WBSElementDecentralized.StockDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON 1 = 1  -- association [0..*]
LEFT OUTER JOIN P_EWM_QltyInspectionEmbedded AS _EWMQualityInspection_emb ON _AvailableStock.QualityInspectionDocUUID = _EWMQualityInspection_emb.QualityInspectionDocUUID AND _AvailableStock.QualityInspecitionDocBin2Hex != '00000000000000000000000000000000'  -- association [0..1]
;