SAP table TMKS (Calculation Schemas: Purchasing)
SAP table TMKS has 3 primary key fields being MANDT,KALSE,KALSK.
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 | |
| KALSE | Group for Calculation Schema (Purchasing Organization) | CHAR | 4 | 0 | TMKE | KALSE | |
| KALSK | Group for Calculation Schema (Supplier) | CHAR | 2 | 0 | TMKK | KALSK | |
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | CHAR | 6 | 0 | T683 | KALSM_D | |
| KALBO | Settlement schema (subsequent settlement) | CHAR | 6 | 0 | T683 | KALBO | |
| KALSS | Schema for price determination (Ext. Services Management) | CHAR | 6 | 0 | T683 | KALSS | |
| KALNB | Procedure for Free Goods Determination | CHAR | 6 | 0 | T683 | KALNB |
TMKS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TMKS | KALBO | T683 | Pricing procedures | KAPPL |
| 0 TMKS | KALBO | T683 | Pricing procedures | KALSM |
| 1 TMKS | KALNB | T683 | Pricing procedures | KAPPL |
| 1 TMKS | KALNB | T683 | Pricing procedures | KALSM |
| 0 TMKS | KALSE | TMKE | Group for Calculation Schema (Purchasing Organization) | MANDT |
| 0 TMKS | KALSE | TMKE | Group for Calculation Schema (Purchasing Organization) | KALSE |
| 1 TMKS | KALSK | TMKK | Group for Calculation Schema (Supplier) | MANDT |
| 1 TMKS | KALSK | TMKK | Group for Calculation Schema (Supplier) | KALSK |
| 0 TMKS | KALSM | T683 | Pricing procedures | KAPPL |
| 0 TMKS | KALSM | T683 | Pricing procedures | KALSM |
| 1 TMKS | KALSS | T683 | Pricing procedures | KAPPL |
| 1 TMKS | KALSS | T683 | Pricing procedures | KALSM |