Sitemap

Amicuk Programming Answers

View on ekpo,ekbe quantities are appearing twice

-0001-11-30   Views:1

Advertisement

hi experts, I have created view based on EKPO, EKBE. Key is EBELN in the VIEW. When i check the data in VIEW the data appearing twice from both the tables. for example EBELN   EBELP QUANTITY 10000      10         20 10000      10         20 so its ap

hi experts,
I have created view based on EKPO, EKBE.
Key is EBELN in the VIEW.
When i check the data in VIEW the data appearing twice from both the tables.
for example
EBELN   EBELP QUANTITY
10000      10         20
10000      10         20
so its appearing twice which is not right.
when i check the ME23N
it shows only
EBELN    EBELP    QUANTITY
10000      10             20.
what is the problem, and wot is the solution for this?
regards
venuscm

The replay answer
Advertisement
hi,
join the two tables on as many key fields as possible, eg mandt, gjahr, bukrs, etc.
Harshita Saxena

Go to See the other 4 answers

View on ekpo,ekbe quantities are appearing twice

Category:DefaultRelease time:-0001-11-30Views:130

hi experts, I have created view based on EKPO, EKBE. Key is EBELN in the VIEW. When i check the data in VIEW the data appearing twice from both the tables. for example EBELN   EBELP QUANTITY 10000      10         20 10000      10         20 so its ap[More]

Buffered Function Modules for EKKO, EKPO, EKBE, EKES etc

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Could you please let me know of some buffered function modules for reading data from EKKO EKPO EKBE EKES EKET? Regards, SurajTry BAPI_PO_GETDETAIL  , BAPI_PO_GETITEMS  , BAPI_PO_GET_LISTRead other 2 answers[More]

Datasource for the table EKKO,EKPO, EKBE, BKPF, BSEG

Category:DefaultRelease time:-0001-11-30Views:130

Hello Gurus, I am having a requirement wher i need to create report for the fields coming from the above tables. pls let me know if der is any such data source from which i can get data for all the tables EKKO,EKPO,EKBE,BKPF,BSEG. If der is no single[More]

In BDCP table I am not getting any entries for EKKO,EKPO,EKBE,EKET,EBAN

Category:DefaultRelease time:-0001-11-30Views:130

In BDCP table I am not getting any entries for EKKO,EKPO,EKBE,EKET,EBAN tables. But there are entries for many other tables. I have got objects for EKKO,EKPO,EKBE,EKET,EBAN tables from TCDOB tables.Hi Avishek,    Let me explain the meaning of Change[More]

Function module for getting ekko ekpo ekbe, eket data for material & plant

Category:DefaultRelease time:2015-10-11Views:130

Hi  experts,      I need to get data for me31l transactional data......for that i need ekbe purchasing document and      material documents based on given material and plant and posting date or crop.....     Please reply as soon as possible.. Thanks[More]

Generic DataSource by View on EKBE table.

Category:DefaultRelease time:-0001-11-30Views:130

Hi All I am also trying to create View based on EKBE table . I am getting some errors even through  I have included at reference table ( EKBE,EKKO and T001)  with respective fields. View is Ok, only when I try to activate DataSource in  RSO2 , I am g[More]

Finding Sum of grouped lines / Tables EKKO, EKPO

Category:DefaultRelease time:-0001-11-30Views:130

Hi, am using the following tables: TABLES: ekko,ekpo. with Inner Join select ekkobukrs ekkoebeln ekkoaedat ekkobsart ekkoekgrp ekkolifnr ekkowaers ekkowkurs ekkoernam ekpobrtwr    into CORRESPONDING FIELDS OF TABLE itab from ekko     inner join EKPO[More]

View using Material master,Vendor master and PO tables

Category:DefaultRelease time:-0001-11-30Views:130

Hello folks. There is a requirement to create view using material master tables ( MARA,MARC,MARD,MAKT & MBEW ) , vendor master tables ( LFA1 & LFB1) and Purchase order tables ( EKKO & EKPO tables). I have created the attribute views for materi[More]

REPORT FOR SUBCONTRACTING

Category:DefaultRelease time:2015-10-11Views:130

DEAR FRIENDS, I am making a program for tracking the materials given (mb1b 541 movt.) for subcontracting and taken by me (101 for actual good receipt, 543 for the given material- stock type inward, 545 for the scrap returns). but while i made the pro[More]

GR and IR as separate columns in the BEx report

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am working on a Purchasing report in which the user needs the snap shot of PO history,Like PO no.,Item,Netprice,PO Qty,Net order value,GR no.,IR number etc. I created a view on EKPO and EKBE.Here,based on the BELNR(Material document) field we a[More]

In MR11 - u201CNo (suitable) purchase order/item found     u201C.

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, We are having issue with MR11 in 4.6 B. While doing MR11 for a PO where Delivery costs have not been balanced, we are getting message u201CNo (suitable) purchase order/item found     u201C. In the research, we found that in 4.6 B, MR11 is[More]

Hot
There MUST be a simple way to update ActiveX References when a third party library has been updated to a new version. I had made up several VI's that passed the ActiveX Class Refnum around.  This refnum was generated by right-clicking on a standard A [More]
Am trying to print from my Toshiba laptop running Windows 8 to my HP Envy 4500 wirelessly. Works fine from my ipad, works fine from my desktop and laptop running Windows 7. I have uninstalled and re-installed the printer driver 5 times. Printer is re [More]
Can anybody send the script for the api to update quanitiy in the subinventory.This will be helpfull .Pls send as soon as possible. Regards Kumar.936453 wrote: Hi All, Is there any Api to subinv transfer and update quantity in sub inv.I am waiting fo [More]
Hello, everyone. I'm trying to create a new work center in HR related to an organizational unit by using the bapi: BAPI_HRMASTER_SAVE_REPL_MULT. For some reason I'm getting an error message: "Object [work_center_id] does not exist in status 1". [More]
Dear all, Im a beginner in Livecache administration I would like to schedule backup of livecache from LC10 . The Following are my System Details Scm : SAP SCM 5.10 Lc version :KERNEL    7.7.04   BUILD 037-123-218-794 DBM Server : DBMServer 7.7.04   B [More]
Hi,    There was a sap script written in language DE(original language) , now i also have the same script in EN ,i have made some changes to the EN form. Now my program runs in many languages like JA,KO etc.. when i call the script i want it to call [More]
I am on OS X 10.9.2.  When downloading the free trial from Adobe site, Application Manager briefly opens, and then crashes with an error box saying "Adobe Application Manager quit unexpectedly."  Any ideas?  I'll try to reinstall the App Manager [More]
we have two lists work order list and estimation list. we developed infopath form for work order list , in that we have work order field we don't enter the value of that field after filling the all fields when i clicked save button work order ID fiel [More]
Hi I need to collect info about io devices and cpu. but i cannot use prtdiag. is there any way to collect this information on solaris machine.... may any available c APIs Thanks in advance. Nageshyep.... prtconf -vp | grep <wot u r looking 4>Read ot [More]
I've thinking about this thing for a very long time - a thing that's really bugging me: the swatches panel's "list types". Currently you can list your swatches as small or large thumbnails - or in a small or large list. Neither is really "s [More]