topic Re: Table TTXY - use? in Application Development and Automation Discussions

Table TTXY - use?

Former Member — Wed, 18 Feb 2009 19:47:40 GMT

Hi Experts,

Can someone Explain the purpose of the table TTXY.

Should it be configured anywhere to get filled up automatically.

Please share ay details about this table.

regards,

Kevin.

Re: Table TTXY - use?

Former Member — Wed, 18 Feb 2009 20:22:14 GMT

hi check this document

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/36eb7a90-0201-0010-baae-a894964dc84e

See page number 13.

Re: Table TTXY - use?

Former Member — Wed, 18 Feb 2009 20:33:46 GMT

That was helpful.

Now i am working on integrating TAXWARE & SAP and i find this table empty.

I am under the assumption that all updates to these kind of tables ar going to be realtime.

Any Sparks?

rgards,

Kevin.

Re: Table TTXY - use?

Former Member — Wed, 18 Feb 2009 20:40:00 GMT

yes the table is automatically going to get updated, like during creation invoice. similarly in many other transaction which when when run will fetch and fill data to this table.

Re: Table TTXY - use?

Former Member — Wed, 18 Feb 2009 20:43:42 GMT

I have created a number of invoices, orders, Accounting Documents & this table has 0 entries.

Anything that i can do?

thanks for your response.

regards,

Kevin.

Re: Table TTXY - use?

Former Member — Thu, 19 Feb 2009 06:23:09 GMT

hi,

Kevin Nash ,

TTXY TABLE use for FI-GL- Account and external systems for tax calculation,

Re: Table TTXY - use?

Former Member — Thu, 19 Feb 2009 14:27:13 GMT

True that i understand.

I am trying to know how to configure this table so that i can expect some entries.

regards,

Kevin.

Re: Table TTXY - use?

Former Member — Fri, 20 Feb 2009 10:01:57 GMT

I hope this helps-

The 3rd party tax packages provide customers with services including tax audit reporting and

tax returns. These external tax packages require information from the SAP R/3 system in

order to provide these services.

The external tax packages currently do not support dynamic transaction backout for all of their

databases. Therefore, SAP has chosen not to update these packages realtime. SAP uses a 3

step procedure for updating the external tax packages.

SAP AG SAP - External Sales and Use Tax System Interface

Step 1: at time of document creation, the tax calculation details are stored in the internal

memory of the tax calculation modules. As soon as the document is posted into FI, the

data is removed from the internal memory and stored into a table (TTXY). This table

contains all COM_TAX data by document number and item number. This allows to have

more detailed information available, especially for SD documents.

Step 2: at time of FI document posting a special index (TTXI) is updated for all tax relevant

documents.

Step 3: SAP provides 2 programs (RFYTXD00 and RFYTXU00) which use the index

(TTXI,TTXY), along with the document tax information (BSET), to update the external

tax package. The index is then updated with status information (i.e. update successful or not)

Regards