SAP ABAP Table UMSV (Tax Balances per Comp.Code, Tax Code and Process.Key)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	UMSV	Table Relationship Diagram
Short Description	Tax Balances per Comp.Code, Tax Code and Process.Key

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	LAUFD	☑	LAUFD	DATUM	DATS	8	0	Date on Which the Program Is to Be Run
3	LAUFI	☑	LAUFI	LAUFI	CHAR	6	0	Additional Identification
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	MWSKZ	☑	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
7	KTOSL	☑	KTOSL	CHAR3	CHAR	3	0	Transaction Key
8	SHKZG_UMSV	☑	SHKZG_UMSV	SHKZG	CHAR	1	0	Indicator: Total Balance, Debit Balance or Credit Balance?
9	HWBAS	☐	HWBAS_BSES	WERTV8	CURR	15	2	Tax Base Amount in Local Currency
10	HWSTE	☐	HWSTEV	WERTV7	CURR	13	2	Tax Amount in Local Currency with +/- Sign
11	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UMSV	BUKRS	T001	BUKRS	KEY	1	CN
2	UMSV	LAND1	T005	LAND1	KEY	1	CN
3	UMSV	MANDT	T000	MANDT	KEY	1	CN
4	UMSV	MWSKZ	T007A	MWSKZ	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in