I_ApplicationDocumentItem

DDL: I_APPLICATIONDOCUMENTITEM SQL: IACMCASCAI Type: view BASIC

ACM Basic View For CA Application Document Item

I_ApplicationDocumentItem is a Basic CDS View that provides data about "ACM Basic View For CA Application Document Item" in SAP S/4HANA. It reads from 2 data sources (/accgo/t_cas_cai, jest) and exposes 11 fields with key fields ApplicationDocument, ApplicationDocumentItem, Side, SubItem.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
/accgo/t_cas_cai appdata from
jest status inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IACMCASCAI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label ACM Basic View For CA Application Document Item view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument appldoc
KEY ApplicationDocumentItem item
KEY Side side
KEY SubItem sub_item
ContrAppItmCat item_cat
LDCId uis_id
ApplicationStatusObject appl_objnr
Plant werks
ACMPrecedingDocument1 pred_doc1
ACMPrecedingDocumentItem1 pred_item1
ACMPrecedingDocument5 pred_doc5 
@AbapCatalog.sqlViewName: 'IACMCASCAI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'ACM Basic View For CA Application Document Item'
@VDM.viewType: #BASIC
@ObjectModel.usageType:{ dataClass: #TRANSACTIONAL,
                         serviceQuality: #D,
                         sizeCategory: #L }

define view I_ApplicationDocumentItem
  as select from /accgo/t_cas_cai as appdata
  inner join jest as status on  status.objnr = appdata.appl_objnr
                            and status.inact = ' '
                                                                  
{

  key appldoc  as ApplicationDocument,
  key item     as ApplicationDocumentItem,
  key side     as Side,
  key sub_item as SubItem,
      item_cat as ContrAppItmCat,
      uis_id   as LDCId,
      appl_objnr as ApplicationStatusObject,
      werks     as Plant,
      pred_doc1      as ACMPrecedingDocument1,              
      pred_item1     as ACMPrecedingDocumentItem1,          
      pred_doc5      as ACMPrecedingDocument5
}
where status.stat  <> 'I7A06'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_CAS_CAI",
"JEST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More