P_MX_JOURNALENTRYGRHISTORY2

CDS View

P_MX_JOURNALENTRYGRHISTORY2 is a CDS View in S/4HANA. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MX_JrnlEntrItmInvcCompType view inner CONSUMPTION
P_MX_JrnlEntrNationalCompDets view inner CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
KEY MaterialDocumentNumber AccountingDocument 2
KEY MaterialDocumentYear FiscalYear 2 
@AbapCatalog.sqlViewName: 'PMXJEGRHIST2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { sizeCategory: #XL, dataClass: #MIXED, serviceQuality: #P }
@Metadata.ignorePropagatedAnnotations:true

define view P_MX_JournalEntryGRHistory2 
  as select distinct from P_MX_JournalEntryGRHistory as JournalEntryDetails
  
    inner join I_JournalEntryItem as MaterialDocument
      on JournalEntryDetails.Ledger                      = MaterialDocument.Ledger
     and JournalEntryDetails.CompanyCode                 = MaterialDocument.CompanyCode
     and JournalEntryDetails.ReferenceDocument           = MaterialDocument.ReferenceDocument
     and JournalEntryDetails.ReferenceDocumentFiscalYear = MaterialDocument.ReferenceDocumentContext
     and JournalEntryDetails.ReferenceDocumentItem       = MaterialDocument.ReferenceDocumentItem
     and JournalEntryDetails.PurchasingDocument          = MaterialDocument.PurchasingDocument
     and JournalEntryDetails.PurchasingDocumentItem      = MaterialDocument.PurchasingDocumentItem
    
{
  key JournalEntryDetails.Ledger,
  key JournalEntryDetails.CompanyCode,
  key JournalEntryDetails.AccountingDocument,                          -- FI supplier invoice (MIRO)
  key JournalEntryDetails.FiscalYear,
      MaterialDocument.AccountingDocument as MaterialDocumentNumber,   -- FI goods receipt document (MIGO)
      cast( MaterialDocument.FiscalYear as fis_gjahr_no_conv preserving type ) as MaterialDocumentYear
      
}
 where MaterialDocument.ReferenceDocumentType = 'MKPF'
   and MaterialDocument.ReferenceDocument is not initial
   and MaterialDocument.ReferenceDocumentContext is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM",
"P_MX_JOURNALENTRYGRHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More