C_PPS_PurchaseRequestItemTP

DDL: C_PPS_PURCHASEREQUESTITEMTP Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

Purchase Request Item

C_PPS_PurchaseRequestItemTP is a Consumption CDS View that provides data about "Purchase Request Item" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurchaseRequestItemTP) and exposes 33 fields with key field PPSPurchaseRequestItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurchaseRequestItemTP R_PPS_PurchaseRequestItemTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Purchase Request Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name PPS_PurchaseRequestItem view
Feature SW:PPS_NG_MVP2025 view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PPSPurchaseRequestItemUUID PPSPurchaseRequestItemUUID
PPSPurchaseRequest PPSPurchaseRequest Purch.Reqn.
PPSPurchaseRequestItem PPSPurchaseRequestItem Item Number
PurchaseRequisitionItemText PurchaseRequisitionItemText Product
PPSPurchaseRequestType PPSPurchaseRequestType
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
PPSPurchaseRequestPrice PPSPurchaseRequestPrice Unit Price
PPSPurchaseRequestItemCurrency PPSPurchaseRequestItemCurrency
PPSPurRequestPriceQuantity PPSPurRequestPriceQuantity
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Material Material Product
MaterialName _MaterialText MaterialName Material Description
MaterialGroup MaterialGroup Product Group
MaterialGroupName _MaterialGroupText MaterialGroupName prod Grp Desc.
Plant Plant Plant
PlantName _Plant PlantName Plant Name
RequestedQuantity RequestedQuantity Quantity
BaseUnit BaseUnit Unit of Measure
ProductTypeCode ProductTypeCode Product Type Group
ProductTypeCodeName _ProductTypeCodeText Name Zone name
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurgDocItemCategoryName _ItemCategoryText PurgDocItemCategoryName Text for ItCat.
CreationDate CreationDate Request Date
CreatedByUser CreatedByUser User Name
CreatedByUserName _UserDescription UserDescription Full Name
DeliveryDate DeliveryDate Delivery Date
PerformancePeriodStartDate PerformancePeriodStartDate Valid From
PerformancePeriodEndDate PerformancePeriodEndDate Valid To
PPSPurchaseRequestUUID PPSPurchaseRequestUUID
PPSPurRequestProductSourceType PPSPurRequestProductSourceType
PPSPurchaseRequestProductKey PPSPurchaseRequestProductKey

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_PPS_PurchaseRequestItemTP.
-- 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 C_PPS_PurchaseRequestItemTP AS
SELECT
  PPSPurchaseRequestItemUUID,
  PPSPurchaseRequest,
  PPSPurchaseRequestItem,
  PurchaseRequisitionItemText,
  PPSPurchaseRequestType,
  PurchasingGroup,
  PurchasingOrganization,
  PPSPurchaseRequestPrice,
  PPSPurchaseRequestItemCurrency,
  PPSPurRequestPriceQuantity,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  Plant,
  _Plant.PlantName AS PlantName,
  RequestedQuantity,
  BaseUnit,
  ProductTypeCode,
  _ProductTypeCodeText.Name AS ProductTypeCodeName,
  PurchasingDocumentItemCategory,
  _ItemCategoryText.PurgDocItemCategoryName AS PurgDocItemCategoryName,
  CreationDate,
  CreatedByUser,
  _UserDescription.UserDescription AS CreatedByUserName,
  DeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PPSPurchaseRequestUUID,
  PPSPurRequestProductSourceType,
  PPSPurchaseRequestProductKey
FROM R_PPS_PurchaseRequestItemTP
;

Learn More