I_EWM_PInvCountDynFldSel_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 I_EWM_PInvCountDynFldSel_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.

CREATE VIEW I_EWM_PInvCountDynFldSel_2 AS
SELECT
  lgnum AS EWMWarehouse,
  pi_area AS PhysicalInventoryArea,
  pi_itm_number AS PInvItmNumberIsDspd,
  bin AS StorageBinIsDspd,
  bin_empty AS StorageBinEmptyIsDspd,
  sub_hu AS NestedHndlgUnitIsDspd,
  sub_hu_complete AS NestedHndlgUnitCmpltIsDspd,
  sub_hu_missing AS NestedHndlgUnitMisgIsDspd,
  sub_hu_empty AS NestedHndlgUnitEmptyIsDspd,
  hu AS HandlingUnitIsDspd,
  hu_complete AS HndlgUnitCompleteIsDspd,
  hu_missing AS HndlgUnitMissingIsDspd,
  hu_empty AS HndlgUnitEmptyIsDspd,
  productid AS ProductIDIsDspd,
  product_desc AS ProductDescIsDspd,
  batch AS BatchIsDspd,
  owner AS OwnerIsDspd,
  owner_desc AS OwnerNameIsDspd,
  entitled AS EntitledToDisposePtyIsDspd,
  entitled_desc AS EntitledToDisposePtyNameIsDspd,
  stock_type AS StockTypeIsDspd,
  stock_type_desc AS StockTypeTextIsDspd,
  stock_usage AS StockUsageIsDspd,
  stock_usage_desc AS StockUsageTextIsDspd,
  special_stock_type AS SpecialStockTypeIsDspd,
  special_stock_type_desc AS SpecialStockTypeTextIsDspd,
  special_stock_ext_no AS SpecialStockExtNoIsDspd,
  special_stock_ext_itm_no AS SpecialStockExtItmNoIsDspd,
  country_of_origin AS CountryOfOriginIsDspd,
  coo_desc AS CountryOfOriginNameIsDspd,
  sled AS ShelfLifeExprtnDateIsDspd,
  gr_date AS GoodsReceiptDateIsDspd,
  quantity AS ProductQuantityIsDspd,
  uom AS ProductUoMIsDspd,
  bookqtyflg AS BookQuantityIsDspd,
  bookuomflg AS BookQuantityUoMIsDspd
FROM /scwm/tformfld
;