P_EWM_WhseDocumentHeader03

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_WhseDocumentHeader03.
-- 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_WhseDocumentHeader03 AS
SELECT
  EWMWarehouse,
  EWMWarehouseDocument,
  WarehouseTimeZone,
  EWMNrOfWarehouseDocumentItems,
  Product,
  ProductDescription,
  Batch,
  EWMStockType,
  StockDocumentCategory,
  StockDocumentNumber,
  ExternalStockDocumentNumber,
  EWMStockUsage,
  EWMStockOwner,
  EWMStockOwnerName,
  EntitledToDisposeParty,
  EntitledToDisposePartyName,
  WhseTaskCrtnWhseTmznDateTime,
  WhseTaskCrtnUTCDateTime,
  CreatedByUser,
  cast(_CreatedByUser.UserDescription as ewm_de_createdbyname preserving type ) AS CreatedByUserName,
  EWMStorageType,
  EWMStorageSection,
  EWMStorageBin,
  HandlingUnitNumber,
  WarehouseMovementsReason,
  WarehouseMovementsText,
  EWMGoodsMovementProcess,
  EWMWhseDocAcctAsgtCategory,
  EWMAccountAssignmentObject,
  LogicalRecordTransactionCode,
  EWMWarehouseDocCancelableCode,
  WarehouseProcessCategory,
  EWMWarehouseDocumentStatus,
  EWMWarehouseDocumentStatusIcon
FROM P_EWM_WhseDocumentHeader02
LEFT OUTER JOIN I_EWM_WarehouseNumberText_2 AS _WarehouseText ON EWMWarehouse = _WarehouseText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockTypeText_2 AS _EWMStockTypeText ON EWMStockType = _EWMStockTypeText.EWMStockType AND EWMWarehouse = _EWMStockTypeText.EWMWarehouse  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockDocCategoryText AS _StockDocCategoryText ON StockDocumentCategory = _StockDocCategoryText.StockDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_StockUsageText_2 AS _EWMStockUsageText ON EWMStockUsage = _EWMStockUsageText.EWMStockUsage  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _EWMStockOwnerText ON EWMStockOwner = _EWMStockOwnerText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _EWMEntitledToDisposePartyText ON EntitledToDisposeParty = _EWMEntitledToDisposePartyText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseMovementsReasonText AS _WarehouseMovementReasonText ON EWMWarehouse = _WarehouseMovementReasonText.EWMWarehouse AND WarehouseMovementsReason = _WarehouseMovementReasonText.WarehouseMovementsReason  -- association [0..*]
LEFT OUTER JOIN I_EWM_AccountAssgmtCatText AS _EWMAccountAssgmtCatText ON EWMWhseDocAcctAsgtCategory = _EWMAccountAssgmtCatText.EWMAccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageTypeText_2 AS _EWMStorageTypeText ON EWMWarehouse = _EWMStorageTypeText.EWMWarehouse AND EWMStorageType = _EWMStorageTypeText.EWMStorageType  -- association [0..*]
LEFT OUTER JOIN I_EWM_StorageSectionText_2 AS _EWMStorageSectionText ON EWMWarehouse = _EWMStorageSectionText.EWMWarehouse AND EWMStorageType = _EWMStorageSectionText.EWMStorageType AND EWMStorageSection = _EWMStorageSectionText.EWMStorageSection  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseDocCancelableText AS _EWMWhseDocCancelableCodeT ON EWMWarehouseDocCancelableCode = _EWMWhseDocCancelableCodeT.EWMWarehouseDocCancelableCode  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseDocumentStatusText AS _EWMWarehouseDocumentStatusT ON EWMWarehouseDocumentStatus = _EWMWarehouseDocumentStatusT.EWMWarehouseDocumentStatus  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseDocProcessCategoryT AS _WarehouseProcessCategoryT ON WarehouseProcessCategory = _WarehouseProcessCategoryT.WarehouseProcessCategory  -- association [0..*]
;