P_EWM_PInvDocInWhseOrd04

DDL: P_EWM_PINVDOCINWHSEORD04 SQL: PEWMPIDOCWO04 Type: view CONSUMPTION
17 Fields 1 Data Sources

Help view of warehouse orders in PI doc

P_EWM_PInvDocInWhseOrd04 is a Consumption CDS View that provides data about "Help view of warehouse orders in PI doc" in SAP S/4HANA. It reads from 1 data source (P_EWM_PInvDocInWhseOrd03) and exposes 17 fields with key fields WarehouseOrder, PhysicalInventoryDocumentUUID.

Data Sources (1)

SourceAliasJoin Type
P_EWM_PInvDocInWhseOrd03 WhseOrd from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PEWMPIDOCWO04 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Help view of warehouse orders in PI doc view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WarehouseOrder P_EWM_PInvDocInWhseOrd03 WarehouseOrder
KEY PhysicalInventoryDocumentUUID P_EWM_PInvDocInWhseOrd03 PhysicalInventoryDocumentUUID
TimeZoneID P_EWM_PInvDocInWhseOrd03 TimeZoneID Time Zone
PInvLogItemTimeStamp P_EWM_PInvDocInWhseOrd03 PInvLogItemTimeStamp
clientNULLasPInvCreationDate
clientNULLasPInvCreationTime
PInvPrintedTimeStamp P_EWM_PInvDocInWhseOrd03 PInvPrintedTimeStamp
clientNULLasPInvPrintedDate
clientNULLasPInvPrintedTime
PhysicalInventoryLogByUserName P_EWM_PInvDocInWhseOrd03 PhysicalInventoryLogByUserName
ActivityArea P_EWM_PInvDocInWhseOrd03 ActivityArea
PhysicalInventoryArea P_EWM_PInvDocInWhseOrd03 PhysicalInventoryArea
PhysicalInventoryDocumentType P_EWM_PInvDocInWhseOrd03 PhysicalInventoryDocumentType
PhysicalInventoryDocNumber P_EWM_PInvDocInWhseOrd03 PhysicalInventoryDocNumber
PhysicalInventoryDocYear P_EWM_PInvDocInWhseOrd03 PhysicalInventoryDocYear
Warehouse P_EWM_PInvDocInWhseOrd03 Warehouse Warehouse No.
EWMWarehouse P_EWM_PInvDocInWhseOrd03 EWMWarehouse Warehouse No.

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_PInvDocInWhseOrd04.
-- 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: PEWMPIDOCWO04

CREATE VIEW P_EWM_PInvDocInWhseOrd04 AS
SELECT
  WhseOrd.WarehouseOrder AS WarehouseOrder,
  WhseOrd.PhysicalInventoryDocumentUUID AS PhysicalInventoryDocumentUUID,
  WhseOrd.TimeZoneID AS TimeZoneID,
  WhseOrd.PInvLogItemTimeStamp AS PInvLogItemTimeStamp,
  tstmp_to_dats( WhseOrd.PInvLogItemTimeStamp, WhseOrd.TimeZoneID, $session.client, 'NULL' ) as PInvCreationDate AS clientNULLasPInvCreationDate,
  tstmp_to_tims( WhseOrd.PInvLogItemTimeStamp, WhseOrd.TimeZoneID, $session.client, 'NULL' ) as PInvCreationTime AS clientNULLasPInvCreationTime,
  WhseOrd.PInvPrintedTimeStamp AS PInvPrintedTimeStamp,
  tstmp_to_dats( WhseOrd.PInvPrintedTimeStamp, WhseOrd.TimeZoneID, $session.client, 'NULL' ) as PInvPrintedDate AS clientNULLasPInvPrintedDate,
  tstmp_to_tims( WhseOrd.PInvPrintedTimeStamp, WhseOrd.TimeZoneID, $session.client, 'NULL' ) as PInvPrintedTime AS clientNULLasPInvPrintedTime,
  WhseOrd.PhysicalInventoryLogByUserName AS PhysicalInventoryLogByUserName,
  WhseOrd.ActivityArea AS ActivityArea,
  WhseOrd.PhysicalInventoryArea AS PhysicalInventoryArea,
  WhseOrd.PhysicalInventoryDocumentType AS PhysicalInventoryDocumentType,
  WhseOrd.PhysicalInventoryDocNumber AS PhysicalInventoryDocNumber,
  WhseOrd.PhysicalInventoryDocYear AS PhysicalInventoryDocYear,
  WhseOrd.Warehouse AS Warehouse,
  WhseOrd.EWMWarehouse AS EWMWarehouse
FROM P_EWM_PInvDocInWhseOrd03 AS WhseOrd
;

Learn More