SAP table EBKN (Purchase Requisition Account Assignment)
SAP table EBKN has 4 primary key fields being MANDT,BANFN,BNFPO,ZEBKN.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| BANFN | Purchase Requisition Number | CHAR | 10 | 0 | BANFN | ||
| BNFPO | Item number of purchase requisition | NUMC | 5 | 0 | EBAN | BNFPO | |
| ZEBKN | Serial number for PReq account assignment segment | NUMC | 2 | 0 | DZEBKN | ||
| LOEKZ | Deletion Indicator in Purchasing Document | CHAR | 1 | 0 | ELOEK | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| MENGE | Purchase requisition quantity | QUAN | 13 | 3 | BAMNG | ||
| VPROZ | Distribution percentage in the case of multiple acct assgt | DEC | 3 | 1 | VPROZ | ||
| SAKTO | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| PROJN | Old: Project number : No longer used --> PS_POSNR | CHAR | 16 | 0 | PROJN | ||
| VBELN | Sales and Distribution Document Number | CHAR | 10 | 0 | VBELN | ||
| VBELP | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||
| VETEN | Schedule Line Number | NUMC | 4 | 0 | VBEP | ETENR | |
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLA | ANLN2 | |
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| WEMPF | Goods Recipient | CHAR | 12 | 0 | WEMPF | ||
| ABLAD | Unloading Point | CHAR | 25 | 0 | ABLAD | ||
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| XBKST | Posting to cost center? | CHAR | 1 | 0 | XBKST | ||
| XBAUF | Post To Order | CHAR | 1 | 0 | XBAUF | ||
| XBPRO | Post to project | CHAR | 1 | 0 | XBPRO | ||
| KSTRG | Cost Object | CHAR | 12 | 0 | KSTRG | ||
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||
| PRCTR | Profit Center | CHAR | 10 | 0 | PRCTR | ||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PRPS | PS_PSP_PNR | |
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | AUFK | NPLNR | |
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||
| APLZL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||
| VPTNR | Partner account number | CHAR | 10 | 0 | KNA1 | JV_PART | |
| FIPOS | Commitment Item | CHAR | 14 | 0 | FMFPO | FIPOS | |
| RECID | Recovery Indicator | CHAR | 2 | 0 | JV_RECIND | ||
| FISTL | Funds Center | CHAR | 16 | 0 | FISTL | ||
| GEBER | Fund | CHAR | 10 | 0 | BP_GEBER | ||
| FKBER | Functional Area | CHAR | 16 | 0 | FKBER | ||
| DABRZ | Reference date for settlement | DATS | 8 | 0 | DABRBEZ | ||
| NETWR | Net Order Value in PO Currency | CURR | 13 | 2 | BWERT | ||
| AUFPL_ORD | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| APLZL_ORD | General counter for order | NUMC | 8 | 0 | CO_APLZL | ||
| EXTWBSELEMENT | Work Breakdown Structure Element (WBS Element) | CHAR | 24 | 0 | PS_POSID | ||
| EXTVORNR | Network Activity | CHAR | 4 | 0 | EXTVORNR | ||
| SERVICE_DOC_TYPE | Service Document Type | CHAR | 4 | 0 | FCO_SRVDOC_TYPE | ||
| SERVICE_DOC_ID | Service Document ID | CHAR | 10 | 0 | FCO_SRVDOC_ID | ||
| SERVICE_DOC_ITEM_ID | Service Document Item ID | NUMC | 6 | 0 | FCO_SRVDOC_ITEM_ID | ||
| KBLNR | Document Number for Earmarked Funds | CHAR | 10 | 0 | * | KBLNR | |
| KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | 0 | * | KBLPOS | |
| LSTAR | Activity Type | CHAR | 6 | 0 | CSLA | LSTAR | |
| PRZNR | Business Process | CHAR | 12 | 0 | CBPR | CO_PRZNR | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| FM_SPLIT_BATCH | Batch to group results from an PSM assignment distribution | NUMC | 3 | 0 | FMSP_SPLIT_BATCH | ||
| FM_SPLIT_BEGRU | Authorization group for PSM account assignment distribution | CHAR | 4 | 0 | * | FMSP_SPLIT_AUTG | |
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | FM_BUDGET_PERIOD | ||
| DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| FMFGUS_KEY | United States Federal Government Fields | CHAR | 22 | 0 | FMFG_US_KEY | ||
| EGRUP | Equity group | CHAR | 3 | 0 | * | JV_EGROUP | |
| VNAME | Joint venture | CHAR | 6 | 0 | * | JV_NAME | |
| TCOBJNR | Object number | CHAR | 22 | 0 | * | J_OBJNR | |
| DATEOFSERVICE | Date of Service | DATS | 8 | 0 | VVBEACTDATE | ||
| NOTAXCORR | Do Not Consider Item in Input Tax Correction | CHAR | 1 | 0 | VVREITNOTAXCORR | ||
| DIFFOPTRATE | Real Estate Option Rate | DEC | 9 | 6 | POPTSATZ | ||
| HASDIFFOPTRATE | Use Different Option Rate | CHAR | 1 | 0 | VVREITUSEDIFFOPTRATE |
EBKN foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EBKN | ANLN1 | ANLH | Main asset number | BUKRS |
| 0 EBKN | ANLN1 | ANLH | Main asset number | ANLN1 |
| 1 EBKN | ANLN2 | ANLA | Asset Master Record Segment | BUKRS |
| 1 EBKN | ANLN2 | ANLA | Asset Master Record Segment | ANLN1 |
| 1 EBKN | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| 0 EBKN | AUFNR | AUFK | Order master data | AUFNR |
| 1 EBKN | BNFPO | EBAN | Purchase Requisition | BANFN |
| 1 EBKN | BNFPO | EBAN | Purchase Requisition | BNFPO |
| 0 EBKN | FIPOS | FMFPO | FIFM: Commitment Item | MANDT |
| 0 EBKN | FIPOS | FMFPO | FIFM: Commitment Item | FIKRS |
| 0 EBKN | FIPOS | FMFPO | FIFM: Commitment Item | DATBIS |
| 1 EBKN | GSBER | TGSB | Business Areas | MANDT |
| 1 EBKN | GSBER | TGSB | Business Areas | GSBER |
| 0 EBKN | KOKRS | TKA01 | Controlling Areas | MANDT |
| 1 EBKN | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 1 EBKN | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 1 EBKN | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 1 EBKN | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 0 EBKN | LSTAR | CSLA | Activity master | MANDT |
| 0 EBKN | LSTAR | CSLA | Activity master | KOKRS |
| 0 EBKN | LSTAR | CSLA | Activity master | DATBI |
| 1 EBKN | MANDT | T000 | Clients | MANDT |
| 0 EBKN | NPLNR | AUFK | Order master data | AUFNR |
| 1 EBKN | PRZNR | CBPR | CO-ABC: Activity Master Table | KOKRS |
| 1 EBKN | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| 1 EBKN | PRZNR | CBPR | CO-ABC: Activity Master Table | DATBI |
| 0 EBKN | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 EBKN | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 EBKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 EBKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 EBKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 EBKN | VETEN | VBEP | Sales Document: Schedule Line Data | MANDT |
| 0 EBKN | VETEN | VBEP | Sales Document: Schedule Line Data | VBELN |
| 0 EBKN | VETEN | VBEP | Sales Document: Schedule Line Data | POSNR |
| 0 EBKN | VETEN | VBEP | Sales Document: Schedule Line Data | ETENR |
| 1 EBKN | VPTNR | KNA1 | General Data in Customer Master | MANDT |
| 1 EBKN | VPTNR | KNA1 | General Data in Customer Master | KUNNR |