I_CurrencyTypesCorrespnc

DDL: I_CURRENCYTYPESCORRESPNC SQL: ICURRTPCORR Type: view COMPOSITE

Currency Types for Correspondence

I_CurrencyTypesCorrespnc is a Composite CDS View that provides data about "Currency Types for Correspondence" in SAP S/4HANA. It reads from 11 data sources and exposes 24 fields with key fields Ledger, CompanyCode.

11 data source(s) 24 fields

Data Sources (11)

SourceAliasJoin Type
I_CurrencyRoleText curtcc_text left_outer
I_CurrencyRoleText curtgc_text left_outer
I_CurrencyRoleText curtp1_text left_outer
I_CurrencyRoleText curtp2_text left_outer
I_CurrencyRoleText curtp3_text left_outer
I_CurrencyRoleText curtp4_text left_outer
I_CurrencyRoleText curtp5_text left_outer
I_CurrencyRoleText curtp6_text left_outer
I_CurrencyRoleText curtp7_text left_outer
I_CurrencyRoleText curtp8_text left_outer
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICURRTPCORR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Currency Types for Correspondence view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger
KEY CompanyCode CompanyCode
FiscalYearVariant FiscalYearVariant
CompanyCodeCurrencyRole CompanyCodeCurrencyRole
GlobalCurrencyRole GlobalCurrencyRole
FreeDefinedCurrency1Role FreeDefinedCurrency1Role
FreeDefinedCurrency2Role FreeDefinedCurrency2Role
FreeDefinedCurrency3Role FreeDefinedCurrency3Role
FreeDefinedCurrency4Role FreeDefinedCurrency4Role
FreeDefinedCurrency5Role FreeDefinedCurrency5Role
FreeDefinedCurrency6Role FreeDefinedCurrency6Role
FreeDefinedCurrency7Role FreeDefinedCurrency7Role
FreeDefinedCurrency8Role FreeDefinedCurrency8Role
AccountingPrinciple AccountingPrinciple
CompanyCodeCurrencyRoleName
GlobalCurrencyRoleName
FreeDefinedCurrency1RoleName
FreeDefinedCurrency2RoleName
FreeDefinedCurrency3RoleName
FreeDefinedCurrency4RoleName
FreeDefinedCurrency5RoleName
FreeDefinedCurrency6RoleName
FreeDefinedCurrency7RoleName
FreeDefinedCurrency8RoleName 
@AbapCatalog.sqlViewName: 'ICURRTPCORR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'Currency Types for Correspondence'
define view I_CurrencyTypesCorrespnc
  as select from I_LedgerCompanyCodeCrcyRoles left outer join I_CurrencyRoleText as curtcc_text  on  curtcc_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.CompanyCodeCurrencyRole  
                                                                                                 and curtcc_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtgc_text  on  curtgc_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole       
                                                                                                 and curtgc_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp1_text  on  curtp1_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role       
                                                                                                 and curtp1_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp2_text  on  curtp2_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role 
                                                                                                 and curtp2_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp3_text  on  curtp3_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role 
                                                                                                 and curtp3_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp4_text  on  curtp4_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency4Role 
                                                                                                 and curtp4_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp5_text  on  curtp5_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role 
                                                                                                 and curtp5_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp6_text  on  curtp6_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role 
                                                                                                 and curtp6_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp7_text  on  curtp7_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role 
                                                                                                 and curtp7_text.Language     = $session.system_language
                                              left outer join I_CurrencyRoleText as curtp8_text  on  curtp8_text.CurrencyRole = I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role 
                                                                                                 and curtp8_text.Language     = $session.system_language

{
//I_LedgerCompanyCodeCrcyRoles 

key Ledger, 
key CompanyCode, 
FiscalYearVariant, 
CompanyCodeCurrencyRole, 
GlobalCurrencyRole, 
FreeDefinedCurrency1Role, 
FreeDefinedCurrency2Role, 
FreeDefinedCurrency3Role, 
FreeDefinedCurrency4Role, 
FreeDefinedCurrency5Role, 
FreeDefinedCurrency6Role, 
FreeDefinedCurrency7Role, 
FreeDefinedCurrency8Role, 
AccountingPrinciple ,

cast(curtcc_text.CurrencyRoleName as fins_curtype_h_t ) as CompanyCodeCurrencyRoleName,
cast(curtgc_text.CurrencyRoleName as fins_curtype_k_t ) as GlobalCurrencyRoleName,
cast(curtp1_text.CurrencyRoleName as fins_curtype_o_t ) as FreeDefinedCurrency1RoleName,
cast(curtp2_text.CurrencyRoleName as fins_curtype_v_t ) as FreeDefinedCurrency2RoleName,
cast(curtp3_text.CurrencyRoleName as fins_curtype_b_t ) as FreeDefinedCurrency3RoleName,
cast(curtp4_text.CurrencyRoleName as fins_curtype_c_t ) as FreeDefinedCurrency4RoleName,
cast(curtp5_text.CurrencyRoleName as fins_curtype_d_t ) as FreeDefinedCurrency5RoleName,
cast(curtp6_text.CurrencyRoleName as fins_curtype_e_t ) as FreeDefinedCurrency6RoleName,
cast(curtp7_text.CurrencyRoleName as fins_curtype_f_t ) as FreeDefinedCurrency7RoleName,
cast(curtp8_text.CurrencyRoleName as fins_curtype_g_t ) as FreeDefinedCurrency8RoleName

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CURRENCYROLETEXT",
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More