P_Purgrequisitionacctvaluehelp

DDL: P_PURGREQUISITIONACCTVALUEHELP SQL: PPURGREQNACCT_VH Type: view CONSUMPTION Package: ODATA_MM_PUR_PRITEMACCT_MNTR
23 Fields 1 Data Sources 3 Associations

Value help for purchase requisition

P_Purgrequisitionacctvaluehelp is a Consumption CDS View that provides data about "Value help for purchase requisition" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 23 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 3 associations to related views. Part of development package ODATA_MM_PUR_PRITEMACCT_MNTR.

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem PurchaseRequisitionItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_Supplier _DesiredSupplier $projection.Supplier = _DesiredSupplier.Supplier

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPURGREQNACCT_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PurchaseRequisition view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Value help for purchase requisition view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem Requisn. item
PurchaseRequisitionItemText I_Purchaserequisitionitem PurchaseRequisitionItemText Short Text
ProcessingStatus I_Purchaserequisitionitem ProcessingStatus Worklist Status
Material I_Purchaserequisitionitem Material Vehicle Model
Plant I_Purchaserequisitionitem Plant Valuation Area
PlantName _Plant PlantName Plant Name
PurchasingDocumentCategory I_Purchaserequisitionitem PurchasingDocumentCategory Doc. Category
IsPurReqnBlocked I_Purchaserequisitionitem IsPurReqnBlocked Blocking Ind.
IsPurReqnCmplt I_Purchaserequisitionitem IsPurReqnCmplt Incomplete
Supplier I_Purchaserequisitionitem Supplier Supplier
FixedSupplier I_Purchaserequisitionitem FixedSupplier Fixed Vendor
IsDeleted I_Purchaserequisitionitem IsDeleted TRUE
IsClosed I_Purchaserequisitionitem IsClosed Closed
OrderedQuantity I_Purchaserequisitionitem OrderedQuantity Quantity
RequestedQuantity
PurchasingDocumentItemCategory I_Purchaserequisitionitem PurchasingDocumentItemCategory Item Category
PurchasingDocumentSubtype I_Purchaserequisitionitem PurchasingDocumentSubtype Control
IsBusinessPurposeCompleted
_MaterialText _MaterialText
PurchaseRequisitionType I_Purchaserequisitionitem PurchaseRequisitionType Order Type
PurchasingGroup I_Purchaserequisitionitem PurchasingGroup Purchasing Group
PurchasingOrganization I_Purchaserequisitionitem PurchasingOrganization Purchasing Organization

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_Purgrequisitionacctvaluehelp.
-- 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: PPURGREQNACCT_VH

CREATE VIEW P_Purgrequisitionacctvaluehelp AS
SELECT
  PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  PurchaseRequisitionItem.Material AS Material,
  PurchaseRequisitionItem.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  PurchaseRequisitionItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseRequisitionItem.IsPurReqnBlocked AS IsPurReqnBlocked,
  PurchaseRequisitionItem.IsPurReqnCmplt AS IsPurReqnCmplt,
  PurchaseRequisitionItem.Supplier AS Supplier,
  PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  PurchaseRequisitionItem.IsDeleted AS IsDeleted,
  PurchaseRequisitionItem.IsClosed AS IsClosed,
  PurchaseRequisitionItem.OrderedQuantity AS OrderedQuantity,
  cast(PurchaseRequisitionItem.RequestedQuantity as abap.dec( 25, 2 )) AS RequestedQuantity,
  PurchaseRequisitionItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurchaseRequisitionItem.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  PurchaseRequisitionItem._Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization
FROM I_Purchaserequisitionitem AS PurchaseRequisitionItem
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _DesiredSupplier ON Supplier = _DesiredSupplier.Supplier  -- association [0..1]
;

Learn More