Import
Parameters for Test Tax Calculation 
Structure: I_SAP_CONTROL_DATA (SAP Control info)
Parameter |
Definition |
Example |
APP_SERVER |
SAP Application Server |
us01d1 |
SAP_VERSION |
SAP Release |
46B |
INTERF_VERSION |
SAP Tax Interface Version |
TAXDOC00 |
Structure: I_TAX_CAL_HEAD_IN (Document header input info)
Parameter |
Definition |
Example |
SYST_NAME |
Logical SAP system name |
DEV |
CLIENT |
Client number |
800 |
COMP_CODE |
Company Code |
US01 |
DOC_NUMBER |
Document number |
0090007640 or blank |
CURRENCY |
Document currency during tax calculation |
USD |
CURR_DEC |
Number of decimal places for currency |
002 |
TXJCD_L1 …L4 |
Length of the nth part of the tax jurisdiction code |
(02, 03, 04, 01) - Vertex (02, 05, 02, 00) – Taxware |
TAX_PER_ITEM |
Tax calculation is done by line item (1) |
X (SD only) or blank (SD, MM, FI) |
NR_LINE_ITEMS |
Total number of lines in the external tax document (2) |
000001, 000002, or 000003, etc. |
...
1. Each line item will be treated separately for tax calculation. Therefore, Max Tax rules across multiple lines in the same document will not be applied. For Release 4.6x, this flag should be set when dealing with MM/FI transactions.
2. Total number of entries in table I_TAX_CAL_ITEM_IN.
Table: I_TAX_CAL_ITEM_IN (Item input info)
Create at least one record in input table: I_TAX_CAL_ITEM_IN. Copying and then modifying existing entries creates new records: Position the cursor on an existing record then choose Double line or Ctrl+F12. After the record has been duplicated, double-click the record to be modified.
Parameter |
Definition |
Example |
ITEM_NO |
External tax document item number |
000001, 000002, 000003, etc. |
POS_NO |
Item position number in document |
000010, 000020, 000030, etc. |
GROUP_ID |
Set position number in document (1) |
000010, 000040, etc. or blank |
COUNTRY |
Departure country |
US |
DIVISION |
SAP Business Area |
0001 |
MATNR |
Material number |
MAT01 |
PROD_CODE |
Material product code defined in the external system |
XXX or blank |
GROUP_PROD_CODE |
Set product code. This is the common product code of the set sub-items |
YYY or blank |
QUANTITY |
Item quantity (2) |
‘ 2000 ’ (two) |
UNIT |
Item selling/buying unit |
ST (pieces) |
APAR_IND |
Input or Output tax indicator |
A – output tax or A/R V – input tax or A/P |
TAX_TYPE |
Tax type or category |
0 – Sales Tax 1 – Consumer Use Tax 2 – Service Tax 3 – Rental/Lease Tax |
EXEMP_IND |
Non-taxable transaction control indicator |
Blank or 0 – External system decides (3) 1 – Taxable (4) 2 – Non-taxable (5) |
TAX_DATE |
Transaction date for tax calculation |
19991009 |
TXJCD_ST |
Ship-to jurisdiction code |
|
TXJCD_SF |
Ship-from jurisdiction code |
|
TXJCD_POA |
Jurisdiction code for Point of Order Acceptance |
|
TXJCD_POO |
Jurisdiction code for Point of Order Origin |
|
AMOUNT |
Tax base amount (6) |
‘ 300000 ‘ (three thousand) |
GROSS_AMOUNT |
Gross tax base amount (7) |
‘ 300000 ‘ (three thousand) |
FREIGHT_AM |
Item freight amount |
‘ 1500 ‘ (fifteen) |
EXEMPT_AMT |
Exempt amount |
Blank |
ACCNT_NO |
Customer/Vendor account number |
CUST01 |
ACCNT_CLS |
Account class |
Blank |
COST_OBJECT |
Cost object where the goods are consumed |
Cost Center or blank |
PTP_IND |
Indicator: Point of Title Passage |
Blank |
EXCERTIF |
Customer exempt certification defined in SAP (8) |
It is recommended to leave this field blank |
EXREASON |
Exempt reason defined in SAP (9) |
It is recommended to leave this field blank |
USER_DATA |
User-specific data to be passed to external tax system |
It is sent during tax calculation for validation purposes only |
...
1. Set is an item composed of sub-items. When a Set is entered in the order, its components appear as its sub-items. Each sub-item has as its higher-level item position number the same GROUP_ID.
2. The quantity field has an implied 3 decimal places. When entering the quantity, three additional zeros must be added. Last character is reserved for the sign: space means positive. For example: ‘ 10000 ‘ is actually 10.000.
3. External system decides if transaction is non-taxable vs. taxable. External system’s taxability decision engine is used.
4. External system assumes transaction is taxable. Therefore, external system’s taxability decision engine is ignored and tax rates are based solely on jurisdiction codes.
5. Call to external tax system is bypassed during tax calculation. SAP imposes zero rates and zero amounts.
6. When entering a taxable amount, add two additional zeros to take into consideration two decimal places. Last character represents the sign: ‘ ‘ or ‘+’ for positive values and ‘-‘ for negative values. For example, ‘ 10000 ‘ is actually 100.00.
7. This field is currently defaulted with AMOUNT.
8. If this field is blank, a possible exempt certification defined for the customer is checked in the external system.
9. It is recommended to fill this field for reporting purposes only and not to use it for tax calculation.