P_RU_DSInvoiceJournal4

DDL: P_RU_DSINVOICEJOURNAL4 SQL: PRUDSINVCJRNL4 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU_INVJOURNAL
25 Fields 4 Data Sources

InvJournal: Get External Data (obsoleted)

P_RU_DSInvoiceJournal4 is a Consumption CDS View that provides data about "InvJournal: Get External Data (obsoleted)" in SAP S/4HANA. It reads from 4 data sources (P_RU_VATExtraInfo, P_RU_VATExtraInfo, P_RU_VATExtraInfo, I_RU_ReverseDocuments) and exposes 25 fields. Part of development package GLO_FIN_IS_VAT_RU_INVJOURNAL.

Data Sources (4)

SourceAliasJoin Type
P_RU_VATExtraInfo AcctgDocumentExtraInfo left_outer
P_RU_VATExtraInfo CorrInvoiceExtraInfo left_outer
P_RU_VATExtraInfo InvoiceExtraInfo left_outer
I_RU_ReverseDocuments ReversedDocuments left_outer

Annotations (6)

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

Fields (25)

KeyFieldSource TableSource FieldDescription
CompanyCode InvoiceJournal CompanyCode Receiver Company Code
AccountingDocument InvoiceJournal AccountingDocument Journal Entry
FiscalYear InvoiceJournal FiscalYear G/L Fiscal Year
PostingDate InvoiceJournal PostingDate Posting Date for GR
RU_VATSubScenario InvoiceJournal RU_VATSubScenario Subscenario
RU_VATReturnSectionType InvoiceJournal RU_VATReturnSectionType Section Type
RU_VATReturnVersion InvoiceJournal RU_VATReturnVersion VAT Return Version
TaxCode InvoiceJournal TaxCode Tax Code
Invoice InvoiceJournal Invoice Orig.Inv.Number
InvoiceYear InvoiceJournal InvoiceYear Orig.Inv.Year
ExternalInvoice
InvoiceDate
CorrectionInvoice InvoiceJournal CorrectionInvoice Corr.Inv.Number
CorrectionInvoiceYear InvoiceJournal CorrectionInvoiceYear Corr.Inv.Year
ExternalCorrectionInvoice
CorrectionInvoiceDate
RevisionNumber InvoiceJournal RevisionNumber Revision Number
RevisionInvoiceDate InvoiceJournal RevisionInvoiceDate
OriginalInvoiceRevisionNumber InvoiceJournal OriginalInvoiceRevisionNumber Rev.Num.Orig.Inv.
OriginalInvoiceRevisionDate InvoiceJournal OriginalInvoiceRevisionDate Rev.Date Orig.Inv.
TaxReportingDate InvoiceJournal TaxReportingDate Tax Reporting Date
RevisionTaxReportingDate InvoiceJournal RevisionTaxReportingDate
ReverseDocument I_RU_ReverseDocuments ReverseDocument Reversed With
ReverseDocumentFiscalYear I_RU_ReverseDocuments ReverseDocumentFiscalYear Year
ActionRuleIsGenerated InvoiceJournal ActionRuleIsGenerated

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_DSInvoiceJournal4.
-- 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: PRUDSINVCJRNL4

CREATE VIEW P_RU_DSInvoiceJournal4 AS
SELECT
  InvoiceJournal.CompanyCode AS CompanyCode,
  InvoiceJournal.AccountingDocument AS AccountingDocument,
  InvoiceJournal.FiscalYear AS FiscalYear,
  InvoiceJournal.PostingDate AS PostingDate,
  InvoiceJournal.RU_VATSubScenario AS RU_VATSubScenario,
  InvoiceJournal.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  InvoiceJournal.RU_VATReturnVersion AS RU_VATReturnVersion,
  InvoiceJournal.TaxCode AS TaxCode,
  InvoiceJournal.Invoice AS Invoice,
  InvoiceJournal.InvoiceYear AS InvoiceYear,
  coalesce(InvoiceExtraInfo.ExternalInvoice, '') AS ExternalInvoice,
  coalesce(InvoiceExtraInfo.InvoiceDate, '00000000') AS InvoiceDate,
  InvoiceJournal.CorrectionInvoice AS CorrectionInvoice,
  InvoiceJournal.CorrectionInvoiceYear AS CorrectionInvoiceYear,
  coalesce(CorrInvoiceExtraInfo.ExternalInvoice, '') AS ExternalCorrectionInvoice,
  coalesce(CorrInvoiceExtraInfo.InvoiceDate, '00000000') AS CorrectionInvoiceDate,
  InvoiceJournal.RevisionNumber AS RevisionNumber,
  InvoiceJournal.RevisionInvoiceDate AS RevisionInvoiceDate,
  InvoiceJournal.OriginalInvoiceRevisionNumber AS OriginalInvoiceRevisionNumber,
  InvoiceJournal.OriginalInvoiceRevisionDate AS OriginalInvoiceRevisionDate,
  InvoiceJournal.TaxReportingDate AS TaxReportingDate,
  InvoiceJournal.RevisionTaxReportingDate AS RevisionTaxReportingDate,
  ReversedDocuments.ReverseDocument AS ReverseDocument,
  ReversedDocuments.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  InvoiceJournal.ActionRuleIsGenerated AS ActionRuleIsGenerated
LEFT OUTER JOIN I_RU_ReverseDocuments AS ReversedDocuments ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_VATExtraInfo AS InvoiceExtraInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_VATExtraInfo AS CorrInvoiceExtraInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_VATExtraInfo AS AcctgDocumentExtraInfo ON /* join condition not captured in parsed metadata */
;

Learn More