Skip to Content
0
Mar 11, 2010 at 08:47 AM

Regarding Select stmt.

30 Views

Hi All,

I have Small issue , am extracting the data from BSIK ,using this select stmt

REFRESH it_bsik.

  • SELECT lifnr umskz blart dmbtr FROM bsik INTO TABLE it_bsik

  • FOR ALL ENTRIES IN it_emp

  • WHERE lifnr = it_emp-lifnr

  • AND bukrs = 'FUND'

  • AND gjahr = p_gjahr

  • AND blart IN ('ZA','ZN','ZL','ZK','ZG','ZM'). am using this select Query .

I have 14 records in my table but while extracting only am getting 11 in internal table it_bsik.

i need to get total records and base on umskz ,blart amount has to be sum.

I want to display ZN data with Spl GL 9, k and ZA data with 2 ,5 ,8 indivisually.

Data which i have .

kN01079 9 ZN 14.75

KN01079 9 ZN 618.35

KN01079 K ZN 10.92

KN01079 K ZN 143.47

KN01079 2 ZA 1,755.00

KN01079 2 ZA 1,755.00

KN01079 2 ZA 10.92

KN01079 5 ZA 2,296.00

KN01079 5 ZA 2,296.00

KN01079 5 ZA 248.51

KN01079 8 ZA 6,097.00

KN01079 8 ZA 6,097.00

KN01079 9 ZA 248.51

KN01079 K ZA 10.92

Thanks & Regard's,

shaik.