ACE_ACEPSOI_BASIC

DDL: ACE_ACEPSOI_BASIC SQL: ACEV_ACEPSOIBSC Type: view

basic view for ACEPSOI

ACE_ACEPSOI_BASIC is a CDS View that provides data about "basic view for ACEPSOI" in SAP S/4HANA. It reads from 3 data sources (acac_objects, acepsoi, acesobj) and exposes 17 fields with key fields mandt, comp, bukrs, gjahr, objid.

3 data source(s) 17 fields

Data Sources (3)

SourceAliasJoin Type
acac_objects acac_objects left_outer
acepsoi acepsoi from
acesobj acesobj left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOIBSC 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 basic view for ACEPSOI view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY mandt acepsoi mandt
KEY comp acepsoi comp
KEY bukrs acepsoi bukrs
KEY gjahr gjahr
KEY objid acepsoi objid
KEY subid acepsoi subid
KEY acrtype acrtype
KEY accrule accrule
cumvalcap cumvalcap
cumvalaccr cumvalaccr
valcap valcap
valaccr valaccr
valretire valretire
currency currency
ref_key acesobj ref_key
ref_subkey acesobj ref_subkey
acac_objtype acac_objects acac_objtype 
@AbapCatalog.sqlViewName: 'ACEV_ACEPSOIBSC'
@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: 'basic view for ACEPSOI'
define view ACE_ACEPSOI_BASIC
  as select from    acepsoi
    left outer join acesobj on  acepsoi.mandt = acesobj.mandt
                            and acepsoi.comp  = acesobj.comp
                            and acepsoi.bukrs = acesobj.bukrs
                            and acepsoi.objid = acesobj.objid
                            and acepsoi.subid = acesobj.subid
    left outer join acac_objects on acac_objects.mandt = acesobj.mandt
                                and acac_objects.bukrs = acesobj.bukrs
                                and acac_objects.ref_key = acesobj.ref_key
                                and acac_objects.ref_subkey = acesobj.ref_subkey
{
  key acepsoi.mandt,
  key acepsoi.comp,
  key acepsoi.bukrs,
  key gjahr,
  key acepsoi.objid,
  key acepsoi.subid,
  key acrtype,
  key accrule,
      cumvalcap,
      cumvalaccr,
      valcap,
      valaccr,
      valretire,
      currency,
      acesobj.ref_key,
      acesobj.ref_subkey,
      acac_objects.acac_objtype
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACAC_OBJECTS",
"ACEPSOI",
"ACESOBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More