What is C_PaymentRequestCustomerVH in SAP S/4HANA?

C_PaymentRequestCustomerVH is a consumption CDS view in SAP S/4HANA. Customer Value Help for Payment Request It contains 48 fields.

Which tables does C_PaymentRequestCustomerVH read from?

C_PaymentRequestCustomerVH reads data from: I_CustomerBankDetails.

What VDM layer is C_PaymentRequestCustomerVH?

C_PaymentRequestCustomerVH is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PaymentRequestCustomerVH

DDL: C_PAYMENTREQUESTCUSTOMERVH Type: view_entity CONSUMPTION

48 Fields 1 Data Sources 2 Associations

Customer Value Help for Payment Request

C_PaymentRequestCustomerVH is a Consumption CDS View that provides data about "Customer Value Help for Payment Request" in SAP S/4HANA. It reads from 1 data source (I_CustomerBankDetails) and exposes 48 fields with key fields Customer, CompanyCode, BankCountryendasBankCountry, BankendasBank, BankAccount. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CustomerBankDetails	_CustomerBankDetails	inner

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_BankAccount	_BankAccount	`$projection.PayeeBankAccount = _BankAccount.BankAccountInternalID`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.dataCategory	#VALUE_HELP	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	true	view
Consumption.ranked	true	view
EndUserText.label	Customer Value Help for Payment Request	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	Customer
KEY	CompanyCode
KEY	BankCountryendasBankCountry
KEY	BankendasBank
KEY	BankAccount	I_CustomerBankDetails	BankAccount	Bank acct
	BankAccountendasbanknasPayeeBankAccount
	BankDetailReference	I_CustomerBankDetails	BankDetailReference	Reference
	CustomerName	I_Customer	CustomerName	Name of Customer
	CustomerAccountGroup	I_Customer	CustomerAccountGroup	Account group
	CustomerClassification
	VATRegistration	I_Customer	VATRegistration	VAT Registration No.
	Industry	I_Customer	Industry	Industry Sector
	StreetName	I_Customer	StreetName	Text
	CityName	I_Customer	CityName	Name
	PostalCode	I_Customer	PostalCode	Postal Code
	Country	I_Customer	Country	Venue: Ctry/Reg
	TelephoneNumber1	I_Customer	TelephoneNumber1
	TelephoneNumber2	I_Customer	TelephoneNumber2
	FaxNumber	I_Customer	FaxNumber	Fax Number
	TaxJurisdiction	I_Customer	TaxJurisdiction	Tax Jurisdiction
	TaxNumberType	I_Customer	TaxNumberType	Tax number type
	TaxNumber1	I_Customer	TaxNumber1	VAT Reg. No.
	TaxNumber2	I_Customer	TaxNumber2	Tax Number 2
	SearchTerm1
	PaymentSystem
	AliasType
	BPBankAccountAliasName
	Language	I_Customer	Language	Report Text Language
	AuthorizationGroup	I_Customer	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	I_Customer	IsBusinessPurposeCompleted	Purpose Completed
	BPBankAccountInternalID
	BankControlKey	I_CustomerBankDetails	BankControlKey	Control Key
	IBAN
	BankAccountHolderName	I_CustomerBankDetails	BankAccountHolderName	Account Holder
	PaymentReason	I_Customer	PaymentReason	Payment Reason
	DataControllerSet	I_Customer	DataControllerSet	Data Ctrlr. Set
	DataController1	I_Customer	DataController1	Data Controller
	DataController2	I_Customer	DataController2	Data Controller
	DataController3	I_Customer	DataController3	Data Controller
	DataController4	I_Customer	DataController4	Data Controller
	DataController5	I_Customer	DataController5	Data Controller
	DataController6	I_Customer	DataController6	Data Controller
	DataController7	I_Customer	DataController7	Data Controller
	DataController8	I_Customer	DataController8	Data Controller
	DataController9	I_Customer	DataController9	Data Controller
	DataController10	I_Customer	DataController10	Data Controller
	_BankAccount		_BankAccount
	_Customer		_Customer

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_PaymentRequestCustomerVH.
-- 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.

CREATE VIEW C_PaymentRequestCustomerVH AS
SELECT
  cast(I_Customer.Customer as farp_customer_id) AS Customer,
  I_Customer._CustomerCompany.CompanyCode AS CompanyCode,
  case when _CustomerBankDetails._BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then '' else _CustomerBankDetails.BankCountry end as BankCountry AS BankCountryendasBankCountry,
  case when _CustomerBankDetails._BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then '' else _CustomerBankDetails.Bank end as Bank AS BankendasBank,
  _CustomerBankDetails.BankAccount AS BankAccount,
  cast( case when _CustomerBankDetails.BankAccount like '<IBAN>____________' then '' when _CustomerBankDetails._BusinessPartnerBankAlias.BPBankAccountAliasName <> '' then '' else _CustomerBankDetails.BankAccount end as bankn) as PayeeBankAccount AS BankAccountendasbanknasPayeeBankAccount,
  _CustomerBankDetails.BankDetailReference AS BankDetailReference,
  I_Customer.CustomerName AS CustomerName,
  I_Customer.CustomerAccountGroup AS CustomerAccountGroup,
  cast ( I_Customer.CustomerClassification as farp_kukla ) AS CustomerClassification,
  I_Customer.VATRegistration AS VATRegistration,
  I_Customer.Industry AS Industry,
  I_Customer.StreetName AS StreetName,
  I_Customer.CityName AS CityName,
  I_Customer.PostalCode AS PostalCode,
  I_Customer.Country AS Country,
  I_Customer.TelephoneNumber1 AS TelephoneNumber1,
  I_Customer.TelephoneNumber2 AS TelephoneNumber2,
  I_Customer.FaxNumber AS FaxNumber,
  I_Customer.TaxJurisdiction AS TaxJurisdiction,
  I_Customer.TaxNumberType AS TaxNumberType,
  I_Customer.TaxNumber1 AS TaxNumber1,
  I_Customer.TaxNumber2 AS TaxNumber2,
  cast(I_Customer._CustomerToBusinessPartner._BusinessPartner.SearchTerm1 as fap_ffp_searchterm) AS SearchTerm1,
  _CustomerBankDetails._BusinessPartnerBankAlias.PaymentSystem AS PaymentSystem,
  _CustomerBankDetails._BusinessPartnerBankAlias.AliasType AS AliasType,
  _CustomerBankDetails._BusinessPartnerBankAlias.BPBankAccountAliasName AS BPBankAccountAliasName,
  I_Customer.Language AS Language,
  I_Customer.AuthorizationGroup AS AuthorizationGroup,
  I_Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast(_CustomerBankDetails.BPBankAccountInternalID as farp_bnk_com_bvtyp) AS BPBankAccountInternalID,
  _CustomerBankDetails.BankControlKey AS BankControlKey,
  _CustomerBankDetails._BusinessPartnerBank._IBAN.IBAN AS IBAN,
  _CustomerBankDetails.BankAccountHolderName AS BankAccountHolderName,
  I_Customer.PaymentReason AS PaymentReason,
  I_Customer.DataControllerSet AS DataControllerSet,
  I_Customer.DataController1 AS DataController1,
  I_Customer.DataController2 AS DataController2,
  I_Customer.DataController3 AS DataController3,
  I_Customer.DataController4 AS DataController4,
  I_Customer.DataController5 AS DataController5,
  I_Customer.DataController6 AS DataController6,
  I_Customer.DataController7 AS DataController7,
  I_Customer.DataController8 AS DataController8,
  I_Customer.DataController9 AS DataController9,
  I_Customer.DataController10 AS DataController10
INNER JOIN I_CustomerBankDetails AS _CustomerBankDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON PayeeBankAccount = _BankAccount.BankAccountInternalID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Depth:

C_PaymentRequestCustomerVH view_entity

I_CustomerBankDetails view