P_EWM_PInvItemRow_DiffQty

DDL: P_EWM_PINVITEMROW_DIFFQTY Type: view_entity COMPOSITE Package: VDM_EWM_CORE
5 Fields 1 Data Sources 2 Associations

Private view for Row of PInv Item with Quantity in Whse

P_EWM_PInvItemRow_DiffQty is a Composite CDS View that provides data about "Private view for Row of PInv Item with Quantity in Whse" in SAP S/4HANA. It reads from 1 data source (P_EWM_PInvItemRow_Diff) and exposes 5 fields with key fields PhysicalInventoryDocumentUUID, PhysicalInventoryItemNumber, LineIndexOfPInvItem, PhysicalInventoryChangeVersion, PInvDocumentItemType. It has 2 associations to related views. Part of development package VDM_EWM_CORE.

Data Sources (1)

SourceAliasJoin Type
P_EWM_PInvItemRow_Diff _PIDocItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_EWM_PInvDocBusItemQty _PIItemDiffQuan _PIItemDiffQuan.PhysicalInventoryDocumentUUID = _PIDocItem.PhysicalInventoryDocumentUUID and _PIItemDiffQuan.PhysicalInventoryItemNumber = _PIDocItem.PhysicalInventoryItemNumber and _PIItemDiffQuan.LineIndexOfPInvItem = _PIDocItem.LineIndexOfPInvItem and _PIItemDiffQuan.PhysicalInventoryChangeVersion = _PIDocItem.PhysicalInventoryChangeVersion and _PIItemDiffQuan.PInvDocumentItemType = 'D' and _PIItemDiffQuan.PInvQuantityDocStatus = 'DI' and _PIItemDiffQuan.PInvQuantitySequence = 1
[0..1] P_EWM_PInvDocBusItemQty _PIItemDiffDeftQuan _PIItemDiffDeftQuan.PhysicalInventoryDocumentUUID = _PIDocItem.PhysicalInventoryDocumentUUID and _PIItemDiffDeftQuan.PhysicalInventoryItemNumber = _PIDocItem.PhysicalInventoryItemNumber and _PIItemDiffDeftQuan.LineIndexOfPInvItem = _PIDocItem.LineIndexOfPInvItem and _PIItemDiffDeftQuan.PhysicalInventoryChangeVersion = _PIDocItem.PhysicalInventoryChangeVersion and _PIItemDiffDeftQuan.PInvDocumentItemType = 'PD' and _PIItemDiffDeftQuan.PInvQuantityDocStatus = 'PD' and _PIItemDiffDeftQuan.PInvQuantitySequence = 1

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber
KEY LineIndexOfPInvItem LineIndexOfPInvItem
KEY PhysicalInventoryChangeVersion PhysicalInventoryChangeVersion
KEY PInvDocumentItemType PInvDocumentItemType

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_PInvItemRow_DiffQty.
-- 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_PInvItemRow_DiffQty AS
SELECT
  PhysicalInventoryDocumentUUID,
  PhysicalInventoryItemNumber,
  LineIndexOfPInvItem,
  PhysicalInventoryChangeVersion,
  PInvDocumentItemType
FROM P_EWM_PInvItemRow_Diff AS _PIDocItem
LEFT OUTER JOIN P_EWM_PInvDocBusItemQty AS _PIItemDiffQuan ON _PIItemDiffQuan.PhysicalInventoryDocumentUUID = _PIDocItem.PhysicalInventoryDocumentUUID AND _PIItemDiffQuan.PhysicalInventoryItemNumber = _PIDocItem.PhysicalInventoryItemNumber AND _PIItemDiffQuan.LineIndexOfPInvItem = _PIDocItem.LineIndexOfPInvItem AND _PIItemDiffQuan.PhysicalInventoryChangeVersion = _PIDocItem.PhysicalInventoryChangeVersion AND _PIItemDiffQuan.PInvDocumentItemType = 'D' AND _PIItemDiffQuan.PInvQuantityDocStatus = 'DI' AND _PIItemDiffQuan.PInvQuantitySequence = 1  -- association [0..1]
LEFT OUTER JOIN P_EWM_PInvDocBusItemQty AS _PIItemDiffDeftQuan ON _PIItemDiffDeftQuan.PhysicalInventoryDocumentUUID = _PIDocItem.PhysicalInventoryDocumentUUID AND _PIItemDiffDeftQuan.PhysicalInventoryItemNumber = _PIDocItem.PhysicalInventoryItemNumber AND _PIItemDiffDeftQuan.LineIndexOfPInvItem = _PIDocItem.LineIndexOfPInvItem AND _PIItemDiffDeftQuan.PhysicalInventoryChangeVersion = _PIDocItem.PhysicalInventoryChangeVersion AND _PIItemDiffDeftQuan.PInvDocumentItemType = 'PD' AND _PIItemDiffDeftQuan.PInvQuantityDocStatus = 'PD' AND _PIItemDiffDeftQuan.PInvQuantitySequence = 1  -- association [0..1]
;

Learn More