I_ProcmtHubPaytTrmsConditions

DDL: I_PROCMTHUBPAYTTRMSCONDITIONS SQL: IHUBPAYTRMCNDN Type: view BASIC Package: APPL_PROC_HUB_GF
9 Fields 1 Data Sources 2 Associations

Basic View for Payment Term Conditions in Procurement Hub

I_ProcmtHubPaytTrmsConditions is a Basic CDS View that provides data about "Basic View for Payment Term Conditions in Procurement Hub" in SAP S/4HANA. It reads from 1 data source (P_ProcmntHubPayTrmsCndn2) and exposes 9 fields with key fields PaymentTerms, ExtSourceSystem. It has 2 associations to related views. Part of development package APPL_PROC_HUB_GF.

Data Sources (1)

SourceAliasJoin Type
P_ProcmntHubPayTrmsCndn2 P_ProcmntHubPayTrmsCndn2 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProcmtHubPaymentTermsCndnTxt _ProcmtHubPaymentTermsCndnTxt $projection.PaymentTerms = _ProcmtHubPaymentTermsCndnTxt.PaymentTerms and $projection.ExtSourceSystem = _ProcmtHubPaymentTermsCndnTxt.ExtSourceSystem
[1..1] I_ProcurementHubPaymentTerms _ProcurementHubPaymentTerms $projection.PaymentTerms = _ProcurementHubPaymentTerms.PaymentTerms and $projection.ExtSourceSystem = _ProcurementHubPaymentTerms.ExtSourceSystem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IHUBPAYTRMCNDN view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic View for Payment Term Conditions in Procurement Hub view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PaymentTerms view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PaymentTerms paymentterms Pyt Terms
KEY ExtSourceSystem extsourcesystem Connected System ID
CashDiscount1Days cashdiscount1days Days from Baseline Date for Payment
CashDiscount2Days cashdiscount2days Days from Baseline Date for Payment
NetPaymentDays netpaymentdays Net Pmt Terms Period
CashDiscount1Percent cashdiscount1percent Disc. Percent 1
CashDiscount2Percent cashdiscount2percent Disc. Percent 2
_ProcurementHubPaymentTerms _ProcurementHubPaymentTerms
_ProcmtHubPaymentTermsCndnTxt _ProcmtHubPaymentTermsCndnTxt

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_ProcmtHubPaytTrmsConditions.
-- 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: IHUBPAYTRMCNDN

CREATE VIEW I_ProcmtHubPaytTrmsConditions AS
SELECT
  PaymentTerms,
  ExtSourceSystem,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent
FROM P_ProcmntHubPayTrmsCndn2
LEFT OUTER JOIN I_ProcmtHubPaymentTermsCndnTxt AS _ProcmtHubPaymentTermsCndnTxt ON PaymentTerms = _ProcmtHubPaymentTermsCndnTxt.PaymentTerms AND ExtSourceSystem = _ProcmtHubPaymentTermsCndnTxt.ExtSourceSystem  -- association [0..*]
LEFT OUTER JOIN I_ProcurementHubPaymentTerms AS _ProcurementHubPaymentTerms ON PaymentTerms = _ProcurementHubPaymentTerms.PaymentTerms AND ExtSourceSystem = _ProcurementHubPaymentTerms.ExtSourceSystem  -- association [1..1]
;

Learn More