C_PurchaseRequisitionValueHelp

DDL: C_PURCHASEREQUISITIONVALUEHELP SQL: CPURREQN_VH Type: view CONSUMPTION
28 Fields 1 Data Sources 9 Associations

Purchase Requisition Value Help

C_PurchaseRequisitionValueHelp is a Consumption CDS View that provides data about "Purchase Requisition Value Help" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 28 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem PurchaseRequisitionItem from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] C_PurReqnProcessingStatus _PurReqnProcessingStatus _PurReqnProcessingStatus.DomainValue = $projection.ProcessingStatus
[0..1] C_PurchasingOrgValueHelp _PurchasingOrgValueHelp _PurchasingOrgValueHelp.PurchasingOrganization = $projection.PurchasingOrganization
[0..1] C_PurchasingGroupValueHelp _PurchasingGrpValueHelp _PurchasingGrpValueHelp.PurchasingGroup = $projection.PurchasingGroup
[0..1] C_PurchaseReqnTypeVH _PurchaseReqnTypeVH _PurchaseReqnTypeVH.PurchaseRequisitionType = $projection.PurchaseRequisitionType
[0..1] C_MM_MaterialGroupValueHelp _MaterialGroupValueHelp _MaterialGroupValueHelp.MaterialGroup = $projection.MaterialGroup
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.FixedSupplier
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.BaseUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQN_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey PurchaseRequisition view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Purchase Requisition Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem Requisn. item
PurchaseRequisitionItemText I_Purchaserequisitionitem PurchaseRequisitionItemText Short Text
ProcessingStatusName _PurReqnProcessingStatus DomainText Short Description
ProcessingStatus I_Purchaserequisitionitem ProcessingStatus Worklist Status
Material I_Purchaserequisitionitem Material Vehicle Model
MaterialGroup I_Purchaserequisitionitem MaterialGroup Product Group
Plant I_Purchaserequisitionitem Plant Valuation Area
PurchasingOrganization I_Purchaserequisitionitem PurchasingOrganization Purchasing Organization
PurchasingGroup I_Purchaserequisitionitem PurchasingGroup Purchasing Group
PurchaseRequisitionType I_Purchaserequisitionitem PurchaseRequisitionType Order Type
RequirementTracking I_Purchaserequisitionitem RequirementTracking Tracking Number
FixedSupplier I_Purchaserequisitionitem FixedSupplier Fixed Vendor
RequestedQuantity I_Purchaserequisitionitem RequestedQuantity Requested Quantity
BaseUnit I_Purchaserequisitionitem BaseUnit Unit of Measure
DeliveryDate I_Purchaserequisitionitem DeliveryDate Delivery Date
PlantName _Plant PlantName Plant Name
_UnitOfMeasure _UnitOfMeasure
MaterialName _MaterialText MaterialName Material Description
_PurchasingOrgValueHelp _PurchasingOrgValueHelp
_PurchasingGrpValueHelp _PurchasingGrpValueHelp
_PurchaseReqnTypeVH _PurchaseReqnTypeVH
_MaterialGroupValueHelp _MaterialGroupValueHelp
PurchasingGroupName _PurchasingGrpValueHelp PurchasingGroupName Purchasing Grp. Name
PurchasingOrganizationName _PurchasingOrgValueHelp PurchasingOrganizationName Purch. Org. Name
PurchasingDocumentTypeName _PurchaseReqnTypeVH PurchasingDocumentTypeName Description
MaterialGroupName _MaterialGroupValueHelp MaterialGroupName prod Grp Desc.
SupplierName _Supplier SupplierName Supplier Name

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_PurchaseRequisitionValueHelp.
-- 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: CPURREQN_VH

CREATE VIEW C_PurchaseRequisitionValueHelp AS
SELECT
  PurchaseRequisitionItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseRequisitionItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurReqnProcessingStatus.DomainText AS ProcessingStatusName,
  PurchaseRequisitionItem.ProcessingStatus AS ProcessingStatus,
  PurchaseRequisitionItem.Material AS Material,
  PurchaseRequisitionItem.MaterialGroup AS MaterialGroup,
  PurchaseRequisitionItem.Plant AS Plant,
  PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchaseRequisitionItem.RequirementTracking AS RequirementTracking,
  PurchaseRequisitionItem.FixedSupplier AS FixedSupplier,
  PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  PurchaseRequisitionItem.DeliveryDate AS DeliveryDate,
  _Plant.PlantName AS PlantName,
  _MaterialText.MaterialName AS MaterialName,
  _PurchasingGrpValueHelp.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrgValueHelp.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseReqnTypeVH.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _MaterialGroupValueHelp.MaterialGroupName AS MaterialGroupName,
  _Supplier.SupplierName AS SupplierName
FROM I_Purchaserequisitionitem AS PurchaseRequisitionItem
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_PurReqnProcessingStatus AS _PurReqnProcessingStatus ON _PurReqnProcessingStatus.DomainValue = ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGrpValueHelp ON _PurchasingGrpValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchaseReqnTypeVH AS _PurchaseReqnTypeVH ON _PurchaseReqnTypeVH.PurchaseRequisitionType = PurchaseRequisitionType  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroupValueHelp ON _MaterialGroupValueHelp.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = FixedSupplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;

Learn More