Company codes

[former_member778915]

Hi Guys, i need help. I have a requirement. There is excel data for two company codes containing account number and stat sub category in 2 sheets. After getting the data from excel into internal table, it should map the account number of 2 company codes against its stat sub category.

How do i do it ?

[former_member778915]

Hi Guys, i need help. I have a requirement. There is excel data for two company codes containing account number and stat sub category in 2 sheets. After getting the data from excel into internal table, it should map the account number of 2 company codes against its stat sub category.

How do i do it ?

[former_member779046]

Hello Apurba,

I will try to give a suggestion, Let me know if it helps

Create a custom program/Z* program ( Excel upload program ) to load the excel data into internal table, As you have data of company codes, Lets keep company code data into a variable (X) and pass the account number into variable ( Y )and stat sub category data into other variables (Z). Then you can pass the logic to have the desired output.(After getting the data from excel into internal table, it should map the account number of 2 company codes against its stat sub category.)

[gregorw]

To read xlsx in ABAP you can use https://github.com/sapmentors/abap2xlsx

[Astashonok]

where are you stuck?