SAP ABAP Table S017 (SIS: Sales promotions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S017	Table Relationship Diagram
Short Description	SIS: Sales promotions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	VBELN	☑	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support	VBUK
9	KTAST	☑	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
10	KTAGR	☑	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	CNT_CAS	☐	CNT_CAS	INT4	INT4	10	0	Counter: number of sales activities/promotions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S017	KTAGR	TVC2	KTAGR
2	S017	KTAST	TVC3	KTAST
3	S017	MANDT	T000	MANDT
4	S017	VBELN	VBUK	VBELN

History

Last changed by/on	SAP	20050411
SAP Release Created in