SE11 ABAP Dictionary SE11 S013

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

S013

PURCHIS: Statistics for Vendor Evaluation
SAP SAP Transparent Table 31 Fields
Primary Key:
MANDT SSOUR VRSIO SPMON SPTAG SPWOC SPBUP EKORG LIFNR MATNR WERKS ESOKZ INFNR

Dictionary Fields Fields

(31 dari 31 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
EKORG
KEY Purch.Org. CHAR 4 - - Purchasing Organization
9
LIFNR
KEY Vendor CHAR 10 - LFA1 Vendor Account Number
10
MATNR
KEY Material CHAR 18 - MARA Material Number
11
WERKS
KEY Plant CHAR 4 - T001W Plant
12
ESOKZ
KEY Infotype CHAR 1 - - Purchasing info record category
13
INFNR
KEY Info Rec. CHAR 10 - - Number of Purchasing Info Record
14
PERIV
- FY Variant CHAR 2 - - Fiscal Year Variant
15
VWDAT
- Pointer NUMC 10 - - Pointer to administrative data
16
PWMT1
- Qty. rl. 1 DEC 3 - - Points score 1 for quantity reliability
17
PWMT2
- Qty. rl. 2 DEC 3 - - Points score 2 for quantity reliability
18
PWTT1
- On-t.del.1 DEC 3 - - Points score 1 for on-time delivery performance
19
PWTT2
- On-t.del.2 DEC 3 - - Points score 2 for on-time delivery performance
20
PWEV1
- CShp.ins.1 DEC 3 - - Points score 1 for compliance with shipping instructions
21
PWEV2
- CShp.ins.2 DEC 3 - - Point score 2 for compliance with shipping instructions
22
PWWE1
- Srv.qual.1 DEC 3 - - Points score 1 for service quality
23
PWWE2
- Srv.qual.2 DEC 3 - - Points score 2 for quality of service
24
PWFR1
- Srv. tm. 1 DEC 3 - - Points score 1 for service timeliness
25
PWFR2
- Srv. tm. 2 DEC 3 - - Points score 2 for service timeliness
26
PWQA1
- QA score 1 DEC 3 - - Points score 1 for quality audit
27
PWQA2
- QA score 2 DEC 3 - - Points score 2 for quality audit
28
LAVI1
- Ship.not.1 DEC 3 - - Points score 1: Shipping notification
29
LAVI2
- Ship.not.2 DEC 3 - - Points score 2: Shipping notification
30
ALAV1
- VarShpNot1 DEC 3 - - Points score 1: Variance from shipping notification
31
ALAV2
- VarShpNot2 DEC 3 - - Points score 2: Variance from shipping notification

Related References & SQL

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

Interactive ERD Diagrams
SAP MM - Goods Receipt Relation →
Standard T-Codes
SE11 SE16
Related Tables
LFA1 MARA T001W MKPF MSEG EKBE MVER S031
ANSI SQL Query 
SELECT a.SSOUR,
       a.VRSIO,
       a.SPMON,
       a.SPTAG,
       a.SPWOC,
       a.SPBUP,
       a.EKORG
FROM S013 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~ekorg
  FROM s013 AS a
  WHERE a~ssour = '0001'
  and a~vrsio = '0001'
  INTO TABLE @DATA(lt_s013)
  UP TO 100 ROWS.