/SCMTMS/CV_EquipResourceText

DDL: /SCMTMS/CV_EQUIPRESOURCETEXT SQL: /SCMTMS/CV_RSEQT Type: view
5 Fields 2 Data Sources 2 Associations

BOPF: /SCMTMS/RESOURCE Node: Description

/SCMTMS/CV_EquipResourceText is a CDS View that provides data about "BOPF: /SCMTMS/RESOURCE Node: Description" in SAP S/4HANA. It reads from 2 data sources (I_EquipmentType, I_ResourceTransp) and exposes 5 fields with key fields TMSRESUID, Language_code, Language_code. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_EquipmentType EquipmentType union
I_ResourceTransp ResourceTransp from

Associations (2)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName /SCMTMS/CV_RSEQT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label BOPF: /SCMTMS/RESOURCE Node: Description view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TMSRESUID I_ResourceTransp ResourceAdditionalUUID UUID
KEY Language_code _ResourceTextBasic Language Report Text Language
ResourceAdditionalUUIDasTMSRESUID
KEY Language_code _EquipmentTypeText Language Report Text Language
Description _EquipmentTypeText EquipmentTypeDesc

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_EquipResourceText.
-- 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_RSEQT

CREATE VIEW /SCMTMS/CV_EquipResourceText AS
SELECT
  ResourceTransp.ResourceAdditionalUUID AS TMSRESUID,
  _ResourceTextBasic.Language AS Language_code,
  _ResourceTextBasic.ResourceName as Description AS ResourceAdditionalUUIDasTMSRESUID,
  _EquipmentTypeText.EquipmentTypeDesc 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]
LEFT OUTER JOIN I_EquipmentTypeText AS _EquipmentTypeText ON EquipmentType.EquipmentGroup = _EquipmentTypeText.EquipmentGroup AND EquipmentType.EquipmentType = _EquipmentTypeText.EquipmentType AND _EquipmentTypeText.Language = $session.system_language  -- association [0..1]
-- UNION with additional select branch(es): I_EquipmentType
;

Learn More