C_SSPReqnConfiguration

DDL: C_SSPREQNCONFIGURATION SQL: CSSPREQNCONF Type: view CONSUMPTION
10 Fields 1 Data Sources 3 Associations

SSP UI configuration

C_SSPReqnConfiguration is a Consumption CDS View that provides data about "SSP UI configuration" in SAP S/4HANA. It reads from 1 data source (I_ProcmtEmployeeUserDetails) and exposes 10 fields with key field Employee. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtEmployeeUserDetails _Userdetails from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_PurReqnEmplByCoOfAuthorVH _PurReqEmplByCoOfAuthorVH $projection.PurReqnEmplByCoOfAuthor = _PurReqEmplByCoOfAuthorVH.Employee
[0..1] C_SSPEmplByReqnGrpOfAuthorVH _SSPEmplByReqnGrpOfAuthorVH $projection.PurReqnEmplByReqnGrpOfAuthor = _SSPEmplByReqnGrpOfAuthorVH.Employee
[1..1] I_BusinessUser _BusinessUser $projection.Employee = _BusinessUser.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSSPREQNCONF view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label SSP UI configuration view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Employee I_ProcmtEmployeeUserDetails UserID User Name
ShopOnBehalfType _UserDefaultSettingItem ShopOnBehalfType Shop on Behalf
FullName I_ProcmtEmployeeUserDetails FullName Name
UserID _BusinessUser BPIdentificationNumber Logical System
PurReqnHeaderCurrencySource _UserDefaultSettingItem PurReqnHeaderCurrencySource Src of Tot Val Crcy
PurReqnEmplByCoOfAuthor
PurReqnEmplByReqnGrpOfAuthor
_SSPEmplByReqnGrpOfAuthorVH _SSPEmplByReqnGrpOfAuthorVH
_PurReqEmplByCoOfAuthorVH _PurReqEmplByCoOfAuthorVH
_UserDefaultSettingItem _UserDefaultSettingItem

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_SSPReqnConfiguration.
-- 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: CSSPREQNCONF

CREATE VIEW C_SSPReqnConfiguration AS
SELECT
  _Userdetails.UserID AS Employee,
  _UserDefaultSettingItem.ShopOnBehalfType AS ShopOnBehalfType,
  _Userdetails.FullName AS FullName,
  _BusinessUser.BPIdentificationNumber AS UserID,
  _UserDefaultSettingItem.PurReqnHeaderCurrencySource AS PurReqnHeaderCurrencySource,
  cast('' as mmpur_req_d_requestor ) AS PurReqnEmplByCoOfAuthor,
  cast('' as mmpur_req_d_requestor ) AS PurReqnEmplByReqnGrpOfAuthor
FROM I_ProcmtEmployeeUserDetails AS _Userdetails
LEFT OUTER JOIN C_PurReqnEmplByCoOfAuthorVH AS _PurReqEmplByCoOfAuthorVH ON PurReqnEmplByCoOfAuthor = _PurReqEmplByCoOfAuthorVH.Employee  -- association [0..*]
LEFT OUTER JOIN C_SSPEmplByReqnGrpOfAuthorVH AS _SSPEmplByReqnGrpOfAuthorVH ON PurReqnEmplByReqnGrpOfAuthor = _SSPEmplByReqnGrpOfAuthorVH.Employee  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _BusinessUser ON Employee = _BusinessUser.UserID  -- association [1..1]
;

Learn More