1. Home
  2. Resources
  3. SAP Tables
  4. EKKN - Account Assignment in Purchasing Document

SAP Table EKKN

Account Assignment in Purchasing Document

EKKN (Account Assignment in Purchasing Document) 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 EKKN to other SAP tables.

EKKN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
LOEKZ Deletion Indicator: Purchasing Document Account Assignment KLOEK CHAR 1 0
X Yes
NULL No
AEDAT Date on Which Record Was Created ERDAT DATS 8 0
KFLAG Change flag: Purchasing (currently not used) EFLAG CHAR 1 0
X Yes
NULL No
MENGE Quantity MENGE_D QUAN 13 3
VPROZ Distribution Percentage in Case of Multiple Account Assgt VPROZ DEC 3 1
NETWR Net Order Value in PO Currency BWERT CURR 13 2
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_CO VBUK CHAR 10 0
VBELP Sales Document Item POSNR_CO VBUP NUMC 6 0
VETEN Delivery Schedule Line Number ETENR VBEP NUMC 4 0
KZBRB Gross requirements indicator KZBRB CHAR 1 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
X Yes
NULL No
XBAUF Post To Order XBAUF CHAR 1 0
X Yes
NULL No
XBPRO Post to project XBPRO CHAR 1 0
X Yes
NULL No
EREKZ Final Invoice Indicator EREKZ CHAR 1 0
X Yes
NULL No
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
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
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
NAVNW Non-deductible input tax NAVNW CURR 13 2
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
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 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
AA_FINAL_IND Final Account Assignment Indicator AA_FINAL_IND CHAR 1 0
X Yes
NULL No
AA_FINAL_REASON Final Account Assignment Reason Code AA_FINAL_REASON T163RC CHAR 2 0
AA_FINAL_QTY Final Account Assignment Quantity AA_FINAL_QTY QUAN 13 3
AA_FINAL_QTY_F Final Account Assignment Quantity (Floating Point Number) AA_FINAL_QTY_F FLTP 16 16
MENGE_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
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
X TRUE
NULL FALSE
DIFFOPTRATE Real estate option rate POPTSATZ DEC 9 6
HASDIFFOPTRATE Use Different Option Rate VVREITUSEDIFFOPTRATE CHAR 1 0
X TRUE
NULL FALSE

EKKN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKKN AA_FINAL_REASON SYST MANDT T163RC Reason for Final Account Assignment Indicator MANDT
EKKN AA_FINAL_REASON EKKN AA_FINAL_REASON T163RC Reason for Final Account Assignment Indicator AA_FINAL_REASON
EKKN ANLN1 EKKN ANLN1 ANLH Main asset number ANLN1
EKKN ANLN1 EKKN MANDT ANLH Main asset number MANDT
EKKN ANLN1 T001 BUKRS ANLH Main asset number BUKRS
EKKN ANLN2 EKKN MANDT ANLA Asset Master Record Segment MANDT
EKKN ANLN2 T001 BUKRS ANLA Asset Master Record Segment BUKRS
EKKN ANLN2 EKKN ANLN1 ANLA Asset Master Record Segment ANLN1
EKKN ANLN2 EKKN ANLN2 ANLA Asset Master Record Segment ANLN2
EKKN AUFNR EKKN MANDT AUFK Order master data MANDT
EKKN AUFNR EKKN AUFNR AUFK Order master data AUFNR
EKKN EBELN EKKN MANDT EKKO Purchasing Document Header MANDT
EKKN EBELN EKKN EBELN EKKO Purchasing Document Header EBELN
EKKN EBELP EKKN EBELP EKPO Purchasing Document Item EBELP
EKKN EBELP EKKN MANDT EKPO Purchasing Document Item MANDT
EKKN EBELP EKKN EBELN EKPO Purchasing Document Item EBELN
EKKN FIPOS EKKN MANDT FMFPO FIFM: Commitment Item MANDT
EKKN FIPOS T001 FIKRS FMFPO FIFM: Commitment Item FIKRS
EKKN FIPOS EKKN FIPOS FMFPO FIFM: Commitment Item FIPOS
EKKN FIPOS EKKN AEDAT FMFPO FIFM: Commitment Item DATBIS
EKKN GSBER EKKN MANDT TGSB Business Areas MANDT
EKKN GSBER EKKN GSBER TGSB Business Areas GSBER
EKKN KOKRS EKKN KOKRS TKA01 Controlling Areas KOKRS
EKKN KOKRS EKKN MANDT TKA01 Controlling Areas MANDT
EKKN KOSTL EKKN KOKRS CSKS Cost Center Master Data KOKRS
EKKN KOSTL EKKN KOSTL CSKS Cost Center Master Data KOSTL
EKKN KOSTL EKKN AEDAT CSKS Cost Center Master Data DATBI
EKKN KOSTL EKKN MANDT CSKS Cost Center Master Data MANDT
EKKN LSTAR * CSLA Activity master DATBI
EKKN LSTAR EKKN MANDT CSLA Activity master MANDT
EKKN LSTAR EKKN KOKRS CSLA Activity master KOKRS
EKKN LSTAR EKKN LSTAR CSLA Activity master LSTAR
EKKN MANDT EKKN MANDT T000 Clients MANDT
EKKN NPLNR EKKN MANDT AUFK Order master data MANDT
EKKN NPLNR EKKN NPLNR AUFK Order master data AUFNR
EKKN PRZNR EKKN MANDT CBPR CO-ABC: Activity Master Table MANDT
EKKN PRZNR EKKN KOKRS CBPR CO-ABC: Activity Master Table KOKRS
EKKN PRZNR EKKN PRZNR CBPR CO-ABC: Activity Master Table PRZNR
EKKN PRZNR * CBPR CO-ABC: Activity Master Table DATBI
EKKN PS_PSP_PNR EKKN MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
EKKN PS_PSP_PNR EKKN PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
EKKN SAKTO EKKN SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
EKKN SAKTO EKKN MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
EKKN SAKTO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
EKKN VBELN EKKN VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
EKKN VBELN EKKN MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
EKKN VBELP EKKN MANDT VBUP Sales Document: Item Status MANDT
EKKN VBELP EKKN VBELN VBUP Sales Document: Item Status VBELN
EKKN VBELP EKKN VBELP VBUP Sales Document: Item Status POSNR
EKKN VETEN EKKN MANDT VBEP Sales Document: Schedule Line Data MANDT
EKKN VETEN EKKN VBELN VBEP Sales Document: Schedule Line Data VBELN
EKKN VETEN EKKN VBELP VBEP Sales Document: Schedule Line Data POSNR
EKKN VETEN EKKN VETEN VBEP Sales Document: Schedule Line Data ETENR
EKKN VPTNR EKKN MANDT KNA1 General Data in Customer Master MANDT
EKKN VPTNR EKKN VPTNR KNA1 General Data in Customer Master KUNNR
EKKN ZZREGION SYST MANDT ZREG User Defined Regions MANDT
EKKN ZZREGION EKKN ZZREGION ZREG User Defined Regions ZZREGION
EKKN ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
EKKN ZZSPREG EKKN ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
EKKN ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
EKKN ZZSTATE * T005S Taxes: Region (Province) Key LAND1
EKKN ZZSTATE EKKN ZZSTATE T005S Taxes: Region (Province) Key BLAND
EKKN ZZUSERFLD1 EKKN ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
EKKN ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT