Tax Code Condition Record
In ScopeTechnical: A003 | ID: SAP-FI-A003-TAX_CODE_CONDITION_RECORD
Stores the actual tax rate percentages for each tax code, country, and tax procedure combination as condition records in the pricing framework. These records are evaluated at runtime to determine...
See how this object fits into Finance
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Unknown
- Typical Sources
- Legacy SAP system (condition table extract)Tax configuration workbookFinance design documentation
Classification
- Information Type
- Configuration
- Object Type
- dictionary
Target Structure
- Load Approach
- Excel
- Target Objects
- A003
Field Definitions(5)
Rules & Considerations(58)
validation
constraint
Sample Load Data(4)
| _scenario | ALANDRPK | KAPPLRPK | KNUMHR | KSCHLRPK | MWSKZRPK | DATAB | DATBI | EGRKZ | KALSM | LSTML | MWART | PROCD | PRUEF | TXIND | TXREL | XMSTU | XSLTA | ZMWSK | COUNTRY | J_1BISS | TAX_CODE | VALID_TO | J_1BUSAGE | NEWDEFTAX | TOLERANCE | ZMWSK_ESA | ZMWSK_ESE | J_1BTAXLW1 | J_1BTAXLW2 | J_1BTAXLW4 | J_1BTAXLW5 | J_1BTXICEX | J_1BTXIPEX | VALID_FROM | TAX_PROCEDURE | TAX_PERCENTAGE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | GBR | TX | 0000000001 | TX00 | V1 | 20200101 | 99991231 | S | SAMPLE | SAM | S | SAMPLE | S | S | S | S | S | SA | GB | S | V1 | 9999-12-31 | S | S | 100.00 | SA | SA | SAM | SAM | SAM | SAM | S | S | 2020-01-01 | TAXGB | 20.00 |
| Closed historical record with successor reference | US | UX | 0000000002 | TX02 | 02 | 20221231 | 20231231 | T | TAMPLE | TAM | T | TAMPLE | T | T | T | T | T | TA | — | T | — | — | T | T | 100.1 | TA | TA | TAM | TAM | TAM | TAM | T | T | — | — | — |
| New record with minimal optional data | GB | TZ | 0000000003 | TX03 | 03 | 99991020 | 99991231 | — | SCMPLE | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
Example values from field definitions
- ALANDRPK
- GBR
- KAPPLRPK
- TX
- KNUMHR
- 0000000001
- KSCHLRPK
- TX00
- MWSKZRPK
- V1
- DATAB
- 20200101
- DATBI
- 99991231
- EGRKZ
- S
- KALSM
- SAMPLE
- LSTML
- SAM
- MWART
- S
- PROCD
- SAMPLE
- PRUEF
- S
- TXIND
- S
- TXREL
- S
- XMSTU
- S
- XSLTA
- S
- ZMWSK
- SA
- COUNTRY
- GB
- J_1BISS
- S
- TAX_CODE
- V1
- VALID_TO
- 9999-12-31
- J_1BUSAGE
- S
- NEWDEFTAX
- S
- TOLERANCE
- 100.00
- ZMWSK_ESA
- SA
- ZMWSK_ESE
- SA
- J_1BTAXLW1
- SAM
- J_1BTAXLW2
- SAM
- J_1BTAXLW4
- SAM
- J_1BTAXLW5
- SAM
- J_1BTXICEX
- S
- J_1BTXIPEX
- S
- VALID_FROM
- 2020-01-01
- TAX_PROCEDURE
- TAXGB
- TAX_PERCENTAGE
- 20.00
Closed historical record with successor reference
- ALANDRPK
- US
- KAPPLRPK
- UX
- KNUMHR
- 0000000002
- KSCHLRPK
- TX02
- MWSKZRPK
- 02
- DATAB
- 20221231
- DATBI
- 20231231
- EGRKZ
- T
- KALSM
- TAMPLE
- LSTML
- TAM
- MWART
- T
- PROCD
- TAMPLE
- PRUEF
- T
- TXIND
- T
- TXREL
- T
- XMSTU
- T
- XSLTA
- T
- ZMWSK
- TA
- COUNTRY
- —
- J_1BISS
- T
- TAX_CODE
- —
- VALID_TO
- —
- J_1BUSAGE
- T
- NEWDEFTAX
- T
- TOLERANCE
- 100.1
- ZMWSK_ESA
- TA
- ZMWSK_ESE
- TA
- J_1BTAXLW1
- TAM
- J_1BTAXLW2
- TAM
- J_1BTAXLW4
- TAM
- J_1BTAXLW5
- TAM
- J_1BTXICEX
- T
- J_1BTXIPEX
- T
- VALID_FROM
- —
- TAX_PROCEDURE
- —
- TAX_PERCENTAGE
- —
New record with minimal optional data
- ALANDRPK
- GB
- KAPPLRPK
- TZ
- KNUMHR
- 0000000003
- KSCHLRPK
- TX03
- MWSKZRPK
- 03
- DATAB
- 99991020
- DATBI
- 99991231
- EGRKZ
- —
- KALSM
- SCMPLE
- LSTML
- —
- MWART
- —
- PROCD
- —
- PRUEF
- —
- TXIND
- —
- TXREL
- —
- XMSTU
- —
- XSLTA
- —
- ZMWSK
- —
- COUNTRY
- —
- J_1BISS
- —
- TAX_CODE
- —
- VALID_TO
- —
- J_1BUSAGE
- —
- NEWDEFTAX
- —
- TOLERANCE
- —
- ZMWSK_ESA
- —
- ZMWSK_ESE
- —
- J_1BTAXLW1
- —
- J_1BTAXLW2
- —
- J_1BTAXLW4
- —
- J_1BTAXLW5
- —
- J_1BTXICEX
- —
- J_1BTXIPEX
- —
- VALID_FROM
- —
- TAX_PROCEDURE
- —
- TAX_PERCENTAGE
- —
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 58