C_PurchaserValueHelp

DDL: C_PURCHASERVALUEHELP SQL: CPURCHVH Type: view CONSUMPTION
17 Fields 2 Data Sources 1 Associations

Purchaser Value Help

C_PurchaserValueHelp is a Consumption CDS View that provides data about "Purchaser Value Help" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoiceItemPurOrdRef, I_PurchaseOrder) and exposes 17 fields with key fields SupplierInvoice, FiscalYear, CreatedByUser. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SupplierInvoiceItemPurOrdRef _InvToPurgDoc inner
I_PurchaseOrder _PurchaseOrder inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURCHVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchaser Value Help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice Inv SupplierInvoice
KEY FiscalYear Inv FiscalYear G/L Fiscal Year
KEY CreatedByUser I_PurchaseOrder CreatedByUser User Name
PurchaseOrderType I_PurchaseOrder PurchaseOrderType PO Type
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
IsEndOfPurposeBlocked I_PurchaseOrder IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
CompanyCode Inv CompanyCode Receiver Company Code
PurchaseOrder I_SupplierInvoiceItemPurOrdRef PurchaseOrder Purchasing Document
FirstName _UserContactCard FirstName First Name
LastName _UserContactCard LastName Last Name
FullName _UserContactCard FullName Name
Department _UserContactCard Department Department
EmailAddress
PhoneNumber _UserContactCard PhoneNumber Telephone no.
MobilePhoneNumber _UserContactCard MobilePhoneNumber Telephone
_UserContactCard _UserContactCard

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_PurchaserValueHelp.
-- 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: CPURCHVH

CREATE VIEW C_PurchaserValueHelp AS
SELECT
  Inv.SupplierInvoice AS SupplierInvoice,
  Inv.FiscalYear AS FiscalYear,
  _PurchaseOrder.CreatedByUser AS CreatedByUser,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Inv.CompanyCode AS CompanyCode,
  _InvToPurgDoc.PurchaseOrder AS PurchaseOrder,
  _UserContactCard.FirstName AS FirstName,
  _UserContactCard.LastName AS LastName,
  _UserContactCard.FullName AS FullName,
  _UserContactCard.Department AS Department,
  cast ( _UserContactCard.EmailAddress as apoc_email_address preserving type ) AS EmailAddress,
  _UserContactCard.PhoneNumber AS PhoneNumber,
  _UserContactCard.MobilePhoneNumber AS MobilePhoneNumber
INNER JOIN I_SupplierInvoiceItemPurOrdRef AS _InvToPurgDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrder AS _PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [1..1]
;

Learn More