The VAT_RULE table includes all the VAT rules configured in the SAP CC system. The
SAP CC system can use this business data to calculate the taxes when charging the
use (usage, recurring, one-shot) of a customer service.
Note Consult the SAP CC Application Help about the support of Value Added Tax (VAT) system and about the tax calculation feature
and process.
Consult the SAP CC Implementation and Configuration Guide about the management and customizing of the VAT rules.
| Schema Version | 5.0.6 | |
| Partitioned | No | |
The VAT_RULE table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| ID |
|
The identifier of the VAT rule | ||||
| DESCRIPTION |
|
The full text description of the VAT rule | ||||
| SUPPLIER_ZONE |
|
The geographical zone (country) of the service provider as supplier | ||||
| B2B_COUNTRY |
|
The source of the place of taxation in case of business to business (B2B) services | ||||
| B2C_COUNTRY |
|
The source of the place of taxation in case of business to customer (B2C) services | ||||
| DEFAULT_B2B_COUNTRY |
|
The default source of the place of taxation in case of B2B services | ||||
| DEFAULT_B2C_COUNTRY |
|
The default source of the place of taxation in case of B2C services |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The identifier of the VAT rule |
| Description |
The identifier of the VAT rule. Must be unique in the SAP CC system.
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The full text description of the VAT rule |
| Description |
|
| Type | NVARCHAR(2000), NOT NULL |
| Definition | The geographical zone (country) of the service provider as supplier |
| Description |
The geographical zone (country) of the service provider as supplier. This zone is
taken into account by the SAP CC system when applying the VAT rule during the tax
calculation process.
|
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The source of the place of taxation in case of business to business (B2B) services |
| Description |
|
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The source of the place of taxation in case of business to customer (B2C) services |
| Description |
|
| Format |
The possible values are:
|
| Type | DECIMAL(1), NULL |
| Definition | The default source of the place of taxation in case of B2B services |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
| Definition | The default source of the place of taxation in case of B2C services |
| Format |
The possible values are:
|
| Type | DECIMAL(1), NOT NULL |
