| 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 | KTAAR | Sales Activity Type for Sales Support | nvarchar | 4 | 0 | CHAR | (N' ') | No | | KTAAR | Allow NULL? |
| 3 | KOPGR | Screen sequence group for document header & item | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVHB | BIFGR | Allow NULL? |
| 4 | UEVOR | Proposal for Fcode on the overview screen | nvarchar | 20 | 0 | CHAR | (N' ') | No | | UEVOR_KA | Allow NULL? |
| 5 | NUMKE | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKI | Allow NULL? |
| 6 | PARGR | Partner Determination Procedure | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVPG | PARGR | Allow NULL? |
| 7 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | No | | VBTYP | Allow NULL? |
| 8 | VBOBJ | SD document object | char | 1 | 0 | CHAR | (N' ') | No | | VBOBJ | Allow NULL? |
| 9 | TRVOG | Transaction group | char | 1 | 0 | CHAR | (N' ') | No | | TRVOG | Allow NULL? |
| 10 | KAPPL | Application for output conditions | nvarchar | 2 | 0 | CHAR | (N' ') | No | T681A | NA_KAPPL | Allow NULL? |
| 11 | KSCHL | Output Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | NA_KSCHL | Allow NULL? |
| 12 | KALSM | Output determination procedure | nvarchar | 6 | 0 | CHAR | (N' ') | No | T683 | KALSMB | Allow NULL? |
| 13 | DATVO | Date proposed as valid-to date | char | 1 | 0 | CHAR | (N' ') | No | | DATVO | Allow NULL? |
| 14 | TXTGR | Text determination procedure | nvarchar | 2 | 0 | CHAR | (N' ') | No | TTXG | TXTGR | Allow NULL? |
| 15 | AFART | Inquiry type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_AFART | Allow NULL? |
| 16 | AGART | Quotation type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_AGART | Allow NULL? |
| 17 | AUART | Sales order type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_AUART | Allow NULL? |
| 18 | GUART | Credit memo type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_GUART | Allow NULL? |
| 19 | LAART | Debit memo type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_LAART | Allow NULL? |
| 20 | REART | Returns type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_REART | Allow NULL? |
| 21 | SOART | Sales document type for sales activities | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_SOART | Allow NULL? |
| 22 | KTAOR | Organizational data required for sales activites | char | 1 | 0 | CHAR | (N' ') | No | | KTAOR | Allow NULL? |
| 23 | BEZOB | Reference mandatory | char | 1 | 0 | CHAR | (N' ') | No | | BEZOB | Allow NULL? |
| 24 | KWIVO | Indicator for mandatory follow-up sales activity | char | 1 | 0 | CHAR | (N' ') | No | | KWIVO | Allow NULL? |
| 25 | KTAFK | Type of follow-up activity | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKK | KTAFK | Allow NULL? |
| 26 | AUMA1 | Order type for sample enclosure for direct mailing campaign | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_AUMA1 | Allow NULL? |
| 27 | AUMA2 | Order type for enclosures for a direct mailing campaign | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | KTA_AUMA2 | Allow NULL? |
| 28 | KPAFK | Partner function for follow-up sales activity | nvarchar | 2 | 0 | CHAR | (N' ') | No | TPAR | KPAFK | Allow NULL? |
| 29 | STGRU | Sales activity status group | nvarchar | 3 | 0 | NUMC | (N'000') | No | TVC6 | STGRU_CAS | Allow NULL? |
| 30 | FEHGR | Incompletion procedure for sales document | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVUV | FEHGR | Allow NULL? |
| 31 | DIAFE | Dialog message for incompletion | char | 1 | 0 | CHAR | (N' ') | No | | DIAUV | Allow NULL? |
| 32 | NUMADR | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKI | Allow NULL? |
| 33 | AR_OBJECT | Document type | nvarchar | 10 | 0 | CHAR | (N' ') | No | TOADV | SAEOBJART | Allow NULL? |
| 34 | TXT_KONSE | Text entered in document | char | 1 | 0 | CHAR | (N' ') | No | | TXT_KONSE | Allow NULL? |
| 35 | EXCLUDE_FC | Exclusion of Fcodes that lead to CREATE->EDIT | char | 1 | 0 | CHAR | (N' ') | Yes | | EXCLUDE_FC | Allow NULL? |
| 36 | STGKK | Statistics grp for sales activity processing in order header | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TKSF | STGKK | Allow NULL? |
| 37 | DIRECTION | Direction of sales activity: Inbound / outbound | char | 1 | 0 | CHAR | (N' ') | Yes | | ACT_DIRECTION | Allow NULL? |
| 38 | PA_PLTYPE | Potential planning: Planning hierarchy type | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | T445P | CASPA_PLTYPE | Allow NULL? |
| 39 | KALE | Maintain appointments in calendar | char | 1 | 0 | CHAR | (N' ') | Yes | | KALE | Allow NULL? |
| 40 | FOLLOW_UP_PREF | CAS: Identify preferred follow-up action | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FOLLOW_UP_PREFERENCE | Allow NULL? |
| 41 | KTAAR_CLASS | CAS: Classify sales activity types | char | 1 | 0 | CHAR | (N' ') | Yes | | KTAAR_CLASS | Allow NULL? |
| 42 | ABPATTERN | Action box pattern | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TVC_FOLLOW_UP | CAS_ABPATTERN | Allow NULL? |
| 43 | ISP_KAPPL | Application for output conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | NA_KAPPL | Allow NULL? |
| 44 | ISP_KSCHL | Output Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | NA_KSCHL | Allow NULL? |
| 45 | ISP_KALSM | Output determination procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMB | Allow NULL? |
