C_SuplrEvalUsrDfndCriteria

DDL: C_SUPLREVALUSRDFNDCRITERIA SQL: CMMPUREVALUSRCRI Type: view CONSUMPTION
29 Fields 1 Data Sources 1 Associations 1 Fiori Apps

User-Defined for Supplier Evaluation

C_SuplrEvalUsrDfndCriteria is a Consumption CDS View that provides data about "User-Defined for Supplier Evaluation" in SAP S/4HANA. It reads from 1 data source (I_SuplrEvalUsrDfndCriteriaTP) and exposes 29 fields with key field SuplrEvalUsrDfndCritraUUID. It has 1 association to related views. It is used in 1 Fiori application: Supplier Evaluation Scores Output.

Data Sources (1)

SourceAliasJoin Type
I_SuplrEvalUsrDfndCriteriaTP I_SuplrEvalUsrDfndCriteriaTP from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SuplrEvalUserDefinedCriteria _SuplrEvalUserDfndCriteria $projection.SuplrEvalUserDefinedCriteria = _SuplrEvalUserDfndCriteria.SuplrEvalUserDefinedCriteria

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CMMPUREVALUSRCRI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label User-Defined for Supplier Evaluation view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
UI.headerInfo.typeName User-Defined Criteria view
UI.headerInfo.typeNamePlural User-Defined Criterion view
OData.publish true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fiori Apps (1)

App IDApp NameTypeDescription
F5061 Supplier Evaluation Scores Output Transactional, Analytical

Supplier Evaluation Scores Output

Business Role: Strategic Buyer

With this app, strategic buyers can create and manage user defined criteria to rate suppliers. You can add scores for a specific supplier for a particular user defined criterion. The list of existing user defined criteria is displayed in this app. Click on the individual entries to view the details.

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SuplrEvalUsrDfndCritraUUID SuplrEvalUsrDfndCritraUUID Unique Idenitifier
Supplier Supplier Supplier
MaterialGroup MaterialGroup Product Group
PurchasingCategory PurchasingCategory Purchasing Category
SuplrEvalUserDefinedCriteria SuplrEvalUserDefinedCriteria Criterion
ValidFrom ValidFrom Valid From
SupplierName _Supplier SupplierName Supplier Name
MaterialGroupName
PurgCatName _PurchasingCategory PurgCatName Purchasing Cat. Name
SuplrEvalUsrCritraStatusDesc _StatusVH SuplrEvalUsrCritraStatusDesc
IsDeleted IsDeleted Status
ValidTo ValidTo Valid To
SuplrEvalUserDfndCriteriaDesc Criterion Description
TotNmbrOfSuplrUsrDfndCritra TotNmbrOfSuplrUsrDfndCritra Count
Comments Comments Comment
SuplrEvalUsrDfndCritraCrtedBy SuplrEvalUsrDfndCritraCrtedBy Created By
CreatedByUserName _CreatedBy UserDescription Full Name
SuplrEvalUserDfndCritraCrtnDte SuplrEvalUserDfndCritraCrtnDte Created On
SuplrEvalUsrDfndCritraChgdBy SuplrEvalUsrDfndCritraChgdBy Last Changed By
UserDescription _LastChangedBy UserDescription Full Name
SuplrEvalUserDfndCritraChgDate SuplrEvalUserDfndCritraChgDate Last Changed on
SupplierAccountGroup SupplierAccountGroup Account group
_SuplrEvalUserDfndCriteria _SuplrEvalUserDfndCriteria
_StatusVH _StatusVH
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy
_MatGroup _MatGroup
_PurchasingCategory _PurchasingCategory
_Supplier _Supplier

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SuplrEvalUsrDfndCriteria.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMMPUREVALUSRCRI

CREATE VIEW C_SuplrEvalUsrDfndCriteria AS
SELECT
  SuplrEvalUsrDfndCritraUUID,
  Supplier,
  MaterialGroup,
  PurchasingCategory,
  SuplrEvalUserDefinedCriteria,
  ValidFrom,
  _Supplier.SupplierName AS SupplierName,
  _MatGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _PurchasingCategory.PurgCatName AS PurgCatName,
  _StatusVH.SuplrEvalUsrCritraStatusDesc AS SuplrEvalUsrCritraStatusDesc,
  IsDeleted,
  ValidTo,
  _SuplrEvalUserDfndCriteria._userdefinedcriteriaText[1:Language = $session.system_language ].SuplrEvalUserDfndCriteriaDesc AS SuplrEvalUserDfndCriteriaDesc,
  TotNmbrOfSuplrUsrDfndCritra,
  Comments,
  SuplrEvalUsrDfndCritraCrtedBy,
  _CreatedBy.UserDescription AS CreatedByUserName,
  SuplrEvalUserDfndCritraCrtnDte,
  SuplrEvalUsrDfndCritraChgdBy,
  _LastChangedBy.UserDescription AS UserDescription,
  SuplrEvalUserDfndCritraChgDate,
  SupplierAccountGroup
FROM I_SuplrEvalUsrDfndCriteriaTP
LEFT OUTER JOIN I_SuplrEvalUserDefinedCriteria AS _SuplrEvalUserDfndCriteria ON SuplrEvalUserDefinedCriteria = _SuplrEvalUserDfndCriteria.SuplrEvalUserDefinedCriteria  -- association [0..1]
;

Learn More