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 |
Possible values
|
||||||
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 |
Possible values
|
||||||
XDFREL2 | Standard Relationship | BU_XDFREL | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
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 |