P_EWM_PInvItemRowSrlNmbr04

DDL: P_EWM_PINVITEMROWSRLNMBR04 Type: view_entity COMPOSITE Package: VDM_EWM_CORE
11 Fields 1 Data Sources 2 Associations

Physical Inventory row serial number 04

P_EWM_PInvItemRowSrlNmbr04 is a Composite CDS View that provides data about "Physical Inventory row serial number 04" in SAP S/4HANA. It reads from 1 data source (P_EWM_PInvItemRowSrlNmbr02) and exposes 11 fields with key fields EWMWarehouse, PhysicalInventoryDocNumber, PhysicalInventoryDocYear, LineIndexOfPInvItem, PhysicalInventoryItemNumber. It has 2 associations to related views. Part of development package VDM_EWM_CORE.

Data Sources (1)

SourceAliasJoin Type
P_EWM_PInvItemRowSrlNmbr02 P_EWM_PInvItemRowSrlNmbr02 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_EWM_PInvItemRowSrlNmbr03 _snInserted $projection.EWMWarehouse = _snInserted.EWMWarehouse and $projection.PhysicalInventoryDocNumber = _snInserted.PhysicalInventoryDocNumber and $projection.PhysicalInventoryDocYear = _snInserted.PhysicalInventoryDocYear and $projection.PhysicalInventoryItemNumber = _snInserted.PhysicalInventoryItemNumber and $projection.LineIndexOfPInvItem = _snInserted.LineIndexOfPInvItem and $projection.EWMSerialNumber = _snInserted.EWMSerialNumber
[1..1] I_EWM_PInvSrlNmbrProcgSts _Status $projection.EWMPInvSrlNmbrProcgStatus = _Status.EWMPInvSrlNmbrProcgStatus

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY PhysicalInventoryDocNumber PhysicalInventoryDocNumber
KEY PhysicalInventoryDocYear PhysicalInventoryDocYear
KEY LineIndexOfPInvItem LineIndexOfPInvItem
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber
KEY EWMPhysInvtrySrlNmbrSqnc EWMPhysInvtrySrlNmbrSqnc
EWMSerialNumber EWMSerialNumber
PInvDocumentItemType PInvDocumentItemType
PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID
ActivityArea _PIAreaMapping ActivityArea
_Status _Status

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_PInvItemRowSrlNmbr04.
-- 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_PInvItemRowSrlNmbr04 AS
SELECT
  EWMWarehouse,
  PhysicalInventoryDocNumber,
  PhysicalInventoryDocYear,
  LineIndexOfPInvItem,
  PhysicalInventoryItemNumber,
  EWMPhysInvtrySrlNmbrSqnc,
  EWMSerialNumber,
  PInvDocumentItemType,
  PhysicalInventoryDocumentUUID,
  _PIAreaMapping.ActivityArea AS ActivityArea
FROM P_EWM_PInvItemRowSrlNmbr02
LEFT OUTER JOIN P_EWM_PInvItemRowSrlNmbr03 AS _snInserted ON EWMWarehouse = _snInserted.EWMWarehouse AND PhysicalInventoryDocNumber = _snInserted.PhysicalInventoryDocNumber AND PhysicalInventoryDocYear = _snInserted.PhysicalInventoryDocYear AND PhysicalInventoryItemNumber = _snInserted.PhysicalInventoryItemNumber AND LineIndexOfPInvItem = _snInserted.LineIndexOfPInvItem AND EWMSerialNumber = _snInserted.EWMSerialNumber  -- association [0..1]
LEFT OUTER JOIN I_EWM_PInvSrlNmbrProcgSts AS _Status ON EWMPInvSrlNmbrProcgStatus = _Status.EWMPInvSrlNmbrProcgStatus  -- association [1..1]
;

Learn More