logic to retrieve batch number in batch split scenario for a material

Hi All!

LIPS-CHARG gives the batch number for a material in normal scenario.But in batch split scenario for a material what should be the logic to retrieve the field batch number based on POSNR,VBELN and UECHA in LIPS.

UECHA corresponds to higher level item of a batch.

I had been given the following logic to do the same but it is not pulling any values inspite of a batch split available for the material.The logic is

Select lips-charg (batch number) where lips-posnr = lips-uecha ( higher level item batch)

Please advise

Regards

Praneeth