SE11 ABAP Dictionary SE11 EINA

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

EINA

Purchasing Info Record: General Data
SAP SAP Transparent Table 38 Fields
Primary Key:
MANDT INFNR

Dictionary Fields Fields

(38 dari 38 kolom)
# 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
MATNR
- Material CHAR 18 - MARA Material Number
4
MATKL
- Matl Group CHAR 9 - - Material Group
5
LIFNR
- Vendor CHAR 10 - LFA1 Vendor Account Number
6
LOEKZ
- Complete CHAR 1 - - Purchasing info: General 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
TXZ01
- Short Text CHAR 40 - - Short Text for Purchasing Info Record
10
SORTL
- Sort Term CHAR 10 - - Sort Term for Non-Stock Info Records
11
MEINS
- Order Unit UNIT 3 - - Purchase Order Unit of Measure
12
UMREZ
- <=> DEC 5 - - Numerator for Conversion of Order Unit to Base Unit
13
UMREN
- Denominat. DEC 5 - - Denominator for Conversion of Order Unit to Base Unit
14
IDNLF
- Vend. Mat. CHAR 35 - - Material Number Used by Vendor
15
VERKF
- Salespers. CHAR 30 - - Salesperson Responsible in the Event of Queries
16
TELF1
- Telephone CHAR 16 - - Vendor's Telephone Number
17
MAHN1
- Reminder 1 DEC 3 - - Number of Days for First Reminder/Expediter
18
MAHN2
- Reminder 2 DEC 3 - - Number of Days for Second Reminder/Expediter
19
MAHN3
- Reminder 3 DEC 3 - - Number of Days for Third Reminder/Expediter
20
URZNR
- Certif. CHAR 10 - - Certificate Number
21
URZDT
- Valid to DATS 8 - - Certificate of Origin Valid Until
22
URZLA
- Ctry.Orig. CHAR 3 - - Country of Issue of Certificate of Origin
23
URZTP
- Cert. Cat. CHAR 1 - - Certificate Category
24
URZZT
- Number CHAR 16 - - Number
25
LMEIN
- Unit UNIT 3 - - Base Unit of Measure
26
REGIO
- Region CHAR 3 - - Region (State, Province, County)
27
VABME
- Var. OUn CHAR 1 - - Variable Purchase Order Unit Active
28
LTSNR
- Subrange CHAR 6 - - Vendor Subrange
29
LTSSF
- Sort No. NUMC 5 - - Sort Sequence Number
30
WGLIF
- VendMatGrp CHAR 18 - - Vendor Material Group
31
RUECK
- Ret. Agmt CHAR 2 - - Return Agreement
32
LIFAB
- Avail. fr. DATS 8 - - Available (Deliverable) From
33
LIFBI
- Avail. to DATS 8 - - Available (Deliverable) Until
34
KOLIF
- Prior Vnd. CHAR 10 - - Prior Vendor
35
ANZPU
- Points QUAN 13 3 - Number of Points
36
PUNEI
- Unit UNIT 3 - - Points unit
37
RELIF
- Reg. Vend. CHAR 1 - - Regular Vendor
38
MFRNR
- Mfr CHAR 10 - - Manufacturer

Related References & SQL

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

Interactive ERD Diagrams
SAP MM - Purchase Orders Relation → SAP MM - Purchasing Info Record Relation →
Standard T-Codes
ME13 ME11 ME12 ME1M
Related Tables
MARA LFA1 EKKO EKPO EKET EKKN EORD EINE
ANSI SQL Query 
SELECT a.INFNR,
       a.MATNR,
       a.MATKL,
       a.LIFNR,
       a.LOEKZ,
       a.ERDAT
FROM EINA AS a
WHERE a.INFNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~infnr,
       a~matnr,
       a~matkl,
       a~lifnr,
       a~loekz,
       a~erdat
  FROM eina AS a
  WHERE a~infnr = '0001'
  INTO TABLE @DATA(lt_eina)
  UP TO 100 ROWS.