C_SrcgProjVersioningReasonVH

DDL: C_SRCGPROJVERSIONINGREASONVH SQL: CSPITMVRSRSNVH Type: view CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJ_MAINTAIN

Reason for New Version of Srcg Project

C_SrcgProjVersioningReasonVH is a Consumption CDS View that provides data about "Reason for New Version of Srcg Project" in SAP S/4HANA. It reads from 3 data sources (I_ProductSourcingReasonModel, I_SourcingProjectType, I_ProductSourcingReason) and exposes 4 fields with key fields SourcingProjectReason, SourcingProjectType. It is exposed through 2 OData services (UI_SOURCINGPROJECT_MANAGE, UI_SRCGPROJ_CONTRIBUTE). Part of development package ODATA_MM_PUR_SRCGPROJ_MAINTAIN.

3 data source(s) Exposed by 2 service(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_ProductSourcingReasonModel _SourcingProjectReasonModel inner
I_SourcingProjectType _SourcingProjectType inner
I_ProductSourcingReason I_ProductSourcingReason from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSPITMVRSRSNVH 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 #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
EndUserText.label Reason for New Version of Srcg Project view
Search.searchable true view
Consumption.ranked true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJ_CONTRIBUTE UI_SRCGPROJ_CONTRIBUTE V2 C1 NOT_RELEASED

Fields (4)

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

@ObjectModel: { representativeKey: 'SourcingProjectReason',
                usageType.dataClass: #MASTER,   //#MIXED,

                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L,
                dataCategory: #VALUE_HELP
                //resultSet.sizeCategory: #XS

                }

@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Reason for New Version of Srcg Project'

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

define view C_SrcgProjVersioningReasonVH
  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.SrcgProjVersioningReasonGroup = _SourcingProjectReasonModel.ProductSourcingReasonGroup 
{
         @UI.hidden: true
         @ObjectModel.text.element: ['SourcingProjectReasonText']
  key    I_ProductSourcingReason.ProductSourcingReason as SourcingProjectReason,
  key    _SourcingProjectType.SourcingProjectType,

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

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

}

Learn More