I_RU_TraceabilityMovementDocs

DDL: I_RU_TRACEABILITYMOVEMENTDOCS SQL: IRUTRCBLYMVTD Type: view BASIC Package: GLO_FIN_IS_RU_TRACEABILITY
17 Fields 1 Data Sources

Traceability RN Movement Documents

I_RU_TraceabilityMovementDocs is a Basic CDS View that provides data about "Traceability RN Movement Documents" in SAP S/4HANA. It reads from 1 data source (j_3rm_rn_doc) and exposes 17 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem. Part of development package GLO_FIN_IS_RU_TRACEABILITY.

Data Sources (1)

SourceAliasJoin Type
j_3rm_rn_doc j_3rm_rn_doc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUTRCBLYMVTD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Traceability RN Movement Documents view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber rn_reg_id RNPT Internal Number
KEY RU_RNPTRegistrationYear rn_reg_year RNPT Year
KEY RU_RNPTRegistrationItem rn_reg_movmnt RNPT Item
RU_RNPTPrimaryDocumentType prim_doc_type Assig. Doc. Type
RU_RNPTPrimaryDocumentNumber prim_doc_num RNPT Assigned Doc
RU_RNPTPrimaryDocumentYear prim_doc_year RNPT Assign.Doc Year
RU_RNPTPrimaryDocumentItem prim_doc_pos RNPT Assign.Doc Item
SupplierInvoice mm_invoice_num Inv. Doc. No.
SupplierInvoiceFiscalYear mm_invoice_year Fiscal Year
SupplierInvoiceItem mm_invoice_pos Item
AccountingDocument fi_invoice_num Document Number
FiscalYear fi_invoice_year Fiscal Year
Quantity menge WarrCountValue
TotalAmountInLocalCurrency amount Value Amount
Currency currency Valuation Crcy
RU_RNPTOperationDate operation_date Operation Date
RU_RNPTRegnItemCancelledByItem cancelled_by Cancelled by

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 I_RU_TraceabilityMovementDocs.
-- 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: IRUTRCBLYMVTD

CREATE VIEW I_RU_TraceabilityMovementDocs AS
SELECT
  rn_reg_id AS RU_RNPTRegistrationNumber,
  rn_reg_year AS RU_RNPTRegistrationYear,
  rn_reg_movmnt AS RU_RNPTRegistrationItem,
  prim_doc_type AS RU_RNPTPrimaryDocumentType,
  prim_doc_num AS RU_RNPTPrimaryDocumentNumber,
  prim_doc_year AS RU_RNPTPrimaryDocumentYear,
  prim_doc_pos AS RU_RNPTPrimaryDocumentItem,
  mm_invoice_num AS SupplierInvoice,
  mm_invoice_year AS SupplierInvoiceFiscalYear,
  mm_invoice_pos AS SupplierInvoiceItem,
  fi_invoice_num AS AccountingDocument,
  fi_invoice_year AS FiscalYear,
  menge AS Quantity,
  amount AS TotalAmountInLocalCurrency,
  Currency,
  operation_date AS RU_RNPTOperationDate,
  cancelled_by AS RU_RNPTRegnItemCancelledByItem
FROM j_3rm_rn_doc
;

Learn More