C_SubstanceVarAssgmtQryTP

DDL: C_SUBSTANCEVARASSGMTQRYTP Type: view CONSUMPTION

Substance Variant Assignment

C_SubstanceVarAssgmtQryTP is a Consumption CDS View that provides data about "Substance Variant Assignment" in SAP S/4HANA. It reads from 1 data source (I_SubstanceVarAssgmtTP) and exposes 6 fields with key field SubstanceVarAssgmtUUID. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_SubstanceVarAssgmtTP SubstanceVarAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_SubstanceQryTP _Substance $projection.SubstanceUUID = _Substance.SubstanceUUID
[1..1] I_ListedSubstanceVariant _AssignedVariant $projection.ListedSubstanceVariantUUID = _AssignedVariant.ListedSubstanceVariantUUID

Annotations (14)

NameValueLevelField
EndUserText.label Substance Variant Assignment view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CSUBVARASQRYTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SubstanceVarAssgmtUUID I_SubstanceVarAssgmtTP SubstanceVarAssgmtUUID
SubstanceUUID I_SubstanceVarAssgmtTP SubstanceUUID
ListedSubstanceCndn _AssignedVariant ListedSubstanceCndn
ListedSubstanceVariantUUID I_SubstanceVarAssgmtTP ListedSubstanceVariantUUID
_Substance _Substance
_AssignedVariant _AssignedVariant 
/*----------------------------------------------------------------------------------------------------------------------
    View for Variant Assignments of a Substance
------------------------------------------------------------------------------------------------------------------------*/
@EndUserText.label: 'Substance Variant Assignment'

@VDM.viewType: #CONSUMPTION

@AccessControl.authorizationCheck: #CHECK

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata: {
  allowExtensions: true
}

@ObjectModel: {
   transactionalProcessingDelegated: true,
   createEnabled:                    true,
   updateEnabled:                    false,
   deleteEnabled:                    true,
   semanticKey:                      [ 'ListedSubstanceVariantUUID' ],
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #C,
     sizeCategory:   #M
   }
}
define view C_SubstanceVarAssgmtQryTP
  as select from I_SubstanceVarAssgmtTP as SubstanceVarAssgmt

  association [1..1] to C_SubstanceQryTP         as _Substance       on $projection.SubstanceUUID = _Substance.SubstanceUUID  
  association [1..1] to I_ListedSubstanceVariant as _AssignedVariant on $projection.ListedSubstanceVariantUUID = _AssignedVariant.ListedSubstanceVariantUUID
{
      
  key SubstanceVarAssgmt.SubstanceVarAssgmtUUID,
      
      SubstanceVarAssgmt.SubstanceUUID,
      
      @ObjectModel.readOnly: true
      _AssignedVariant.ListedSubstanceCndn,
      
      -- Language dependent condition name      
      @ObjectModel.readOnly: true
      _AssignedVariant._ConditionText[1: Language = $session.system_language].ListedSubstanceCndnName as ListedSubstanceCndnName,
      
      @ObjectModel.text.element: [ 'ListedSubstanceCndnName' ]
      SubstanceVarAssgmt.ListedSubstanceVariantUUID,

      //Exposed associations

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _Substance,

      _AssignedVariant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LISTEDSUBSTANCECNDNTEXT",
"I_LISTEDSUBSTANCEVARIANT",
"I_SUBSTANCEVARASSGMTTP"
],
"ASSOCIATED":
[
"C_SUBSTANCEQRYTP",
"I_LISTEDSUBSTANCEVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More