S124 SAP (Customer / material) Table details

Dictionary Type: Table
Description: Customer / material




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




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

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

The S124 table consists of various fields, each holding specific information or linking keys about Customer / material 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 S124 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
KUNAGSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
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
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
KAVANZSales order volume number of transactions MCW_KAVANZINT410MCZAEHLINT
RAVMNGReturn orders quantity MCW_RAVMNGQUAN15(3) MENGV15_3
RAVGEOReturn orders at cost MCW_RAVGEOCURR19(2) WERTV10
RAVGVOReturn orders at retail MCW_RAVGVOCURR19(2) WERTV10
RAVGVPReturn orders at retail with tax MCW_RAVGVPCURR19(2) WERTV10
RAVANZReturn orders, no. of transactions MCW_RAVANZINT410MCZAEHLINT
SAVMNGThird-party orders quantity MCW_SAVMNGQUAN15(3) MENGV15_3
SAVGEOThird-party orders at cost MCW_SAVGEOCURR19(2) WERTV10
SAVGVOThird party orders at retail MCW_SAVGVOCURR19(2) WERTV10
SAVGVPThird-party orders at retail with tax MCW_SAVGVPCURR19(2) WERTV10
SAVANZThird-party order, no. of transactions MCW_SAVANZINT410MCZAEHLINT
LIFMNGDeliveries to customers, quantity MCW_LIFMNGQUAN15(3) MENGV15_3
LIFANZDeliveries to customers, no. of transactions MCW_LIFANZINT410MCZAEHLINT
RLFMNGReturn deliveries from customer, quantity MCW_RLFMNGQUAN15(3) MENGV15_3
RLFANZReturn deliveries from customer, no. of transactions MCW_RLFANZINT410MCZAEHLINT
OAVMNGOn-order quantity IS-R MCW_OAVMNGQUAN15(3) MENGV15_3
OAVWRTOn-order value IS-R MCW_OAVWRTCURR19(2) WERTV10
UMAMNGSales (absolute) quantity in BUn MCW_UMAMNGQUAN15(3) MENGV15_3
UMAGEOSales (absolute) at cost MCW_UMAGEOCURR19(2) WERTV10
UMAGVOSales (absolute) at retail MCW_UMAGVOCURR19(2) WERTV10
UMAGVPSales (absolute) at retail with tax MCW_UMAGVPCURR19(2) WERTV10
PRSNLASales deviation (absolute) during sales MCW_PRSNLACURR19(2) WERTV10
AUMMNGPromotion sales quantity in BUn MCW_AUMMNGQUAN15(3) MENGV15_3
AUMGEOPromotion sales at cost MCW_AUMGEOCURR19(2) WERTV10
AUMGVOPromotion sales at retail MCW_AUMGVOCURR19(2) WERTV10
AUMGVPPromotion sales at retail with tax MCW_AUMGVPCURR19(2) WERTV10
GUTMNGCredit memo quantity in BUn MCW_GUTMNGQUAN15(3) MENGV15_3
GUTGEOCredit memo at cost MCW_GUTGEOCURR19(2) WERTV10
GUTGVOCredit memo at retail MCW_GUTGVOCURR19(2) WERTV10
GUTGVPCredit memo at retail with tax MCW_GUTGVPCURR19(2) WERTV10
GUTNLSCredit memo deviation at sale MCW_GUTNLSCURR19(2) WERTV10
UMSMNGThird-party sales quantity in BUn MCW_SUMMNGQUAN15(3) MENGV15_3
UMSGEOThird-party sales at cost MCW_SUMGEOCURR19(2) WERTV10
UMSGVOThird-party sales at retail MCW_SUMGVOCURR19(2) WERTV10
UMSGVPThird-party sales at retail with tax MCW_SUMGVPCURR19(2) WERTV10
PRSNLSThird-party sales deviation MCW_SPRSNLCURR19(2) WERTV10
KAVMAMSales order volume margin with tax MCW_KAVMAMDEC6(2) PRZ32V
KAVMAOSales order volume margin MCW_KAVMAODEC6(2) PRZ32V
SAVMAMThird-party order margin w/tax MCW_SAVMAMDEC6(2) PRZ32V
SAVMAOThird-party order margin MCW_SAVMAODEC6(2) PRZ32V
UMSMAOSales margin MCW_UMSMAODEC6(2) PRZ32V
UMSMAMSales margin with tax MCW_UMSMAMDEC6(2) PRZ32V
AUMMAOPromotion sales margin MCW_AUMMAODEC6(2) PRZ32V
AUMMAMPromotion sales margin with tax MCW_AUMMAMDEC6(2) PRZ32V
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
KUNRGPayer KUNRGCHAR10KNA1ALPHAKUNNR
KDGRPCustomer group KDGRPCHAR2T151KDGRPVKD
ASCARAssortment ASORTCHAR10Assigned to domainALPHAASORTWSTWSOR

Key field Non-key field



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

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

SELECT SINGLE *
FROM S124
INTO CORRESPONDING FIELDS OF WA_S124
WHERE...

How to access SAP table S124

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