A_PPS_PurchaseRequisitionItem

DDL: A_PPS_PURCHASEREQUISITIONITEM Type: view_entity CONSUMPTION
49 Fields 1 Data Sources

Items

A_PPS_PurchaseRequisitionItem is a Consumption CDS View that provides data about "Items" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurchaseReqnItemTP) and exposes 49 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurchaseReqnItemTP R_PPS_PurchaseReqnItemTP projection

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Items view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name PPS_PurchaseRequisitionItem view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name PPS_PurchaseRequisitionItem_Type view
Feature SW:PPS_NG_MVP2025 view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix PRI view
AbapCatalog.extensibility.quota.maximumFields 170 view
AbapCatalog.extensibility.quota.maximumBytes 1700 view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
PurchaseRequisitionText PurchaseRequisitionText Text
Language Language Report Text Language
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingIsItemSet PurchasingIsItemSet Item Set
PurchasingParentItem PurchasingParentItem Parent Item No
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurchaseRequisitionReleaseDate PurchaseRequisitionReleaseDate Release Date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
IsDeleted IsDeleted TRUE
DeliveryDate DeliveryDate Delivery Date
PurReqnPriceQuantity PurReqnPriceQuantity Price unit
ProcessingStatus ProcessingStatus Worklist Status
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode Reason
Plant Plant Valuation Area
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
RequestedQuantity RequestedQuantity Requested Quantity
CompanyCode CompanyCode Receiver Company Code
OrderedQuantity OrderedQuantity Quantity
Supplier Supplier Supplier
FixedSupplier FixedSupplier Fixed Vendor
SourceDocument SourceDocument Document
IsClosed IsClosed Closed
ProductTypeCode ProductTypeCode Product Type Group
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
PurgDocExternalItemCategory PurgDocExternalItemCategory Item Category
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
PurReqnItemCurrency PurReqnItemCurrency Currency
BaseUnit BaseUnit Unit of Measure
PPSIsIncrementalFundedItem PPSIsIncrementalFundedItem
PPSResponsiblePurchaser PPSResponsiblePurchaser Resp. Purchaser
PPSPerdOfPerfStartDate PPSPerdOfPerfStartDate PeROP Start Date
PPSPerdOfPerfEndDate PPSPerdOfPerfEndDate PeROP End Date
PPSSmartNumberItem PPSSmartNumberItem Smart Number
PPSSmartNumberItemIsManual PPSSmartNumberItemIsManual Checkbox
PPSIsOptionalItem PPSIsOptionalItem TRUE
PPSOptionExerciseStartDate PPSOptionExerciseStartDate Exe Start Date
PPSOptionExerciseEndDate PPSOptionExerciseEndDate Execution End Date
PPSPurReqnItemStatus PPSPurReqnItemStatus Item Status
PPSConfigurableLineItemNumber PPSConfigurableLineItemNumber Config. Itm. No.
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
PPSPurchaseRequisitionItemKey PPSPurchaseRequisitionItemKey
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution

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 A_PPS_PurchaseRequisitionItem.
-- 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 A_PPS_PurchaseRequisitionItem AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseRequisitionText,
  Language,
  PurchaseRequisitionType,
  PurchasingOrganization,
  PurchasingIsItemSet,
  PurchasingParentItem,
  PurchasingDocumentItemCategory,
  PurchaseRequisitionReleaseDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  IsDeleted,
  DeliveryDate,
  PurReqnPriceQuantity,
  ProcessingStatus,
  PurchasingDocVersionReasonCode,
  Plant,
  PurchasingGroup,
  PurchaseRequisitionItemText,
  Material,
  MaterialGroup,
  RequestedQuantity,
  CompanyCode,
  OrderedQuantity,
  Supplier,
  FixedSupplier,
  SourceDocument,
  IsClosed,
  ProductTypeCode,
  PurReqnReleaseStatus,
  PurgDocExternalItemCategory,
  PurchaseRequisitionPrice,
  PurReqnItemCurrency,
  BaseUnit,
  PPSIsIncrementalFundedItem,
  PPSResponsiblePurchaser,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  PPSSmartNumberItem,
  PPSSmartNumberItemIsManual,
  PPSIsOptionalItem,
  PPSOptionExerciseStartDate,
  PPSOptionExerciseEndDate,
  PPSPurReqnItemStatus,
  PPSConfigurableLineItemNumber,
  AccountAssignmentCategory,
  PPSPurchaseRequisitionItemKey,
  MultipleAcctAssgmtDistribution
FROM R_PPS_PurchaseReqnItemTP
;

Learn More