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

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_BOL	Table Relationship Diagram
Short Description	Customer Tax Exemption Certificate: Data Fields BOL

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	.INCLUDE	☐				0	0	Customer Tax Exemption Certificate: Key Fields
2	HDR_GUID	☐	CRM_TAX_EXEMPT_HEADER_GUID	SYSUUID	RAW	16	0	Object Header GUID
3	.INCLUDE	☐				0	0	Customer Tax Exemption Certificate: Data Fields
4	TAXEXEMPT_ID	☐	CRM_TAX_EXEMPT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	Customer Tax Exemption Certificate ID
5	USAGE_IND	☐	CRM_TAX_EXEMPT_USAGE	CRM_TAX_EXEMPT_USAGE	CHAR	1	0	Customer Tax Exemption Certificate Usage Indicator
6	LIMIT_IND	☐	CRM_TAX_EXEMPT_LIMIT	CRM_TAX_EXEMPT_LIMIT	CHAR	1	0	Customer Tax Exemption Certificate Limit Indicator
7	BILL_ORG	☐	CRM_TAX_EXEMPT_BILL_ORG	SYSUUID	RAW	16	0	Billing Unit GUID
8	CUSTOMER	☐	CRM_TAX_EXEMPT_CUSTOMER	SYSUUID	RAW	16	0	Customer GUID
9	TAX_TYPE	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type
10	COUNTRY	☐	CRMT_TAX_CTY	LAND1	CHAR	3	0	Country	T005
11	REGION	☐	CRMT_TAX_REG	REGIO	CHAR	3	0	Region	T005S
12	EXT_ID	☐	CRM_TAX_EXEMPT_EXT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	External Customer Tax Exemption Certificate ID
13	VALID_FROM	☐	CRM_TAX_EXEMPT_VALID_FROM	DATUM	DATS	8	0	Customer Tax Exemption Certificate Validity Start Date
14	VALID_TO	☐	CRM_TAX_EXEMPT_VALID_TO	DATUM	DATS	8	0	Customer Tax Exemption Certificate Validity End Date
15	MAX_AMOUNT	☐	CRM_TAX_EXEMPT_MAX_AMOUNT	WERTV8	CURR	15	2	Maximum amount in Exemption Certificate Currency
16	TOTAL_AMOUNT	☐	CRM_TAX_EXEMPT_TOTAL_AMOUNT	WERTV8	CURR	15	2	Total used amount in Exemption Certificate Currency
17	CURRENCY	☐	CRM_TAX_EXEMPT_CURRENCY	WAERS	CUKY	5	0	Customer Tax Exemption Certificate Currency	TCURC
18	STATUS	☐	CRM_TAX_EXEMPT_STATUS	CRM_TAX_EXEMPT_STATUS	CHAR	1	0	Customer Tax Exemption Certificate Life Cycle Status
19	BLOCK	☐	CRM_TAX_EXEMPT_BLOCK	CRM_TAX_EXEMPT_BLOCK	CHAR	1	0	Customer Tax Exemption Certificate Block
20	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
21	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
22	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
23	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
24	.INCLUDE	☐				0	0	Customer Tax Exemption Certificate: Data External Fields
25	CUSTOMER_ID	☐	CRM_TAX_EXEMPT_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer ID	*
26	BILL_ORG_ID	☐	CRM_TAX_EXEMPT_BILL_ORG_ID	BU_PARTNER	CHAR	10	0	Billing Unit ID	*
27	CREATED_BY_NAME	☐	CRM_TAX_EXEMPT_USER_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person (according to AD_NAMTEXT)
28	CHANGED_BY_NAME	☐	CRM_TAX_EXEMPT_USER_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person (according to AD_NAMTEXT)
29	TAX_TYPE_TEXT	☐	CRMT_TAX_TYPE_DESCRIPTION	TEXT40	CHAR	40	0	Description

Foreign Keys

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

History

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