C_QltyControlChartTrackValue

DDL: C_QLTYCONTROLCHARTTRACKVALUE SQL: CQLTYCNTRLCHTRKV Type: view CONSUMPTION

Control Chart Track Values

C_QltyControlChartTrackValue is a Consumption CDS View that provides data about "Control Chart Track Values" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetCharacteristic) and exposes 20 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetCharacteristic I_InspSubsetCharacteristic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_QualityControlChartTrack _ControlChartTrack $projection.QualityControlChart = _ControlChartTrack.QualityControlChart and $projection.QualityControlChartTrack = _ControlChartTrack.QualityControlChartTrack

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYCNTRLCHTRKV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Control Chart Track Values view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY InspectionSubsetInternalID InspectionSubsetInternalID
QualityControlChart QualityControlChart
QualityControlChartTrack
ControlChartValueObject
ControlChartValue
ControlChartValueHasValue
ControlChartValueText
InspectionSpecificationText _InspectionCharacteristic InspectionSpecificationText
Plant _InspectionLot Plant
WorkCenter
InspectionLotType _InspectionLot InspectionLotType
InspectionSubsetType _InspectionLot InspectionSubsetType
MatlQualityAuthorizationGroup _InspectionLot MatlQualityAuthorizationGroup
_InspectionSubsetType _InspectionLot _InspectionSubsetType
_ControlChartTrack _ControlChartTrack
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation 
@AbapCatalog.sqlViewName: 'CQLTYCNTRLCHTRKV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
@EndUserText.label: 'Control Chart Track Values'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE


define view C_QltyControlChartTrackValue
  as select from I_InspSubsetCharacteristic
  association [1..1] to C_QualityControlChartTrack as _ControlChartTrack on  $projection.QualityControlChart      = _ControlChartTrack.QualityControlChart
                                                                         and $projection.QualityControlChartTrack = _ControlChartTrack.QualityControlChartTrack
{
  key InspectionLot,
  key InspPlanOperationInternalID,
  key InspectionCharacteristic,
  key InspectionSubsetInternalID,
      QualityControlChart,
      '1'                                                                            as QualityControlChartTrack,
      cast('                    ' as qqrkobject preserving type )                    as ControlChartValueObject,
      cast('0' as abap.dec(16,2))                                                          as ControlChartValue,
      ''                                                                             as ControlChartValueHasValue,
      cast('                                        ' as qkurztext preserving type)  as ControlChartValueText,


      _InspectionCharacteristic.InspectionSpecificationText,
      //Fields for Auth - Start

      @UI.hidden: true
      _InspectionLot.Plant,
      @UI.hidden: true
      _InspectionOperation._WorkCenter.WorkCenter,
      @UI.hidden: true
      _InspectionLot.InspectionLotType,
      @UI.hidden: true
      _InspectionLot.InspectionSubsetType,
      @UI.hidden: true
      _InspectionLot.MatlQualityAuthorizationGroup,
      @UI.hidden: true
      _InspectionLot._InspectionSubsetType,
      //Fields for Auth - End


      //Associations

      _ControlChartTrack,
      _InspectionLot,
      _InspectionOperation
}

Learn More