| 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 | KAPPL | Application | nvarchar | 3 | 0 | CHAR | (N' ') | No | /SAPCND/T681A | PRCT_APPLICATION | Allow NULL? |
| 3 | KALSM | Pricing Procedure | nvarchar | 6 | 0 | CHAR | (N' ') | No | PRCC_COND_PPD | PRCT_PRIC_PROC | Allow NULL? |
| 4 | VERSI | Version Number of Pricing Procedure | nvarchar | 6 | 0 | CHAR | (N' ') | No | | PRCT_PP_VERSION | Allow NULL? |
| 5 | STUNR | Level Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PRCT_PP_STEP | Allow NULL? |
| 6 | ZAEHK | Condition Counter | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PRCT_PP_COUNTER | Allow NULL? |
| 7 | KSCHL | Pricing - Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /SAPCND/T685 | PRCT_COND_TYPE | Allow NULL? |
| 8 | KSTAT | Condition is Statistical | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_FLAG_COND_STATISTICAL | Allow NULL? |
| 9 | KVSL1 | Account Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PRCT_ACCOUNT_KEY_1 | Allow NULL? |
| 10 | KVSL2 | Account Key - Accruals | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PRCT_ACCOUNT_KEY_2 | Allow NULL? |
| 11 | KVEWE | Usage for Condition Technique | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | /SAPCND/T681V | /SAPCND/USAGE | Allow NULL? |
| 12 | STUNB | From Reference Step (for Percentage Conditions) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | PRCT_PP_STEP_FROM | Allow NULL? |
| 13 | STUN2 | To Reference Step (for Percentage Conditions) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | PRCT_PP_STEP_TO | Allow NULL? |
| 14 | KZWIW | Condition Subtotal | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_PP_SUBTOTAL | Allow NULL? |
| 15 | KOFRM | Condition Value Formula | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PRCT_FRM_VALUE | Allow NULL? |
| 16 | KOFRM_NUM | Condition Value Formula IPC | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | PRCT_FRM_VALUE_NUM | Allow NULL? |
| 17 | KOFRA | Condition Formula for Condition Basis | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PRCT_FRM_BASIS | Allow NULL? |
| 18 | KOFRA_NUM | Condition Base Formula IPC | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | PRCT_FRM_BASIS_NUM | Allow NULL? |
| 19 | KOBED | Pricing Condition | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PRCT_FRM_REQUIREMENT | Allow NULL? |
| 20 | KOBED_NUM | IPC Requirement | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | PRCT_FRM_REQUIREMENT_NUM | Allow NULL? |
| 21 | DRUKZ | Print Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_PRINT_INDICATOR | Allow NULL? |
| 22 | KOBLI | Condition is Mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_FLAG_COND_OBLIGATORY | Allow NULL? |
| 23 | KAUTO | Manual Condition | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_FLAG_COND_MANUAL | Allow NULL? |
| 24 | AUTHORITY_LEVEL | Level for Authorization Checks | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PRCT_AUTHORITY_LEVEL | Allow NULL? |
| 25 | MANDATORY_TYPE | Behaviour of Mandatory Conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | PRCT_MANDATORY_TYPE | Allow NULL? |
| 26 | DATA_ORIGIN | Data source system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PRC_DATA_ORIGIN | Allow NULL? |
