SAP table VTBMA (Master Agreement)
SAP table VTBMA has 2 primary key fields being MANDT,RMAID.
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 | T000 | MANDT | |
| RMAID | Master Agreement | CHAR | 10 | 0 | TB_RMAID | ||
| SMATYPE | Type of Master Agreement | CHAR | 3 | 0 | ATMA | TB_SMATYPE | |
| CRUSER | Entered By | CHAR | 12 | 0 | TB_CRUSER | ||
| DCRDAT | Entered On | DATS | 8 | 0 | TB_DCRDAT | ||
| UPUSER | Last Changed By | CHAR | 12 | 0 | TB_UPUSER | ||
| DUPDAT | Changed On | DATS | 8 | 0 | TB_DUPDAT | ||
| DCLOSE | Contract Conclusion Date | DATS | 8 | 0 | TB_DVTRAB | ||
| DMABEG | Start of term of master agreement | DATS | 8 | 0 | TB_DMABEG | ||
| DMAEND | End of Term of Master Agreement | DATS | 8 | 0 | TB_DMAEND | ||
| SALLCR | All currencies are allowed | CHAR | 1 | 0 | TB_SALLCR | ||
| SALLDT | All transaction types are allowed | CHAR | 1 | 0 | TB_SALLDT | ||
| SALLLE | Áll Company Codes Are Allowed | CHAR | 1 | 0 | TB_SALLLE | ||
| SALLPA | All business partners are allowed | CHAR | 1 | 0 | TB_SALLPA | ||
| XFIND | Search Term | CHAR | 20 | 0 | TB_XFIND | ||
| SVOLA | Total volume utilzation via asset transactions | CHAR | 1 | 0 | TB_SVOLA | ||
| SVOLP | Total Volume Utilization Via Liability Transactions | CHAR | 1 | 0 | TB_SVOLP |
VTBMA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 VTBMA | MANDT | T000 | Clients | MANDT |