I_IMGACT

DDL: I_IMGACT SQL: IIMGACT Type: view

Ermittlung der IMG Aktivität ID

I_IMGACT is a CDS View that provides data about "Ermittlung der IMG Aktivität ID" in SAP S/4HANA. It reads from 3 data sources (cus_actobj, cus_imgach, I_NumberRangeObject) and exposes 5 fields.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
cus_actobj cusactobj inner
cus_imgach cusimgact from
I_NumberRangeObject obj inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName IIMGACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.dataMaintenance #RESTRICTED view
EndUserText.label Ermittlung der IMG Aktivität ID view

Fields (5)

KeyFieldSource TableSource FieldDescription
CActivity cus_imgach c_activity
IMGTCode cus_imgach tcode
Activity cus_actobj act_id
TCode cus_actobj tcode
Object I_NumberRangeObject NumberRangeObject 
@AbapCatalog.sqlViewName: 'IIMGACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.dataMaintenance : #RESTRICTED
@EndUserText.label: 'Ermittlung der IMG Aktivität ID'
define view I_IMGACT as select from cus_imgach as cusimgact 
inner join cus_actobj as cusactobj on cusimgact.c_activity = cusactobj.act_id
inner join I_NumberRangeObject as obj on cusactobj.tcode = obj.NumberRangeTransactionCode
{
 // key cusimgact.activity as Activity,

  cusimgact.c_activity as CActivity,
  cusimgact.tcode as IMGTCode,
  cusactobj.act_id as Activity,
  cusactobj.tcode as TCode,
  obj.NumberRangeObject as Object
 
} where cusactobj.objectname = 'SNUM' and cusactobj.objecttype = 'T'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NUMBERRANGEOBJECT",
"CUS_ACTOBJ",
"CUS_IMGACH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More