P_RU_VATReportingRNPT2

DDL: P_RU_VATREPORTINGRNPT2 SQL: PRUVATREPRNPT2 Type: view CONSUMPTION

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

Data Sources (1)

SourceAliasJoin Type
P_RU_VATReportingRNPT1 P_RU_VATReportingRNPT1 from

Annotations (7)

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

Fields (21)

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
RU_RNPTPrimaryDocumentType RU_RNPTPrimaryDocumentType
RU_RNPTPrimaryDocumentNumber RU_RNPTPrimaryDocumentNumber
RU_RNPTPrimaryDocumentYear RU_RNPTPrimaryDocumentYear
RU_RNPTPrimaryDocumentItem RU_RNPTPrimaryDocumentItem
FinanceInvoice FinanceInvoice Journal Entry
FinanceInvoiceFiscalYear FinanceInvoiceFiscalYear G/L Fiscal Year
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_VATReportingRNPT2.
-- 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: PRUVATREPRNPT2

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