C_EWM_PInvDocInWhseOrder_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_PInvDocInWhseOrder_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_PInvDocInWhseOrder_2 AS
SELECT
  WarehouseOrder,
  PhysicalInventoryDocumentUUID,
  dats_tims_to_tstmp( PInvCreationDate, PInvCreationTime, 'UTC', $session.client, 'NULL' ) as PInvLogItemTimeStamp AS clientNULLasPInvLogItemTimeStamp,
  dats_tims_to_tstmp( PInvPrintedDate, PInvPrintedTime, 'UTC', $session.client, 'NULL' ) as PInvPrintedTimeStamp AS clientNULLasPInvPrintedTimeStamp,
  PhysicalInventoryLogByUserName,
  ActivityArea,
  PhysicalInventoryArea,
  PhysicalInventoryDocumentType,
  _ProcedureText.PInvDocumentTypeText AS PInvDocumentTypeText,
  PhysicalInventoryDocNumber,
  PhysicalInventoryDocYear,
  EWMWarehouse
FROM P_EWM_PInvDocInWhseOrd04
LEFT OUTER JOIN I_EWM_PInvProcedureText AS _ProcedureText ON PhysicalInventoryDocumentType = _ProcedureText.PhysicalInventoryDocumentType AND _ProcedureText.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN C_EWM_PInvCountItem_2 AS _PInvCountItems ON PhysicalInventoryDocumentUUID = _PInvCountItems.PhysicalInventoryDocumentUUID AND WarehouseOrder = _PInvCountItems.WarehouseOrder  -- association [1..*]
LEFT OUTER JOIN C_EWM_PInvCountDynFldSel AS _DynamicFields ON WarehouseOrder = _DynamicFields.WarehouseOrder AND PhysicalInventoryDocumentUUID = _DynamicFields.PhysicalInventoryDocumentUUID  -- association [0..1]
;