I_SupplierEvalScorecardSuplr

DDL: I_SUPPLIEREVALSCORECARDSUPLR SQL: ISUPEVALSCSUPPTY Type: view COMPOSITE Package: VDM_SLC_SES
21 Fields 1 Data Sources 3 Associations

Supplier Evaluation Scorecard Supplier

I_SupplierEvalScorecardSuplr is a Composite CDS View that provides data about "Supplier Evaluation Scorecard Supplier" in SAP S/4HANA. It reads from 1 data source (I_SupplierEvalScorecardParty) and exposes 21 fields with key field SuplrEvalScorecardPtyUUID. It has 3 associations to related views. Part of development package VDM_SLC_SES.

Data Sources (1)

SourceAliasJoin Type
I_SupplierEvalScorecardParty party from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Supplier
[0..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.BusinessPartner
[1..1] I_SupplierEvalScorecard _SupplierEvalScorecard $projection.SuplrEvalScorecardUUID = _SupplierEvalScorecard.SuplrEvalScorecardUUID

Annotations (10)

NameValueLevelField
EndUserText.label Supplier Evaluation Scorecard Supplier view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISUPEVALSCSUPPTY view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SuplrEvalScorecardPtyUUID SuplrEvalScorecardPtyUUID
SuplrEvalScorecardUUID SuplrEvalScorecardUUID
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID UUID
BusinessPartner
Supplier
AuthorizationGroup I_Supplier AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted Purpose Completed
DataController1 I_Supplier DataController1 Data Controller
DataController2 I_Supplier DataController2 Data Controller
DataController3 I_Supplier DataController3 Data Controller
DataController4 I_Supplier DataController4 Data Controller
DataController5 I_Supplier DataController5 Data Controller
DataController6 I_Supplier DataController6 Data Controller
DataController7 I_Supplier DataController7 Data Controller
DataController8 I_Supplier DataController8 Data Controller
DataController9 I_Supplier DataController9 Data Controller
DataController10 I_Supplier DataController10 Data Controller
DataControllerSet I_Supplier DataControllerSet Data Ctrlr. Set
_Supplier _Supplier
_BusinessPartner _BusinessPartner
_SupplierEvalScorecard _SupplierEvalScorecard

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 I_SupplierEvalScorecardSuplr.
-- 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: ISUPEVALSCSUPPTY

CREATE VIEW I_SupplierEvalScorecardSuplr AS
SELECT
  SuplrEvalScorecardPtyUUID,
  SuplrEvalScorecardUUID,
  I_BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast ( substring(SLCParty,1,10 ) as bu_partner preserving type) AS BusinessPartner,
  cast(I_Supplier_to_BusinessPartner.Supplier as /srmsmc/supplier_id preserving type) AS Supplier,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_Supplier.DataController1 AS DataController1,
  I_Supplier.DataController2 AS DataController2,
  I_Supplier.DataController3 AS DataController3,
  I_Supplier.DataController4 AS DataController4,
  I_Supplier.DataController5 AS DataController5,
  I_Supplier.DataController6 AS DataController6,
  I_Supplier.DataController7 AS DataController7,
  I_Supplier.DataController8 AS DataController8,
  I_Supplier.DataController9 AS DataController9,
  I_Supplier.DataController10 AS DataController10,
  I_Supplier.DataControllerSet AS DataControllerSet
FROM I_SupplierEvalScorecardParty AS party
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalScorecard AS _SupplierEvalScorecard ON SuplrEvalScorecardUUID = _SupplierEvalScorecard.SuplrEvalScorecardUUID  -- association [1..1]
;

Learn More