SAP ABAP Table CNCTTEPRSAPE0014 (Country/Tax Type/Supplier Partner ID/Business Partner ID/Par)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CNCTTEPRSAPE0014	Table Relationship Diagram
Short Description	Country/Tax Type/Supplier Partner ID/Business Partner ID/Par

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

History

Last changed by/on	SAP	20130604
SAP Release Created in