I_ProdEWMWarehouseTP

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_ProdEWMWarehouseTP.
-- 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: IEWMWAREHOUSETP

CREATE VIEW I_ProdEWMWarehouseTP AS
SELECT
  ProductEWMWarehouse.Product AS Product,
  ProductEWMWarehouse.Warehouse AS Warehouse,
  ProductEWMWarehouse.BusinessPartner AS BusinessPartner,
  ProductEWMWarehouse.Warehouse AS WarehouseForEdit,
  ProductEWMWarehouse.BusinessPartner AS BusinessPartnerForEdit,
  ProductEWMWarehouse.ProductUUID AS ProductUUID,
  ProductEWMWarehouse.SupplyChainUnitUUID AS SupplyChainUnitUUID,
  ProductEWMWarehouse.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProductEWMWarehouse.EWMProductProcessBlockProfile AS EWMProductProcessBlockProfile,
  ProductEWMWarehouse.EWMWarehouseProcessType AS EWMWarehouseProcessType,
  ProductEWMWarehouse.EWMProductLoadCategory AS EWMProductLoadCategory,
  ProductEWMWarehouse.EWMPhysInventoryCountingCycle AS EWMPhysInventoryCountingCycle,
  ProductEWMWarehouse.RequiredMinShelfLife AS RequiredMinShelfLife,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_shelf_life_req_min preserving type ) AS RequiredMinShelfLifeCalc,
  ProductEWMWarehouse.EWMProdBackflushWthdrwlMethod AS EWMProdBackflushWthdrwlMethod,
  ProductEWMWarehouse.EWMKitQuantityCorrelation AS EWMKitQuantityCorrelation,
  ProductEWMWarehouse.EWMIsCnsmpnRlvtForValAddedSrvc AS EWMIsCnsmpnRlvtForValAddedSrvc,
  ProductEWMWarehouse.AdjustmentProfile AS AdjustmentProfile,
  ProductEWMWarehouse.EWMMrchdsDistrQtyClassfctn AS EWMMrchdsDistrQtyClassfctn,
  ProductEWMWarehouse.PreferredUnitOfMeasure AS PreferredUnitOfMeasure,
  ProductEWMWarehouse.EWMQualityInspectionGroup AS EWMQualityInspectionGroup,
  ProductEWMWarehouse.EWMPtwyControlStrategy AS EWMPtwyControlStrategy,
  ProductEWMWarehouse.EWMStorageSectionMethod AS EWMStorageSectionMethod,
  ProductEWMWarehouse.StorageBinType AS StorageBinType,
  ProductEWMWarehouse.ProductBulkStorageMethod AS ProductBulkStorageMethod,
  ProductEWMWarehouse.EWMStockRemovalControlStrategy AS EWMStockRemovalControlStrategy,
  ProductEWMWarehouse.EWMStockDeterminationGroup AS EWMStockDeterminationGroup,
  ProductEWMWarehouse.ProdIsRlvtForTwoStepPicking AS ProdIsRlvtForTwoStepPicking,
  ProductEWMWarehouse.EWMStggAreaDeterminationGroup AS EWMStggAreaDeterminationGroup
FROM I_ProdEWMWarehouse AS ProductEWMWarehouse
LEFT OUTER JOIN I_ProdEWMWrhsStorageTypeTP AS _WrhsStorage ON Product = _WrhsStorage.Product AND Warehouse = _WrhsStorage.Warehouse AND BusinessPartner = _WrhsStorage.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN E_ProdEWMWarehouse AS _ActiveExtension ON ProductUUID = _ActiveExtension.ProdSupChnMgmtUUID22 AND SupplyChainUnitUUID = _ActiveExtension.SupplyChainUnitUUID AND BusinessPartnerUUID = _ActiveExtension.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN E_ProdEWMWarehouse AS _DraftExtension ON ProductUUID = _DraftExtension.ProdSupChnMgmtUUID22 AND SupplyChainUnitUUID = _DraftExtension.SupplyChainUnitUUID AND BusinessPartnerUUID = _DraftExtension.BusinessPartnerUUID  -- association [0..1]
;