C_RawChmlCmplncApplication

DDL: C_RAWCHMLCMPLNCAPPLICATION Type: view CONSUMPTION

Chemical Compliance Application

C_RawChmlCmplncApplication is a Consumption CDS View that provides data about "Chemical Compliance Application" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncApplAssgmt) and exposes 4 fields with key fields ChmlCmplncApplication, CompChmlCmplncInfoUUID. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncApplAssgmt Application inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ApplicationText _ApplicationText _ApplicationText.ChmlCmplncApplication = Application.ChmlCmplncApplication --
[1..1] C_RawChmlCmplncInfoTP _RawChmlCmplncInfo _RawChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.CompChmlCmplncInfoUUID

Annotations (10)

NameValueLevelField
EndUserText.label Chemical Compliance Application view
AbapCatalog.sqlViewName CCCRAPPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncApplication I_ChmlCmplncApplAssgmt ChmlCmplncApplication
KEY CompChmlCmplncInfoUUID Component CompChmlCmplncInfoUUID
ChmlCmplncApplicationName
_RawChmlCmplncInfo _RawChmlCmplncInfo 
@EndUserText.label: 'Chemical Compliance Application'

@AbapCatalog:
{
  sqlViewName: 'CCCRAPPL',
  compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #CHECK
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata: {
  allowExtensions: true
}

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  semanticKey:  [ 'ChmlCmplncApplication' ],
  usageType:
  {
    /*Service Quality - reflects the quality of service with respect to the expected performance of the CDS view:
      #A: may be consumed within business logic for high volume transactions or background processing
      #B: may be consumed within business logic for transactions or background processing
    */
    dataClass: #MIXED,
    sizeCategory: #S,
    serviceQuality: #C
  }
}

--Header information
  /*define data for the header*/
@UI:
{
  headerInfo:
  {
    typeName: 'Applications',
    typeNamePlural: 'Applications',
    title:
    {
      label: 'Application',
      value: 'ChmlCmplncApplication'
    }
  },
  presentationVariant:
  {
    sortOrder:
    {
      by: 'ChmlCmplncApplicationName',
      direction: #ASC
    }
  }
}

@Search.searchable: true

define view C_RawChmlCmplncApplication
  as select distinct from I_MatlBasedCmpstnComponent as Component
    inner join I_ChmlCmplncApplAssgmt as Application on Application.ChmlCmplncInfoUUID = Component.ChmlCmplncInfoUUID

  association [0..*] to I_ApplicationText     as _ApplicationText   on _ApplicationText.ChmlCmplncApplication = Application.ChmlCmplncApplication

  -- Association to C_RawChmlCmplncInfo needed for DCL
  association [1..1] to C_RawChmlCmplncInfoTP as _RawChmlCmplncInfo on _RawChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.CompChmlCmplncInfoUUID

{

      @ObjectModel.readOnly: true
      key Application.ChmlCmplncApplication          as ChmlCmplncApplication,

      @ObjectModel.readOnly: true
      // UUID of RM

      key Component.CompChmlCmplncInfoUUID           as CompChmlCmplncInfoUUID,

      _ApplicationText[ 1:Language = $session.system_language ].ChmlCmplncApplicationName as ChmlCmplncApplicationName,

      _RawChmlCmplncInfo
}
where
  Component._Composition.ChmlCompositionStatus = 'RE'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_APPLICATIONTEXT",
"I_CHMLCMPLNCAPPLASSGMT",
"I_CHMLCOMPOSITION",
"I_MATLBASEDCMPSTNCOMPONENT"
],
"ASSOCIATED":
[
"C_RAWCHMLCMPLNCINFOTP",
"I_APPLICATIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More