Skip to Content
0
Former Member
Dec 15, 2006 at 09:25 AM

EKBE table data

130 Views

Acutally I am fetching data from EKBE table for a given EBELN. Here I am getting all the GR and IR number for a EBELN. I have to fileter those GR which have IR. It means for a BELNR if the IR is raised, then the reference document (LFBNR) will be GR no. When I am going to ouput I am getting the IR and GR. I want to bring want to get oneline. If the IR is not raised for GR then it has to dispaly one line item.

Ex: EBELN - BELNR - BWETP - LFBNR

4100000000 - 5000000200 - E - 5000000200

4100000000 - 5000000201 - E - 5000000201

4100000000 - 5100000501 - Q - 5000000200

4100000000 - 5100000502 - Q - 5000000200

OUTPUT EXPECTED:

4100000000 - 5000000201 - E - 5000000201

4100000000 - 5100000501 - Q - 5000000200

4100000000 - 5100000502 - Q - 5000000200

E - GR & Q - IR.

for an E if IR is not there, it has to pick. See the Belnr 5000000201

This is my Prob.

Regards

Ram