@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Currency Role for Ledger Company Code'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CrcyRoleForLedgerCompanyCode
as select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key CompanyCodeCurrencyRole as CurrencyRole,
cast( 'CCC ' as fis_crcy_role_field preserving type ) as CurrencyField,
// CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
//// not required as always available
//where
// CompanyCodeCurrencyRole <> ''
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key GlobalCurrencyRole as CurrencyRole,
cast( 'GC ' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
GlobalCurrencyRole <> ''
and GlobalCurrencyRole <> CompanyCodeCurrencyRole
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency1Role as CurrencyRole,
cast( 'FDC1' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency1Role <> ''
and FreeDefinedCurrency1Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency1Role <> GlobalCurrencyRole
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency2Role as CurrencyRole,
cast( 'FDC2' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency2Role <> ''
and FreeDefinedCurrency2Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency2Role <> GlobalCurrencyRole
and FreeDefinedCurrency2Role <> FreeDefinedCurrency1Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency3Role as CurrencyRole,
cast( 'FDC3' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency3Role <> ''
and FreeDefinedCurrency3Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency3Role <> GlobalCurrencyRole
and FreeDefinedCurrency3Role <> FreeDefinedCurrency2Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency4Role as CurrencyRole,
cast( 'FDC4' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency4Role <> ''
and FreeDefinedCurrency4Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency4Role <> GlobalCurrencyRole
and FreeDefinedCurrency4Role <> FreeDefinedCurrency2Role
and FreeDefinedCurrency4Role <> FreeDefinedCurrency3Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency5Role as CurrencyRole,
cast( 'FDC5' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency5Role <> ''
and FreeDefinedCurrency5Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency5Role <> GlobalCurrencyRole
and FreeDefinedCurrency5Role <> FreeDefinedCurrency2Role
and FreeDefinedCurrency5Role <> FreeDefinedCurrency3Role
and FreeDefinedCurrency5Role <> FreeDefinedCurrency4Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency6Role as CurrencyRole,
cast( 'FDC6' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency6Role <> ''
and FreeDefinedCurrency6Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency6Role <> GlobalCurrencyRole
and FreeDefinedCurrency6Role <> FreeDefinedCurrency2Role
and FreeDefinedCurrency6Role <> FreeDefinedCurrency3Role
and FreeDefinedCurrency6Role <> FreeDefinedCurrency4Role
and FreeDefinedCurrency6Role <> FreeDefinedCurrency5Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency7Role as CurrencyRole,
cast( 'FDC7' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// FreeDefinedCurrency7Role,
// '' as FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency7Role <> ''
and FreeDefinedCurrency7Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency7Role <> GlobalCurrencyRole
and FreeDefinedCurrency7Role <> FreeDefinedCurrency2Role
and FreeDefinedCurrency7Role <> FreeDefinedCurrency3Role
and FreeDefinedCurrency7Role <> FreeDefinedCurrency4Role
and FreeDefinedCurrency7Role <> FreeDefinedCurrency5Role
and FreeDefinedCurrency7Role <> FreeDefinedCurrency6Role
union all select from I_LedgerCompanyCodeCrcyRoles
{
key Ledger,
key CompanyCode,
key FreeDefinedCurrency8Role as CurrencyRole,
cast( 'FDC8' as fis_crcy_role_field preserving type ) as CurrencyField,
// '' as CompanyCodeCurrencyRole,
// '' as GlobalCurrencyRole,
// '' as FreeDefinedCurrency1Role,
// '' as FreeDefinedCurrency2Role,
// '' as FreeDefinedCurrency3Role,
// '' as FreeDefinedCurrency4Role,
// '' as FreeDefinedCurrency5Role,
// '' as FreeDefinedCurrency6Role,
// '' as FreeDefinedCurrency7Role,
// FreeDefinedCurrency8Role,
_Ledger,
_CompanyCode
}
where
FreeDefinedCurrency8Role <> ''
and FreeDefinedCurrency8Role <> CompanyCodeCurrencyRole
and FreeDefinedCurrency8Role <> GlobalCurrencyRole
and FreeDefinedCurrency8Role <> FreeDefinedCurrency2Role
and FreeDefinedCurrency8Role <> FreeDefinedCurrency3Role
and FreeDefinedCurrency8Role <> FreeDefinedCurrency4Role
and FreeDefinedCurrency8Role <> FreeDefinedCurrency5Role
and FreeDefinedCurrency8Role <> FreeDefinedCurrency6Role
and FreeDefinedCurrency8Role <> FreeDefinedCurrency7Role
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_LEDGER"
],
"BASE":
[
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/