Which tables does P_RU_VATReportingItemLog read from?

P_RU_VATReportingItemLog reads data from: I_RU_VATReportingItemLog.

What VDM layer is P_RU_VATReportingItemLog?

P_RU_VATReportingItemLog is classified as a Consumption view optimized for specific business scenarios and reporting.

P_RU_VATReportingItemLog

Q: What is P_RU_VATReportingItemLog in SAP S/4HANA?

P_RU_VATReportingItemLog is a consumption CDS view in SAP S/4HANA. It contains 117 fields.

DDL: P_RU_VATREPORTINGITEMLOG SQL: PRUVATRPTGITL Type: view CONSUMPTION

117 Fields 1 Data Sources

P_RU_VATReportingItemLog is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_RU_VATReportingItemLog) and exposes 117 fields.

Data Sources (1)

Source	Alias	Join Type
I_RU_VATReportingItemLog	MainLog	from

Annotations (7)

Name	Value	Level
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	PRUVATRPTGITL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (117)

Field	Source Table	Source Field	Description
StatryRptgEntity	I_RU_VATReportingItemLog	StatryRptgEntity	Reporting Entity
StatryRptCategory	I_RU_VATReportingItemLog	StatryRptCategory	Report ID
StatryRptRunID	I_RU_VATReportingItemLog	StatryRptRunID	Report Run ID
CompanyCode	I_RU_VATReportingItemLog	CompanyCode	Receiver Company Code
AccountingDocument	I_RU_VATReportingItemLog	AccountingDocument	Journal Entry
FiscalYear	I_RU_VATReportingItemLog	FiscalYear	G/L Fiscal Year
TaxItem	I_RU_VATReportingItemLog	TaxItem	Tax Item
RevisionNumber	I_RU_VATReportingItemLog	RevisionNumber	Revision Number
RU_VATReturnSectionType	I_RU_VATReportingItemLog	RU_VATReturnSectionType	Section Type
SourceDocument	I_RU_VATReportingItemLog	SourceDocument	Document
SourceDocumentFiscalYear	I_RU_VATReportingItemLog	SourceDocumentFiscalYear	Orig. Doc. Year
RU_VATSubScenario	I_RU_VATReportingItemLog	RU_VATSubScenario	Subscenario
Sign	I_RU_VATReportingItemLog	Sign	Type of SIGN component in row type of a Ranges type
PostingDate	bkpf	PostingDate	Posting Date for GR
DocumentDate	bkpf	DocumentDate	Journal Entry Date
AccountingDocumentType	bkpf	AccountingDocumentType	Journal Entry Type
BusinessTransactionType	bkpf	BusinessTransactionType	Bus.transaction
Invoice	I_RU_VATReportingItemLog	Invoice	Orig.Inv.Number
InvoiceYear	I_RU_VATReportingItemLog	InvoiceYear	Orig.Inv.Year
ExternalInvoice	I_RU_VATReportingItemLog	ExternalInvoice	External Number
InvoiceDate	I_RU_VATReportingItemLog	InvoiceDate	Run On
RevisionInvoice	I_RU_VATReportingItemLog	RevisionInvoice	Rev.Inv.Number
RevisionInvoiceYear	I_RU_VATReportingItemLog	RevisionInvoiceYear	Rev.Inv.Year
OriginalInvoiceRevisionNumber	I_RU_VATReportingItemLog	OriginalInvoiceRevisionNumber	Rev.Num.Orig.Inv.
OriginalInvoiceRevisionDate	I_RU_VATReportingItemLog	OriginalInvoiceRevisionDate	Rev.Date Orig.Inv.
CorrectionInvoice	I_RU_VATReportingItemLog	CorrectionInvoice	Corr.Inv.Number
CorrectionInvoiceYear	I_RU_VATReportingItemLog	CorrectionInvoiceYear	Corr.Inv.Year
ExternalCorrectionInvoice	I_RU_VATReportingItemLog	ExternalCorrectionInvoice	Corr. VAT Inv. Ext.
CorrectionInvoiceDate	I_RU_VATReportingItemLog	CorrectionInvoiceDate	Corr. VAT Inv. Date
CorrectionInvoiceRevisionNmbr	I_RU_VATReportingItemLog	CorrectionInvoiceRevisionNmbr	Revision of Corr. No
CorrectionInvoiceRevisionDate	I_RU_VATReportingItemLog	CorrectionInvoiceRevisionDate	Rev. Date of Corr.
TaxReportingDate	I_RU_VATReportingItemLog	TaxReportingDate	Tax Reporting Date
IsReversal	I_RU_VATReportingItemLog	IsReversal	Reversal doc.
IsReversed	I_RU_VATReportingItemLog	IsReversed	Reversed?
RU_InvoiceType	I_RU_VATReportingItemLog	RU_InvoiceType	Invoice Type
TaxCode	I_RU_VATReportingItemLog	TaxCode	Tax Code
TaxItemGroupingVersion	I_RU_VATReportingItemLog	TaxItemGroupingVersion	Tax Grping Ver.
CompanyCodeCurrency	I_RU_VATReportingItemLog	CompanyCodeCurrency	Local Currency
Currency	I_RU_VATReportingItemLog	Currency	Valuation Crcy
CurrencyISOCode	I_RU_VATReportingItemLog	CurrencyISOCode	Document Currency
TotalAmountInTransactionCrcy	I_RU_VATReportingItemLog	TotalAmountInTransactionCrcy	Total Amt In Tr Crcy
AmountInTransactionCurrency	I_RU_VATReportingItemLog	TotalAmountInTransactionCrcy	Total Amt In Tr Crcy
TotalAmountInCoCodeCrcy	I_RU_VATReportingItemLog	TotalAmountInCoCodeCrcy	Total Amt In Co Crcy
TaxAmountInTransCrcy	I_RU_VATReportingItemLog	TaxAmountInTransCrcy	TaxAmt in Tran. Crcy
TaxAmountInCoCodeCrcy	I_RU_VATReportingItemLog	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy	I_RU_VATReportingItemLog	TaxBaseAmountInTransCrcy	Value-Added Tax
TaxBaseAmountInCoCodeCrcy	I_RU_VATReportingItemLog	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
TxBaseAmtWithTxRate0InCCCrcy	I_RU_VATReportingItemLog	TxBaseAmtWithTxRate0InCCCrcy	Tax Base Amount 0%
TxBaseAmtWithTxRate10InCCCrcy	I_RU_VATReportingItemLog	TxBaseAmtWithTxRate10InCCCrcy	Tax Base Amount 10%
TxBaseAmtWithTxRate18InCCCrcy	I_RU_VATReportingItemLog	TxBaseAmtWithTxRate18InCCCrcy	Tax Base Amount 18%
TxBaseAmtWithTxRate20InCCCrcy	I_RU_VATReportingItemLog	TxBaseAmtWithTxRate20InCCCrcy	Tax Base Amount 20%
BaseAmtWithoutTxInCCCrcy	I_RU_VATReportingItemLog	BaseAmtWithoutTxInCCCrcy	Base Amount No Tax
TxAmtWithTxRate10InCCCrcy	I_RU_VATReportingItemLog	TxAmtWithTxRate10InCCCrcy	Tax Amount 10%
TxAmtWithTxRate18InCCCrcy	I_RU_VATReportingItemLog	TxAmtWithTxRate18InCCCrcy	Tax Amount 18%
TxAmtWithTxRate20InCCCrcy	I_RU_VATReportingItemLog	TxAmtWithTxRate20InCCCrcy	Tax Amount 20%
AuthorizationGroup
BusinessPartner	I_RU_VATReportingItemLog	BusinessPartner	Issuing Authority
Supplier	I_RU_VATReportingItemLog	BusinessPartner	Issuing Authority
BusinessPartnerIsOrganization	I_RU_VATReportingItemLog	BusinessPartnerIsOrganization	BP is Org
IsNaturalPerson	I_RU_VATReportingItemLog	IsNaturalPerson	Natural person
BusinessPartnerName	I_RU_VATReportingItemLog	BusinessPartnerName	Extracted Customer Name
SupplierName	I_RU_VATReportingItemLog	BusinessPartnerName	Extracted Customer Name
RU_PartnerOrganizationINN	I_RU_VATReportingItemLog	RU_PartnerOrganizationINN	BP INN
RU_PartnerOrganizationKPP	I_RU_VATReportingItemLog	RU_PartnerOrganizationKPP	BP KPP
RU_PartnerPersonINN	I_RU_VATReportingItemLog	RU_PartnerPersonINN	BP Pers. INN
FirstName	I_RU_VATReportingItemLog	FirstName	First Name
LastName	I_RU_VATReportingItemLog	LastName	Last Name
MiddleName	I_RU_VATReportingItemLog	MiddleName	Middle Name
BusinessPartnerCountry	I_RU_VATReportingItemLog	BusinessPartnerCountry	BP Ctry/Reg.
CustomerCountry	I_RU_VATReportingItemLog	BusinessPartnerCountry	BP Ctry/Reg.
Agent	I_RU_VATReportingItemLog	Agent	Processor ID
AgentIsOrganization	I_RU_VATReportingItemLog	AgentIsOrganization	Agent Is Org
AgentOrganizationName	I_RU_VATReportingItemLog	AgentOrganizationName	Agent Name
RU_AgentOrganizationINN	I_RU_VATReportingItemLog	RU_AgentOrganizationINN	Agent INN
RU_AgentOrganizationKPP	I_RU_VATReportingItemLog	RU_AgentOrganizationKPP	Agent KPP
RU_AgentPersonINN	I_RU_VATReportingItemLog	RU_AgentPersonINN	Agent Pers. INN
AgentPersonSurname	I_RU_VATReportingItemLog	AgentPersonSurname	Agent Pers. Last Nm
AgentPersonName	I_RU_VATReportingItemLog	AgentPersonName	Agent Pers. Frst Nm
AgentPersonMiddleName	I_RU_VATReportingItemLog	AgentPersonMiddleName	Agent Pers. Mid Nm
RU_IncomingInvoiceCompanyCode	I_RU_VATReportingItemLog	RU_IncomingInvoiceCompanyCode	Inc.Company Code
RU_IncomingInvoiceNumber	I_RU_VATReportingItemLog	RU_IncomingInvoiceNumber	Inc.Orig.Inv.Number
RU_IncomingInvoiceFiscalYear	I_RU_VATReportingItemLog	RU_IncomingInvoiceFiscalYear	Inc.Orig.Inv.Year
IncomingCorrectionInvoice	I_RU_VATReportingItemLog	IncomingCorrectionInvoice	Inc.Corr.Inv.Number
IncomingCorrectionInvoiceYear	I_RU_VATReportingItemLog	IncomingCorrectionInvoiceYear	Inc.Corr.Inv.Year
IncomingRevisionNumber	I_RU_VATReportingItemLog	IncomingRevisionNumber	Inc.Rev.Number
IncomingExternalInvoice	I_RU_VATReportingItemLog	IncomingExternalInvoice	Inc.ExternalDocNmbr
RU_IncomingInvoiceDate	I_RU_VATReportingItemLog	RU_IncomingInvoiceDate	Inc.ExternalDocDate
RU_IncomingInvoiceType	I_RU_VATReportingItemLog	RU_IncomingInvoiceType	Inc.Invoice Type
IncomingInvoiceTransCurrency	I_RU_VATReportingItemLog	IncomingInvoiceTransCurrency	In Transaction Curr
IncgInvoiceTransCrcyISOCode	I_RU_VATReportingItemLog	IncgInvoiceTransCrcyISOCode	Inc.Currency ISOCode
CommsnTradeInvoiceLinkedAmount	I_RU_VATReportingItemLog	CommsnTradeInvoiceLinkedAmount	Linked Amount
CommsnTradeInvcLinkedVATAmount	I_RU_VATReportingItemLog	CommsnTradeInvcLinkedVATAmount	Linked VAT
OriginalAmountInTransacCrcy	I_RU_VATReportingItemLog	OriginalAmountInTransacCrcy	Origl Amt Trans Crcy
OriginalTaxAmountInTransacCrcy	I_RU_VATReportingItemLog	OriginalTaxAmountInTransacCrcy	TaxAmtOrigInTrCrcy
DifferenceAmtInTransCrcy	I_RU_VATReportingItemLog	DifferenceAmtInTransCrcy	AmtDifInTransCrcy
DifferenceTaxAmtInTransCrcy	I_RU_VATReportingItemLog	DifferenceTaxAmtInTransCrcy	TaxAmtDifInTrCrcy
RU_VATOperationType	I_RU_VATReportingItemLog	RU_VATOperationType	Operation Type Code
SalesDealType	I_RU_VATReportingItemLog	SalesDealType	Deal Type
RU_TerritoryClassfctnOKTMO	I_RU_VATReportingItemLog	RU_TerritoryClassfctnOKTMO	OKTMO
VATReturnOperation	I_RU_VATReportingItemLog	VATReturnOperation	Operation Code
ExportInvcConfirmedFiscalYear	I_RU_VATReportingItemLog	ExportInvcConfirmedFiscalYear	Reporting Year
FiscalPeriod	I_RU_VATReportingItemLog	FiscalPeriod	Tax period
RU_VATReturnSection	I_RU_VATReportingItemLog	RU_VATReturnSection	VAT Return Section
RU_VATReturnLine	I_RU_VATReportingItemLog	RU_VATReturnLine	Line
VATReturnItemDescription	VATReturnLineText	VATReturnItemDescription
RU_VATReturnVersion	I_RU_VATReportingItemLog	RU_VATReturnVersion	VAT Return Version
RU_VATSubScenarioVersion	I_RU_VATReportingItemLog	RU_VATSubScenarioVersion	Subscenario Version
RU_VATScenario	I_RU_VATReportingItemLog	RU_VATScenario	VAT Scenario
PaymentOrderOutputType
ImprtCstmsDeclnIsRead
MatlRcptDateIsRead
RU_SupplierAgentOutputType
RU_VATExternalPaymentsText	AddlLog	RU_VATExternalPaymentsText	External Payments
RU_VATPaymentDatesText	AddlLog	RU_VATPaymentDatesText	Payment Dates
RU_VATMaterialReceiptDatesText	AddlLog	RU_VATMaterialReceiptDatesText	Receipt Datates
RU_VATImpCustDeclnDocNmbrsText	AddlLog	RU_VATImpCustDeclnDocNmbrsText	ImpCustDeclnDocNmbrs
RU_VATTrdClassfctnNmbrsText	AddlLog	RU_VATTrdClassfctnNmbrsText	Trd Classfctn Nmbrs

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_RU_VATReportingItemLog.
-- 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: PRUVATRPTGITL

CREATE VIEW P_RU_VATReportingItemLog AS
SELECT
  MainLog.StatryRptgEntity AS StatryRptgEntity,
  MainLog.StatryRptCategory AS StatryRptCategory,
  MainLog.StatryRptRunID AS StatryRptRunID,
  MainLog.CompanyCode AS CompanyCode,
  MainLog.AccountingDocument AS AccountingDocument,
  MainLog.FiscalYear AS FiscalYear,
  MainLog.TaxItem AS TaxItem,
  MainLog.RevisionNumber AS RevisionNumber,
  MainLog.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  MainLog.SourceDocument AS SourceDocument,
  MainLog.SourceDocumentFiscalYear AS SourceDocumentFiscalYear,
  MainLog.RU_VATSubScenario AS RU_VATSubScenario,
  MainLog.Sign AS Sign,
  bkpf.PostingDate AS PostingDate,
  bkpf.DocumentDate AS DocumentDate,
  bkpf.AccountingDocumentType AS AccountingDocumentType,
  bkpf.BusinessTransactionType AS BusinessTransactionType,
  MainLog.Invoice AS Invoice,
  MainLog.InvoiceYear AS InvoiceYear,
  MainLog.ExternalInvoice AS ExternalInvoice,
  MainLog.InvoiceDate AS InvoiceDate,
  MainLog.RevisionInvoice AS RevisionInvoice,
  MainLog.RevisionInvoiceYear AS RevisionInvoiceYear,
  MainLog.OriginalInvoiceRevisionNumber AS OriginalInvoiceRevisionNumber,
  MainLog.OriginalInvoiceRevisionDate AS OriginalInvoiceRevisionDate,
  MainLog.CorrectionInvoice AS CorrectionInvoice,
  MainLog.CorrectionInvoiceYear AS CorrectionInvoiceYear,
  MainLog.ExternalCorrectionInvoice AS ExternalCorrectionInvoice,
  MainLog.CorrectionInvoiceDate AS CorrectionInvoiceDate,
  MainLog.CorrectionInvoiceRevisionNmbr AS CorrectionInvoiceRevisionNmbr,
  MainLog.CorrectionInvoiceRevisionDate AS CorrectionInvoiceRevisionDate,
  MainLog.TaxReportingDate AS TaxReportingDate,
  MainLog.IsReversal AS IsReversal,
  MainLog.IsReversed AS IsReversed,
  MainLog.RU_InvoiceType AS RU_InvoiceType,
  MainLog.TaxCode AS TaxCode,
  MainLog.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  MainLog.CompanyCodeCurrency AS CompanyCodeCurrency,
  MainLog.Currency AS Currency,
  MainLog.CurrencyISOCode AS CurrencyISOCode,
  MainLog.TotalAmountInTransactionCrcy AS TotalAmountInTransactionCrcy,
  MainLog.TotalAmountInTransactionCrcy AS AmountInTransactionCurrency,
  MainLog.TotalAmountInCoCodeCrcy AS TotalAmountInCoCodeCrcy,
  MainLog.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  MainLog.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  MainLog.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  MainLog.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  MainLog.TxBaseAmtWithTxRate0InCCCrcy AS TxBaseAmtWithTxRate0InCCCrcy,
  MainLog.TxBaseAmtWithTxRate10InCCCrcy AS TxBaseAmtWithTxRate10InCCCrcy,
  MainLog.TxBaseAmtWithTxRate18InCCCrcy AS TxBaseAmtWithTxRate18InCCCrcy,
  MainLog.TxBaseAmtWithTxRate20InCCCrcy AS TxBaseAmtWithTxRate20InCCCrcy,
  MainLog.BaseAmtWithoutTxInCCCrcy AS BaseAmtWithoutTxInCCCrcy,
  MainLog.TxAmtWithTxRate10InCCCrcy AS TxAmtWithTxRate10InCCCrcy,
  MainLog.TxAmtWithTxRate18InCCCrcy AS TxAmtWithTxRate18InCCCrcy,
  MainLog.TxAmtWithTxRate20InCCCrcy AS TxAmtWithTxRate20InCCCrcy,
  ' ' AS AuthorizationGroup,
  MainLog.BusinessPartner AS BusinessPartner,
  MainLog.BusinessPartner AS Supplier,
  MainLog.BusinessPartnerIsOrganization AS BusinessPartnerIsOrganization,
  MainLog.IsNaturalPerson AS IsNaturalPerson,
  MainLog.BusinessPartnerName AS BusinessPartnerName,
  MainLog.BusinessPartnerName AS SupplierName,
  MainLog.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  MainLog.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  MainLog.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  MainLog.FirstName AS FirstName,
  MainLog.LastName AS LastName,
  MainLog.MiddleName AS MiddleName,
  MainLog.BusinessPartnerCountry AS BusinessPartnerCountry,
  MainLog.BusinessPartnerCountry AS CustomerCountry,
  MainLog.Agent AS Agent,
  MainLog.AgentIsOrganization AS AgentIsOrganization,
  MainLog.AgentOrganizationName AS AgentOrganizationName,
  MainLog.RU_AgentOrganizationINN AS RU_AgentOrganizationINN,
  MainLog.RU_AgentOrganizationKPP AS RU_AgentOrganizationKPP,
  MainLog.RU_AgentPersonINN AS RU_AgentPersonINN,
  MainLog.AgentPersonSurname AS AgentPersonSurname,
  MainLog.AgentPersonName AS AgentPersonName,
  MainLog.AgentPersonMiddleName AS AgentPersonMiddleName,
  MainLog.RU_IncomingInvoiceCompanyCode AS RU_IncomingInvoiceCompanyCode,
  MainLog.RU_IncomingInvoiceNumber AS RU_IncomingInvoiceNumber,
  MainLog.RU_IncomingInvoiceFiscalYear AS RU_IncomingInvoiceFiscalYear,
  MainLog.IncomingCorrectionInvoice AS IncomingCorrectionInvoice,
  MainLog.IncomingCorrectionInvoiceYear AS IncomingCorrectionInvoiceYear,
  MainLog.IncomingRevisionNumber AS IncomingRevisionNumber,
  MainLog.IncomingExternalInvoice AS IncomingExternalInvoice,
  MainLog.RU_IncomingInvoiceDate AS RU_IncomingInvoiceDate,
  MainLog.RU_IncomingInvoiceType AS RU_IncomingInvoiceType,
  MainLog.IncomingInvoiceTransCurrency AS IncomingInvoiceTransCurrency,
  MainLog.IncgInvoiceTransCrcyISOCode AS IncgInvoiceTransCrcyISOCode,
  MainLog.CommsnTradeInvoiceLinkedAmount AS CommsnTradeInvoiceLinkedAmount,
  MainLog.CommsnTradeInvcLinkedVATAmount AS CommsnTradeInvcLinkedVATAmount,
  MainLog.OriginalAmountInTransacCrcy AS OriginalAmountInTransacCrcy,
  MainLog.OriginalTaxAmountInTransacCrcy AS OriginalTaxAmountInTransacCrcy,
  MainLog.DifferenceAmtInTransCrcy AS DifferenceAmtInTransCrcy,
  MainLog.DifferenceTaxAmtInTransCrcy AS DifferenceTaxAmtInTransCrcy,
  MainLog.RU_VATOperationType AS RU_VATOperationType,
  MainLog.SalesDealType AS SalesDealType,
  MainLog.RU_TerritoryClassfctnOKTMO AS RU_TerritoryClassfctnOKTMO,
  MainLog.VATReturnOperation AS VATReturnOperation,
  MainLog.ExportInvcConfirmedFiscalYear AS ExportInvcConfirmedFiscalYear,
  MainLog.FiscalPeriod AS FiscalPeriod,
  MainLog.RU_VATReturnSection AS RU_VATReturnSection,
  MainLog.RU_VATReturnLine AS RU_VATReturnLine,
  VATReturnLineText.VATReturnItemDescription AS VATReturnItemDescription,
  MainLog.RU_VATReturnVersion AS RU_VATReturnVersion,
  MainLog.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  MainLog.RU_VATScenario AS RU_VATScenario,
  ' ' AS PaymentOrderOutputType,
  '' AS ImprtCstmsDeclnIsRead,
  '' AS MatlRcptDateIsRead,
  ' ' AS RU_SupplierAgentOutputType,
  AddlLog.RU_VATExternalPaymentsText AS RU_VATExternalPaymentsText,
  AddlLog.RU_VATPaymentDatesText AS RU_VATPaymentDatesText,
  AddlLog.RU_VATMaterialReceiptDatesText AS RU_VATMaterialReceiptDatesText,
  AddlLog.RU_VATImpCustDeclnDocNmbrsText AS RU_VATImpCustDeclnDocNmbrsText,
  AddlLog.RU_VATTrdClassfctnNmbrsText AS RU_VATTrdClassfctnNmbrsText
FROM I_RU_VATReportingItemLog AS MainLog
;

Depth:

P_RU_VATReportingItemLog view

I_RU_VATReportingItemLog view