ESH_S_SUPLR_EVAL_SCCARD

DDL: ESH_S_SUPLR_EVAL_SCCARD SQL: ESH_U_SUPEVLSCRD Type: view Package: BSESH_SLC_SES

Search view -SUPLR_EVAL_SCCARD

ESH_S_SUPLR_EVAL_SCCARD is a CDS View that provides data about "Search view -SUPLR_EVAL_SCCARD" in SAP S/4HANA. It reads from 1 data source (ESH_N_SUPLR_EVAL_SCCARD) and exposes 27 fields with key field SUPLREVALSCORECARDUUID. Part of development package BSESH_SLC_SES.

SAP Help Documentation

CategoryEnterprise Search
StatusNot Released
Purpose
This CDS View enables you to use the Enterprise Search in the header bar of the SAP Fiori launchpad to find supplier evaluation scorecards by the following criteria: Supplier Purchasing category Start date End date This CDS view provides the prerequisites for processing the following business task: I as strategic buyer want to find particular evaluation scrorecards directly from the SAP Fiori launchpad without entering the Display Scorecards app.

Prerequisites
You are authorized to access supplier evaluation scorecards

Structure
Object types This view relates to the following SAP object types: Supplier Evaluation Scorecard Main CDS parameters and filters The main CDS parameter is: P_Language used to specify the target language for data display The main filters are: SUPLREVALSCORECARDNAME used to specify the name of the evaluation scrorecard PURGCATNAME used to specify the name of the purchasing category assigned to the evaluation scorecard SUPLREVALSTARTDATE used to specify the start date of the evaluation scorecard Measures and attributes Attributes Some important attributes are: Name of the evaluation scorecard ID of the evaluation scorecard ID of the supplier assigned to the evaluation scorecard Name of the supplier assigned to the evaluation scorecard Lifecycle status of the evaluation scorecard Target score defined for the evaluation scorecard Minimum score defined for the evaluation scorecard Number of supplier evaluation responses taken into account for calculating the score ID of the purchasing category assigned to the evaluation scorecard Name of the purchasing category assigned to the evaluation scorecard Language-dependent description of the purchasing category assigned to the evaluation scorecard

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
ESH_N_SUPLR_EVAL_SCCARD ESH_N_SUPLR_EVAL_SCCARD from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.typeName Evaluation Scorecard view
UI.headerInfo.typeNamePlural Evaluation Scorecards view
Consumption.semanticObject SupplierEvalScorecard view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value SUPLREVALSCORECARDNAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_SUPEVLSCRD view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SUPLREVALSCORECARDUUID SUPLREVALSCORECARDUUID
AUTHORIZATIONGROUP AUTHORIZATIONGROUP AuthorizGroup
DATACONTROLLER1 DATACONTROLLER1 Data Controller
DATACONTROLLER10 DATACONTROLLER10 Data Controller
DATACONTROLLER2 DATACONTROLLER2 Data Controller
DATACONTROLLER3 DATACONTROLLER3 Data Controller
DATACONTROLLER4 DATACONTROLLER4 Data Controller
DATACONTROLLER5 DATACONTROLLER5 Data Controller
DATACONTROLLER6 DATACONTROLLER6 Data Controller
DATACONTROLLER7 DATACONTROLLER7 Data Controller
DATACONTROLLER8 DATACONTROLLER8 Data Controller
DATACONTROLLER9 DATACONTROLLER9 Data Controller
DATACONTROLLERSET DATACONTROLLERSET Data Ctrlr. Set
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
MINIMALSCORE MINIMALSCORE
NUMBEROFRESPONSES NUMBEROFRESPONSES
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Name 1
PURCHASINGCATEGORY PURCHASINGCATEGORY Purchasing Category
PURGCATDESCRIPTION PURGCATDESCRIPTION
PURGCATNAME PURGCATNAME Purchasing Category
SUPLREVALENDDATE SUPLREVALENDDATE
SUPLREVALRSPLIFECYCLESTATUS SUPLREVALRSPLIFECYCLESTATUS
SUPLREVALSCORECARDNAME SUPLREVALSCORECARDNAME
SUPLREVALSTARTDATE SUPLREVALSTARTDATE
SUPPLIER SUPPLIER Supplier
SUPPLIEREVALSCORECARD SUPPLIEREVALSCORECARD
TARGETSCORE TARGETSCORE

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 ESH_S_SUPLR_EVAL_SCCARD.
-- 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: ESH_U_SUPEVLSCRD
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_SUPLR_EVAL_SCCARD AS
SELECT
  SUPLREVALSCORECARDUUID,
  AUTHORIZATIONGROUP,
  DATACONTROLLER1,
  DATACONTROLLER10,
  DATACONTROLLER2,
  DATACONTROLLER3,
  DATACONTROLLER4,
  DATACONTROLLER5,
  DATACONTROLLER6,
  DATACONTROLLER7,
  DATACONTROLLER8,
  DATACONTROLLER9,
  DATACONTROLLERSET,
  ISBUSINESSPURPOSECOMPLETED,
  MINIMALSCORE,
  NUMBEROFRESPONSES,
  ORGANIZATIONBPNAME1,
  PURCHASINGCATEGORY,
  PURGCATDESCRIPTION,
  PURGCATNAME,
  SUPLREVALENDDATE,
  SUPLREVALRSPLIFECYCLESTATUS,
  SUPLREVALSCORECARDNAME,
  SUPLREVALSTARTDATE,
  SUPPLIER,
  SUPPLIEREVALSCORECARD,
  TARGETSCORE
FROM ESH_N_SUPLR_EVAL_SCCARD
;