I_TechnicalReportText

DDL: I_TECHNICALREPORTTEXT SQL: ITECHREPTEXT Type: view BASIC
5 Fields 1 Data Sources 2 Associations

Technical Report - Text

I_TechnicalReportText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

MaintenanceCatalogProfileText · Asset Management

I_TechnicalReportText is a Basic CDS View that provides data about "Technical Report - Text" in SAP S/4HANA. It reads from 1 data source (t352b_t) and exposes 5 fields with key fields CatalogProfile, Language. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Purpose
This CDS view helps you to get the description of a catalog profile. This CDS view provides the data to answer the following business questions: What is the description of the catalog profile? What is the description of a catalog profie in all languages? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Further Important Fields Important fields in this view include the following: Field Name Description CatalogProfile This parameter is used to provide a key for a catalog profile. Language This parameter is used to indicate the language in which the description of the catalog profile should be shown. CatalogProfileText This parameter is used to indicate the description of the catalog profile.

SAP Business Warehouse (SAP BW) Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Corresponding DataSource (Extractor) ITECHREPTEXT Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC-MN
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageAsset Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view helps you to get the description of a catalog profile.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the description of the catalog profile?</p></li> <li><p>What is the description of a catalog profie in all languages?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t352b_t t352b_t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_TechnicalReport _TechnicalReport $projection.CatalogProfile = _TechnicalReport.CatalogProfile

Annotations (16)

NameValueLevelField
EndUserText.label Technical Report - Text view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CatalogProfile view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ITECHREPTEXT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.sapObjectNodeType.name MaintenanceCatalogProfileText view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CatalogProfile t352b_t rbnr Catalog Profile
KEY Language t352b_t spras Off. Language
CatalogProfileText t352b_t rbnrx Catalog Profile Description
_Language _Language
_TechnicalReport _TechnicalReport

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_TechnicalReportText.
-- 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: ITECHREPTEXT

CREATE VIEW I_TechnicalReportText AS
SELECT
  t352b_t.rbnr AS CatalogProfile,
  t352b_t.spras AS Language,
  t352b_t.rbnrx AS CatalogProfileText
FROM t352b_t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_TechnicalReport AS _TechnicalReport ON CatalogProfile = _TechnicalReport.CatalogProfile  -- association [0..1]
;

Learn More