S085 SAP (Material: Movements + Stock) Table details

Dictionary Type: Table
Description: Material: Movements + Stock




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




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

S085 is a standard SAP Table which is used to store Material: Movements + Stock data and is available within R/3 SAP systems depending on the version and release level.

The S085 table consists of various fields, each holding specific information or linking keys about Material: Movements + Stock data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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 S085 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
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BTRKZPlant category VLFKZCHAR1VLFKZ
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
WGRU2Material group hierarchy 2 MCW_WGRU2CHAR18KLASSEWGRU2
WGRU1Material group hierarchy 1 MCW_WGRU1CHAR18KLASSEWGRU1
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
SAISOSeason Category SAISOCHAR4T6WSPSAISOSAISO
PLGTPPrice Band Category PLGTPCHAR2TWPTPLGTP
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
HWAERLocal Currency HWAERCUKY5TCURCWAERS
UMSMNGSales quantity in base unit of measure MCW_UMSMNGQUAN15(3) MENGV15_3
UMSGEOSales at cost MCW_UMSGEOCURR19(2) WERTV10
UMSGVOSales at retail MCW_UMSGVOCURR19(2) WERTV10
UMSGVPSales at retail with tax MCW_UMSGVPCURR19(2) WERTV10
PRSNLSSales deviation during sales MCW_PRSNLSCURR19(2) WERTV10
WESMNGGoods receipt (vendor) quantity in BUn MCW_WESMNGQUAN15(3) MENGV15_3
WESGEOGoods receipt (vendor) at cost MCW_WESGEOCURR19(2) WERTV10
WESGVOGoods receipt (vendor) at retail MCW_WESGVOCURR19(2) WERTV10
WESGVPGoods receipt (vendor) at retail with tax MCW_WESGVPCURR19(2) WERTV10
WESANZGoods receipt (vendor) number of transactions MCW_WESANZINT410MCZAEHLINT
KMEMNGGoods receipt (distribution center) quantity in BUn MCW_KMEMNGQUAN15(3) MENGV15_3
KMEGEOGoods receipt (DC) at cost MCW_KMEGEOCURR19(2) WERTV10
KMEGVOGoods receipt (DC) at retail MCW_KMEGVOCURR19(2) WERTV10
KMEGVPGoods receipt (dist. center) at retail with tax MCW_KMEGVPCURR19(2) WERTV10
KMEANZGoods receipt (distribution center), no. of transactions MCW_KMEANZINT410MCZAEHLINT
KMAMNGGoods issue (distribution center) quantity in BUn MCW_KMAMNGQUAN15(3) MENGV15_3
KMAGEOGoods issue (DC) at cost MCW_KMAGEOCURR19(2) WERTV10
KMAGVOGoods issue (DC) at retail MCW_KMAGVOCURR19(2) WERTV10
KMAGVPGoods issue (dist. center) at retail with tax MCW_KMAGVPCURR19(2) WERTV10
KMAANZGoods issue (distribution center), no. of transactions MCW_KMAANZINT410MCZAEHLINT
BVLMNGOrder volume quantity Retail MCW_BVLMNGQUAN15(3) MENGV15_3
BVLGEOOrder volume at cost MCW_BVLGEOCURR19(2) WERTV10
BVLGVOOrder volume at retail MCW_BVLGVOCURR19(2) WERTV10
BVLGVPOrder volume at retail with tax MCW_BVLGVPCURR19(2) WERTV10
BVLANZOrder volume, number of transactions MCW_BVLANZINT410MCZAEHLINT
BSTMNGStock quantity in base unit of measure MCW_BSTMNGQUAN15(3) MENGV15_3
BSTGEOStock at cost MCW_BSTGEOCURR19(2) WERTV10
BSTGVOStock at retail MCW_BSTGVOCURR19(2) WERTV10
BSTGVPStock at retail with tax MCW_BSTGVPCURR19(2) WERTV10
UBPVPMRevaluation at retail, plus, quantity MCW_UBPVPMQUAN15(3) MENGV15_3
UBPGVORevaluation at retail, plus MCW_UBPGVOCURR19(2) WERTV10
UBPGVPRevaluation at retail, plus, at retail with tax MCW_UBPGVPCURR19(2) WERTV10
UBPVAZRevaluation at retail, plus, no. of transactions MCW_UBPVAZINT410MCZAEHLINT
UBMVPMRevaluation at retail, minus, quantity MCW_UBMVPMQUAN15(3) MENGV15_3
UBMGVORevaluation at retail, minus MCW_UBMGVOCURR19(2) WERTV10
UBMGVPRevaluation at retail, minus, at retail with tax MCW_UBMGVPCURR19(2) WERTV10
UBMVAZRevaluation at retail, minus, no. of transactions MCW_UBMVAZINT410MCZAEHLINT
ZUGMNGReceipts quantity in BUn MCW_ZUGMNGQUAN15(3) MENGV15_3
ZUGGEOReceipts at cost MCW_ZUGGEOCURR19(2) WERTV10
ZUGGVOReceipts at retail MCW_ZUGGVOCURR19(2) WERTV10
ZUGGVPReceipts at retail with tax MCW_ZUGGVPCURR19(2) WERTV10
ABGMNGIssues quantity in BUn MCW_ABGMNGQUAN15(3) MENGV15_3
ABGGEOIssues at cost MCW_ABGGEOCURR19(2) WERTV10
ABGGVOIssues at retail MCW_ABGGVOCURR19(2) WERTV10
ABGGVPIssues at retail with tax MCW_ABGGVPCURR19(2) WERTV10
WESMAOGoods receipt margin (vendor+GR(DC)) MCW_WESMAODEC6(2) PRZ32V
WESMAMGoods receipt margin with tax (vendor+GR(DC)) MCW_WESMAMDEC6(2) PRZ32V
UMSMAOSales margin MCW_UMSMAODEC6(2) PRZ32V
UMSMAMSales margin with tax MCW_UMSMAMDEC6(2) PRZ32V
BVLMAOOrder volume margin MCW_BVLMAODEC6(2) PRZ32V
BVLMAMOrder volume margin with tax MCW_BVLMAMDEC6(2) PRZ32V
BSTMAOStock margin MCW_BSTMAODEC6(2) PRZ32V
BSTMAMStock margin including tax MCW_BSTMAMDEC6(2) PRZ32V
RWMENGRange of coverage in days (quantity) MCW_RWMENGDEC7BCSP4
RWWERTRange of coverage in days (value) MCW_RWWERTDEC7BCSP4
UHMENGInventory turn (quantity) MCW_UHMENGDEC6(2) PRZ32V
UHWERTInventory turn (value) MCW_UHWERTDEC6(2) PRZ32V
JUMENGAnnual inventory turn (quantity) MCW_JUMENGDEC6(2) PRZ32V
JUWERTAnnual inventory turn (value) MCW_JUWERTDEC6(2) PRZ32V
GMROIOGross margin return on inventory investment MCW_GMROIODEC6(2) PRZ32V
GMROIMGross margin return on inventory investment with tax MCW_GMROIMDEC6(2) PRZ32V

Key field Non-key field



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

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

SELECT SINGLE *
FROM S085
INTO CORRESPONDING FIELDS OF WA_S085
WHERE...

How to access SAP table S085

Within an ECC or HANA version of SAP you can also view further information about S085 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!