| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | VARNUMH | Condition Record ID | varbinary | 16 | 0 | RAW | | No | /SAPCND/CONDINDX | /SAPCND/COND_TABLE_ENTRY_ID | |
| 3 | CPE_CONDTYPE_PR | CPE: Condition Type of Pricing | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | CPET_CONDTYPE_PR | Allow NULL? |
| 4 | MM_PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EKORG | Allow NULL? |
| 5 | MM_VENDOR_GROUP | Group for Calculation Schema (Vendor) | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | KALSK | Allow NULL? |
| 6 | MM_VENDOR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ELIFN | Allow NULL? |
| 7 | MM_SUPPL_VEND | Supplying Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LLIEF | Allow NULL? |
| 8 | CPE_T_TERMNO | CPE Term - Number in Formula | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | CPET_TERMNO | Allow NULL? |
| 9 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /SAPCND/COND_TYPE | Allow NULL? |
| 10 | OBJECT_ID | Higher-level object number for condition records | varbinary | 16 | 0 | RAW | | Yes | | /SAPCND/OBJECT_ID | |
| 11 | TIMESTAMP_TO | Timestamp for Validity End Date | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | /SAPCND/TIMESTAMP_TO | Allow NULL? |
| 12 | RELEASE_STATUS | Release Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPCND/RELEASE_STATUS | Allow NULL? |
| 13 | TIMESTAMP_FROM | Timestamp for Validity Start Date | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | /SAPCND/TIMESTAMP_FROM | Allow NULL? |
| 14 | KSCHL_SUPP | Supplementary Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /SAPCND/SUPP_COND_TYPE | Allow NULL? |
| 15 | COND_GROUP_ID | ID of Group of Condition Records | varbinary | 16 | 0 | RAW | | Yes | | /SAPCND/COND_GROUP_ID | |
| 16 | MAINT_STATUS | Editing status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPCND/MAINT_STATUS | Allow NULL? |
| 17 | CREATED_BY | Name of User that Created the Condition Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /SAPCND/CREATED_BY | Allow NULL? |
| 18 | CREATED_ON | Date on which Condition Record was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPCND/CREATED_ON | Allow NULL? |
| 19 | KOPOS | Condition Supplement ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /SAPCND/SUPP_CONDITION_ID | Allow NULL? |
| 20 | SUPP_EXIST | Additional Data Indicator for Condition Record | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPCND/SUPP_EXIST | Allow NULL? |
| 21 | SCALE_DIM | Dimenstion number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /SAPCND/DIMENSION_ID | Allow NULL? |
| 22 | CPE_R_RATETYPE | CPE: Rate Type for Formula Assembly | char | 1 | 0 | CHAR | (N' ') | Yes | | CPET_RATETYPE | Allow NULL? |
| 23 | CPE_R_RATE | CPE Formula - Rate in Formula Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CPET_FORMRATE | |
| 24 | CPE_R_CURRENCY | CPE Formula - Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CPET_FORMCURR | Allow NULL? |
| 25 | CPE_R_PRICEUNIT | CPE Formula - Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | CPET_FORMPRUN | |
| 26 | CPE_R_UOM | CPE Formula - Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CPET_FORMUOM | Allow NULL? |
