C_PurchaseOrderValueHelp

DDL: C_PURCHASEORDERVALUEHELP SQL: CPURORD_VH Type: view CONSUMPTION
14 Fields 1 Data Sources 2 Associations

Purchase Order Value Help

C_PurchaseOrderValueHelp is a Consumption CDS View that provides data about "Purchase Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 14 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PurchaseOrderItem _PurchaseOrderItem PurchaseOrder.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPURORD_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Purchase Order Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem _PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier I_PurchaseOrder Supplier Supplier
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
PurchasingDocumentDeletionCode I_PurchaseOrder PurchasingDocumentDeletionCode Del. Indicator
ReleaseIsNotCompleted I_PurchaseOrder ReleaseIsNotCompleted Subj.to Release
PurchasingCompletenessStatus I_PurchaseOrder PurchasingCompletenessStatus Incomplete
ProductType _PurchaseOrderItem ProductType Product Type Group
Material _PurchaseOrderItem Material Vehicle Model
ServicePerformer _PurchaseOrderItem ServicePerformer Service Performer
IsCompletelyDelivered _PurchaseOrderItem IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced _PurchaseOrderItem IsFinallyInvoiced Final Invoice
_MaterialText _MaterialText

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_PurchaseOrderValueHelp.
-- 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: CPURORD_VH

CREATE VIEW C_PurchaseOrderValueHelp AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  _PurchaseOrderItem.ProductType AS ProductType,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced
FROM I_PurchaseOrder AS PurchaseOrder
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
;

Learn More