Skip to Content
0
Former Member
Jan 14, 2005 at 08:47 AM

How to use collect statement properly

2788 Views

In PBID table , i will get 4 rows for a material . I will get the corresponding values of bdzei from the same table . Now i will pass this bdzei into pbhi table. then i will get some 200 rows of data. I have to sum up the field plnmg , by grouping the laeda field of pbhi. In short, i need to know the sum of pbhi-plnmg for a particular pbhi-laeda . I know a way to do it. But i want to know how to use the COLLECT statement for this purpose. My output should contain oly 1 line for 1 material ..

PBID table

-


Matnr BDZEI

p4471 457

1002

2309

2493

PBHI table

-


BDZEI LAEDA PLNMG

-


1002 06.08.2004 0.000

1002 06.08.2004 83.000

457 07.08.2004 12.000

457 07.08.2004 24.000

Reqd O/p

MATNR LAEDA PLNMG

-


p4471 06.08.2004 83

p4471 07.08.2004 36

Hope u understood my situation .please help me out ...

Thanking you in advance ..

Shankar