1. Home
  2. Resources
  3. SAP Tables
  4. BUS000EMPL - Business Partner: Work and Screen Fields Employee

SAP Table BUS000EMPL

Business Partner: Work and Screen Fields Employee

BUS000EMPL (Business Partner: Work and Screen Fields Employee) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUS000EMPL to other SAP tables.

BUS000EMPL table fields

Field Data element Checktable Datatype Length Decimals
USERNAME User Name SYUNAME CHAR 12 0
INTERNETUSER Internet User BU_INTERNETUSER CHAR 40 0
REFUSER Reference User from User Master BU_REFUSER CHAR 12 0
PASSWORD New Password (Repeat) BU_PASSWORD CHAR 40 0
PASSW_REPEAT New Password (Repeat) BU_PASSW_REPEAT CHAR 40 0
USER_CLASS User group in user master maintenance XUCLASS USGRP CHAR 12 0
USER_VALID_FROM User: Valid From BU_DATABSTR_USER CHAR 10 0
USER_VALID_TO User: Valid From BU_DATBISTR_USER CHAR 10 0
USER_ROLE Role Name AGR_NAME CHAR 30 0
USER_TITLE Role name AGR_TITLE CHAR 80 0
USER_LANGU Language BU_USER_LANGU LANG 1 0
USER_DCPFM Decimal Format XUDCPFM CHAR 1 0
NULL 1.234.567,89
X 1,234,567.89
Y 1 234 567,89
USER_DATFM Date format XUDATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
5 YYYY/MM/DD
6 YYYY-MM-DD
7 GYY.MM.DD (Japanese Date)
8 GYY/MM/DD (Japanese Date)
9 GYY-MM-DD (Japanese Date)
A YYYY/MM/DD (Islamic Date 1)
B YYYY/MM/DD (Islamic Date 2)
C YYYY/MM/DD (Iranian Date)
EMPLOYEE_ID Personnel Number BU_PERNO NUMC 8 0
USER_LOCK Business Partner: User Lock BU_USER_LOCK CHAR 1 0

BUS000EMPL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUS000EMPL USER_CLASS SYST MANDT USGRP User Groups MANDT
BUS000EMPL USER_CLASS BUS000EMPL USER_CLASS USGRP User Groups USERGROUP