R_BPUSRROLE

CDS View
9 Fields 6 CDS Views

Business User Role

R_BPUSRROLE is a CDS View in S/4HANA. Business User Role. It contains 9 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_BPUsrRoleCurrent view_entity from COMPOSITE Business User Role Current (valid today)
R_BPUsrRoleNext view_entity from COMPOSITE Business User Role Next (valid in future)
R_BPUsrRoleNextBase view_entity from COMPOSITE Business User Role Next Base
R_BPUsrRolePrevious view_entity from COMPOSITE Business User Role Previous (valid in past)
R_BPUsrRolePreviousBase view_entity from COMPOSITE Business User Role Previous Base
R_WorkAssignmentTP view_entity inner TRANSACTIONAL Work assignment TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerRole BPUsrRoleForEdit,BusinessPartnerRole 5
KEY BusinessPartnerUUID BusinessPartnerUUID 4
BasicRoleCategory BasicRoleCategory 1
BPIdentificationCategory BPIdentificationCategory 4
BPRoleCategoryUsageCode BPRoleCategoryUsageCode 4
BPUsrRoleValidFromDate BPUsrRoleValidFromDate,StartDate 5
BPUsrRoleValidToDate BPUsrRoleValidToDate,EndDate 5
BusinessPartner BusinessPartner 4
RoleCategory RoleCategory 5

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.

-- Business User Role
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_BPUSRROLE (
    BUSINESSPARTNERROLE,
    BUSINESSPARTNERUUID,
    BASICROLECATEGORY,
    BPIDENTIFICATIONCATEGORY,
    BPROLECATEGORYUSAGECODE,
    BPUSRROLEVALIDFROMDATE,
    BPUSRROLEVALIDTODATE,
    BUSINESSPARTNER,
    ROLECATEGORY,
    PRIMARY KEY (BUSINESSPARTNERROLE, BUSINESSPARTNERUUID)
);

Learn More