SAP ABAP Table EKKN (Account Assignment in Purchasing Document)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | EKKN | Table Relationship Diagram |
Short Description | Account Assignment in Purchasing Document |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
3 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
4 | ZEKKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
5 | LOEKZ | KLOEK | XFELD | CHAR | 1 | 0 | Deletion Indicator: Purchasing Document Account Assignment | ||
6 | AEDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
7 | KFLAG | EFLAG | XFELD | CHAR | 1 | 0 | Change flag: Purchasing (currently not used) | ||
8 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
9 | VPROZ | VPROZ | VPROZ | DEC | 3 | 1 | Distribution percentage in the case of multiple acct assgt | ||
10 | NETWR | BWERT | WERT7 | CURR | 13 | 2 | Net Order Value in PO Currency | ||
11 | SAKTO | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
12 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
13 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
14 | PROJN | PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
15 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | ||
16 | VBELP | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
17 | VETEN | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
18 | KZBRB | KZBRB | CHAR1 | CHAR | 1 | 0 | Gross requirements indicator | ||
19 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
20 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
21 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
22 | WEMPF | WEMPF | WEMPF | CHAR | 12 | 0 | Goods recipient | ||
23 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
24 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
25 | XBKST | XBKST | XFELD | CHAR | 1 | 0 | Posting to cost center? | ||
26 | XBAUF | XBAUF | XFELD | CHAR | 1 | 0 | Post To Order | ||
27 | XBPRO | XBPRO | XFELD | CHAR | 1 | 0 | Post to project | ||
28 | EREKZ | EREKZ | XFELD | CHAR | 1 | 0 | Final Invoice Indicator | ||
29 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
30 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
31 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
32 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
33 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | AUFK | |
34 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
35 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
36 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
37 | VPTNR | JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | * | |
38 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | FMFPO | |
39 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
40 | .INCLUDE | 0 | 0 | ||||||
41 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
42 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
43 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
44 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
45 | AUFPL_ORD | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
46 | APLZL_ORD | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
47 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
48 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
49 | NAVNW | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
50 | .INCLUDE | 0 | 0 | Include for the Reduction of Funds Reservations (FM) | |||||
51 | KBLNR | KBLNR | KBLNR | CHAR | 10 | 0 | Document Number for Earmarked Funds | * | |
52 | KBLPOS | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | EKKN | AUFNR | AUFK | AUFNR | REF | 1 | N |
2 | EKKN | EBELN | EKKO | EBELN | KEY | 1 | CN |
3 | EKKN | EBELP | EKPO | EBELP | KEY | 1 | CN |
4 | EKKN | FIPOS | FMFPO | FIPOS | REF | C | CN |
5 | EKKN | KOKRS | TKA01 | KOKRS | REF | 1 | N |
6 | EKKN | KOSTL | CSKS | KOSTL | KEY | 1 | CN |
7 | EKKN | MANDT | T000 | MANDT | KEY | 1 | N |
8 | EKKN | NPLNR | AUFK | AUFNR | REF | 1 | CN |
9 | EKKN | PS_PSP_PNR | PRPS | PSPNR | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |