topic Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1 in Application Development and Automation Discussions

Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 17:13:00 GMT

I am using BAPI_SALESDOCU_CREATEFROMDATA1 to create sales orders. These orders are for people who do not have an SAP customer number and we do not want them to have a customer number. Because of this we are using a generic customer number so that requires us to change the ship-to and bill-to address. How am I suppose to do this? Right now I am using the partners structure BAPIPARTNR and passing it to the BAPI. I am using an existing partner number and overriding the name, address, district, etc... However I do not know, or know how to get, the Tax Jurisdiction code and that is required.

So, first, is there a better way to do this? Second, how do I get the tax jurisdiction code?

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 17:22:43 GMT

Hi,

Please check table KNA1-TXJCD?

Regards,

Ferry Lianto

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 17:27:20 GMT

That won't help me because these are not customers in SAP. We are simply using a customer number and changing the relevant data. When we do this manually, through VA01, the tax code is automatically populated. When I use the BAPI it does not populate the tax code.

Regards,

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 17:35:08 GMT

Hi,

Which is the screen in VA01 that hold Tax Jurisdiction data?

Regards,

Ferry Lianto

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 17:40:43 GMT

The Partner's screen on the header.

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:23:18 GMT

Hi,

Sorry ... I could not find tax jurisdiction info (partner header screen) in my system.

Please press F1 on tax jurisdiction and check the technical information for field data reference.

Regards,

Ferry Lianto

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:27:19 GMT

You may have to expand the fields on that section of the screen. It is located just under the Region (in the address block). Here is the information that F1 gives me:

Tax Jurisdiction Code

Specifies the tax authority to which taxes must be paid. It is always the city to which the goods were delivered.

Use

The tax location is used for calculating tax rates in the USA.

The tax location can be determined using the SAP regional structure or an external tool. The external tool takes precedence when determining the Tax Jurisdiction Code.

Technical info:

Program Name SAPLSZA1

Screen Number 0301

Program Name SAPLV09C

Status ADDRESS_DIALOG

<b> Table Name ADDR1_DATA

Field Name TAXJURCODE </b>

Data Element AD_TXJCD

DE Supplement 0

Parameter ID TXJ

Screen Field ADDR1_DATA-TAXJURCODE

Program Name SAPLV09C

Screen Number 5000

The field for the BAPI is BAPIPARTNR-TAXJURCODE

Davis

Message was edited by:

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:34:45 GMT

Hi Davis,

I checked in my other system (4.7), the tax jurisdiction is coming from customer master (XD03) under Address tab - Street Adress section.

So I guess you can check KNA1-TXJCD.

Regards,

Ferry Lianto

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:39:35 GMT

We do have it stored there but these are not customers that I am dealing with (they don't have an entry in KNA1). Right now when we change the address of a partner (on an order) the tax jurisdiction is being populated automatically, based on the city and zipcode. Some zip codes will have more than one tax jurisdiction code so you will have to decide which one to use.

Regards,

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:45:23 GMT

Hi Davis,

Please check these FM perhaps they may help.

JURISDICTION_DETERMINE

JURISDICTION_CHECK

TAX_TXJCD_DETERMINE_TABLE

Regards,

Ferry Lianto

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:48:56 GMT

Is your generic customer number defined as a one-time-only customer?

Rob

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:53:33 GMT

Ferry,

That looks like it will work but the only problem is that some cities will have more than one tax code. When there is more than on a dialog box pops up asking for you to select one. This job is run in the background so dialogs won't work.

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:54:31 GMT

Rob,

I'm not sure what a one-time-only customer is. All I know is that we use this same customer number several times a day 5 days a week and each time it is for a new order/location.

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 18:56:42 GMT

Ferry,

The last FM works great! TAX_TXJCD_DETERMINE_TABLE

That FM returns a table of all tax codes for a given city/zip. This is exactly what I needed!

Thank you so much for finding this FM for me!

Davis

Re: Tax Jurisdiction code and BAPI BAPI_SALESDOCU_CREATEFROMDATA1

Former Member — Wed, 31 Oct 2007 19:02:26 GMT

Hi Davis,

Glad to help ...

Also you can try FM DETERMINE_TXJCD_EXTERNALLY with NO_DIALOG = 'X'.

The customer master program is using this FM to determine tax jurisdiction.

Regards,

Ferry Lianto