Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

urgent doubt

Former Member
0 Likes
943

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
911

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

6 REPLIES 6
Read only

Former Member
0 Likes
911

sorry can not get your question properly.

you can refer to BSEG table for data.

regards

shiba dutta

Read only

0 Likes
911

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

Read only

Former Member
0 Likes
911

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.

Read only

Former Member
0 Likes
912

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

Read only

0 Likes
911

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

Read only

Former Member
0 Likes
911

Hi,

do you want to use BBSEG for use in program RFBIBL00 ?

regards,

Rolf