| 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 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CACSIMPYEAR | Allow NULL? |
| 3 | CASE_ID | ID of Commission Case | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CACSCASEID | Allow NULL? |
| 4 | CASE_VERS | Commission Case Version | nvarchar | 6 | 0 | NUMC | (N'000000') | No | YCRM01_CAS | CACSCASEVERS | Allow NULL? |
| 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACSPARTID | Allow NULL? |
| 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACSINVPOS | Allow NULL? |
| 7 | FLG_CANCEL_OBJ | Indicator: Object is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCOBJ | Allow NULL? |
| 8 | FLG_CANCEL_VERS | Indicator: Version is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCVERS | Allow NULL? |
| 9 | STATUS_VERSION | Object Version Status | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSVERS | Allow NULL? |
| 10 | STATUS_WORK | Object Processing Status (Replica) | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSWORKP | Allow NULL? |
| 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID | Allow NULL? |
| 12 | PD_OE_ID | Organizational Unit (Object Type O) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | CACS_OBJID_O | Allow NULL? |
| 13 | GPART | Business Partner to Receive Commission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CACS_GPART_INV | Allow NULL? |
| 14 | ROLE | Participant Role | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCACS_ROLE | CACSROLE | Allow NULL? |
| 15 | ROLE_COMMSHAR | Share of Direct Remuneration (in Percent) | decimal | 10 | 5 | DEC | ((0)) | Yes | | CACSCOMMSHARE | |
| 16 | ROLE_PRODSHAR | Share of Indirect Remuneration (in Percent) | decimal | 10 | 5 | DEC | ((0)) | Yes | | CACSPRODSHARE | |
| 17 | DISTRIBUTE | Distribution Key for the Activity Share | int | 10 | 0 | INT4 | ((0)) | Yes | | CACSDISTRIBUTE | Allow NULL? |
| 18 | FLG_CONSTELL | Indicator: Ignore Commissions Contract in Constellation | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGCONS | Allow NULL? |
| 19 | FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGREV | Allow NULL? |
