FMLV_CURTP_ML

CDS View

Select ML relevant currencies

FMLV_CURTP_ML is a CDS View in S/4HANA. Select ML relevant currencies. It contains 6 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 6 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FCML_RLDNR view inner ML relevant currencies for SDM
fmlv_ckmlcr_compat view inner Compatibility View for CKMLCR
fmlv_ckmlpr_compat view inner Compatibility View for CKMLPR
FMLV_F4_ML view from Select ML relevant currencies

Fields (6)

KeyField CDS FieldsUsed in Views
KEY curtp curtp 3
KEY rbukrs rbukrs 1
ext_curtype curtp,ext_curtype 4
rcolumn rcolumn 2
rldnr rldnr 4
waers waers 1 
@AbapCatalog.sqlViewName: 'FMLVCURTPML'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering:{
  status: #ACTIVE,
  type: #FULL
}
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
  }
}
@EndUserText.label: 'Select ML relevant currencies'

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

// Use Case 1: Classic ML currency scenario

//   -> ML supports an external currency type only once.

//   -> Return external currency types, independent of assigned ledger.

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

// Use Case 2: Flexible or full parallel accounting scenario

//   -> ML supports same external currency type in multiple ledgers.

//   -> Return unique currency types.

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


define view fmlv_curtp_ml
  as

  select from              fmlt_curtp_ml as curtp_ml

    left outer to one join fmlc_toggle   as switch    on switch.toggle_id = 'FINS_PARALLEL_ACCOUNTING_RS'
    inner join             finsc_ledger  as ledger    on ledger.rldnr = curtp_ml.rldnr
    inner join             finsc_curtype as curtp_def on(   (     curtp_def.curtype     = curtp_ml.curtp 
                                                              and curtp_def.rldnr       = ''
                                                              and ledger.xleading       = 'X' )
                                                          or(     curtp_def.ext_curtype = curtp_ml.curtp 
                                                              and curtp_def.rldnr       = curtp_ml.rldnr
                                                              and ledger.xleading       = '' ) )

{
  key curtp_ml.rbukrs                                                                 as rbukrs,
  key case when switch.is_active = 'X' then curtp_def.curtype else curtp_ml.curtp end as curtp,
      curtp_ml.rldnr                                                                  as rldnr,
      curtp_ml.curtp                                                                  as ext_curtype,
      curtp_ml.rcolumn                                                                as rcolumn,
      curtp_ml.waers                                                                  as waers,
      curtp_ml.is_logistic_curtype                                                    as is_logistic_curtype
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_CURTYPE",
"FINSC_LEDGER",
"FMLC_TOGGLE",
"FMLT_CURTP_ML"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More