ACE_ACESOBJ_ASSGMT

DDL: ACE_ACESOBJ_ASSGMT SQL: ACEV_SOBJ_ASSGMT Type: view

View From ACEOBJ ACEPSOH ACEDSASSGMT

ACE_ACESOBJ_ASSGMT is a CDS View that provides data about "View From ACEOBJ ACEPSOH ACEDSASSGMT" in SAP S/4HANA. It reads from 4 data sources (acedsassgmt, aceobj, acepsoh, prps) and exposes 26 fields with key fields comp, bukrs, ref_key, ref_subkey, date_to.

4 data source(s) 26 fields

Data Sources (4)

SourceAliasJoin Type
acedsassgmt acedsassgmt from
aceobj aceobj inner
acepsoh acepsoh inner
prps prps left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_SOBJ_ASSGMT 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 ACEDSASSGMT view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY comp acedsassgmt comp
KEY bukrs acedsassgmt bukrs
KEY ref_key aceobj ref_key
KEY ref_subkey acepsoh ref_subkey
KEY date_to acedsassgmt date_to
date_from acedsassgmt date_from
gsber acedsassgmt bus_area
prctr acedsassgmt profit_ctr
segment acedsassgmt segment
geber acedsassgmt fund
fistl acedsassgmt funds_ctr
fipos acedsassgmt cmmt_item
fkber acedsassgmt func_area_long
grant_nbr acedsassgmt grant_nbr
measure acedsassgmt measure
budget_pd acedsassgmt budget_period
kostl acedsassgmt costcenter
aufnr acedsassgmt orderid
ps_psp_pnr prps pspnr
kstrg acedsassgmt costobject
lstar acedsassgmt acttype
nplnr acedsassgmt network
aufpl acedsassgmt routing_no
prznr acedsassgmt co_busproc
kdauf acedsassgmt sales_ord
kdpos acedsassgmt s_ord_item 
@AbapCatalog.sqlViewName: 'ACEV_SOBJ_ASSGMT'
@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 ACEDSASSGMT'
define view ACE_ACESOBJ_ASSGMT
  as select from acedsassgmt 
    inner join aceobj   on  acedsassgmt.comp  = aceobj.comp
                        and acedsassgmt.bukrs = aceobj.bukrs
                        and acedsassgmt.objid = aceobj.objid
    inner join acepsoh  on  acedsassgmt.comp  = acepsoh.comp
                        and acedsassgmt.bukrs = acepsoh.bukrs
                        and acedsassgmt.objid = acepsoh.objid
                        and acedsassgmt.subid = acepsoh.subid
                        
    left outer join prps    on acedsassgmt.wbs_element = prps.posid
{
  key acedsassgmt.comp,
  key acedsassgmt.bukrs,
  key aceobj.ref_key,
  key acepsoh.ref_subkey,  
  
  key acedsassgmt.date_to,
  
  acedsassgmt.date_from,
  
  acedsassgmt.bus_area as gsber,
  acedsassgmt.profit_ctr as prctr,
  acedsassgmt.segment,
  acedsassgmt.fund as geber,
  acedsassgmt.funds_ctr as fistl,
  acedsassgmt.cmmt_item as fipos,
  acedsassgmt.func_area_long as fkber,
  acedsassgmt.grant_nbr,
  acedsassgmt.measure,
  
  acedsassgmt.budget_period as budget_pd,
  acedsassgmt.costcenter as kostl,
  acedsassgmt.orderid as aufnr,
  prps.pspnr as ps_psp_pnr,
  acedsassgmt.costobject as kstrg,
  acedsassgmt.acttype as lstar,
  acedsassgmt.network as nplnr,
  acedsassgmt.routing_no as aufpl,
  acedsassgmt.co_busproc as prznr,
  acedsassgmt.sales_ord as kdauf,
  acedsassgmt.s_ord_item as kdpos
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACEDSASSGMT",
"ACEOBJ",
"ACEPSOH",
"PRPS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More