We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] Ekbe Table Fetching Data

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from Shanthi on Dec 18 at 4:00 AM
Hi Shyam,
When you fetch records from a table and place it in an internal table, only one of same data records may be put in the internal table. If multiple records contain same data, all records may not be put in the internal table. You better fetch the primary key which differentiates the records with same values.

---------------Original Message---------------
From: shyam
Sent: Tuesday, December 17, 2013 10:52 PM
Subject: Ekbe Table Fetching Data

I am facing ekbe table some issues for fetching data for grn value. This is my code for ekbe table.

* select ebeln "to get po grn value
* ebelp
* BUDAT
* bewtp
* bwart
* menge
* dmbtr
* werks from ekbe
* into table it_ekbe
* where ebeln = it_ekpo-ebeln
* and ebelp = it_ekpo-ebelp
* and bewtp = 'E'
* and bwart in ('101', '105','123','122','102','106' ).

In ekbe table it had five datas .but in coding I have only three items came..only for reverse condition ...for example.

ebeln ebelp bwart bewtp dmbtr
400000018 10 101 E 4000
400000018 10 102 E 4000
400000018 10 101 E 5000
400000018 10 105 E 4000
400000018 10 101 E 4000

this ekbe table datas...

But I have in coding it_ekbe oly three datas are came

400000018 10 101 E 4000
400000018 10 102 E 4000
400000018 10 101 E 5000

Please tell some useful ideas.

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
Shanthi  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language