SAP Table EINA
Purchasing Info Record: General Data
EINA (Purchasing Info Record: General Data) 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 EINA to other SAP tables.
EINA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
INFNR
Number of Purchasing Info Record
|
INFNR |
CHAR
|
10 | 0 | ||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||
|
MATKL
Material Group
|
MATKL | T023 |
CHAR
|
9 | 0 | |||||||||
|
LIFNR
Vendor Account Number
|
ELIFN | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
LOEKZ
Purchasing info: General data flagged for deletion
|
ILOEA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||
|
TXZ01
Short Text for Purchasing Info Record
|
EINATX |
CHAR
|
40 | 0 | ||||||||||
|
SORTL
Sort Term for Non-Stock Info Records
|
SORTI |
CHAR
|
10 | 0 | ||||||||||
|
MEINS
Purchase Order Unit of Measure
|
BSTME | T006 |
UNIT
|
3 | 0 | |||||||||
|
UMREZ
Numerator for Conversion of Order Unit to Base Unit
|
UMBSZ |
DEC
|
5 | 0 | ||||||||||
|
UMREN
Denominator for Conversion of Order Unit to Base Unit
|
UMBSN |
DEC
|
5 | 0 | ||||||||||
|
IDNLF
Material Number Used by Vendor
|
IDNLF |
CHAR
|
35 | 0 | ||||||||||
|
VERKF
Salesperson Responsible in the Event of Queries
|
VERKF |
CHAR
|
30 | 0 | ||||||||||
|
TELF1
Vendor's Telephone Number
|
TELF0 |
CHAR
|
16 | 0 | ||||||||||
|
MAHN1
Number of Days for First Reminder/Expediter
|
MAHN1 |
DEC
|
3 | 0 | ||||||||||
|
MAHN2
Number of Days for Second Reminder/Expediter
|
MAHN2 |
DEC
|
3 | 0 | ||||||||||
|
MAHN3
Number of Days for Third Reminder/Expediter
|
MAHN3 |
DEC
|
3 | 0 | ||||||||||
|
URZNR
Certificate Number
|
URZNR |
CHAR
|
10 | 0 | ||||||||||
|
URZDT
Certificate of Origin Valid Until
|
URZDT |
DATS
|
8 | 0 | ||||||||||
|
URZLA
Country of Issue of Certificate of Origin
|
ULAND | T005 |
CHAR
|
3 | 0 | |||||||||
|
URZTP
Certificate Category
|
URZTP | T069 |
CHAR
|
1 | 0 | |||||||||
|
URZZT
Number
|
URZZT |
CHAR
|
16 | 0 | ||||||||||
|
LMEIN
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |||||||||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||
|
VABME
Variable Purchase Order Unit Active
|
VABME |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LTSNR
Vendor Subrange
|
LTSNR | WYT1 |
CHAR
|
6 | 0 | |||||||||
|
LTSSF
Sort Sequence Number
|
LTSSF |
NUMC
|
5 | 0 | ||||||||||
|
WGLIF
Vendor Material Group
|
WGLIF |
CHAR
|
18 | 0 | ||||||||||
|
RUECK
Return Agreement
|
W_RUECKNV | TWRV |
CHAR
|
2 | 0 | |||||||||
|
LIFAB
Available (Deliverable) From
|
LIFAB |
DATS
|
8 | 0 | ||||||||||
|
LIFBI
Available (Deliverable) Until
|
LIFBI |
DATS
|
8 | 0 | ||||||||||
|
KOLIF
Prior Vendor
|
KOLIF | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
ANZPU
Number of Points
|
ANZPU |
QUAN
|
13 | 3 | ||||||||||
|
PUNEI
Points unit
|
PUNEI | T006 |
UNIT
|
3 | 0 | |||||||||
|
RELIF
Regular Vendor
|
RELIF |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MFRNR
Manufacturer
|
MFRNR1 |
CHAR
|
10 | 0 | ||||||||||
EINA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EINA | KOLIF | EINA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EINA | KOLIF | EINA | KOLIF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EINA | LIFNR | EINA | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EINA | LIFNR | EINA | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EINA | LMEIN | EINA | MANDT |
T006
Units of Measurement
|
MANDT |
| EINA | LMEIN | EINA | LMEIN |
T006
Units of Measurement
|
MSEHI |
| EINA | LTSNR | EINA | MANDT |
WYT1
Vendor Subrange
|
MANDT |
| EINA | LTSNR | EINA | LIFNR |
WYT1
Vendor Subrange
|
LIFNR |
| EINA | LTSNR | EINA | LTSNR |
WYT1
Vendor Subrange
|
LTSNR |
| EINA | MANDT | EINA | MANDT |
T000
Clients
|
MANDT |
| EINA | MATKL | EINA | MANDT |
T023
Material Groups
|
MANDT |
| EINA | MATKL | EINA | MATKL |
T023
Material Groups
|
MATKL |
| EINA | MATNR | EINA | MANDT |
MARA
General Material Data
|
MANDT |
| EINA | MATNR | EINA | MATNR |
MARA
General Material Data
|
MATNR |
| EINA | MEINS | EINA | MANDT |
T006
Units of Measurement
|
MANDT |
| EINA | MEINS | EINA | MEINS |
T006
Units of Measurement
|
MSEHI |
| EINA | PUNEI | EINA | MANDT |
T006
Units of Measurement
|
MANDT |
| EINA | PUNEI | EINA | PUNEI |
T006
Units of Measurement
|
MSEHI |
| EINA | REGIO | EINA | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| EINA | REGIO | EINA | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| EINA | REGIO | EINA | URZLA |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| EINA | RUECK | EINA | MANDT |
TWRV
Return agreements IS-R
|
MANDT |
| EINA | RUECK | EINA | RUECK |
TWRV
Return agreements IS-R
|
RUECV |
| EINA | URZLA | EINA | MANDT |
T005
Countries
|
MANDT |
| EINA | URZLA | EINA | URZLA |
T005
Countries
|
LAND1 |
| EINA | URZTP | EINA | MANDT |
T069
Certificate Categories
|
MANDT |
| EINA | URZTP | EINA | URZTP |
T069
Certificate Categories
|
URZTP |