I_RepetitiveCode

DDL: I_REPETITIVECODE SQL: IRPTVCODE Type: view BASIC

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.

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 (8)

NameValueLevelField
AbapCatalog.sqlViewName IRPTVCODE view
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
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PayingCompanyCode bukrs
KEY HouseBank hbkid
KEY RepetitiveCode rpcode
HouseBankAccount hktid
PayeeCompanyCode pbukr
PayeeHouseBank partn
PayeeHouseBankAccount parta
PaymentMethod zlsch
Currency waers
BankCountry banks
CompanyCodeCountry I_CompanyCode Country
PaymentMethodName _PaytMeth PaymentMethodName
RepetitiveCodeReferenceText _Reference rp_text 
@AbapCatalog.sqlViewName: 'IRPTVCODE'
@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
@ClientHandling.algorithm: #SESSION_VARIABLE
define view 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 bukrs as PayingCompanyCode,
    key hbkid as HouseBank,
//    key ltrim( rpcode, '0') as RepetitiveCode,

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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_PAYMENTMETHOD",
"FIBL_RPCODE",
"FIBL_RPCODE_TDEF"
],
"ASSOCIATED":
[
"I_PAYMENTMETHOD",
"FIBL_RPCODE_TDEF"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More