What is I_RU_VATReportingItemLog in SAP S/4HANA?

I_RU_VATReportingItemLog is a basic CDS view in SAP S/4HANA. VAT Reporting Items Log It contains 98 fields.

Which tables does I_RU_VATReportingItemLog read from?

I_RU_VATReportingItemLog reads data from: firud_vat1_rpitm.

What VDM layer is I_RU_VATReportingItemLog?

I_RU_VATReportingItemLog is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_RU_VATReportingItemLog

DDL: I_RU_VATREPORTINGITEMLOG SQL: IRUVATRPTGITL Type: view BASIC

98 Fields 1 Data Sources

VAT Reporting Items Log

I_RU_VATReportingItemLog is a Basic CDS View that provides data about "VAT Reporting Items Log" in SAP S/4HANA. It reads from 1 data source (firud_vat1_rpitm) and exposes 98 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

Data Sources (1)

Source	Alias	Join Type
firud_vat1_rpitm	firud_vat1_rpitm	from

Annotations (10)

Name	Value	Level
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IRUVATRPTGITL	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	VAT Reporting Items Log	view

Fields (98)

Key	Field	Source Field	Description
KEY	StatryRptgEntity	statryrptgentity	Reporting Entity
KEY	StatryRptCategory	statryrptcategory	Report ID
KEY	StatryRptRunID	statryrptrunid	Report Run ID
KEY	CompanyCode	companycode	Receiver Company Code
KEY	AccountingDocument	accountingdocument	Journal Entry
KEY	FiscalYear	fiscalyear	G/L Fiscal Year
KEY	TaxItem	taxitem	Tax Item
KEY	RevisionNumber	revisionnumber	Revision Number
KEY	RU_VATReturnSectionType	ru_vatreturnsectiontype	Section Type
KEY	SourceDocument		Original Document
KEY	SourceDocumentFiscalYear	originaldocumentyear	Orig. Doc. Year
KEY	RU_VATSubScenario	ru_vatsubscenario	Subscenario
KEY	Sign	sign	Type of SIGN component in row type of a Ranges type
	Invoice	invoice	Orig.Inv.Number
	InvoiceYear	invoiceyear	Orig.Inv.Year
	ExternalInvoice	externalinvoice	External Number
	InvoiceDate	invoicedate	Run On
	RevisionInvoice	revisioninvoice	Rev.Inv.Number
	RevisionInvoiceYear	revisioninvoiceyear	Rev.Inv.Year
	OriginalInvoiceRevisionNumber	originalinvoicerevisionnumber	Rev.Num.Orig.Inv.
	OriginalInvoiceRevisionDate	originalinvoicerevisiondate	Rev.Date Orig.Inv.
	CorrectionInvoice	correctioninvoice	Corr.Inv.Number
	CorrectionInvoiceYear	correctioninvoiceyear	Corr.Inv.Year
	ExternalCorrectionInvoice	externalcorrectioninvoice	Corr. VAT Inv. Ext.
	CorrectionInvoiceDate	correctioninvoicedate	Corr. VAT Inv. Date
	CorrectionInvoiceRevisionNmbr	correctioninvoicerevisionnmbr	Revision of Corr. No
	CorrectionInvoiceRevisionDate	correctioninvoicerevisiondate	Rev. Date of Corr.
	TaxReportingDate	taxreportingdate	Tax Reporting Date
	IsReversal	isreversal	Reversal doc.
	IsReversed	isreversed	Reversed?
	RU_InvoiceType	ru_invoicetype	Invoice Type
	TaxCode	taxcode	Tax Code
	TaxItemGroupingVersion	taxitemgroupingversion	Tax Grping Ver.
	CompanyCodeCurrency	companycodecurrency	Local Currency
	Currency	currency	Valuation Crcy
	CurrencyISOCode	currencyisocode	Document Currency
	TotalAmountInTransactionCrcy	totalamountintransactioncrcy	Total Amt In Tr Crcy
	TotalAmountInCoCodeCrcy	totalamountincocodecrcy	Total Amt In Co Crcy
	TaxAmountInTransCrcy	taxamountintranscrcy	TaxAmt in Tran. Crcy
	TaxAmountInCoCodeCrcy	taxamountincocodecrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	taxbaseamountintranscrcy	Value-Added Tax
	TaxBaseAmountInCoCodeCrcy	taxbaseamountincocodecrcy	TxBaseAmt CoCodeCrcy
	TxBaseAmtWithTxRate0InCCCrcy	txbaseamtwithtxrate0incccrcy	Tax Base Amount 0%
	TxBaseAmtWithTxRate10InCCCrcy	txbaseamtwithtxrate10incccrcy	Tax Base Amount 10%
	TxBaseAmtWithTxRate18InCCCrcy	txbaseamtwithtxrate18incccrcy	Tax Base Amount 18%
	TxBaseAmtWithTxRate20InCCCrcy	txbaseamtwithtxrate20incccrcy	Tax Base Amount 20%
	BaseAmtWithoutTxInCCCrcy	baseamtwithouttxincccrcy	Base Amount No Tax
	TxAmtWithTxRate10InCCCrcy	txamtwithtxrate10incccrcy	Tax Amount 10%
	TxAmtWithTxRate18InCCCrcy	txamtwithtxrate18incccrcy	Tax Amount 18%
	TxAmtWithTxRate20InCCCrcy	txamtwithtxrate20incccrcy	Tax Amount 20%
	BusinessPartner	businesspartner	Issuing Authority
	BusinessPartnerIsOrganization	businesspartnerisorganization	BP is Org
	IsNaturalPerson	businesspartnerisnaturalperson	Natural Person
	BusinessPartnerName	businesspartnername	Extracted Customer Name
	RU_PartnerOrganizationINN	ru_partnerorganizationinn	BP INN
	RU_PartnerOrganizationKPP	ru_partnerorganizationkpp	BP KPP
	RU_PartnerPersonINN	ru_partnerpersoninn	BP Pers. INN
	FirstName	firstname	First Name
	LastName	lastname	Last Name
	MiddleName	middlename	Middle Name
	BusinessPartnerCountry	businesspartnercountry	BP Ctry/Reg.
	Agent		Processor ID
	AgentIsOrganization	agentisorganization	Agent Is Org
	AgentOrganizationName	agentorganizationname	Agent Name
	RU_AgentOrganizationINN	ru_agentorganizationinn	Agent INN
	RU_AgentOrganizationKPP	ru_agentorganizationkpp	Agent KPP
	RU_AgentPersonINN	ru_agentpersoninn	Agent Pers. INN
	AgentPersonSurname	agentpersonsurname	Agent Pers. Last Nm
	AgentPersonName	agentpersonname	Agent Pers. Frst Nm
	AgentPersonMiddleName	agentpersonmiddlename	Agent Pers. Mid Nm
	RU_IncomingInvoiceCompanyCode	ru_incominginvoicecompanycode	Inc.Company Code
	RU_IncomingInvoiceNumber		Inc.Orig.Inv.Number
	RU_IncomingInvoiceFiscalYear	ru_incominginvoicefiscalyear	Inc.Orig.Inv.Year
	IncomingCorrectionInvoice	incomingcorrectioninvoice	Inc.Corr.Inv.Number
	IncomingCorrectionInvoiceYear	incomingcorrectioninvoiceyear	Inc.Corr.Inv.Year
	IncomingRevisionNumber	incomingrevisionnumber	Inc.Rev.Number
	IncomingExternalInvoice	incomingexternalinvoice	Inc.ExternalDocNmbr
	RU_IncomingInvoiceDate	ru_incominginvoicedate	Inc.ExternalDocDate
	RU_IncomingInvoiceType	ru_incominginvoicetype	Inc.Invoice Type
	IncomingInvoiceTransCurrency	incominginvoicetranscurrency	In Transaction Curr
	IncgInvoiceTransCrcyISOCode	incginvoicetranscrcyisocode	Inc.Currency ISOCode
	CommsnTradeInvoiceLinkedAmount	commsntradeinvoicelinkedamount	Linked Amount
	CommsnTradeInvcLinkedVATAmount	commsntradeinvclinkedvatamount	Linked VAT
	OriginalAmountInTransacCrcy	originalamountintransaccrcy	Origl Amt Trans Crcy
	OriginalTaxAmountInTransacCrcy	originaltaxamountintransaccrcy	TaxAmtOrigInTrCrcy
	DifferenceAmtInTransCrcy	differenceamtintranscrcy	AmtDifInTransCrcy
	DifferenceTaxAmtInTransCrcy	differencetaxamtintranscrcy	TaxAmtDifInTrCrcy
	RU_VATOperationType	ru_vatoperationtype	Operation Type Code
	SalesDealType		Deal Type
	RU_TerritoryClassfctnOKTMO		OKTMO
	VATReturnOperation	vatreturnoperation	Operation Code
	ExportInvcConfirmedFiscalYear	exportinvcconfirmedfiscalyear	Reporting Year
	FiscalPeriod		Tax period
	RU_VATReturnSection	ru_vatreturnsection	VAT Return Section
	RU_VATReturnLine	ru_vatreturnline	Line
	RU_VATReturnVersion	ru_vatreturnversion	VAT Return Version
	RU_VATSubScenarioVersion	ru_vatsubscenarioversion	Subscenario Version
	RU_VATScenario	ru_vatscenario	VAT Scenario

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 I_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: IRUVATRPTGITL

CREATE VIEW I_RU_VATReportingItemLog AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  RevisionNumber,
  RU_VATReturnSectionType,
  cast(originaldocument as cds_source_document) AS SourceDocument,
  originaldocumentyear AS SourceDocumentFiscalYear,
  RU_VATSubScenario,
  Sign,
  Invoice,
  InvoiceYear,
  ExternalInvoice,
  InvoiceDate,
  RevisionInvoice,
  RevisionInvoiceYear,
  OriginalInvoiceRevisionNumber,
  OriginalInvoiceRevisionDate,
  CorrectionInvoice,
  CorrectionInvoiceYear,
  ExternalCorrectionInvoice,
  CorrectionInvoiceDate,
  CorrectionInvoiceRevisionNmbr,
  CorrectionInvoiceRevisionDate,
  TaxReportingDate,
  IsReversal,
  IsReversed,
  RU_InvoiceType,
  TaxCode,
  TaxItemGroupingVersion,
  CompanyCodeCurrency,
  Currency,
  CurrencyISOCode,
  TotalAmountInTransactionCrcy,
  TotalAmountInCoCodeCrcy,
  TaxAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TxBaseAmtWithTxRate0InCCCrcy,
  TxBaseAmtWithTxRate10InCCCrcy,
  TxBaseAmtWithTxRate18InCCCrcy,
  TxBaseAmtWithTxRate20InCCCrcy,
  BaseAmtWithoutTxInCCCrcy,
  TxAmtWithTxRate10InCCCrcy,
  TxAmtWithTxRate18InCCCrcy,
  TxAmtWithTxRate20InCCCrcy,
  BusinessPartner,
  BusinessPartnerIsOrganization,
  businesspartnerisnaturalperson AS IsNaturalPerson,
  BusinessPartnerName,
  RU_PartnerOrganizationINN,
  RU_PartnerOrganizationKPP,
  RU_PartnerPersonINN,
  FirstName,
  LastName,
  MiddleName,
  BusinessPartnerCountry,
  cast(agent as actorid) AS Agent,
  AgentIsOrganization,
  AgentOrganizationName,
  RU_AgentOrganizationINN,
  RU_AgentOrganizationKPP,
  RU_AgentPersonINN,
  AgentPersonSurname,
  AgentPersonName,
  AgentPersonMiddleName,
  RU_IncomingInvoiceCompanyCode,
  cast(ru_incominginvoicenumber as char50) AS RU_IncomingInvoiceNumber,
  RU_IncomingInvoiceFiscalYear,
  IncomingCorrectionInvoice,
  IncomingCorrectionInvoiceYear,
  IncomingRevisionNumber,
  IncomingExternalInvoice,
  RU_IncomingInvoiceDate,
  RU_IncomingInvoiceType,
  IncomingInvoiceTransCurrency,
  IncgInvoiceTransCrcyISOCode,
  CommsnTradeInvoiceLinkedAmount,
  CommsnTradeInvcLinkedVATAmount,
  OriginalAmountInTransacCrcy,
  OriginalTaxAmountInTransacCrcy,
  DifferenceAmtInTransCrcy,
  DifferenceTaxAmtInTransCrcy,
  RU_VATOperationType,
  cast(salesdealtype as char4) AS SalesDealType,
  cast(ru_territoryclassfctnoktmo as firu_oktmo_int) AS RU_TerritoryClassfctnOKTMO,
  VATReturnOperation,
  ExportInvcConfirmedFiscalYear,
  cast(fiscalperiod as numc3) AS FiscalPeriod,
  RU_VATReturnSection,
  RU_VATReturnLine,
  RU_VATReturnVersion,
  RU_VATSubScenarioVersion,
  RU_VATScenario
FROM firud_vat1_rpitm
;

Depth:

I_RU_VATReportingItemLog view

firud_vat1_rpitm

P_RU_VATReportingItemLog view