| 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 | * | MANDT | Allow NULL? |
| 2 | TYPE | DSD Deal Conditions - Deal Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | /DSD/PR_CUTP | /DSD/PR_TYPE | Allow NULL? |
| 3 | MATNR | DSD Deal Conditions - Material Number Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_MATNR_ACTIVE | Allow NULL? |
| 4 | MATKL | DSD Deal Conditions - Material Group Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_MATKL_ACTIVE | Allow NULL? |
| 5 | KONDM | DSD Deal Conditions - Material Pricing Group Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_KONDM_ACTIVE | Allow NULL? |
| 6 | VKORG | DSD Deal Conditions - Sales organization Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_VKORG_ACTIVE | Allow NULL? |
| 7 | VTWEG | DSD Deal Conditions - Distribution channel Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_VTWEG_ACTIVE | Allow NULL? |
| 8 | SPART | DSD Deal Conditions - Division Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_SPART_ACTIVE | Allow NULL? |
| 9 | WERKS | DSD Deal Conditions - Delivering Plant Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_WERKS_ACTIVE | Allow NULL? |
| 10 | KUNNR | DSD Deal Conditions - Customer Number Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_KUNNR_ACTIVE | Allow NULL? |
| 11 | KDGRP | DSD Deal Conditions - Customer Group Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_KDGRP_ACTIVE | Allow NULL? |
| 12 | HKUNNR | DSD Deal Conditions - Higher-Level Customer Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/PR_HKUNNR_ACTIVE | Allow NULL? |
