SE11 ABAP Dictionary SE11 EBKN

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

EBKN

Purchase Requisition Account Assignment
SAP SAP Transparent Table 70 Fields
Primary Key:
MANDT BANFN BNFPO ZEBKN

Dictionary Fields Fields

(70 dari 70 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
BANFN
KEY Purch.Req. CHAR 10 - - Purchase Requisition Number
3
BNFPO
KEY PReq. Item NUMC 5 - - Item Number of Purchase Requisition
4
ZEBKN
KEY Serial no. NUMC 2 - - Serial number for PReq account assignment segment
5
LOEKZ
- Delet.Ind. CHAR 1 - - Deletion Indicator in Purchasing Document
6
ERDAT
- On DATS 8 - - Date on Which Record Was Created
7
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
8
MENGE
- Quantity QUAN 13 3 - Purchase Requisition Quantity
9
VPROZ
- Distrib. DEC 3 1 - Distribution Percentage in Case of Multiple Account Assgt
10
SAKTO
- G/L acct CHAR 10 - - G/L Account Number
11
GSBER
- Bus. Area CHAR 4 - - Business Area
12
KOSTL
- Cost Ctr CHAR 10 - - Cost Center
13
PROJN
- not in use CHAR 16 - - Old: Project number : No longer used --> PS_POSNR
14
VBELN
- SD Doc. CHAR 10 - VBAK Sales and Distribution Document Number
15
VBELP
- Item NUMC 6 - - Sales Document Item
16
VETEN
- Schd. Line NUMC 4 - - Delivery Schedule Line Number
17
ANLN1
- Asset CHAR 12 - - Main Asset Number
18
ANLN2
- Subnumber CHAR 4 - - Asset Subnumber
19
AUFNR
- Order CHAR 12 - - Order Number
20
WEMPF
- Recipient CHAR 12 - - Goods Recipient/Ship-To Party
21
ABLAD
- Unl. Point CHAR 25 - - Unloading Point
22
KOKRS
- CO Area CHAR 4 - - Controlling Area
23
XBKST
- Posting to cost center? CHAR 1 - - Posting to cost center?
24
XBAUF
- Order CHAR 1 - - Post To Order
25
XBPRO
- Project CHAR 1 - - Post to project
26
KSTRG
- CostObject CHAR 12 - - Cost Object
27
PAOBJNR
- Prof.Segmt NUMC 10 - - Profitability Segment Number (CO-PA)
28
PRCTR
- Profit Ctr CHAR 10 - - Profit Center
29
PS_PSP_PNR
- WBS Elem. NUMC 8 - - Work Breakdown Structure Element (WBS Element)
30
NPLNR
- Network CHAR 12 - - Network Number for Account Assignment
31
AUFPL
- Plan no. NUMC 10 - - Routing number of operations in the order
32
IMKEY
- RE Key CHAR 8 - - Internal Key for Real Estate Object
33
APLZL
- Counter NUMC 8 - - Internal counter
34
VPTNR
- Partner CHAR 10 - - Partner account number
35
FIPOS
- Cmmt Item CHAR 14 - - Commitment Item
36
RECID
- Rec.Indic. CHAR 2 - - Recovery Indicator
37
ZZSPREG
- SpecREG CHAR 5 - - Special Region
38
ZZBUSPARTN
- Bus.partn. CHAR 10 - - Business partner
39
ZZPRODUCT
- ProductGrp CHAR 10 - - Product group
40
ZZLOCA
- City CHAR 4 - - City
41
ZZCHAN
- Dist. chan CHAR 4 - - Distribution channel
42
ZZLOB
- BUSINESS L CHAR 7 - - BUSINESS LINE
43
ZZNFAL
- ZZNFAL CHAR 10 - -
44
ZZUSERFLD1
- Territory CHAR 9 - - Territory
45
ZZUSERFLD2
- Ownr/Cntr CHAR 12 - - Owner/Cont.
46
ZZUSERFLD3
- Vein CHAR 22 - - Vein
47
ZZREGION
- Location CHAR 3 - - Location
48
ZZSTATE
- State/Prov CHAR 3 - - State/Province Code
49
FISTL
- Funds Ctr CHAR 16 - - Funds Center
50
GEBER
- Fund CHAR 10 - - Fund
51
FKBER
- Func. Area CHAR 16 - - Functional Area
52
DABRZ
- Ref. Date DATS 8 - - Reference Date for Settlement
53
NETWR
- Net Value CURR 13 2 - Net Order Value in PO Currency
54
AUFPL_ORD
- Plan no. NUMC 10 - - Routing number of operations in the order
55
APLZL_ORD
- Counter NUMC 8 - - General counter for order
56
KBLNR
- DocumentNo CHAR 10 - - Document Number for Earmarked Funds
57
KBLPOS
- Doc. item NUMC 3 - - Earmarked Funds: Document Item
58
LSTAR
- Acty Type CHAR 6 - - Activity Type
59
PRZNR
- BusProcess CHAR 12 - - Business Process
60
GRANT_NBR
- Grant CHAR 20 - - Grant
61
FM_SPLIT_BATCH
- Batch # NUMC 3 - - Batch to group results from an PSM assignment distribution
62
FM_SPLIT_BEGRU
- Auth.Grou CHAR 4 - - Authorization group for PSM account assignment distribution
63
BUDGET_PD
- BP CHAR 10 - - FM: Budget Period
64
EGRUP
- Equity grp CHAR 3 - - Equity group
65
VNAME
- Venture CHAR 6 - - Joint Venture
66
TCOBJNR
- Obj. no. CHAR 22 - - Object number
67
DATEOFSERVICE
- DATEOFSERVICE DATS 8 - -
68
NOTAXCORR
- NOTAXCORR CHAR 1 - -
69
DIFFOPTRATE
- Option rte DEC 9 6 - Real estate option rate
70
HASDIFFOPTRATE
- HASDIFFOPTRATE CHAR 1 - -

Related References & SQL

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

Interactive ERD Diagrams
SAP MM - Purchase Requisition Relation →
Standard T-Codes
SE11 SE16
Related Tables
VBAK EBAN STXH STXL
ANSI SQL Query 
SELECT a.BANFN,
       a.BNFPO,
       a.ZEBKN,
       a.LOEKZ,
       a.ERDAT,
       a.ERNAM,
       a.MENGE
FROM EBKN AS a
WHERE a.BANFN = '0001'
  AND a.BNFPO = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~banfn,
       a~bnfpo,
       a~zebkn,
       a~loekz,
       a~erdat,
       a~ernam,
       a~menge
  FROM ebkn AS a
  WHERE a~banfn = '0001'
  and a~bnfpo = '0001'
  INTO TABLE @DATA(lt_ebkn)
  UP TO 100 ROWS.