EKKN SAP (Account Assignment in Purchasing Document) Table details

Dictionary Type: Table
Description: Account Assignment in Purchasing Document




ABAP Code to SELECT data from EKKN
Related tables to EKKN
Access table EKKN




Table field list including key, data, relationships and ABAP select examples

EKKN is a standard SAP Table which is used to store Account Assignment in Purchasing Document data and is available within R/3 SAP systems depending on the version and release level.

The EKKN table consists of various fields, each holding specific information or linking keys about Account Assignment in Purchasing Document data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ZEKKN (Sequential Number of Account Assignment), LOEKZ (Deletion Indicator: Purchasing Document Account Assignment).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EKKN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
LOEKZDeletion Indicator: Purchasing Document Account Assignment KLOEKCHAR1XFELD
AEDATDate on Which Record Was Created ERDATDATS8DATUM
KFLAGChange flag: Purchasing (currently not used) EFLAGCHAR1XFELD
MENGEQuantity MENGE_DQUAN13(3) MENG13
VPROZDistribution Percentage in Case of Multiple Account Assgt VPROZDEC3(1) VPROZ
NETWRNet Order Value in PO Currency BWERTCURR13(2) WERT7
SAKTOG/L Account Number SAKNRCHAR10SKA1ALPHASAKNRSAKC_SAKNR
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
VBELNSales and Distribution Document Number VBELN_COCHAR10VBUKALPHAVBELNAUN
VBELPSales Document Item POSNR_CONUMC6VBUPPOSNRAPO
VETENDelivery Schedule Line Number ETENRNUMC4VBEPETENR
KZBRBGross requirements indicator KZBRBCHAR1CHAR1
ANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
WEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
ABLADUnloading Point ABLADCHAR25TEXT25
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
XBKSTPosting to cost center? XBKSTCHAR1XFELD
XBAUFPost To Order XBAUFCHAR1XFELD
XBPROPost to project XBPROCHAR1XFELD
EREKZFinal Invoice Indicator EREKZCHAR1XFELD
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12AUFKALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
VPTNRPartner account number JV_PARTCHAR10KNA1ALPHAKUNNR
FIPOSCommitment Item FIPOSCHAR14FMFPOFIPOSFIP
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
DABRZReference Date for Settlement DABRBEZDATS8DDAT
AUFPL_ORDRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZL_ORDGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
NAVNWNon-deductible input tax NAVNWCURR13(2) WERT7
KBLNRDocument Number for Earmarked Funds KBLNRCHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
PRZNRBusiness Process CO_PRZNRCHAR12CBPRALPHACO_PRZNRKWP
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
FM_SPLIT_BATCHBatch to group results from an PSM assignment distribution FMSP_SPLIT_BATCHNUMC3NUMC3
FM_SPLIT_BEGRUAuthorization group for PSM account assignment distribution FMSP_SPLIT_AUTGCHAR4Assigned to domainFMSP_SPLIT_AUTG
AA_FINAL_INDFinal Account Assignment Indicator AA_FINAL_INDCHAR1XFELD
AA_FINAL_REASONFinal Account Assignment Reason Code AA_FINAL_REASONCHAR2T163RCCHAR02
AA_FINAL_QTYFinal Account Assignment Quantity AA_FINAL_QTYQUAN13(3) MENG13
AA_FINAL_QTY_FFinal Account Assignment Quantity (Floating Point Number) AA_FINAL_QTY_FFLTP16(16)
MENGE_FQuantity (Floating Point Number - Internal Field) MENGE_FFLTP16(16)
.INCLU--AP 0
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
.INCLU--AP 0
TCOBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
DATEOFSERVICEDate of Service VVBEACTDATEDATS8DATUM
NOTAXCORRDo Not Consider Item in Input Tax Correction VVREITNOTAXCORRCHAR1BOOLE
DIFFOPTRATEReal estate option rate POPTSATZDEC9(6) POPTSATZ
HASDIFFOPTRATEUse Different Option Rate VVREITUSEDIFFOPTRATECHAR1BOOLE

Key field Non-key field



How do I retrieve data from SAP table EKKN using ABAP code

The following ABAP code Example will allow you to do a basic selection on EKKN to SELECT all data from the table
DATA: WA_EKKN TYPE EKKN.

SELECT SINGLE *
FROM EKKN
INTO CORRESPONDING FIELDS OF WA_EKKN
WHERE...

How to access SAP table EKKN

Within an ECC or HANA version of SAP you can also view further information about EKKN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!