P_OFFSETTINGACCOUNT

CDS View

Private union view for OffsettingAccount

P_OFFSETTINGACCOUNT is a CDS View in S/4HANA. Private union view for OffsettingAccount. It contains 5 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 5 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OffsettingAccount view_entity from COMPOSITE Offsetting Account

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY OffsettingAccount OffsettingAccount 1
KEY OffsettingAccountType OffsettingAccountType 1
OffsettingAccountName OffsettingAccountName 1
OffsettingAccountShortName OffsettingAccountShortName 1 
 @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