C_RepetitiveCodeVH

DDL: C_REPETITIVECODEVH Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

Suppliers Repetitive Codes Value Help

C_RepetitiveCodeVH is a Consumption CDS View that provides data about "Suppliers Repetitive Codes Value Help" in SAP S/4HANA. It reads from 1 data source (P_PaytTransRepetitiveCode) and exposes 29 fields with key fields PaymentRepetitiveCode, PayingCompanyCode, HouseBank.

Data Sources (1)

SourceAliasJoin Type
P_PaytTransRepetitiveCode P_PaytTransRepetitiveCode from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
EndUserText.label Suppliers Repetitive Codes Value Help view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PaymentRepetitiveCode PaymentRepetitiveCode Repetitive Code
KEY PayingCompanyCode Paying Company Code
KEY HouseBank HouseBank House Bank
RcvgPaytBusPartnerReference RcvgPaytBusPartnerReference Ptr/cus
PartnerBankDetailKey PartnerBankDetailKey Bank Details
HouseBankAccount HouseBankAccount House Bank Account
BankChain BankChain Bank Chain ID
BankCountryKey BankCountryKey Bank Ctry/Reg.
BankKey BankKey Bank Number
BankAccount BankAccount Bank acct
BankControlKey BankControlKey Control Key
BankDetailReference BankDetailReference Reference
BankAccountHolderName BankAccountHolderName Account Holder
CompanyCode CompanyCode Receiver Company Code
PaymentMethod PaymentMethod Pymt Meth.
Currency Currency Valuation Crcy
PayeePaymentSystem PayeePaymentSystem Payment System
PayeeAliasType PayeeAliasType Payee Alias Type
PayeeAliasName PayeeAliasName Payee Alias
GLAccount _RepetitiveCodeDefaults GLAccount General Ledger
BusinessArea _RepetitiveCodeDefaults BusinessArea Business Area
IsSinglePayment _RepetitiveCodeDefaults IsSinglePayment
ReferenceTypeText _RepetitiveCodeDefaults ReferenceTypeText
DataExchangeInstructionKey _RepetitiveCodeDefaults DataExchangeInstructionKey Instruction Key
DataExchangeInstruction1 _RepetitiveCodeDefaults DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 _RepetitiveCodeDefaults DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 _RepetitiveCodeDefaults DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 _RepetitiveCodeDefaults DataExchangeInstruction4 Instruction 4
StateCentralBankPaymentReason _RepetitiveCodeDefaults StateCentralBankPaymentReason SCB Ind.

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_RepetitiveCodeVH.
-- 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_RepetitiveCodeVH AS
SELECT
  PaymentRepetitiveCode,
  cast(PayingCompanyCode as farp_bnk_com_dzbukr preserving type) AS PayingCompanyCode,
  HouseBank,
  RcvgPaytBusPartnerReference,
  PartnerBankDetailKey,
  HouseBankAccount,
  BankChain,
  BankCountryKey,
  BankKey,
  BankAccount,
  BankControlKey,
  BankDetailReference,
  BankAccountHolderName,
  CompanyCode,
  PaymentMethod,
  Currency,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  _RepetitiveCodeDefaults.GLAccount AS GLAccount,
  _RepetitiveCodeDefaults.BusinessArea AS BusinessArea,
  _RepetitiveCodeDefaults.IsSinglePayment AS IsSinglePayment,
  _RepetitiveCodeDefaults.ReferenceTypeText AS ReferenceTypeText,
  _RepetitiveCodeDefaults.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _RepetitiveCodeDefaults.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _RepetitiveCodeDefaults.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _RepetitiveCodeDefaults.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _RepetitiveCodeDefaults.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _RepetitiveCodeDefaults.StateCentralBankPaymentReason AS StateCentralBankPaymentReason
FROM P_PaytTransRepetitiveCode
;

Learn More