ACE_ACEDSOPC

DDL: ACE_ACEDSOPC SQL: ACEV_ACEDSOPC Type: view

Compatibility view for ACEDSOP

ACE_ACEDSOPC is a CDS View that provides data about "Compatibility view for ACEDSOP" in SAP S/4HANA. It reads from 2 data sources (acesobj, acesobj_param) and exposes 9 fields with key fields comp, bukrs, objid, subid, param_name.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
acesobj acesobj inner
acesobj_param acesobj_param from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEDSOPC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Compatibility view for ACEDSOP view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY comp acesobj_param comp
KEY bukrs acesobj_param bukrs
KEY objid acesobj objid
KEY subid acesobj subid
KEY param_name acesobj_param param_name
KEY date_to acesobj_param date_to
date_from acesobj_param date_from
content acesobj_param content
content_xml acesobj_param content_xml 
@AbapCatalog.sqlViewName: 'ACEV_ACEDSOPC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Compatibility view for ACEDSOP'
@AbapCatalog.preserveKey:true

define view ACE_ACEDSOPC
  as select from acesobj_param
    inner join   acesobj on  acesobj_param.comp       = acesobj.comp
                         and acesobj_param.logsys     = acesobj.logsys
                         and acesobj_param.bukrs      = acesobj.bukrs
                         and acesobj_param.ref_key    = acesobj.ref_key
                         and acesobj_param.ref_subkey = acesobj.ref_subkey
{
  key acesobj_param.comp,
  key acesobj_param.bukrs,
  key acesobj.objid,
  key acesobj.subid,

  key acesobj_param.param_name,
  key acesobj_param.date_to,

      acesobj_param.date_from,
      acesobj_param.content,
      acesobj_param.content_xml
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACESOBJ",
"ACESOBJ_PARAM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More