I_Usercatalogs

DDL: I_USERCATALOGS SQL: IUSERCATALOGS Type: view COMPOSITE
14 Fields 2 Data Sources 1 Associations

CDS View for User Catalog

I_Usercatalogs is a Composite CDS View that provides data about "CDS View for User Catalog" in SAP S/4HANA. It reads from 2 data sources (I_ProcmtEmployeeUserDetails, I_ProcmtUserDefaultCatalogs) and exposes 14 fields with key fields Employee, PersonalizationID, BusinessObjectType, PurReqnSSPCatalog. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_ProcmtEmployeeUserDetails _Userdetail inner
I_ProcmtUserDefaultCatalogs I_ProcmtUserDefaultCatalogs from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProcmtEmployeeUserDetails _Userdetails $projection.Employee = _Userdetails.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUSERCATALOGS view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View for User Catalog view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Employee I_ProcmtUserDefaultCatalogs Employee Object ID
KEY PersonalizationID PersonalizationID UUID
KEY BusinessObjectType I_ProcmtUserDefaultCatalogs BusinessObjectType Object Type
KEY PurReqnSSPCatalog PurReqnSSPCatalog Web Service ID
IsBusinessPurposeCompleted _Userdetails IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _Userdetails AuthorizationGroup AuthorizGroup
UserID _Userdetails UserID User Name
CompanyCode _Userdetails CompanyCode Receiver Company Code
DfltCtlgInOneProcmt I_ProcmtUserDefaultCatalogs DfltCtlgInOneProcmt Default Indicator
Person _Userdetails Person Person/ Farm/ Field
FullName _Userdetails FullName Name
PersonWorkAgrmtAuthznGrpg _Userdetails PersonWorkAgrmtAuthznGrpg Org.key
_Userdetails _Userdetails
_BusinessPartner _Userdetails _BusinessPartner

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_Usercatalogs.
-- 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: IUSERCATALOGS

CREATE VIEW I_Usercatalogs AS
SELECT
  I_ProcmtUserDefaultCatalogs.Employee AS Employee,
  PersonalizationID,
  I_ProcmtUserDefaultCatalogs.BusinessObjectType AS BusinessObjectType,
  PurReqnSSPCatalog,
  _Userdetails.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Userdetails.AuthorizationGroup AS AuthorizationGroup,
  _Userdetails.UserID AS UserID,
  _Userdetails.CompanyCode AS CompanyCode,
  I_ProcmtUserDefaultCatalogs.DfltCtlgInOneProcmt AS DfltCtlgInOneProcmt,
  _Userdetails.Person AS Person,
  _Userdetails.FullName AS FullName,
  _Userdetails.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  _Userdetails._BusinessPartner AS _BusinessPartner
FROM I_ProcmtUserDefaultCatalogs
INNER JOIN I_ProcmtEmployeeUserDetails AS _Userdetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProcmtEmployeeUserDetails AS _Userdetails ON Employee = _Userdetails.UserID  -- association [1..1]
;

Learn More