SAP Table S922
Market Analysis
S922 (Market Analysis) 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 S922 to other SAP tables.
Source: S922 (Market Analysis)
S922 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 | |||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 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 | |||
| STWAE | Statistics currency | STWAE | TCURC | CUKY | 5 | 0 | ||
S922 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S922 | LAND1 | S922 | MANDT | T005 | Countries | MANDT |
| S922 | LAND1 | S922 | LAND1 | T005 | Countries | LAND1 |
| S922 | MANDT | S922 | MANDT | T000 | Clients | MANDT |
| S922 | MATNR | S922 | MANDT | MARA | General Material Data | MANDT |
| S922 | MATNR | S922 | MATNR | MARA | General Material Data | MATNR |
| S922 | STWAE | S922 | MANDT | TCURC | Currency Codes | MANDT |
| S922 | STWAE | S922 | STWAE | TCURC | Currency Codes | WAERS |
| S922 | ZZLOC | S922 | MANDT | ZZFCIDES02 | Location | MANDT |
| S922 | ZZLOC | S922 | ZZLOC | ZZFCIDES02 | Location | ZZLOC |
| S922 | ZZREGIO | S922 | MANDT | ZZFCIDES01 | Regions | MANDT |
| S922 | ZZREGIO | S922 | ZZREGIO | ZZFCIDES01 | Regions | ZZREGIO |
