P_RU_VATReportingRNPT

DDL: P_RU_VATREPORTINGRNPT SQL: PRUVATREPRNPT Type: view CONSUMPTION

P_RU_VATReportingRNPT is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_VATReportingRNPT2) and exposes 22 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem.

Data Sources (1)

SourceAliasJoin Type
P_RU_VATReportingRNPT2 P_RU_VATReportingRNPT2 from

Annotations (7)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber RU_RNPTRegistrationNumber
KEY RU_RNPTRegistrationYear RU_RNPTRegistrationYear
KEY RU_RNPTRegistrationItem RU_RNPTRegistrationItem
RU_RNPTRegnExternalNumber RU_RNPTRegnExternalNumber
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
Quantity Quantity Value
BaseUnitofMeasure BaseUnitofMeasure Base Unit
TotalAmountInLocalCurrency TotalAmountInLocalCurrency RNPT Item Amount
Currency Currency Valuation Crcy
SourceTypeDesc SourceTypeDesc
DataToSave DataToSave
RU_RNPTPrimaryDocumentType RU_RNPTPrimaryDocumentType
RU_RNPTPrimaryDocumentNumber RU_RNPTPrimaryDocumentNumber
RU_RNPTPrimaryDocumentYear RU_RNPTPrimaryDocumentYear
RU_RNPTPrimaryDocumentItem RU_RNPTPrimaryDocumentItem
FinanceInvoice FinanceInvoice
FinanceInvoiceFiscalYear FinanceInvoiceFiscalYear
SupplierInvoice SupplierInvoice
SupplierInvoiceFiscalYear SupplierInvoiceFiscalYear
SupplierInvoiceItem SupplierInvoiceItem

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_VATReportingRNPT.
-- 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: PRUVATREPRNPT

CREATE VIEW P_RU_VATReportingRNPT AS
SELECT
  RU_RNPTRegistrationNumber,
  RU_RNPTRegistrationYear,
  RU_RNPTRegistrationItem,
  RU_RNPTRegnExternalNumber,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  Quantity,
  BaseUnitofMeasure,
  TotalAmountInLocalCurrency,
  Currency,
  SourceTypeDesc,
  DataToSave,
  RU_RNPTPrimaryDocumentType,
  RU_RNPTPrimaryDocumentNumber,
  RU_RNPTPrimaryDocumentYear,
  RU_RNPTPrimaryDocumentItem,
  FinanceInvoice,
  FinanceInvoiceFiscalYear,
  SupplierInvoice,
  SupplierInvoiceFiscalYear,
  SupplierInvoiceItem
FROM P_RU_VATReportingRNPT2
;