C_SubstanceTechNameTextTP

DDL: C_SUBSTANCETECHNAMETEXTTP Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Consumption View for Subst Tech Name Txt

C_SubstanceTechNameTextTP is a Consumption CDS View that provides data about "Consumption View for Subst Tech Name Txt" in SAP S/4HANA. It reads from 1 data source (R_SubstanceTechNameTextTP) and exposes 10 fields with key fields SubstanceTechNameUUID, Language. It is exposed through 1 OData service (EHDGM_UI_SUBSTANCETECHNAME). It is used in 1 Fiori application: Manage Technical Names for Substance.

Data Sources (1)

SourceAliasJoin Type
R_SubstanceTechNameTextTP R_SubstanceTechNameTextTP projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consumption View for Subst Tech Name Txt view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey Language view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
UI.headerInfo.typeName Technical Name view
UI.headerInfo.typeNamePlural Technical Names view
UI.headerInfo.title.label Technical Names for Dangerous Goods view
UI.headerInfo.title.value SubstanceTechNameText view

OData Services (1)

ServiceBindingVersionContractRelease
EHDGM_UI_SUBSTANCETECHNAME EHDGM_UI_SUBSTANCETECHNAME V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5261 Manage Technical Names for Substance Transactional An Application to manage Technical Names for substnaces that have to be shown in the Dangerous Goods Description of product classified as a Dangerous Good

Manage Technical Names for Substance

Business Role: Dangerous Goods Specialist - Product Compliance

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SubstanceTechNameUUID SubstanceTechNameUUID Technical Name UUID
KEY Language Language Report Text Language
LanguageForEdit LanguageForEdit Original Language
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
SubstanceTechNameText SubstanceTechNameText Technical Name
_Language _Language
_LanguageForEdit _LanguageForEdit

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 C_SubstanceTechNameTextTP.
-- 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.

CREATE VIEW C_SubstanceTechNameTextTP AS
SELECT
  SubstanceTechNameUUID,
  Language,
  LanguageForEdit,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  SubstanceTechNameText
FROM R_SubstanceTechNameTextTP
;

Learn More