ACE_ACEPSOI_LEDGER

DDL: ACE_ACEPSOI_LEDGER SQL: ACEV_ACEPSOIL Type: view

ACEPSOI with ledger

ACE_ACEPSOI_LEDGER is a CDS View that provides data about "ACEPSOI with ledger" in SAP S/4HANA. It reads from 2 data sources (acepsoi, ACE_ACCOUNT_PRINCIPLE_LEDGER) and exposes 8 fields with key fields comp, bukrs, gjahr, objid, subid.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
acepsoi a from
ACE_ACCOUNT_PRINCIPLE_LEDGER b left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
EndUserText.label ACEPSOI with ledger view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY comp acepsoi comp
KEY bukrs acepsoi bukrs
KEY gjahr gjahr
KEY objid objid
KEY subid subid
KEY accrule acepsoi accrule
KEY rldnr rldnr
acrtype acepsoi acrtype 
@AbapCatalog.sqlViewName: 'ACEV_ACEPSOIL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'ACEPSOI with ledger'
define view ACE_ACEPSOI_LEDGER
  as select from    acepsoi                      as a
    left outer join ACE_ACCOUNT_PRINCIPLE_LEDGER as b on  a.comp    = b.comp
                                                      and a.bukrs   = b.bukrs
                                                      and a.accrule = b.accrule
{
  key a.comp,
  key a.bukrs,
  key gjahr,
  key objid,
  key subid,
  key a.accrule,
  key rldnr,
  a.acrtype
}

Learn More