SAP ABAP Table S409 (Contract & Billing)

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	S409	Table Relationship Diagram
Short Description	Contract & Billing

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	KUNNR	☑	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
9	VBELV	☑	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
10	POSNV	☑	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
11	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	WERKS	☑	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	T001W
13	VRKME	☑	VRKME	MEINS	UNIT	3	0	Sales unit	T006
14	PS_PSP_PNR	☑	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
20	AEWAVWR	☐	MC_AEWAVWR	WERTV10	CURR	19	2	Cost of incoming orders
21	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
22	AEKZWI1	☐	/CBAD/AEKZWI1	WERTV9	CURR	17	2	Consumed Budget
23	AEKZWI2	☐	/CBAD/AEKZWI2	WERTV9	CURR	17	2	Gross Value
24	AEKZWI3	☐	/CBAD/AEKZWI3	WERTV9	CURR	17	2	Discount
25	AEKZWI4	☐	/CBAD/AEKZWI4	WERTV9	CURR	17	2	Subtotal 4
26	AEKZWI5	☐	/CBAD/AEKZWI5	WERTV9	CURR	17	2	Subtotal 5
27	AEKZWI6	☐	/CBAD/AEKZWI6	WERTV9	CURR	17	2	Billed Quantity
28	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales
29	UMWAVWR	☐	MC_UMWAVWR	WERTV10	CURR	19	2	Cost of invoiced sales
30	UMMENGE	☐	MC_UMMENGE	MENGV15_3	QUAN	15	3	Sales quantity
31	UMKZWI1	☐	/CBAD/UMKZWI1	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 1
32	UMKZWI2	☐	/CBAD/UMKZWI2	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 2
33	UMKZWI3	☐	/CBAD/UMKZWI3	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 3
34	UMKZWI4	☐	/CBAD/UMKZWI4	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 4
35	UMKZWI5	☐	/CBAD/UMKZWI5	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 5
36	UMKZWI6	☐	/CBAD/UMKZWI6	WERTV9	CURR	17	2	Billing Document: Condition Subtotal 6

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S409	BASME	T006	MSEHI
2	S409	KUNNR	KNA1	KUNNR	KEY
3	S409	MANDT	T000	MANDT	KEY
4	S409	MATNR	MARA	MATNR	KEY
5	S409	POSNV	VBUP	POSNR	KEY
6	S409	PS_PSP_PNR	PRPS	PSPNR	KEY	C	CN
7	S409	STWAE	TCURC	WAERS
8	S409	VBELV	VBUK	VBELN	KEY
9	S409	VRKME	T006	MSEHI	KEY
10	S409	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20100310
SAP Release Created in	603