SAP Table S952
Reference Structure for Generating Info Structures
S952 (Reference Structure for Generating Info Structures) 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 S952 to other SAP tables.
S952 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 | |||
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 | 0 | ||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | 0 | |||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | 0 | |||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||
| PLGTP | Price Band Category | PLGTP | TWPT | CHAR | 2 | 0 | ||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| PSWAE | Database Currency for Planning Data in a Planning Scenario | WISP_PSWAE | TCURC | CUKY | 5 | 0 | ||
| PLMHT | Planned Unit of Measure | WISP_PLMHT | T006 | UNIT | 3 | 0 | ||
| BKSPGVP | Stock adjustment miscellaneous + retail with tax | WISP_BKSPGVP | CURR | 19 | 2 | |||
| BKSPGVO | Stock Adjustment Miscellaneous + Retail | WISP_BKSPGVO | CURR | 19 | 2 | |||
| BKSPGEO | Stock adjustment miscellaneous + (cost) | WISP_BKSPGEO | CURR | 19 | 2 | |||
| BKSPMNG | Stock Adjustment Miscellanous + Quantity | WISP_BKSPMNG | QUAN | 15 | 3 | |||
| BKSMGVP | Stock adjustment miscellaneous - retail with tax | WISP_BKSMGVP | CURR | 19 | 2 | |||
| BKSMGVO | Stock Adjustment Miscellaneous - Retail | WISP_BKSMGVO | CURR | 19 | 2 | |||
| BKSMGEO | Stock adjustment miscellaneous - cost | WISP_BKSMGEO | CURR | 19 | 2 | |||
| BKSMMNG | Stock Adjustment Miscellaneous - Quantity | WISP_BKSMMNG | QUAN | 15 | 3 | |||
| ZUGSGVP | Miscellaneous receipts at retail with tax | WISP_ZUGSGVP | CURR | 19 | 2 | |||
| ZUGSGVO | Miscellaneous receipts at retail | WISP_ZUGSGVO | CURR | 19 | 2 | |||
| ZUGSGEO | Miscellaneous receipts at cost | WISP_ZUGSGEO | CURR | 19 | 2 | |||
| ZUGSMNG | Receipts miscellaneous quantity | WISP_ZUGSMNG | QUAN | 15 | 3 | |||
| ABGSGVP | Misc Issues at Retail With Tax | WISP_ABGSGVP | CURR | 19 | 2 | |||
| ABGSGVO | Miscellaneous Issues at Retail | WISP_ABGSGVO | CURR | 19 | 2 | |||
| ABGSGEO | Miscellaneous Issues at Cost | WISP_ABGSGEO | CURR | 19 | 2 | |||
| ABGSMNG | Miscellaneous Issue Quantity | WISP_ABGSMNG | QUAN | 15 | 3 | |||
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15 | 3 | |||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 19 | 2 | |||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19 | 2 | |||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 19 | 2 | |||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 19 | 2 | |||
| BKIMMG | Stock adjustment inventory difference minus (quantity) | MCW_BKIMMG | QUAN | 15 | 3 | |||
| BKIMEO | Stock adjustment inventory difference minus (cost) | MCW_BKIMEO | CURR | 19 | 2 | |||
| BKIMVO | Stock adjustment inventory difference minus (retail) | MCW_BKIMVO | CURR | 19 | 2 | |||
| WESMNG | Goods receipt (vendor) quantity in BUn | MCW_WESMNG | QUAN | 15 | 3 | |||
| WESGEO | Goods receipt (vendor) at cost | MCW_WESGEO | CURR | 19 | 2 | |||
| WESGVO | Goods receipt (vendor) at retail | MCW_WESGVO | CURR | 19 | 2 | |||
| WESGVP | Goods receipt (vendor) at retail with tax | MCW_WESGVP | CURR | 19 | 2 | |||
| BSTMNG | Stock quantity in base unit of measure | MCW_BSTMNG | QUAN | 15 | 3 | |||
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 19 | 2 | |||
| BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 19 | 2 | |||
| BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 19 | 2 | |||
| UBPVPM | Revaluation at retail, plus, quantity | MCW_UBPVPM | QUAN | 15 | 3 | |||
| UBMVPM | Revaluation at retail, minus, quantity | MCW_UBMVPM | QUAN | 15 | 3 | |||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 19 | 2 | |||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 19 | 2 | |||
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 19 | 2 | |||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 19 | 2 | |||
| ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 15 | 3 | |||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 19 | 2 | |||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 19 | 2 | |||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 19 | 2 | |||
| ZUGMNG | Receipts quantity in BUn | MCW_ZUGMNG | QUAN | 15 | 3 | |||
| ZUGGEO | Receipts at cost | MCW_ZUGGEO | CURR | 19 | 2 | |||
| ZUGGVO | Receipts at retail | MCW_ZUGGVO | CURR | 19 | 2 | |||
| ZUGGVP | Receipts at retail with tax | MCW_ZUGGVP | CURR | 19 | 2 | |||
| RTEMNG | Returns to vendor quantity in base unit of measure | MCW_RTEMNG | QUAN | 15 | 3 | |||
| RTEGEO | Returns to vendor at cost | MCW_RTEGEO | CURR | 19 | 2 | |||
| RTEGVO | Returns to vendor at retail | MCW_RTEGVO | CURR | 19 | 2 | |||
| RTEGVP | Returns to vendor at retail with tax | MCW_RTEGVP | CURR | 19 | 2 | |||
| BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | MCW_BKIMVP | CURR | 19 | 2 | |||
| ZUKGVP | Additional purchase at retail with tax | WISP_ZUKGVP | CURR | 19 | 2 | |||
| ZUKGVO | Additional purchase at retail | WISP_ZUKGVO | CURR | 19 | 2 | |||
| ZUKGEO | Receipts at cost | WISP_ZUKGEO | CURR | 19 | 2 | |||
| ZUKMNG | Additional purchase quantity | WISP_ZUKMNG | QUAN | 15 | 3 | |||
| VEDGVP | Budget Released at Retail With Tax | WISP_VEDGVP | CURR | 19 | 2 | |||
| VEDGVO | Budget Released at Retail | WISP_VEDGVO | CURR | 19 | 2 | |||
| VEDGEO | Budget Released at Cost | WISP_VEDGEO | CURR | 19 | 2 | |||
| VEDMNG | Budget Released as Quantity | WISP_VEDMNG | QUAN | 15 | 3 | |||
| UBMGEO | Revaluation at cost, minus | MCW_UBMGEO | CURR | 19 | 2 | |||
| UBPGEO | Revaluation at cost, plus | MCW_UBPGEO | CURR | 19 | 2 | |||
S952 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S952 | EKORG | S952 | MANDT | T024E | Purchasing Organizations | MANDT |
| S952 | EKORG | S952 | EKORG | T024E | Purchasing Organizations | EKORG |
| S952 | MANDT | S952 | MANDT | T000 | Clients | MANDT |
| S952 | MATKL | S952 | MATKL | T023 | Material Groups | MATKL |
| S952 | MATKL | S952 | MANDT | T023 | Material Groups | MANDT |
| S952 | PLGTP | S952 | MANDT | TWPT | Price band categories | MANDT |
| S952 | PLGTP | S952 | PLGTP | TWPT | Price band categories | PLGTP |
| S952 | PLMHT | S952 | MANDT | T006 | Units of Measurement | MANDT |
| S952 | PLMHT | S952 | PLMHT | T006 | Units of Measurement | MSEHI |
| S952 | PSWAE | S952 | MANDT | TCURC | Currency Codes | MANDT |
| S952 | PSWAE | S952 | PSWAE | TCURC | Currency Codes | WAERS |
| S952 | SAISO | S952 | MANDT | T6WSP | Check Table for Season Indicator | MANDT |
| S952 | SAISO | S952 | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
| S952 | VKORG | S952 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| S952 | VKORG | S952 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| S952 | VTWEG | S952 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| S952 | VTWEG | S952 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
