C_ProdSubstnCtrlUnassgdGrp

DDL: C_PRODSUBSTNCTRLUNASSGDGRP Type: view_entity CONSUMPTION

Product Substitution Unassigned Group

C_ProdSubstnCtrlUnassgdGrp is a Consumption CDS View that provides data about "Product Substitution Unassigned Group" in SAP S/4HANA. It reads from 1 data source (I_MDSubstnCtrlUnassgdGrp) and exposes 12 fields with key fields MDSubstnObjectType, MDSubstnControl, MDSubstnGroup, MDSubstnVersionValue. It is exposed through 1 OData service (UI_PRODSUBSTN_CTRL_MANAGE). It is used in 1 Fiori application: Manage Substitution Controls - Products.

1 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MDSubstnCtrlUnassgdGrp I_MDSubstnCtrlUnassgdGrp from

Parameters (2)

NameTypeDefault
P_MDSubstnObjectType sbo_bo_type
P_MDSubstnControl md_substn_control

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
EndUserText.label Product Substitution Unassigned Group view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
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 (12)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnObjectType MDSubstnObjectType
KEY MDSubstnControl MDSubstnControl
KEY MDSubstnGroup MDSubstnGroup
KEY MDSubstnVersionValue MDSubstnVersionValue
MDSubstnGroupDescription MDSubstnGroupDescription
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
MDSubstnStatus MDSubstnStatus
MDSubstnStatusCriticality MDSubstnStatusCriticality
MDSubstnStatusDescription MDSubstnStatusDescription 
@AccessControl: {
 authorizationCheck: #CHECK
}
@Metadata.allowExtensions: true
@EndUserText.label: 'Product Substitution Unassigned Group'
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #S
  }
}
@Search.searchable: true
@VDM: {
  viewType: #CONSUMPTION
}
define view entity C_ProdSubstnCtrlUnassgdGrp
  with parameters
    P_MDSubstnObjectType : sbo_bo_type,
    P_MDSubstnControl    : md_substn_control
  as select from I_MDSubstnCtrlUnassgdGrp( P_MDSubstnObjectType : $parameters.P_MDSubstnObjectType, P_MDSubstnControl : $parameters.P_MDSubstnControl )
{
  key MDSubstnObjectType,
     
  key MDSubstnControl,

      @Search: {
            defaultSearchElement: true,
            fuzzinessThreshold: 0.8,
            ranking: #HIGH
          }
  key MDSubstnGroup,

  key MDSubstnVersionValue,

      @Search: {
            defaultSearchElement: true,
            fuzzinessThreshold: 0.8,
            ranking: #HIGH
          }
      MDSubstnGroupDescription,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      CreatedByUser,

      CreationDateTime,
      LastChangeDateTime,

      @Search: {
      defaultSearchElement: true,
      fuzzinessThreshold: 0.8,
      ranking: #HIGH
      }
      LastChangedByUser,

      MDSubstnStatus,
      MDSubstnStatusCriticality,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      MDSubstnStatusDescription
}
where
      MDSubstnObjectType = $parameters.P_MDSubstnObjectType
  and MDSubstnControl    = $parameters.P_MDSubstnControl

Learn More