ACE_ACESOBJ_PARAM

DDL: ACE_ACESOBJ_PARAM SQL: ACEV_SOBJ_PARAM Type: view

View From ACEOBJ ACEPSOH ACEDSOP

ACE_ACESOBJ_PARAM is a CDS View that provides data about "View From ACEOBJ ACEPSOH ACEDSOP" in SAP S/4HANA. It reads from 3 data sources (acedsop, aceobj, acepsoh) and exposes 9 fields with key fields comp, bukrs, ref_key, ref_subkey, param_name.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
acedsop acedsop from
aceobj aceobj inner
acepsoh acepsoh inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_SOBJ_PARAM 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 View From ACEOBJ ACEPSOH ACEDSOP view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY comp acedsop comp
KEY bukrs acedsop bukrs
KEY ref_key aceobj ref_key
KEY ref_subkey acepsoh ref_subkey
KEY param_name acedsop param_name
KEY date_to acedsop date_to
date_from acedsop date_from
content acedsop content
content_xml acedsop content_xml 
@AbapCatalog.sqlViewName: 'ACEV_SOBJ_PARAM'
@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: 'View From ACEOBJ ACEPSOH ACEDSOP'
define view ACE_ACESOBJ_PARAM 
  as select from acedsop 
    inner join aceobj   on  acedsop.comp  = aceobj.comp
                        and acedsop.bukrs = aceobj.bukrs
                        and acedsop.objid = aceobj.objid
    inner join acepsoh  on  acedsop.comp  = acepsoh.comp
                        and acedsop.bukrs = acepsoh.bukrs
                        and acedsop.objid = acepsoh.objid
                        and acedsop.subid = acepsoh.subid
{
  key acedsop.comp,
  key acedsop.bukrs,
  key aceobj.ref_key,
  key acepsoh.ref_subkey,  
  
  key acedsop.param_name,
  key acedsop.date_to,
  
  acedsop.date_from,
  acedsop.content,
  acedsop.content_xml
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACEDSOP",
"ACEOBJ",
"ACEPSOH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More