SAP Table S620
IDES Data Generation
S620 (IDES Data Generation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S620 to other SAP tables.
S620 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TVTA | CHAR | 2 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| BASME | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||
| STWAE | Statistics currency | STWAE | TCURC | CUKY | 5 | 0 | ||
| AEMENGE | Incoming orders quantity | MC_AEMENGE | QUAN | 15 | 3 | |||
| AENETWR | Net value of incoming orders | MC_AENETWR | CURR | 19 | 2 | |||
| UMMENGE | Sales quantity | MC_UMMENGE | QUAN | 15 | 3 | |||
| UMNETWR | Net value of invoiced sales | MC_UMNETWR | CURR | 19 | 2 | |||
| ABSAT | Sales | ABSAT | FLTP | 16 | 16 | |||
S620 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S620 | BASME | S620 | MANDT | T006 | Units of Measurement | MANDT |
| S620 | BASME | S620 | BASME | T006 | Units of Measurement | MSEHI |
| S620 | MANDT | S620 | MANDT | T000 | Clients | MANDT |
| S620 | MATNR | S620 | MANDT | MARA | General Material Data | MANDT |
| S620 | MATNR | S620 | MATNR | MARA | General Material Data | MATNR |
| S620 | SPART | S620 | MANDT | TVTA | Organizational Unit: Sales Area(s) | MANDT |
| S620 | SPART | S620 | VKORG | TVTA | Organizational Unit: Sales Area(s) | VKORG |
| S620 | SPART | S620 | VTWEG | TVTA | Organizational Unit: Sales Area(s) | VTWEG |
| S620 | SPART | S620 | SPART | TVTA | Organizational Unit: Sales Area(s) | SPART |
| S620 | STWAE | S620 | MANDT | TCURC | Currency Codes | MANDT |
| S620 | STWAE | S620 | STWAE | TCURC | Currency Codes | WAERS |
| S620 | VKORG | S620 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| S620 | VKORG | S620 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| S620 | VTWEG | S620 | VKORG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| S620 | VTWEG | S620 | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |
| S620 | VTWEG | S620 | MANDT | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| S620 | WERKS | S620 | MANDT | T001W | Plants/Branches | MANDT |
| S620 | WERKS | S620 | WERKS | T001W | Plants/Branches | WERKS |
