SE11 ABAP Dictionary SE11 S011

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

S011

PURCHIS: Purchasing Group Statistics
SAP SAP Transparent Table 27 Fields
Primary Key:
MANDT SSOUR VRSIO SPMON SPTAG SPWOC SPBUP EKORG EKGRP LIFNR

Dictionary Fields Fields

(27 dari 27 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
EKGRP
KEY Pur. Group CHAR 3 - - Purchasing Group
10
LIFNR
KEY Vendor CHAR 10 - LFA1 Vendor Account Number
11
PERIV
- FY Variant CHAR 2 - - Fiscal Year Variant
12
VWDAT
- Pointer NUMC 10 - - Pointer to administrative data
13
HWAER
- Local Cur. CUKY 5 - - Local Currency
14
NETWR
- Order val. CURR 15 2 - Effective order value
15
REWRT
- Inv. amt. CURR 15 2 - Invoice Amount
16
ABEST
- POs DEC 9 - - No. of purchase orders
17
ABSTP
- PO items DEC 9 - - Number of purchase order items
18
ABSTE
- Ord.it.sch DEC 9 - - Number of purchase order item schedule lines
19
AANFR
- RFQs DEC 9 - - Number of requests for quotations
20
AANFP
- RFQ items DEC 9 - - Number of requests for quotation items
21
AANGP
- Qu. Items DEC 9 - - Number of Quotation Items
22
AKONT
- Contracts DEC 9 - - Number of contracts
23
AKONP
- ContrItems DEC 9 - - Number of contract items
24
ALFPL
- SchedAgrmt DEC 9 - - Number of scheduling agreements
25
ALFPP
- SchAgmtItm DEC 9 - - Number of scheduling agreement items
26
ALFPE
- Del.scheds DEC 9 - - Number of delivery schedules
27
ALIEF
- Deliveries DEC 9 - - Number of deliveries

Related References & SQL

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

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