C_ProcurementHubPaymentTermsVH

DDL: C_PROCUREMENTHUBPAYMENTTERMSVH SQL: CHUBPAYTRMS Type: view CONSUMPTION
10 Fields 1 Data Sources 2 Associations

Value Help for Payment Terms

C_ProcurementHubPaymentTermsVH is a Consumption CDS View that provides data about "Value Help for Payment Terms" in SAP S/4HANA. It reads from 1 data source (I_ProcmtHubPaytTrmsConditions) and exposes 10 fields with key fields PaymentTerms, ProcurementHubSourceSystem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtHubPaytTrmsConditions I_ProcmtHubPaytTrmsConditions from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProcmtHubPaymentTermsText _ProcmtHubPaymentTermsText $projection.PaymentTerms = _ProcmtHubPaymentTermsText.PaymentTerms and $projection.ProcurementHubSourceSystem = _ProcmtHubPaymentTermsText.ExtSourceSystem
[1..1] I_BackendSourceSystem _BackendSourceSystem $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CHUBPAYTRMS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Value Help for Payment Terms view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey PaymentTerms view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PaymentTerms PaymentTerms Payment Terms
KEY ProcurementHubSourceSystem ExtSourceSystem Connected System ID
PaymentTermsName Payment Terms Description
CashDiscount1Days CashDiscount1Days Cash Discount Days 1
CashDiscount1Percent CashDiscount1Percent Cash Discount Percentage 1
CashDiscount2Days CashDiscount2Days Cash Discount Days 2
CashDiscount2Percent CashDiscount2Percent Cash Discount Percentage 2
NetPaymentDays NetPaymentDays Net Payment Days
ProcurementHubSourceSystemName _BackendSourceSystem ProcurementHubSourceSystemName Connected Sys Name
_ProcurementHubPaymentTerms _ProcurementHubPaymentTerms

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_ProcurementHubPaymentTermsVH.
-- 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: CHUBPAYTRMS

CREATE VIEW C_ProcurementHubPaymentTermsVH AS
SELECT
  PaymentTerms,
  ExtSourceSystem AS ProcurementHubSourceSystem,
  _ProcmtHubPaymentTermsText[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  _BackendSourceSystem.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName
FROM I_ProcmtHubPaytTrmsConditions
LEFT OUTER JOIN I_ProcmtHubPaymentTermsText AS _ProcmtHubPaymentTermsText ON PaymentTerms = _ProcmtHubPaymentTermsText.PaymentTerms AND ProcurementHubSourceSystem = _ProcmtHubPaymentTermsText.ExtSourceSystem  -- association [0..*]
LEFT OUTER JOIN I_BackendSourceSystem AS _BackendSourceSystem ON ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
;

Learn More