ACE_ACEDSOI_LEDGER_GRP

DDL: ACE_ACEDSOI_LEDGER_GRP SQL: ACEV_ACEDSOILG Type: view

ACEDSOI has ledger group assigned

ACE_ACEDSOI_LEDGER_GRP is a CDS View that provides data about "ACEDSOI has ledger group assigned" in SAP S/4HANA. It reads from 4 data sources (acedsoh, acedsoi, aceobj, tacc_trgt_ldgr) and exposes 8 fields with key fields comp, bukrs, ref_key, ref_subkey, acrtype.

4 data source(s) 8 fields

Data Sources (4)

SourceAliasJoin Type
acedsoh acedsoh inner
acedsoi acedsoi from
aceobj aceobj inner
tacc_trgt_ldgr tacc_trgt_ldgr inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEDSOILG 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
AbapCatalog.preserveKey true view
EndUserText.label ACEDSOI has ledger group assigned view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY comp acedsoi comp
KEY bukrs acedsoi bukrs
KEY ref_key aceobj ref_key
KEY ref_subkey acedsoh ref_subkey
KEY acrtype acedsoi acrtype
KEY accrule acedsoi accrule
KEY itemtype
ldgrp_gl tacc_trgt_ldgr ldgrp_gl 
@AbapCatalog.sqlViewName: 'ACEV_ACEDSOILG'
@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
@AbapCatalog.preserveKey:true
@EndUserText.label: 'ACEDSOI has ledger group assigned'
define view ACE_ACEDSOI_LEDGER_GRP
  as select from acedsoi
    inner join   acedsoh        on  acedsoi.comp    = acedsoh.comp
                                and acedsoi.bukrs   = acedsoh.bukrs
                                and acedsoi.objid   = acedsoh.objid
                                and acedsoi.subid   = acedsoh.subid
                                and acedsoh.date_to = '99991231'
    inner join   aceobj         on  acedsoi.comp  = aceobj.comp
                                and acedsoi.bukrs = aceobj.bukrs
                                and acedsoi.objid = aceobj.objid
    inner join   tacc_trgt_ldgr on  acedsoi.accrule         =  tacc_trgt_ldgr.acc_principle

{
  key    acedsoi.comp,
  key    acedsoi.bukrs,
  key    aceobj.ref_key,
  key    acedsoh.ref_subkey,
  key    acedsoi.acrtype,
  key    acedsoi.accrule,
  key    concat( concat(acedsoi.acrtype,'_'), acedsoi.accrule ) as itemtype,
         tacc_trgt_ldgr.ldgrp_gl
}
where
  acedsoi.date_to = '99991231'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACEDSOH",
"ACEDSOI",
"ACEOBJ",
"TACC_TRGT_LDGR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More