SE11 ABAP Dictionary SE11 S031

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

S031

Statistics: Movements for current stocks
SAP SAP Transparent Table 37 Fields
Primary Key:
MANDT SSOUR VRSIO SPMON SPTAG SPWOC SPBUP WERKS MATNR LGORT

Dictionary Fields Fields

(37 dari 37 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
SSOUR
KEY Source CHAR 4 - - Statistic(s) origin
3
VRSIO
KEY Version CHAR 3 - - Version number in the information structure
4
SPMON
KEY Month NUMC 6 - - Period to analyze - month
5
SPTAG
KEY Date DATS 8 - - Period to analyze - current date
6
SPWOC
KEY Week NUMC 6 - - Period to analyze - week
7
SPBUP
KEY Period NUMC 6 - - Period to analyze - posting period
8
WERKS
KEY Plant CHAR 4 - T001W Plant
9
MATNR
KEY Material CHAR 18 - MARA Material Number
10
LGORT
KEY Stor. Loc. CHAR 4 - T001L Storage Location
11
PERIV
- FY Variant CHAR 2 - - Fiscal Year Variant
12
VWDAT
- Pointer NUMC 10 - - Pointer to administrative data
13
BASME
- Unit UNIT 3 - - Base Unit of Measure
14
HWAER
- Currency CUKY 5 - - Currency Key
15
MZUBB
- Val.stk(R) QUAN 15 3 - Valuated stock receipts quantity
16
WZUBB
- VlStkRcVal CURR 15 2 - Valuated stock receipts value
17
AZUBB
- NoValStRec DEC 9 - - Number of times that valuated stock has been received
18
MZUKB
- CnsStckRec QUAN 15 3 - Consignment stock receipts quantity
19
AZUKB
- NoCnsRecs DEC 9 - - Number of times that consignment stock has been received
20
MAGBB
- Val.stk(I) QUAN 15 3 - Quantity of valuated stock issues
21
WAGBB
- VlStkIssVl CURR 15 2 - Value of valuated stock that has been issued
22
AAGBB
- No.iss.VS DEC 9 - - Number of times valuated stock has been issued
23
MAGKB
- CnsStckIss QUAN 15 3 - Quantity of consignment stock that has been issued
24
AAGKB
- NoCnsgtIss DEC 9 - - Number of times consignment stock has been issued
25
AMBWG
- NoMatMvmts DEC 9 - - Number of material movements
26
MGVBR
- Tot. usage QUAN 15 3 - Total usage quantity
27
WGVBR
- Tot.us.val CURR 15 2 - Total usage value
28
AGVBR
- NoTotUsage DEC 9 - - Number of times that total usage has been updated
29
MUVBR
- Unpl.usage QUAN 15 3 - Unplanned usage quantity
30
WUVBR
- Unpl.usage CURR 15 2 - Unplanned usage value
31
AUVBR
- NoUnplUsag DEC 9 - - Number of times an unplanned usage has been recorded
32
ASTOR
- NoCancels DEC 9 - - Number of cancelation documents to date
33
BBNULL
- NoVlStZero DEC 9 - - Number of times that valuated stock was zero
34
KBNULL
- NoCnsZero DEC 9 - - Number of times that consignment stock was zero
35
GBNULL
- NoTtStZero DEC 9 - - Number of times that total stock was zero
36
BESZUG
- StckLvlGdR QUAN 15 3 - Stock level at goods receipt
37
WBESZUG
- ValStkGdsR CURR 15 2 - Value of stock at goods receipt

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk S031.

Interactive ERD Diagrams
SAP MM - Goods Receipt Relation →
Standard T-Codes
SE11 SE16
Related Tables
T001W MARA T001L MKPF MSEG EKBE MVER S011
ANSI SQL Query 
SELECT a.SSOUR,
       a.VRSIO,
       a.SPMON,
       a.SPTAG,
       a.SPWOC,
       a.SPBUP,
       a.WERKS
FROM S031 AS a
WHERE a.SSOUR = '0001'
  AND a.VRSIO = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~ssour,
       a~vrsio,
       a~spmon,
       a~sptag,
       a~spwoc,
       a~spbup,
       a~werks
  FROM s031 AS a
  WHERE a~ssour = '0001'
  and a~vrsio = '0001'
  INTO TABLE @DATA(lt_s031)
  UP TO 100 ROWS.