Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

EKPO - RSEG Query

Go to solution
Former Member

‎04-20-2010 9:55 AM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎04-20-2010 10:15 AM

0 Kudos

Hello,

This simply means that a single PO line item, has multiple invoices created against it. Now these could be invoice receipts or reversals, which can be identified by the field SHKZG in the table RSEG. If it is 'S' then it is an invoice and if it is 'H' then it would be a reversal.

As for picking the BELNR is concerned, you will need to check the logic from the specs provided, whether you need to pick the reversals or receipts, etc. what exactly is the requirement, as in this case there is a possibility that one to many relation will exist.

Regards,

Sachin

3 REPLIES 3

Go to solution
Former Member

‎04-20-2010 10:15 AM

0 Kudos

Hello,

This simply means that a single PO line item, has multiple invoices created against it. Now these could be invoice receipts or reversals, which can be identified by the field SHKZG in the table RSEG. If it is 'S' then it is an invoice and if it is 'H' then it would be a reversal.

As for picking the BELNR is concerned, you will need to check the logic from the specs provided, whether you need to pick the reversals or receipts, etc. what exactly is the requirement, as in this case there is a possibility that one to many relation will exist.

Regards,

Sachin

Go to solution
Former Member

‎04-20-2010 10:20 AM

0 Kudos

hi,

I think you can also check field MWSKZ along with EBELN & EBELP. It may help.

Regards

harris

Go to solution
Former Member

‎04-20-2010 10:43 AM

0 Kudos

Hi ANkesh,

It depends upon your requirement. whether u need material costs IR docs or delivery costs IR docs with their relevant conditions.

Better check such entires in table EKBE and EKBZ before going for RBKP and RSEG table.