P_HU_MM_AUDITREPORTNEWR

DDL: P_HU_MM_AUDITREPORTNEWR Type: view_entity COMPOSITE
20 Fields 1 Data Sources

P_HU_MM_AUDITREPORTNEWR is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpBPTaxItem) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
I_StRpBPTaxItem I_StRpBPTaxItem 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 #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
CompanyCode I_StRpBPTaxItem CompanyCode Receiver Company Code
CompanyCodeCurrency I_StRpBPTaxItem CompanyCodeCurrency Local Currency
DocumentCurrency I_StRpBPTaxItem DocumentCurrency Document Currency
OriginalReferenceDocument
ProductName
Quantity
UnitOfMeasure
TaxRate
CountryCurrency I_StRpBPTaxItem CountryCurrency Currency
DocumentReferenceID
curr282endasBaseUnitNetAmount
ReferenceDocumentType I_StRpBPTaxItem ReferenceDocumentType Reference Document Type
DocumentDate I_StRpBPTaxItem DocumentDate Journal Entry Date
PostingDate I_StRpBPTaxItem PostingDate Posting Date for GR
TaxFulfillmentDate I_StRpBPTaxItem PostingDate Posting Date for GR
NetPriceAmount
TaxAmount
GrossAmount
curr282endendasTaxAmountInCoCodeCrcy
Supplier I_StRpBPTaxItem 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_AUDITREPORTNEWR.
-- 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_AUDITREPORTNEWR AS
SELECT
  I_StRpBPTaxItem.CompanyCode AS CompanyCode,
  I_StRpBPTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpBPTaxItem.DocumentCurrency AS DocumentCurrency,
  I_StRpBPTaxItem._SupplierInvoice.SupplierInvoice AS OriginalReferenceDocument,
  I_SupplierInvoiceItemPurOrdRef._PurchaseOrderItem.PurchaseOrderItemText AS ProductName,
  cast(I_SupplierInvoiceItemPurOrdRef.QuantityInPurchaseOrderUnit as abap.dec( 15, 2 )) AS Quantity,
  I_SupplierInvoiceItemPurOrdRef._PurchaseOrderItem.PurchaseOrderQuantityUnit AS UnitOfMeasure,
  cast(I_StRpBPTaxItem.TaxRate as abap.dec( 8, 2 )) AS TaxRate,
  I_StRpBPTaxItem.CountryCurrency AS CountryCurrency,
  ltrim(I_StRpBPTaxItem._SupplierInvoice.SupplierInvoice, '0') AS DocumentReferenceID,
  case when I_SupplierInvoiceItemPurOrdRef.QuantityInPurchaseOrderUnit = 0 or I_SupplierInvoiceItemPurOrdRef.QuantityInPurchaseOrderUnit is null then cast( get_numeric_value(I_StRpBPTaxItem.TaxBaseAmountInTransCrcy) as abap.curr(28,2)) else cast( get_numeric_value(I_StRpBPTaxItem.TaxBaseAmountInTransCrcy) / I_SupplierInvoiceItemPurOrdRef.QuantityInPurchaseOrderUnit as abap.curr(28,2)) end as BaseUnitNetAmount AS curr282endasBaseUnitNetAmount,
  I_StRpBPTaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpBPTaxItem.DocumentDate AS DocumentDate,
  I_StRpBPTaxItem.PostingDate AS PostingDate,
  I_StRpBPTaxItem.PostingDate AS TaxFulfillmentDate,
  cast( get_numeric_value(I_StRpBPTaxItem.TaxBaseAmountInTransCrcy) as abap.curr(28,2)) AS NetPriceAmount,
  cast(abs( get_numeric_value(I_StRpBPTaxItem.TaxAmountInTransCrcy)) as abap.curr(28,2)) AS TaxAmount,
  cast(abs( get_numeric_value(I_StRpBPTaxItem.TaxAmountInTransCrcy)) + abs( get_numeric_value(I_StRpBPTaxItem.TaxBaseAmountInTransCrcy)) as abap.curr(28,2)) AS GrossAmount,
  case I_StRpBPTaxItem.CompanyCodeCurrency when 'HUF' then cast(get_numeric_value(I_StRpBPTaxItem.TaxAmountInCoCodeCrcy) as abap.curr(28,2)) else case I_StRpBPTaxItem.DocumentCurrency when 'HUF' then cast(get_numeric_value(I_StRpBPTaxItem.TaxAmountInTransCrcy) as abap.curr(28,2)) else cast(get_numeric_value(I_StRpBPTaxItem.TaxAmountInCountryCrcy) as abap.curr(28,2)) end end as TaxAmountInCoCodeCrcy AS curr282endendasTaxAmountInCoCodeCrcy,
  I_StRpBPTaxItem.Supplier AS Supplier
FROM I_StRpBPTaxItem
;

Learn More