JV_JVSO1_COMB_DOC_BALANCE

DDL: JV_JVSO1_COMB_DOC_BALANCE SQL: CJVSO1DOCBAL Type: view Package: GJVA_MIG

Doc. bal. for 4A/4C view on JVSO1

JV_JVSO1_COMB_DOC_BALANCE is a CDS View that provides data about "Doc. bal. for 4A/4C view on JVSO1" in SAP S/4HANA. It reads from 3 data sources (bkpf, JV_JVSO1_COMB, finsc_ledger) and exposes 23 fields. Part of development package GJVA_MIG.

3 data source(s) 23 fields

Data Sources (3)

SourceAliasJoin Type
bkpf bkpf inner
JV_JVSO1_COMB jv from
finsc_ledger ll right_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CJVSO1DOCBAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Doc. bal. for 4A/4C view on JVSO1 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
rldnr JV_JVSO1_COMB rldnr
rldnr_gl finsc_ledger rldnr
rbukrs JV_JVSO1_COMB rbukrs
ryear JV_JVSO1_COMB ryear
reffidoc JV_JVSO1_COMB reffidoc
tcode bkpf tcode
awtyp bkpf awtyp
racct JV_JVSO1_COMB racct
rjvnam JV_JVSO1_COMB rjvnam
regrou JV_JVSO1_COMB regrou
rpartn JV_JVSO1_COMB rpartn
rrecin JV_JVSO1_COMB rrecin
bilid JV_JVSO1_COMB bilid
rtcur JV_JVSO1_COMB rtcur
hwaer JV_JVSO1_COMB hwaer
hwae2 JV_JVSO1_COMB hwae2
hwae3 JV_JVSO1_COMB hwae3
hwae4 JV_JVSO1_COMB hwae4
tsl
hsl
ksl_4a
hsl_4c
ksl_4c 
@AbapCatalog.sqlViewName: 'CJVSO1DOCBAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.dataMaintenance: #DISPLAY_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Doc. bal. for 4A/4C view on JVSO1'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE ]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE

define view JV_JVSO1_COMB_DOC_BALANCE

  as select from     JV_JVSO1_COMB as jv

    inner join       bkpf                on  bkpf.bukrs = jv.rbukrs
                                         and bkpf.gjahr = jv.ryear
                                         and bkpf.belnr = jv.reffidoc

    right outer join finsc_ledger  as ll on  ll.ledger_type = ' '
                                         and ll.xleading    = 'X'

{
  jv.rldnr,
  ll.rldnr         as rldnr_gl,

  jv.rbukrs,
  jv.ryear,
  jv.reffidoc,

  bkpf.tcode,
  bkpf.awtyp,

  jv.racct,
  jv.rjvnam,
  jv.regrou,
  jv.rpartn,
  jv.rrecin,
  jv.bilid,

  jv.rtcur,
  jv.hwaer,
  jv.hwae2,
  jv.hwae3,
  jv.hwae4,

  @Semantics.amount.currencyCode: 'rtcur'
  sum( jv.tsl )    as tsl,
  @Semantics.amount.currencyCode: 'hwaer'
  sum( jv.hsl )    as hsl,
  @Semantics.amount.currencyCode: 'hwae2'
  sum( jv.ksl_4a ) as ksl_4a,
  @Semantics.amount.currencyCode: 'hwae3'
  sum( jv.hsl_4c ) as hsl_4c,
  @Semantics.amount.currencyCode: 'hwae4'
  sum( jv.ksl_4c ) as ksl_4c

}

where
  (
       bkpf.rldnr  is initial
    or bkpf.rldnr  =  ll.rldnr
  )

  and  jv.activ    =  'JVFI'
  and  jv.refactiv <> 'COFI'

group by
  jv.rldnr,
  ll.rldnr,
  jv.rbukrs,
  jv.ryear,
  jv.reffidoc,

  bkpf.tcode,
  bkpf.awtyp,

  jv.racct,
  jv.rjvnam,
  jv.regrou,
  jv.rpartn,
  jv.rrecin,
  jv.bilid,

  jv.rtcur,
  jv.hwaer,
  jv.hwae2,
  jv.hwae3,
  jv.hwae4

Learn More