FMUSFGA_COMPAT

CDS View

Compatibility view for FMUSFGA replace with ACDOCA

FMUSFGA_COMPAT is a CDS View in S/4HANA. Compatibility view for FMUSFGA replace with ACDOCA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FMUSFGA_FROM_ACDOCA_CCFWD view from Ledger 95 data from ACDOCA for correction/close postings 
@AbapCatalog.sqlViewName: 'FMUSFGA_COMPAT_V'
@ClientHandling.algorithm: #AUTOMATED  // SESSION_VARIABLE causes short dump with CLIENT-SPECIFIED

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.viewEnhancementCategory: [#UNION, #PROJECTION_LIST]
//@AbapCatalog.preserveKey:false

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Compatibility view for FMUSFGA replace with ACDOCA'

define view FMUSFGA_COMPAT
  as select from fmusfga
{
  //rclnt,

  gl_sirid,
  rldnr,
  rrcty,
  rvers,
  ryear,
  fmusfga.rtcur,
  drcrk,
  poper,
  docct,
  docnr,
  docln,
  rbukrs,
  racct,
  rbusa,
  rprctr,
  rcntr,
  rprojk,
  rfarea,
  rfund
}

union all

select from  acdoca
  inner join fmfg_uj_activ as activation on acdoca.rclnt = activation.client
association [1..1] to finsc_ledger on  acdoca.rldnr          = finsc_ledger.rldnr
                                   and finsc_ledger.xleading = 'X' // Leading ledger only

association [1..1] to bkpf         on  acdoca.rbukrs = bkpf.bukrs // TO GET HEADER FIELDS NOT DUPLICATED IN ACDOCA

                                   and acdoca.gjahr  = bkpf.gjahr
                                   and acdoca.belnr  = bkpf.belnr
//association [0..1] to prps         on  acdoca.ps_posid = prps.posid // TO GET CORRECT FORMAT TO REPLACE FMUSFGA.PROJK

association [0..1] to prps         on  acdoca.ps_psp_pnr = prps.pspnr // TO GET CORRECT FORMAT TO REPLACE FMUSFGA.PROJK

{
  //rclnt,

  cast('000000000000000000' as abap.char( 18 ))                                           as gl_sirid,
  cast('95' as abap.char(2))                                                              as rldnr,
  acdoca.rrcty,
  cast('001' as abap.char(3))                                                             as rvers,
  acdoca.ryear,
  acdoca.rtcur,
  acdoca.drcrk,
  acdoca.poper,
  'S'                                                                                     as docct,
  acdoca.belnr                                                                            as docnr,
  acdoca.docln,
  acdoca.rbukrs,
  acdoca.racct,
  acdoca.rbusa,
  acdoca.prctr                                                                            as rprctr,
  acdoca.rcntr,
//   Note 3469048

//  prps.pspnr                                                                             as rprojk,

  case
   when acdoca.ps_psp_pnr = '00000000'
   then acdoca.ps_psp_pnr
  else prps.pspnr
  end                                                                                     as rprojk,
  acdoca.rfarea,
  acdoca.rfund
}
where
       activation.uj_activation_timestamp <= acdoca.timestamp // Entered on or after UL activation

  and  acdoca.rldnr = finsc_ledger.rldnr
  and(
       acdoca.bstat = ' '
   or  acdoca.bstat = 'L'
   or  acdoca.bstat = 'U'
   or  acdoca.bstat = 'J'
   or  acdoca.bstat = 'T'
//   or (bstat = 'C' and poper = '000')  As requested by customers Note 3458380

  ) // Normal/clearing/reset clearing/noted items only

  // Updated with new bstat values based on feedback from FI (Ruediger)

Learn More