customer master LSMW: Upload of multiple tax categories problem

[Former Member]

Hi All,

I am using standard batch input method (RFBIDE00) for creating Customer Master.

In Sales Area Data-> Billing Document tab-> TAXES there are two rows, one for tax category MWST and the other for ZPFS.

In each i need to fill the field TAXKD (TAX CLASSIFICATION) .

In my LSMW there is structure BKNVI which has got all the tax related fields:

Departure country (ALAND):

Tax category (TATYP):

Tax Classification (TAXKD):

Here I need to populate 2 tax categories and hence I have to call the structure BKNVI two times each time passing the tax details for 2 different tax categories.

Any pointers on how to do this.

When i go for LSMW this is the error i'm getting ....

ERROR:

Check tax classification; maintenance is incomplete

Message no. F2269

thanks,

Gaurav Joshi

[Former Member]

No need to call the structure BKNVI two times , you need to pass two tax category like below

but you need to pass seperate strcture for tax.

KUNNR|VKORG|VTWEG|SPART|ALAND|TATYP|TAXKD

1234|DE01|01|05|HU|MWST|1

1234|DE01|01|05|IT|ZPFS|1

[Former Member]

Hi Chenna,

I am using the standard batch input LSMW to create the new customer master record where I am not passing the customer number field (KUNNR).

Will this technique upload two tax categories for the same customer master or will it create 2 distinct customers.

regards,

Gaurav

[Former Member]

it will not create 2 distinct customers. for customer master creation through LSMW you need to pass the data with 2 files

1 is all customer master main data

2 is tax data

the 2nd file customer number is reading the data from first file.

loop at main_data.

loop at tax_data.

based on main_data customer it will read the tax data for more than 1 tax data(like WMST, ZSPR)

endloop.

endloop.

l

[royolav_johansen]

I usually do it like this:

Code: BKNVI = INIT_BKNVI.

STYPE Batch Input Interface Record Type

Rule : Default Settings

Code: BKNVI-STYPE = '2'.

TBNAM Table Name

Rule : Default Settings

Code: BKNVI-TBNAM = 'BKNVI'.

ALAND Departure country (country from which the goods are sent)

Source: INP_STRUCT_01-TAX_COUNTRY (Tax country)

Code: BKNVI-ALAND = INP_STRUCT_01-TAX_COUNTRY.

TATYP Tax category (sales tax, federal sales tax,...)

Source: INP_STRUCT_01-TAX_CAT (Tax category)

Rule : Transfer (MOVE)

Code: BKNVI-TATYP = INP_STRUCT_01-TAX_CAT.

TAXKD Tax classification for customer

Source: INP_STRUCT_01-TAX_CLASS (Taxable Classification)

Code: BKNVI-TAXKD = INP_STRUCT_01-TAX_CLASS.

• Save for NO

TRANSFER_RECORD.

• Save for SE

BKNVI-ALAND = 'SE'.

BKNVI-TAXKD = '1'.

TRANSFER_RECORD.

• Then add for DK (Saved automatically)

BKNVI-ALAND = 'DK'.

BKNVI-TAXKD = '1'.

Regards

Roy Olav Johansen

TechWeaver

[madhu_vadlamani]

Hi Gaurav,

1) Maintain the same order taxes in lsmw how you will maintain in customer master .if there is any change in order then that will change the taxes order.I uploaded that taxes in this way.Structure is BKNVI and field is Tatyp.

INPH-TAX_CAT1 (Tax category)

INPH-TAX_CAT2 (Tax Category)

INPH-TAX_CAT3 (Tax Category)

INPH-TAX_CAT4 (Tax Category)

if BKNVI-ALAND = 'IN'

and INPH-TAX_CAT1 = 'JEC3'.

BKNVI-TATYP = INPH-TAX_CAT1.

BKNVI-TAXKD = INPH-TAX_CLASS1.

transfer_record.

endif.

if BKNVI-ALAND = 'IN'

and INPH-TAX_CAT2 = 'JIVC'.

BKNVI-TATYP = INPH-TAX_CAT2.

BKNVI-TAXKD = INPH-TAX_CLASS2.

transfer_record.

endif.

if BKNVI-ALAND = 'IN'

and INPH-TAX_CAT3 = 'JIVP'.

BKNVI-TATYP = INPH-TAX_CAT3.

BKNVI-TAXKD = INPH-TAX_CLASS3.

transfer_record.

endif.

if BKNVI-ALAND = 'IN'

and INPH-TAX_CAT4 = 'JSVD'.

BKNVI-TATYP = INPH-TAX_CAT4.

BKNVI-TAXKD = INPH-TAX_CLASS4.

transfer_record.

endif.

This will keep all tax conditions for a single customer

If you have more conditions then just increase the order and keep the code in lsmw.Check this and post if need help.

Edited by: madhurao123 on Sep 15, 2011 6:25 PM