SAP ABAP Table ROIUVL_TCD (Tax Calculation Data)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
⤷ OIU_RVVA (Package) PRA Valuation (Revenue)
⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
⤷ OIU_RVVA (Package) PRA Valuation (Revenue)
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIUVL_TCD | Table Relationship Diagram |
Short Description | Tax Calculation Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | TCD_NO | OIUVL_TCD_NO | OIU_SYS_NO | NUMC | 12 | 0 | TCD Number | ||
3 | LAND1 | OIU_COUNTRY | LAND1 | CHAR | 3 | 0 | Country | T005 | |
4 | PRI_GEO_LOC | OIU_PRI_GEO_LOC | OIU_PRI_GEO_LOC | CHAR | 2 | 0 | Primary geographical location (PRI geo. loc.) | OIU_CM_LXPGL | |
5 | MAJPD_CD | OIU_MAJPD_CD | OIU_MAJPD_CD | CHAR | 1 | 0 | Major product code | ||
6 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | OIU_CM_MAT_PRCD | |
7 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
8 | SEVT_TAX_TY | OIU_SEVT_TAX_TY | OIU_SEVT_TAX_TY | CHAR | 2 | 0 | Severance Tax Type | OIU_CM_SEVTGRP | |
9 | EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
10 | EFF_TO_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
11 | TAX_CLASS_FL | OIUVL_TAX_CLASS_FL | OIUVL_TAX_CLASS_FL | CHAR | 1 | 0 | Tax class exist | ||
12 | MEAS_UNIT_NM | OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | * | |
13 | CURR | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
14 | FX_MCD_RAT | OIUVL_FX_MCD_RAT_AM | OIUVL_PERCENT76 | DEC | 7 | 6 | Fixed marketing rate amount | ||
15 | FX_MCD | OIUVL_FX_MCD_AM | WERT8 | CURR | 15 | 2 | Fixed marketing amount | ||
16 | RMB_TAX_CD | OIUVL_RMB_TX_CD | OIUVL_RMB_TX_CD | CHAR | 1 | 0 | Reimbursement tax code | ||
17 | RMB_MKCT_FL_1 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
18 | RMB_MKCT_FL_2 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
19 | RMB_MKCT_FL_3 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
20 | RMB_MKCT_FL_4 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
21 | RMB_MKCT_FL_5 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
22 | RMB_MKCT_FL_6 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
23 | RMB_MKCT_FL_7 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
24 | RMB_MKCT_FL_8 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
25 | RMB_MKCT_FL_9 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
26 | RMB_MKCT_FL_10 | OIUVL_RMB_MKCT_FL | OIUVL_RMB_MKCT_FL | CHAR | 1 | 0 | Marketing reimbursement for marketing cost allowed flag | ||
27 | DED_FL_1 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
28 | DED_FL_2 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
29 | DED_FL_3 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
30 | DED_FL_4 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
31 | DED_FL_5 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
32 | DED_FL_6 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
33 | DED_FL_7 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
34 | DED_FL_8 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
35 | DED_FL_9 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
36 | DED_FL_10 | OIUVL_DED_FL | OIUVL_DED_FL | CHAR | 1 | 0 | Deduct allowed for deduction flag | ||
37 | EXMP_CD_1 | OIUVL_EXMP_CD | OIUVL_EXMP_CD | CHAR | 2 | 0 | Exempt Entity Code | ||
38 | EXMP_CD_2 | OIUVL_EXMP_CD | OIUVL_EXMP_CD | CHAR | 2 | 0 | Exempt Entity Code | ||
39 | EXMP_CD_3 | OIUVL_EXMP_CD | OIUVL_EXMP_CD | CHAR | 2 | 0 | Exempt Entity Code | ||
40 | EXMP_CD_4 | OIUVL_EXMP_CD | OIUVL_EXMP_CD | CHAR | 2 | 0 | Exempt Entity Code | ||
41 | EXMP_CD_5 | OIUVL_EXMP_CD | OIUVL_EXMP_CD | CHAR | 2 | 0 | Exempt Entity Code | ||
42 | RMB_PART_CD_1 | OIUVL_RMB_PART_CD | OIUVL_RMB_PART_CD | CHAR | 1 | 0 | Reimbursement Part Code | ||
43 | RMB_PART_CD_2 | OIUVL_RMB_PART_CD | OIUVL_RMB_PART_CD | CHAR | 1 | 0 | Reimbursement Part Code | ||
44 | RMB_PART_CD_3 | OIUVL_RMB_PART_CD | OIUVL_RMB_PART_CD | CHAR | 1 | 0 | Reimbursement Part Code | ||
45 | RMB_PART_CD_4 | OIUVL_RMB_PART_CD | OIUVL_RMB_PART_CD | CHAR | 1 | 0 | Reimbursement Part Code | ||
46 | RMB_PART_CD_5 | OIUVL_RMB_PART_CD | OIUVL_RMB_PART_CD | CHAR | 1 | 0 | Reimbursement Part Code | ||
47 | EXMP_TAX_CLS | OIU_TAX_CLS | OIU_TAX_CLS | CHAR | 4 | 0 | Tax Class | OIU_CM_TAXCLS | |
48 | GR_UP_RMB_FL | OIUVL_GR_UP_RMB_FL | OIU_FLAG | CHAR | 1 | 0 | Gross up reimbursement amount | ||
49 | ONE_PC_GAS_RMB_F | OIUVL_ONE_PC_GAS_RMB_FL | OIUVL_ONE_PC_GAS_RMB_FL | CHAR | 1 | 0 | One percent tax reimbursement | ||
50 | INCL_TAX_FREE_05 | OIUVL_INCL_TAX_FREE_05 | OIU_FLAG | CHAR | 1 | 0 | Include Tax Free 05 in taxable value/volume summarization | ||
51 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
52 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
53 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
54 | EXMPT_CD1_FL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
55 | EXMPT_CD2_FL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
56 | EXMPT_CD3_FL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
57 | EXMPT_CD4_FL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
58 | EXMPT_CD5_FL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
59 | PRI_GEO_DESC | OIU_PRI_GEO_DESC | CHAR30 | CHAR | 30 | 0 | Primary geographical location description | ||
60 | SEVT_TAX_DE | OIU_SEVT_TAX_DE | OIU_CAPTEXT50 | CHAR | 50 | 0 | Severance Tax Type Description | ||
61 | MAJPD_DE | DDTEXT | DDTEXT | CHAR | 60 | 0 | Explanatory short text | ||
62 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
63 | VL_TYPE_DE | OIU_VL_TYPE_DE | OIU_TEXT50 | CHAR | 50 | 0 | Volume Type Description | ||
64 | TAX_CLS_DE | OIU_TAX_CLS_DE | OIU_TEXT50 | CHAR | 50 | 0 | Description | ||
65 | XXDBACTION | OIU_DBACTION | CHAR1 | CHAR | 1 | 0 | Database Action Flag |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIUVL_TCD | EXMP_TAX_CLS | OIU_CM_TAXCLS | TAX_CLS | 1 | CN | |
2 | ROIUVL_TCD | LAND1 | T005 | LAND1 | 1 | CN | |
3 | ROIUVL_TCD | MATNR | OIU_CM_MAT_PRCD | MATNR | 1 | CN | |
4 | ROIUVL_TCD | PRI_GEO_LOC | OIU_CM_LXPGL | PRI_GEO_LOC | KEY | 1 | CN |
5 | ROIUVL_TCD | SEVT_TAX_TY | OIU_CM_SEVTGRP | SEVT_TAX_TY | KEY | 1 | CN |
6 | ROIUVL_TCD | VL_TYPE_CD | OIU_PR_VLTYP | VL_TYPE_CD | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |