P_HU_AuditReport

DDL: P_HU_AUDITREPORT SQL: PAUDITREPORT Type: view COMPOSITE
31 Fields 1 Data Sources 1 Associations

P_HU_AuditReport is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpBPTaxItem) and exposes 31 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_StRpBPTaxItem I_StRpBPTaxItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAUDITREPORT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpBPTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpBPTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpBPTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpBPTaxItem TaxItem Tax Item
DocumentDate I_StRpBPTaxItem DocumentDate Journal Entry Date
PostingDate I_StRpBPTaxItem PostingDate Posting Date for GR
TaxReportingDate I_StRpBPTaxItem TaxReportingDate Tax Reporting Date
TaxCode I_StRpBPTaxItem TaxCode Tax Code
TaxRate I_StRpBPTaxItem TaxRate Tax Rate
DocumentReferenceID I_StRpBPTaxItem DocumentReferenceID Reference
InvoiceReference I_StRpBPTaxItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_StRpBPTaxItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
OriginalReferenceDocument I_StRpBPTaxItem OriginalReferenceDocument Reference Key
ReferenceDocumentType I_StRpBPTaxItem ReferenceDocumentType Reference Document Type
TaxBaseAmountInCoCodeCrcy I_StRpBPTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_StRpBPTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
CompanyCodeCurrency I_StRpBPTaxItem CompanyCodeCurrency Local Currency
TaxBaseAmountInTransCrcy I_StRpBPTaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInTransCrcy I_StRpBPTaxItem TaxAmountInTransCrcy TaxAmt in Tran. Crcy
DocumentCurrency I_StRpBPTaxItem DocumentCurrency Document Currency
FinancialAccountType I_StRpBPTaxItem FinancialAccountType Fin. Account Type
ReferenceDocument I_StRpBPTaxItem ReferenceDocument Reference Document
ReferenceDocumentContext I_StRpBPTaxItem ReferenceDocumentContext Reference Document Context
BusinessPartnerUUID I_StRpBPTaxItem BusinessPartnerUUID UUID
_CompanyCodeCurrency I_StRpBPTaxItem _CompanyCodeCurrency
_BillingDocument I_StRpBPTaxItem _BillingDocument
_SupplierInvoice I_StRpBPTaxItem _SupplierInvoice
_BusinessPartner I_StRpBPTaxItem _BusinessPartner
_AccountingDocument I_StRpBPTaxItem _AccountingDocument
_CompanyCode _CompanyCode
AuthorizationGroup I_StRpBPTaxItem AuthorizationGroup AuthorizGroup

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_AuditReport.
-- 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.
-- SQL view name: PAUDITREPORT

CREATE VIEW P_HU_AuditReport AS
SELECT
  I_StRpBPTaxItem.CompanyCode AS CompanyCode,
  I_StRpBPTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpBPTaxItem.FiscalYear AS FiscalYear,
  I_StRpBPTaxItem.TaxItem AS AccountingDocumentItem,
  I_StRpBPTaxItem.DocumentDate AS DocumentDate,
  I_StRpBPTaxItem.PostingDate AS PostingDate,
  I_StRpBPTaxItem.TaxReportingDate AS TaxReportingDate,
  I_StRpBPTaxItem.TaxCode AS TaxCode,
  I_StRpBPTaxItem.TaxRate AS TaxRate,
  I_StRpBPTaxItem.DocumentReferenceID AS DocumentReferenceID,
  I_StRpBPTaxItem.InvoiceReference AS InvoiceReference,
  I_StRpBPTaxItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_StRpBPTaxItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  I_StRpBPTaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpBPTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpBPTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpBPTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpBPTaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpBPTaxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  I_StRpBPTaxItem.DocumentCurrency AS DocumentCurrency,
  I_StRpBPTaxItem.FinancialAccountType AS FinancialAccountType,
  I_StRpBPTaxItem.ReferenceDocument AS ReferenceDocument,
  I_StRpBPTaxItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_StRpBPTaxItem.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_StRpBPTaxItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_StRpBPTaxItem._BillingDocument AS _BillingDocument,
  I_StRpBPTaxItem._SupplierInvoice AS _SupplierInvoice,
  I_StRpBPTaxItem._BusinessPartner AS _BusinessPartner,
  I_StRpBPTaxItem._AccountingDocument AS _AccountingDocument,
  I_StRpBPTaxItem.AuthorizationGroup AS AuthorizationGroup
FROM I_StRpBPTaxItem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More