EBKN (Purchase Requisition Account Assignment) 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 EBKN to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
BANFN
Purchase Requisition Number
|
BANFN |
CHAR
|
10 | 0 | ||||||||
|
BNFPO
Item Number of Purchase Requisition
|
BNFPO | EBAN |
NUMC
|
5 | 0 | |||||||
|
ZEBKN
Serial number for PReq account assignment segment
|
DZEBKN |
NUMC
|
2 | 0 | ||||||||
|
LOEKZ
Deletion Indicator in Purchasing Document
|
ELOEK |
CHAR
|
1 | 0 | ||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||
|
MENGE
Purchase Requisition Quantity
|
BAMNG |
QUAN
|
13 | 3 | ||||||||
|
VPROZ
Distribution Percentage in Case of Multiple Account Assgt
|
VPROZ |
DEC
|
3 | 1 | ||||||||
|
SAKTO
G/L Account Number
|
SAKNR | SKA1 |
CHAR
|
10 | 0 | |||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||
|
PROJN
Old: Project number : No longer used --> PS_POSNR
|
PROJN |
CHAR
|
16 | 0 | ||||||||
|
VBELN
Sales and Distribution Document Number
|
VBELN | VBUK |
CHAR
|
10 | 0 | |||||||
|
VBELP
Sales Document Item
|
POSNR_VA | VBUP |
NUMC
|
6 | 0 | |||||||
|
VETEN
Delivery Schedule Line Number
|
ETENR | VBEP |
NUMC
|
4 | 0 | |||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||
|
ANLN2
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||
|
AUFNR
Order Number
|
AUFNR | AUFK |
CHAR
|
12 | 0 | |||||||
|
WEMPF
Goods Recipient/Ship-To Party
|
WEMPF |
CHAR
|
12 | 0 | ||||||||
|
ABLAD
Unloading Point
|
ABLAD |
CHAR
|
25 | 0 | ||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||
|
XBKST
Posting to cost center?
|
XBKST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XBAUF
Post To Order
|
XBAUF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XBPRO
Post to project
|
XBPRO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KSTRG
Cost Object
|
KSTRG |
CHAR
|
12 | 0 | ||||||||
|
PAOBJNR
Profitability Segment Number (CO-PA)
|
RKEOBJNR |
NUMC
|
10 | 0 | ||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||
|
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR | PRPS |
NUMC
|
8 | 0 | |||||||
|
NPLNR
Network Number for Account Assignment
|
NPLNR | AUFK |
CHAR
|
12 | 0 | |||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||
|
APLZL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||
|
VPTNR
Partner account number
|
JV_PART | KNA1 |
CHAR
|
10 | 0 | |||||||
|
FIPOS
Commitment Item
|
FIPOS | FMFPO |
CHAR
|
14 | 0 | |||||||
|
RECID
Recovery Indicator
|
JV_RECIND |
CHAR
|
2 | 0 | ||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||
|
DABRZ
Reference Date for Settlement
|
DABRBEZ |
DATS
|
8 | 0 | ||||||||
|
NETWR
Net Order Value in PO Currency
|
BWERT |
CURR
|
13 | 2 | ||||||||
|
AUFPL_ORD
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||
|
APLZL_ORD
General counter for order
|
CO_APLZL |
NUMC
|
8 | 0 | ||||||||
|
KBLNR
Document Number for Earmarked Funds
|
KBLNR |
CHAR
|
10 | 0 | ||||||||
|
KBLPOS
Earmarked Funds: Document Item
|
KBLPOS |
NUMC
|
3 | 0 | ||||||||
|
LSTAR
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||
|
PRZNR
Business Process
|
CO_PRZNR | CBPR |
CHAR
|
12 | 0 | |||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||
|
FM_SPLIT_BATCH
Batch to group results from an PSM assignment distribution
|
FMSP_SPLIT_BATCH |
NUMC
|
3 | 0 | ||||||||
|
FM_SPLIT_BEGRU
Authorization group for PSM account assignment distribution
|
FMSP_SPLIT_AUTG |
CHAR
|
4 | 0 | ||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||
|
EGRUP
Equity group
|
JV_EGROUP |
CHAR
|
3 | 0 | ||||||||
|
VNAME
Joint Venture
|
JV_NAME |
CHAR
|
6 | 0 | ||||||||
|
TCOBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||
|
DATEOFSERVICE
Date of Service
|
VVBEACTDATE |
DATS
|
8 | 0 | ||||||||
|
NOTAXCORR
Do Not Consider Item in Input Tax Correction
|
VVREITNOTAXCORR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DIFFOPTRATE
Real estate option rate
|
POPTSATZ |
DEC
|
9 | 6 | ||||||||
|
HASDIFFOPTRATE
Use Different Option Rate
|
VVREITUSEDIFFOPTRATE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EBKN | ANLN1 | EBKN | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| EBKN | ANLN1 | EBKN | MANDT |
ANLH
Main asset number
|
MANDT |
| EBKN | ANLN1 | T001 | BUKRS |
ANLH
Main asset number
|
BUKRS |
| EBKN | ANLN2 | EBKN | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| EBKN | ANLN2 | T001 | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| EBKN | ANLN2 | EBKN | ANLN1 |
ANLA
Asset Master Record Segment
|
ANLN1 |
| EBKN | ANLN2 | EBKN | ANLN2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| EBKN | AUFNR | EBKN | MANDT |
AUFK
Order master data
|
MANDT |
| EBKN | AUFNR | EBKN | AUFNR |
AUFK
Order master data
|
AUFNR |
| EBKN | BNFPO | EBKN | MANDT |
EBAN
Purchase Requisition
|
MANDT |
| EBKN | BNFPO | EBKN | BANFN |
EBAN
Purchase Requisition
|
BANFN |
| EBKN | BNFPO | EBKN | BNFPO |
EBAN
Purchase Requisition
|
BNFPO |
| EBKN | FIPOS | T001 | FIKRS |
FMFPO
FIFM: Commitment Item
|
FIKRS |
| EBKN | FIPOS | EBKN | FIPOS |
FMFPO
FIFM: Commitment Item
|
FIPOS |
| EBKN | FIPOS | EBKN | ERDAT |
FMFPO
FIFM: Commitment Item
|
DATBIS |
| EBKN | FIPOS | EBKN | MANDT |
FMFPO
FIFM: Commitment Item
|
MANDT |
| EBKN | GSBER | EBKN | MANDT |
TGSB
Business Areas
|
MANDT |
| EBKN | GSBER | EBKN | GSBER |
TGSB
Business Areas
|
GSBER |
| EBKN | KOKRS | EBKN | MANDT |
TKA01
Controlling Areas
|
MANDT |
| EBKN | KOKRS | EBKN | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| EBKN | KOSTL | EBKN | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| EBKN | KOSTL | EBKN | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| EBKN | KOSTL | EBKN | ERDAT |
CSKS
Cost Center Master Data
|
DATBI |
| EBKN | KOSTL | EBKN | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| EBKN | LSTAR | * |
CSLA
Activity master
|
DATBI | |
| EBKN | LSTAR | EBKN | MANDT |
CSLA
Activity master
|
MANDT |
| EBKN | LSTAR | EBKN | KOKRS |
CSLA
Activity master
|
KOKRS |
| EBKN | LSTAR | EBKN | LSTAR |
CSLA
Activity master
|
LSTAR |
| EBKN | MANDT | EBKN | MANDT |
T000
Clients
|
MANDT |
| EBKN | NPLNR | EBKN | MANDT |
AUFK
Order master data
|
MANDT |
| EBKN | NPLNR | EBKN | NPLNR |
AUFK
Order master data
|
AUFNR |
| EBKN | PRZNR | EBKN | MANDT |
CBPR
CO-ABC: Activity Master Table
|
MANDT |
| EBKN | PRZNR | EBKN | KOKRS |
CBPR
CO-ABC: Activity Master Table
|
KOKRS |
| EBKN | PRZNR | EBKN | PRZNR |
CBPR
CO-ABC: Activity Master Table
|
PRZNR |
| EBKN | PRZNR | * |
CBPR
CO-ABC: Activity Master Table
|
DATBI | |
| EBKN | PS_PSP_PNR | EBKN | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| EBKN | PS_PSP_PNR | EBKN | PS_PSP_PNR |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| EBKN | SAKTO | EBKN | MANDT |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT |
| EBKN | SAKTO | T001 | KTOPL |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL |
| EBKN | SAKTO | EBKN | SAKTO |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| EBKN | VBELN | EBKN | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| EBKN | VBELN | EBKN | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| EBKN | VBELP | EBKN | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| EBKN | VBELP | EBKN | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| EBKN | VBELP | EBKN | VBELP |
VBUP
Sales Document: Item Status
|
POSNR |
| EBKN | VETEN | EBKN | VETEN |
VBEP
Sales Document: Schedule Line Data
|
ETENR |
| EBKN | VETEN | EBKN | MANDT |
VBEP
Sales Document: Schedule Line Data
|
MANDT |
| EBKN | VETEN | EBKN | VBELN |
VBEP
Sales Document: Schedule Line Data
|
VBELN |
| EBKN | VETEN | EBKN | VBELP |
VBEP
Sales Document: Schedule Line Data
|
POSNR |
| EBKN | VPTNR | EBKN | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EBKN | VPTNR | EBKN | VPTNR |
KNA1
General Data in Customer Master
|
KUNNR |
| EBKN | ZZREGION | SYST | MANDT |
ZREG
User Defined Regions
|
MANDT |
| EBKN | ZZREGION | EBKN | ZZREGION |
ZREG
User Defined Regions
|
ZZREGION |
| EBKN | ZZSPREG | EBKN | ZZSPREG |
ZZSPREG
Check table for ZZSPREG = Special Region
|
ZZSPREG |
| EBKN | ZZSPREG | SYST | MANDT |
ZZSPREG
Check table for ZZSPREG = Special Region
|
MANDT |
| EBKN | ZZSTATE | SYST | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| EBKN | ZZSTATE | * |
T005S
Taxes: Region (Province) Key
|
LAND1 | |
| EBKN | ZZSTATE | EBKN | ZZSTATE |
T005S
Taxes: Region (Province) Key
|
BLAND |
| EBKN | ZZUSERFLD1 | SYST | MANDT |
ZFU1
Check Table for User Field 1
|
MANDT |
| EBKN | ZZUSERFLD1 | EBKN | ZZUSERFLD1 |
ZFU1
Check Table for User Field 1
|
ZZUSERFLD1 |