Skip to Content
0
Former Member
Apr 20, 2010 at 08:55 AM

EKPO - RSEG Query

897 Views

Hi,

I am using relation Ekpo-Ebeln = Rseg-ebeln and ekpo-ebelp = rseg-ebelp to pull out Rseg-belnr. but i am getting

Ekpo Record

4500000160   00010             03.07.2008   STRAP-ASSY,1780,ELASTIC                  1786-300-110
4500000160   00020             03.07.2008   BAG,1495CC1,ACCESSORY                    1495-210-000
4500000160   00030             03.07.2008   COMPUTER SLEEVE,1495CC1                  1495-410-001

Rseg Record

5105600102 2008  000001 4500000160   00010   00    1786-300-110
5105600102 2008  000002 4500000160   00020   00    1495-210-000
5105600102 2008  000003 4500000160   00030   00    1495-410-001
5105600178 2008  000001 4500000160   00010   00    1786-300-110
5105600178 2008  000002 4500000160   00020   00    1495-210-000
5105600178 2008  000003 4500000160   00030   00    1495-410-001
5105600179 2008  000001 4500000160   00010   00    1786-300-110
5105600179 2008  000002 4500000160   00020   00    1495-210-000
5105600179 2008  000003 4500000160   00030   00    1495-410-001

Wrt to one line item of ekpo i am getting 3 records in Rseg , how to identify which belnr i will pick from Rseg table

in rseg table with respect to one po no. there are repetitive entries in rseg , so what relation should be added to pick the correct belnr.

Edited by: Ankesh Jindal on Apr 20, 2010 10:58 AM