SAP Table S626
LO935: SOP without plant
S626 (LO935: SOP without plant) 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 S626 to other SAP tables.
S626 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 | ||
SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||
KUNNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 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 | |||
FUMMENGE | Sales quantity | MC_UMMENGE | QUAN | 15 | 3 | |||
UMNETWR | Net value of invoiced sales | MC_UMNETWR | CURR | 19 | 2 | |||
PRODU | Production | PRODU | FLTP | 16 | 16 | |||
LAGRI | Stock level | LAGRI | FLTP | 16 | 16 | |||
LAGRZ | Target stock level | LAGRZ | FLTP | 16 | 16 | |||
REICH | Range of coverage (days' supply) | REICH | FLTP | 16 | 16 | |||
REICZ | Target range of coverage (target days' supply) | REICZ | FLTP | 16 | 16 | |||
ABSAT | Sales | ABSAT | FLTP | 16 | 16 |
S626 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
S626 | BASME | S626 | MANDT | T006 | Units of Measurement | MANDT |
S626 | BASME | S626 | BASME | T006 | Units of Measurement | MSEHI |
S626 | KUNNR | S626 | MANDT | KNA1 | General Data in Customer Master | MANDT |
S626 | KUNNR | S626 | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
S626 | MANDT | S626 | MANDT | T000 | Clients | MANDT |
S626 | MATNR | S626 | MANDT | MARA | General Material Data | MANDT |
S626 | MATNR | S626 | MATNR | MARA | General Material Data | MATNR |
S626 | SPART | S626 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
S626 | SPART | S626 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
S626 | STWAE | S626 | MANDT | TCURC | Currency Codes | MANDT |
S626 | STWAE | S626 | STWAE | TCURC | Currency Codes | WAERS |
S626 | VKORG | S626 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
S626 | VKORG | S626 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |