P_RepetitiveCodeBasic

DDL: P_REPETITIVECODEBASIC SQL: PRPTVCODEB Type: view BASIC

P_RepetitiveCodeBasic is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fibl_rpcode) and exposes 10 fields with key fields PayingCompanyCode, HouseBank, RepetitiveCode.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
fibl_rpcode rpcode from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRPTVCODEB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

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 
@AbapCatalog.sqlViewName: 'PRPTVCODEB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC 
@VDM.private:true
define view P_RepetitiveCodeBasic as select from fibl_rpcode as rpcode
{
    key bukrs as PayingCompanyCode,
    key hbkid as HouseBank,
    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
} where ptype = '03' and waers <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FIBL_RPCODE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More