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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| 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 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| EINA | LIFNR | EINA | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| 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 | MATKL | T023 | Material Groups | MATKL |
| EINA | MATKL | EINA | MANDT | T023 | Material Groups | MANDT |
| 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 | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| EINA | REGIO | EINA | URZLA | T005S | Taxes: Region (Province) Key | LAND1 |
| EINA | REGIO | EINA | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| EINA | RUECK | EINA | MANDT | TWRV | Return agreements IS-R | MANDT |
| EINA | RUECK | EINA | RUECK | TWRV | Return agreements IS-R | RUECV |
| EINA | URZLA | EINA | URZLA | T005 | Countries | LAND1 |
| EINA | URZLA | EINA | MANDT | T005 | Countries | MANDT |
| EINA | URZTP | EINA | MANDT | T069 | Certificate Categories | MANDT |
| EINA | URZTP | EINA | URZTP | T069 | Certificate Categories | URZTP |
