Which tables does P_RU_VATSPLedgersJournal1 read from?

P_RU_VATSPLedgersJournal1 reads data from: P_RU_VATReporting.

What VDM layer is P_RU_VATSPLedgersJournal1?

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

P_RU_VATSPLedgersJournal1

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

P_RU_VATSPLedgersJournal1 is a consumption CDS view in SAP S/4HANA. It contains 89 fields.

DDL: P_RU_VATSPLEDGERSJOURNAL1 SQL: PRUVATSPLDJ1 Type: view CONSUMPTION

89 Fields 1 Data Sources

P_RU_VATSPLedgersJournal1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_VATReporting) and exposes 89 fields.

Data Sources (1)

Source	Alias	Join Type
P_RU_VATReporting	VatReporting	from

Annotations (6)

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

Fields (89)

Field	Source Table	Source Field	Description
CompanyCode	P_RU_VATReporting	CompanyCode	Receiver Company Code
AccountingDocument	P_RU_VATReporting	AccountingDocument	Journal Entry
FiscalYear	P_RU_VATReporting	FiscalYear	G/L Fiscal Year
TaxItem	P_RU_VATReporting	TaxItem	Tax Item
PostingDateendasPostingDate
TaxReportingDateendasTaxReportingDate
DocumentDate	P_RU_VATReporting	DocumentDate	Journal Entry Date
AccountingDocumentType	P_RU_VATReporting	AccountingDocumentType	Journal Entry Type
IsReversal	P_RU_VATReporting	IsReversal	Reversal doc.
IsReversed	P_RU_VATReporting	IsReversed	Reversed?
OriginalReferenceDocument	P_RU_VATReporting	OriginalReferenceDocument	Reference Key
ReferenceDocumentType	P_RU_VATReporting	ReferenceDocumentType	Reference Document Type
BusinessTransactionType	P_RU_VATReporting	BusinessTransactionType	Bus.transaction
SenderLogicalSystem	P_RU_VATReporting	SenderLogicalSystem	Sender Logical System
TaxCode	P_RU_VATReporting	TaxCode	Tax Code
TaxRate	P_RU_VATReporting	TaxRate	Tax Rate
CompanyCodeCurrency	P_RU_VATReporting	CompanyCodeCurrency	Local Currency
Currency	P_RU_VATReporting	Currency	Valuation Crcy
AmountInCompanyCodeCurrency	P_RU_VATReporting	AmountInCompanyCodeCurrency	Local Crcy Amt
TaxBaseAmountInCoCodeCrcy	P_RU_VATReporting	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy	P_RU_VATReporting	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
AmountInTransactionCurrency	P_RU_VATReporting	AmountInTransactionCurrency	Pt Crcy Amt
TaxBaseAmountInTransCrcy	P_RU_VATReporting	TaxBaseAmountInTransCrcy	Value-Added Tax
TaxAmount	P_RU_VATReporting	TaxAmount	Tax Amt in Rptg Crcy
DebitCreditCode	P_RU_VATReporting	DebitCreditCode	Single-Character Flag
Sign	P_RU_VATReporting	Sign	Type of SIGN component in row type of a Ranges type
Invoice
InvoiceYear
CorrectionInvoice	VatCorRev	CorrectionInvoice	Corr.Inv.Number
CorrectionInvoiceYear	VatCorRev	CorrectionInvoiceYear	Corr.Inv.Year
RevisionInvoice	VatCorRev	RevisionInvoice	Rev.Inv.Number
RevisionInvoiceDate	VatCorRev	RevisionInvoiceDate
RevisionInvoiceYear	VatCorRev	RevisionInvoiceYear	Rev.Inv.Year
OriginalInvoiceRevisionNumber	VatCorRev	OriginalInvoiceRevisionNumber	Rev.Num.Orig.Inv.
OriginalInvoiceRevisionDate	VatCorRev	OriginalInvoiceRevisionDate	Rev.Date Orig.Inv.
CorRev_CompanyCodeName	VatCorRev	CompanyCodeName	Company Name
CorRev_CompanyCodeINN	VatCorRev	RU_CompanyCodeINN
CorRev_CompanyCodeKPP	VatCorRev	RU_CompanyCodeKPP
CorRev_BusinessPartnerName	VatCorRev	BusinessPartnerName	Extracted Customer Name
CorRev_BusinessPartnerINN	VatCorRev	RU_PartnerOrganizationINN	BP INN
CorRev_BusinessPartnerKPP	VatCorRev	RU_PartnerOrganizationKPP	BP KPP
CorRev_BusinessPartnerIsOrg	VatCorRev	RU_PartnerOrganizationIsOrg
CorRev_BusinessPartnerIsNP	VatCorRev	RU_PartnerOrganizationIsNP
CorRev_SupplierName	VatCorRev	SupplierName	Supplier Name
CorRev_SupplierINN	VatCorRev	RU_SupplierINN
CorRev_SupplierKPP	VatCorRev	RU_SupplierKPP	Seller KPP
CorRev_SupplierIsOrg	VatCorRev	RU_SupplierIsOrg
CorRev_SupplierIsNP	VatCorRev	RU_SupplierIsNP
CorRev_CommisTradeSupplierName	VatCorRev	RU_CommissionTradeSupplierName
CorRev_CommisTradeSupplierINN	VatCorRev	RU_CommissionTradeSupplierINN
CorRev_CommisTradeSupplierKPP	VatCorRev	RU_CommissionTradeSupplierKPP
CorRev_CommisTradeSupplIsOrg	VatCorRev	RU_CommissionTradeSuplrIsOrg
CorRev_CommisTradeSupplIsNP	VatCorRev	RU_CommissionTradeSuplrIsNP
CorRev_CommisTradeCustomerName	VatCorRev	RU_CommissionTradeCustomerName
CorRev_CommisTradeCustomerINN	VatCorRev	RU_CommissionTradeCustomerINN
CorRev_CommisTradeCustomerKPP	VatCorRev	RU_CommissionTradeCustomerKPP
CorRev_CommisTradeCustIsOrg	VatCorRev	RU_CommissionTradeCustIsOrg
CorRev_CommisTradeCustIsNP	VatCorRev	RU_CommissionTradeCustIsNP
LedgerLineSign	VatCorRev	LedgerLineSign
IsRevisionReversed	VatCorRev	IsRevisionReversed
IsLastDocumentCorRevChain	VatCorRev	IsLastDocumentCorRevChain
IntermediateRevisionsAreShown	CompanyCodeVatParam	IntermediateRevisionsAreShown
RU_VATReturnVersion	P_RU_VATReporting	RU_VATReturnVersion	VAT Return Version
RU_VATReturnSectionType	P_RU_VATReporting	RU_VATReturnSectionType	Section Type
RU_VATReturnSection	P_RU_VATReporting	RU_VATReturnSection	VAT Return Section
RU_VATReturnLine	P_RU_VATReporting	RU_VATReturnLine	Line
RU_VATSubScenarioVersion	P_RU_VATReporting	RU_VATSubScenarioVersion	Subscenario Version
RU_VATSubScenario	P_RU_VATReporting	RU_VATSubScenario	Subscenario
RU_VATScenario	P_RU_VATReporting	RU_VATScenario	VAT Scenario
RU_TotalAmountCalcType	P_RU_VATReporting	RU_TotalAmountCalcType
RU_TaxBaseAmountCalcType	P_RU_VATReporting	RU_TaxBaseAmountCalcType
BusinessPartnerType	P_RU_VATReporting	BusinessPartnerType	Undefined range (can be used for patch levels)
AgentType	P_RU_VATReporting	AgentType
PaymentOrderOutputType	P_RU_VATReporting	PaymentOrderOutputType
ImprtCstmsDeclnIsRead	P_RU_VATReporting	ImprtCstmsDeclnIsRead
MatlRcptDateIsRead	P_RU_VATReporting	MatlRcptDateIsRead
RU_CustomerOutputType	P_RU_VATReporting	RU_CustomerOutputType
RU_SupplierAgentOutputType	P_RU_VATReporting	RU_SupplierAgentOutputType
RU_SupplierOutputType	P_RU_VATReporting	RU_SupplierOutputType
RU_SubagentOutputType	P_RU_VATReporting	RU_SubagentOutputType
SalesDealType	P_RU_VATReporting	SalesDealType	Deal Type
RU_OrgOperationType	P_RU_VATReporting	RU_OrgOperationType
RU_PersonOperationType	P_RU_VATReporting	RU_PersonOperationType
SourceDocument	P_RU_VATReporting	SourceDocument	Document
SourceDocumentFiscalYear	P_RU_VATReporting	SourceDocumentFiscalYear
RevisionNumber	P_RU_VATReporting	RevisionNumber	Revision Number
StatryRptgEntity	P_RU_VATReporting	StatryRptgEntity	Reporting Entity
StatryRptCategory	P_RU_VATReporting	StatryRptCategory	Report ID
StatryRptRunID	P_RU_VATReporting	StatryRptRunID	Report Run ID

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_VATSPLedgersJournal1.
-- 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: PRUVATSPLDJ1

CREATE VIEW P_RU_VATSPLedgersJournal1 AS
SELECT
  VatReporting.CompanyCode AS CompanyCode,
  VatReporting.AccountingDocument AS AccountingDocument,
  VatReporting.FiscalYear AS FiscalYear,
  VatReporting.TaxItem AS TaxItem,
  case when VatCorRev.RevisionInvoiceDate is not null and VatCorRev.RevisionInvoiceDate <> '00000000' then VatCorRev.RevisionInvoiceDate else VatReporting.PostingDate end as PostingDate AS PostingDateendasPostingDate,
  case when VatCorRev.RevisionTaxReportingDate is not null and VatCorRev.RevisionTaxReportingDate <> '00000000' then VatCorRev.RevisionTaxReportingDate else VatReporting.TaxReportingDate end as TaxReportingDate AS TaxReportingDateendasTaxReportingDate,
  VatReporting.DocumentDate AS DocumentDate,
  VatReporting.AccountingDocumentType AS AccountingDocumentType,
  VatReporting.IsReversal AS IsReversal,
  VatReporting.IsReversed AS IsReversed,
  VatReporting.OriginalReferenceDocument AS OriginalReferenceDocument,
  VatReporting.ReferenceDocumentType AS ReferenceDocumentType,
  VatReporting.BusinessTransactionType AS BusinessTransactionType,
  VatReporting.SenderLogicalSystem AS SenderLogicalSystem,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.TaxRate AS TaxRate,
  VatReporting.CompanyCodeCurrency AS CompanyCodeCurrency,
  VatReporting.Currency AS Currency,
  VatReporting.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  VatReporting.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  VatReporting.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  VatReporting.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  VatReporting.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  VatReporting.TaxAmount AS TaxAmount,
  VatReporting.DebitCreditCode AS DebitCreditCode,
  VatReporting.Sign AS Sign,
  coalesce(VatCorRev.Invoice, VatReporting.SourceDocument) AS Invoice,
  coalesce(VatCorRev.InvoiceYear, VatReporting.SourceDocumentFiscalYear) AS InvoiceYear,
  VatCorRev.CorrectionInvoice AS CorrectionInvoice,
  VatCorRev.CorrectionInvoiceYear AS CorrectionInvoiceYear,
  VatCorRev.RevisionInvoice AS RevisionInvoice,
  VatCorRev.RevisionInvoiceDate AS RevisionInvoiceDate,
  VatCorRev.RevisionInvoiceYear AS RevisionInvoiceYear,
  VatCorRev.OriginalInvoiceRevisionNumber AS OriginalInvoiceRevisionNumber,
  VatCorRev.OriginalInvoiceRevisionDate AS OriginalInvoiceRevisionDate,
  VatCorRev.CompanyCodeName AS CorRev_CompanyCodeName,
  VatCorRev.RU_CompanyCodeINN AS CorRev_CompanyCodeINN,
  VatCorRev.RU_CompanyCodeKPP AS CorRev_CompanyCodeKPP,
  VatCorRev.BusinessPartnerName AS CorRev_BusinessPartnerName,
  VatCorRev.RU_PartnerOrganizationINN AS CorRev_BusinessPartnerINN,
  VatCorRev.RU_PartnerOrganizationKPP AS CorRev_BusinessPartnerKPP,
  VatCorRev.RU_PartnerOrganizationIsOrg AS CorRev_BusinessPartnerIsOrg,
  VatCorRev.RU_PartnerOrganizationIsNP AS CorRev_BusinessPartnerIsNP,
  VatCorRev.SupplierName AS CorRev_SupplierName,
  VatCorRev.RU_SupplierINN AS CorRev_SupplierINN,
  VatCorRev.RU_SupplierKPP AS CorRev_SupplierKPP,
  VatCorRev.RU_SupplierIsOrg AS CorRev_SupplierIsOrg,
  VatCorRev.RU_SupplierIsNP AS CorRev_SupplierIsNP,
  VatCorRev.RU_CommissionTradeSupplierName AS CorRev_CommisTradeSupplierName,
  VatCorRev.RU_CommissionTradeSupplierINN AS CorRev_CommisTradeSupplierINN,
  VatCorRev.RU_CommissionTradeSupplierKPP AS CorRev_CommisTradeSupplierKPP,
  VatCorRev.RU_CommissionTradeSuplrIsOrg AS CorRev_CommisTradeSupplIsOrg,
  VatCorRev.RU_CommissionTradeSuplrIsNP AS CorRev_CommisTradeSupplIsNP,
  VatCorRev.RU_CommissionTradeCustomerName AS CorRev_CommisTradeCustomerName,
  VatCorRev.RU_CommissionTradeCustomerINN AS CorRev_CommisTradeCustomerINN,
  VatCorRev.RU_CommissionTradeCustomerKPP AS CorRev_CommisTradeCustomerKPP,
  VatCorRev.RU_CommissionTradeCustIsOrg AS CorRev_CommisTradeCustIsOrg,
  VatCorRev.RU_CommissionTradeCustIsNP AS CorRev_CommisTradeCustIsNP,
  VatCorRev.LedgerLineSign AS LedgerLineSign,
  VatCorRev.IsRevisionReversed AS IsRevisionReversed,
  VatCorRev.IsLastDocumentCorRevChain AS IsLastDocumentCorRevChain,
  CompanyCodeVatParam.IntermediateRevisionsAreShown AS IntermediateRevisionsAreShown,
  VatReporting.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReporting.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatReporting.RU_VATReturnSection AS RU_VATReturnSection,
  VatReporting.RU_VATReturnLine AS RU_VATReturnLine,
  VatReporting.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatReporting.RU_VATSubScenario AS RU_VATSubScenario,
  VatReporting.RU_VATScenario AS RU_VATScenario,
  VatReporting.RU_TotalAmountCalcType AS RU_TotalAmountCalcType,
  VatReporting.RU_TaxBaseAmountCalcType AS RU_TaxBaseAmountCalcType,
  VatReporting.BusinessPartnerType AS BusinessPartnerType,
  VatReporting.AgentType AS AgentType,
  VatReporting.PaymentOrderOutputType AS PaymentOrderOutputType,
  VatReporting.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  VatReporting.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  VatReporting.RU_CustomerOutputType AS RU_CustomerOutputType,
  VatReporting.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
  VatReporting.RU_SupplierOutputType AS RU_SupplierOutputType,
  VatReporting.RU_SubagentOutputType AS RU_SubagentOutputType,
  VatReporting.SalesDealType AS SalesDealType,
  VatReporting.RU_OrgOperationType AS RU_OrgOperationType,
  VatReporting.RU_PersonOperationType AS RU_PersonOperationType,
  VatReporting.SourceDocument AS SourceDocument,
  VatReporting.SourceDocumentFiscalYear AS SourceDocumentFiscalYear,
  VatReporting.RevisionNumber AS RevisionNumber,
  VatReporting.StatryRptgEntity AS StatryRptgEntity,
  VatReporting.StatryRptCategory AS StatryRptCategory,
  VatReporting.StatryRptRunID AS StatryRptRunID
FROM P_RU_VATReporting AS VatReporting
;

Depth:

P_RU_VATSPLedgersJournal1 view

P_RU_VATReporting view

P_RU_VATSPLedgersJournal2 view