SAP Table BUS050_BW

BW Extraction: Enhanced BUT050

BUS050_BW (BW Extraction: Enhanced BUT050) 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 BUS050_BW to other SAP tables.

BUS050_BW table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RELNR BP Relationship Number BU_RELNR CHAR 12 0
PARTNER1 Business Partner Number BU_PARTNER BUT000 CHAR 10 0
PARTNER2 Business Partner Number BU_PARTNER BUT000 CHAR 10 0
DATE_TO Validity Date (Valid To) BU_DATTO DATS 8 0
DATE_FROM Validity Date (Valid From) BU_DATFROM DATS 8 0
RELTYP Business Partner Relationship Category BU_RELTYP CHAR 6 0
XRF Business partner role definition instead of BP relationship BU_XRF CHAR 1 0
X Yes
NULL No
DFTVAL BP: Differentiation type characteristic (change doc.-rel.) BU_DFTVAL CHAR 20 0
RLTYP Business partner role (change doc.-relevant) BU_RLTYPE CHAR 6 0
RELKIND Business partner relationship type BU_RELKIND CHAR 4 0
CRUSR User who created the object BU_CRUSR CHAR 12 0
CRDAT Date on which the object was created BU_CRDAT DATS 8 0
CRTIM Time at which the object was created BU_CRTIM TIMS 6 0
CHUSR Last user to change object BU_CHUSR CHAR 12 0
CHDAT Date when object was last changed BU_CHDAT DATS 8 0
CHTIM Time at which object was last changed BU_CHTIM TIMS 6 0
XDFREL Standard Relationship BU_XDFREL CHAR 1 0
X Yes
NULL No
XDFREL2 Standard Relationship BU_XDFREL CHAR 1 0
X Yes
NULL No
DB_KEY GP: UUID for Identifying the Data Record (SETGUID) BUP_SETGUID RAW 16 0
DB_KEY_TD GP: UUID for Identifying the Data Record (SETGUID) BUP_SETGUID RAW 16 0
PARTNER1_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
PARTNER2_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
FLG_DELETED Checkbox XFELD CHAR 1 0
X Yes
NULL No

BUS050_BW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUS050_BW CLIENT BUS050_BW CLIENT T000 Clients MANDT
BUS050_BW PARTNER1 BUS050_BW CLIENT BUT000 BP: General data I CLIENT
BUS050_BW PARTNER1 BUS050_BW PARTNER1 BUT000 BP: General data I PARTNER
BUS050_BW PARTNER2 BUS050_BW CLIENT BUT000 BP: General data I CLIENT
BUS050_BW PARTNER2 BUS050_BW PARTNER2 BUT000 BP: General data I PARTNER