R_MNGJRNLENTRPRKDCHGHEADER

CDS View

Journal Entry - Parked Changed Header

R_MNGJRNLENTRPRKDCHGHEADER is a CDS View in S/4HANA. Journal Entry - Parked Changed Header. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MngJrnlEntrChangeDocument view_entity union_all TRANSACTIONAL Journal Entry - Changed Document

Fields (6)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocTableKey ChangeDocTableKey 1
KEY ChangeDocument ChangeDocument 1
KEY DatabaseTable DatabaseTable 1
ChangeDocNewFieldValue ChangedFieldNewValue 1
ChangeDocPreviousFieldValue ChangedFieldOldValue 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry - Parked Changed Header'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

define view entity R_MngJrnlEntrPrkdChgHeader
  as select from      I_ChangeDocumentItem          as _ChangeDocItem
  inner join          R_MngJrnlEntrPrkdChgDocTblKey as _AccountingDoc    on  _ChangeDocItem.DatabaseTable = _AccountingDoc.DatabaseTable
                                                                         and _ChangeDocItem.ChangeDocTableKey = _AccountingDoc.ChangeDocumentTableKey
  
{
  key _AccountingDoc.CompanyCode,
  key _AccountingDoc.Ledger,
  key _AccountingDoc.AccountingDocument,
  key _ChangeDocItem.ChangeDocument,
  key _ChangeDocItem.DatabaseTable,
  key _ChangeDocItem.ChangeDocTableKey,
  key _ChangeDocItem.ChangeDocDatabaseTableField,
  //key _AccountingDoc.AccountingDocumentItem                as JournalEntryItem,

  key _AccountingDoc.FiscalYear,
      _AccountingDoc.DocumentDate,
      _AccountingDoc.PostingDate,
      _ChangeDocItem._ChangeDocument.CreatedByUser         as ChangedBy,
      _ChangeDocItem._ChangeDocument.CreationTime          as LastChangeTime,
      _ChangeDocItem.ChangeDocPreviousFieldValue           as ChangedFieldOldValue,
      _ChangeDocItem.ChangeDocNewFieldValue                as ChangedFieldNewValue,
      _ChangeDocItem._ChangeDocument.CreationDate          as LastChangedDate,
      _AccountingDoc.AccountingDocumentCreationDate        as CreationDate,
      _AccountingDoc.CreationTime,
      _AccountingDoc.AccountingDocumentType,
      _AccountingDoc.AccountingDocumentCategory

}
where
  _ChangeDocItem.ChangeDocObjectClass = 'BELEGV' and
  _ChangeDocItem.DatabaseTable = 'VBKPF'
  
group by
  _AccountingDoc.CompanyCode,                     _AccountingDoc.Ledger,
  _AccountingDoc.AccountingDocument,              _ChangeDocItem.ChangeDocument,
  _ChangeDocItem.DatabaseTable,                   _ChangeDocItem.ChangeDocTableKey,
  _ChangeDocItem.ChangeDocDatabaseTableField,     _AccountingDoc.FiscalYear,
  _AccountingDoc.DocumentDate,                    _AccountingDoc.PostingDate,
  _ChangeDocItem._ChangeDocument.CreatedByUser,   _ChangeDocItem._ChangeDocument.CreationTime,
  _ChangeDocItem.ChangeDocPreviousFieldValue,     _ChangeDocItem.ChangeDocNewFieldValue,
  _ChangeDocItem._ChangeDocument.CreationDate,    _AccountingDoc.AccountingDocumentCreationDate,
  _AccountingDoc.CreationTime,
  _AccountingDoc.AccountingDocumentType,
  _AccountingDoc.AccountingDocumentCategory
    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM",
"R_MNGJRNLENTRPRKDCHGDOCTBLKEY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More