ace_chk_aceobj_vs_Vaceobj

DDL: ACE_CHK_ACEOBJ_VS_VACEOBJ SQL: ACEV_ACEOBJCK Type: view

Check ACEOBJ against with Compatitility view ACE_ACEOBJC

ace_chk_aceobj_vs_Vaceobj is a CDS View that provides data about "Check ACEOBJ against with Compatitility view ACE_ACEOBJC" in SAP S/4HANA. It reads from 2 data sources (ACE_ACEOBJC, aceobj) and exposes 5 fields with key fields comp, bukrs, objid.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
ACE_ACEOBJC ACE_ACEOBJC left_outer
aceobj aceobj from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEOBJCK 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 ACEOBJ against with Compatitility view ACE_ACEOBJC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY comp aceobj comp
KEY bukrs aceobj bukrs
KEY objid aceobj objid
ref_keythenXelseendasIsRefKeyEqual
objstatusthenXelseendasIsObjstatusEqual 
@AbapCatalog.sqlViewName: 'ACEV_ACEOBJCK'
@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 ACEOBJ against with Compatitility view ACE_ACEOBJC'
define view ace_chk_aceobj_vs_Vaceobj 
  as select from    aceobj
    left outer join ACE_ACEOBJC on  ACE_ACEOBJC.comp       =  aceobj.comp
                                and ACE_ACEOBJC.bukrs      =  aceobj.bukrs
                                and ACE_ACEOBJC.objid      =  aceobj.objid
//                                and (

//                                   (

//                                     ACE_ACEOBJC.ref_key   <> aceobj.ref_key

//                                   )

//                                   or(

//                                     ACE_ACEOBJC.objstatus <> aceobj.objstatus

//                                   )

//                                 )


{
  key aceobj.comp,
  key aceobj.bukrs,
  key aceobj.objid,

      case when aceobj.ref_key = ACE_ACEOBJC.ref_key
           then 'X'
           else '' end as IsRefKeyEqual,

      case when  aceobj.objstatus = ACE_ACEOBJC.objstatus
           then 'X'
           else '' end as IsObjstatusEqual


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACE_ACEOBJC",
"ACEOBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More