2007 Jan 08 9:20 AM
Hi experts,
how to convert the data in the internal table into the BBSEG(Strcture) and performing the mapping of the data as Finanacial related fields,Account payble terms,...etc..
Plz help me
Thanks
2007 Jan 08 9:42 AM
what i can understand you have lot of values in your itab which you have uploaded and now transfer only relevant data from that table to the structure bbseg.
if it is so.
then decalre itab1 like bbseg .
now
loop at itab.
move-corresponding itab to itab1.
append itab1.
endloop.
it will only fetch the matching rows of itab and itab1 data.
regards
shiba dutta
Hi experts,
how to convert the data in the internal table into the BBSEG(Strcture) and performing the mapping of the data as Finanacial related fields,Account payble terms,...etc..
Plz help me
Thanks
2007 Jan 08 9:21 AM
sorry can not get your question properly.
you can refer to BSEG table for data.
regards
shiba dutta
2007 Jan 08 9:31 AM
Hi Shiba,
i have an excel sheet in that excel sheet diff tables and fields are avilable.i hade taken all the table fields as 1 internal table.then iam going convert the internal table as into the BBSEG(Strcture it is not exact,some 'T' strcture) and performing the mapping of the data as Finanacial related fields,Account payble terms,...etc..but my problem is
how to convert the data in the internal table into the BBSEG(Strcture) and performing the mapping of the data as Finanacial related fields,Account payble terms,...etc..
Plz help me from this issue
Message was edited by:
skk
2007 Jan 08 9:34 AM
can u declare the internal table as
<b>DATA : ITAB LIKE LINE OF BBSEG OCCURS 0 WITH HEADER LINE.</b>
Since the work area is compatible to the structure of BBSEG u can do the mapping .
Just see if this is working for u .
I hope you are trying to update the Field Content of Internal table to Structure .
regards,
vijay.
2007 Jan 08 9:42 AM
what i can understand you have lot of values in your itab which you have uploaded and now transfer only relevant data from that table to the structure bbseg.
if it is so.
then decalre itab1 like bbseg .
now
loop at itab.
move-corresponding itab to itab1.
append itab1.
endloop.
it will only fetch the matching rows of itab and itab1 data.
regards
shiba dutta
2007 Jan 08 12:01 PM
Hi Shiba,
tks for ur reply after convert the data in the internal table into specified format(suppose BBSEG),The mapping of the data as GL-GL,AP-AP,GL-AP,GL-AR..By following the format.
1)left justify character fields
2)right justify numeric fields
3)right justify amount decimal point and 2 decimal places.not to use coomas or the$sign.
4)null values must be blank
why we r maintaing this conditions becoz this excel file will send to inbound control.
plz help me.
Thanks
2007 Jan 08 9:42 AM
Hi,
do you want to use BBSEG for use in program RFBIBL00 ?
regards,
Rolf
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |