P_HU_MM_AUDITREPORTNEW

DDL: P_HU_MM_AUDITREPORTNEW Type: view_entity CONSUMPTION Package: GLO_FIN_IS_HU
23 Fields 1 Data Sources

Documents from MM Module for AuditReport

P_HU_MM_AUDITREPORTNEW is a Consumption CDS View that provides data about "Documents from MM Module for AuditReport" in SAP S/4HANA. It reads from 1 data source (P_HU_MM_AUDITREPORTNEWR) and exposes 23 fields. Part of development package GLO_FIN_IS_HU.

Data Sources (1)

SourceAliasJoin Type
P_HU_MM_AUDITREPORTNEWR P_HU_MM_AUDITREPORTNEWR from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
CompanyCode P_HU_MM_AUDITREPORTNEWR CompanyCode Receiver Company Code
CompanyCodeCurrency P_HU_MM_AUDITREPORTNEWR CompanyCodeCurrency Local Currency
DocumentCurrency P_HU_MM_AUDITREPORTNEWR DocumentCurrency Document Currency
OriginalReferenceDocument P_HU_MM_AUDITREPORTNEWR OriginalReferenceDocument Reference Key
ProductName P_HU_MM_AUDITREPORTNEWR ProductName Description
Quantity P_HU_MM_AUDITREPORTNEWR Quantity Value
UnitOfMeasure
Taxrate P_HU_MM_AUDITREPORTNEWR Taxrate Tax Rate
CountryCurrency P_HU_MM_AUDITREPORTNEWR CountryCurrency Currency
DocumentReferenceID P_HU_MM_AUDITREPORTNEWR DocumentReferenceID Reference
BaseUnitNetAmount P_HU_MM_AUDITREPORTNEWR BaseUnitNetAmount
CustomerInvoiceType P_HU_MM_AUDITREPORTNEWR CustomerInvoiceType
OriginalInvoiceID
ReferenceDocumentType P_HU_MM_AUDITREPORTNEWR ReferenceDocumentType Reference Document Type
DocumentDate P_HU_MM_AUDITREPORTNEWR DocumentDate Journal Entry Date
PostingDate P_HU_MM_AUDITREPORTNEWR PostingDate Posting Date for GR
TaxFulfillmentDate P_HU_MM_AUDITREPORTNEWR TaxFulfillmentDate Tax Settlement Date
NetPriceAmount P_HU_MM_AUDITREPORTNEWR NetPriceAmount Net Price
TaxAmount P_HU_MM_AUDITREPORTNEWR TaxAmount Tax Amt in Rptg Crcy
GrossAmount P_HU_MM_AUDITREPORTNEWR GrossAmount Gross value
HungarianCurrency P_HU_MM_AUDITREPORTNEWR HungarianCurrency
TaxAmountInHUFCrcy P_HU_MM_AUDITREPORTNEWR TaxAmountInHUFCrcy
Supplier P_HU_MM_AUDITREPORTNEWR Supplier Supplier

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_HU_MM_AUDITREPORTNEW.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_HU_MM_AUDITREPORTNEW AS
SELECT
  P_HU_MM_AUDITREPORTNEWR.CompanyCode AS CompanyCode,
  P_HU_MM_AUDITREPORTNEWR.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_HU_MM_AUDITREPORTNEWR.DocumentCurrency AS DocumentCurrency,
  P_HU_MM_AUDITREPORTNEWR.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_HU_MM_AUDITREPORTNEWR.ProductName AS ProductName,
  P_HU_MM_AUDITREPORTNEWR.Quantity AS Quantity,
  coalesce( _UnitOfMeasureLangDep.UnitOfMeasure_E, P_HU_MM_AUDITREPORTNEWR.UnitOfMeasure ) AS UnitOfMeasure,
  P_HU_MM_AUDITREPORTNEWR.Taxrate AS Taxrate,
  P_HU_MM_AUDITREPORTNEWR.CountryCurrency AS CountryCurrency,
  P_HU_MM_AUDITREPORTNEWR.DocumentReferenceID AS DocumentReferenceID,
  P_HU_MM_AUDITREPORTNEWR.BaseUnitNetAmount AS BaseUnitNetAmount,
  P_HU_MM_AUDITREPORTNEWR.CustomerInvoiceType AS CustomerInvoiceType,
  '' AS OriginalInvoiceID,
  P_HU_MM_AUDITREPORTNEWR.ReferenceDocumentType AS ReferenceDocumentType,
  P_HU_MM_AUDITREPORTNEWR.DocumentDate AS DocumentDate,
  P_HU_MM_AUDITREPORTNEWR.PostingDate AS PostingDate,
  P_HU_MM_AUDITREPORTNEWR.TaxFulfillmentDate AS TaxFulfillmentDate,
  P_HU_MM_AUDITREPORTNEWR.NetPriceAmount AS NetPriceAmount,
  P_HU_MM_AUDITREPORTNEWR.TaxAmount AS TaxAmount,
  P_HU_MM_AUDITREPORTNEWR.GrossAmount AS GrossAmount,
  P_HU_MM_AUDITREPORTNEWR.HungarianCurrency AS HungarianCurrency,
  P_HU_MM_AUDITREPORTNEWR.TaxAmountInHUFCrcy AS TaxAmountInHUFCrcy,
  P_HU_MM_AUDITREPORTNEWR.Supplier AS Supplier
FROM P_HU_MM_AUDITREPORTNEWR
;

Learn More