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
how do I grant access to a portal user from API I want to grant access to a user from an API, ie I need a command to grant "SCOTT" access to "EXAMPLE_APP" APPLICATION as an end user?Hi, I am assuming that you have already updated the E [More]
Hello, my problem is very simple. The quality of the image of my PDF is really horrible. I need to have a PDF file because in order to print a magazine, that's the file that I need. So I converted my picture: http://image.noelshack.com/fichiers/2013/ [More]
Hello! I having trouble to print out the array to a JTextArea. This is an asignment so please do not spoonfeed me with code. To test that I have added elements correctly in my array I sat it up to print out in console, wich works fine. Please give me [More]
Have been running Firefox without problem in both my own and my child's account on my laptop. Today, although Firefox still works normally in my own account, it does not launch at all in my child's account. Clicking on either the short cut or via All [More]
I'm still getting used to stacks in the dock. What I can't understand is why I have to look at icons that have nothing to do with the item? My Applications folder stack shows the Address Book item on top and my Utilities folder stack shows the Activi [More]
I recently downloaded Aperture 3.2.1 and after editing a couple photos (love that process!), tried to print them.  Both had horizontal lines across the entire photo.  I don't have this problem when printing from iPhoto. As an FYI, I have this problem [More]
Hi, We have done the required settings to transmit the PO to vendor via email. We now have a requirement where in the PO should be sent to multiple vendor email addresses. Pls suggest the solution for this. ThxHi Please create a Address Group with al [More]
as the title says im looking for an ebook reader for my n8 viewing post and forums, there are no preinstalled ebook reader ovi doesn't have any readers i can find pls suggest a compatible ebook reader for the n8 also provide link if you can ovi shoul [More]
So I was trying to download Adobe Premier because I am a youtuber and I heard you can work with multiple layers. Well, When I tried to download from Creative Cloud. It said "Error, Creative Cloud Desktop is running in the backgroun" When I check [More]
Hi, i created a PD infotype several days ago with 3 fields using PPCI. I have to change this infotype adding 5 more fields. I have modified the HRI9500 structure. The PPCI only allows me to create new infotypes, but i want to modificate an existing o [More]