SAP ABAP Table CRMT_TAXEXEMPT_DATA (Customer Tax Exemption Certificate: Data Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-TAX (Application Component) Tax Determination
     ⤷ CRM_TAXEXEMPT (Package) Customer Tax Exemption Certificate # DB & Conf

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_TAXEXEMPT_DATA	Table Relationship Diagram
Short Description	Customer Tax Exemption Certificate: Data Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
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	TAXEXEMPT_ID	☐	CRM_TAX_EXEMPT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	Customer Tax Exemption Certificate ID
2	USAGE_IND	☐	CRM_TAX_EXEMPT_USAGE	CRM_TAX_EXEMPT_USAGE	CHAR	1	0	Customer Tax Exemption Certificate Usage Indicator
3	LIMIT_IND	☐	CRM_TAX_EXEMPT_LIMIT	CRM_TAX_EXEMPT_LIMIT	CHAR	1	0	Customer Tax Exemption Certificate Limit Indicator
4	BILL_ORG	☐	CRM_TAX_EXEMPT_BILL_ORG	SYSUUID	RAW	16	0	Billing Unit GUID
5	CUSTOMER	☐	CRM_TAX_EXEMPT_CUSTOMER	SYSUUID	RAW	16	0	Customer GUID
6	TAX_TYPE	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type
7	COUNTRY	☐	CRMT_TAX_CTY	LAND1	CHAR	3	0	Country	T005
8	REGION	☐	CRMT_TAX_REG	REGIO	CHAR	3	0	Region	T005S
9	EXT_ID	☐	CRM_TAX_EXEMPT_EXT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	External Customer Tax Exemption Certificate ID
10	VALID_FROM	☐	CRM_TAX_EXEMPT_VALID_FROM	DATUM	DATS	8	0	Customer Tax Exemption Certificate Validity Start Date
11	VALID_TO	☐	CRM_TAX_EXEMPT_VALID_TO	DATUM	DATS	8	0	Customer Tax Exemption Certificate Validity End Date
12	MAX_AMOUNT	☐	CRM_TAX_EXEMPT_MAX_AMOUNT	WERTV8	CURR	15	2	Maximum amount in Exemption Certificate Currency
13	TOTAL_AMOUNT	☐	CRM_TAX_EXEMPT_TOTAL_AMOUNT	WERTV8	CURR	15	2	Total used amount in Exemption Certificate Currency
14	CURRENCY	☐	CRM_TAX_EXEMPT_CURRENCY	WAERS	CUKY	5	0	Customer Tax Exemption Certificate Currency	TCURC
15	STATUS	☐	CRM_TAX_EXEMPT_STATUS	CRM_TAX_EXEMPT_STATUS	CHAR	1	0	Customer Tax Exemption Certificate Life Cycle Status
16	BLOCK	☐	CRM_TAX_EXEMPT_BLOCK	CRM_TAX_EXEMPT_BLOCK	CHAR	1	0	Customer Tax Exemption Certificate Block
17	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
18	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
19	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
20	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_TAXEXEMPT_DATA	COUNTRY	T005	LAND1
2	CRMT_TAXEXEMPT_DATA	CURRENCY	TCURC	WAERS
3	CRMT_TAXEXEMPT_DATA	REGION	T005S	BLAND

History

Last changed by/on	SAP	20110908
SAP Release Created in	701