| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | RELNR | BP Relationship Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | BU_RELNR | Allow NULL? |
| 3 | PARTNER1 | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | BU_PARTNER | Allow NULL? |
| 4 | PARTNER2 | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | BU_PARTNER | Allow NULL? |
| 5 | DATE_TO | Validity Date (Valid To) | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BU_DATTO | Allow NULL? |
| 6 | DATE_FROM | Validity Date (Valid From) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_DATFROM | Allow NULL? |
| 7 | RELTYP | Business Partner Relationship Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | BU_RELTYP | Allow NULL? |
| 8 | XRF | Business partner role definition instead of BP relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XRF | Allow NULL? |
| 9 | DFTVAL | BP: Differentiation type characteristic (change doc.-rel.) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BU_DFTVAL | Allow NULL? |
| 10 | RLTYP | Business partner role (change doc.-relevant) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | BU_RLTYPE | Allow NULL? |
| 11 | RELKIND | Business partner relationship type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BU_RELKIND | Allow NULL? |
| 12 | CRUSR | User who created the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BU_CRUSR | Allow NULL? |
| 13 | CRDAT | Date on which the object was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_CRDAT | Allow NULL? |
| 14 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BU_CRTIM | Allow NULL? |
| 15 | CHUSR | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BU_CHUSR | Allow NULL? |
| 16 | CHDAT | Date when object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_CHDAT | Allow NULL? |
| 17 | CHTIM | Time at which object was last changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BU_CHTIM | Allow NULL? |
| 18 | XDFREL | Standard Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XDFREL | Allow NULL? |
| 19 | XDFREL2 | Standard Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XDFREL | Allow NULL? |
| 20 | DB_KEY | GP: UUID for Identifying the Data Record (SETGUID) | varbinary | 16 | 0 | RAW | | Yes | | BUP_SETGUID | |
| 21 | DB_KEY_TD | GP: UUID for Identifying the Data Record (SETGUID) | varbinary | 16 | 0 | RAW | | Yes | | BUP_SETGUID | |
