SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

S123 Table in SAP | Customer / material group Table & Fields List

S123 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S123 in SAP.

  • Table description : Customer / material group
  • Module : CRM
  • Parent Module : CRM
  • Package : MCS
  • Software Component : BBPCRM
S123 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP S123 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SSOURStatistic(s) originSSOURSSOUR
VRSIOVersion number in the information structureVRSIOVRSIO
SPMONPeriod to analyze - monthSPMONMCPERIOD
SPTAGPeriod to analyze - current dateSPTAGDATUM
SPWOCPeriod to analyze - weekSPWOCMCPERIOD
SPBUPPeriod to analyze - posting periodSPBUPMCPERIOD
EKORGPurchasing organizationEKORGEKORG
VKORGSales OrganizationVKORGVKORG
VTWEGDistribution ChannelVTWEGVTWEG
BZIRKSales districtBZIRKBZIRK
WERKSPlantWERKS_DWERKS
KUNAGSold-to partyKUNAGKUNNR
WGRU2Material group hierarchy 2MCW_WGRU2KLASSE
WGRU1Material group hierarchy 1MCW_WGRU1KLASSE
MATKLMaterial GroupMATKLMATKL
PERIVFiscal Year VariantPERIVPERIV
VWDATPointer to administrative dataVWDATVWDAT
BASMEBase Unit of MeasureMEINSMEINS
HWAERLocal CurrencyHWAERWAERS
KAVMNGSales order volume quantityMCW_KAVMNGMENGV15_3
KAVGEOSales order volume at costMCW_KAVGEOWERTV10
KAVGVOSales order volume at retailMCW_KAVGVOWERTV10
KAVGVPSales order volume at retail with taxMCW_KAVGVPWERTV10
KAVANZSales order volume number of transactionsMCW_KAVANZMCZAEHLINT
RAVMNGReturn orders quantityMCW_RAVMNGMENGV15_3
RAVGEOReturn orders at costMCW_RAVGEOWERTV10
RAVGVOReturn orders at retailMCW_RAVGVOWERTV10
RAVGVPReturn orders at retail with taxMCW_RAVGVPWERTV10
RAVANZReturn orders, no. of transactionsMCW_RAVANZMCZAEHLINT
SAVMNGThird-party orders quantityMCW_SAVMNGMENGV15_3
SAVGEOThird-party orders at costMCW_SAVGEOWERTV10
SAVGVOThird party orders at retailMCW_SAVGVOWERTV10
SAVGVPThird-party orders at retail with taxMCW_SAVGVPWERTV10
SAVANZThird-party order, no. of transactionsMCW_SAVANZMCZAEHLINT
LIFMNGDeliveries to customers, quantityMCW_LIFMNGMENGV15_3
LIFANZDeliveries to customers, no. of transactionsMCW_LIFANZMCZAEHLINT
RLFMNGReturn deliveries from customer, quantityMCW_RLFMNGMENGV15_3
RLFANZReturn deliveries from customer, no. of transactionsMCW_RLFANZMCZAEHLINT
OAVMNGOn-order quantity IS-RMCW_OAVMNGMENGV15_3
OAVWRTOn-order value IS-RMCW_OAVWRTWERTV10
UMAMNGSales (absolute) quantity in BUnMCW_UMAMNGMENGV15_3
UMAGEOSales (absolute) at costMCW_UMAGEOWERTV10
UMAGVOSales (absolute) at retailMCW_UMAGVOWERTV10
UMAGVPSales (absolute) at retail with taxMCW_UMAGVPWERTV10
PRSNLASales deviation (absolute) during salesMCW_PRSNLAWERTV10
AUMMNGPromotion sales quantity in BUnMCW_AUMMNGMENGV15_3
AUMGEOPromotion sales at costMCW_AUMGEOWERTV10
AUMGVOPromotion sales at retailMCW_AUMGVOWERTV10
AUMGVPPromotion sales at retail with taxMCW_AUMGVPWERTV10
GUTMNGCredit memo quantity in BUnMCW_GUTMNGMENGV15_3
GUTGEOCredit memo at costMCW_GUTGEOWERTV10
GUTGVOCredit memo at retailMCW_GUTGVOWERTV10
GUTGVPCredit memo at retail with taxMCW_GUTGVPWERTV10
GUTNLSCredit memo deviation at saleMCW_GUTNLSWERTV10
UMSMNGThird-party sales quantity in BUnMCW_SUMMNGMENGV15_3
UMSGEOThird-party sales at costMCW_SUMGEOWERTV10
UMSGVOThird-party sales at retailMCW_SUMGVOWERTV10
UMSGVPThird-party sales at retail with taxMCW_SUMGVPWERTV10
PRSNLSThird-party sales deviationMCW_SPRSNLWERTV10
KAVMAMSales order volume margin with taxMCW_KAVMAMPRZ32V
KAVMAOSales order volume marginMCW_KAVMAOPRZ32V
SAVMAMThird-party order margin w/taxMCW_SAVMAMPRZ32V
SAVMAOThird-party order marginMCW_SAVMAOPRZ32V
UMSMAOSales marginMCW_UMSMAOPRZ32V
UMSMAMSales margin with taxMCW_UMSMAMPRZ32V
AUMMAOPromotion sales marginMCW_AUMMAOPRZ32V
AUMMAMPromotion sales margin with taxMCW_AUMMAMPRZ32V
KUNRGPayerKUNRGKUNNR
KDGRPCustomer groupKDGRPKDGRP

S123 related tables

TableNote
A266Standard Dummy Customer/Material Group/Material Number
WRF_PRICAT_002Assign External Material Group - SAP Material Group
A265Standard Dummy Customer/Document Type/Material Grp/Material
A101SOrg/DstCh/Material-Main Item/Material Pricing Group
A102SOrg/DstCh/Material Pricing Group-Main Item/Material
MVGDMaterial master/product group material version
OIRAMATHANDGRPMaterial handling group material assignment (IS-Oil SSR)
T023SBase Material Group/Hierarchy Material Assignment
A030Customer/Material Pricing Group
A256Customer/Catalog Group 2/Material
A277Standard Dummy Customer/Document Type/Material Group
MSR_C_INSPCATCUSCatalog and Code Group for Material Inspection by Customer
S123Customer / material group
A031Price Group/Material Pricing Group
J_3R_INVDIFFMATMaterial group assignment to group of inventory difference
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com