C_ProdnPlngPurReqnQuickView

DDL: C_PRODNPLNGPURREQNQUICKVIEW SQL: CPURREQQV Type: view CONSUMPTION
70 Fields 1 Data Sources

Purchase Requisition Details

C_ProdnPlngPurReqnQuickView is a Consumption CDS View that provides data about "Purchase Requisition Details" in SAP S/4HANA. It reads from 1 data source (I_PurReqnQuickView) and exposes 70 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnQuickView I_PurReqnQuickView from

Parameters (1)

NameTypeDefault
P_MRPElementCategory delkz

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQQV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Requisition Details view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
Material Material Vehicle Model
MaterialName MaterialName Material Description
MRPPlant MRPPlant Plant
MaterialProcurementCategory MaterialProcurementCategory Procurement
MaterialProcurementCatName MaterialProcurementCatName
SupplyingPlant SupplyingPlant Supplying Plant
SupplyingPlantName SupplyingPlantName Plant Name
MRPController MRPController MRP Controller
MRPControllerName MRPControllerName Controller name
InternalContactPersonName InternalContactPersonName
MRPControllerPhoneNumber MRPControllerPhoneNumber Telephone no.
ContactPersonEmailAddress ContactPersonEmailAddress Email
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseRequisitionType PurchaseRequisitionType Order Type
PurchasingDocumentTypeName PurchasingDocumentTypeName Description
PurchaseRequisitionIsFixed PurchaseRequisitionIsFixed "Fixed" ind.
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
ReleaseDate ReleaseDate
DeliveryDate DeliveryDate Delivery Date
PurchaseOutlineAgreement PurchaseOutlineAgreement Agreement
PurchaseOutlineAgreementItem PurchaseOutlineAgreementItem Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
SalesDocumentType SalesDocumentType Sales Doc. Type
SalesOrderItemMaterial SalesOrderItemMaterial
SalesOrderItemMaterialName SalesOrderItemMaterialName
Customer Customer Sold-to Party
WBSElementInternalID WBSElementInternalID WBS Internal ID
PartnerWBSElement WBSElement WBS Internal ID
WBSDescription WBSDescription WBS Element Name
WBSElementDescription WBSElementDescription Description
ProjectInternalID ProjectInternalID Project Def.
WBSElementObject WBSElementObject Object number
Project Project WBS Element
ProjectDescription ProjectDescription Project Name
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity Standard Qty
MaximumOrderQuantity MaximumOrderQuantity Max. Quantity
MinimumPurchaseOrderQuantity MinimumPurchaseOrderQuantity Minimum Qty
MaterialStagingTime MaterialStagingTime Staging Time
PurchaseOrderRoundingProfile PurchaseOrderRoundingProfile Rnding Profile
MaterialFixedLotSizeQuantity MaterialFixedLotSizeQuantity Fixed lot size
MaterialMinLotSizeQuantity MaterialMinLotSizeQuantity Min. Lot Size
MaterialMaxLotSizeQuantity MaterialMaxLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
MaterialRoundingProfile MaterialRoundingProfile Rnding Profile
MaterialRoundingProfileName MaterialRoundingProfileName
TotalQuantity TotalQuantity Activity Quantity
OrderedQuantity OrderedQuantity Quantity
OpenQuantity OpenQuantity PBE Entry Open Qty
PurchaseRequisitionUnit PurchaseRequisitionUnit
Supplier Supplier Supplier
BPSupplierName BPSupplierName Supplier Name
BPSupplierFullName BPSupplierFullName
SupplierPhoneNumber SupplierPhoneNumber Telephone
EmailAddress EmailAddress E-Mail Address
SupplierIsFixed SupplierIsFixed Fixed Supplier
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName PurchasingGroupName Purchasing Grp. Name
PurchasingGroupPhoneNumber PurchasingGroupPhoneNumber Tel.No.Purch.Gp
PurchasingGroupEmailAddress PurchasingGroupEmailAddress
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
MRPElementCategory MRPElementCategory MRP Elmnt Ind.

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_ProdnPlngPurReqnQuickView.
-- 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: CPURREQQV
-- Parameters: P_MRPElementCategory : delkz

CREATE VIEW C_ProdnPlngPurReqnQuickView AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  Material,
  MaterialName,
  MRPPlant,
  MaterialProcurementCategory,
  MaterialProcurementCatName,
  SupplyingPlant,
  SupplyingPlantName,
  MRPController,
  MRPControllerName,
  InternalContactPersonName,
  MRPControllerPhoneNumber,
  ContactPersonEmailAddress,
  PurchasingDocumentCategory,
  PurchaseRequisitionType,
  PurchasingDocumentTypeName,
  PurchaseRequisitionIsFixed,
  PurchasingInfoRecord,
  PurchasingOrganization,
  SupplierMaterialNumber,
  MaterialPlannedDeliveryDurn,
  MaterialGoodsReceiptDuration,
  ReleaseDate,
  DeliveryDate,
  PurchaseOutlineAgreement,
  PurchaseOutlineAgreementItem,
  SalesDocument,
  SalesDocumentItem,
  SalesDocumentType,
  SalesOrderItemMaterial,
  SalesOrderItemMaterialName,
  Customer,
  WBSElementInternalID,
  WBSElement AS PartnerWBSElement,
  WBSDescription,
  WBSElementDescription,
  ProjectInternalID,
  WBSElementObject,
  Project,
  ProjectDescription,
  StandardPurchaseOrderQuantity,
  MaximumOrderQuantity,
  MinimumPurchaseOrderQuantity,
  MaterialStagingTime,
  PurchaseOrderRoundingProfile,
  MaterialFixedLotSizeQuantity,
  MaterialMinLotSizeQuantity,
  MaterialMaxLotSizeQuantity,
  LotSizeRoundingQuantity,
  MaterialRoundingProfile,
  MaterialRoundingProfileName,
  TotalQuantity,
  OrderedQuantity,
  OpenQuantity,
  PurchaseRequisitionUnit,
  Supplier,
  BPSupplierName,
  BPSupplierFullName,
  SupplierPhoneNumber,
  EmailAddress,
  SupplierIsFixed,
  PurchasingGroup,
  PurchasingGroupName,
  PurchasingGroupPhoneNumber,
  PurchasingGroupEmailAddress,
  PurgDocOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  MRPElementCategory
FROM I_PurReqnQuickView
;

Learn More