| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | HRITABNR | HRTABNR | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | HRTABSEQNR | Allow NULL? |
| 4 | SALESORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 5 | DCHANNEL | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 6 | DIVISION | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 7 | AMOUNT | Rate (condition amount or percentage) where no scale exists | decimal | 11 | 2 | CURR | ((0)) | Yes | | KBETR_KOND | |
| 8 | UNIT_AMT | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 9 | PRICE_UNIT_AMT | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 10 | UOM_AMT | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 11 | VALID_FROM_AMT | Validity start date of the condition record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KODATAB | Allow NULL? |
| 12 | VALID_TO_AMT | Validity end date of the condition record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KODATBI | Allow NULL? |
| 13 | CALC_TYP_AMT | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | /XLSO/E_KRECH | Allow NULL? |
| 14 | DISCOUNT | Discount | decimal | 11 | 2 | CURR | ((0)) | Yes | | /XLSO/E_DISCOUNT | |
| 15 | UNIT_DCT | Rate unit (currency or percentage) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KONWA | Allow NULL? |
| 16 | PRICE_UNIT_DCT | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 17 | UOM_DCT | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | KMEIN | Allow NULL? |
| 18 | VALID_FROM_DCT | Validity start date of the condition record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KODATAB | Allow NULL? |
| 19 | VALID_TO_DCT | Validity end date of the condition record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KODATBI | Allow NULL? |
| 20 | CALC_TYP_DCT | Calculation type for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | /XLSO/E_KRECH | Allow NULL? |
