SE11 ABAP Dictionary SE11 EKPO

Data SE16 SE16

EKPO

Purchasing Document Item
SAP MM Transparent Table 260 Fields
Primary Key:
MANDT EBELN EBELP

Dictionary Fields Fields

(260 dari 260 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
EBELN
KEY Purch.Doc. CHAR 10 - EKKO Purchasing Document Number
3
EBELP
KEY Item NUMC 5 - - Item Number of Purchasing Document
4
LOEKZ
- Delet.Ind. CHAR 1 - - Deletion Indicator in Purchasing Document
5
STATU
- Status CHAR 1 - - RFQ status
6
AEDAT
- Changed On DATS 8 - - Purchasing Document Item Change Date
7
TXZ01
- Short Text CHAR 40 - - Short Text
8
MATNR
- Material CHAR 18 - MARA Material Number
9
EMATN
- Material CHAR 18 - - Material Number
10
BUKRS
- CoCode CHAR 4 - T001 Company Code
11
WERKS
- Plant CHAR 4 - T001W Plant
12
LGORT
- Stor. Loc. CHAR 4 - T001L Storage Location
13
BEDNR
- TrackingNo CHAR 10 - - Requirement Tracking Number
14
MATKL
- Matl Group CHAR 9 - - Material Group
15
INFNR
- Info Rec. CHAR 10 - - Number of Purchasing Info Record
16
IDNLF
- Vend. Mat. CHAR 35 - - Material Number Used by Vendor
17
KTMNG
- Quantity QUAN 13 3 - Target Quantity
18
MENGE
- Quantity QUAN 13 3 - Purchase Order Quantity
19
MEINS
- Order Unit UNIT 3 - - Purchase Order Unit of Measure
20
BPRME
- OrderPr.Un UNIT 3 - - Order Price Unit (Purchasing)
21
BPUMZ
- Conversion DEC 5 - - Numerator for Conversion of Order Price Unit into Order Unit
22
BPUMN
- Conversion DEC 5 - - Denominator for Conv. of Order Price Unit into Order Unit
23
UMREZ
- <=> DEC 5 - - Numerator for Conversion of Order Unit to Base Unit
24
UMREN
- Denominat. DEC 5 - - Denominator for Conversion of Order Unit to Base Unit
25
NETPR
- Net Price CURR 11 2 - Net Price in Purchasing Document (in Document Currency)
26
PEINH
- Per DEC 5 - - Price Unit
27
NETWR
- Net Value CURR 13 2 - Net Order Value in PO Currency
28
BRTWR
- Gross val. CURR 13 2 - Gross order value in PO currency
29
AGDAT
- QuotDdln DATS 8 - - Deadline for Submission of Bid/Quotation
30
WEBAZ
- GR ProcTme DEC 3 - - Goods Receipt Processing Time in Days
31
MWSKZ
- Tax Code CHAR 2 - - Sales Tax Code
32
BONUS
- Sett. G. 1 CHAR 2 - - Settlement Group 1 (Purchasing)
33
INSMK
- Stock Type CHAR 1 - - Stock Type
34
SPINF
- InfoUpdate CHAR 1 - - Indicator: Update Info Record
35
PRSDR
- Pr. Price CHAR 1 - - Price Printout
36
SCHPR
- Est. Price CHAR 1 - - Indicator: Estimated Price
37
MAHNZ
- No. R/E DEC 3 - - Number of Reminders/Expediters
38
MAHN1
- Reminder 1 DEC 3 - - Number of Days for First Reminder/Expediter
39
MAHN2
- Reminder 2 DEC 3 - - Number of Days for Second Reminder/Expediter
40
MAHN3
- Reminder 3 DEC 3 - - Number of Days for Third Reminder/Expediter
41
UEBTO
- Over. Tol. DEC 3 1 - Overdelivery Tolerance Limit
42
UEBTK
- Unlimited CHAR 1 - - Indicator: Unlimited Overdelivery Allowed
43
UNTTO
- Under.Tol. DEC 3 1 - Underdelivery Tolerance Limit
44
BWTAR
- Val. Type CHAR 10 - - Valuation Type
45
BWTTY
- Val. Cat. CHAR 1 - - Valuation Category
46
ABSKZ
- Rej. Ind. CHAR 1 - - Rejection Indicator
47
AGMEM
- Comment CHAR 3 - - Internal Comment on Quotation
48
ELIKZ
- Del. Cmpl. CHAR 1 - - "Delivery Completed" Indicator
49
EREKZ
- Final Inv. CHAR 1 - - Final Invoice Indicator
50
PSTYP
- Item Cat. CHAR 1 - - Item Category in Purchasing Document
51
KNTTP
- AcctAssCat CHAR 1 - - Account Assignment Category
52
KZVBR
- Consumpt. CHAR 1 - - Consumption Posting
53
VRTKZ
- Distrib. CHAR 1 - - Distribution Indicator for Multiple Account Assignment
54
TWRKZ
- Part. Inv. CHAR 1 - - Partial Invoice Indicator
55
WEPOS
- GR CHAR 1 - - Goods Receipt Indicator
56
WEUNB
- GR Non-Val CHAR 1 - - Goods Receipt, Non-Valuated
57
REPOS
- IR CHAR 1 - - Invoice Receipt Indicator
58
WEBRE
- GR-BasedIV CHAR 1 - - Indicator: GR-Based Invoice Verification
59
KZABS
- Ackn. Reqd CHAR 1 - - Order Acknowledgment Requirement
60
LABNR
- Ackn. No. CHAR 20 - - Order Acknowledgment Number
61
KONNR
- Agreement CHAR 10 - - Number of Principal Purchase Agreement
62
KTPNR
- Agmt Item NUMC 5 - - Item Number of Principal Purchase Agreement
63
ABDAT
- Recon.Date DATS 8 - - Reconciliation Date for Agreed Cumulative Quantity
64
ABFTZ
- AgrCumQty QUAN 13 3 - Agreed Cumulative Quantity
65
ETFZ1
- Firm Zone DEC 3 - - Firm Zone (Go-Ahead for Production)
66
ETFZ2
- Trade-Off DEC 3 - - Trade-Off Zone (Go-Ahead for Materials Procurement)
67
KZSTU
- Bindg MRP CHAR 1 - - Firm/Trade-Off Zones Binding with Regard to Mat. Planning
68
NOTKZ
- Exclusion CHAR 1 - - Exclusion in Outline Agreement Item with Material Class
69
LMEIN
- Base Unit UNIT 3 - - Base Unit of Measure
70
EVERS
- Shipping CHAR 2 - - Shipping Instructions
71
ZWERT
- Targ. Val. CURR 13 2 - Target Value for Outline Agreement in Document Currency
72
NAVNW
- Non-deductible input tax CURR 13 2 - Non-deductible input tax
73
ABMNG
- RelOrdQty. QUAN 13 3 - Standard release order quantity
74
PRDAT
- Price Date DATS 8 - - Date of Price Determination
75
BSTYP
- Doc. Cat. CHAR 1 - - Purchasing Document Category
76
EFFWR
- Value CURR 13 2 - Effective value of item
77
XOBLR
- Commitment CHAR 1 - - Item affects commitments
78
KUNNR
- Customer CHAR 10 - KNA1 Customer
79
ADRNR
- Address CHAR 10 - - Manual address number in purchasing document item
80
EKKOL
- Cond. Grp CHAR 4 - - Condition Group with Vendor
81
SKTOF
- No Disc. CHAR 1 - - Item Does Not Qualify for Cash Discount
82
STAFO
- Update grp CHAR 6 - - Update group for statistics update
83
PLIFZ
- Plan. Del. DEC 3 - - Planned Delivery Time in Days
84
NTGEW
- Net QUAN 13 3 - Net Weight
85
GEWEI
- Unit UNIT 3 - - Unit of Weight
86
TXJCD
- Tax Jur. CHAR 15 - - Tax Jurisdiction
87
ETDRK
- Print-rel. CHAR 1 - - Indicator: Print-relevant schedule lines exist
88
SOBKZ
- Spec.Stock CHAR 1 - - Special Stock Indicator
89
ARSNR
- SetReserNo NUMC 10 - - Settlement reservation number
90
ARSPS
- SettlItmNo NUMC 4 - - Item number of the settlement reservation
91
INSNC
- Not chgbl. CHAR 1 - - Quality inspection indicator cannot be changed
92
SSQSS
- QM ContKey CHAR 8 - - Control Key for Quality Management in Procurement
93
ZGTYP
- Cert. type CHAR 4 - - Certificate Type
94
EAN11
- EAN/UPC CHAR 18 - - International Article Number (EAN/UPC)
95
BSTAE
- ConfContr. CHAR 4 - - Confirmation Control Key
96
REVLV
- Rev. Level CHAR 2 - - Revision Level
97
GEBER
- Fund CHAR 10 - - Fund
98
FISTL
- Funds Ctr CHAR 16 - - Funds Center
99
FIPOS
- Cmmt Item CHAR 14 - - Commitment Item
100
KO_GSBER
- BA:Partner CHAR 4 - - Business area reported to the partner
101
KO_PARGB
- Ptr ass.BA CHAR 4 - - assumed business area of the business partner
102
KO_PRCTR
- Profit Ctr CHAR 10 - - Profit Center
103
KO_PPRCTR
- Partner PC CHAR 10 - - Partner Profit Center
104
MEPRF
- PrDateCntr CHAR 1 - - Price Determination (Pricing) Date Control
105
BRGEW
- Gross QUAN 13 3 - Gross Weight
106
VOLUM
- Volume QUAN 13 3 - Volume
107
VOLEH
- VolumeUnit UNIT 3 - - Volume unit
108
INCO1
- Incoterms CHAR 3 - - Incoterms (Part 1)
109
INCO2
- Inco. 2 CHAR 28 - - Incoterms (Part 2)
110
VORAB
- Advance CHAR 1 - - Advance procurement: project stock
111
KOLIF
- Prior Vnd. CHAR 10 - - Prior Vendor
112
LTSNR
- Subrange CHAR 6 - - Vendor Subrange
113
PACKNO
- Number NUMC 10 - - Package number
114
FPLNR
- Inv. plan CHAR 10 - - Invoicing plan number
115
GNETWR
- Net value CURR 13 2 - Currently not used
116
STAPO
- Statist. CHAR 1 - - Item is statistical
117
UEBPO
- H-Lev.Item NUMC 5 - - Higher-Level Item in Purchasing Documents
118
LEWED
- GR Date DATS 8 - - Latest Possible Goods Receipt
119
EMLIF
- Vendor CHAR 10 - - Vendor to be supplied/who is to receive delivery
120
LBLKZ
- SC vendor CHAR 1 - - Subcontracting vendor
121
SATNR
- Conf. matl CHAR 18 - - Cross-Plant Configurable Material
122
ATTYP
- Matl Cat. CHAR 2 - - Material Category
123
KANBA
- KanbanInd. CHAR 1 - - Kanban Indicator
124
ADRN2
- Address CHAR 10 - - Number of delivery address
125
CUOBJ
- Int.obj.no NUMC 18 - - Configuration (internal object number)
126
XERSY
- ERS CHAR 1 - - Evaluated Receipt Settlement (ERS)
127
EILDT
- GRSettFrom DATS 8 - - Start Date for GR-Based Settlement
128
DRDAT
- Transm. DATS 8 - - Last Transmission
129
DRUHR
- Transm. TIMS 6 - - Time
130
DRUNR
- Seq. No. NUMC 4 - - Sequential Number
131
AKTNR
- Promotion CHAR 10 - - Promotion
132
ABELN
- Alloc.Tab. CHAR 10 - - Allocation Table Number
133
ABELP
- Item NUMC 5 - - Item number of allocation table
134
ANZPU
- Points QUAN 13 3 - Number of Points
135
PUNEI
- Unit UNIT 3 - - Points unit
136
SAISO
- Season CHAR 4 - - Season Category
137
SAISJ
- Season Yr CHAR 4 - - Season Year
138
EBON2
- Sett. G. 2 CHAR 2 - - Settlement Group 2 (Rebate Settlement, Purchasing)
139
EBON3
- Sett. G. 3 CHAR 2 - - Settlement Group 3 (Rebate Settlement, Purchasing)
140
EBONF
- Settlement CHAR 1 - - Item Relevant to Subsequent (Period-End Rebate) Settlement
141
MLMAA
- ML act. CHAR 1 - - Material ledger activated at material level
142
MHDRZ
- Rem. Life DEC 4 - - Minimum Remaining Shelf Life
143
ANFNR
- RFQ CHAR 10 - - RFQ Number
144
ANFPS
- Item NUMC 5 - - Item Number of RFQ
145
KZKFG
- OrigConfig CHAR 1 - - Origin of Configuration
146
USEQU
- QuotaUsage CHAR 1 - - Quota arrangement usage
147
UMSOK
- Stock Tfr CHAR 1 - - Special Stock Indicator for Physical Stock Transfer
148
BANFN
- Purch.Req. CHAR 10 - - Purchase Requisition Number
149
BNFPO
- PReq. Item NUMC 5 - - Item Number of Purchase Requisition
150
MTART
- Matl Type CHAR 4 - - Material Type
151
UPTYP
- SI Cat. CHAR 1 - - Subitem Category, Purchasing Document
152
UPVOR
- Sub-items CHAR 1 - - Subitems Exist
153
KZWI1
- Subtotal 1 CURR 13 2 - Subtotal 1 from pricing procedure for condition
154
KZWI2
- Subtotal 2 CURR 13 2 - Subtotal 2 from pricing procedure for condition
155
KZWI3
- Subtotal 3 CURR 13 2 - Subtotal 3 from pricing procedure for condition
156
KZWI4
- Subtotal 4 CURR 13 2 - Subtotal 4 from pricing procedure for condition
157
KZWI5
- Subtotal 5 CURR 13 2 - Subtotal 5 from pricing procedure for condition
158
KZWI6
- Subtotal 6 CURR 13 2 - Subtotal 6 from pricing procedure for condition
159
SIKGR
- Key CHAR 3 - - Processing key for sub-items
160
MFZHI
- Max. CMGQ QUAN 15 3 - Maximum Cumulative Material Go-Ahead Quantity
161
FFZHI
- Max. CPGQ QUAN 15 3 - Maximum Cumulative Production Go-Ahead Quantity
162
RETPO
- Ret. Item CHAR 1 - - Returns Item
163
AUREL
- AT-Relev. CHAR 1 - - Relevant to Allocation Table
164
BSGRU
- Ord. Reas. CHAR 3 - - Reason for Ordering
165
LFRET
- Del. Type CHAR 4 - - Delivery Type for Returns to Vendors
166
MFRGR
- MatlFrtGrp CHAR 8 - - Material freight group
167
NRFHG
- DiK CHAR 1 - - Material qualifies for discount in kind
168
J_1BNBM
- NCM Code CHAR 16 - - Brazilian NCM Code
169
J_1BMATUSE
- Usage CHAR 1 - - Usage of the material
170
J_1BMATORG
- Origin CHAR 1 - - Origin of the material
171
J_1BOWNPRO
- Produced CHAR 1 - - Produced in-house
172
J_1BINDUST
- Mat. cat. CHAR 2 - - Material CFOP category
173
ABUEB
- Profile CHAR 4 - - Release Creation Profile
174
NLABD
- Next FRC DATS 8 - - Next Forecast Delivery Schedule Transmission
175
NFABD
- Next JIT DATS 8 - - Next JIT Delivery Schedule Transmission
176
KZBWS
- Valuation CHAR 1 - - Valuation of Special Stock
177
BONBA
- Reb.basis CURR 13 2 - Rebate basis 1
178
FABKZ
- JIT Indic. CHAR 1 - - Indicator: Item Relevant to JIT Delivery Schedules
179
J_1AINDXP
- Inf. index CHAR 5 - - Inflation Index
180
J_1AIDATEP
- Index date DATS 8 - - Inflation Index Date
181
MPROF
- MPP CHAR 4 - - Manufacturer Part Profile
182
EGLKZ
- Final Del. CHAR 1 - - "Outward Delivery Completed" Indicator
183
KZTLF
- Part. Del. CHAR 1 - - Partial Delivery at Item Level (Stock Transfer)
184
KZFME
- Usage UoM CHAR 1 - - Units of measure usage
185
RDPRF
- R. Profile CHAR 4 - - Rounding Profile
186
TECHS
- StdVariant CHAR 12 - - Parameter Variant/Standard Variant
187
CHG_SRV
- Configuration changed CHAR 1 - - Configuration changed
188
CHG_FPLNR
- No invoice for this item although not free of charge CHAR 1 - - No invoice for this item although not free of charge
189
MFRPN
- MPN CHAR 40 - - Manufacturer Part Number
190
MFRNR
- Manufact. CHAR 10 - - Number of a Manufacturer
191
EMNFR
- Ex. manuf. CHAR 10 - - External manufacturer code name or number
192
NOVET
- Ship block CHAR 1 - - Item blocked for SD delivery
193
AFNAM
- Requisnr. CHAR 12 - - Name of Requisitioner/Requester
194
TZONRC
- Rec. tzone CHAR 6 - - Time zone of recipient location
195
IPRKZ
- Per. Ind. CHAR 1 - - Period Indicator for Shelf Life Expiration Date
196
LEBRE
- S-Based IV CHAR 1 - - Indicator for Service-Based Invoice Verification
197
BERID
- MRP Area CHAR 10 - - MRP Area
198
XCONDITIONS
- Conditions for item although no invoice CHAR 1 - - Conditions for item although no invoice
199
APOMS
- EP CHAR 1 - - APO as Planning System
200
CCOMP
- ST cat. CHAR 1 - - Posting Logic in the Case of Stock Transfers
201
GRANT_NBR
- Grant CHAR 20 - - Grant
202
FKBER
- Func. Area CHAR 16 - - Functional Area
203
STATUS
- Status CHAR 1 - - Status of Purchasing Document Item
204
RESLO
- Iss.St.Loc CHAR 4 - - Issuing Storage Location for Stock Transport Order
205
KBLNR
- DocumentNo CHAR 10 - - Document Number for Earmarked Funds
206
KBLPOS
- Doc. item NUMC 3 - - Earmarked Funds: Document Item
207
WEORA
- Orig. Acc. CHAR 1 - - Acceptance At Origin
208
SRV_BAS_COM
- SBC CHAR 1 - - Service-Based Commitment
209
PRIO_URG
- ReqmtUrgcy NUMC 2 - - Requirement Urgency
210
PRIO_REQ
- ReqmtPrio. NUMC 3 - - Requirement Priority
211
EMPST
- Rec. pnt CHAR 25 - - Receiving point
212
SPE_ABGRU
- Rej.reason CHAR 2 - - Reason for rejection of quotations and sales orders
213
SPE_CRM_SO
- CRM SD Doc CHAR 10 - - CRM Sales Order Number for TPOP Process
214
SPE_CRM_SO_ITEM
- CRM Item NUMC 6 - - CRM Sales Order Item Number in TPOP Process
215
SPE_CRM_REF_SO
- CRM Rf Doc CHAR 35 - - CRM Reference Order Number for TPOP Process
216
SPE_CRM_REF_ITEM
- CRM Rf Itm CHAR 6 - - CRM Reference Sales Order Item Number in TPOP Process
217
SPE_CHNG_SYS
- ChngSysTy CHAR 1 - - Last Changer's System Type
218
SPE_INSMK_SRC
- Src St Typ CHAR 1 - - Stock Type of Source Storage Location in STO
219
SPE_CQ_CTRLTYPE
- CtrlType CHAR 1 - - CQ Control Type
220
SPE_CQ_NOCQ
- NoCQTrans CHAR 1 - - No Transmission of Cumulative Quantities in SA Release
221
REASON_CODE
- Reason CHAR 4 - - Goods Receipt Reason Code
222
CQU_SAR
- Cum. GRs QUAN 15 3 - Cumulative Goods Receipts from Redirected Purchase Orders
223
ANZSN
- No.ser.no. INT4 10 - - Number of serial numbers
224
SPE_EWM_DTC
- EWM DTC CHAR 1 - - EWM Delivery Based Tolerance Check
225
EXLIN
- ConfItemNo CHAR 40 - - Item Number Length
226
EXSNR
- Sort No. NUMC 5 - - External Sorting
227
EHTYP
- Ext.H Cat. CHAR 4 - - External Hierarchy Category
228
RETPC
- Retent. % DEC 5 2 - Retention in Percent
229
DPTYP
- Down Paymt CHAR 4 - - Down Payment Indicator
230
DPPCT
- DP % DEC 5 2 - Down Payment Percentage
231
DPAMT
- DwnPaytAmt CURR 11 2 - Down Payment Amount in Document Currency
232
DPDAT
- DP Due Dte DATS 8 - - Due Date for Down Payment
233
FLS_RSTO
- Enh.StRet. CHAR 1 - - Store Return with Inbound and Outbound Delivery
234
EXT_RFX_NUMBER
- Ext. Doc. CHAR 35 - - Document Number of External Document
235
EXT_RFX_ITEM
- Ext. Item CHAR 10 - - Item Number of External Document
236
EXT_RFX_SYSTEM
- Log.System CHAR 10 - - Logical System
237
SRM_CONTRACT_ID
- CentContr. CHAR 10 - - Central Contract
238
SRM_CONTRACT_ITM
- CC Item NUMC 10 - - Central Contract Item Number
239
/BEV1/NEGEN_ITEM
- Generated CHAR 1 - - Indicator: Item Is Generated
240
/BEV1/NEDEPFREE
- Dep. Free CHAR 1 - - Indicator: Dependent Items Are Free of Charge
241
/BEV1/NESTRUCCAT
- Category CHAR 1 - - Structure Category for Material Relationship
242
ADVCODE
- AdvCd CHAR 2 - - Advice Code
243
BUDGET_PD
- BP CHAR 10 - - FM: Budget Period
244
EXCPE
- Acc.Period NUMC 2 - - Acceptance Period
245
IUID_RELEVANT
- IUID-Rel. CHAR 1 - - IUID-Relevant
246
REFSITE
- Ref. Site CHAR 4 - - Reference Site For Purchasing
247
SERRU
- SC type CHAR 1 - - Type of subcontracting
248
SERNP
- Profile CHAR 4 - - Serial Number Profile
249
DISUB_SOBKZ
- Sp. stck CHAR 1 - - Special stock indicator Subcontracting
250
DISUB_PSPNR
- WBS Elem. NUMC 8 - - Work Breakdown Structure Element (WBS Element)
251
DISUB_KUNNR
- Customer CHAR 10 - - Customer Number 1
252
DISUB_VBELN
- SD Doc. CHAR 10 - - Sales and Distribution Document Number
253
DISUB_POSNR
- Item NUMC 6 - - Item number of the SD document
254
DISUB_OWNER
- Owner CHAR 10 - - Owner of stock
255
REF_ITEM
- RefItm NUMC 5 - - Reference Item for Remaining Qty Cancellation
256
SOURCE_ID
- Origin CHAR 3 - - Origin Profile
257
SOURCE_KEY
- SourceKey CHAR 32 - - Key in Source System
258
PUT_BACK
- DelId CHAR 1 - - Indicator for Putting Back from Grouped PO Document
259
POL_ID
- Item No. CHAR 10 - - Order List Item Number
260
CONS_ORDER
- ConsOrder? CHAR 1 - - Purchase Order for Consignment

Related References & SQL

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

Interactive ERD Diagrams
SAP MM - Purchase Orders Relation →
Standard T-Codes
ME23N ME21N ME2M ME2N
Related Tables
EKKO MARA T001 T001W T001L KNA1 EKET EKKN
ANSI SQL Query
SELECT a.EBELN,
       a.EBELP,
       a.LOEKZ,
       a.STATU,
       a.AEDAT,
       a.TXZ01,
       a.MATNR
FROM EKPO AS a
WHERE a.EBELN = '4500017291'
  AND a.EBELP = '0001';
ABAP OpenSQL (7.40+)
SELECT a~ebeln,
       a~ebelp,
       a~loekz,
       a~statu,
       a~aedat,
       a~txz01,
       a~matnr
  FROM ekpo AS a
  WHERE a~ebeln = '4500017291'
  and a~ebelp = '0001'
  INTO TABLE @DATA(lt_ekpo)
  UP TO 100 ROWS.