S012 is a standard Data Collection Transparent Table in SAP Logistics application, which stores Purchasing 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 S012. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

S012 — Meta Data

Description: Purchasing
Main Category: Logistics
Sub Category: Data Collection
Table type: Transparent Table (TRANSP)

S012 — 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 LIFNR Vendor X CHAR 10 LFA1
    10 MATNR Material X CHAR 40 MARA
    11 WERKS Plant X CHAR 4 T001W
    12 ESOKZ Purchasing info record category X CHAR 1
    13 MATKL Material Group X CHAR 9 T023
    14 INFNR Number of purchasing info record X CHAR 10 EINA
    15 LAND1 Country X CHAR 3 T005
    16 PERIV Fi.Year Variant CHAR 2
    17 VWDAT Character Field Length = 10 NUMC 10
    18 BASME Base Unit of Measure UNIT 3 T006
    19 HWAER Local Currency CUKY 5 TCURC
    20 MENGE Quantity in base unit of measure QUAN 15
    21 WEMNG Purchase Order Quantity QUAN 15
    22 WEMGM Goods receipt qty in base unit (calculate wtd.delivery time) QUAN 15
    23 REMNG Purchase Order Quantity QUAN 15
    24 LSMNG Quantity in Unit of Measure from Delivery Note QUAN 15
    25 NETWR Net value CURR 15
    26 REWRT Invoice Value Entered (in Local Currency) CURR 15
    27 ABSTP Payment guarantee category DEC 9
    28 ABSTE Number of purchase order item schedule lines DEC 9
    29 AANFP Number of requests for quotation items DEC 9
    30 AANGP Number of Quotation Items DEC 9
    31 AKONP Number of contract items DEC 9
    32 ALFPP Number of scheduling agreement items DEC 9
    33 ALFPE Number of delivery schedules DEC 9
    34 ALIEF Deliveries DEC 9
    35 MABW1 Deviation 1 in the quantity delivered DEC 9
    36 MABW2 Variance 2 in the quantity delivered DEC 9
    37 MABW3 Variance 3 in the quantity delivered DEC 9
    38 MABW4 Variance 4 in the quantity delivered DEC 9
    39 MABW5 Variance 5 in the quantity delivered DEC 9
    40 TABW1 Delivery date variance 1 in days DEC 9
    41 TABW2 Delivery date variance 2 in days DEC 9
    42 TABW3 Delivery date variance 3 in days DEC 9
    43 TABW4 Delivery date variance 4 in days DEC 9
    44 TABW5 Delivery date variance 5 in days DEC 9
    45 LFZTA Total del.time DEC 13
    46 LFZTG Weighted total delivery time DEC 15
    47 MENGE_R Scheduled Quantity Rate QUAN 15
    48 REMNG_R Invoice receipt quantity of returns QUAN 15
    49 WEMNG_R Goods receipt quantity of returns QUAN 15
    50 REWRT_R Invoice amount: Returns CURR 15
    51 EFFWR_R Effective order value of returns CURR 15
    52 WEWRT Char 15 CURR 13
    53 REMNG_B Invoice receipt quantity as at posting date QUAN 15
    54 WEWRT_B Goods receipt value as at posting date CURR 15
    55 REWRT_B Invoice Amount as at Posting Date CURR 15
    56 REMNG_R_B IR quantity: Returns as at posting date QUAN 15
    57 REWRT_R_B IR value: Returns as at posting date CURR 15
    58 WEWRT_R_B GR value: Returns as at posting date CURR 15
    59 .INCLU--AP 0
    60 .INCLUDE 0
    61 .INCLUDE 0
    62 OIFEETOT Fee total CURR 13
    63 OIVATH Updated information in related user data field CURR 13
    64 OIVATF Updated information in related user data field CURR 13
    65 OITXCON1 Updated information in related user data field CURR 13
    66 OITXCON2 Updated information in related user data field CURR 13
    67 OITXCON3 Updated information in related user data field CURR 13
    68 OITXCON4 Updated information in related user data field CURR 13
    69 OITXCON5 Updated information in related user data field CURR 13
    70 OITXCON6 Updated information in related user data field CURR 13
    71 WAERS Currency CUKY 5 TCURC
    72 .INCLUDE 0
    73 OISMENGE Called-off/delivered/goods receipt quantity QUAN 13
    74 OIINTQTY Quantity scheduled to be exchanged QUAN 13
    75 OIMEINS Quantity schedule-related UoM UNIT 3 T006
    76 OIRECQTY Quantity intended against an exchange QUAN 13

SAP Help, Wiki Resources, and Forum Discussions on S012

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
EKPO Purchasing Document Item MM - Purchasing
S011 PURCHIS: Purchasing Group Statistics Logistics - Data Collection
S013 PURCHIS: Statistics for Vendor Evaluation Logistics - Data Collection
EKET Scheduling Agreement Schedule Lines MM - Purchasing
EKBE History per Purchasing Document MM - Purchasing
MARA General Material Data Logistics - Material Master
EKKN Account Assignment in Purchasing Document MM - Purchasing

Transaction Codes for SAP Table S012

TCODE Description Functional Area
ME21N Create Purchase Order MM - Purchasing
LBWE LO Data Ext.: Customizing Cockpit Logistics - Logistics Information System (LIS)
ME22N Change Purchase Order MM - Purchasing
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MCE3 PURCHIS: Vendor Analysis Selection MM - Purchasing Information System
MIGO Goods Movement MM - Inventory Management
MCE7 PURCHIS: Material Analysis Selection MM - Purchasing Information System
OLI3 PURCHIS Statistical Setup LO - Logistics Information System (LIS)

FMs for SAP Table S012

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
SD_DATETIME_DIFFERENCE Ermittlung der Differenz zwischen zwei Datums/Zeitwerten. Logistics Execution - Transportation
SSF_FUNCTION_MODULE_NAME Basis - Smart Forms
EXIT_SAPLRSAP_001 Customer Function Call f Basis - BW Service API
RV_DELIVERY_CREATE Erstellen Lieferungen im Sammelgang SD - Basic Functions
MCEX_UPDATE_03 Fortschreibung LIS-BW, Applikation MM LO - Logistics Information System (LIS)

ABAP Reports for SAP Table S012

ABAP REPORT Description Functional Area
RMCENEUA Statistical setup of info structures from purchasing documents MM - Purchasing Information System
RSM13005 Tool for Analyzing and Processing VB Request Basis - Client/Server Technology
CL_GUI_TOOLBAR================CP Create archiving object using transferred internal table
RMCSBWCC Check of Possible Error Sources in Extractor Changes Logistics - Logistics Information System (LIS)
CL_ABAP_TYPEDESCR=============CP Include LDMEE1_ABACIH
ABSOLETE Include RFMBL_REG_REPORT_CHECK_PERII01 PSM - Funds Management
CL_GOS_PUBLICATION============CP Create event
CL_GUI_CFW====================CP Places URL data in an internal table

BW Datasources for SAP Table S012

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_S012 Purchasing MM - Materials Management
2LIS_02_S013 Vendor Evaluation MM - Materials Management
2LIS_01_S001 Customer SD - Sales and Distribution
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution
2LIS_01_S005 Shipping point SD - Sales and Distribution

Authorization Objects for SAP Table S012

AUTHORIZATION OBJECT Description Functional Area
J_1IRG23D Authorisation object for Depo Transactions
C_VKORG Transfer of Sales Organization Data