| 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 | KEYR1 | Returns Lot | nvarchar | 12 | 0 | CHAR | (N' ') | No | | KEYR1_KK | Allow NULL? |
| 3 | POSRA | Item number in a returns lot | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | POSRA_KK | Allow NULL? |
| 4 | SELT1 | Selection Category | char | 1 | 0 | CHAR | (N' ') | Yes | TFK004 | SELTX_KK | Allow NULL? |
| 5 | SELW1 | Field value to be selected | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SELOP_KK | Allow NULL? |
| 6 | BETRR | Return amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRR_KK | |
| 7 | BETRU | Input Amount For Returns in Transaction Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRU_KK | |
| 8 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 9 | WAERSU | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 11 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 12 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 13 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 14 | VALUT | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT | Allow NULL? |
| 15 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | DFKKSUMC | FIKEY_KK | Allow NULL? |
| 16 | RLSKO | Bank clearing account for returns | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | RLSKO_KK | Allow NULL? |
| 17 | RLGRD | Return reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TFK045A | RLGRD_KK | Allow NULL? |
| 18 | RLHBK | House bank's return reason | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TFK045D | RLHBK_KK | Allow NULL? |
| 19 | OPBEL | Payment document for returns | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPZBEL_KK | Allow NULL? |
| 20 | TXTVW | Note to Payee in Payment | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TXTVW_KK | Allow NULL? |
| 21 | KLAEB | Number of Clarification Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KLAEB_KK | Allow NULL? |
| 22 | STATE | CFC: Status of an application table entry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_ITEM_STATE | CFC_STATE | Allow NULL? |
| 23 | LOCK_USER | Name of the person to last change the status of the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CFC_UNAME | Allow NULL? |
| 24 | LOCK_LIMIT | CFC: Lock period of a lock entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_LOCK_LIMIT | Allow NULL? |
| 25 | WORKSTATE | Last processing status of a clarification case | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CFC_IT_WORKSTATE | CFC_WORKSTATE | Allow NULL? |
| 26 | RESUBMIT_DATE | Date on which Resubmission Occurs | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFC_RESUBMIT_DATE | Allow NULL? |
| 27 | WF_COUNT | Number of active workflows with this clarification case | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CFC_WORKFLOW_COUNTER | |
