SAP ABAP Table UKSD (User Control Totals (Online))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	UKSD	Table Relationship Diagram
Short Description	User Control Totals (Online)

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	USNAM	☑	USNAM	XUBNAME	CHAR	12	0	User name	*
3	DATUM	☐	DATUM_UKSD	DATUM	DATS	8	0	Date of Last Initialization of the Control Totals
4	UZEIT	☐	UZEIT_UKSD	UZEIT	TIMS	6	0	Time of Last Initializing of Control Totals
5	ANZBL	☐	ANZBL_UKSD	PACK3	DEC	5	0	Number of Documents Entered Online (Control Total)
6	AZDEZ	☐	AZDEZ_F05K	AZDEZ	CHAR	1	0	Number of Decimal Places for Displaying Amounts
7	XBZVB	☐	XBZVB	XFELD	CHAR	1	0	Indicator: Use document counter in update task ?
8	VSALD	☐	VSALD_UKSD	WRTV8	CURR	15	2	Control totals: Customer balance requirements
9	SALDD	☐	SALDD_UKSD	WRTV8	CURR	15	2	Customer Balance Control Totals
10	WAERD	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	VSALK	☐	VSALK_UKSD	WRTV8	CURR	15	2	Control totals: Vendor balance requirements
12	SALDK	☐	SALDK_UKSD	WRTV8	CURR	15	2	Vendor Balance Control Totals
13	WAERK	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	KOAR1	☐	KOART	KOART	CHAR	1	0	Account type
15	VONK1	☐	VONKN_UKSD	MAXKN	CHAR	10	0	From account number (interval lower limit)
16	BISK1	☐	BISKN_UKSD	MAXKN	CHAR	10	0	To Account Number (Interval Upper Limit)
17	SOLV1	☐	SOLV1_UKSD	WERT8	CURR	15	2	Control Totals: Debit Requirements
18	HABV1	☐	HABV1_UKSD	WERT8	CURR	15	2	Control Totals: Credit Requirements
19	SOLL1	☐	SOLL1_UKSD	WERT8	CURR	15	2	Debit Amount Control Totals
20	HABN1	☐	HABN1_UKSD	WERT8	CURR	15	2	Control Totals Credit Amount
21	WAER1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	KOAR2	☐	KOART	KOART	CHAR	1	0	Account type
23	VONK2	☐	VONKN_UKSD	MAXKN	CHAR	10	0	From account number (interval lower limit)
24	BISK2	☐	BISKN_UKSD	MAXKN	CHAR	10	0	To Account Number (Interval Upper Limit)
25	SOLV2	☐	SOLV1_UKSD	WERT8	CURR	15	2	Control Totals: Debit Requirements
26	HABV2	☐	HABV1_UKSD	WERT8	CURR	15	2	Control Totals: Credit Requirements
27	SOLL2	☐	SOLL1_UKSD	WERT8	CURR	15	2	Debit Amount Control Totals
28	HABN2	☐	HABN1_UKSD	WERT8	CURR	15	2	Control Totals Credit Amount
29	WAER2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	KOAR3	☐	KOART	KOART	CHAR	1	0	Account type
31	VONK3	☐	VONKN_UKSD	MAXKN	CHAR	10	0	From account number (interval lower limit)
32	BISK3	☐	BISKN_UKSD	MAXKN	CHAR	10	0	To Account Number (Interval Upper Limit)
33	SOLV3	☐	SOLV1_UKSD	WERT8	CURR	15	2	Control Totals: Debit Requirements
34	HABV3	☐	HABV1_UKSD	WERT8	CURR	15	2	Control Totals: Credit Requirements
35	SOLL3	☐	SOLL1_UKSD	WERT8	CURR	15	2	Debit Amount Control Totals
36	HABN3	☐	HABN1_UKSD	WERT8	CURR	15	2	Control Totals Credit Amount
37	WAER3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
38	KOAR4	☐	KOART	KOART	CHAR	1	0	Account type
39	VONK4	☐	VONKN_UKSD	MAXKN	CHAR	10	0	From account number (interval lower limit)
40	BISK4	☐	BISKN_UKSD	MAXKN	CHAR	10	0	To Account Number (Interval Upper Limit)
41	SOLV4	☐	SOLV1_UKSD	WERT8	CURR	15	2	Control Totals: Debit Requirements
42	HABV4	☐	HABV1_UKSD	WERT8	CURR	15	2	Control Totals: Credit Requirements
43	SOLL4	☐	SOLL1_UKSD	WERT8	CURR	15	2	Debit Amount Control Totals
44	HABN4	☐	HABN1_UKSD	WERT8	CURR	15	2	Control Totals Credit Amount
45	WAER4	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
46	KOAR5	☐	KOART	KOART	CHAR	1	0	Account type
47	VONK5	☐	VONKN_UKSD	MAXKN	CHAR	10	0	From account number (interval lower limit)
48	BISK5	☐	BISKN_UKSD	MAXKN	CHAR	10	0	To Account Number (Interval Upper Limit)
49	SOLV5	☐	SOLV1_UKSD	WERT8	CURR	15	2	Control Totals: Debit Requirements
50	HABV5	☐	HABV1_UKSD	WERT8	CURR	15	2	Control Totals: Credit Requirements
51	SOLL5	☐	SOLL1_UKSD	WERT8	CURR	15	2	Debit Amount Control Totals
52	HABN5	☐	HABN1_UKSD	WERT8	CURR	15	2	Control Totals Credit Amount
53	WAER5	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UKSD	MANDT	T000	MANDT	KEY	1	CN
2	UKSD	WAER1	TCURC	WAERS	REF	C	CN
3	UKSD	WAER2	TCURC	WAERS	REF	C	CN
4	UKSD	WAER3	TCURC	WAERS	REF	C	CN
5	UKSD	WAER4	TCURC	WAERS	REF	C	CN
6	UKSD	WAER5	TCURC	WAERS	REF	C	CN
7	UKSD	WAERD	TCURC	WAERS	REF	C	CN
8	UKSD	WAERK	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in