I_SrvcEntrShtPurOrdValueHelp

DDL: I_SRVCENTRSHTPURORDVALUEHELP SQL: ISESPURORD_VH Type: view BASIC Package: APPL_MM_PUR_SES_TR
12 Fields 1 Data Sources 2 Associations

SES: Purchase Order Value Help

I_SrvcEntrShtPurOrdValueHelp is a Basic CDS View that provides data about "SES: Purchase Order Value Help" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItem) and exposes 12 fields with key fields PurchaseOrder, Service, PurchaseOrderItemText. It has 2 associations to related views. Part of development package APPL_MM_PUR_SES_TR.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItem _PurchaseOrderItem inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SuplrContactCard _Supplier $projection.Supplier = _Supplier.ContactCardID
[0..1] I_BusinessPartner _BusinessPartner $projection.ServicePerformer = _BusinessPartner.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISESPURORD_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
Search.searchable true view
ObjectModel.semanticKey PurchaseOrder view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label SES: Purchase Order Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder PurchaseOrder Purchasing Document
KEY Service Service ID
KEY PurchaseOrderItemText R_PurchaseOrderItem PurchaseOrderItemText Short Text
Supplier PurchaseOrder Supplier Supplier ID
SupplierName _Supplier FullName Supplier Name
PurchasingGroup PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode PurchaseOrder CompanyCode Receiver Company Code
ServicePerformer R_PurchaseOrderItem ServicePerformer Service Performer ID
LastName _BusinessPartner LastName Performer Last Name
PurchaseOrderType PurchaseOrder PurchaseOrderType PO Type
PurchasingOrganization PurchaseOrder PurchasingOrganization Purchasing Organization
Plant R_PurchaseOrderItem Plant Valuation Area

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 I_SrvcEntrShtPurOrdValueHelp.
-- 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: ISESPURORD_VH

CREATE VIEW I_SrvcEntrShtPurOrdValueHelp AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  cast(_PurchaseOrderItem.Material as vdm_service) AS Service,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  PurchaseOrder.Supplier AS Supplier,
  _Supplier.FullName AS SupplierName,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _BusinessPartner.LastName AS LastName,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderItem.Plant AS Plant
INNER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SuplrContactCard AS _Supplier ON Supplier = _Supplier.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON ServicePerformer = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More