ACE_ACEPSOIT_ACDOCA_CHECK_02

DDL: ACE_ACEPSOIT_ACDOCA_CHECK_02 SQL: ACEV_ACDOCACHK2 Type: view Package: ACE_MIG

check ACEPSOIT against ACDOCA 02

ACE_ACEPSOIT_ACDOCA_CHECK_02 is a CDS View that provides data about "check ACEPSOIT against ACDOCA 02" in SAP S/4HANA. It reads from 2 data sources (ACE_ACEPSOIT_BASIC, acdoca) and exposes 10 fields with key fields mandt, comp, bukrs, gjahr, objid. Part of development package ACE_MIG.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
ACE_ACEPSOIT_BASIC ace_item from
acdoca fi_item left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACDOCACHK2 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
EndUserText.label check ACEPSOIT against ACDOCA 02 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY mandt ACE_ACEPSOIT_BASIC mandt
KEY comp ACE_ACEPSOIT_BASIC comp
KEY bukrs ACE_ACEPSOIT_BASIC bukrs
KEY gjahr ACE_ACEPSOIT_BASIC gjahr
KEY objid ACE_ACEPSOIT_BASIC objid
KEY subid ACE_ACEPSOIT_BASIC subid
KEY acrtype ACE_ACEPSOIT_BASIC acrtype
KEY accrule ACE_ACEPSOIT_BASIC accrule
KEY docnr ACE_ACEPSOIT_BASIC docnr
awref acdoca awref 
@AbapCatalog.sqlViewName: 'ACEV_ACDOCACHK2'
@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
@EndUserText.label: 'check ACEPSOIT against ACDOCA 02'
define view ACE_ACEPSOIT_ACDOCA_CHECK_02
  as select from    ACE_ACEPSOIT_BASIC as ace_item
    left outer join acdoca             as fi_item on  fi_item.rclnt = ace_item.mandt
                                                  and fi_item.awtyp = ace_item.awtyp
                                                  and fi_item.aworg = ace_item.aworg
                                                  and fi_item.awref = ace_item.awref


{
  key ace_item.mandt,
  key ace_item.comp,
  key ace_item.bukrs,
  key ace_item.gjahr,
  key ace_item.objid,
  key ace_item.subid,
  key ace_item.acrtype,
  key ace_item.accrule,
  key ace_item.docnr,
      fi_item.awref
}
where
      ace_item.awref <> ''
  and ace_item.awtyp <> ''
  and ace_item.aworg <> ''
  and fi_item.awref  is null
// deal with the case when awtyp and awkey is not empty, 

//this means FI document posted, 

//but ACDOCA has no this document, then this is an inconsistency scenario

Learn More