P_ProjPurDocItems

DDL: P_PROJPURDOCITEMS SQL: PPURDOCI Type: view COMPOSITE
37 Fields 2 Data Sources 1 Associations

P_ProjPurDocItems is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurgDocAccountAssignment, I_PurReqnAcctAssgmt) and exposes 37 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, PurchasingDocumentItem, AccountAssignmentNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurgDocAccountAssignment PurDocAcctAssgmt union_all
I_PurReqnAcctAssgmt PurReqnAcctAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Purchaserequisitionitem _PurItem _PurItem.PurchaseRequisition = $projection.PurchasingDocument and _PurItem.PurchaseRequisitionItem = $projection.PurchasingDocumentItem

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPURDOCI view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #CHECK view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurReqnAcctAssgmt PurchaseRequisition Requisition
KEY PurchasingDocumentItem I_PurReqnAcctAssgmt PurchaseRequisitionItem Purchasing Doc. Item
KEY AccountAssignmentNumber I_PurReqnAcctAssgmt PurchaseReqnAcctAssgmtNumber Account Assgmt No.
WBSElementInternalID I_PurReqnAcctAssgmt WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID I_PurReqnAcctAssgmt ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_PurReqnAcctAssgmt NetworkActivityInternalID Counter
ProjectNetwork I_PurReqnAcctAssgmt ProjectNetwork Order
PurchasingDocumentType _PurItem PurchaseRequisitionType Order Type
PurchasingDocumentTypeName
PurchasingDocumentItemText _PurItem PurchaseRequisitionItemText Short Text
DeliveryDate _PurItem DeliveryDate Delivery Date
BaseUnit _PurItem BaseUnit Unit of Measure
RequestedQuantity _PurItem RequestedQuantity Quantity
Plant _PurItem Plant Valuation Area
PlantName
Supplier _PurItem Supplier Supplier
Material _PurItem Material Vehicle Model
MaterialGroup _PurItem MaterialGroup Product Group
PurchasingDocument Requisition
KEY PurchasingDocumentItem I_PurgDocAccountAssignment PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber I_PurgDocAccountAssignment AccountAssignmentNumber Account Assgmt No.
WBSElementInternalID I_PurgDocAccountAssignment WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID I_PurgDocAccountAssignment ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_PurgDocAccountAssignment NetworkActivityInternalID Counter
ProjectNetwork I_PurgDocAccountAssignment ProjectNetwork Order
PurchasingDocumentType Order Type
PurchasingDocumentTypeName
PurchasingDocumentItemText _PurItem PurchasingDocumentItemText Short Text
DeliveryDate Delivery Date
BaseUnit _PurItem BaseUnit Unit of Measure
RequestedQuantity _PurItem OrderQuantity Quantity
Plant _PurItem Plant Valuation Area
PlantName
Supplier Supplier
Material _PurItem Material Vehicle Model
MaterialGroup _PurItem MaterialGroup Product Group
PurchasingDocumentCategory _PurItem PurchasingDocumentCategory Doc. Category

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_ProjPurDocItems.
-- 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: PPURDOCI

CREATE VIEW P_ProjPurDocItems AS
SELECT
  PurReqnAcctAssgmt.PurchaseRequisition AS PurchasingDocument,
  PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchasingDocumentItem,
  PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS AccountAssignmentNumber,
  PurReqnAcctAssgmt.WBSElementInternalID AS WBSElementInternalID,
  PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  PurReqnAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  _PurItem.PurchaseRequisitionType AS PurchasingDocumentType,
  _PurItem._PurchasingDocumentType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurItem.PurchaseRequisitionItemText AS PurchasingDocumentItemText,
  _PurItem.DeliveryDate AS DeliveryDate,
  _PurItem.BaseUnit AS BaseUnit,
  _PurItem.RequestedQuantity AS RequestedQuantity,
  _PurItem.Plant AS Plant,
  _PurItem._Plant.PlantName AS PlantName,
  _PurItem.Supplier AS Supplier,
  _PurItem.Material AS Material,
  _PurItem.MaterialGroup AS MaterialGroup,
  _PurItem.PurchasingDocumentCategory AS PurchasingDocumentCategory
FROM I_PurReqnAcctAssgmt AS PurReqnAcctAssgmt
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurItem ON _PurItem.PurchaseRequisition = PurchasingDocument AND _PurItem.PurchaseRequisitionItem = PurchasingDocumentItem  -- association [1..1]
-- UNION ALL with additional select branch(es): I_PurgDocAccountAssignment
;

Learn More