SAP Table EBKN
Purchase Requisition Account Assignment
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.
EBKN table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||
XBAUF | Post To Order | XBAUF | CHAR | 1 | 0 |
Possible values
|
||||||
XBPRO | Post to project | XBPRO | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
DIFFOPTRATE | Real estate option rate | POPTSATZ | DEC | 9 | 6 | |||||||
HASDIFFOPTRATE | Use Different Option Rate | VVREITUSEDIFFOPTRATE | CHAR | 1 | 0 |
Possible values
|
EBKN foreign key relationships
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 |