ACE_ACDOCA_REF_DOC_TOTAL_01

DDL: ACE_ACDOCA_REF_DOC_TOTAL_01 SQL: ACEV_ACDOCAT1 Type: view

Calc total amount for summarized case

ACE_ACDOCA_REF_DOC_TOTAL_01 is a CDS View that provides data about "Calc total amount for summarized case" in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 15 fields with key fields rclnt, rldnr, rbukrs, gjahr, belnr.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
acdoca acdoca from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACDOCAT1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Calc total amount for summarized case view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY rclnt rclnt
KEY rldnr acdoca rldnr
KEY rbukrs rbukrs
KEY gjahr gjahr
KEY belnr belnr
KEY docln docln
awtyp awtyp
aworg aworg
awref awref
drcrk drcrk
budat budat
poper poper
ryear ryear
rwcur rwcur
bldat bldat 
@AbapCatalog.sqlViewName: 'ACEV_ACDOCAT1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Calc total amount for summarized case'
define view ACE_ACDOCA_REF_DOC_TOTAL_01
  as select from acdoca       as acdoca
//    inner join   finsc_ledger as ledger on  acdoca.rclnt = ledger.mandt

//                                        and acdoca.rldnr = ledger.rldnr

//                                        and xleading     = 'X'

{
  key rclnt,
  key acdoca.rldnr,
  key rbukrs,
  key gjahr,
  key belnr,
  key docln,
      awtyp,
      aworg,
      awref,
      drcrk,
      budat,
      poper,
      ryear,
      rwcur,
      bldat,
      case when wsl >= 0 then wsl
      else (-1) * wsl
      end as wsl
}
where
      awref <> ''
  and awtyp <> ''
  and aworg <> ''
  and drcrk =  'S'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More