P_PaytTransRepetitiveCode

DDL: P_PAYTTRANSREPETITIVECODE SQL: PRPTVCODE Type: view BASIC Package: ODATA_PROCESS_FF_PAYMENTS

Repetitive Codes

P_PaytTransRepetitiveCode is a Basic CDS View that provides data about "Repetitive Codes" in SAP S/4HANA. It reads from 1 data source (fibl_rpcode) and exposes 23 fields with key fields PayingCompanyCode, HouseBank, PaymentRepetitiveCode. It has 2 associations to related views. Part of development package ODATA_PROCESS_FF_PAYMENTS.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
fibl_rpcode fibl_rpcode from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PaymentSystem _PaymentSystem $projection.PayeePaymentSystem = _PaymentSystem.PaymentSystem
[0..1] I_AliasType _AliasType $projection.PayeeAliasType = _AliasType.AliasType

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRPTVCODE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #BASIC view
VDM.private true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PayingCompanyCode bukrs
KEY HouseBank hbkid
KEY PaymentRepetitiveCode rpcode
HouseBankAccount hktid
BankChain chain
BankCountryKey banks
BankKey bankl
BankAccount bankn
BankControlKey bkont
BankDetailReference bkref
BankAccountHolderName koinh
RcvgPaytBusPartnerCategory ptype
RcvgPaytBusPartnerReference partn
PartnerBankDetailKey parta
CompanyCode pbukr
PaymentMethod zlsch
Currency waers
RepetitiveCodeReleasedBy urele
PayeePaymentSystem zpayment_system
PayeeAliasType zalias_type
PayeeAliasName zbank_alias
_PaymentSystem _PaymentSystem
_AliasType _AliasType 
@AbapCatalog.sqlViewName: 'PRPTVCODE'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A

@VDM.viewType: #BASIC
@VDM.private: true

define view P_PaytTransRepetitiveCode
  as select from fibl_rpcode
  
  association [0..1] to I_PaymentSystem   as _PaymentSystem on  $projection.PayeePaymentSystem = _PaymentSystem.PaymentSystem
  association [0..1] to I_AliasType       as _AliasType     on  $projection.PayeeAliasType = _AliasType.AliasType

{
  key bukrs                               as PayingCompanyCode,
  key hbkid                               as HouseBank,
  key rpcode                              as PaymentRepetitiveCode,
      hktid                               as HouseBankAccount,
      chain                               as BankChain,
      banks                               as BankCountryKey,
      bankl                               as BankKey,
      bankn                               as BankAccount, 
      bkont                               as BankControlKey,
      bkref                               as BankDetailReference,
      koinh                               as BankAccountHolderName,
      ptype                               as RcvgPaytBusPartnerCategory,
      partn                               as RcvgPaytBusPartnerReference,
      parta                               as PartnerBankDetailKey,
      pbukr                               as CompanyCode,
      zlsch                               as PaymentMethod,  
      waers                               as Currency,
      urele                               as RepetitiveCodeReleasedBy,
      zpayment_system                     as PayeePaymentSystem,
      zalias_type                         as PayeeAliasType,   
      zbank_alias                         as PayeeAliasName,   

      _PaymentSystem,
      _AliasType
}

Learn More