SAP Table S016
SIS: Sales activities
S016 (SIS: Sales activities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S016 to other SAP tables.
S016 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | 0 | |||
| VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | 0 | |||
| SPMON | Period to analyze - month | SPMON | NUMC | 6 | 0 | |||
| SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | 0 | |||
| SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | 0 | |||
| SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | 0 | |||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||
| VKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||
| KTAAR | Sales Activity Type for Sales Support | KTAAR | TVKK | CHAR | 4 | 0 | ||
| KTAGR | Reason for sales activity | KTAGR | TVC2 | CHAR | 3 | 0 | ||
| KTAER | Outcome of sales activities | KTAER | TVC1 | CHAR | 3 | 0 | ||
| KTAEB | Analysis of sales activity outcome | KTAEB | TVC4 | CHAR | 3 | 0 | ||
| PKUNAG | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||
| PARNR_AP | Number of contact person | PARNR | NUMC | 10 | 0 | |||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | 0 | |||
| CNT_CAS | Counter: number of sales activities/promotions | CNT_CAS | INT4 | 10 | 0 | |||
S016 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| S016 | KTAAR | S016 | MANDT | TVKK | Sales Activity Types | MANDT |
| S016 | KTAAR | S016 | KTAAR | TVKK | Sales Activity Types | KTAAR |
| S016 | KTAEB | S016 | KTAEB | TVC4 | Sales Activity Outcome Analysis | KTAEB |
| S016 | KTAEB | S016 | MANDT | TVC4 | Sales Activity Outcome Analysis | MANDT |
| S016 | KTAER | S016 | MANDT | TVC1 | Sales Activity Outcome | MANDT |
| S016 | KTAER | S016 | KTAER | TVC1 | Sales Activity Outcome | KTAER |
| S016 | KTAGR | S016 | MANDT | TVC2 | Reasons for Sales Activities | MANDT |
| S016 | KTAGR | S016 | KTAGR | TVC2 | Reasons for Sales Activities | KTAGR |
| S016 | MANDT | S016 | MANDT | T000 | Clients | MANDT |
| S016 | PKUNAG | S016 | MANDT | KNA1 | General Data in Customer Master | MANDT |
| S016 | PKUNAG | S016 | PKUNAG | KNA1 | General Data in Customer Master | KUNNR |
| S016 | VKBUR | S016 | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
| S016 | VKBUR | S016 | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
| S016 | VKGRP | S016 | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
| S016 | VKGRP | S016 | VKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
| S016 | VKORG | S016 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| S016 | VKORG | S016 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
