I_AcctgDocHdrForChgDoc

DDL: I_ACCTGDOCHDRFORCHGDOC Type: view BASIC

Accounting Document Header for binding to Change Document

I_AcctgDocHdrForChgDoc is a Basic CDS View that provides data about "Accounting Document Header for binding to Change Document" in SAP S/4HANA. It reads from 1 data source (bkpf) and exposes 6 fields with key field DatabaseTable.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
bkpf AccDocHdr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACCDOCHDR4CD 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 Accounting Document Header for binding to Change Document 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
CompanyCode bkpf bukrs
AccountingDocument
FiscalYear bkpf gjahr
AccountingDocumentType
Ledger bkpf rldnr 
@AbapCatalog: {
    sqlViewName: 'IACCDOCHDR4CD',
    compiler.compareFilter: true,
    preserveKey:true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Accounting Document Header for binding to Change Document'
@ObjectModel.usageType: {
    serviceQuality: #X,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
}
@VDM: {
    viewType: #BASIC,
    private: false
}

define view I_AcctgDocHdrForChgDoc
  as select from bkpf as AccDocHdr
{

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

Learn More