SAP ABAP Table S009 (CAS: Last Documents)

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	S009	Table Relationship Diagram
Short Description	CAS: Last Documents

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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
9	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
10	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
11	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
12	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	BEL01	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
16	BEL02	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
17	BEL03	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
18	BEL04	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
19	BEL05	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
20	BEL06	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
21	BEL07	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
22	BEL08	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
23	BEL09	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
24	BEL10	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
25	BEL11	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
26	BEL12	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
27	BEL13	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
28	BEL14	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
29	BEL15	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
30	BEL16	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
31	BEL17	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
32	BEL18	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
33	BEL19	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
34	BEL20	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S009	BEL01	VBUK	VBELN	KEY	1	CN
2	S009	BEL02	VBUK	VBELN	KEY	1	CN
3	S009	BEL03	VBUK	VBELN	KEY	1	CN
4	S009	BEL04	VBUK	VBELN	KEY	1	CN
5	S009	BEL05	VBUK	VBELN	KEY	1	CN
6	S009	BEL06	VBUK	VBELN	KEY	1	CN
7	S009	BEL07	VBUK	VBELN	KEY	1	CN
8	S009	BEL08	VBUK	VBELN	KEY	1	CN
9	S009	BEL09	VBUK	VBELN	KEY	1	CN
10	S009	BEL10	VBUK	VBELN	KEY	1	CN
11	S009	BEL11	VBUK	VBELN	KEY	1	CN
12	S009	BEL12	VBUK	VBELN	KEY	1	CN
13	S009	BEL13	VBUK	VBELN	KEY	1	CN
14	S009	BEL14	VBUK	VBELN	KEY	1	CN
15	S009	BEL15	VBUK	VBELN	KEY	1	CN
16	S009	BEL16	VBUK	VBELN	KEY	1	CN
17	S009	BEL17	VBUK	VBELN	KEY	1	CN
18	S009	BEL18	VBUK	VBELN	KEY	1	CN
19	S009	BEL19	VBUK	VBELN	KEY	1	CN
20	S009	BEL20	VBUK	VBELN	KEY	1	CN
21	S009	KUNNR	KNA1	KUNNR	KEY	1	CN
22	S009	MANDT	T000	MANDT	KEY	1	CN
23	S009	SPART	TVTA	SPART	KEY	1	CN
24	S009	VKORG	TVKO	VKORG	KEY	1	CN
25	S009	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	470