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
Is there any Java API to read the Encrypted Values from Windows Registry settings ? My Java Application invokes a 3rd party Tool that writes the key/value to windows registry settings under : "HKLM\Software\<3rdparty>\dataValue". This entr [More]
I have an iphone 5S, using version 7.0.4. I had a TON of photos on my camera roll which was taking up space so this evening I synced and chose to import all 600 photos into iphoto (version 9.5.1). It took a while to import all the photos as expected [More]
I have a user who is getting a dialog box that says Registry editing has been disabled by your administrator.  This started happening after I copied the original user profile who had had administrator access to a new profile with power user access.  [More]
I defined the parameter nls_lan=american.america.zhs16cgb231280 in the .profile in the server.And I defined NLS_LANGUAGE="SIMPLIED CHINESE" AND NLS_TERRITORY=CHINA in the init.ora file. then I insert a chinese string in a field of a table.But wh [More]
Hi, We are in the process of moving to 4.2.3 on our production instance which is tightly integrated with our eBusiness Suite. We do not use Oracle SSO. The logout URL is currently set using the following code: l_return := 'apex_custom_auth.logout_the [More]
As described by many users of fglrx or r128 on old cards... when shutting down from inside X, there is a very good chance that the computer will freeze before it finishes shutting down. Nothing I can do saves that and from others I hear the only way [More]
Hello everyone,             Can anyone answer my query as we dont have ECC or any other backend as the customer is only service customer,in which can billing be done in CRM standalone without ECC as backend. pls let me know the process on how to do i [More]
I need to know how the icon at the right corner is called (red) to make it a shortcut.Tab view Show all tabs. For more info: Safari window elements http://support.apple.com/kb/HT5364Read other 3 answers [More]
A "share" bar comes up and blocks part of the information I'm viewing. I don't care to share anything on facebook, twitter, pinterest, etc. How can I stop this share bar from appearing? One suggestion was to go to Tools, Options, Content, and un [More]
Back on 3/13, I was able to launch I-tunes, purchase and download songs and sync to my I-pod. I went away for a few days and hadn't tried to launch I-tunes until tonight. When I tried to launch I-tunes tonight, I got an immediate "software applicatio [More]