P_RU_TraceabilityDocsInfo

DDL: P_RU_TRACEABILITYDOCSINFO SQL: PRUTRCBLYDOCS Type: view CONSUMPTION
22 Fields 2 Data Sources

Data from traceability databases

P_RU_TraceabilityDocsInfo is a Consumption CDS View that provides data about "Data from traceability databases" in SAP S/4HANA. It reads from 2 data sources (I_RU_TraceabilityMovementDocs, I_RU_TraceabilityRegnNumber) and exposes 22 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem, CompanyCode.

Data Sources (2)

SourceAliasJoin Type
I_RU_TraceabilityMovementDocs rnptDoc inner
I_RU_TraceabilityRegnNumber rnptReg from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUTRCBLYDOCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Data from traceability databases view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber I_RU_TraceabilityRegnNumber 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
KEY CompanyCode I_RU_TraceabilityRegnNumber CompanyCode Receiver Company Code
RU_RNPTRegnExternalNumber I_RU_TraceabilityRegnNumber RU_RNPTRegnExternalNumber RNPT External No.
RU_RNPTSourceOperationType I_RU_TraceabilityRegnNumber RU_RNPTSourceOperationType Source Oper. Type
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
RU_RNPTPrimaryDocumentItemFI
RU_RNPTPrimaryDocumentItemMM
SupplierInvoice I_RU_TraceabilityMovementDocs SupplierInvoice Inv. Doc. No.
SupplierInvoiceFiscalYear I_RU_TraceabilityMovementDocs SupplierInvoiceFiscalYear Fiscal Year
SupplierInvoiceItem I_RU_TraceabilityMovementDocs SupplierInvoiceItem Item
AccountingDocument I_RU_TraceabilityMovementDocs AccountingDocument Journal Entry
FiscalYear I_RU_TraceabilityMovementDocs 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
RU_RNPTOperationDate I_RU_TraceabilityMovementDocs RU_RNPTOperationDate Operation Date

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_TraceabilityDocsInfo.
-- 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: PRUTRCBLYDOCS

CREATE VIEW P_RU_TraceabilityDocsInfo AS
SELECT
  rnptReg.RU_RNPTRegistrationNumber AS RU_RNPTRegistrationNumber,
  rnptDoc.RU_RNPTRegistrationYear AS RU_RNPTRegistrationYear,
  rnptDoc.RU_RNPTRegistrationItem AS RU_RNPTRegistrationItem,
  rnptReg.CompanyCode AS CompanyCode,
  rnptReg.RU_RNPTRegnExternalNumber AS RU_RNPTRegnExternalNumber,
  rnptReg.RU_RNPTSourceOperationType AS RU_RNPTSourceOperationType,
  rnptDoc.RU_RNPTPrimaryDocumentType AS RU_RNPTPrimaryDocumentType,
  rnptDoc.RU_RNPTPrimaryDocumentNumber AS RU_RNPTPrimaryDocumentNumber,
  rnptDoc.RU_RNPTPrimaryDocumentYear AS RU_RNPTPrimaryDocumentYear,
  rnptDoc.RU_RNPTPrimaryDocumentItem AS RU_RNPTPrimaryDocumentItem,
  right( rnptDoc.RU_RNPTPrimaryDocumentItem, 3) AS RU_RNPTPrimaryDocumentItemFI,
  right( rnptDoc.RU_RNPTPrimaryDocumentItem, 4) AS RU_RNPTPrimaryDocumentItemMM,
  rnptDoc.SupplierInvoice AS SupplierInvoice,
  rnptDoc.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  rnptDoc.SupplierInvoiceItem AS SupplierInvoiceItem,
  rnptDoc.AccountingDocument AS AccountingDocument,
  rnptDoc.FiscalYear AS FiscalYear,
  rnptDoc.Quantity AS Quantity,
  rnptReg.BaseUnitofMeasure AS BaseUnitofMeasure,
  rnptDoc.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  rnptDoc.Currency AS Currency,
  rnptDoc.RU_RNPTOperationDate AS RU_RNPTOperationDate
FROM I_RU_TraceabilityRegnNumber AS rnptReg
INNER JOIN I_RU_TraceabilityMovementDocs AS rnptDoc ON /* join condition not captured in parsed metadata */
;

Learn More