SAP table FINB_TR_DERIVE (FINB-Transport: Table for Transporting the ABA Derivation)
SAP table FINB_TR_DERIVE has 4 primary key fields being MANDT,RELID,TRKEY,SRTF2.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| RELID | Region in IMPORT/EXPORT Data Table | CHAR | 2 | 0 | INDX_RELID | ||
| TRKEY | FINB TR: Length of the Transport Key in Cluster Table | CHAR | 90 | 0 | FINB_TR_CONTAINERKEY | ||
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INT4 | 10 | 0 | INDX_SRTF2 | ||
| AEDAT | (8-character) Date for SYST | DATS | 8 | 0 | SYDATS | ||
| USNAM | User Name | CHAR | 12 | 0 | USERNAME | ||
| SAPRL | CHAR | 4 | 0 | ||||
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INT2 | 5 | 0 | INDX_CLSTR | ||
| CLUSTD | Data field for IMPORT/EXPORT database tables | LRAW | 2886 | 0 | INDX_CLUST |