Fml_Curtp_Cell

@AbapCatalog.sqlViewName: 'FMLV_CURTP_CELL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@EndUserText.label: 'Mapping ML Curtp to Cell in FINSC_LD_CMP'
// Version (cell view  16.03.16)


//--------------------------------------------------------------------------------------------

// Per each valuation area:

// The view shows all material ledger currency types and shows the cell (RLDNR / Currenvy Group)

// where the ML currency is mapped into table FINSC_LD_CMP

//

// This view is used after the data migration for check function

//--------------------------------------------------------------------------------------------

define view Fml_Curtp_Cell as


  //------------------------------------------------------------

  //  Part 1: Generate entry for currency column type "H"

  //------------------------------------------------------------

  select
    curr.mandt  as mandt,
    curr.bukrs  as bukrs,
    curr.bwkey  as bwkey,
    curr.curtph as curtp,
    'H'         as rcolumn,
    curr.rldnr  as rldnr
  from fmlv_relind_bwke as curr

  // Ledger Table: Take only basis ledger

    inner join I_Ledger as ld 
    on  ld.mandt  = curr.mandt
    and ld.Ledger = curr.rldnr

  // Take only the basis ledger and currency column type "H" if ML relevant

  where
        ld.LedgerType  = ' '
    and curr.mlrelindh = 'X'


  union all
  //--------------------------------------------------------------------------

  //  Part 2: Add now entry for currency column type "K"

  //--------------------------------------------------------------------------

  select
    curr.mandt  as mandt,
    curr.bukrs  as bukrs,
    curr.bwkey  as bwkey,
    curr.curtpk as curtp,
    'K'         as rcolumn,
    curr.rldnr  as rldnr
  from fmlv_relind_bwke as curr

  // Ledger Table: Take only basis ledger

    inner join I_Ledger as ld     
    on  ld.mandt  = curr.mandt
    and ld.Ledger = curr.rldnr

  // Take only the basis ledger and currency column type "K" if ML relevant

  where
        ld.LedgerType  = ' '
    and curr.mlrelindk = 'X'


  union all
  //--------------------------------------------------------------------------

  //  Part 3: Add now entry for currency column type "O"

  //--------------------------------------------------------------------------

  select
    curr.mandt  as mandt,
    curr.bukrs  as bukrs,
    curr.bwkey  as bwkey,
    curr.curtpo as curtp,
    'O'         as rcolumn,
    curr.rldnr  as rldnr
  from fmlv_relind_bwke as curr

  // Ledger Table: Take only basis ledger

    inner join I_Ledger as ld     
    on  ld.mandt  = curr.mandt
    and ld.Ledger = curr.rldnr

  // Take only the basis ledger and currency column type "O" if ML relevant

  where
        ld.LedgerType  = ' '
    and curr.mlrelindo = 'X'


  union all
  //--------------------------------------------------------------------------

  //  Part 4: Add now entry for currency column type "V"

  //--------------------------------------------------------------------------

  select
    curr.mandt  as mandt,
    curr.bukrs  as bukrs,
    curr.bwkey  as bwkey,
    curr.curtpv as curtp,
    'V'         as rcolumn,
    curr.rldnr  as rldnr
  from fmlv_relind_bwke as curr

  // Ledger Table: Take only basis ledger

    inner join I_Ledger as ld     
    on  ld.mandt  = curr.mandt
    and ld.Ledger = curr.rldnr

  // Take only the basis ledger and currency column type "V" if ML relevant

  where
        ld.LedgerType  = ' '
    and curr.mlrelindv = 'X'            
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"FMLV_RELIND_BWKE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/