C_SrcPrjSuplrPartcipnDclnRsnVH

DDL: C_SRCPRJSUPLRPARTCIPNDCLNRSNVH SQL: CSPSPLDCLNRSNVH Type: view CONSUMPTION

Rsn for Suplr Partcipn Dcln in Srcg Proj

C_SrcPrjSuplrPartcipnDclnRsnVH is a Consumption CDS View that provides data about "Rsn for Suplr Partcipn Dcln in Srcg Proj" in SAP S/4HANA. It reads from 3 data sources (I_ProductSourcingReasonModel, I_SourcingProjectType, I_ProductSourcingReason) and exposes 4 fields with key fields SourcingProjectReason, SourcingProjectReasonGroup, SourcingProjectType.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_ProductSourcingReasonModel _SourcingProjectReasonModel inner
I_SourcingProjectType _SourcingProjectType inner
I_ProductSourcingReason I_ProductSourcingReason from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CSPSPLDCLNRSNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SourcingProjectReason view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #CONSUMPTION view
EndUserText.label Rsn for Suplr Partcipn Dcln in Srcg Proj view
Search.searchable true view
Consumption.ranked true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectReason I_ProductSourcingReason ProductSourcingReason
KEY SourcingProjectReasonGroup I_ProductSourcingReasonModel ProductSourcingReasonGroup
KEY SourcingProjectType I_SourcingProjectType SourcingProjectType
SourcingProjectReasonText 
@AbapCatalog.sqlViewName: 'CSPSPLDCLNRSNVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: { representativeKey: 'SourcingProjectReason',
                usageType.dataClass: #MIXED,
                usageType.serviceQuality: #C,
                usageType.sizeCategory:  #L,
                dataCategory: #VALUE_HELP,
                resultSet.sizeCategory: #XS
                }

@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Rsn for Suplr Partcipn Dcln in Srcg Proj'

@Search.searchable: true
@Consumption.ranked: true

define view C_SrcPrjSuplrPartcipnDclnRsnVH
  as select from I_ProductSourcingReason 

    inner join   I_ProductSourcingReasonModel as _SourcingProjectReasonModel on I_ProductSourcingReason.ProductSourcingReason = _SourcingProjectReasonModel.ProductSourcingReason

    inner join   I_SourcingProjectType        as _SourcingProjectType        on _SourcingProjectType.SrcPrjSuplrPartcipnDclnRsnGrp = _SourcingProjectReasonModel.ProductSourcingReasonGroup 
{
         @UI.hidden: true
         @ObjectModel.text.element: ['SourcingProjectReasonText']
  key    I_ProductSourcingReason.ProductSourcingReason as SourcingProjectReason,

         @UI.hidden: true
  key    _SourcingProjectReasonModel.ProductSourcingReasonGroup as SourcingProjectReasonGroup,

  key    _SourcingProjectType.SourcingProjectType,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         @Semantics.text: true
         I_ProductSourcingReason._SourcingProjectReasonText[1:Language = $session.system_language ].ProductSourcingReasonText as SourcingProjectReasonText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTSOURCINGREASON",
"I_PRODUCTSOURCINGREASONMODEL",
"I_PRODUCTSOURCINGREASONTEXT",
"I_SOURCINGPROJECTTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More