SAP ABAP Table /1CN/CCCSAPI3TUS (Condition Table)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/1CN/CCCSAPI3TUS	Table Relationship Diagram
Short Description	Condition Table

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	CPE_CONDTYPE_PR	☐	CPET_CONDTYPE_PR	KSCHL	CHAR	4	0	CPE: Condition Type of Pricing	*
5	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
6	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
7	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
8	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
9	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
10	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY	SYSUUID	RAW	16	0	Ship-to Party GUID
11	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
12	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
13	CPE_T_TERMNO	☐	CPET_TERMNO	NUMC5	NUMC	5	0	CPE Term - Number in Formula
14	.INCLUDE	☐				0	0	General Reference for Condition Tables
15	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
16	OBJECT_ID	☐	/SAPCND/OBJECT_ID	SYSUUID	RAW	16	0	Higher-level object number for condition records
17	TIMESTAMP_TO	☐	/SAPCND/TIMESTAMP_TO	TIMESTAMP	CHAR	14	0	Timestamp for Validity End Date
18	RELEASE_STATUS	☐	/SAPCND/RELEASE_STATUS	/SAPCND/RELEASE_STATUS	CHAR	1	0	Release Status
19	TIMESTAMP_FROM	☐	/SAPCND/TIMESTAMP_FROM	TIMESTAMP	CHAR	14	0	Timestamp for Validity Start Date
20	KSCHL_SUPP	☐	/SAPCND/SUPP_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Supplementary Condition Type	*
21	COND_GROUP_ID	☐	/SAPCND/COND_GROUP_ID	SYSUUID	RAW	16	0	ID of Group of Condition Records
22	MAINT_STATUS	☐	/SAPCND/MAINT_STATUS	/SAPCND/MAINT_STATUS	CHAR	2	0	Editing status
23	.INCLUDE	☐				0	0	User Spec. Management Data (created, changed)
24	CREATED_BY	☐	/SAPCND/CREATED_BY	XUBNAME	CHAR	12	0	Name of User that Created the Condition Record	*
25	CREATED_ON	☐	/SAPCND/CREATED_ON	SYDATS	DATS	8	0	Date on which Condition Record was Created
26	.INCLUDE	☐				0	0	General Reference for Additional Information
27	KOPOS	☐	/SAPCND/SUPP_CONDITION_ID	/SAPCND/SUPP_CONDITION_ID	NUMC	3	0	Condition Supplement ID
28	SUPP_EXIST	☐	/SAPCND/SUPP_EXIST	XFELD	CHAR	1	0	Additional Data Indicator for Condition Record
29	SCALE_DIM	☐	/SAPCND/DIMENSION_ID	NUMC2	NUMC	2	0	Dimenstion number
30	CPE_R_RATETYPE	☐	CPET_RATETYPE	CPE_RATETYPE	CHAR	1	0	CPE: Rate Type for Formula Assembly
31	CPE_R_RATE	☐	CPET_FORMRATE	CPE_AMOUNT	CURR	15	2	CPE Formula - Rate in Formula Currency
32	CPE_R_CURRENCY	☐	CPET_FORMCURR	WAERS	CUKY	5	0	CPE Formula - Currency	*
33	CPE_R_PRICEUNIT	☐	CPET_FORMPRUN	CPE_PRUN	DEC	5	0	CPE Formula - Price Unit
34	CPE_R_UOM	☐	CPET_FORMUOM	MEINS	UNIT	3	0	CPE Formula - Unit of Measure	*
35	CPE_T_USERVAL1	☐	CPET_USERVAL1	CPE_USERVAL1	DEC	17	7	CPE Term - Freely Usable Field
36	CPE_T_USERUOM1	☐	CPET_USERUOM1	MEINS	UNIT	3	0	CPE Term - Freely Usable Unit of Measure Field	*

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in