SE11 ABAP Dictionary SE11 EINE

Popular:

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

EINE

Purchasing Info Record: Purchasing Organization Data

SAP SAP Transparent Table 71 Fields

Primary Key:

MANDT INFNR EKORG ESOKZ WERKS

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	INFNR	KEY	Info Rec.	CHAR	10	-	-	Number of Purchasing Info Record
3	EKORG	KEY	Purch.Org.	CHAR	4	-	-	Purchasing Organization
4	ESOKZ	KEY	Infotype	CHAR	1	-	-	Purchasing info record category
5	WERKS	KEY	Plant	CHAR	4	-	T001W	Plant
6	LOEKZ	-	P.org.data	CHAR	1	-	-	Purch. info: Purch. organization data flagged for deletion
7	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
8	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
9	EKGRP	-	Pur. Group	CHAR	3	-	-	Purchasing Group
10	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
11	BONUS	-	Rebate	CHAR	1	-	-	Indicator: Volume-Based Rebate
12	MGBON	-	Qty Rebate	CHAR	1	-	-	Indicator: Quantity-Based Volume Rebate
13	MINBM	-	Min. Qty	QUAN	13	3	-	Minimum Purchase Order Quantity
14	NORBM	-	Stand. Qty	QUAN	13	3	-	Standard Purchase Order Quantity
15	APLFZ	-	Plnd Dely	DEC	3	-	-	Planned Delivery Time in Days
16	UEBTO	-	Over. Tol.	DEC	3	1	-	Overdelivery Tolerance Limit
17	UEBTK	-	Unlimited	CHAR	1	-	-	Indicator: Unlimited Overdelivery Allowed
18	UNTTO	-	Under.Tol.	DEC	3	1	-	Underdelivery Tolerance Limit
19	ANGNR	-	Quotation	CHAR	10	-	-	Quotation Number
20	ANGDT	-	Valid from	DATS	8	-	-	Quotation Validity Date
21	ANFNR	-	RFQ	CHAR	10	-	-	RFQ Number
22	ANFPS	-	Item	NUMC	5	-	-	Item Number of RFQ
23	ABSKZ	-	Rej. Ind.	CHAR	1	-	-	Rejection Indicator
24	AMODV	-	From	DATS	8	-	-	Amortization period from
25	AMODB	-	To	DATS	8	-	-	Amortization period to
26	AMOBM	-	Plan qty.	QUAN	15	3	-	Amortized planned quantity
27	AMOBW	-	Plan. val.	CURR	15	2	-	Amortized planned value
28	AMOAM	-	Actual qty	QUAN	15	3	-	Amortized actual quantity
29	AMOAW	-	Act. value	CURR	15	2	-	Amortized actual value
30	AMORS	-	Reset	CHAR	1	-	-	Indicator: Amortization reset
31	BSTYP	-	Doc. Cat.	CHAR	1	-	-	Purchasing Document Category
32	EBELN	-	Purch.Doc.	CHAR	10	-	EKKO	Purchasing Document Number
33	EBELP	-	Item	NUMC	5	-	-	Item Number of Purchasing Document
34	DATLB	-	Date	DATS	8	-	-	Date of Last PO or Sched. Agreement Document in Info Record
35	NETPR	-	Net Price	CURR	11	2	-	Net Price in Purchasing Info Record
36	PEINH	-	Per	DEC	5	-	-	Price Unit
37	BPRME	-	OrderPr.Un	UNIT	3	-	-	Order Price Unit (Purchasing)
38	PRDAT	-	Valid to	DATS	8	-	-	Price Valid Until
39	BPUMZ	-	Conversion	DEC	5	-	-	Numerator for Conversion of Order Price Unit into Order Unit
40	BPUMN	-	Conversion	DEC	5	-	-	Denominator for Conv. of Order Price Unit into Order Unit
41	MTXNO	-	No Mat. Tx	CHAR	1	-	-	Material Master Record PO Text Not Relevant
42	WEBRE	-	GR-BasedIV	CHAR	1	-	-	Indicator: GR-Based Invoice Verification
43	EFFPR	-	Eff. Price	CURR	11	2	-	Effective Price in Purchasing Info Record
44	EKKOL	-	Cond. Grp	CHAR	4	-	-	Condition Group with Vendor
45	SKTOF	-	No Disc.	CHAR	1	-	-	Item Does Not Qualify for Cash Discount
46	KZABS	-	Ackn. Reqd	CHAR	1	-	-	Order Acknowledgment Requirement
47	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
48	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
49	EBONU	-	Sett. G. 1	CHAR	2	-	-	Settlement Group 1 (Purchasing)
50	EVERS	-	Shipping	CHAR	2	-	-	Shipping Instructions
51	EXPRF	-	Procedure	CHAR	8	-	-	Export/Import Procedure for Foreign Trade
52	BSTAE	-	ConfContr.	CHAR	4	-	-	Confirmation Control Key
53	MEPRF	-	PrDateCntr	CHAR	1	-	-	Price Determination (Pricing) Date Control
54	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
55	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
56	XERSN	-	No ERS	CHAR	1	-	-	No Evaluated Receipt Settlement (ERS)
57	EBON2	-	Sett. G. 2	CHAR	2	-	-	Settlement Group 2 (Rebate Settlement, Purchasing)
58	EBON3	-	Sett. G. 3	CHAR	2	-	-	Settlement Group 3 (Rebate Settlement, Purchasing)
59	EBONF	-	No S.Sett.	CHAR	1	-	-	Item Not Relevant to Subseq. (Period-End Rebate) Settlement
60	MHDRZ	-	Rem. Life	DEC	4	-	-	Minimum Remaining Shelf Life
61	VERID	-	Version	CHAR	4	-	-	Production Version
62	BSTMA	-	Max. Qty	QUAN	13	3	-	Maximum Purchase Order Quantity
63	RDPRF	-	R. Profile	CHAR	4	-	-	Rounding Profile
64	MEGRU	-	UoM Group	CHAR	4	-	-	Unit of Measure Group
65	J_1BNBM	-	NCM Code	CHAR	16	-	-	Brazilian NCM Code
66	SPE_CRE_REF_DOC	-	Cre Refdoc	CHAR	1	-	-	Create Purchase Order for Delivery Without Reference
67	IPRKZ	-	Per. Ind.	CHAR	1	-	-	Period Indicator for Shelf Life Expiration Date
68	CO_ORDER	-	RT Consum.	CHAR	1	-	-	Real-Time Consumption Posting of Subcontracting Components
69	VENDOR_RMA_REQ	-	RMA Req.	CHAR	1	-	-	Vendor RMA Number Required
70	TRANSPORT_CHAIN	-	TrChain	CHAR	10	-	-	Transportation Chain
71	STAGING_TIME	-	Stg Time	DEC	3	-	-	Staging Time in Days

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Purchase Orders Relation → SAP MM - Purchasing Info Record Relation →

Standard T-Codes

SE11 SE16

Related Tables

T001W TCURC EKKO EKPO EKET EKKN EORD EINA

ANSI SQL Query

SELECT a.INFNR,
       a.EKORG,
       a.ESOKZ,
       a.WERKS,
       a.LOEKZ,
       a.ERDAT,
       a.ERNAM
FROM EINE AS a
WHERE a.INFNR = '0001'
  AND a.EKORG = '0001';

ABAP OpenSQL (7.40+)

SELECT a~infnr,
       a~ekorg,
       a~esokz,
       a~werks,
       a~loekz,
       a~erdat,
       a~ernam
  FROM eine AS a
  WHERE a~infnr = '0001'
  and a~ekorg = '0001'
  INTO TABLE @DATA(lt_eine)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 EINE

EINE

Dictionary Fields Fields

Related References & SQL