P_Consacct

DDL: P_CONSACCT SQL: PCONSACCT Type: view BASIC Package: FINS_RTC_MODEL

Consolidation Accounts

P_Consacct is a Basic CDS View that provides data about "Consolidation Accounts" in SAP S/4HANA. It reads from 2 data sources (ska1, t004) and exposes 5 fields. Part of development package FINS_RTC_MODEL.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
ska1 a from
t004 b inner

Annotations (3)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PCONSACCT view

Fields (5)

KeyFieldSource TableSource FieldDescription
mandt ska1 mandt
ktopl ska1 ktopl
saknr ska1 saknr
kktpl t004 kktpl
bilkt ska1 bilkt 
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PCONSACCT'
define view P_Consacct as select from ska1 as a 
inner join t004 as b on a.mandt = b.mandt
                    and a.ktopl = b.ktopl
{
    a.mandt,     //Client

    a.ktopl,     //Local Chart of Accounts

    a.saknr,     //Local Account Number

    b.kktpl,     //Group Chart of Accounts

    a.bilkt      //Group Account Number

}

Learn More