S160 SAP (Perishables) Table details

Dictionary Type: Table
Description: Perishables




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




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

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

The S160 table consists of various fields, each holding specific information or linking keys about Perishables 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 S160 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
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
BTRKZPlant category VLFKZCHAR1VLFKZ
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
SATNRCross-Plant Configurable Material SATNRCHAR18MARAMATN1MATNR
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
HWAERLocal Currency HWAERCUKY5TCURCWAERS
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
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
RTEMNGReturns to vendor quantity in base unit of measure MCW_RTEMNGQUAN15(3) MENGV15_3
RTEGEOReturns to vendor at cost MCW_RTEGEOCURR19(2) WERTV10
RTEGVOReturns to vendor at retail MCW_RTEGVOCURR19(2) WERTV10
RTEGVPReturns to vendor at retail with tax MCW_RTEGVPCURR19(2) WERTV10
ULVMNGStock transport order quantity MCW_ULVMNGQUAN15(3) MENGV15_3
ULVGEOStock transport order at cost MCW_ULVGEOCURR19(2) WERTV10
ULVGVOStock transport order at retail MCW_ULVGVOCURR19(2) WERTV10
ULVGVPStock transport order at retail with tax MCW_ULVGVPCURR19(2) WERTV10
UAVMNGStock transport order 2 (supplying site view), quantity MCW_UAVMNGQUAN15(3) MENGV15_3
UAVGEOStock transport order 2 (supplying site view) at cost MCW_UAVGEOCURR19(2) WERTV10
UAVGVOStock transport order 2 (supplying site view) at retail MCW_UAVGVOCURR19(2) WERTV10
UAVGVPStock transport order 2 (supplying site view) at retail w/T MCW_UAVGVPCURR19(2) WERTV10
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
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
ULAMNGGoods clearing: issues quantity in BUn MCW_ULAMNGQUAN15(3) MENGV15_3
ULAGEOGoods clearing: issues at cost MCW_ULAGEOCURR19(2) WERTV10
ULAGVOGoods clearing: issues at retail MCW_ULAGVOCURR19(2) WERTV10
ULAGVPGoods clearing: issues at retail with tax MCW_ULAGVPCURR19(2) WERTV10
ULEMNGGoods clearing: receipts quantity in BUn MCW_ULEMNGQUAN15(3) MENGV15_3
ULEGEOGoods clearing: receipts at cost MCW_ULEGEOCURR19(2) WERTV10
ULEGVOGoods clearing: receipts at retail MCW_ULEGVOCURR19(2) WERTV10
ULEGVPGoods clearing: receipts at retail with tax MCW_ULEGVPCURR19(2) WERTV10
BKSMMGStock adjustment miscellaneous minus (quantity) MCW_BKSMMGQUAN15(3) MENGV15_3
BKSMEOStock adjustment miscellaneous minus (cost) MCW_BKSMEOCURR19(2) WERTV10
BKSMVOStock adjustment miscellaneous minus (retail) MCW_BKSMVOCURR19(2) WERTV10
BKSMVPStock adjustment miscellaneous minus (retail with tax) MCW_BKSMVPCURR19(2) WERTV10
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
KAVMNGSales order volume quantity MCW_KAVMNGQUAN15(3) MENGV15_3
KAVGEOSales order volume at cost MCW_KAVGEOCURR19(2) WERTV10
KAVGVOSales order volume at retail MCW_KAVGVOCURR19(2) WERTV10
KAVGVPSales order volume at retail with tax MCW_KAVGVPCURR19(2) WERTV10
LIFMNGDeliveries to customers, quantity MCW_LIFMNGQUAN15(3) MENGV15_3
ABTNRDepartment number ABTNRCHAR4TSABABTNR
MERK1Characteristic 1 MCW_MERK1CHAR30ATWRT
MERK2Characteristic 2 MCW_MERK2CHAR30ATWRT
MERK3Characteristic 3 MCW_MERK3CHAR30ATWRT
ATINM1Internal characteristic number, characteristic 1 MCW_ATINM1NUMC10Assigned to domainATINNATINN
ATINM2Internal characteristic number, characteristic 2 MCW_ATINM2NUMC10Assigned to domainATINNATINN
ATINM3Internal characteristic number, characteristic 3 MCW_ATINM3NUMC10Assigned to domainATINNATINN

Key field Non-key field



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

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

SELECT SINGLE *
FROM S160
INTO CORRESPONDING FIELDS OF WA_S160
WHERE...

How to access SAP table S160

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