ACE_ACEPSOIT_ACEPSOITV_UNION

DDL: ACE_ACEPSOIT_ACEPSOITV_UNION SQL: ACEV_ACEPSOITVU Type: view

Union ACEPSOIT and view ACEPSOIT

ACE_ACEPSOIT_ACEPSOITV_UNION is a CDS View that provides data about "Union ACEPSOIT and view ACEPSOIT" in SAP S/4HANA. It reads from 2 data sources (ACE_ACEPSOIT, acepsoit) and exposes 31 fields with key fields mandt, comp, bukrs, objid, subid.

2 data source(s) 31 fields

Data Sources (2)

SourceAliasJoin Type
ACE_ACEPSOIT ACE_ACEPSOIT union_all
acepsoit acepsoit from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOITVU 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 Union ACEPSOIT and view ACEPSOIT view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY comp comp
KEY bukrs bukrs
KEY objid objid
KEY subid subid
KEY acrtype acrtype
KEY accrule accrule
valtbp
currency currency
transtype transtype
effdate effdate
podate podate
poper poper
poyear poyear
awtyp awtyp
KEY comp comp
KEY bukrs bukrs
KEY gjahr gjahr
KEY objid objid
KEY subid subid
KEY acrtype acrtype
KEY accrule accrule
valtbp valtbp
currency currency
transtype transtype
effdate effdate
podate podate
poper poper
poyear poyear
awtyp awtyp
awkey awkey 
@AbapCatalog.sqlViewName: 'ACEV_ACEPSOITVU'
@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: 'Union ACEPSOIT and view ACEPSOIT'
define view ACE_ACEPSOIT_ACEPSOITV_UNION
  as select from acepsoit
{
  key mandt,
  key comp,
  key bukrs,
  key case when poyear is initial then gjahr
      else poyear end as gjahr,
  key objid,
  key subid,
  key acrtype,
  key accrule,
      (-1)*valtbp as valtbp,
      currency,
      transtype,
      effdate,
      podate,
      poper,
      poyear,
      awtyp,
      awkey
}

union all select from ACE_ACEPSOIT
{
  key mandt,
  key comp,
  key bukrs,
  key gjahr,
  key objid,
  key subid,
  key acrtype,
  key accrule,
      valtbp,
      currency,
      transtype,
      effdate,
      podate,
      poper,
      poyear,
      awtyp,
      awkey
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACE_ACEPSOIT",
"ACEPSOIT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More