C_ProdnHoldRelReasonCodeVH

DDL: C_PRODNHOLDRELREASONCODEVH SQL: CPHRRCVH Type: view CONSUMPTION

Release Reason Code Value Help

C_ProdnHoldRelReasonCodeVH is a Consumption CDS View that provides data about "Release Reason Code Value Help" in SAP S/4HANA. It reads from 1 data source (I_MfgActionReasonCode) and exposes 7 fields with key fields MfgActionReasonCodeGroupCtlg, MfgActionReasonCodeGroup, ManufacturingActionReasonCode, Version.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgActionReasonCode code from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPHRRCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ManufacturingActionReasonCode view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #CONSUMPTION view
EndUserText.label Release Reason Code Value Help view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg
KEY MfgActionReasonCodeGroup I_MfgActionReasonCode MfgActionReasonCodeGroup
KEY ManufacturingActionReasonCode I_MfgActionReasonCode ManufacturingActionReasonCode
KEY Version I_MfgActionReasonCode Version
MfgActionReasonCodeName
_Catalog _Catalog
_Group _Group 
@AbapCatalog.sqlViewName: 'CPHRRCVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:
{
  representativeKey: 'ManufacturingActionReasonCode',
  usageType:
              {
                serviceQuality: #B,
                sizeCategory:   #S,
                dataClass:      #CUSTOMIZING
              }
--  ,resultSet.sizeCategory: #XS
}
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Release Reason Code Value Help'
@Search.searchable: true
define view C_ProdnHoldRelReasonCodeVH
  as select from I_MfgActionReasonCode as code
{

      // key fields

      @UI.hidden: true
  key code.MfgActionReasonCodeGroupCtlg                                   as  MfgActionReasonCodeGroupCtlg,
      @UI.hidden: true
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgActnRsnCodeGrpStdVH', element: 'MfgActionReasonCodeGroup' } } ]
  key code.MfgActionReasonCodeGroup                                       as  MfgActionReasonCodeGroup,
      @Search:{defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key code.ManufacturingActionReasonCode                                  as  ManufacturingActionReasonCode,
      @UI.hidden: true
  key code.Version                                                        as  Version,
      
      @Search:{defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      _Text[1: Language=$session.system_language].MfgActionReasonCodeName as  MfgActionReasonCodeName,
      
      // associations

      @Consumption.filter.hidden: true
      _Catalog,
      @Consumption.filter.hidden: true
      _Group

}
where
      MfgActionReasonCodeGroupCtlg = '7'
  and Version                      = '000001'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGACTIONREASONCODE",
"I_MFGACTIONREASONCODETEXT"
],
"ASSOCIATED":
[
"I_INSPECTIONCATALOG",
"I_MFGACTIONREASONCODEGROUP"
],
"BASE":
[
"I_MFGACTIONREASONCODE"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More