SAP table TAX_ITEM_DETAIL (Detail tax informationfor a line item)

Field Description Data Type Length Decimals Checktable Data Element
TAX_DATA TTYP 0 0 EXTAX_JUR_LEVEL_TABLE
REF_ITEM_KEY STRU 0 0 TAX_LINE_KEY
TAXPS Tax document item number NUMC 6 0 TAX_POSNR
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
SHPTO Tax Jurisdiction CHAR 15 0 TXJCD
ITEMNR External-tax document item number NUMC 6 0 XTAX_DOC_ITEM_NUMBER
INPUT_DATA STRU 0 0 EXTAX_ITEM_IN
POS_NO Tax document item number NUMC 6 0 TAX_POSNR
GROUP_ID Grouping code for components that are part of the same set CHAR 18 0 TAX_GROUP_ID
COUNTRY Tax Departure Country/Region CHAR 3 0 LANDTX
DIVISION Business area/division code CHAR 4 0 DIVISION
MATNR Material number for taxes CHAR 18 0 TAX_MATNR
PROD_CODE SAP Internal Product Code (External Interface) CHAR 10 0 PROCD_TTXP
GROUP_PROD_CODE Group product code CHAR 10 0 GRP_PROCD
QUANTITY Material quantity (internal representation - KOMP-MENGE) QUAN 13 3 ETD_QUANTITY
UNIT Unit for quantity UNIT 3 0 TAX_UNIT
UPMAT Pricing reference material of main item CHAR 40 0 UPMAT
MATKL Material Group CHAR 9 0 MATKL
APAR_IND Indicator for A/P or A/R CHAR 1 0 APAR_IND
TAX_TYPE Indicator: Sales/Use/Rental/Service/... Tax CHAR 1 0 TAXTYPEXT
EXEMP_IND Indicator: Transaction Is Tax Exempt/Taxable CHAR 1 0 EXTEXMTFLG
TAX_DATE Tax date (internal representation) DATS 8 0 ETDTXDAT
TXJCD_ST Jurisdiction code "Ship-to" CHAR 15 0 TXJCD_ST
TXJCD_SF Jurisdiction code "Ship-from" CHAR 15 0 TXJCD_SF
TXJCD_POA Jurisdiction code "Point of order acceptance" CHAR 15 0 TXJCD_POA
TXJCD_POO Jurisdiction code "Point of order origin" CHAR 15 0 TXJCD_POO
AMOUNT Tax base amount CURR 23 2 ETDTAXBASE
GROSS_AMOUNT Tax base amount gross. CURR 23 2 ETDGROSS_AMOUNT
FREIGHT_AM Freight Amount (internal representation) CURR 23 2 ETDFRTAMOUNT
EXEMPT_AMT Exempt amount (internal representation) CURR 23 2 ETDEXMTAMOUNT
BILLED_AMOUNT Billed amount (in currency format) CURR 23 2 FOT_BILLED_AMOUNT_D
ACCNT_NO Vendor or ship-to customer account number CHAR 16 0 TAX_ACCNT_NO
ACCNT_CLS Classification item of an account (Customer/vendor) CHAR 10 0 TAX_ACCNT_CLS
COST_OBJECT Cost object where the goods are consumed CHAR 18 0 TAX_COST_OBJECT
PTP_IND Indicator: Point of Title Passage CHAR 1 0 PTP_IND
EXCERTIF Customer tax exemption certificate number defined in SAP CHAR 25 0 EXCERTIF
EXREASON Tax Exemption Reason Code CHAR 2 0 EXDETCODE
USER_DATA User-Specific Field CHAR 50 0 USER_DATA
SOLDTO Sold-to Party CHAR 10 0 KUNAG
SHIPTO Ship-to Party CHAR 10 0 KUNWE
GL_ACCOUNT G/L Account Number, Significant Length CHAR 10 0 SAKAN
KOSTL Cost Center CHAR 10 0 KOSTL
DOC_DATE Document Date in Document DATS 8 0 BLDAT
POST_DATE Posting Date in the Document DATS 8 0 BUDAT
SR_DATE Service Render Date DATS 8 0 FIS_ETXDC_SRDAT
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
CONT_VAL Total Contract Value CHAR 25 0 FIS_ETXDC_CONVAL
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
BTT_CODE Business Transaction Type(Do not use! Will be overwrited) NUMC 5 0 FOT_TDT_TXDAT_DET_BTT_CODE_E
BILLTO Bill-to Party CHAR 10 0 KUNRE
SUPPLIER Account Number of Supplier CHAR 10 0 LIFNR
EXTENSION_FIELD001 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD002 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD003 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD004 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD005 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD006 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD007 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD008 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD009 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD010 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD011 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD012 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD013 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD014 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD015 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD016 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD017 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD018 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD019 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD020 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD021 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD022 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD023 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD024 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD025 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD026 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD027 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD028 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD029 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD030 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD031 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD032 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD033 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD034 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD035 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD036 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD037 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD038 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD039 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD040 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD041 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD042 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD043 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD044 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD045 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD046 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD047 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD048 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD049 Text (100 characters) CHAR 100 0 TEXT100
EXTENSION_FIELD050 Text (100 characters) CHAR 100 0 TEXT100
STORE_CODE Store Code CHAR 10 0 STORE_CODE
USER_REPT_DATA User specific reporting data CHAR 50 0 USER_REPT_DATA
OUTPUT_DATA STRU 0 0 EXTAX_ITEM_OUT
DEFAULT_REASON Tax Default Reason CHAR 1 0 TAX_DEFAULT_REASON
TXJCD_IND Indicator: Jurisdiction Code Used for Tax Calculation CHAR 1 0 TXJCDIND
TAXPCOV Total tax rate (internal representation - KBETR) CURR 23 2 ETDTAXPERCNTG
TAX_DATE_RETURN Date for tax calculation (format YYYYMMDD). CHAR 8 0 TAX_DATE
TAXAMOV Total tax amount (internal representation - HWSTE) CURR 23 2 ETDTAXAMOUNTG
EXMATFLAG Code for Material Tax Exemption CHAR 2 0 EXMATCODE
EXCUSFLG Code for Customer Tax Exemption CHAR 2 0 EXCUSCODE
EXT_EXCERTIF Customer exempt certificate as returned by tax system CHAR 25 0 EXT_EXCERTIF
EXT_EXREASON Tax Exemption Reason Code as returned by tax system CHAR 2 0 EXT_DETCODE
GL_TAXPCOV G/L tax rate (KBETR) CURR 23 2 GL_TAXPERCNT
GL_TAXAMOV G/L tax amount (HWSTE) CURR 23 2 GL_TAXAMOUNT
TAX_STATE Tax State CHAR 2 0 FIS_ETXDC_REGION
GL_TAXBAS G/L Tax base amount (HWBAS) CURR 23 2 GL_TAXBASE
POSTING_DATA STRU 0 0 EXTAX_POST_INFO
REP_DATE Posting date (internal format) DATS 8 0 EXTREPDATE
CREDIT_IND Indicator: Tax Credit CHAR 1 0 EXTCREDFLG