P_HU_AuditReportSearchHelp

DDL: P_HU_AUDITREPORTSEARCHHELP Type: view_entity CONSUMPTION Package: GLO_FIN_IS_HU

HU helper view for Audit Report

P_HU_AuditReportSearchHelp is a Consumption CDS View that provides data about "HU helper view for Audit Report" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_JournalEntry) and exposes 6 fields. Part of development package GLO_FIN_IS_HU.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from
I_JournalEntry I_JournalEntry union_all

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
OriginalReferenceDocument
DocumentDate DocumentDate
OriginalReferenceDocument AccountingDocument
DocumentDate DocumentDate
PostingDate PostingDate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_HU_AuditReportSearchHelp as select from I_JournalEntry
{
   CompanyCode,
   cast (left(OriginalReferenceDocument,10) as idhu_invoice_id) as OriginalReferenceDocument,
   DocumentDate,
   PostingDate
}
where OriginalReferenceDocument is not initial and ( ReferenceDocumentType = 'RMRP' or ReferenceDocumentType = 'VBRK')

union all select from I_JournalEntry
{
   CompanyCode,
   AccountingDocument as OriginalReferenceDocument,
   DocumentDate,
   PostingDate
}
where OriginalReferenceDocument is not initial and TransactionCode = 'MRKO'

Learn More