S207 - MAP: Store Planning Structure
MAP: Store Planning Structure information is stored in SAP table S207.
It is part of development package WIS_PLAN in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Retail: Planning".
It is part of development package WIS_PLAN in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Retail: Planning".
Fields for table S207
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
| SAISO | Season Category | X | SAISO | CHAR | 4 | T6WSP |
| VKORG | Sales Organization | X | VKORG | CHAR | 4 | TVKO |
| VTWEG | Distribution Channel | X | VTWEG | CHAR | 2 | TVTW |
| BZIRK | Sales District | X | BZIRK | CHAR | 6 | T171 |
| WERKS | Plant | X | WERKS_D | CHAR | 4 | T001W |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| PSWAE | Database Currency for Planning Data in a Planning Scenario | WISP_PSWAE | CUKY | 5 | TCURC | |
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 10 | ||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 10 | ||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 10 | ||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 10 | ||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 10 | ||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 10 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 10 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 10 | ||
| WESGVP | Goods receipt (vendor) at retail with tax | MCW_WESGVP | CURR | 10 | ||
| WESGVO | Goods receipt (vendor) at retail | MCW_WESGVO | CURR | 10 | ||
| WESGEO | Goods receipt (vendor) at cost | MCW_WESGEO | CURR | 10 | ||
| BKIMVP | Stock adjustment inventory difference minus (retail w/tax) | MCW_BKIMVP | CURR | 10 | ||
| BKIMVO | Stock adjustment inventory difference minus (retail) | MCW_BKIMVO | CURR | 10 | ||
| BKIMEO | Stock adjustment inventory difference minus (cost) | MCW_BKIMEO | CURR | 10 | ||
| RTEGVP | Returns to vendor at retail with tax | MCW_RTEGVP | CURR | 10 | ||
| RTEGVO | Returns to vendor at retail | MCW_RTEGVO | CURR | 10 | ||
| RTEGEO | Returns to vendor at cost | MCW_RTEGEO | CURR | 10 | ||
| BKSPGVP | Stock adjustment miscellaneous + retail with tax | WISP_BKSPGVP | CURR | 10 | ||
| BKSPGVO | Stock Adjustment Miscellaneous + Retail | WISP_BKSPGVO | CURR | 10 | ||
| BKSPGEO | Stock adjustment miscellaneous + (cost) | WISP_BKSPGEO | CURR | 10 | ||
| BKSMGVP | Stock adjustment miscellaneous - retail with tax | WISP_BKSMGVP | CURR | 10 | ||
| BKSMGVO | Stock Adjustment Miscellaneous - Retail | WISP_BKSMGVO | CURR | 10 | ||
| BKSMGEO | Stock adjustment miscellaneous - cost | WISP_BKSMGEO | CURR | 10 | ||
| ABGSGVP | Misc Issues at Retail With Tax | WISP_ABGSGVP | CURR | 10 | ||
| ABGSGVO | Miscellaneous Issues at Retail | WISP_ABGSGVO | CURR | 10 | ||
| ABGSGEO | Miscellaneous Issues at Cost | WISP_ABGSGEO | CURR | 10 | ||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 10 | ||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 10 | ||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 10 | ||
| BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 10 | ||
| BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 10 | ||
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 10 | ||
| VEDGVP | Budget Released at Retail With Tax | WISP_VEDGVP | CURR | 10 | ||
| VEDGVO | Budget Released at Retail | WISP_VEDGVO | CURR | 10 | ||
| VEDGEO | Budget Released at Cost | WISP_VEDGEO | CURR | 10 | ||
| EKORG | Purchasing organization | EKORG | CHAR | 4 | T024E |