P_OffsettingAccountVH

DDL: P_OFFSETTINGACCOUNTVH Type: view_entity COMPOSITE Package: FINS_FIS_FICO

Private view for Offsetting Account Value Help

P_OffsettingAccountVH is a Composite CDS View that provides data about "Private view for Offsetting Account Value Help" 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. Part of development package FINS_FIS_FICO.

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 (5)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true 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.entityBuffer.definitionAllowed: false
 @Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_OffsettingAccountVH as select from I_GLAccountInChartOfAccounts as 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 as 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  as 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 as 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 as 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