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
I have Comcast Internet and have it connected to a Motorla Surfboard modem and have that running directly to a 2TB Time Capsule. The TC is serving as our time machine as well as our wireless router. We lost power in a storm a week ago and can no long [More]
Hello! Ive plugged my Ipod into my laptop with Itunes open and it normally syncs automatically, when i came to do it today it wont sync and when i try to do it from the file menu the sync option is greyed out. Itunes wont even show my Ipod on the lef [More]
Hello. Traditionally I have used the Finder search (Command F) to search for words in my stickies. It doesnt seem to work in Mountain Lion and is driving me nuts. I keep a lot of useful info in floating stickies. Does anyone have a solution to this? [More]
I open a video and sound plays, I log out, when I log back in, I don't have sound. I have to restart my computer. Why do I loose the sound? This has only been happening recently.Did you already try the provided tips in this article about troubleshoot [More]
Bonjour, J'ai deux application qui doivent tourner sur la cible PXI sous l'OS temps réel Pharlap. La première fait l'acquisition de signaux logiques et analogiques via les cartes présentes sur le châssis PXI. Le téléchargement de cette Dll vers la c [More]
After trying every possible solution proposed to resolve my wifi connection problems after upgrading to iOS6'the only solution left is to purchase another router. Today an Apple tech support rep told me wifi connection was hardware related only and h [More]
How can I get Win 10 to open to my prefered user account?  It insists on going to my Administrative account.Hi, We could click the Back button beside the account Picture, then the screen would list the account available on this PC: After that, we cou [More]
the submit button has disappeared off a form - any ideas?Lucia It's difficult for me to answer the questions easily, as it was one of our customers who had the difficulty, not us. We have navigated around the issue now, and all other customers seem t [More]
Hi all, Need your help! I have a use case where I need to provide user a dropdown list in the Blueprint so that they can select a project number. The project numbers are dynamic and can be exported to a .csv file and I can then write a PS script to c [More]
On the last week  I upgraded my Lenovo M58p (model 6088) to Windows 8.1_64 (Enterprise) and encountered the problem in which the drivers for the following were not installed and couldn't be located .... PCI Serial Port In the model page there is no i [More]