C_MassUpdtPurOrdVH

DDL: C_MASSUPDTPURORDVH SQL: CMASUPDPURORDVH Type: view CONSUMPTION
17 Fields 1 Data Sources

Purchase Order Value Help

C_MassUpdtPurOrdVH is a Consumption CDS View that provides data about "Purchase Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 17 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem _PurchaseOrderItem from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CMASUPDPURORDVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Value Help view
Consumption.ranked true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Search.searchable true view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
OData.publish true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier PurchaseOrder Supplier Supplier
SupplierName
PurchasingGroup PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode PurchaseOrder CompanyCode Receiver Company Code
PurchasingDocumentDeletionCode PurchaseOrder PurchasingDocumentDeletionCode Del. Indicator
ReleaseIsNotCompleted PurchaseOrder ReleaseIsNotCompleted Subj.to Release
PurchasingCompletenessStatus PurchaseOrder PurchasingCompletenessStatus Incomplete
ProductType I_PurchaseOrderItem ProductType Product Type Group
Material I_PurchaseOrderItem Material Vehicle Model
MaterialName I_PurchaseOrderItem PurchaseOrderItemText Short Text
ServicePerformer I_PurchaseOrderItem ServicePerformer Service Performer
IsCompletelyDelivered I_PurchaseOrderItem IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced I_PurchaseOrderItem IsFinallyInvoiced Final Invoice
PurchaseOrderType PurchaseOrderType PO Type
PurchasingOrganization 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 C_MassUpdtPurOrdVH.
-- 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: CMASUPDPURORDVH

CREATE VIEW C_MassUpdtPurOrdVH AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder._Supplier.SupplierName AS SupplierName,
  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.PurchaseOrderItemText AS MaterialName,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  PurchaseOrderType,
  PurchasingOrganization
FROM I_PurchaseOrderItem AS _PurchaseOrderItem
;

Learn More