P_PurRequisitionNoTouch

DDL: P_PURREQUISITIONNOTOUCH SQL: PMMPRNOTOUCH Type: view CONSUMPTION
21 Fields 3 Data Sources

Purchase Requisition No Touch

P_PurRequisitionNoTouch is a Consumption CDS View that provides data about "Purchase Requisition No Touch" in SAP S/4HANA. It reads from 3 data sources (P_PurchaseRequisitionChng, P_PurchaseOrderChng, P_PurchaseRequisitionItm) and exposes 21 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, Supplier.

Data Sources (3)

SourceAliasJoin Type
P_PurchaseRequisitionChng ChangeDocument left_outer
P_PurchaseOrderChng ChangePurOrd left_outer
P_PurchaseRequisitionItm P_PurchaseRequisitionItm from

Parameters (2)

NameTypeDefault
P_StartDate budat
P_EndDate budat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMMPRNOTOUCH view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Purchase Requisition No Touch view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition RequisitionItem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem RequisitionItem PurchaseRequisitionItem Requisn. item
KEY Supplier RequisitionItem Supplier Supplier
PurchasingGroup RequisitionItem PurchasingGroup Purchasing Group
PurchasingOrganization RequisitionItem PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurReqnOrigin PurReqnOrigin Creation ind.
PurReqnSSPCatalog RequisitionItem PurReqnSSPCatalog Web Service ID
MaterialGroup RequisitionItem MaterialGroup Product Group
Material RequisitionItem Material Vehicle Model
Plant RequisitionItem Plant Valuation Area
PurReqnItemClassification PurReqnItemClassification
CreatedByUser RequisitionItem CreatedByUser User Name
CreationDate RequisitionItem CreationDate Time Stamp
BaseUnit RequisitionItem BaseUnit Unit of Measure
PurReqCreationDate PurReqCreationDate Requisn Date
RequestedQuantity RequestedQuantity Requested Quantity
PurReqnPriceQuantity PurReqnPriceQuantity Price unit
PurReqnItemCurrency PurReqnItemCurrency Currency
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price

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_PurRequisitionNoTouch.
-- 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: PMMPRNOTOUCH
-- Parameters: P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_PurRequisitionNoTouch AS
SELECT
  RequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  RequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  RequisitionItem.Supplier AS Supplier,
  RequisitionItem.PurchasingGroup AS PurchasingGroup,
  RequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  CompanyCode,
  PurchaseRequisitionType,
  PurReqnOrigin,
  RequisitionItem.PurReqnSSPCatalog AS PurReqnSSPCatalog,
  RequisitionItem.MaterialGroup AS MaterialGroup,
  RequisitionItem.Material AS Material,
  RequisitionItem.Plant AS Plant,
  PurReqnItemClassification,
  RequisitionItem.CreatedByUser AS CreatedByUser,
  RequisitionItem.CreationDate AS CreationDate,
  RequisitionItem.BaseUnit AS BaseUnit,
  PurReqCreationDate,
  RequestedQuantity,
  PurReqnPriceQuantity,
  PurReqnItemCurrency,
  PurchaseRequisitionPrice
FROM P_PurchaseRequisitionItm
LEFT OUTER JOIN P_PurchaseRequisitionChng AS ChangeDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PurchaseOrderChng AS ChangePurOrd ON /* join condition not captured in parsed metadata */
;

Learn More