S011 is a standard Data Collection Transparent Table in SAP Logistics application, which stores PURCHIS: Purchasing Group Statistics data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for S011. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
S011 — Meta Data
Description: | PURCHIS: Purchasing Group Statistics |
Main Category: | Logistics |
Sub Category: | Data Collection |
Table type: | Transparent Table (TRANSP) |
S011 — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | SSOUR | Statistic(s) origin | X | CHAR | 4 | |
3 | VRSIO | Version | X | CHAR | 3 | * |
4 | SPMON | Calendar year / month | X | NUMC | 6 | |
5 | SPTAG | Calendar day | X | DATS | 8 | |
6 | SPWOC | Calendar year / week | X | NUMC | 6 | |
7 | SPBUP | Fiscal year / period | X | NUMC | 6 | |
8 | EKORG | Purchasing Org. | X | CHAR | 4 | T024E |
9 | EKGRP | Purch. Group | X | CHAR | 3 | T024 |
10 | LIFNR | Vendor | X | CHAR | 10 | LFA1 |
11 | PERIV | Fi.Year Variant | CHAR | 2 | T009 | |
12 | VWDAT | Character Field Length = 10 | NUMC | 10 | ||
13 | HWAER | Local Currency | CUKY | 5 | TCURC | |
14 | NETWR | Net value | CURR | 15 | ||
15 | REWRT | Invoice Value Entered (in Local Currency) | CURR | 15 | ||
16 | ABEST | No. of purchase orders | DEC | 9 | ||
17 | ABSTP | Payment guarantee category | DEC | 9 | ||
18 | ABSTE | Number of purchase order item schedule lines | DEC | 9 | ||
19 | AANFR | Number of requests for quotations | DEC | 9 | ||
20 | AANFP | Number of requests for quotation items | DEC | 9 | ||
21 | AANGP | Number of Quotation Items | DEC | 9 | ||
22 | AKONT | Recon. account | DEC | 9 | ||
23 | AKONP | Number of contract items | DEC | 9 | ||
24 | ALFPL | Number of scheduling agreements | DEC | 9 | ||
25 | ALFPP | Number of scheduling agreement items | DEC | 9 | ||
26 | ALFPE | Number of delivery schedules | DEC | 9 | ||
27 | ALIEF | Deliveries | DEC | 9 |
SAP Help, Wiki Resources, and Forum Discussions on S011
-
Enhancing S011 with bukrs | SCN
Hi, i need to add the bukrs (Company code) to the structure S011 (purchasing), i have the fields LIFNR (Vendor), EKORG (purchasing org.) and EKGRP (purchasing group), and i need to get the bukrs using this fields, i tried with lfb1, but every vendor has more than one company code (bukrs), any ideas??
http://scn.sap.com/message/7837827
-
How to populate the data in purchasing LIS tables - S011 and S012
While Running the report mc$g, I am not getting the values into invoice column. Please let me know if there is any setting I need to do in IMG to populate the invoice data.
http://scn.sap.com/message/7876589
-
Problem in updating of standard database tables( S011, S012, S013).
Hi Gurus,
Here i am having the problem with these transactions MCE1, MCE3, MCE5,
MCE7.
In these t-codes we are not able to get Purchase Order Values... Please
help me out from this ... To get the PO Value what should i do ....
there PO values are showing '0.00' (Zero)..
These t-codes are using S011, S012, S013 tables, in those tables also
PO ...
http://scn.sap.com/message/3987376
-
2LIS_02_S011 | SCN
Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...
http://scn.sap.com/message/4113657
Related Tables
TABLE | Description | Functional Area |
---|---|---|
S012 | Purchasing | Logistics - Data Collection |
S013 | PURCHIS: Statistics for Vendor Evaluation | Logistics - Data Collection |
EKPO | Purchasing Document Item | MM - Purchasing |
EKBE | History per Purchasing Document | MM - Purchasing |
EKET | Scheduling Agreement Schedule Lines | MM - Purchasing |
S031 | Statistics: Movements for current stocks | Logistics - Data Collection |
S015 | Subsequent Settlement: Evaluation | Logistics - Data Collection |
Transaction Codes for SAP Table S011
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
LBWE | LO Data Ext.: Customizing Cockpit | Logistics - Logistics Information System (LIS) |
MIGO | Goods Movement | MM - Inventory Management |
MCE1 | PURCHIS: PurchGrp Analysis Selection | MM - Purchasing Information System |
RSA3 | Extractor Checker | Basis - BW Service API |
MCE3 | PURCHIS: Vendor Analysis Selection | MM - Purchasing Information System |
OMO2 | Update Maintenance: PURCHIS | LO - Logistics Information System (LIS) |
ME21N | Create Purchase Order | MM - Purchasing |
FMs for SAP Table S011
FM | Description | Functional Area |
---|---|---|
CONVERSION_EXIT_PDATE_OUTPUT | Conversion Exit for Domain GBDAT: YYYYMMDD -> DD/MM/YYYY | Cross Application - Cross-Application Objects in HR |
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
DATE_CHECK_PLAUSIBILITY | Date plausibility check | 30A - Communication Services: Mail |
EXIT_SAPMC29C_005 | ECH: Check Before Saving the Change Number | Cross Application - Engineering Change Management |
GUI_UPLOAD | Upload for Data Provider | Basis - Graphical User Interface |
PA_GET_SUPER_PACKAGE_NAME | Direkt umfassendes Paket ermitteln | Basis - Package Tools |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
ABAP Reports for SAP Table S011
ABAP REPORT | Description | Functional Area |
---|---|---|
RMCENEUA | Statistical setup of info structures from purchasing documents | MM - Purchasing Information System |
CL_GOS_PUBLICATION============CP | Create event | |
CL_GUI_CFW====================CP | Places URL data in an internal table | |
CL_GUI_TOOLBAR================CP | Create archiving object using transferred internal table | |
RKPEP000 | Project line items | Project Systems - Accounting |
CL_ABAP_TYPEDESCR=============CP | Include LDMEE1_ABACIH | |
RKPEP004 | Display Project Planned Cost Line Items | Project Systems - Accounting |
SAPLCCCONV | Konvertierungsexits |
BW Datasources for SAP Table S011
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_02_ITM | Purchasing Data (Item Level) | MM - Materials Management |
2LIS_02_SCL | Purchasing Data (Schedule Line Level) | MM - Materials Management |
2LIS_02_HDR | Purchasing Data (Header Level) | MM - Materials Management |
2LIS_02_S011 | Purchasing groups | MM - Materials Management |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_01_S001 | Customer | SD - Sales and Distribution |
2LIS_43_POSCAS | POS Data: Cashier | IS - Retail |
2LIS_02_CGR | Produced Activity: Delivery of Confirmations | MM - Materials Management |
Authorization Objects for SAP Table S011
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_LFA1_BEK | Vendor: Account Authorization | |
G_800_GRP | Report Writer: Report | |
M_MSEG_BWE | Goods Receipt for Purchase Order: Movement Type | |
M_BEST_BSA | Document Type in Purchase Order | |
S_BTCH_ADM | Background Processing: Background Administrator | |
S_LOG_COM | Authorization to Execute Logical Operating System Commands | |
S_USER_AUT | User Master Maintenance: Authorizations |
Most searched SAP Logistics - General Tables
- Material Master Tables
- Handling Unit Tables
- Bom Tables
- Material Document Tables
- Storage Location Tables
- Material Group Tables
- Serial Number Tables
- Batch Tables
- Material Type Tables
- Inventory Tables
- Valuation Class Tables
- Plant Storage Location Tables
- Master Data Tables
- Physical Inventory Tables
- Customer Master Contact Person Tables
- Stock Tables
- Distribution Channel Tables
- Bom Component Tables
- Material Status Tables
- Product Group Tables
- Mara Tables
- Se16 Tables List Tables