C_SrcgProjVersioningReasonVH

DDL: C_SRCGPROJVERSIONINGREASONVH SQL: CSPITMVRSRSNVH Type: view CONSUMPTION

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). It is used in 3 Fiori applications: Manage Sourcing Projects, Display Sourcing Project, Contribute to Sourcing Projects.

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

Fiori Apps (3)

App IDApp NameTypeDescription
F4861 Manage Sourcing Projects Transactional An application to create and manage sourcing projects.
F5934 Display Sourcing Project Transactional An application to approve Sourcing Projects.
F7757 Contribute to Sourcing Projects Transactional The app is an application to contribute to sourcing projects as an additional user.

Manage Sourcing Projects

Business Role: Sourcing Manager

Key functionalities:1. Support for "strategic" and "demand driven" sourcing processes2. Determine and invite suppliers as per "preferred supplier list"3. Create/add legal and other co-applicable documents to the sourcing project4. Evaluate and negotiate supplier quotations5. Create awarding scenarios to award the most suitable supplier quotations6. Create follow-on documents for the awarded quotations – purchase orders or central purchase contractsFor more information, see Product Sourcing.

Display Sourcing Project

Business Role: Purchasing Manager

Key functionalities:1. Support for "strategic" and "demand driven" sourcing processes2. Determine and invite suppliers as per "preferred supplier list"3. Create/add legal and other co-applicable documents to the sourcing project4. Evaluate and negotiate supplier quotations5. Create awarding scenarios to award the most suitable supplier quotations6. Create follow-on documents for the awarded quotations – purchase orders or central purchase contractsFor more information, see Product Sourcing.

Contribute to Sourcing Projects

Business Role: Employee - Sourcing

With this release, if the sourcing managers invite you to contribute, you can support them by enhancing the sourcing projects that they have created. For example, you can add attachments to the sourcing projects that you are invited to contribute to.

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

}