hi suja !
there is nothing to Confuse with Split Command.
see let us assume that you have one flat file.
ok.
in that flat file the data is like this..!
here am using COMMA as delimiter. ok
Gd : genral data for Customer or vendor master.
for each vendor let us assume having a couple of bank accounts.
BD : bank details
so while populating the particular customer we hav to populate the bank details alo.
GD,1000,0001,0002,mr.,xxx ......... etc
BD,1000,de,90998770,hdfc,atm .....etc
BD,1000,de,90998771,hdfc,atm .....etc
BD,1000,de,90998772,hdfc,atm .....etc
BD,1000,de,90998773,hdfc,atm .....etc
GD,1001,0001,0002,mr.,yyy ......... etc
BD,1001,de,90998779,hdfc,atm .....etc
BD,1001,de,90998778,hdfc,atm .....etc
BD,1001,de,90998777,hdfc,atm .....etc
BD,1001,de,90998776,hdfc,atm .....etc
ok this is my flat file.
now take one internal table like this :
data : begin of it_totaldata occurs 0,
dummy(200),
end of it_totaldata.
at first we have up load the data into it_totaldata by using GUI_UPLOAD
after uploading data into internal table it_totaldata ,
then we have to SPLIT the data with respect to the identifier.
see at start of each record i used GD and BD.
that is general data (General data) m Bank details (BD).
now am splinting the data ok.
put conditon:
loop at it_totaldata.
if it_totaldata+0(2) = 'GD'.
split it_totaldata at ',' into VAR " this is variable to hold identifier
it_gd_data-lifnr
it_gd_data-bukrs
.
.
.
.
.
append it_gd_data.
elseif it_totaldata+0(2) = 'BD'
split it_totaldata at ',' into VAR " this is variable to hold identifier
it_bd_Data-banks
it_bd_Data-bankl
it_bd_Data-bankn
.
.
.
append it_bd_data.
endloop.
any further Queries regarding let me know ok.!
if useful reward me,
Cheers ,
Rajesh!
Edited by: rajesh k on Mar 8, 2008 9:57 AM
Bluesky
