I_USERCATALOGS

CDS View

CDS View for User Catalog

I_USERCATALOGS is a CDS View in S/4HANA. CDS View for User Catalog. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Usercatalogswithdraft view from COMPOSITE BO view for catalogs

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BusinessObjectType BusinessObjectType 1
KEY Employee Employee 1
KEY PersonalizationID PersonalizationID 1
KEY PurReqnSSPCatalog PurReqnSSPCatalog 1
AuthorizationGroup AuthorizationGroup 1
CompanyCode CompanyCode 1
DfltCtlgInOneProcmt DfltCtlgInOneProcmt 1
FullName FullName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
Person Person 1
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 1
UserID UserID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CDS View for User Catalog
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USERCATALOGS (
    BUSINESSOBJECTTYPE,
    EMPLOYEE,
    PERSONALIZATIONID,
    PURREQNSSPCATALOG,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    DFLTCTLGINONEPROCMT,
    FULLNAME,
    ISBUSINESSPURPOSECOMPLETED,
    PERSON,
    PERSONWORKAGRMTAUTHZNGRPG,
    USERID,
    PRIMARY KEY (BUSINESSOBJECTTYPE, EMPLOYEE, PERSONALIZATIONID, PURREQNSSPCATALOG)
);