P_OffsettingAccount

DDL: P_OFFSETTINGACCOUNT Type: view_entity COMPOSITE Package: FINS_FIS_FICO

Private union view for OffsettingAccount

P_OffsettingAccount is a Composite CDS View that provides data about "Private union view for OffsettingAccount" in SAP S/4HANA. It reads from 5 data sources (I_Customer, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts, I_Supplier) and exposes 20 fields with key fields ChartOfAccounts, OffsettingAccount, OffsettingAccountType, OffsettingAccount, OffsettingAccountType. Part of development package FINS_FIS_FICO.

5 data source(s) 20 fields

Data Sources (5)

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

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

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts
KEY OffsettingAccount
KEY OffsettingAccountType
OffsettingAccountName
KEY OffsettingAccount
KEY OffsettingAccountType
OffsettingAccountName
ChartOfAccounts
KEY OffsettingAccount
KEY OffsettingAccountType
OffsettingAccountName
ChartOfAccounts
KEY OffsettingAccount
KEY OffsettingAccountType
OffsettingAccountName
ChartOfAccounts
KEY OffsettingAccount
KEY OffsettingAccountType
OffsettingAccountName
OffsettingAccountShortName I_GLAccountTextRawData GLAccountName 
 @AbapCatalog.entityBuffer.definitionAllowed: false
 @Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_OffsettingAccount as 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,
cast(I_Supplier.SupplierName as fis_offsetting_acct_name preserving type ) as  OffsettingAccountName,
cast(I_Supplier.OrganizationBPName1 as fis_offsetting_acct_short_name preserving type ) as OffsettingAccountShortName
//I_Supplier.SupplierFullName 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, 
cast(I_Customer.CustomerName as fis_offsetting_acct_name preserving type ) as OffsettingAccountName,
cast(I_Customer.OrganizationBPName1 as fis_offsetting_acct_short_name preserving type ) as OffsettingAccountShortName
//I_Customer.CustomerFullName as OffsettingAccountFullName

}

union all select from I_GLAccountInChartOfAccounts as I_GLAccountInChartOfAccounts
left outer to one join  I_GLAccountTextRawData as I_GLAccountTextRawData 
                                       on I_GLAccountInChartOfAccounts.ChartOfAccounts = I_GLAccountTextRawData.ChartOfAccounts
                                       and I_GLAccountInChartOfAccounts.GLAccount = I_GLAccountTextRawData.GLAccount
                                       and I_GLAccountTextRawData.Language = $session.system_language
{

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,
cast(I_GLAccountTextRawData.GLAccountName as fis_offsetting_acct_name ) as OffsettingAccountName,
I_GLAccountTextRawData.GLAccountName as OffsettingAccountShortName
//I_GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as OffsettingAccountFullName

}
//where I_GLAccountTextRawData.Language = $session.system_language 


union all select from I_GLAccountInChartOfAccounts as I_GLAccountInChartOfAccounts
left outer to one join I_GLAccountTextRawData as I_GLAccountTextRawData
                                       on I_GLAccountInChartOfAccounts.ChartOfAccounts = I_GLAccountTextRawData.ChartOfAccounts
                                       and I_GLAccountInChartOfAccounts.GLAccount = I_GLAccountTextRawData.GLAccount
                                       and I_GLAccountTextRawData.Language = $session.system_language
{

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,
cast(I_GLAccountTextRawData.GLAccountName as fis_offsetting_acct_name) as OffsettingAccountName,
I_GLAccountTextRawData.GLAccountName as OffsettingAccountShortName
//I_GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as OffsettingAccountFullName

}
//where I_GLAccountTextRawData.Language = $session.system_language 


union all select from I_GLAccountInChartOfAccounts as I_GLAccountInChartOfAccounts
left outer to one join I_GLAccountTextRawData as I_GLAccountTextRawData 
                                       on I_GLAccountInChartOfAccounts.ChartOfAccounts = I_GLAccountTextRawData.ChartOfAccounts
                                       and I_GLAccountInChartOfAccounts.GLAccount = I_GLAccountTextRawData.GLAccount
                                       and I_GLAccountTextRawData.Language = $session.system_language 
{

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,
cast(I_GLAccountTextRawData.GLAccountName as fis_offsetting_acct_name) as OffsettingAccountName,
I_GLAccountTextRawData.GLAccountName as OffsettingAccountShortName
//I_GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as OffsettingAccountFullName

}
//where I_GLAccountTextRawData.Language = $session.system_language

Learn More