SE11 ABAP Dictionary SE11 EORD

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

EORD

Purchasing Source List
SAP SAP Transparent Table 26 Fields
Primary Key:
MANDT MATNR WERKS ZEORD

Dictionary Fields Fields

(26 dari 26 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
MATNR
KEY Material CHAR 18 - MARA Material Number
3
WERKS
KEY Plant CHAR 4 - T001W Plant
4
ZEORD
KEY Number NUMC 5 - - Number of Source List Record
5
ERDAT
- On DATS 8 - - Date on Which Record Was Created
6
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
7
VDATU
- Valid from DATS 8 - - Source List Record Valid From
8
BDATU
- Valid to DATS 8 - - Source List Record Valid To
9
LIFNR
- Vendor CHAR 10 - LFA1 Vendor Account Number
10
FLIFN
- Fixed vend CHAR 1 - - Indicator: Fixed vendor
11
EBELN
- Agreement CHAR 10 - EKKO Agreement Number
12
EBELP
- Item NUMC 5 - - Agreement Item
13
FEBEL
- Fixed CHAR 1 - - Fixed Outline Purchase Agreement Item
14
RESWK
- Proc. Pl. CHAR 4 - - Plant from Which Material is Procured
15
FRESW
- Fix. plant CHAR 1 - - Fixed issuing plant in case of stock transport order
16
EMATN
- MPN Mat. CHAR 18 - - Material Number Corresponding to Manufacturer Part Number
17
NOTKZ
- Blocked CHAR 1 - - Blocked Source of Supply
18
EKORG
- Purch.Org. CHAR 4 - - Purchasing Organization
19
VRTYP
- Doc. Cat. CHAR 1 - - Purchasing Document Category
20
EORTP
- Cntrl Ind. CHAR 1 - - Category of Source List Record
21
AUTET
- MRP CHAR 1 - - Source List Usage in Materials Planning
22
MEINS
- Order Unit UNIT 3 - - Purchase Order Unit of Measure
23
LOGSY
- Log.System CHAR 10 - - Logical System
24
SOBKZ
- Spec.Stock CHAR 1 - - Special Stock Indicator
25
SRM_CONTRACT_ID
- CentContr. CHAR 10 - - Central Contract
26
SRM_CONTRACT_ITM
- CC Item NUMC 10 - - Central Contract Item Number

Related References & SQL

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

Interactive ERD Diagrams
SAP MM - Purchase Orders Relation →
Standard T-Codes
SE11 SE16
Related Tables
MARA T001W LFA1 EKKO EKPO EKET EKKN EINA
ANSI SQL Query 
SELECT a.MATNR,
       a.WERKS,
       a.ZEORD,
       a.ERDAT,
       a.ERNAM,
       a.VDATU,
       a.BDATU
FROM EORD AS a
WHERE a.MATNR = 'FG-100'
  AND a.WERKS = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~matnr,
       a~werks,
       a~zeord,
       a~erdat,
       a~ernam,
       a~vdatu,
       a~bdatu
  FROM eord AS a
  WHERE a~matnr = 'fg-100'
  and a~werks = '0001'
  INTO TABLE @DATA(lt_eord)
  UP TO 100 ROWS.