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

uregent

Former Member
0 Likes
446

Hi,

iam working on excelsheet.user can fill the coloumns manually.it has 50 coloums.now i convert the excel file to certain Structure and performing mapping for the excel file fields and the Structure.The Structure realted to finanacial related one and excel fields are also same.now the doubt is how can we map Financial fields suppose GL-GL,GL-AP.GL-AR,AP-AR,AR-AR etc.

plz help me

helpful answers get rewarded.

thanks

Hi,

iam working on excelsheet.user can fill the coloumns manually.it has 50 coloums.now i convert the excel file to certain Structure and performing mapping for the excel file fields and the Structure.The Structure realted to finanacial related one and excel fields are also same.now the doubt is how can we map Financial fields suppose GL-GL,GL-AP.GL-AR,AP-AR,AR-AR etc.

plz help me

helpful answers get rewarded.

thanks

2 REPLIES 2
Read only

Former Member
0 Likes
412

Hi,

i understand your question. Use the field symbols. Take two internal tables with GL-AP records and GL-AR records. Based on the conditions u can populate the data by usingBDC. Take help from functional consultant.

Regards,

Kumar.

Read only

andreas_mann3
Active Contributor
0 Likes
412

hi,

use report rfbibl00 and fill structures : BBKPF, BBSEG and BBTAX

-> look documentation to that report

A.