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.