/SCMTMS/CV_ResourceText

DDL: /SCMTMS/CV_RESOURCETEXT SQL: /SCMTMS/CV_RESDC Type: view
3 Fields 1 Data Sources 1 Associations

BOPF: /SCMTMS/RESOURCE Node: Description

/SCMTMS/CV_ResourceText is a CDS View that provides data about "BOPF: /SCMTMS/RESOURCE Node: Description" in SAP S/4HANA. It reads from 1 data source (I_ResourceTransp) and exposes 3 fields with key fields TMSRESUID, LANGUAGE_CODE. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ResourceTransp ResourceTransp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ResourceTextBasic _ResourceTextBasic ResourceTransp.ResourceUUID = _ResourceTextBasic.ResourceUUID and _ResourceTextBasic.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName /SCMTMS/CV_RESDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
EndUserText.label BOPF: /SCMTMS/RESOURCE Node: Description view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY TMSRESUID I_ResourceTransp ResourceAdditionalUUID UUID
KEY LANGUAGE_CODE _ResourceTextBasic Language Report Text Language
DESCRIPTION _ResourceTextBasic ResourceName

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 /SCMTMS/CV_ResourceText.
-- 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: /SCMTMS/CV_RESDC

CREATE VIEW /SCMTMS/CV_ResourceText AS
SELECT
  ResourceTransp.ResourceAdditionalUUID AS TMSRESUID,
  _ResourceTextBasic.Language AS LANGUAGE_CODE,
  _ResourceTextBasic.ResourceName AS DESCRIPTION
FROM I_ResourceTransp AS ResourceTransp
LEFT OUTER JOIN I_ResourceTextBasic AS _ResourceTextBasic ON ResourceTransp.ResourceUUID = _ResourceTextBasic.ResourceUUID AND _ResourceTextBasic.Language = $session.system_language  -- association [0..1]
;

Learn More