S086 SAP (Promotion) Table details

Dictionary Type: Table
Description: Promotion




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




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

S086 is a standard SAP Table which is used to store Promotion data and is available within R/3 SAP systems depending on the version and release level.

The S086 table consists of various fields, each holding specific information or linking keys about Promotion 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 S086 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
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BTRKZPlant category VLFKZCHAR1VLFKZ
WGRU2Material group hierarchy 2 MCW_WGRU2CHAR18KLASSEWGRU2
WGRU1Material group hierarchy 1 MCW_WGRU1CHAR18KLASSEWGRU1
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
AKTYPPromotion Category W_AKTYPCHAR4TWTYAKTTY
AKTHEPromotion theme W_AKTHECHAR4TWATTHEMA
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
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

Key field Non-key field



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

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

SELECT SINGLE *
FROM S086
INTO CORRESPONDING FIELDS OF WA_S086
WHERE...

How to access SAP table S086

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