I_RepetitiveCode

DDL: I_REPETITIVECODE Type: view_entity BASIC Package: ODATA_BANKTRANSFER

Basic View for Repetitive Code

I_RepetitiveCode is a Basic CDS View that provides data about "Basic View for Repetitive Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, fibl_rpcode) and exposes 13 fields with key fields PayingCompanyCode, HouseBank, RepetitiveCode. It has 2 associations to related views. Part of development package ODATA_BANKTRANSFER.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode companycode inner
fibl_rpcode rpcode from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PaymentMethod _PaytMeth $projection.PaymentMethod = _PaytMeth.PaymentMethod and $projection.CompanyCodeCountry = _PaytMeth.Country
[1..1] fibl_rpcode_tdef _Reference rpcode.bukrs = _Reference.bukrs and rpcode.hbkid = _Reference.hbkid and rpcode.rpcode = _Reference.rpcode

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Basic View for Repetitive Code view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PayingCompanyCode fibl_rpcode bukrs
KEY HouseBank fibl_rpcode hbkid
KEY RepetitiveCode fibl_rpcode rpcode
HouseBankAccount fibl_rpcode hktid
PayeeCompanyCode fibl_rpcode pbukr
PayeeHouseBank fibl_rpcode partn
PayeeHouseBankAccount fibl_rpcode parta
PaymentMethod fibl_rpcode zlsch
Currency fibl_rpcode waers
BankCountry fibl_rpcode banks
CompanyCodeCountry I_CompanyCode Country
PaymentMethodName _PaytMeth PaymentMethodName
RepetitiveCodeReferenceText _Reference rp_text 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@EndUserText.label: 'Basic View for Repetitive Code'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
define view entity I_RepetitiveCode as select from fibl_rpcode as rpcode
  inner join   I_CompanyCode       as companycode on rpcode.bukrs = companycode.CompanyCode
association [1..1] to I_PaymentMethod as _PaytMeth on $projection.PaymentMethod = _PaytMeth.PaymentMethod
                                                  and $projection.CompanyCodeCountry = _PaytMeth.Country
association [1..1] to fibl_rpcode_tdef as _Reference on rpcode.bukrs = _Reference.bukrs
                                                    and rpcode.hbkid = _Reference.hbkid
                                                    and rpcode.rpcode = _Reference.rpcode{
    key rpcode.bukrs as PayingCompanyCode,
    key rpcode.hbkid as HouseBank,
//    key ltrim( rpcode, '0') as RepetitiveCode,

    key rpcode.rpcode as RepetitiveCode,
    rpcode.hktid as HouseBankAccount,
    rpcode.pbukr as PayeeCompanyCode,
    rpcode.partn as PayeeHouseBank,
    rpcode.parta as PayeeHouseBankAccount,
    rpcode.zlsch as PaymentMethod,
    rpcode.waers as Currency,
    rpcode.banks as BankCountry,
    companycode.Country as CompanyCodeCountry,
    _PaytMeth.PaymentMethodName as PaymentMethodName,
    _Reference.rp_text as RepetitiveCodeReferenceText
} where rpcode.ptype = '03' and rpcode.waers <> '' and
        rpcode.drele is not initial

Learn More