_BUSINESSUSER

21 Fields

_BUSINESSUSER is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY BPIdentificationNumber Employee,PersonExternalID,UserID 6
KEY BusinessPartner BusinessPartner,MfgBusinessPartner 8
KEY UserID UserID 11
AuthorizationGroup AuthorizationGroup 5
BusinessPartnerName BusinessPartnerName 2
DataController1 DataController1 3
DataController10 DataController10 3
DataController2 DataController2 3
DataController3 DataController3 3
DataController4 DataController4 3
DataController5 DataController5 3
DataController6 DataController6 3
DataController7 DataController7 3
DataController8 DataController8 3
DataController9 DataController9 3
DataControllerSet DataControllerSet 3
FirstName FirstName 6
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 5
LastName FamilyName,LastName 6
PersonFullName BusinessPartnerFullName,BusinessPartnerName,PersonFullName,PPSResponsiblePurchaserName 20
UserDescription AccountingDocCreatedByUserName 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _BUSINESSUSER (
    BPIDENTIFICATIONNUMBER,
    BUSINESSPARTNER,
    USERID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    PERSONFULLNAME,
    USERDESCRIPTION,
    PRIMARY KEY (BPIDENTIFICATIONNUMBER, BUSINESSPARTNER, USERID)
);

Learn More