SAP ABAP Table CNCTTEPRSAPE1001 (Country/Tax Region/Tax Type)

Hierarchy

☛ LOCAL (Software Component)
   ⤷ $TMP (Package) Temporary Objects (never transported!)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CNCTTEPRSAPE1001	Table Relationship Diagram
Short Description	Country/Tax Region/Tax Type

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Key for Condition Tables
3	VARNUMH	☑	/SAPCND/COND_TABLE_ENTRY_ID	SYSUUID	RAW	16	0	Condition Record ID	/SAPCND/CONDINDX
4	COUNTRY_TX	☐	TTET_COUNTRY	TTE_COUNTRY	CHAR	2	0	Country	*
5	TAX_REG	☐	TTET_TAX_REGION	TTE_TAX_REGION	CHAR	3	0	Region	*
6	TAXTYP	☐	TTET_TAX_TYP	TTE_TAX_TYP	CHAR	4	0	Tax Type	*
7	.INCLUDE	☐				0	0	General Reference for Condition Tables
8	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
9	OBJECT_ID	☐	/SAPCND/OBJECT_ID	SYSUUID	RAW	16	0	Higher-level object number for condition records
10	TIMESTAMP_TO	☐	/SAPCND/TIMESTAMP_TO	TIMESTAMP	CHAR	14	0	Timestamp for Validity End Date
11	RELEASE_STATUS	☐	/SAPCND/RELEASE_STATUS	/SAPCND/RELEASE_STATUS	CHAR	1	0	Release Status
12	TIMESTAMP_FROM	☐	/SAPCND/TIMESTAMP_FROM	TIMESTAMP	CHAR	14	0	Timestamp for Validity Start Date
13	KSCHL_SUPP	☐	/SAPCND/SUPP_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Supplementary Condition Type	*
14	COND_GROUP_ID	☐	/SAPCND/COND_GROUP_ID	SYSUUID	RAW	16	0	ID of Group of Condition Records
15	MAINT_STATUS	☐	/SAPCND/MAINT_STATUS	/SAPCND/MAINT_STATUS	CHAR	2	0	Editing status
16	.INCLUDE	☐				0	0	User Spec. Management Data (created, changed)
17	CREATED_BY	☐	/SAPCND/CREATED_BY	XUBNAME	CHAR	12	0	Name of User that Created the Condition Record	*
18	CREATED_ON	☐	/SAPCND/CREATED_ON	SYDATS	DATS	8	0	Date on which Condition Record was Created
19	.INCLUDE	☐				0	0	General Reference for Additional Information
20	KOPOS	☐	/SAPCND/SUPP_CONDITION_ID	/SAPCND/SUPP_CONDITION_ID	NUMC	3	0	Condition Supplement ID
21	SUPP_EXIST	☐	/SAPCND/SUPP_EXIST	XFELD	CHAR	1	0	Additional Data Indicator for Condition Record
22	SCALE_DIM	☐	/SAPCND/DIMENSION_ID	NUMC2	NUMC	2	0	Dimenstion number
23	.INCLUDE	☐				0	0	Include for Condition Tables (A000)
24	.INCLUDE	☐				0	0	Include for Condition Tables (A000): statistic part
25	KBETR	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
26	KPEIN	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
27	KMEIN	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
28	.INCLUDE	☐				0	0	Include for Condition Tables (A000): dynamic part
29	KONWA	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
30	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
31	LICENSE	☐	TTET_EXEMPT_LICENSE_ID	TTE_EXEMPT_LICENSE_ID	CHAR	20	0	Exemption License ID in TTE
32	AUTHORITYID	☐	TTET_AUTHORITYID	TTE_AUTHORITYID	CHAR	8	0	Tax Authority ID
33	REASONCODE	☐	TTET_EXEMPT_REASON	TTE_EXEMPT_REASON	CHAR	6	0	Exemption reason in TTE
34	TX_ISSUE_DATE	☐	TTET_ISSUEDATE_C	TTE_ISSUEDATE_C	CHAR	8	0	Exemption License Issuing Date in TTE
35	OWNERID	☐	TTET_PARTNERID_OWNER	TTE_PARTNER_ID	CHAR	32	0	Customer (Exemption Certificate)
36	FOLLOWON_LIC	☐	TTET_FOLLOWON_LICENSE	TTE_EXEMPT_LICENSE_ID	CHAR	20	0	Follow On Exemption License ID in TTE
37	TX_EXEMPT_QTY	☐	TTET_EXEMPT_QTY_C	TTE_EXEMPT_QTY_CHAR30	CHAR	30	0	Exempted Quantity in TTE
38	QTY_UNIT	☐	TTET_QUANTITY_UNIT	TTE_QUANTITY_UNIT	CHAR	3	0	Quantity Unit in TTE
39	TRANSPORT_MODE	☐	TTET_TRANSPORT_MODE	TTE_TRANSPORT_MODE	CHAR	2	0	Transportation mode in TTE
40	TX_CUMUL_AMT	☐	TTET_CUMULAT_AMT_C	TTE_CUMUL_AMT_CHAR30	CHAR	30	0	Cumulated Amount in TTE
41	TX_CUMUL_MAX_AMT	☐	TTET_CUMULAT_MAXAMT_C	TTE_CUMUL_MAXAMT_CHAR30	CHAR	30	0	Cumulated Maximum Amount in TTE
42	TX_CUMCURRUNIT	☐	TTET_CUMCURRUNIT	TTE_CUMCURRUNIT_CHAR	CHAR	3	0	Cumulation Currency Unit in TTE
43	TX_CUMUL_QTY	☐	TTET_CUMUL_QTY_C	TTE_CUMUL_QTY_CHAR30	CHAR	30	0	Cumulated Maximum Quantity in TTE
44	TX_CUMUL_MAX_QTY	☐	TTET_CUMUL_MAXQTY_C	TTE_CUMUL_MAXQTY_CHAR30	CHAR	30	0	Cumulated Maximum Quantity in TTE
45	TX_TOPUP_AMT	☐	TTET_TOPUP_AMOUNT_C	TTE_TOPUP_AMOUNT_CHAR30	CHAR	30	0	Topup Amount in TTE (character string 30)
46	TX_TOPUP_QTY	☐	TTET_TOPUP_QTY_C	TTE_TOPUP_QTY_CHAR30	CHAR	30	0	Topup quantity in TTE (character string 30)
47	EXEMPTID	☐	TTET_EXEMPT_ID	TTE_EXEMPT_ID	CHAR	32	0	Exemption ID in TTE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CNCTTEPRSAPE1001	VARNUMH	/SAPCND/CONDINDX	VARNUMH

History

Last changed by/on	SAP	20130604
SAP Release Created in