R_JrnlEntrLdgrCoCodeCrcyRole

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Ledger Company Code Currency Role for MJE'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #MASTER
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
define view entity R_JrnlEntrLdgrCoCodeCrcyRole
  as select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'CCC' as fis_crcy_role_field) as CurrencyField,
  
      CompanyCodeCurrencyRole    as CurrencyRole,
      
      cast( 'CompanyCodeCurrency' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInCoCodeCrcy,CreditAmountInCoCodeCrcy' as abap.char(255)) as AmountFieldName,
      cast( 'TaxBaseAmountInCoCodeCrcy' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  CompanyCodeCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'GC' as fis_crcy_role_field) as CurrencyField,
  
      GlobalCurrencyRole        as CurrencyRole,
      
      cast( 'GlobalCurrency' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInGlobalCrcy,CreditAmountInGlobalCrcy' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  GlobalCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC1' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency1Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency1' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy1,CreditAmountInFreeDfndCrcy1' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency1Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC2' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency2Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency2' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy2,CreditAmountInFreeDfndCrcy2' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency2Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC3' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency3Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency3' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy3,CreditAmountInFreeDfndCrcy3' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency3Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC4' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency4Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency4' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy4,CreditAmountInFreeDfndCrcy4' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency4Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC5' as fis_crcy_role_field) as CurrencyField,
      
      FreeDefinedCurrency5Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency5' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy5,CreditAmountInFreeDfndCrcy5' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency5Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC6' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency6Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency6' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy6,CreditAmountInFreeDfndCrcy6' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency6Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC7' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency7Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency7' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy7,CreditAmountInFreeDfndCrcy7' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency7Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FDC8' as fis_crcy_role_field) as CurrencyField,
  
      FreeDefinedCurrency8Role    as CurrencyRole,
      
      cast( 'FreeDefinedCurrency8' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFreeDfndCrcy8,CreditAmountInFreeDfndCrcy8' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FreeDefinedCurrency8Role <> ''
  
union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key cast( 'FC' as fis_crcy_role_field) as CurrencyField,
  
      FunctionalCurrencyRole      as CurrencyRole,
      
      cast( 'FunctionalCurrency' as fis_crcy_role_field_text) as CurrencyFieldName,
      cast( 'DebitAmountInFunctionalCrcy,CreditAmountInFunctionalCrcy' as abap.char(255)) as AmountFieldName,
      cast( '' as abap.char(255)) as TaxBaseAmountFieldName
}
where
  FunctionalCurrencyRole <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/