I_USERREQUISITIONINGGROUPS

CDS View
4 Fields 4 CDS Views

Basic view for Requisitioning groups

I_USERREQUISITIONINGGROUPS is a CDS View in S/4HANA. Basic view for Requisitioning groups. It contains 4 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProcmtUsrDfltReqngGrpsAPI01 view from COMPOSITE Default Reqng Grps for Users in Procmt
I_PurchaseReqngGrpEmplByUserVH view inner COMPOSITE Employees by Requisitioning groups of Author
I_PurReqnGrpOfEmpl view from COMPOSITE Requisitioning groups of Employee
I_UserRequisitioningGroupsWD view from COMPOSITE BO View for Requisitioning Groups

Fields (4)

KeyField CDS FieldsUsed in Views
KEY BusinessObjectType BusinessObjectType 2
KEY Employee Employee,UserID 3
KEY PersonalizationID PersonalizationID 2
KEY RequisitioningGroup RequisitioningGroup 2

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.

-- Basic view for Requisitioning groups
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_USERREQUISITIONINGGROUPS (
    BUSINESSOBJECTTYPE,
    EMPLOYEE,
    PERSONALIZATIONID,
    REQUISITIONINGGROUP,
    PRIMARY KEY (BUSINESSOBJECTTYPE, EMPLOYEE, PERSONALIZATIONID, REQUISITIONINGGROUP)
);

Learn More