TTEPD3_USITEM - Persistency TTE Document UsItem

Persistency TTE Document UsItem information is stored in SAP table TTEPD3_USITEM.
It is part of development package AP_TTE_PERSISTENCY in software component AP-TTE. This development package consists of objects that can be grouped under "Transaction Tax Engine ( TTE Document Persistency )".

Fields for table TTEPD3_USITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
TTEDOCUMENTID	TTE Document ID	X	TTET_TTEDOCUMENTID_PD	RAW	16
ITEMID	Item Identifier	X	TTET_ITEMID_COM_PD	CHAR	64
COMP_CODE	Company Code		TTET_USBUKRS_COM	CHAR	8
DIVISION	Business Area/Division Code		TTET_USDIVISION_COM	CHAR	8
COUNTRY	Tax Departure Country/Region		TTET_USLANDTX_COM	CHAR	6
DOC_NUMBER	Document No.		TTET_USBELNR_D_COM	CHAR	20
POS_NO	Tax document item number		TTET_USTAXPOSNR_COM	NUMC	12
ACCNT_NO	External Partner Number		TTET_USTAX_XACCNT_COM	CHAR	32
ACCNT_CLS	Taxable Partner Classification		TTET_USTAX_XACCNTCLS_COM	CHAR	20
TAX_DATE	Date of Tax Calculation		TTET_USTAX_XDATE_COM	CHAR	16
REP_DATE	Date for Tax Reporting		TTET_USTAX_XREPDAT_COM	CHAR	16
TXJCD_ST	Jurisdiction code		TTET_USTXJCD_COM	CHAR	30
TXJCD_SF	Jurisdiction code		TTET_USTXJCD_COM	CHAR	30
TXJCD_POA	Jurisdiction code		TTET_USTXJCD_COM	CHAR	30
TXJCD_POO	Jurisdiction code		TTET_USTXJCD_COM	CHAR	30
TXJCD_IND	Indicator: Tax Jurisdiction		TTET_USTAX_XTXJCDIND_COM	CHAR	2
PTP_IND	Indicator: Space for Title Transfer		TTET_USTAX_XPTPIND_COM	CHAR	2
APAR_IND	Ind.: Transaction on Debit/Credit Side		TTET_USTAX_XAPARIND_COM	CHAR	2
TXJCD_L1	Two digit number		TTET_USNUMC2_COM	NUMC	4
TXJCD_L2	Two digit number		TTET_USNUMC2_COM	NUMC	4
TXJCD_L3	Two digit number		TTET_USNUMC2_COM	NUMC	4
TXJCD_L4	Two digit number		TTET_USNUMC2_COM	NUMC	4
TAX_TYPE	Indicator: Tax Category (Sales/Rental/Use/Lease)		TTET_USTAX_XTYPE_COM	CHAR	2
MATNR	Calling System Material Number		TTET_USTAX_XMATNR_COM	CHAR	36
PROD_CODE	Taxable Product Classification		TTET_USTAX_XPRODCODE_COM	CHAR	20
QUANTITY	Taxable Quantity		TTET_USTAX_XQUANTITY_COM	CHAR	26
UNIT	Tax Base Unit of Measure		TTET_USTAX_XUNIT_COM	CHAR	6
AMOUNT	Tax Base Amount		TTET_USTAX_XBASE_COM	CHAR	30
CURRENCY	Tax currency		TTET_USTAX_XCURR_COM	CHAR	10
CURR_DEC	No. of Decimal Places for Tax Reporting Currency		TTET_USTAX_XCURRDEC_COM	CHAR	6
FREIGHT_AM	Freight Amount		TTET_USTAX_XFRAMOUNT_COM	CHAR	30
EXEMPT_AMT	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXEMPT_IND	Indicator: Tax Exemption		TTET_USTAX_XEXEMPTFLG_COM	CHAR	2
CREDIT_IND	Indicator: Tax Credit Memo		TTET_USTAX_XCREDFLG_COM	CHAR	2
UPDATE_IND	Indicator: Update Calling System		TTET_USTAX_XUPDFLG_COM	CHAR	2
OVWRT_IND	Indicator: Overwriting A Calling System		TTET_USTAX_XOVRFLG_COM	CHAR	2
TAXPCT0	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT1	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT2	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT3	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT4	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT5	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT6	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT7	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT8	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCT9	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXPCOV	Tax Percentage Rate		TTET_USTAX_XPERCENT_COM	CHAR	30
TAXAMT0	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT1	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT2	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT3	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT4	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT5	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT6	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT7	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT8	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMT9	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXAMOV	Tax Amount		TTET_USTAX_XAMOUNT_COM	CHAR	30
TAXBAS0	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS1	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS2	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS3	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS4	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS5	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS6	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS7	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS8	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
TAXBAS9	Tax Base Amount From Calling System		TTET_USTAX_XBASAMT_COM	CHAR	30
EXMATFLG	Tax Exemption Code Material		TTET_USTAX_XEXMAT_COM	CHAR	4
EXCUSFLG	Tax Exemption Code Business partner		TTET_USTAX_XEXCUS_COM	CHAR	4
EXAMT0	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT1	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT2	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT3	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT4	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT5	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT6	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT7	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT8	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXAMT9	Tax Exemption Amount		TTET_USTAX_XEXAMOUNT_COM	CHAR	30
EXCODE0	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE1	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE2	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE3	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE4	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE5	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE6	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE7	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE8	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCODE9	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
EXCERTIF	Tax Exemption Certificate		TTET_USTAX_XEXCERT_COM	CHAR	50
EXREASON	Code for Tax Exemption		TTET_USTAX_XEXCODE_COM	CHAR	4
USER_DATA	User-Specific Data		TTET_USTAX_XUSERDAT_COM	CHAR	100