C_ProjPurDocItems

DDL: C_PROJPURDOCITEMS SQL: CPURDOC Type: view CONSUMPTION
21 Fields 1 Data Sources

Purchasing Document Item Details

C_ProjPurDocItems is a Consumption CDS View that provides data about "Purchasing Document Item Details" in SAP S/4HANA. It reads from 1 data source (I_ProjPurDocItems) and exposes 21 fields with key fields PurchasingDocument, PurchasingDocumentItem, PurchasingDocumentCategory, AccountAssignmentNumber.

Data Sources (1)

SourceAliasJoin Type
I_ProjPurDocItems I_ProjPurDocItems from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPURDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Purchase Document Item view
UI.headerInfo.typeNamePlural Purchase Document Items view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value PurchasingDocument view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value PurchasingDocumentItem view
EndUserText.label Purchasing Document Item Details view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_ProjPurDocItems PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_ProjPurDocItems PurchasingDocumentItem Purchasing Doc. Item
KEY PurchasingDocumentCategory I_ProjPurDocItems PurchasingDocumentCategory Doc. Category
KEY AccountAssignmentNumber I_ProjPurDocItems AccountAssignmentNumber Account Assgmt No.
WBSElementInternalID I_ProjPurDocItems WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID I_ProjPurDocItems ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_ProjPurDocItems NetworkActivityInternalID Counter
BaseUnit I_ProjPurDocItems BaseUnit Unit of Measure
PurchasingDocumentTypeName
PurchasingDocumentItemText I_ProjPurDocItems PurchasingDocumentItemText Short Text
DeliveryDate
RequestedQuantity
PlantName I_ProjPurDocItems PlantName Plant Name
Plant I_ProjPurDocItems Plant Valuation Area
Supplier
SupplierName
Material I_ProjPurDocItems Material Vehicle Model
MaterialGroup I_ProjPurDocItems MaterialGroup Product Group
NetworkActivityObject I_ProjPurDocItems NetworkActivityObject
NtwkActyObjBsdAuthznIsActv I_ProjPurDocItems NtwkActyObjBsdAuthznIsActv
_Supplier _Supplier

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_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: CPURDOC

CREATE VIEW C_ProjPurDocItems AS
SELECT
  I_ProjPurDocItems.PurchasingDocument AS PurchasingDocument,
  I_ProjPurDocItems.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_ProjPurDocItems.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_ProjPurDocItems.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_ProjPurDocItems.WBSElementInternalID AS WBSElementInternalID,
  I_ProjPurDocItems.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_ProjPurDocItems.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_ProjPurDocItems.BaseUnit AS BaseUnit,
  cast( I_ProjPurDocItems.PurchasingDocumentTypeName as ps_s4_batxt preserving type ) AS PurchasingDocumentTypeName,
  I_ProjPurDocItems.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  cast( I_ProjPurDocItems.DeliveryDate as ps_s4_eindt preserving type ) AS DeliveryDate,
  cast( I_ProjPurDocItems.RequestedQuantity as ps_s4_bamng preserving type ) AS RequestedQuantity,
  I_ProjPurDocItems.PlantName AS PlantName,
  I_ProjPurDocItems.Plant AS Plant,
  cast( I_ProjPurDocItems.Supplier as ps_s4_wlief preserving type ) AS Supplier,
  I_ProjPurDocItems._Supplier.BPSupplierName AS SupplierName,
  I_ProjPurDocItems.Material AS Material,
  I_ProjPurDocItems.MaterialGroup AS MaterialGroup,
  I_ProjPurDocItems.NetworkActivityObject AS NetworkActivityObject,
  I_ProjPurDocItems.NtwkActyObjBsdAuthznIsActv AS NtwkActyObjBsdAuthznIsActv
FROM I_ProjPurDocItems
;

Learn More