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

S039 Table in SAP | Statistics: Inventory Controlling Table & Fields List

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

  • Table description : Statistics: Inventory Controlling
  • Module : CRM
  • Parent Module : CRM
  • Package : MCS
  • Software Component : BBPCRM
S039 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 S039 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
WERKSPlantWERKS_DWERKS
MATNRMaterial NumberMATNRMATNR
LGORTStorage locationLGORT_DLGORT
DISPOMRP controllerDISPODISPO
DISMMMRP TypeDISMMDISMM
MTARTMaterial typeMTARTMTART
MATKLMaterial GroupMATKLMATKL
GSBERBusiness AreaGSBERGSBER
SPARTDivisionSPARTSPART
PERIVFiscal Year VariantPERIVPERIV
VWDATPointer to administrative dataVWDATVWDAT
BASMEBase Unit of MeasureMEINSMEINS
HWAERCurrency KeyWAERSWAERS
MZUBBValuated stock receipts quantityMZUBBMENGV15
WZUBBValuated stock receipts valueWZUBBWERT15
AZUBBNumber of times that valuated stock has been receivedAZUBBANZAHL
MZUKBConsignment stock receipts quantityMZUKBMENGV15
AZUKBNumber of times that consignment stock has been receivedAZUKBANZAHL
MAGBBQuantity of valuated stock issuesMAGBBMENGV15
WAGBBValue of valuated stock that has been issuedWAGBBWERT15
AAGBBNumber of times valuated stock has been issuedAAGBBANZAHL
MAGKBQuantity of consignment stock that has been issuedMAGKBMENGV15
AAGKBNumber of times consignment stock has been issuedAAGKBANZAHL
AMBWGNumber of material movementsAMBWGANZAHL
MGVBRTotal usage quantityGVBRMMENGV15
WGVBRTotal usage valueWGVBRWERT15
AGVBRNumber of times that total usage has been updatedAGVBRANZAHL
MUVBRUnplanned usage quantityUVBRMMENGV15
WUVBRUnplanned usage valueWUVBRWERT15
AUVBRNumber of times an unplanned usage has been recordedAUVBRANZAHL
ASTORNumber of cancelation documents to dateASTORANZAHL
BBNULLNumber of times that valuated stock was zeroBBNULLANZAHL
KBNULLNumber of times that consignment stock was zeroKBNULLANZAHL
GBNULLNumber of times that total stock was zeroGBNULLANZAHL
.INCLUDEAdditional Key Figures in Inventory Controlling    
MBWBESTQuantity of valuated stockMBWBESTMENGV15
WBWBESTValue of valuated stockWBWBESTWERT15
MKOBESTQuantity of consignment stockMKOBESTMENGV15
DZUBBAverage valuated stock receipts quantityDZUBBMENGV15
DZWBBAverage valuated stock receipts valueDZWBBWERT15
DAGBBAverage quantity of valuated stock issuesDAGBBMENGV15
DAWBBAverage valuated stock issues valueDAWBBWERT15
DZUKBAverage consignment stock receipts quantityDZUKBMENGV15
DAGKBAverage quantity of consignment stock that has been issuedDAGKBMENGV15
DGVBRAverage consumptionDGVBRMENGV15
GSBESTTotal stockGSBESTMENGV15
RWGSBESTRange of coverage of total stockRWGSBESTBCSP4
RWKOBESTRange of coverage of consignment stockRWKOBESTBCSP4
RWBEWBESTRange of coverage of valuated stockRWBEWBESTBCSP4
UHGSBESTTurnover of total stockUHGESBESTBCSP4
UHBWBESTTurnover of valuated stockUHBWBESTBCSP4
UHKOBESTTurnover of consignment stockUHKOBESTBCSP4
DBWBESTAverage quantity of valuated stockDBWBESTMENGV15
DKOBESTAverage quantity of consignment stockDKOBESTMENGV15
DGSBESTAverage quantity of total stockDGSBESTMENGV15
DWBWBESTAverage valuated stock valueDWBWBESTWERT15
DRWBWBESTAverage range of coverage of valuated stockDRWBWBESTBCSP4
DRWKOBESTAverage range of coverage of consignment stockDRWKOBESTBCSP4
DRWGSBESTAverage range of coverage of total stockDRWGSBESTBCSP4
DUHBWBESTAverage inventory turnover of valuated stockDUHBWBESTBCSP4
DUHKOBESTAverage turnover of consignment stockDUHKOBESTBCSP4
DUHGSBESTAverage turnover of total stockDUHGSBESTBCSP4
DWGVBRValue of average total usageDWGVBRWERT15
DUVBRAverage unplanned usage quantityDUVBRMENGV15
DWUVBRAverage unplanned usage valueDWUVBRWERT15
UHWBWBESTInventory turnover (value-based) of valuated stockUHWBWBESTBCSP4
UHWGSBESTInventory turnover (value-based) of total stockUHWGSBESTBCSP4
DUHWGSBESTAverage turnover (value-based) of total stockDUHWGSBESTBCSP4
DUHWBWBESTAverage turnover (value-based) of valuated stockDUHWBWBESTBCSP4
JUHWGSBESTAnnual inventory turnover (value-based) of total stockJUHWGSBESTBCSP4
JUHWBWBESTAnnual inventory turnover (value-based) of valuated stockJUHWBWBESTBCSP4
JUHGSBESTAnnual inventory turnover (quantity-based) of total stockJUHGSBESTBCSP4
JUHKOBESTAnnual turnover (quantity-based) of consignment stockJUHKOBESTBCSP4
JUHBWBESTAnnual inventory turnover of valuated stockJUHBWBESTBCSP4
RWWGSBESTRange of coverage (value-based) of total stockRWWGSBESTBCSP4
RWWBWBESTRange of coverage (value-based) of valuated stockRWWBWBESTBCSP4
DRWWGSBESTAverage range of coverage (value-based) of total stockDRWWGSBESTBCSP4
DRWWBWBESTAverage range of coverage (value-based) of valuated stockDRWWBWBESTBCSP4
LETZTZUGDate: Last ReceiptLETZTZUGDATS
LETZTABGDate: last (i.e. most recent) goods issueLETZTABGDATS
LETZTVERDate: last (i.e. most recent) consumptionLETZTVERDATS
LETZTBEWDate: last (i.e. most recent) goods movementLETZTBEWDATS
EISBESafety stockMC_EISBEMENGV15
BESZUGStock level at goods receiptBESZUGMENGV15
WBESZUGValue of stock at goods receiptWBESZUGWERT15
BKLASValuation ClassBKLASBKLAS

S039 related tables

TableNote
S039Statistics: Inventory Controlling
CON_FIN_TACTIVE2Activate Inventory Accounting in Controlling Area
S200Inventory Controlling Stores
/SAPHT/DRMFIFINVDRM Inventory Reconciliation FIFO Inventory
/SAPHT/DRMREPINVDRM Inventory Reconciliation Reported Inventory
TNS06IS-H: Switch for controlling the statistics transfer
CNVCDMCUCIA_STATStatistics data collected from the Statistics system
ESH_QL_ST_STATSearchterm Statistics Table for Indexing of Statistics Data
A026Controlling Area/Cost Center
A027Controlling Area
A058Controlling Area/Cost Center Type
A059Controlling Area/Company Code
A060Controlling Area/Business Area
A061Controlling Area/Cost Center Type/Cost Center
A062Controlling Area/Company Code/Cost Center
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