C_SamplingDefinitionRoot

DDL: C_SAMPLINGDEFINITIONROOT SQL: CSAMPLROOT Type: view CONSUMPTION

Sampling

C_SamplingDefinitionRoot is a Consumption CDS View that provides data about "Sampling" in SAP S/4HANA. It reads from 2 data sources (I_SamplingReference, I_SamplingDefinitionRoot) and exposes 8 fields with key field SamplingUUID.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_SamplingReference _SamplingReference inner
I_SamplingDefinitionRoot I_SamplingDefinitionRoot from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSAMPLROOT view
VDM.viewType #CONSUMPTION view
EndUserText.label Sampling view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Sampling view
UI.headerInfo.typeNamePlural Samplings view
UI.headerInfo.title.value SamplingUUID view
AbapCatalog.compiler.compareFilter true view
Consumption.semanticObject EnvironmentalData view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SamplingUUID I_SamplingReference SamplingUUID
SamplingChemicalProperty _SamplingHeader SamplingChemicalProperty
SamplingAnalyteType _SamplingHeader SamplingAnalyteType
SamplingAnalyteUUID _SamplingHeader SamplingAnalyteUUID
SamplingDefinitionName SamplingDefinitionName
SamplingHeaderUUID _SamplingHeader SamplingHeaderUUID
EHSLocationUUID EHSLocationUUID
_EHSLocation _EHSLocation 
@AbapCatalog.sqlViewName: 'CSAMPLROOT'
@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Sampling'

@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:{ serviceQuality: #D,        // < 100 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MIXED }

@UI: {
  headerInfo: {
    typeName: 'Sampling',
    typeNamePlural: 'Samplings',
    title: {
      value: 'SamplingUUID'
    }
  }
}


@AbapCatalog.compiler.compareFilter: true
@Consumption.semanticObject: 'EnvironmentalData'


define view C_SamplingDefinitionRoot
  as select from I_SamplingDefinitionRoot
    inner join I_SamplingReference as _SamplingReference 
      on I_SamplingDefinitionRoot.SamplingDefinitionUUID = _SamplingReference.SamplingDefinitionUUID
{
      @UI.hidden: true
  key _SamplingReference.SamplingUUID,

      @UI.hidden: true
      _SamplingHeader.SamplingChemicalProperty,
      
      @UI.hidden: true
      _SamplingHeader.SamplingAnalyteType,
      
      @UI.hidden: true
      _SamplingHeader.SamplingAnalyteUUID,

      @UI.hidden: true
      SamplingDefinitionName,

      @UI.hidden: true
      _SamplingHeader.SamplingHeaderUUID,

      @UI.hidden: true
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_EHSLocationValueHelp', element: 'EHSLocationUUID' }}]
      EHSLocationUUID,

      _EHSLocation

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAMPLINGDEFINITIONROOT",
"I_SAMPLINGHEADER",
"I_SAMPLINGREFERENCE"
],
"ASSOCIATED":
[
"I_EHSLOCATIONREVISION"
],
"BASE":
[
"I_SAMPLINGDEFINITIONROOT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More