S205 SAP (MAP: Store Planning Movements) Table details

Dictionary Type: Table
Description: MAP: Store Planning Movements




ABAP Code to SELECT data from S205
Related tables to S205
Access table S205




Table field list including key, data, relationships and ABAP select examples

S205 is a standard SAP Table which is used to store MAP: Store Planning Movements data and is available within R/3 SAP systems depending on the version and release level.

The S205 table consists of various fields, each holding specific information or linking keys about MAP: Store Planning Movements data available in SAP. These include SPMON (Period to analyze - month), SAISO (Season Category), VKORG (Sales Organization), VTWEG (Distribution Channel).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP S205 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SAISOSeason Category SAISOCHAR4T6WSPSAISOSAISO
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
SSOURStatistic(s) origin SSOURCHAR4SSOUR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
PSWAEDatabase Currency for Planning Data in a Planning Scenario WISP_PSWAECUKY5TCURCWAERS
UBPGVPRevaluation at retail, plus, at retail with tax MCW_UBPGVPCURR19(2) WERTV10
UBMGVPRevaluation at retail, minus, at retail with tax MCW_UBMGVPCURR19(2) WERTV10
UBPGVORevaluation at retail, plus MCW_UBPGVOCURR19(2) WERTV10
UBMGVORevaluation at retail, minus MCW_UBMGVOCURR19(2) WERTV10
PRSNLSSales deviation during sales MCW_PRSNLSCURR19(2) WERTV10
UMSGVPSales at retail with tax MCW_UMSGVPCURR19(2) WERTV10
UMSGVOSales at retail MCW_UMSGVOCURR19(2) WERTV10
UMSGEOSales at cost MCW_UMSGEOCURR19(2) WERTV10
WESGVPGoods receipt (vendor) at retail with tax MCW_WESGVPCURR19(2) WERTV10
WESGVOGoods receipt (vendor) at retail MCW_WESGVOCURR19(2) WERTV10
WESGEOGoods receipt (vendor) at cost MCW_WESGEOCURR19(2) WERTV10
BKIMVPStock adjustment inventory difference minus (retail w/tax) MCW_BKIMVPCURR19(2) WERTV10
BKIMVOStock adjustment inventory difference minus (retail) MCW_BKIMVOCURR19(2) WERTV10
BKIMEOStock adjustment inventory difference minus (cost) MCW_BKIMEOCURR19(2) WERTV10
RTEGVPReturns to vendor at retail with tax MCW_RTEGVPCURR19(2) WERTV10
RTEGVOReturns to vendor at retail MCW_RTEGVOCURR19(2) WERTV10
RTEGEOReturns to vendor at cost MCW_RTEGEOCURR19(2) WERTV10
BKSPGVPStock adjustment miscellaneous + retail with tax WISP_BKSPGVPCURR19(2) WERTV10
BKSPGVOStock Adjustment Miscellaneous + Retail WISP_BKSPGVOCURR19(2) WERTV10
BKSPGEOStock adjustment miscellaneous + (cost) WISP_BKSPGEOCURR19(2) WERTV10
BKSMGVPStock adjustment miscellaneous - retail with tax WISP_BKSMGVPCURR19(2) WERTV10
BKSMGVOStock Adjustment Miscellaneous - Retail WISP_BKSMGVOCURR19(2) WERTV10
BKSMGEOStock adjustment miscellaneous - cost WISP_BKSMGEOCURR19(2) WERTV10
ZUGSGVPMiscellaneous receipts at retail with tax WISP_ZUGSGVPCURR19(2) WERTV10
ZUGSGVOMiscellaneous receipts at retail WISP_ZUGSGVOCURR19(2) WERTV10
ZUGSGEOMiscellaneous receipts at cost WISP_ZUGSGEOCURR19(2) WERTV10
ABGSGVPMisc Issues at Retail With Tax WISP_ABGSGVPCURR19(2) WERTV10
ABGSGVOMiscellaneous Issues at Retail WISP_ABGSGVOCURR19(2) WERTV10
ABGSGEOMiscellaneous Issues at Cost WISP_ABGSGEOCURR19(2) WERTV10
ZUGGVPReceipts at retail with tax MCW_ZUGGVPCURR19(2) WERTV10
ZUGGVOReceipts at retail MCW_ZUGGVOCURR19(2) WERTV10
ZUGGEOReceipts at cost MCW_ZUGGEOCURR19(2) WERTV10
ABGGVPIssues at retail with tax MCW_ABGGVPCURR19(2) WERTV10
ABGGVOIssues at retail MCW_ABGGVOCURR19(2) WERTV10
ABGGEOIssues at cost MCW_ABGGEOCURR19(2) WERTV10
ZUKGVPAdditional purchase at retail with tax WISP_ZUKGVPCURR19(2) WERTV10
ZUKGVOAdditional purchase at retail WISP_ZUKGVOCURR19(2) WERTV10
ZUKGEOReceipts at cost WISP_ZUKGEOCURR19(2) WERTV10
VEDGVPBudget Released at Retail With Tax WISP_VEDGVPCURR19(2) WERTV10
VEDGVOBudget Released at Retail WISP_VEDGVOCURR19(2) WERTV10
VEDGEOBudget Released at Cost WISP_VEDGEOCURR19(2) WERTV10
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO

Key field Non-key field



How do I retrieve data from SAP table S205 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S205 to SELECT all data from the table
DATA: WA_S205 TYPE S205.

SELECT SINGLE *
FROM S205
INTO CORRESPONDING FIELDS OF WA_S205
WHERE...

How to access SAP table S205

Within an ECC or HANA version of SAP you can also view further information about S205 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!