Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from hkb_singh on Dec 18 at 12:22 AM These kind of issues do not arise generally. You are suggesting that in a table with
all budat you have only 5 entries and get only 3 . You are not showing entries in menge and also one should try to keep the natural order of things. If there is an index using Bwart and you go from 101, to 105 to 123 to 122 to 102 to 106 it is kind of not respecting the natural order.
Harry.
| | | ---------------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. __.____._ |   _.____.__ |
