ACE_ACEPSOIT_ACDOCA_CHECK_03

DDL: ACE_ACEPSOIT_ACDOCA_CHECK_03 SQL: ACEV_ACDOCACHK3 Type: view Package: ACE_MIG

check ACEPSOIT against ACDOCA 03

ACE_ACEPSOIT_ACDOCA_CHECK_03 is a CDS View that provides data about "check ACEPSOIT against ACDOCA 03" in SAP S/4HANA. It reads from 1 data source (ACE_ACEPSOIT_BASIC) and exposes 9 fields with key fields mandt, comp, bukrs, gjahr, objid. Part of development package ACE_MIG.

Data Sources (1)

SourceAliasJoin Type
ACE_ACEPSOIT_BASIC ACE_ACEPSOIT_BASIC from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACDOCACHK3 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 check ACEPSOIT against ACDOCA 03 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY comp comp
KEY bukrs bukrs
KEY gjahr gjahr
KEY objid objid
KEY subid subid
KEY acrtype acrtype
KEY accrule accrule
KEY docnr docnr
@AbapCatalog.sqlViewName: 'ACEV_ACDOCACHK3'
@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: 'check ACEPSOIT against ACDOCA 03'
define view ACE_ACEPSOIT_ACDOCA_CHECK_03
  as select from ACE_ACEPSOIT_BASIC
{
  key mandt,
  key comp,
  key bukrs,
  key gjahr,
  key objid,
  key subid,
  key acrtype,
  key accrule,
  key docnr
}
where
  awtyp = '' and awkey = ''
// only awtyp and awkey both are empty, means no FI document posted yet

// there are 2 special cases that field AWKEY is 'NOT_RELEVANT' or 'LEGACY', but awtyp is empty