LSMW Direct Input Method RMDATIND tax classification material

[Former Member]

Hi folks,

I am loading material master data throught LSMW using direct input method. In MM01 for a particular sales org we have tax classifcation for three different countries US, CA and GB. Could anyone tell me how do I post the tax classification Material data in the table control for these three different countries.

COUNTRY COUNTRY TAX CATG. TAX CATEG. TAX CLASSIF

CA Canada CTX1 GST (Canada) ...........

CA Canada CTX2 PST (Canada) ...........

CA Canada CTX3 PST (Base+GST) Cdn...........

GB United Kingdom MWST Output Tax...........

US USA UTXJ Tax Jurisdict.Code ...........

US USA UTX2 County Sales Tax ...............

US USA UTX3 City Sales Tax .............

Points will be rewarded for the answers.

Thanks,

Raj

[former_member214131]

Hi,

Not sure about the same requirement of countries & tax codes for all the materials for your upload.

If this is the case,

enable the

Extras->DisplayVariant

from the menu of the LSMW & check all the check boxes. Now you see the

__END_OF_RECORD__

for the structure

BMMH2

which has to be mapped with the input structure in the Maintain structure relations step.

double click on the

__END_OF_RECORD__

which will lead to ABAP editor & then put the following code:

* Canada
bmmh2-stype = '3'. 
bmmh2-aland = 'CA'.
bmmh2-taty1 = 'CTX1'.
bmmh2-taxm1 = '1'.
transfer_record.

bmmh2-stype = '3'. 
bmmh2-aland = 'CA'.
bmmh2-taty1 = 'CTX2'.
bmmh2-taxm1 = '1'.
transfer_record.

else if you have a different set of countries with different tax codes for the set of materials,

You need to have a separate file for this & map the fields to the structure fields of

BMMH2

.

Hope this helps.

Best Regards, Murugesh AS

Message was edited by:

Murugesh Arcot

[Former Member]

Hi Murugesh,

Thanks for the quick response and your answer was very helpful. I solved my problem and awarded full points to your answer.

Thanks once again,

Raj

[Former Member]

Hi Murugesh,

There is slight change in the requirement now. Instead of hardcoding the values of tax classification material. I need to pass them thru a flat file. As you mentioned in your above answer, i need to maintain a seperate flat file for the tax codes.

for tax codes do i have to write the code in Begin of record and map the fields in BMMh2 structure to my flat file structure?

In my req. we have a particular sales org that has 3 countries and remaining sales org have only one country.

Can you trhow some sugestions/points on this. Appreciate your help.

Thanks

Raj

[former_member214131]

Hi,

As I have written in my previsous reply, you need a separate file to map the structure BMMH2 along with a header file with MATNR, Sales area fields to be mapped with structure BMM00.

So you need a single line in this header file with MATNR & Sales area fields.

For the corresponding line in header, we need the same key fields (MATNR & Sales area fields) along with individual tax codes fields.

Hope this helps.

* And finally, since the current thread is already marked Answered, you need to create a new thread for your questions.

Best Regards, Murugesh AS

[Former Member]

you can try below code

==============================================================

BMMH2-ALAND = 'CA'. BMMH2-TATY1 = 'CTX2'. BMMH2-TAXM1 = '1'.

BMMH2-TATY2 = 'CTX2'. BMMH2-TAXM2 = '1'.

BMMH2-TATY3 = 'CTX3'. BMMH2-TAXM3 = '1'.

transfer_record.

BMMH2-ALAND = 'MO'. BMMH2-TATY1 = 'MWST'. BMMH2-TAXM1 = '1'.

BMMH2-TATY2 = '/'. BMMH2-TAXM2 = '/'.

BMMH2-TATY3 = '/'. BMMH2-TAXM3 = '/'.

transfer_record.

BMMH2-ALAND = 'SG'. BMMH2-TATY1 = 'MWST'. BMMH2-TAXM1 = '1'.

===============================================================

[Former Member]

Hello Raj/ Murgesh,

I am following up this thread from long as I have the same requirement.

For same country i have to maintain 2 tax classification data as one of the plant is in diff country.

As per your suggestion I created two diff source strcuture.

1 for material master data and it is assigned to: BGR00, BMM00, BMMH1. (w/o tax classification data)

2nd for : BMMH2 where it contains material no. sales area + tax classification fields.

When I tried to map i realized that i do not have material no. and sales area fields in BMMH2. So how do i link source fields of BMMH2 to target BMMH2?

Please let me know if I need to provide further input on the same from my end to get my query answered.

Rgds,

KK

[former_member1200092]

I share my experience.

https://answers.sap.com/comments/13533708/view.html