1. Home
  2. Resources
  3. SAP Tables
  4. S012 - Purchasing

SAP Table S012

Purchasing

S012 (Purchasing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link S012 to other SAP tables.

S012 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SSOUR Statistic(s) origin SSOUR CHAR 4 0
VRSIO Version number in the information structure VRSIO CHAR 3 0
SPMON Period to analyze - month SPMON NUMC 6 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
SPWOC Period to analyze - week SPWOC NUMC 6 0
SPBUP Period to analyze - posting period SPBUP NUMC 6 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant EWERK T001W CHAR 4 0
ESOKZ Purchasing info record category ESOKZ CHAR 1 0
0 Standard
2 Consignment
3 Subcontracting
P Pipeline
1 Chargeable
MATKL Material Group MATKL T023 CHAR 9 0
INFNR Number of Purchasing Info Record INFNR EINA CHAR 10 0
LAND1 Country key of vendor MCLANDL T005 CHAR 3 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
VWDAT Pointer to administrative data VWDAT NUMC 10 0
BASME Base Unit of Measure MEINS T006 UNIT 3 0
HWAER Local Currency HWAER TCURC CUKY 5 0
MENGE Purchase order quantity MC_MENGE QUAN 15 3
WEMNG Quantity of goods received MC_WEMNG QUAN 15 3
WEMGM Goods receipt qty in base unit (calculate wtd.delivery time) MC_WEMGMAX QUAN 15 3
REMNG Invoice receipt quantity MC_REMNG QUAN 15 3
LSMNG Target delivery quantity in base unit of measure MC_LSMNG QUAN 15 3
NETWR Effective order value MC_EFFWR CURR 15 2
REWRT Invoice Amount MC_REWRT CURR 15 2
ABSTP Number of purchase order items MC_ABSTP DEC 9 0
ABSTE Number of purchase order item schedule lines MC_ABSTE DEC 9 0
AANFP Number of requests for quotation items MC_AANFP DEC 9 0
AANGP Number of Quotation Items MC_AANGP DEC 9 0
AKONP Number of contract items MC_AKONP DEC 9 0
ALFPP Number of scheduling agreement items MC_ALFPP DEC 9 0
ALFPE Number of delivery schedules MC_ALFPE DEC 9 0
ALIEF Number of deliveries MC_ALIEF DEC 9 0
MABW1 Deviation 1 in the quantity delivered MC_MABW1 DEC 9 0
MABW2 Variance 2 in the quantity delivered MC_MABW2 DEC 9 0
MABW3 Variance 3 in the quantity delivered MC_MABW3 DEC 9 0
MABW4 Variance 4 in the quantity delivered MC_MABW4 DEC 9 0
MABW5 Variance 5 in the quantity delivered MC_MABW5 DEC 9 0
TABW1 Delivery date variance 1 in days MC_TABW1 DEC 9 0
TABW2 Delivery date variance 2 in days MC_TABW2 DEC 9 0
TABW3 Delivery date variance 3 in days MC_TABW3 DEC 9 0
TABW4 Delivery date variance 4 in days MC_TABW4 DEC 9 0
TABW5 Delivery date variance 5 in days MC_TABW5 DEC 9 0
LFZTA Total delivery time in days MC_LFZTA DEC 13 0
LFZTG Weighted total delivery time MC_LFZTG DEC 15 1
MENGE_R Order quantity (returns) MC_MENGE_R QUAN 15 3
REMNG_R Invoice receipt quantity of returns MC_REMNG_R QUAN 15 3
WEMNG_R Goods receipt quantity of returns MC_WEMNG_R QUAN 15 3
REWRT_R Invoice amount: Returns MC_REWRT_R CURR 15 2
EFFWR_R Effective order value of returns MC_EFFWR_R CURR 15 2
WEWRT Value of goods received in local currency MC_WEWERT CURR 13 2
REMNG_B Invoice receipt quantity as at posting date MC_REMNG_B QUAN 15 3
WEWRT_B Goods receipt value as at posting date MC_WEWRT_B CURR 15 2
REWRT_B Invoice Amount as at Posting Date MC_REWRT_B CURR 15 2
REMNG_R_B IR quantity: Returns as at posting date MC_REMNG_R_B QUAN 15 3
REWRT_R_B IR value: Returns as at posting date MC_REWRT_R_B CURR 15 2
WEWRT_R_B GR value: Returns as at posting date MC_WEWRT_R_B CURR 15 2
OIFEETOT Fee total (document currency) OI0BW_FEETOTD CURR 13 2
OIVATH Amount in Local Currency DMBTR CURR 13 2
OIVATF Amount in document currency WRBTR CURR 13 2
OITXCON1 Excise duty tax from pricing conditions: rate 1 OIH_TXCON1 CURR 13 2
OITXCON2 Excise duty tax from pricing conditions: rate 2 OIH_TXCON2 CURR 13 2
OITXCON3 Excise duty tax from pricing conditions: rate 3 OIH_TXCON3 CURR 13 2
OITXCON4 Excise duty tax from pricing conditions: rate 4 OIH_TXCON4 CURR 13 2
OITXCON5 Excise duty tax from pricing conditions: rate 5 OIH_TXCON5 CURR 13 2
OITXCON6 Excise duty tax from pricing conditions: rate 6 OIH_TXCON6 CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
OISMENGE Called-off/delivered/goods receipt quantity OIA_SMENGE QUAN 13 3
OIINTQTY Quantity scheduled to be exchanged OIA_INTQTY QUAN 13 3
OIMEINS Quantity schedule-related UoM OIA_MEINS T006 UNIT 3 0
OIRECQTY Quantity intended against an exchange OIA_RECQTY QUAN 13 3

S012 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S012 BASME S012 BASME T006 Units of Measurement MSEHI
S012 BASME S012 MANDT T006 Units of Measurement MANDT
S012 EKORG S012 EKORG T024E Purchasing Organizations EKORG
S012 EKORG S012 MANDT T024E Purchasing Organizations MANDT
S012 HWAER S012 MANDT TCURC Currency Codes MANDT
S012 HWAER S012 HWAER TCURC Currency Codes WAERS
S012 INFNR S012 MANDT EINA Purchasing Info Record: General Data MANDT
S012 INFNR S012 INFNR EINA Purchasing Info Record: General Data INFNR
S012 LAND1 S012 MANDT T005 Countries MANDT
S012 LAND1 S012 LAND1 T005 Countries LAND1
S012 LIFNR S012 MANDT LFA1 Vendor Master (General Section) MANDT
S012 LIFNR S012 LIFNR LFA1 Vendor Master (General Section) LIFNR
S012 MANDT S012 MANDT T000 Clients MANDT
S012 MATKL S012 MANDT T023 Material Groups MANDT
S012 MATKL S012 MATKL T023 Material Groups MATKL
S012 MATNR S012 MANDT MARA General Material Data MANDT
S012 MATNR S012 MATNR MARA General Material Data MATNR
S012 OIMEINS SYST MANDT T006 Units of Measurement MANDT
S012 OIMEINS S012 OIMEINS T006 Units of Measurement MSEHI
S012 WAERS S012 MANDT TCURC Currency Codes MANDT
S012 WAERS S012 WAERS TCURC Currency Codes WAERS
S012 WERKS S012 MANDT T001W Plants/Branches MANDT
S012 WERKS S012 WERKS T001W Plants/Branches WERKS