P_RU_TraceabilityOpsDocs

DDL: P_RU_TRACEABILITYOPSDOCS SQL: PRUTRCBLYOPDOCS Type: view CONSUMPTION
22 Fields 1 Data Sources

Traceability operations primary documents

P_RU_TraceabilityOpsDocs is a Consumption CDS View that provides data about "Traceability operations primary documents" in SAP S/4HANA. It reads from 1 data source (P_RU_TraceabilityDocsInfo) and exposes 22 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_RU_TraceabilityDocsInfo rnptDoc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUTRCBLYOPDOCS 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 Traceability operations primary documents view

Fields (22)

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

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_TraceabilityOpsDocs.
-- 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: PRUTRCBLYOPDOCS

CREATE VIEW P_RU_TraceabilityOpsDocs AS
SELECT
  rnptDoc.RU_RNPTRegistrationNumber AS RU_RNPTRegistrationNumber,
  rnptDoc.RU_RNPTRegistrationYear AS RU_RNPTRegistrationYear,
  rnptDoc.RU_RNPTRegistrationItem AS RU_RNPTRegistrationItem,
  rnptDoc.CompanyCode AS CompanyCode,
  rnptDoc.RU_RNPTRegnExternalNumber AS RU_RNPTRegnExternalNumber,
  rnptDoc.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,
  rnptDoc.SupplierInvoice AS SupplierInvoice,
  rnptDoc.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  rnptDoc.SupplierInvoiceItem AS SupplierInvoiceItem,
  concat( rnptDoc.SupplierInvoice, rnptDoc.SupplierInvoiceFiscalYear ) AS SupplierInvoiceFullKey,
  rnptDoc.AccountingDocument AS AccountingDocument,
  rnptDoc.FiscalYear AS FiscalYear,
  rnptDoc.Quantity AS Quantity,
  rnptDoc.BaseUnitofMeasure AS BaseUnitofMeasure,
  rnptDoc.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  rnptDoc.Currency AS Currency,
  rnptDoc.RU_RNPTOperationDate AS RU_RNPTOperationDate,
  coalesce( AccDocItem.AssetTransactionType, '' ) AS AssetTransactionType
FROM P_RU_TraceabilityDocsInfo AS rnptDoc
;

Learn More