P_PurDocItem

DDL: P_PURDOCITEM SQL: PPURDOCITM Type: view CONSUMPTION
42 Fields 1 Data Sources

View for Purchasing Document Item

P_PurDocItem is a Consumption CDS View that provides data about "View for Purchasing Document Item" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocumentItem) and exposes 42 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocumentItem _PurgDocItm from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURDOCITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for Purchasing Document Item view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument R_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem R_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
Assembly Vehicle Model
Material Material Vehicle Model
_Material _Material
Plant Plant Valuation Area
MaterialGroup MaterialGroup Product Group
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
CompanyCode CompanyCode Receiver Company Code
StorageLocation StorageLocation StorageLocation
RequirementTracking RequirementTracking Tracking Number
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
_PurgDocumentCategory _PurgDocumentCategory
TargetQuantity TargetQuantity Target Quantity
NetAmount NetAmount Stated Amount
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
IsReturnsItem IsReturnsItem Returns Item
ProductTypeCode ProductTypeCode Product Type Group
ProductType ProductType Product Type Group
OrderQuantity OrderQuantity Quantity
CurrentDate
OrderQuantityUnit R_PurchasingDocumentItem OrderQuantityUnit Sales Unit
DocumentCurrency R_PurchasingDocumentItem DocumentCurrency Document Currency
SupplierIsSubcontractor SupplierIsSubcontractor SC Supplier
MRPArea MRPArea MRP Area
StockSegment StockSegment Stock Segment
ProductSeasonYear ProductSeasonYear Season Year
ProductSeason ProductSeason Season
ProductCollection ProductCollection Collection
ProductTheme ProductTheme Theme
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
ProductCharacteristic1 ProductCharacteristic1 Characteristic 1
ProductCharacteristic2 ProductCharacteristic2 Characteristic 2
ProductCharacteristic3 ProductCharacteristic3 Characteristic 3
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode Del. Indicator
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_PurchasingDocument _PurchasingDocument

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_PurDocItem.
-- 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: PPURDOCITM

CREATE VIEW P_PurDocItem AS
SELECT
  _PurgDocItm.PurchasingDocument AS PurchasingDocument,
  _PurgDocItm.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurchasingDocumentItemText,
  cast(Material as bagrp) AS Assembly,
  Material,
  Plant,
  MaterialGroup,
  AccountAssignmentCategory,
  CompanyCode,
  StorageLocation,
  RequirementTracking,
  PurchasingDocumentCategory,
  TargetQuantity,
  NetAmount,
  NetPriceAmount,
  NetPriceQuantity,
  IsReturnsItem,
  ProductTypeCode,
  ProductType,
  OrderQuantity,
  $session.system_date AS CurrentDate,
  _PurgDocItm.OrderQuantityUnit AS OrderQuantityUnit,
  _PurgDocItm.DocumentCurrency AS DocumentCurrency,
  SupplierIsSubcontractor,
  MRPArea,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  CrossPlantConfigurableProduct,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  PurchasingDocumentItemCategory,
  GoodsReceiptIsExpected,
  IsCompletelyDelivered,
  PurchasingDocumentDeletionCode,
  IsEndOfPurposeBlocked
FROM R_PurchasingDocumentItem AS _PurgDocItm
;

Learn More