SAP ABAP Table CRMM_TAXEXEMPT (Customer Tax Exemption Certificate)

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	TRANSP	Transparent table
Transparent table	CRMM_TAXEXEMPT	Table Relationship Diagram
Short Description	Customer Tax Exemption Certificate

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

History

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