I_AcctgNotifJournalEntry

DDL: I_ACCTGNOTIFJOURNALENTRY SQL: IACCTGNOTIFJE Type: view_entity COMPOSITE

Accounting Notification Journal Entry

I_AcctgNotifJournalEntry is a Composite CDS View that provides data about "Accounting Notification Journal Entry" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 5 fields with key fields AccountingNotificationUUID, AccountingDocument, CompanyCode, FiscalYear.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData I_GLAccountLineItemRawData from

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Accounting Notification Journal Entry view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AccountingNotificationUUID AccountingNotificationUUID
KEY AccountingDocument AccountingDocument
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
_PyrlAcctgNotif _PyrlAcctgNotif 
@VDM.viewType:#COMPOSITE
//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
//@ClientHandling.type: #CLIENT_DEPENDENT

//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Accounting Notification Journal Entry'
//@AbapCatalog.sqlViewName: 'IACCTGNOTIFJE'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
define view entity I_AcctgNotifJournalEntry
  //  with parameters

  //    P_AccountingNotificationUUID : fis_hdr_technical_id

  as select from I_GLAccountLineItemRawData
  association to parent I_PyrlAccountingNotification as _PyrlAcctgNotif on $projection.AccountingNotificationUUID = _PyrlAcctgNotif.PyrlAccountingNotificationUUID
{
  key AccountingNotificationUUID,
  key AccountingDocument,
  key CompanyCode,
  key FiscalYear,

      _PyrlAcctgNotif
}
where
  AccountingNotificationUUID != hextobin( '00000000000000000000000000000000' )
//  and AccountingNotificationUUID = $parameters.P_AccountingNotificationUUID

group by
  AccountingNotificationUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[
"I_PYRLACCOUNTINGNOTIFICATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More