R_PPS_PurchaseRequestItemDraft

DDL: R_PPS_PURCHASEREQUESTITEMDRAFT Type: view_entity BASIC
33 Fields 1 Data Sources

Purchase Request Item - Draft

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

Data Sources (1)

SourceAliasJoin Type
pps_preq_itm_d pps_preq_itm_d from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Request Item - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.sapObjectNodeType.name PPS_PurchaseRequestItem view
Feature SW:PPS_NG_MVP2025 view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PPSPurchaseRequestItemUUID ppspurchaserequestitemuuid
PPSPurchaseRequestUUID ppspurchaserequestuuid
PPSPurchaseRequest ppspurchaserequest Purch.Reqn.
PPSPurchaseRequestType ppspurchaserequesttype
PurchasingGroup purchasinggroup Purchasing Group
PurchasingOrganization purchasingorganization Purchasing Organization
PPSPurchaseRequestItem ppspurchaserequestitem Requisn. item
PPSPurchaseRequestPrice ppspurchaserequestprice
PPSPurRequestPriceQuantity ppspurrequestpricequantity
Material material Vehicle Model
MaterialGroup materialgroup Product Group
Plant plant Valuation Area
CompanyCode companycode Receiver Company Code
PPSPurchaseRequestItemCurrency ppspurchaserequestitemcurrency
RequestedQuantity requestedquantity Requested Quantity
BaseUnit baseunit Unit of Measure
ProductTypeCode producttypecode Product Type Group
PurchasingDocumentItemCategory purchasingdocumentitemcategory Item Category
CreationDate creationdate Time Stamp
CreatedByUser createdbyuser User Name
DeliveryDate deliverydate Delivery Date
PerformancePeriodStartDate performanceperiodstartdate Start of Performance Period
PerformancePeriodEndDate performanceperiodenddate End of Performance Period
PPSPurRequestProductSourceType ppspurrequestproductsourcetype
PPSPurchaseRequestProductKey ppspurchaserequestproductkey
PurchaseRequisitionItemText purchaserequisitionitemtext Short Text
FixedSupplier fixedsupplier Fixed Vendor
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_PPS_PurchaseRequestItemDraft.
-- 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 R_PPS_PurchaseRequestItemDraft AS
SELECT
  PPSPurchaseRequestItemUUID,
  PPSPurchaseRequestUUID,
  PPSPurchaseRequest,
  PPSPurchaseRequestType,
  PurchasingGroup,
  PurchasingOrganization,
  PPSPurchaseRequestItem,
  PPSPurchaseRequestPrice,
  PPSPurRequestPriceQuantity,
  Material,
  MaterialGroup,
  Plant,
  CompanyCode,
  PPSPurchaseRequestItemCurrency,
  RequestedQuantity,
  BaseUnit,
  ProductTypeCode,
  PurchasingDocumentItemCategory,
  CreationDate,
  CreatedByUser,
  DeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PPSPurRequestProductSourceType,
  PPSPurchaseRequestProductKey,
  PurchaseRequisitionItemText,
  FixedSupplier,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM pps_preq_itm_d
;

Learn More