SAP ABAP View V_EKKNP (Read Purchase Order Acc. Assignment via Ext. WBS Element No.)
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
View Type | D | Database View |
Database View | V_EKKNP | |
Short Description | Read Purchase Order Acc. Assignment via Ext. WBS Element No. | |
Root table | EKKN | Account Assignment in Purchasing Document |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | EKKN | EKKN | ||
2 | PRPS |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | EKKN | MANDT | JL | EQ | 0 | 0 | ||||
2 | PRPS | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | EKKN | PS_PSP_PNR | JL | EQ | 0 | 0 | ||||
4 | PRPS | PSPNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | * | EKKN | * | |||||
2 | MANDT | EKKN | MANDT | MANDT | Client | |||
3 | EBELN | EKKN | EBELN | EBELN | Purchasing Document Number | |||
4 | EBELP | EKKN | EBELP | EBELP | Item Number of Purchasing Document | |||
5 | ZEKKN | EKKN | ZEKKN | DZEKKN | Sequential Number of Account Assignment | |||
6 | LOEKZ | EKKN | LOEKZ | KLOEK | Deletion Indicator: Purchasing Document Account Assignment | |||
7 | AEDAT | EKKN | AEDAT | ERDAT | Date on which the record was created | |||
8 | KFLAG | EKKN | KFLAG | EFLAG | Change flag: Purchasing (currently not used) | |||
9 | MENGE | EKKN | MENGE | MENGE_D | Quantity | |||
10 | VPROZ | EKKN | VPROZ | VPROZ | Distribution percentage in the case of multiple acct assgt | |||
11 | NETWR | EKKN | NETWR | BWERT | Net Order Value in PO Currency | |||
12 | SAKTO | EKKN | SAKTO | SAKNR | G/L Account Number | |||
13 | GSBER | EKKN | GSBER | GSBER | Business Area | |||
14 | KOSTL | EKKN | KOSTL | KOSTL | Cost Center | |||
15 | PROJN | EKKN | PROJN | PROJN | Old: Project number : No longer used --> PS_POSNR | |||
16 | VBELN | EKKN | VBELN | VBELN_CO | Sales and Distribution Document Number | |||
17 | VBELP | EKKN | VBELP | POSNR_CO | Sales Document Item | |||
18 | VETEN | EKKN | VETEN | ETENR | Schedule line | |||
19 | KZBRB | EKKN | KZBRB | KZBRB | Gross requirements indicator | |||
20 | ANLN1 | EKKN | ANLN1 | ANLN1 | Main Asset Number | |||
21 | ANLN2 | EKKN | ANLN2 | ANLN2 | Asset Subnumber | |||
22 | AUFNR | EKKN | AUFNR | AUFNR | Order Number | |||
23 | WEMPF | EKKN | WEMPF | WEMPF | Goods recipient | |||
24 | ABLAD | EKKN | ABLAD | ABLAD | Unloading Point | |||
25 | KOKRS | EKKN | KOKRS | KOKRS | Controlling Area | |||
26 | XBKST | EKKN | XBKST | XBKST | Posting to cost center? | |||
27 | XBAUF | EKKN | XBAUF | XBAUF | Post To Order | |||
28 | XBPRO | EKKN | XBPRO | XBPRO | Post to project | |||
29 | EREKZ | EKKN | EREKZ | EREKZ | Final Invoice Indicator | |||
30 | KSTRG | EKKN | KSTRG | KSTRG | Cost Object | |||
31 | PAOBJNR | EKKN | PAOBJNR | RKEOBJNR | Profitability Segment Number (CO-PA) | |||
32 | PRCTR | EKKN | PRCTR | PRCTR | Profit Center | |||
33 | PS_PSP_PNR | EKKN | PS_PSP_PNR | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | |||
34 | NPLNR | EKKN | NPLNR | NPLNR | Network Number for Account Assignment | |||
35 | AUFPL | EKKN | AUFPL | CO_AUFPL | Routing number of operations in the order | |||
36 | IMKEY | EKKN | IMKEY | IMKEY | Internal Key for Real Estate Object | |||
37 | APLZL | EKKN | APLZL | CIM_COUNT | Internal counter | |||
38 | VPTNR | EKKN | VPTNR | JV_PART | Partner account number | |||
39 | FIPOS | EKKN | FIPOS | FIPOS | Commitment Item | |||
40 | RECID | EKKN | RECID | JV_RECIND | Recovery Indicator | |||
41 | FISTL | EKKN | FISTL | FISTL | Funds Center | |||
42 | GEBER | EKKN | GEBER | BP_GEBER | Fund | |||
43 | FKBER | EKKN | FKBER | FKBER | Functional Area | |||
44 | DABRZ | EKKN | DABRZ | DABRBEZ | Reference date for settlement | |||
45 | AUFPL_ORD | EKKN | AUFPL_ORD | CO_AUFPL | Routing number of operations in the order | |||
46 | APLZL_ORD | EKKN | APLZL_ORD | CO_APLZL | General counter for order | |||
47 | MWSKZ | EKKN | MWSKZ | MWSKZ | Tax on sales/purchases code | |||
48 | TXJCD | EKKN | TXJCD | TXJCD | Tax Jurisdiction | |||
49 | NAVNW | EKKN | NAVNW | NAVNW | Non-deductible input tax | |||
50 | KBLNR | EKKN | KBLNR | KBLNR | Document Number for Earmarked Funds | |||
51 | KBLPOS | EKKN | KBLPOS | KBLPOS | Earmarked Funds: Document Item | |||
52 | LSTAR | EKKN | LSTAR | LSTAR | Activity Type | |||
53 | PRZNR | EKKN | PRZNR | CO_PRZNR | Business Process | |||
54 | GRANT_NBR | EKKN | GRANT_NBR | GM_GRANT_NBR | Grant | |||
55 | BUDGET_PD | EKKN | BUDGET_PD | FM_BUDGET_PERIOD | FM: Budget Period | |||
56 | FM_SPLIT_BATCH | EKKN | FM_SPLIT_BATCH | FMSP_SPLIT_BATCH | Batch to group results from an PSM assignment distribution | |||
57 | FM_SPLIT_BEGRU | EKKN | FM_SPLIT_BEGRU | FMSP_SPLIT_AUTG | Authorization group for PSM account assignment distribution | |||
58 | AA_FINAL_IND | EKKN | AA_FINAL_IND | AA_FINAL_IND | Final Account Assignment Indicator | |||
59 | AA_FINAL_REASON | EKKN | AA_FINAL_REASON | AA_FINAL_REASON | Final Account Assignment Reason Code | |||
60 | AA_FINAL_QTY | EKKN | AA_FINAL_QTY | AA_FINAL_QTY | Final Account Assignment Quantity | |||
61 | AA_FINAL_QTY_F | EKKN | AA_FINAL_QTY_F | AA_FINAL_QTY_F | Final Account Assignment Quantity (Floating Point Number) | |||
62 | MENGE_F | EKKN | MENGE_F | MENGE_F | Quantity (Floating Point Number - Internal Field) | |||
63 | EGRUP | EKKN | EGRUP | JV_EGROUP | Equity group | |||
64 | VNAME | EKKN | VNAME | JV_NAME | Joint venture | |||
65 | TCOBJNR | EKKN | TCOBJNR | J_OBJNR | Object number | |||
66 | DATEOFSERVICE | EKKN | DATEOFSERVICE | VVBEACTDATE | Date of Service | |||
67 | NOTAXCORR | EKKN | NOTAXCORR | VVREITNOTAXCORR | Do Not Consider Item in Input Tax Correction | |||
68 | DIFFOPTRATE | EKKN | DIFFOPTRATE | POPTSATZ | Real Estate Option Rate | |||
69 | HASDIFFOPTRATE | EKKN | HASDIFFOPTRATE | VVREITUSEDIFFOPTRATE | Use Different Option Rate | |||
70 | POSID | PRPS | POSID | PS_POSID | Work Breakdown Structure Element (WBS Element) | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |