JV_ACDOCA_BILLING

DDL: JV_ACDOCA_BILLING SQL: CJVACDOCA_BILL Type: view Package: GJVA_MIG

JVA view on ACDOCA for partner billing

JV_ACDOCA_BILLING is a CDS View that provides data about "JVA view on ACDOCA for partner billing" in SAP S/4HANA. It reads from 2 data sources (acdoca, t001) and exposes 69 fields with key fields rclnt, rbukrs, gjahr, belnr, docln. Part of development package GJVA_MIG.

2 data source(s) 69 fields

Data Sources (2)

SourceAliasJoin Type
acdoca acdoca from
t001 t001 inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CJVACDOCA_BILL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label JVA view on ACDOCA for partner billing view
ObjectModel.supportedCapabilities #SQL_DATA_SOURCE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY rclnt acdoca rclnt
KEY rbukrs acdoca rbukrs
KEY gjahr acdoca gjahr
KEY belnr acdoca belnr
KEY docln acdoca docln
buzei acdoca buzei
co_belnr acdoca co_belnr
co_buzei acdoca co_buzei
vorgn acdoca vorgn
blart acdoca blart
ryear acdoca ryear
poper acdoca poper
budat acdoca budat
bldat acdoca bldat
awref acdoca awref
aworg acdoca aworg
awitem acdoca awitem
awtyp acdoca awtyp
awsys acdoca awsys
prec_awref acdoca prec_awref
prec_aworg acdoca prec_aworg
prec_awitem acdoca prec_awitem
prec_awtyp acdoca prec_awtyp
prec_awsys acdoca prec_awsys
src_awref acdoca src_awref
src_aworg acdoca src_aworg
src_awitem acdoca src_awitem
src_awtyp acdoca src_awtyp
src_awsys acdoca src_awsys
racct acdoca racct
rbusa acdoca rbusa
kokrs acdoca kokrs
sgtxt acdoca sgtxt
mwskz acdoca mwskz
ktosl acdoca ktosl
vname acdoca vname
egrup acdoca egrup
btype acdoca btype
kunnr acdoca kunnr
lifnr acdoca lifnr
vptnr acdoca vptnr
billm acdoca billm
pom acdoca pom
jvactivity acdoca jvactivity
drcrk acdoca drcrk
rwcur acdoca rwcur
rhcur acdoca rhcur
rkcur acdoca rkcur
rocur acdoca rocur
rvcur acdoca rvcur
rbcur acdoca rbcur
rccur acdoca rccur
rdcur acdoca rdcur
recur acdoca recur
rfcur acdoca rfcur
rgcur acdoca rgcur
wsl acdoca wsl
hsl acdoca hsl
ksl acdoca ksl
osl acdoca osl
vsl acdoca vsl
bsl acdoca bsl
csl acdoca csl
dsl acdoca dsl
esl acdoca esl
fsl acdoca fsl
gsl acdoca gsl
usnam acdoca usnam
timestamp acdoca timestamp 
@AbapCatalog.sqlViewName: 'CJVACDOCA_BILL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.dataMaintenance: #DISPLAY_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'JVA view on ACDOCA for partner billing'
@ObjectModel.supportedCapabilities: #SQL_DATA_SOURCE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE

define view JV_ACDOCA_BILLING

  as select from           acdoca

    inner join             t001        on  t001.bukrs = acdoca.rbukrs
                                       and t001.xjvaa = 'X'
  //Join the ledger

    left outer to one join I_JVALedger on I_JVALedger.CompanyCode = acdoca.rbukrs

{
  key acdoca.rclnt,
  key acdoca.rbukrs,
  key acdoca.gjahr,
  key acdoca.belnr,
  key acdoca.docln,
      acdoca.buzei,

      acdoca.co_belnr,
      acdoca.co_buzei,

      acdoca.vorgn,
      acdoca.blart,

      acdoca.ryear,
      acdoca.poper,

      acdoca.budat,
      acdoca.bldat,

      acdoca.awref,
      acdoca.aworg,
      acdoca.awitem,
      acdoca.awtyp,
      acdoca.awsys,

      acdoca.prec_awref,
      acdoca.prec_aworg,
      acdoca.prec_awitem,
      acdoca.prec_awtyp,
      acdoca.prec_awsys,

      acdoca.src_awref,
      acdoca.src_aworg,
      acdoca.src_awitem,
      acdoca.src_awtyp,
      acdoca.src_awsys,

      acdoca.racct,
      acdoca.rbusa,
      acdoca.kokrs,

      acdoca.sgtxt,

      acdoca.mwskz,
      acdoca.ktosl,


      acdoca.vname,
      acdoca.egrup,
      acdoca.btype,
      acdoca.kunnr,
      acdoca.lifnr,
      acdoca.vptnr,
      acdoca.billm,
      acdoca.pom,
      acdoca.jvactivity,

      acdoca.drcrk,

      acdoca.rwcur,
      acdoca.rhcur,
      acdoca.rkcur,
      acdoca.rocur,
      acdoca.rvcur,
      acdoca.rbcur,
      acdoca.rccur,
      acdoca.rdcur,
      acdoca.recur,
      acdoca.rfcur,
      acdoca.rgcur,

      @Semantics.amount.currencyCode: 'rwcur'
      acdoca.wsl,
      @Semantics.amount.currencyCode: 'rhcur'
      acdoca.hsl,
      @Semantics.amount.currencyCode: 'rkcur'
      acdoca.ksl,
      @Semantics.amount.currencyCode: 'rocur'
      acdoca.osl,
      @Semantics.amount.currencyCode: 'rvcur'
      acdoca.vsl,
      @Semantics.amount.currencyCode: 'rbcur'
      acdoca.bsl,
      @Semantics.amount.currencyCode: 'rccur'
      acdoca.csl,
      @Semantics.amount.currencyCode: 'rdcur'
      acdoca.dsl,
      @Semantics.amount.currencyCode: 'recur'
      acdoca.esl,
      @Semantics.amount.currencyCode: 'rfcur'
      acdoca.fsl,
      @Semantics.amount.currencyCode: 'rgcur'
      acdoca.gsl,

      acdoca.usnam,

      acdoca.timestamp,
      cast( tstmp_to_dats(
        acdoca.timestamp,
        abap_system_timezone( $session.client, 'NULL' ),
        $session.client,
        'NULL' ) as cpudt preserving type ) as cpudt,

      cast( tstmp_to_tims(
        acdoca.timestamp,
        abap_system_timezone( $session.client, 'NULL' ),
        $session.client,
        'NULL' ) as cputm preserving type ) as cputm

}

where
        acdoca.rldnr = I_JVALedger.Ledger
  and(
        acdoca.kunnr is not initial
    and acdoca.btype is not initial
  )

Learn More