| 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 | RELTYP | Business Partner Relationship Category | nvarchar | 6 | 0 | CHAR | (N' ') | No | | BU_RELTYP | Allow NULL? |
| 3 | XRF | Business partner role definition instead of BP relationship | char | 1 | 0 | CHAR | (N' ') | No | | BU_XRF | Allow NULL? |
| 4 | RLTP1 | BP Role Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TB003A | BU_PARTNERROLECAT | Allow NULL? |
| 5 | RLTP2 | BP Role Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TB003A | BU_PARTNERROLECAT | Allow NULL? |
| 6 | DFTYP | Differentiation Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBZ0D | BU_DFTYP | Allow NULL? |
| 7 | APPLI_TAB | Data management application | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBZ0A | BU_APPLTAB | Allow NULL? |
| 8 | VARNR | BDT: Screen sequence | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TBZ3N | BU_VARNR | Allow NULL? |
| 9 | XDIRECTION | One-Way Business Partner Relationship Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XDIRECT | Allow NULL? |
| 10 | TIMDP | Time Constraint | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_TIMDEP | Allow NULL? |
| 11 | CARDI | Number of relationships/role definitions in each set | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BU_CARDIN | Allow NULL? |
| 12 | CARDI_P1 | Cardinality from view of business partner 1 | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BU_CARDIN_P1 | Allow NULL? |
| 13 | CARDI_P2 | Cardinality from view of business partner 2 | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BU_CARDIN_P2 | Allow NULL? |
| 14 | XORGA_P1 | 'Organization' partner cat. relev. for relationship/role def | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XORGA_R | Allow NULL? |
| 15 | XPERS_P1 | 'Person' partner category rel. for relationship/role def. | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XPERS_R | Allow NULL? |
| 16 | XGROU_P1 | 'Group' partner category relevant for relationship/role def. | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XGROU_R | Allow NULL? |
| 17 | XORGA_P2 | 'Organization' partner cat. relev. for relationship/role def | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XORGA_R | Allow NULL? |
| 18 | XPERS_P2 | 'Person' partner category rel. for relationship/role def. | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XPERS_R | Allow NULL? |
| 19 | XGROU_P2 | 'Group' partner category relevant for relationship/role def. | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XGROU_R | Allow NULL? |
| 20 | XDFREL | Standard Relationship Indicator Maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_DFREL | Allow NULL? |
| 21 | XDFREL2 | Standard Relationship Indicator Maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_DFREL | Allow NULL? |
| 22 | PROTECT | BP: 'Protect Data' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_PROTECT | Allow NULL? |
| 23 | OWNER_BO | ESF: Name of a Business Object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BU_SESF_BUSINESS_OBJECT | Allow NULL? |