I_RU_TraceabilityRegnNumber

DDL: I_RU_TRACEABILITYREGNNUMBER SQL: IRUTRCBLYREGN Type: view BASIC
9 Fields 1 Data Sources

Traceability RN registration entry

I_RU_TraceabilityRegnNumber is a Basic CDS View that provides data about "Traceability RN registration entry" in SAP S/4HANA. It reads from 1 data source (j_3rm_rn_reg) and exposes 9 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear.

Data Sources (1)

SourceAliasJoin Type
j_3rm_rn_reg j_3rm_rn_reg from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUTRCBLYREGN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Traceability RN registration entry view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber rn_reg_id RNPT Internal Number
KEY RU_RNPTRegistrationYear rn_reg_year RNPT Year
RU_RNPTRegnExternalNumber rn_ext_num RNPT External No.
RU_RNPTSourceOperationType src_oper_type Source Oper. Type
CompanyCode company_code Company Code
BaseUnitofMeasure meins Valuation Unit
Product matnr Vehicle Model
Asset asset_num Asset
AssetSubNumber asset_subnum Sub-number

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_TraceabilityRegnNumber.
-- 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: IRUTRCBLYREGN

CREATE VIEW I_RU_TraceabilityRegnNumber AS
SELECT
  rn_reg_id AS RU_RNPTRegistrationNumber,
  rn_reg_year AS RU_RNPTRegistrationYear,
  rn_ext_num AS RU_RNPTRegnExternalNumber,
  src_oper_type AS RU_RNPTSourceOperationType,
  company_code AS CompanyCode,
  meins AS BaseUnitofMeasure,
  matnr AS Product,
  asset_num AS Asset,
  asset_subnum AS AssetSubNumber
FROM j_3rm_rn_reg
;

Learn More