FAC_CDS_SH_ACTIVE_FSV

DDL: FINS_SH_ACTIVE_FSV SQL: FISV_ACT_FSV Type: view Package: FINS_FI_UH

Active Financial Statement Versions

FAC_CDS_SH_ACTIVE_FSV is a CDS View that provides data about "Active Financial Statement Versions" in SAP S/4HANA. It reads from 2 data sources (hrrp_node_n, hrrp_dirt_n) and exposes 4 fields with key fields versn, ktopl, spras. Part of development package FINS_FI_UH.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
hrrp_node_n node inner
hrrp_dirt_n t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FISV_ACT_FSV view
EndUserText.label Active Financial Statement Versions view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY versn
KEY ktopl hrrp_node_n ktopl
KEY spras hrrp_dirt_n spras
vstxt 
@AbapCatalog.sqlViewName: 'FISV_ACT_FSV'
@EndUserText.label: 'Active Financial Statement Versions'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.compiler.compareFilter:true

define view FAC_CDS_SH_ACTIVE_FSV
  as select distinct from(
    (
                      hrrp_dir_n  as dir
        inner join    hrrp_node_n as node on  dir.hryid     =  node.hryid
                                          and dir.hrytyp    =  node.hrytyp
                                          and dir.hryvalto  =  node.hryvalto
                                          and node.nodetype =  'L'
                                          and node.nodecls  <> ''
    )
      left outer join hrrp_dirt_n as t    on  dir.hryid    = t.hryid
                                          and dir.hrytyp   = t.hrytyp
                                          and dir.hryvalto = t.hryvalto
                                          and t.spras      = $session.system_language
  )

{

  key   cast(dir.hryid as versn_011 )                 as versn,
  key   node.ktopl                                    as ktopl,
  key   t.spras                                       as spras,
        cast(t.hrytxt as vstxt_011t preserving type ) as vstxt
}
where
       dir.hrytyp    = 'FSVN'
  and  dir.hryid     not like '0102/%'
  and  dir.hryid     not like '0109/%'
  and  dir.hryid     not like 'H109/%'
  and  dir.hryid     not like '%_DRAFT'

  and(
       dir.hryvalto  = '99991231'
    or dir.hrysource = 'UH'
  )

Learn More