What is P_RU_VATSPLedgers1 in SAP S/4HANA?

P_RU_VATSPLedgers1 is a consumption CDS view in SAP S/4HANA. SPLedgers: Amounts-1 It contains 85 fields.

Which tables does P_RU_VATSPLedgers1 read from?

P_RU_VATSPLedgers1 reads data from: P_RU_VATSPLedgersJournal.

What VDM layer is P_RU_VATSPLedgers1?

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

P_RU_VATSPLedgers1

DDL: P_RU_VATSPLEDGERS1 SQL: PRUVATSPLEDGERS1 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU

85 Fields 1 Data Sources

SPLedgers: Amounts-1

P_RU_VATSPLedgers1 is a Consumption CDS View that provides data about "SPLedgers: Amounts-1" in SAP S/4HANA. It reads from 1 data source (P_RU_VATSPLedgersJournal) and exposes 85 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (1)

Source	Alias	Join Type
P_RU_VATSPLedgersJournal	P_RU_VATSPLedgersJournal	from

Annotations (6)

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

Fields (85)

Field	Source Field	Description
CompanyCode	CompanyCode	Receiver Company Code
AccountingDocument	AccountingDocument	Journal Entry
FiscalYear	FiscalYear	G/L Fiscal Year
TaxItem	TaxItem	Tax Item
PostingDate	PostingDate	Posting Date for GR
TaxReportingDate	TaxReportingDate	Tax Reporting Date
DocumentDate	DocumentDate	Journal Entry Date
AccountingDocumentType	AccountingDocumentType	Journal Entry Type
IsReversal	IsReversal	Reversal doc.
IsReversed	IsReversed	Reversed?
OriginalReferenceDocument	OriginalReferenceDocument	Reference Key
ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
BusinessTransactionType	BusinessTransactionType	Bus.transaction
SenderLogicalSystem	SenderLogicalSystem	Sender Logical System
TaxCode	TaxCode	Tax Code
TaxRate	TaxRate	Tax Rate
Invoice	Invoice	Orig.Inv.Number
InvoiceYear	InvoiceYear	Orig.Inv.Year
ExternalInvoice	ExternalInvoice	External Number
InvoiceDate	InvoiceDate	Run On
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.
RevisionInvoice	RevisionInvoice	Rev.Inv.Number
RevisionInvoiceYear	RevisionInvoiceYear	Rev.Inv.Year
RU_InvoiceType	RU_InvoiceType	Invoice Type
CorRev_CompanyCodeName	CorRev_CompanyCodeName
CorRev_CompanyCodeINN	CorRev_CompanyCodeINN
CorRev_CompanyCodeKPP	CorRev_CompanyCodeKPP
CorRev_BusinessPartnerName	CorRev_BusinessPartnerName
CorRev_BusinessPartnerINN	CorRev_BusinessPartnerINN
CorRev_BusinessPartnerKPP	CorRev_BusinessPartnerKPP
CorRev_BusinessPartnerIsOrg	CorRev_BusinessPartnerIsOrg
CorRev_BusinessPartnerIsNP	CorRev_BusinessPartnerIsNP
CorRev_SupplierName	CorRev_SupplierName
CorRev_SupplierINN	CorRev_SupplierINN
CorRev_SupplierKPP	CorRev_SupplierKPP
CorRev_SupplierIsOrg	CorRev_SupplierIsOrg
CorRev_SupplierIsNP	CorRev_SupplierIsNP
CorRev_CommisTradeSupplierName	CorRev_CommisTradeSupplierName
CorRev_CommisTradeSupplierINN	CorRev_CommisTradeSupplierINN
CorRev_CommisTradeSupplierKPP	CorRev_CommisTradeSupplierKPP
CorRev_CommisTradeSupplIsOrg	CorRev_CommisTradeSupplIsOrg
CorRev_CommisTradeSupplIsNP	CorRev_CommisTradeSupplIsNP
CorRev_CommisTradeCustomerName	CorRev_CommisTradeCustomerName
CorRev_CommisTradeCustomerINN	CorRev_CommisTradeCustomerINN
CorRev_CommisTradeCustomerKPP	CorRev_CommisTradeCustomerKPP
CorRev_CommisTradeCustIsOrg	CorRev_CommisTradeCustIsOrg
CorRev_CommisTradeCustIsNP	CorRev_CommisTradeCustIsNP
CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
Currency	Currency	Valuation Crcy
CurrencyISOCode	CurrencyISOCode	Document Currency
TotalAmountInTransactionCrcy	TotalAmountInTransactionCrcy	Total Amt In Tr Crcy
TaxBaseAmountInTransCrcy	TaxBaseAmountInTransCrcy	Value-Added Tax
TaxAmountInTransCrcy	TaxAmountInTransCrcy	TaxAmt in Tran. Crcy
TotalAmountInCoCodeCrcy	TotalAmountInCoCodeCrcy	Total Amt In Co Crcy
TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
TaxItemGroupingVersion	TaxItemGroupingVersion	Tax Grping Ver.
Sign	Sign	Type of SIGN component in row type of a Ranges type
RU_VATReturnVersion	RU_VATReturnVersion	VAT Return Version
RU_VATReturnSectionType	RU_VATReturnSectionType	Section Type
RU_VATReturnSection	RU_VATReturnSection	VAT Return Section
RU_VATReturnLine	RU_VATReturnLine	Line
RU_VATSubScenarioVersion	RU_VATSubScenarioVersion	Subscenario Version
RU_VATSubScenario	RU_VATSubScenario	Subscenario
RU_VATScenario	RU_VATScenario	VAT Scenario
BusinessPartnerType	BusinessPartnerType	Undefined range (can be used for patch levels)
AgentType	AgentType
PaymentOrderOutputType	PaymentOrderOutputType
ImprtCstmsDeclnIsRead	ImprtCstmsDeclnIsRead
MatlRcptDateIsRead	MatlRcptDateIsRead
RU_OrgOperationType	RU_OrgOperationType
RU_PersonOperationType	RU_PersonOperationType
SourceDocument	SourceDocument	Document
SourceDocumentFiscalYear	SourceDocumentFiscalYear
RevisionNumber	RevisionNumber	Revision Number
StatryRptgEntity	StatryRptgEntity	Reporting Entity
StatryRptCategory	StatryRptCategory	Report ID
StatryRptRunID	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_VATSPLedgers1.
-- 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: PRUVATSPLEDGERS1

CREATE VIEW P_RU_VATSPLedgers1 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  PostingDate,
  TaxReportingDate,
  DocumentDate,
  AccountingDocumentType,
  IsReversal,
  IsReversed,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  BusinessTransactionType,
  SenderLogicalSystem,
  TaxCode,
  TaxRate,
  Invoice,
  InvoiceYear,
  ExternalInvoice,
  InvoiceDate,
  OriginalInvoiceRevisionNumber,
  OriginalInvoiceRevisionDate,
  CorrectionInvoice,
  CorrectionInvoiceYear,
  ExternalCorrectionInvoice,
  CorrectionInvoiceDate,
  CorrectionInvoiceRevisionNmbr,
  CorrectionInvoiceRevisionDate,
  RevisionInvoice,
  RevisionInvoiceYear,
  RU_InvoiceType,
  CorRev_CompanyCodeName,
  CorRev_CompanyCodeINN,
  CorRev_CompanyCodeKPP,
  CorRev_BusinessPartnerName,
  CorRev_BusinessPartnerINN,
  CorRev_BusinessPartnerKPP,
  CorRev_BusinessPartnerIsOrg,
  CorRev_BusinessPartnerIsNP,
  CorRev_SupplierName,
  CorRev_SupplierINN,
  CorRev_SupplierKPP,
  CorRev_SupplierIsOrg,
  CorRev_SupplierIsNP,
  CorRev_CommisTradeSupplierName,
  CorRev_CommisTradeSupplierINN,
  CorRev_CommisTradeSupplierKPP,
  CorRev_CommisTradeSupplIsOrg,
  CorRev_CommisTradeSupplIsNP,
  CorRev_CommisTradeCustomerName,
  CorRev_CommisTradeCustomerINN,
  CorRev_CommisTradeCustomerKPP,
  CorRev_CommisTradeCustIsOrg,
  CorRev_CommisTradeCustIsNP,
  CompanyCodeCurrency,
  Currency,
  CurrencyISOCode,
  TotalAmountInTransactionCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInTransCrcy,
  TotalAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxItemGroupingVersion,
  Sign,
  RU_VATReturnVersion,
  RU_VATReturnSectionType,
  RU_VATReturnSection,
  RU_VATReturnLine,
  RU_VATSubScenarioVersion,
  RU_VATSubScenario,
  RU_VATScenario,
  BusinessPartnerType,
  AgentType,
  PaymentOrderOutputType,
  ImprtCstmsDeclnIsRead,
  MatlRcptDateIsRead,
  RU_OrgOperationType,
  RU_PersonOperationType,
  SourceDocument,
  SourceDocumentFiscalYear,
  RevisionNumber,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM P_RU_VATSPLedgersJournal
;

Depth:

P_RU_VATSPLedgers1 view

P_RU_VATSPLedgersJournal view

P_RU_VATSPLedgers2 view