SAP Table
ESD_TOPR Maintenance of Tolerance Profiles
SAP table ESD_TOPR has 2 primary key fields being MANDT,PROFIL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
ESD_TOPR columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| KeyPROFIL | Tolerance Profile | CHAR | 10 | 0 | DI_ESD_PROFIL | ||||||
| MGFZ | Quantities/Cumulative Quantity Check | CHAR | 2 | 0 | DI_ESD_MGFZ | ||||||
|
|||||||||||
| PRAB | Percentage/Absolute Value Check | CHAR | 2 | 0 | DI_ESD_PRAB | ||||||
|
|||||||||||
| MG_MIN | Minimum Quantities | NUMC | 5 | 0 | DI_ESD_MIN | ||||||
| MG_MAX | Maximum Quantity | NUMC | 5 | 0 | DI_ESD_MAX | ||||||
| HK | First Checking Horizon | NUMC | 4 | 0 | DI_ESD_HK | ||||||
| HM | Second Checking Horizon | NUMC | 4 | 0 | DI_ESD_HM | ||||||
| HL | Third Checking Horizon | NUMC | 4 | 0 | DI_ESD_HL | ||||||
| AK_PLUS | Positive Variance in Short-Term Horizon | NUMC | 5 | 0 | DI_ESD_KP | ||||||
| AK_MINUS | Negative Variance in Short-Term Horizon | NUMC | 5 | 0 | DI_ESD_KM | ||||||
| AM_PLUS | Positive Variance in Mid-Term Horizon | NUMC | 5 | 0 | DI_ESD_MP | ||||||
| AM_MINUS | Negative Variance in Mid-Term Horizon | NUMC | 5 | 0 | DI_ESD_MM | ||||||
| AL_PLUS | Positive Variance in Long-Term Horizon | NUMC | 5 | 0 | DI_ESD_LP | ||||||
| AL_MINUS | Negative Variance in Long-Term Horizon | NUMC | 5 | 0 | DI_ESD_LM | ||||||
| WORKFLOW | Workflow Indicator | CHAR | 1 | 0 | DI_ESD_WF | ||||||
|
|||||||||||
| REMARK | Text Field for Comments | CHAR | 30 | 0 | DI_ESD_RMK | ||||||
/ Relationships
ESD_TOPR foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| ESD_TOPR | MANDT | T000 | Clients | MANDT |