P_RU_VATSPLedgersJournal

DDL: P_RU_VATSPLEDGERSJOURNAL SQL: PRUVATSPLDJ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
86 Fields 1 Data Sources

SPLedgers/Journal

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

Data Sources (1)

SourceAliasJoin Type
P_RU_VATSPLedgersJournal5 P_RU_VATSPLedgersJournal5 from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUVATSPLDJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (86)

KeyFieldSource TableSource FieldDescription
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
DebitCreditCode DebitCreditCode Single-Character Flag
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
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
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
RU_TotalAmountCalcType RU_TotalAmountCalcType
RU_TaxBaseAmountCalcType RU_TaxBaseAmountCalcType
BusinessPartnerType BusinessPartnerType Undefined range (can be used for patch levels)
AgentType AgentType
PaymentOrderOutputType PaymentOrderOutputType
ImprtCstmsDeclnIsRead ImprtCstmsDeclnIsRead
MatlRcptDateIsRead MatlRcptDateIsRead
RU_CustomerOutputType RU_CustomerOutputType
RU_SupplierAgentOutputType RU_SupplierAgentOutputType
RU_SupplierOutputType RU_SupplierOutputType
RU_SubagentOutputType RU_SubagentOutputType
SalesDealType SalesDealType Deal Type
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_VATSPLedgersJournal.
-- 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: PRUVATSPLDJ

CREATE VIEW P_RU_VATSPLedgersJournal AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  PostingDate,
  TaxReportingDate,
  DocumentDate,
  AccountingDocumentType,
  IsReversal,
  IsReversed,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  BusinessTransactionType,
  SenderLogicalSystem,
  TaxCode,
  TaxRate,
  DebitCreditCode,
  Invoice,
  InvoiceYear,
  ExternalInvoice,
  InvoiceDate,
  OriginalInvoiceRevisionNumber,
  OriginalInvoiceRevisionDate,
  CorrectionInvoice,
  CorrectionInvoiceYear,
  ExternalCorrectionInvoice,
  CorrectionInvoiceDate,
  CorrectionInvoiceRevisionNmbr,
  CorrectionInvoiceRevisionDate,
  RevisionInvoice,
  RevisionInvoiceYear,
  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,
  TaxItemGroupingVersion,
  Sign,
  RU_VATReturnVersion,
  RU_VATReturnSectionType,
  RU_VATReturnSection,
  RU_VATReturnLine,
  RU_VATSubScenarioVersion,
  RU_VATSubScenario,
  RU_VATScenario,
  RU_TotalAmountCalcType,
  RU_TaxBaseAmountCalcType,
  BusinessPartnerType,
  AgentType,
  PaymentOrderOutputType,
  ImprtCstmsDeclnIsRead,
  MatlRcptDateIsRead,
  RU_CustomerOutputType,
  RU_SupplierAgentOutputType,
  RU_SupplierOutputType,
  RU_SubagentOutputType,
  SalesDealType,
  RU_OrgOperationType,
  RU_PersonOperationType,
  SourceDocument,
  SourceDocumentFiscalYear,
  RevisionNumber,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM P_RU_VATSPLedgersJournal5
;

Learn More