SAP table EKKNU (Work Structure for Account Assignments in Purchasing Doc.-)

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
UPDKZ Type of Change CHAR 1 0 CDCHNGIND
D Delete
E Delete (single field documentation)
I Insert
J Insert (single field documentation)
U Change
ITEM_WITH_ERROR Checkbox CHAR 1 0 XFELD
No
X Yes
ID 4 Byte Signed Integer INT4 10 0 INT4
SWENR Business Entity Number CHAR 8 0 * SWENR
SGENR Building Number CHAR 8 0 * SGENR
SGRNR Land Number for BE CHAR 8 0 * SGRNR
SMENR Number of Rental Unit CHAR 8 0 * SMENR
SMIVE Lease-Out Number CHAR 13 0 SMIVE
SNKSL Service Charge Key CHAR 4 0 * SNKSL
SEMPSL Settlement Unit CHAR 5 0 * SEMPSL
SVWNR Management Contract Number CHAR 13 0 VVSVWNR
RECNNR Real Estate Contract Number CHAR 13 0 RECNNR
SBERI Correction item number CHAR 10 0 * SBERI
TCNO RE-FX: Number of Correction Object CHAR 16 0 VVREITTCNO
VORNR Operation/Activity Number CHAR 4 0 VORNR
PSP_PNR Work breakdown structure element (WBS element) CHAR 24 0 PSP_PNR
SHARE_F Quantity Share Account Assignment Line for Item FLTP 16 16 SHARE_F
MEASURE Funded Program CHAR 24 0 FM_MEASURE

EKKNU foreign key relationships

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