Table TTXY - use?

[Former Member]

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.

[Former Member]

hi check this document

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

See page number 13.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi,

Kevin Nash ,

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

[Former Member]

True that i understand.

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

regards,

Kevin.

[Former Member]

Hi

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