C_EWM_PInvCountItem_2

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_EWM_PInvCountItem_2.
-- 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.
-- Parameters: P_Language : sylangu

CREATE VIEW C_EWM_PInvCountItem_2 AS
SELECT
  item.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  item.PhysicalInventoryItemNumber AS PhysicalInventoryItemNumber,
  item.LineIndexOfPInvItem AS LineIndexOfPInvItem,
  item.PhysicalInventoryChangeVersion AS PhysicalInventoryChangeVersion,
  item.PInvDocumentItemType AS PInvDocumentItemType,
  _PInvDoc.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  _PInvDoc.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  item.EWMWarehouse AS EWMWarehouse,
  item.WarehouseOrder AS WarehouseOrder,
  item.ActivityArea AS ActivityArea,
  item.PhysicalInventoryArea AS PhysicalInventoryArea,
  item.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  item.WhseTaskGoodsReceiptDateTime AS WhseTaskGoodsReceiptDateTime,
  item.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  item.CountryOfOrigin AS CountryOfOrigin,
  _CountryText.CountryName AS CountryName,
  item.EntitledToDisposeParty AS EntitledToDisposeParty,
  _Entitled.BusinessPartnerName AS NameOfEntitledToDisposeParty,
  item.EWMStockOwner AS EWMStockOwner,
  _StockOwner.BusinessPartnerName AS StockOwnerName,
  item.EWMStockType AS EWMStockType,
  case when _StockTypeText.EWMStockTypeName is not null then _StockTypeText.EWMStockTypeName else _WhseIndepText.EWMStockTypeName end as EWMStockTypeName AS EWMStockTypeNameendasEWMStockTypeName,
  item.EWMStockUsage AS EWMStockUsage,
  _StockUsageText.StockUsageName AS StockUsageName,
  item.StockDocumentCategory AS StockDocumentCategory,
  _SpclStkTypeText.StockDocCategoryText AS StockDocCategoryText,
  item.StockItemNumber AS StockItemNumber,
  item.Product AS Product,
  _ProductText.ProductName AS ProductName,
  item.Batch AS Batch,
  item.EWMStorageBin AS EWMStorageBin,
  cast ( item.HandlingUnitNumber as ewm_de_hu_no_conv ) AS HandlingUnitNumber,
  cast ( item.NestedHandingUnitNumber as ewm_de_hu_no_conv ) AS NestedHandingUnitNumber,
  item.SequenceOfPInvDocumentItems AS SequenceOfPInvDocumentItems,
  item.BookQuantityUnitOfMeasure AS BookQuantityUnitOfMeasure,
  item.BookQtyOfPInvItemInBookQtyUoM AS BookQtyOfPInvItemInBookQtyUoM,
  item.BookQuantityUnitOfMeasure AS EnteredUoMOfPInv,
  '' AS EWMStorageBinIsEmpty,
  '' AS HandlingUnitIsComplete,
  '' AS HandlingUnitIsMissing,
  '' AS HandlingUnitIsEmpty,
  '' AS NestedHndlgUnitIsComplete,
  '' AS NestedHndlgUnitIsMissing,
  '' AS NestedHndlgUnitIsEmpty,
  _StockOwner.IsBusinessPurposeCompleted AS EWMOwnerIsBusPurposeCmpltd,
  _Entitled.IsBusinessPurposeCompleted AS EWMEntitledIsBusPurposeCmpltd
FROM P_EWM_PINVCOUNTITEM08 AS item
LEFT OUTER JOIN I_EWM_PInvDocHeaderLog AS _PInvDoc ON PhysicalInventoryDocumentUUID = _PInvDoc.PhysicalInventoryDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _StockOwner ON EWMStockOwner = _StockOwner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Entitled ON EntitledToDisposeParty = _Entitled.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_StockTypeText_2 AS _StockTypeText ON EWMStockType = _StockTypeText.EWMStockType AND EWMWarehouse = _StockTypeText.EWMWarehouse AND _StockTypeText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseIndepStockTypeText_2 AS _WhseIndepText ON EWMStockType = _WhseIndepText.EWMStockType AND _WhseIndepText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_EWM_StockUsageText_2 AS _StockUsageText ON EWMStockUsage = _StockUsageText.EWMStockUsage AND _StockUsageText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON CountryOfOrigin = _CountryText.Country AND _CountryText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_EWM_SpecialStockTypeText AS _SpclStkTypeText ON StockDocumentCategory = _SpclStkTypeText.StockDocumentCategory AND _SpclStkTypeText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN E_EWM_PhysicalInventoryDoc AS _Extension ON PhysicalInventoryDocumentUUID = _Extension.PhysicalInventoryDocumentUUID AND PhysicalInventoryItemNumber = _Extension.PhysicalInventoryItemNumber AND LineIndexOfPInvItem = _Extension.LineIndexOfPInvItem AND PhysicalInventoryChangeVersion = _Extension.PhysicalInventoryChangeVersion AND PInvDocumentItemType = _Extension.PInvDocumentItemType  -- association [0..1]
;