SAP table EKKN (Account Assignment in Purchasing Document)

The EKKN table in SAP contains account assignment data for purchasing documents. It links procurement activities to specific cost objects or accounts, ensuring proper financial tracking and integration.

Key Features:

The EKKN table is critical for aligning procurement activities with financial and controlling processes in SAP.

SAP table EKKN has 4 primary key fields being MANDT,EBELN,EBELP,ZEKKN.

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
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
LOEKZ Deletion Indicator: Purchasing Document Account Assignment CHAR 1 0 KLOEK
AEDAT Date on which the record was created DATS 8 0 ERDAT
KFLAG Change flag: Purchasing (currently not used) CHAR 1 0 EFLAG
MENGE Quantity QUAN 13 3 MENGE_D
VPROZ Distribution percentage in the case of multiple acct assgt DEC 3 1 VPROZ
NETWR Net Order Value in PO Currency CURR 13 2 BWERT
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_CO
VBELP Sales Document Item NUMC 6 0 POSNR_CO
VETEN Schedule Line Number NUMC 4 0 VBEP ETENR
KZBRB Gross requirements indicator CHAR 1 0 KZBRB
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
EREKZ Final Invoice Indicator CHAR 1 0 EREKZ
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
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
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
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
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
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
NAVNW Non-deductible input tax CURR 13 2 NAVNW
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
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
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
AA_FINAL_IND Final Account Assignment Indicator CHAR 1 0 AA_FINAL_IND
AA_FINAL_REASON Final Account Assignment Reason Code CHAR 2 0 T163RC AA_FINAL_REASON
AA_FINAL_QTY Final Account Assignment Quantity QUAN 13 3 AA_FINAL_QTY
AA_FINAL_QTY_F Final Account Assignment Quantity (Floating Point Number) FLTP 16 16 AA_FINAL_QTY_F
MENGE_F Quantity (Floating Point Number - Internal Field) FLTP 16 16 MENGE_F
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
EGRUP Equity group CHAR 3 0 * JV_EGROUP
VNAME Joint venture CHAR 6 0 * JV_NAME
KBLNR_CAB Referenced Funds Precommitment CHAR 10 0 * REFPRECOM
KBLPOS_CAB Item in Referenced Funds Precommitment NUMC 3 0 * REFPREPOS
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

EKKN foreign key relationships

Table Field Check Table Check Field
0 EKKN AA_FINAL_REASON T163RC Reason for Final Account Assignment Indicator MANDT
0 EKKN AA_FINAL_REASON T163RC Reason for Final Account Assignment Indicator AA_FINAL_REASON
1 EKKN ANLN1 ANLH Main asset number BUKRS
1 EKKN ANLN1 ANLH Main asset number ANLN1
0 EKKN ANLN2 ANLA Asset Master Record Segment BUKRS
0 EKKN ANLN2 ANLA Asset Master Record Segment ANLN1
0 EKKN ANLN2 ANLA Asset Master Record Segment ANLN2
1 EKKN AUFNR AUFK Order master data AUFNR
0 EKKN EBELN EKKO Purchasing Document Header EBELN
1 EKKN EBELP EKPO Purchasing Document Item MANDT
1 EKKN EBELP EKPO Purchasing Document Item EBELN
0 EKKN FIPOS FMFPO FIFM: Commitment Item MANDT
0 EKKN FIPOS FMFPO FIFM: Commitment Item FIKRS
0 EKKN FIPOS FMFPO FIFM: Commitment Item DATBIS
1 EKKN GSBER TGSB Business Areas MANDT
1 EKKN GSBER TGSB Business Areas GSBER
0 EKKN KOKRS TKA01 Controlling Areas MANDT
1 EKKN KOSTL CSKS Cost Center Master Record MANDT
1 EKKN KOSTL CSKS Cost Center Master Record KOKRS
1 EKKN KOSTL CSKS Cost Center Master Record KOSTL
1 EKKN KOSTL CSKS Cost Center Master Record DATBI
0 EKKN LSTAR CSLA Activity master MANDT
0 EKKN LSTAR CSLA Activity master KOKRS
0 EKKN LSTAR CSLA Activity master DATBI
1 EKKN MANDT T000 Clients MANDT
0 EKKN NPLNR AUFK Order master data AUFNR
1 EKKN PRZNR CBPR CO-ABC: Activity Master Table KOKRS
1 EKKN PRZNR CBPR CO-ABC: Activity Master Table PRZNR
1 EKKN PRZNR CBPR CO-ABC: Activity Master Table DATBI
0 EKKN PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 EKKN PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 EKKN SAKTO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 EKKN SAKTO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 EKKN SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 EKKN VETEN VBEP Sales Document: Schedule Line Data MANDT
0 EKKN VETEN VBEP Sales Document: Schedule Line Data VBELN
0 EKKN VETEN VBEP Sales Document: Schedule Line Data POSNR
0 EKKN VETEN VBEP Sales Document: Schedule Line Data ETENR
1 EKKN VPTNR KNA1 General Data in Customer Master MANDT
1 EKKN VPTNR KNA1 General Data in Customer Master KUNNR