P_RU_TraceabilityOperations

DDL: P_RU_TRACEABILITYOPERATIONS SQL: PRUTRCBLYOPS Type: view CONSUMPTION
32 Fields 1 Data Sources

Traceability Operations for analytics

P_RU_TraceabilityOperations is a Consumption CDS View that provides data about "Traceability Operations for analytics" in SAP S/4HANA. It reads from 1 data source (I_RU_TraceabilityOpsRptgItem) and exposes 32 fields with key fields RU_RNPTRegistrationNumber, RU_RNPTRegistrationYear, RU_RNPTRegistrationItem, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_RU_TraceabilityOpsRptgItem traceabilityOperations from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRUTRCBLYOPS view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Traceability Operations for analytics view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY RU_RNPTRegistrationNumber I_RU_TraceabilityOpsRptgItem RU_RNPTRegistrationNumber RNPT Internal Number
KEY RU_RNPTRegistrationYear I_RU_TraceabilityOpsRptgItem RU_RNPTRegistrationYear RNPT Year
KEY RU_RNPTRegistrationItem I_RU_TraceabilityOpsRptgItem RU_RNPTRegistrationItem RNPT Item
KEY CompanyCode I_RU_TraceabilityOpsRptgItem CompanyCode Receiver Company Code
RU_RNPTOperationDate I_RU_TraceabilityOpsRptgItem RU_RNPTOperationDate Operation Date
RU_RNPTOperationType I_RU_TraceabilityOpsRptgItem RU_RNPTOperationType Code of Operation
RU_RNPTLegalDocumentType I_RU_TraceabilityOpsRptgItem RU_RNPTLegalDocumentType External Doc. Type
RU_RNPTLegalDocumentNumber I_RU_TraceabilityOpsRptgItem RU_RNPTLegalDocumentNumber External Doc. Number
RU_RNPTLegalDocumentDate I_RU_TraceabilityOpsRptgItem RU_RNPTLegalDocumentDate External Doc. Date
BusinessPartnerName I_RU_TraceabilityOpsRptgItem BusinessPartnerName Extracted Customer Name
RU_PartnerOrganizationINN I_RU_TraceabilityOpsRptgItem RU_PartnerOrganizationINN BP INN
RU_PartnerOrganizationKPP I_RU_TraceabilityOpsRptgItem RU_PartnerOrganizationKPP BP KPP
LastName I_RU_TraceabilityOpsRptgItem LastName Last Name
FirstName I_RU_TraceabilityOpsRptgItem FirstName First Name
MiddleName I_RU_TraceabilityOpsRptgItem MiddleName Middle Name
RU_PartnerPersonINN I_RU_TraceabilityOpsRptgItem RU_PartnerPersonINN BP Pers. INN
RU_RNPTRegnExternalNumber I_RU_TraceabilityOpsRptgItem RU_RNPTRegnExternalNumber RNPT External No.
BaseUnitofMeasure I_RU_TraceabilityOpsRptgItem BaseUnitofMeasure Base Unit
Quantity I_RU_TraceabilityOpsRptgItem Quantity Value
Currency I_RU_TraceabilityOpsRptgItem Currency Valuation Crcy
TotalAmountInLocalCurrency I_RU_TraceabilityOpsRptgItem TotalAmountInLocalCurrency RNPT Item Amount
GoodsMovementType I_RU_TraceabilityOpsRptgItem GoodsMovementType Movement Type
AssetTransactionType I_RU_TraceabilityOpsRptgItem AssetTransactionType Trans.Type
TaxCode I_RU_TraceabilityOpsRptgItem TaxCode Tax Code
Product regNum Product Product Sold
MaterialName material MaterialName Material Description
Asset regNum Asset Asset
FixedAssetDescription asset FixedAssetDescription Description
RU_RNPTPrimaryDocumentNumber regMov RU_RNPTPrimaryDocumentNumber
RU_RNPTPrimaryDocumentYear regMov RU_RNPTPrimaryDocumentYear
RU_RNPTPrimaryDocumentItem regMov RU_RNPTPrimaryDocumentItem
RU_RNPTPrimaryDocumentType regMov RU_RNPTPrimaryDocumentType

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_TraceabilityOperations.
-- 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: PRUTRCBLYOPS
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_RU_TraceabilityOperations AS
SELECT
  traceabilityOperations.RU_RNPTRegistrationNumber AS RU_RNPTRegistrationNumber,
  traceabilityOperations.RU_RNPTRegistrationYear AS RU_RNPTRegistrationYear,
  traceabilityOperations.RU_RNPTRegistrationItem AS RU_RNPTRegistrationItem,
  traceabilityOperations.CompanyCode AS CompanyCode,
  traceabilityOperations.RU_RNPTOperationDate AS RU_RNPTOperationDate,
  traceabilityOperations.RU_RNPTOperationType AS RU_RNPTOperationType,
  traceabilityOperations.RU_RNPTLegalDocumentType AS RU_RNPTLegalDocumentType,
  traceabilityOperations.RU_RNPTLegalDocumentNumber AS RU_RNPTLegalDocumentNumber,
  traceabilityOperations.RU_RNPTLegalDocumentDate AS RU_RNPTLegalDocumentDate,
  traceabilityOperations.BusinessPartnerName AS BusinessPartnerName,
  traceabilityOperations.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  traceabilityOperations.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  traceabilityOperations.LastName AS LastName,
  traceabilityOperations.FirstName AS FirstName,
  traceabilityOperations.MiddleName AS MiddleName,
  traceabilityOperations.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  traceabilityOperations.RU_RNPTRegnExternalNumber AS RU_RNPTRegnExternalNumber,
  traceabilityOperations.BaseUnitofMeasure AS BaseUnitofMeasure,
  traceabilityOperations.Quantity AS Quantity,
  traceabilityOperations.Currency AS Currency,
  traceabilityOperations.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  traceabilityOperations.GoodsMovementType AS GoodsMovementType,
  traceabilityOperations.AssetTransactionType AS AssetTransactionType,
  traceabilityOperations.TaxCode AS TaxCode,
  regNum.Product AS Product,
  material.MaterialName AS MaterialName,
  regNum.Asset AS Asset,
  asset.FixedAssetDescription AS FixedAssetDescription,
  regMov.RU_RNPTPrimaryDocumentNumber AS RU_RNPTPrimaryDocumentNumber,
  regMov.RU_RNPTPrimaryDocumentYear AS RU_RNPTPrimaryDocumentYear,
  regMov.RU_RNPTPrimaryDocumentItem AS RU_RNPTPrimaryDocumentItem,
  regMov.RU_RNPTPrimaryDocumentType AS RU_RNPTPrimaryDocumentType
FROM I_RU_TraceabilityOpsRptgItem AS traceabilityOperations
;

Learn More