What is C_PaymentRequestVariantVH in SAP S/4HANA?

C_PaymentRequestVariantVH is a consumption CDS view in SAP S/4HANA. Payment Request Template Value Help It contains 57 fields.

Which tables does C_PaymentRequestVariantVH read from?

C_PaymentRequestVariantVH reads data from: I_PaytReqVariantAdministration.

What VDM layer is C_PaymentRequestVariantVH?

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

C_PaymentRequestVariantVH

DDL: C_PAYMENTREQUESTVARIANTVH Type: view_entity CONSUMPTION Package: ODATA_PROCESS_FF_PAYMENTS

57 Fields 1 Data Sources 2 Associations

Payment Request Template Value Help

C_PaymentRequestVariantVH is a Consumption CDS View that provides data about "Payment Request Template Value Help" in SAP S/4HANA. It reads from 1 data source (I_PaytReqVariantAdministration) and exposes 57 fields with key field PaymentRequestVariant. It has 2 associations to related views. Part of development package ODATA_PROCESS_FF_PAYMENTS.

Data Sources (1)

Source	Alias	Join Type
I_PaytReqVariantAdministration	_PaymentRequestVariantAdmin	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	C_PaytRequestCustomerVariant	_CustomerVariant	`$projection.PaymentRequestVariant = _CustomerVariant.PaymentRequestVariant`
[1..1]	C_PaytRequestSupplierVariant	_SupplierVariant	`$projection.PaymentRequestVariant = _SupplierVariant.PaymentRequestVariant`

Annotations (12)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	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
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_PaymentRequestTemplateVH	view
Search.searchable	true	view
Consumption.ranked	true	view
EndUserText.label	Payment Request Template Value Help	view

Fields (57)

Key	Field	Source Table	Source Field	Description
KEY	PaymentRequestVariant	I_PaytReqVariantAdministration	PaymentRequestVariant	Variant Name
	PaymentRequestType
	CreatedByUser	I_PaytReqVariantAdministration	CreatedByUser	User Name
	PaymentRequestVariantText	I_PaytReqVariantAdministration	PaymentRequestVariantText	User Group
	PayingCompanyCode	_PaymentData	PayingCompanyCode	Paying Company Code
	HouseBank	_PaymentData	HouseBank	House Bank
	HouseBankAccount	_PaymentData	HouseBankAccount	House Bank Account
	PaymentRequestCurrency	_PaymentData	PaymentRequestCurrency
	PaymentRequestAmountInPaytCrcy	_PaymentData	PaymentRequestAmountInPaytCrcy
	PaymentRequestAmountInCCCrcy	_PaymentData	PaymentRequestAmountInCCCrcy
	CompanyCodeCurrency	_PaymentData	CompanyCodeCurrency	Local Currency
	PaymentMethod	_PaymentData	PaymentMethod	Pymt Meth.
	ReferenceTypeText	_PaymentData	ReferenceTypeText
	IsSinglePayment	_PaymentData	IsSinglePayment
	DataExchangeInstructionKey	_PaymentData	DataExchangeInstructionKey	Instruction Key
	DataExchangeInstruction1	_PaymentData	DataExchangeInstruction1	Instruction 1
	DataExchangeInstruction2	_PaymentData	DataExchangeInstruction2	Instruction 2
	DataExchangeInstruction3	_PaymentData	DataExchangeInstruction3	Instruction 3
	DataExchangeInstruction4	_PaymentData	DataExchangeInstruction4	Instruction 4
	StateCentralBankPaymentReason	_PaymentData	StateCentralBankPaymentReason	SCB Ind.
	SupplyingCountry	_PaymentData	SupplyingCountry	Supplying Ctry/Reg.
	BankChain	_PaymentData	BankChain
	PaymentMethodSupplement	_PaymentData	PaymentMethodSupplement	Pmnt Meth. Sup.
	PaymentReference	_PaymentData	PaymentReference	Payment Reference
	TaxID1	_PaymentData	TaxID1	Tax Number 1
	PayeeNameendasPayeeName
	BankAccountHolderName	_PostingData	BankAccountHolderName	Account Holder
	BankDetailReference	_PostingData	BankDetailReference
	FinancialAccountType	_PostingData	FinancialAccountType	Fin. Account Type
	CustomerSupplierAccount	_PostingData	CustomerSupplierAccount
	PayeeTitle	_PostingData	PayeeTitle
	PayeePostalCodeendasPayeePostalCode
	PayeePOBox	_PostingData	PayeePOBox
	POBoxPostalCode	_PostingData	POBoxPostalCode	PO Box Postal Code
	PayeeAdditionalName2	_PostingData	PayeeAdditionalName2
	PayeeAdditionalName3	_PostingData	PayeeAdditionalName3
	PayeeAdditionalName4	_PostingData	PayeeAdditionalName4
	PayeeCityNameendasPayeeCityName
	PayeeStreetendasPayeeStreet
	PayeeCountryendasPayeeCountry
	PayeeRegion	_PostingData	PayeeRegion
	PayeeLanguage	_PostingData	PayeeLanguage
	PayeeFaxNumber	_PostingData	PayeeFaxNumber
	Supplier	_BPPostingData	Supplier	Supplier
	Customer	_BPPostingData	Customer	Sold-to Party
	PayeeBankCountryendasPayeeBankCountry
	PayeeBankAccountendasPayeeBankAccount
	CompanyCodeendasCompanyCode
	BusinessAreaendasBusinessArea
	DocumentItemTextendasDocumentItemText
	IBANwhenFIBLthenelseendasPayeeIBAN
	PaymentSystemelseendasPaymentSystem
	AliasTypeelseendasAliasType
	SupplierAccountGroup
	SupplierFinsAuthorizationGrp
	CustomerAccountGroup
	CustomerFinsAuthorizationGrp

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_PaymentRequestVariantVH.
-- 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_PaymentRequestVariantVH AS
SELECT
  _PaymentRequestVariantAdmin.PaymentRequestVariant AS PaymentRequestVariant,
  cast(_PaymentRequestVariantAdmin.PaymentRequestType as farp_payrq_type) AS PaymentRequestType,
  _PaymentRequestVariantAdmin.CreatedByUser AS CreatedByUser,
  _PaymentRequestVariantAdmin.PaymentRequestVariantText AS PaymentRequestVariantText,
  _PaymentData.PayingCompanyCode AS PayingCompanyCode,
  _PaymentData.HouseBank AS HouseBank,
  _PaymentData.HouseBankAccount AS HouseBankAccount,
  _PaymentData.PaymentRequestCurrency AS PaymentRequestCurrency,
  _PaymentData.PaymentRequestAmountInPaytCrcy AS PaymentRequestAmountInPaytCrcy,
  _PaymentData.PaymentRequestAmountInCCCrcy AS PaymentRequestAmountInCCCrcy,
  _PaymentData.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PaymentData.PaymentMethod AS PaymentMethod,
  _PaymentData.ReferenceTypeText AS ReferenceTypeText,
  _PaymentData.IsSinglePayment AS IsSinglePayment,
  _PaymentData.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _PaymentData.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _PaymentData.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _PaymentData.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _PaymentData.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _PaymentData.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _PaymentData.SupplyingCountry AS SupplyingCountry,
  _PaymentData.BankChain AS BankChain,
  _PaymentData.PaymentMethodSupplement AS PaymentMethodSupplement,
  _PaymentData.PaymentReference AS PaymentReference,
  _PaymentData.TaxID1 AS TaxID1,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.CustomerName when 'FI-AP-PR' then _SupplierVariant._Supplier.SupplierName when 'FI-BL' then _PostingData.PayeeName else _PostingData.PayeeName end as PayeeName AS PayeeNameendasPayeeName,
  _PostingData.BankAccountHolderName AS BankAccountHolderName,
  _PostingData.BankDetailReference AS BankDetailReference,
  _PostingData.FinancialAccountType AS FinancialAccountType,
  _PostingData.CustomerSupplierAccount AS CustomerSupplierAccount,
  _PostingData.PayeeTitle AS PayeeTitle,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.PostalCode when 'FI-AP-PR' then _SupplierVariant._Supplier.PostalCode when 'FI-BL' then _PostingData.PayeePostalCode else _PostingData.PayeePostalCode end as PayeePostalCode AS PayeePostalCodeendasPayeePostalCode,
  _PostingData.PayeePOBox AS PayeePOBox,
  _PostingData.POBoxPostalCode AS POBoxPostalCode,
  _PostingData.PayeeAdditionalName2 AS PayeeAdditionalName2,
  _PostingData.PayeeAdditionalName3 AS PayeeAdditionalName3,
  _PostingData.PayeeAdditionalName4 AS PayeeAdditionalName4,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.CityName when 'FI-AP-PR' then _SupplierVariant._Supplier.CityName when 'FI-BL' then _PostingData.PayeeCityName else _PostingData.PayeeCityName end as PayeeCityName AS PayeeCityNameendasPayeeCityName,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.StreetName when 'FI-AP-PR' then _SupplierVariant._Supplier.StreetName when 'FI-BL' then _PostingData.PayeeStreet else _PostingData.PayeeStreet end as PayeeStreet AS PayeeStreetendasPayeeStreet,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.Country when 'FI-AP-PR' then _SupplierVariant._Supplier.Country when 'FI-BL' then _PostingData.PayeeCountry else _PostingData.PayeeCountry end as PayeeCountry AS PayeeCountryendasPayeeCountry,
  _PostingData.PayeeRegion AS PayeeRegion,
  _PostingData.PayeeLanguage AS PayeeLanguage,
  _PostingData.PayeeFaxNumber AS PayeeFaxNumber,
  _BPPostingData.Supplier AS Supplier,
  _BPPostingData.Customer AS Customer,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.BankCountry when 'FI-AP-PR' then _SupplierVariant.BankCountry when 'FI-BL' then _PostingData.PayeeBankCountry else _PostingData.PayeeBankCountry end as PayeeBankCountry AS PayeeBankCountryendasPayeeBankCountry,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.BankAccount when 'FI-AP-PR' then _SupplierVariant.BankAccount when 'FI-BL' then _PostingData.PayeeBankAccount else _PostingData.PayeeBankAccount end as PayeeBankAccount AS PayeeBankAccountendasPayeeBankAccount,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.CompanyCode when 'FI-AP-PR' then _SupplierVariant.CompanyCode when 'FI-BL' then _PostingData.CompanyCode else _PostingData.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.BusinessArea when 'FI-AP-PR' then _SupplierVariant.BusinessArea when 'FI-BL' then _PostingData.BusinessArea else _PostingData.BusinessArea end as BusinessArea AS BusinessAreaendasBusinessArea,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.DocumentItemText when 'FI-AP-PR' then _SupplierVariant.DocumentItemText when 'FI-BL' then _PostingData.DocumentItemText else _PostingData.DocumentItemText end as DocumentItemText AS DocumentItemTextendasDocumentItemText,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.IBAN when 'FI-AP-PR' then _SupplierVariant.IBAN when 'FI-BL' then '' else '' end as PayeeIBAN AS IBANwhenFIBLthenelseendasPayeeIBAN,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.PaymentSystem when 'FI-AP-PR' then _SupplierVariant.PaymentSystem when 'FI-BL' then _PostingData.PaymentSystem else '' end as PaymentSystem AS PaymentSystemelseendasPaymentSystem,
  case PaymentRequestType when 'FI-AR-PR' then _CustomerVariant.AliasType when 'FI-AP-PR' then _SupplierVariant.AliasType when 'FI-BL' then _PostingData.AliasType else '' end as AliasType AS AliasTypeelseendasAliasType,
  _BPPostingData._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _BPPostingData._Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _BPPostingData._Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _BPPostingData._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp
FROM I_PaytReqVariantAdministration AS _PaymentRequestVariantAdmin
LEFT OUTER JOIN C_PaytRequestCustomerVariant AS _CustomerVariant ON PaymentRequestVariant = _CustomerVariant.PaymentRequestVariant  -- association [1..1]
LEFT OUTER JOIN C_PaytRequestSupplierVariant AS _SupplierVariant ON PaymentRequestVariant = _SupplierVariant.PaymentRequestVariant  -- association [1..1]
;

Depth:

C_PaymentRequestVariantVH view_entity

I_PaytReqVariantAdministration view_entity