P_RU_VATReportingRNPT1

DDL: P_RU_VATREPORTINGRNPT1 SQL: PRUVATREPRNPT1 Type: view CONSUMPTION
121 Fields 18 Data Sources

P_RU_VATReportingRNPT1 is a Consumption CDS View in SAP S/4HANA. It reads from 18 data sources and exposes 121 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem.

Annotations (7)

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

Fields (121)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber I_RU_TraceabilityMovementDocs RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityMovementDocs RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityMovementDocs RU_RNPTRegistrationItem RNPT Item
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
CompanyCode I_JournalEntry CompanyCode Receiver Company Code
AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
Quantity I_RU_TraceabilityMovementDocs Quantity Value
BaseUnitofMeasure I_RU_TraceabilityRegnNumber BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency I_RU_TraceabilityMovementDocs TotalAmountInLocalCurrency RNPT Item Amount
Currency I_RU_TraceabilityMovementDocs Currency Valuation Crcy
SourceTypeDesc
RU_RNPTPrimaryDocumentType I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentType Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentNumber RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentYear RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem I_RU_TraceabilityMovementDocs RU_RNPTPrimaryDocumentItem RNPT Assign.Doc Item
FinanceInvoice I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FinanceInvoiceFiscalYear I_RU_TraceabilityMovementDocs FiscalYear G/L Fiscal Year
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
SupplierInvoiceItem I_RU_TraceabilityMovementDocs SupplierInvoiceItem Item

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_VATReportingRNPT1.
-- 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: PRUVATREPRNPT1

CREATE VIEW P_RU_VATReportingRNPT1 AS
SELECT
  TRItem.RU_RNPTRegistrationNumber AS RU_RNPTRegistrationNumber,
  TRItem.RU_RNPTRegistrationYear AS RU_RNPTRegistrationYear,
  TRItem.RU_RNPTRegistrationItem AS RU_RNPTRegistrationItem,
  TRReg.RU_RNPTRegnExternalNumber AS RU_RNPTRegnExternalNumber,
  AccDoc.CompanyCode AS CompanyCode,
  AccDoc.AccountingDocument AS AccountingDocument,
  AccDoc.FiscalYear AS FiscalYear,
  TRItem.Quantity AS Quantity,
  TRReg.BaseUnitofMeasure AS BaseUnitofMeasure,
  TRItem.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  TRItem.Currency AS Currency,
  'MM ' AS SourceTypeDesc,
  TRItem.RU_RNPTPrimaryDocumentType AS RU_RNPTPrimaryDocumentType,
  TRItem.RU_RNPTPrimaryDocumentNumber AS RU_RNPTPrimaryDocumentNumber,
  TRItem.RU_RNPTPrimaryDocumentYear AS RU_RNPTPrimaryDocumentYear,
  TRItem.RU_RNPTPrimaryDocumentItem AS RU_RNPTPrimaryDocumentItem,
  TRItem.AccountingDocument AS FinanceInvoice,
  TRItem.FiscalYear AS FinanceInvoiceFiscalYear,
  TRItem.SupplierInvoice AS SupplierInvoice,
  TRItem.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  TRItem.SupplierInvoiceItem AS SupplierInvoiceItem
FROM I_RU_TraceabilityMovementDocs AS TRItem
INNER JOIN I_RU_TraceabilityRegnNumber AS TRReg ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_AcctgDocReferenceID AS AccDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntry AS AccDoc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_RU_TraceabilityMovementDocs
;

Learn More