SE11 ABAP Dictionary SE11 S012

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

S012

Purchasing

SAP SAP Transparent Table 58 Fields

Primary Key:

MANDT SSOUR VRSIO SPMON SPTAG SPWOC SPBUP EKORG LIFNR MATNR WERKS ESOKZ MATKL INFNR LAND1

#	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	MATKL	KEY	Matl Group	CHAR	9	-	-	Material Group
14	INFNR	KEY	Info Rec.	CHAR	10	-	-	Number of Purchasing Info Record
15	LAND1	KEY	Vend. cty	CHAR	3	-	T005	Country key of vendor
16	PERIV	-	FY Variant	CHAR	2	-	-	Fiscal Year Variant
17	VWDAT	-	Pointer	NUMC	10	-	-	Pointer to administrative data
18	BASME	-	Unit	UNIT	3	-	-	Base Unit of Measure
19	HWAER	-	Local Cur.	CUKY	5	-	-	Local Currency
20	MENGE	-	PO qty.	QUAN	15	3	-	Purchase order quantity
21	WEMNG	-	GR qty	QUAN	15	3	-	Quantity of goods received
22	WEMGM	-	GR qty wDt	QUAN	15	3	-	Goods receipt qty in base unit (calculate wtd.delivery time)
23	REMNG	-	IR qty	QUAN	15	3	-	Invoice receipt quantity
24	LSMNG	-	TargDelQty	QUAN	15	3	-	Target delivery quantity in base unit of measure
25	NETWR	-	Order val.	CURR	15	2	-	Effective order value
26	REWRT	-	Inv. amt.	CURR	15	2	-	Invoice Amount
27	ABSTP	-	PO items	DEC	9	-	-	Number of purchase order items
28	ABSTE	-	Ord.it.sch	DEC	9	-	-	Number of purchase order item schedule lines
29	AANFP	-	RFQ items	DEC	9	-	-	Number of requests for quotation items
30	AANGP	-	Qu. Items	DEC	9	-	-	Number of Quotation Items
31	AKONP	-	ContrItems	DEC	9	-	-	Number of contract items
32	ALFPP	-	SchAgmtItm	DEC	9	-	-	Number of scheduling agreement items
33	ALFPE	-	Del.scheds	DEC	9	-	-	Number of delivery schedules
34	ALIEF	-	Deliveries	DEC	9	-	-	Number of deliveries
35	MABW1	-	Qty var. 1	DEC	9	-	-	Deviation 1 in the quantity delivered
36	MABW2	-	Qty var. 2	DEC	9	-	-	Variance 2 in the quantity delivered
37	MABW3	-	Qty var. 3	DEC	9	-	-	Variance 3 in the quantity delivered
38	MABW4	-	Qty var. 4	DEC	9	-	-	Variance 4 in the quantity delivered
39	MABW5	-	Qty var. 5	DEC	9	-	-	Variance 5 in the quantity delivered
40	TABW1	-	Del.dt.vr1	DEC	9	-	-	Delivery date variance 1 in days
41	TABW2	-	Del.dt.vr2	DEC	9	-	-	Delivery date variance 2 in days
42	TABW3	-	Del.dt.vr3	DEC	9	-	-	Delivery date variance 3 in days
43	TABW4	-	Del.dt.vr4	DEC	9	-	-	Delivery date variance 4 in days
44	TABW5	-	Del.dt.vr5	DEC	9	-	-	Delivery date variance 5 in days
45	LFZTA	-	Ttl del.T	DEC	13	-	-	Total delivery time in days
46	LFZTG	-	WtdTtlDelT	DEC	15	1	-	Weighted total delivery time
47	MENGE_R	-	PO qty.	QUAN	15	3	-	Order quantity (returns)
48	REMNG_R	-	IR qty	QUAN	15	3	-	Invoice receipt quantity of returns
49	WEMNG_R	-	GR Qty	QUAN	15	3	-	Goods receipt quantity of returns
50	REWRT_R	-	Inv. amt.	CURR	15	2	-	Invoice amount: Returns
51	EFFWR_R	-	Order val.	CURR	15	2	-	Effective order value of returns
52	WEWRT	-	GR value	CURR	13	2	-	Value of goods received in local currency
53	REMNG_B	-	IR qty	QUAN	15	3	-	Invoice receipt quantity as at posting date
54	WEWRT_B	-	GR value	CURR	15	2	-	Goods receipt value as at posting date
55	REWRT_B	-	Inv.A (PD)	CURR	15	2	-	Invoice Amount as at Posting Date
56	REMNG_R_B	-	IR qty.RPD	QUAN	15	3	-	IR quantity: Returns as at posting date
57	REWRT_R_B	-	IR val.RPD	CURR	15	2	-	IR value: Returns as at posting date
58	WEWRT_R_B	-	GR val.RPD	CURR	15	2	-	GR value: Returns as at posting date

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Purchase Orders Relation →

Standard T-Codes

SE11 SE16

Related Tables

LFA1 MARA T001W T005 EKKO EKPO EKET EKKN

ANSI SQL Query

SELECT a.SSOUR,
       a.VRSIO,
       a.SPMON,
       a.SPTAG,
       a.SPWOC,
       a.SPBUP,
       a.EKORG
FROM S012 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 s012 AS a
  WHERE a~ssour = '0001'
  and a~vrsio = '0001'
  INTO TABLE @DATA(lt_s012)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 S012

S012

Dictionary Fields Fields

Related References & SQL