I_RecrrgAcctgDocHdrForChgDoc

DDL: I_RECRRGACCTGDOCHDRFORCHGDOC Type: view BASIC

Recurring Accounting Doc. Header for binding to Change Doc.

I_RecrrgAcctgDocHdrForChgDoc is a Basic CDS View that provides data about "Recurring Accounting Doc. Header for binding to Change Doc." in SAP S/4HANA. It reads from 2 data sources (bkpf, bkdf) and exposes 6 fields with key fields DatabaseTable, gjahr4endasChangeDocumentTableKey.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
bkpf AccDocHdr left_outer
bkdf AccDocRecurringHdr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRACCDOCHDR4CD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Recurring Accounting Doc. Header for binding to Change Doc. view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private false view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DatabaseTable
KEY gjahr4endasChangeDocumentTableKey
CompanyCode bkdf bukrs
AccountingDocument bkdf belnr
FiscalYear bkdf gjahr
AccountingDocumentType bkpf blart 
@AbapCatalog: {
    sqlViewName: 'IRACCDOCHDR4CD',
    compiler.compareFilter: true,
    preserveKey:true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Recurring Accounting Doc. Header for binding to Change Doc.'
@ObjectModel.usageType: {
    serviceQuality: #X,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
}
@VDM: {
    viewType: #BASIC,
    private: false
}

define view I_RecrrgAcctgDocHdrForChgDoc
  as select from    bkdf as AccDocRecurringHdr
    left outer join bkpf as AccDocHdr on  AccDocRecurringHdr.bukrs = AccDocHdr.bukrs
                                      and AccDocRecurringHdr.belnr = AccDocHdr.belnr
                                      and AccDocRecurringHdr.gjahr = AccDocHdr.gjahr
{

  key cast('BKDF' as farp_database_table_name ) as DatabaseTable,

  key case length( AccDocRecurringHdr.bukrs )
            when 4 then  ( concat(AccDocRecurringHdr.mandt,  concat(AccDocRecurringHdr.bukrs, concat(AccDocRecurringHdr.belnr, AccDocRecurringHdr.gjahr ) ) ) )      
            when 3 then  ( concat(AccDocRecurringHdr.mandt,  concat_with_space(AccDocRecurringHdr.bukrs, concat(AccDocRecurringHdr.belnr, AccDocRecurringHdr.gjahr ), 1 ) ) )
            when 2 then  ( concat(AccDocRecurringHdr.mandt,  concat_with_space(AccDocRecurringHdr.bukrs, concat(AccDocRecurringHdr.belnr, AccDocRecurringHdr.gjahr ), 2 ) ) ) 
            when 1 then  ( concat(AccDocRecurringHdr.mandt,  concat_with_space(AccDocRecurringHdr.bukrs, concat(AccDocRecurringHdr.belnr, AccDocRecurringHdr.gjahr ), 3 ) ) )
            else         ( concat(AccDocRecurringHdr.mandt,  concat_with_space(AccDocRecurringHdr.bukrs, concat(AccDocRecurringHdr.belnr, AccDocRecurringHdr.gjahr ), 4 ) ) )   
            end as ChangeDocumentTableKey,
      AccDocRecurringHdr.bukrs                  as CompanyCode,
      AccDocRecurringHdr.belnr                  as AccountingDocument,
      AccDocRecurringHdr.gjahr                  as FiscalYear,
      AccDocHdr.blart                           as AccountingDocumentType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKDF",
"BKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More