| 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 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KNUMV | Allow NULL? |
| 3 | KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | KPOSN | Allow NULL? |
| 4 | STUNR | Step number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | STUNR | Allow NULL? |
| 5 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHK | Allow NULL? |
| 6 | NUM | Condition Contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WCB_COCO_NUM | Allow NULL? |
| 7 | GUID | Condition Contract GUID | varbinary | 16 | 0 | RAW | | Yes | | WCB_GUID | |
| 8 | DOC_TYPE_TO | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WCB_DOC_TYPE | Allow NULL? |
| 9 | DOCNR_TO | Condition Contract: Document Number of Follow-On Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WCB_DOCNR_TO | Allow NULL? |
| 10 | DOC_YEAR_TO | Condition Contract: Year of Follow-On Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | WCB_DOC_YEAR_TO | Allow NULL? |
| 11 | KNUMH | Condition record number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KONP | KNUMH | Allow NULL? |
| 12 | KOPOS | Sequential number of the condition | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | KONP | KOPOS | Allow NULL? |
| 13 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | KAPPL | Allow NULL? |
| 14 | KSCHL | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KSCHA | Allow NULL? |
| 15 | LOGICAL_DELETED | Indicator: Deleted Logically | char | 1 | 0 | CHAR | (N' ') | Yes | | WCB_LOGICAL_DELETED | Allow NULL? |
| 16 | FLOW_TYPE | Document Flow Type | char | 1 | 0 | CHAR | (N' ') | Yes | | WCB_FLOW_TYPE | Allow NULL? |
| 17 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 18 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 19 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 20 | ACCR_REV_STATUS | CCS: Accruals reversal status | char | 1 | 0 | CHAR | (N' ') | Yes | | WB2_ACCRUALS_REVERSAL_STATUS | Allow NULL? |
| 21 | SETTL_DATE | CCS: Settlement Date of the Accruals Reversal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WB2_SETTLEMENT_DATE_ACCR_REV | Allow NULL? |
| 22 | REF_SETTL_DATE | CCS: Reference Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WB2_REF_SETTLEMENT_DATE | Allow NULL? |
| 23 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 24 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 25 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
