P_AccrEngineObjTypeParamField

DDL: P_ACCRENGINEOBJTYPEPARAMFIELD Type: view BASIC

P_AccrEngineObjTypeParamField is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (dd03l, tacecomp) and exposes 3 fields with key fields AccrualEngineAccrualObjectType, FieldName.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
dd03l dd03l from
tacecomp tacecomp inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PACEAOBJTYPEPF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType tacecomp comp
KEY FieldName dd03l fieldname
IsCloudSystem R_CloudPackage IsCloudSystem 
@AbapCatalog: {
    sqlViewName: 'PACEAOBJTYPEPF',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
    private: true,
    viewType: #BASIC
}
define view P_AccrEngineObjTypeParamField
  as select from           dd03l
    inner join             tacecomp       on dd03l.tabname = tacecomp.param_fields
    left outer to one join R_CloudPackage on R_CloudPackage.IsCloudSystem = 'X'
{
  key tacecomp.comp   as AccrualEngineAccrualObjectType,
  key dd03l.fieldname as FieldName,
      R_CloudPackage.IsCloudSystem
}
where
          tacecomp.s4ace_used         =  'X'
  and     dd03l.fieldname             <> '.INCLUDE'
  and(
          $projection.iscloudsystem   is null // get everything for OP

    or(
          $projection.iscloudsystem   =  'X'
      and tacecomp.available_in_cloud =  'X' // get Cloud only for Cloud

    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CLOUDPACKAGE",
"DD03L",
"TACECOMP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More