C_ProdSubstnCtrlTextTP

DDL: C_PRODSUBSTNCTRLTEXTTP Type: view_entity CONSUMPTION Package: ODATA_PROD_SUBSTN_CTRL
7 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Product Substitution Control Text

C_ProdSubstnCtrlTextTP is a Consumption CDS View that provides data about "Product Substitution Control Text" in SAP S/4HANA. It reads from 1 data source (R_ProdSubstnCtrlTextTP) and exposes 7 fields with key fields Language, MDSubstnObjectType, MDSubstnControl. It is exposed through 2 OData services (ASQL_F4787, UI_PRODSUBSTN_CTRL_MANAGE). It is used in 1 Fiori application: Manage Substitution Controls - Products. Part of development package ODATA_PROD_SUBSTN_CTRL.

Data Sources (1)

SourceAliasJoin Type
R_ProdSubstnCtrlTextTP R_ProdSubstnCtrlTextTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Product Substitution Control Text view
ObjectModel.representativeKey MDSubstnControl view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4787 ASQL_F4787 C2 NOT_RELEASED
UI_PRODSUBSTN_CTRL_MANAGE UI_PRODSUBSTN_CTRL_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4787 Manage Substitution Controls - Products Transactional An application to maintain configuration data for product substitution or exclusion where the user can manage substitution controls

Manage Substitution Controls - Products

Business Role: Master Data Specialist - Product Data

A control is used to consume one or more predefined groups of substitutions. With this app, you can create and manage controls. By assigning substitution groups to controls, consuming applications can manage substitution groups. You can assign only active and inactive groups to a control. A control can be deleted even if groups are assigned to it. You can use this app if the business role Master Data Specialist – Product Data (R0097-13) is assigned to you.

Key Features: You can use this app to: Create, edit, and delete a control. Create multiple language-specific descriptions for a control. Assign and unassign groups to controls.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY MDSubstnObjectType MDSubstnObjectType
KEY MDSubstnControl MDSubstnControl
MDSubstnControlDescription MDSubstnControlDescription
LanguageName
_Language _Language
_MDObjectType _MDObjectType

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_ProdSubstnCtrlTextTP.
-- 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_ProdSubstnCtrlTextTP AS
SELECT
  Language,
  MDSubstnObjectType,
  MDSubstnControl,
  MDSubstnControlDescription,
  _Language._Text[1: Language=$session.system_language].LanguageName AS LanguageName
FROM R_ProdSubstnCtrlTextTP
;

Learn More