ACE_ACEPSOIT_REF_DOC_TOTAL_01

DDL: ACE_ACEPSOIT_REF_DOC_TOTAL_01 SQL: ACEV_ACEPSOITT1 Type: view Package: ACE_MIG

Calc total amount for summarized case

ACE_ACEPSOIT_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 (ACE_ACEPSOIT_BASIC) and exposes 18 fields with key fields mandt, comp, bukrs, gjahr, objid. Part of development package ACE_MIG.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
ACE_ACEPSOIT_BASIC ACE_ACEPSOIT_BASIC from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOITT1 view
AbapCatalog.compiler.compareFilter 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 (18)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY comp comp
KEY bukrs bukrs
KEY gjahr gjahr
KEY objid objid
KEY subid subid
KEY acrtype acrtype
KEY accrule accrule
KEY docnr docnr
currency currency
transtype transtype
effdate effdate
podate podate
poper poper
poyear poyear
awtyp awtyp
awref awref
aworg aworg 
@AbapCatalog.sqlViewName: 'ACEV_ACEPSOITT1'
@AbapCatalog.compiler.compareFilter: 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_ACEPSOIT_REF_DOC_TOTAL_01
  as select from ACE_ACEPSOIT_BASIC
{
  key mandt,
  key comp,
  key bukrs,
  key gjahr,
  key objid,
  key subid,
  key acrtype,
  key accrule,
  key docnr,
      case when valtbp >= 0 then valtbp
      else (-1) * valtbp
      end as valtbp,
      currency,
      transtype,
      effdate,
      podate,
      poper,
      poyear,
      awtyp,
      awref,
      aworg
}
where
      awtyp <> '' //there is a case that field AWKEY is 'NOT_RELEVANT'

Learn More