P_RU_VATItemLogDelta

DDL: P_RU_VATITEMLOGDELTA SQL: PRUVATITMLOGD Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
21 Fields 2 Data Sources

ACR Reported Tax Items Log Table

P_RU_VATItemLogDelta is a Consumption CDS View that provides data about "ACR Reported Tax Items Log Table" in SAP S/4HANA. It reads from 2 data sources (I_RU_StRpJournalEntryLog, I_RU_StRpJournalEntryLog) and exposes 21 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (2)

SourceAliasJoin Type
I_RU_StRpJournalEntryLog Run1 from
I_RU_StRpJournalEntryLog Run2 union_all

Parameters (2)

NameTypeDefault
P_RunID1 srf_report_run_id
P_RunID2 srf_report_run_id

Annotations (6)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity I_RU_StRpJournalEntryLog StatryRptgEntity Reporting Entity
StatryRptCategory I_RU_StRpJournalEntryLog StatryRptCategory Report ID
StatryRptRunID I_RU_StRpJournalEntryLog StatryRptRunID Report Run ID
CompanyCode I_RU_StRpJournalEntryLog CompanyCode Receiver Company Code
AccountingDocument I_RU_StRpJournalEntryLog AccountingDocument Journal Entry
FiscalYear I_RU_StRpJournalEntryLog FiscalYear G/L Fiscal Year
TaxItem I_RU_StRpJournalEntryLog TaxItem Tax Item
RevisionNumber I_RU_StRpJournalEntryLog RevisionNumber Revision Number
RU_VATReturnSectionType I_RU_StRpJournalEntryLog RU_VATReturnSectionType Section Type
RunID1
StatryRptgEntity Reporting Entity
StatryRptCategory I_RU_StRpJournalEntryLog StatryRptCategory Report ID
StatryRptRunID I_RU_StRpJournalEntryLog StatryRptRunID Report Run ID
CompanyCode I_RU_StRpJournalEntryLog CompanyCode Receiver Company Code
AccountingDocument I_RU_StRpJournalEntryLog AccountingDocument Journal Entry
FiscalYear I_RU_StRpJournalEntryLog FiscalYear G/L Fiscal Year
TaxItem I_RU_StRpJournalEntryLog TaxItem Tax Item
RevisionNumber I_RU_StRpJournalEntryLog RevisionNumber Revision Number
RU_VATReturnSectionType I_RU_StRpJournalEntryLog RU_VATReturnSectionType Section Type
RunID1
RunID2

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_VATItemLogDelta.
-- 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: PRUVATITMLOGD
-- Parameters: P_RunID1 : srf_report_run_id, P_RunID2 : srf_report_run_id

CREATE VIEW P_RU_VATItemLogDelta AS
SELECT
  Run1.StatryRptgEntity AS StatryRptgEntity,
  Run1.StatryRptCategory AS StatryRptCategory,
  Run1.StatryRptRunID AS StatryRptRunID,
  Run1.CompanyCode AS CompanyCode,
  Run1.AccountingDocument AS AccountingDocument,
  Run1.FiscalYear AS FiscalYear,
  Run1.TaxItem AS TaxItem,
  Run1.RevisionNumber AS RevisionNumber,
  Run1.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  $parameters.P_RunID1 AS RunID1,
  $parameters.P_RunID2 AS RunID2
FROM I_RU_StRpJournalEntryLog AS Run1
-- UNION ALL with additional select branch(es): I_RU_StRpJournalEntryLog
;

Learn More