P_ChmlCmplncBulkNavgnLink

DDL: P_CHMLCMPLNCBULKNAVGNLINK Type: view CONSUMPTION

Chemical Compliance Navigation Link to Bulk

P_ChmlCmplncBulkNavgnLink is a Consumption CDS View that provides data about "Chemical Compliance Navigation Link to Bulk" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 1 field. It has 1 association to related views.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo I_ChmlCmplncInfo from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncProdAssgmt _BulkAssignment $projection.ChmlCmplncInfoUUID = _BulkAssignment.ChmlCmplncInfoUUID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCNAVBLINK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Chemical Compliance Navigation Link to Bulk view

Fields (1)

KeyFieldSource TableSource FieldDescription
UUIDofCCIkeyChmlCmplncInfoUUID 
@AbapCatalog:
{
  sqlViewName: 'PCCNAVBLINK',
  compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog.preserveKey: true

@VDM.viewType: #CONSUMPTION
@VDM: {
    private: true
}

@EndUserText.label: 'Chemical Compliance Navigation Link to Bulk'
define view P_ChmlCmplncBulkNavgnLink 

  // read CCI

  as select from I_ChmlCmplncInfo
  
  // association to bulk 

  association [0..1] to I_ChmlCmplncProdAssgmt  as _BulkAssignment   on  $projection.ChmlCmplncInfoUUID = _BulkAssignment.ChmlCmplncInfoUUID  
{

  
      --UUID of CCI
  key ChmlCmplncInfoUUID,

      -- Navigation link to bulk 
      case
        when _BulkAssignment.ChmlCmplncProdUUID is not null
          then _BulkAssignment.ChmlCmplncProdUUID
        else
          I_ChmlCmplncInfo.ChmlCmplncInfoUUID
      end                                                          as  ChmlCmplncInfoNavgnLink
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCPRODASSGMT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCPRODASSGMT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More