P_OffsettingAccountVH

DDL: P_OFFSETTINGACCOUNTVH SQL: PFIOFFACCTVH Type: view COMPOSITE

P_OffsettingAccountVH is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_Customer, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts, I_Supplier) and exposes 9 fields with key fields ChartOfAccounts, OffsettingAccount, ChartOfAccounts, OffsettingAccount, ChartOfAccounts.

5 data source(s) 9 fields

Data Sources (5)

SourceAliasJoin Type
I_Customer I_Customer union_all
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts from
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts union_all
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts union_all
I_Supplier I_Supplier union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIOFFACCTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts
KEY OffsettingAccount
KEY ChartOfAccounts
KEY OffsettingAccount
KEY ChartOfAccounts
KEY OffsettingAccount
KEY OffsettingAccount
KEY OffsettingAccount
KEY OffsettingAccountType 
@AbapCatalog.sqlViewName: 'PFIOFFACCTVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
//@EndUserText.label: 'Private view for Offsetting Account Value Help'

define view P_OffsettingAccountVH as select from I_GLAccountInChartOfAccounts {

key    I_GLAccountInChartOfAccounts.ChartOfAccounts,
key    cast(I_GLAccountInChartOfAccounts.GLAccount as fis_gkont preserving type ) as OffsettingAccount,
key cast('S'  as farp_gkoar preserving type ) as OffsettingAccountType

}

union all select from I_GLAccountInChartOfAccounts {

key    I_GLAccountInChartOfAccounts.ChartOfAccounts,
key    cast(I_GLAccountInChartOfAccounts.GLAccount as fis_gkont preserving type ) as OffsettingAccount,
key cast('A' as farp_gkoar preserving type ) as OffsettingAccountType
//I_GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as OffsettingAccountFullName

}

union all select from I_GLAccountInChartOfAccounts {

key    I_GLAccountInChartOfAccounts.ChartOfAccounts,
key    cast(I_GLAccountInChartOfAccounts.GLAccount as fis_gkont preserving type ) as OffsettingAccount,
key cast('M' as farp_gkoar preserving type ) as OffsettingAccountType
//I_GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as OffsettingAccountFullName

}

union all select from I_Customer {

key cast('    ' as fis_ktopl preserving type ) as ChartOfAccounts,
key cast(I_Customer.Customer as fis_gkont preserving type ) as OffsettingAccount,
key cast('D' as farp_gkoar preserving type ) as OffsettingAccountType
//I_Customer.CustomerFullName as OffsettingAccountFullName

}

union all select from I_Supplier {

key cast('    '  as fis_ktopl preserving type ) as ChartOfAccounts,
key cast(I_Supplier.Supplier as fis_gkont preserving type ) as OffsettingAccount,
key cast('K' as farp_gkoar preserving type ) as OffsettingAccountType
//I_Supplier.SupplierFullName as OffsettingAccountFullName

}

Learn More