SAP ABAP Table /1CN/WS_ED_0001200 (External working set structure)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/1CN/WS_ED_0001200	Table Relationship Diagram
Short Description	External working set structure

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	/BON/AG_NUMBER_TEMP	☐	REB_AG_NUM_TEMP	CHAR10	CHAR	10	0	Temporary Agreement Number in Change Mode
2	/BON/BOSTA	☐	REB_COND_REC_STATUS	/BON/CR_STATUS	CHAR	1	0	Rebate Status for Condition Record
3	/BON/KBRUE_PRT	☐	REB_ACCRUAL_RATE_EXT	REB_RATE_EXT	CHAR	21	0	External Display of Accrual Rate
4	/BON/KNUMA_BO	☐	REB_AG_GUID	SYSUUID	RAW	16	0	Agreement GUID
5	/BON/KNUMA_BO_PRT	☐	REB_AG_NUMBER	/BON/AG_NUMBER	CHAR	10	0	Agreement Number for External Display
6	/BON/KONMS	☐	REB_SCALE_UNIT	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
7	/BON/KONWS	☐	REB_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
8	/BON/KWAEH	☐	REB_AG_CURR	WAERS	CUKY	5	0	Cumulation Currency (Agreement Currency)	*
9	/BON/KZBZG	☐	REB_SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Indicator: Scale Base Type	*
10	/BON/LOGSYS	☐	REB_LOGSYS	LOGSYS	CHAR	10	0	System in Which the Agreement Was Created	*
11	/BON/ORIGIN	☐	REB_REC_ORIGIN	/BON/ORIGIN	CHAR	2	0	Origin of Condition Record (Generated)
12	/BON/PRODUCT_ID	☐	REB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Rebate Product Identifier
13	/BON/PRODUCT_OBJECT_FAMILY	☐	REB_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Rebate Product Object Family	*
14	/BON/PRODUCT_TYPE	☐	REB_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type (Rebate)	*
15	/BON/RUEWA	☐	REB_ACCURAL_CURR	WAERS	CUKY	5	0	Currency Unit for Accruals	*
16	/SAPCND/ACB	☐	/1CN/TSCALE_SET_EXT_CB_T		TTYP	0	0
17	/SAPCND/ACF	☐	/1CN/TSCALE_SET_EXT_CF_T		TTYP	0	0
18	/SAPCND/ACP	☐	/1CN/TSCALE_SET_EXT_CP_T		TTYP	0	0
19	/SAPCND/BCB	☐	/1CN/TSCALE_DATA_EXT_CB_T		TTYP	0	0
20	/SAPCND/BCF	☐	/1CN/TSCALE_DATA_EXT_CF_T		TTYP	0	0
21	/SAPCND/BCP	☐	/1CN/TSCALE_DATA_EXT_CP_T		TTYP	0	0
22	/SAPCND/LIN_ID_01	☐	/SAPCND/SCALE_LINE_ID	NUMC4	NUMC	4	0	Consecutive Number of Scale Base
23	/SAPCND/LIN_ID_02	☐	/SAPCND/SCALE_LINE_ID	NUMC4	NUMC	4	0	Consecutive Number of Scale Base
24	/SAPCND/LIN_VALUE_01_001	☐	/SAPCND/GENERAL_SCALE_LINE	/SAPCND/GENERAL_SCALE_LINE	CHAR	20	0	General Input Type for Scale Levels
25	/SAPCND/LIN_VALUE_01_002	☐	/SAPCND/GENERAL_SCALE_LINE	/SAPCND/GENERAL_SCALE_LINE	CHAR	20	0	General Input Type for Scale Levels
26	/SAPCND/LIN_VALUE_02_001	☐	/SAPCND/GENERAL_SCALE_LINE	/SAPCND/GENERAL_SCALE_LINE	CHAR	20	0	General Input Type for Scale Levels
27	/SAPCND/LIN_VALUE_02_002	☐	/SAPCND/GENERAL_SCALE_LINE	/SAPCND/GENERAL_SCALE_LINE	CHAR	20	0	General Input Type for Scale Levels
28	/SAPCND/MNT_IS_ARCHIVED	☐	/SAPCND/MNT_IS_ARCHIVED	XFELD	CHAR	1	0	Is the Condition Record Only in Archive?
29	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
30	CAMPAIGN_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
31	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
32	CND_ALV_CELLTAB	☐	LVC_T_STYL		TTYP	0	0
33	COND_GROUP_ID	☐	/SAPCND/COND_GROUP_ID	SYSUUID	RAW	16	0	ID of Group of Condition Records
34	CREATED_BY	☐	/SAPCND/CREATED_BY	XUBNAME	CHAR	12	0	Name of User that Created the Condition Record	*
35	CREATED_ON	☐	/SAPCND/CREATED_ON	SYDATS	DATS	8	0	Date on which Condition Record was Created
36	DATE_FROM	☐	/SAPCND/DATE_FROM	SYDATS	DATS	8	0	Valid From Date
37	DATE_TO	☐	/SAPCND/DATE_TO	SYDATS	DATS	8	0	Valid-to Date
38	DBACTION_SUPP	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
39	DBACTION_TABL	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
40	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
41	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
42	EXPNT	☐	PRCT_CONV_COND_EXP	EXP10	INT2	5	0	Base 10 Exponent for Conversion to the Base Unit of Measure
43	FGD_ADD_PRODUCT_ID	☐	FGD_ADD_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Free Goods Additional Product ID
44	FGD_ADD_PRODUCT_LOGSYS	☐	FGD_ADD_PRODUCT_LOGSYS	LOGSYS	CHAR	10	0	System in Which the Free Goods Add. Product Was Created	*
45	FGD_ADD_PRODUCT_OBJECT_FAMILY	☐	FGD_ADD_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family for FGD	*
46	FGD_ADD_PRODUCT_TYPE	☐	FGD_ADD_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Free Goods Additional Product Type	*
47	FGD_ADD_QNTY	☐	FGD_ADD_QNT	FGD_QNT	QUAN	18	5	Additional Quantity to be given as free goods.
48	FGD_ADD_QNT_UNIT	☐	FGD_ADD_QNTY_UNIT	FGD_UNIT	UNIT	3	0	Unit for additional free goods quantity	*
49	FGD_CAL_TYPE	☐	FGD_CAL_TYPE	FGD_CAL_TYPE	NUMC	3	0	Calculation Type for Free Goods
50	FGD_EXCLINCL_IND	☐	FGD_EXCL_INCL_IND	FGD_EXCL_INC_IND	CHAR	1	0	Free Goods Exclusive Inclusive Indicator
51	FGD_LSTANR	☐	FGD_LSTANR	FGD_LSTANR	CHAR	1	0	Free Goods Delivery Control
52	FGD_MIN_QNTY	☐	FGD_MIN_QNT	FGD_QNT	QUAN	18	5	Minimum quantity free goods
53	FGD_QNTY	☐	FGD_QNT	FGD_QNT	QUAN	18	5	Free Goods Quantity
54	FGD_QNTY_UNIT	☐	FGD_QNTY_UNIT	FGD_UNIT	UNIT	3	0	Unit for free goods quantity	*
55	GKWRT_PRT	☐	PRCT_UPPER_LIMIT_MNT_RATE	PRC_MNT_RATE	CHAR	21	0	Cond maintenance: Upper Limit of the Cond. Rate
56	HIER_CAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
57	HIER_NODE_SEARCH_TERM	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
58	HIER_NO_ID	☐	BU_HIERNR_ID	BU_PARTNER	CHAR	10	0	Business Partners as Hierarchy Nodes ( Conditions )	*
59	HIER_TREE_SEARCH_TERM	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
60	KAPPL	☐	/SAPCND/APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	Application as Condition Technique	/SAPCND/T681A
61	KBETR_PRT	☐	PRCT_MNT_RATE	PRC_MNT_RATE	CHAR	21	0	Condition maintenance: Condition amount
62	KMEIN	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
63	KOMXWRT	☐	MAXCONVAL	WERTV8	CURR	15	2	Maximum condition value
64	KONMS	☐	PRCT_COND_SCALE_UOM	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
65	KONWA	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
66	KONWS	☐	PRCT_COND_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
67	KOPOS	☐	/SAPCND/SUPP_CONDITION_ID	/SAPCND/SUPP_CONDITION_ID	NUMC	3	0	Condition Supplement ID
68	KOTABNR	☐	/SAPCND/COND_TABLE_ID	/SAPCND/COND_TABLE_ID	CHAR	8	0	Condition Table	*
69	KPEIN	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
70	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
71	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
72	KSCHL_SUPP	☐	/SAPCND/SUPP_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Supplementary Condition Type	*
73	KSTBM	☐	PRCT_COND_SCALE_LEVEL	PRC_QUANTITY	DEC	18	5	Scale Limit
74	KUMNE	☐	PRCT_DENOMINATOR	INT4	INT4	10	0	Denominator for Conversion to Base Unit of Measure
75	KUMZA	☐	PRCT_NUMERATOR	INT4	INT4	10	0	Counter for Conversion to Base Unit of Measure
76	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
77	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
78	KZBZG	☐	/SAPCND/SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Scale Base Type	*
79	KZNEP	☐	PRCT_EXCL_INDICATOR	PRC_EXCL_INDICATOR	CHAR	1	0	Exclusion Indicator in Condition Record (KZNEP)
80	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
81	MAINT_STATUS	☐	/SAPCND/MAINT_STATUS	/SAPCND/MAINT_STATUS	CHAR	2	0	Editing status
82	MEINS	☐	PRCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure for a Product	*
83	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
84	MNT_IL_LINE_FCAT	☐	/SAPCND/MNT_WAC_ROW_FCAT_T		TTYP	0	0
85	MNT_OW_ERROR_BY_COND_REC	☐	/SAPCND/MNT_ERROR_BY_COND_REC	XFELD	CHAR	1	0	Record Contains Errors Due to Own Field Values
86	MNT_OW_ERROR_BY_RELATION	☐	/SAPCND/MNT_ERROR_BY_RELATION	XFELD	CHAR	1	0	Condition Record:Contains Errors w.Reference to Other Record
87	MNT_OW_EXISTS_AT_DB	☐	/SAPCND/MNT_EXISTS_AT_DB	XFELD	CHAR	1	0	Specifies whether a condition record exists in the DB
88	MNT_OW_MAINT_MODE_ON_SELECT	☐	/SAPCND/MAINT_MODE	/SAPCND/MAINT_MODUS	CHAR	1	0	Maintain Mode
89	MNT_UI_COLOR_LINE	☐	LVC_EMPHSZ	CHAR4	CHAR	4	0	ALV control: Highlight column with color
90	MNT_UI_COND_REC_STATUS	☐	/SAPCND/MNT_COND_REC_STATUS	/SAPCND/MNT_COND_REC_STATUS	CHAR	64	0	Status of Condition Record
91	MNT_UI_IS_COND_TYPE_LINE	☐	/SAPCND/BOOLEAN	XFELD	CHAR	1	0	Boolean Variable
92	MNT_UI_IS_DELETED_ICON	☐	/SAPCND/MNT_IS_DELETED_ICON	/SAPCND/MNT_IS_DELETED_ICON	CHAR	4	0	Deleted: Condition Record Icon
93	MNT_UI_IS_INITIAL_LINE	☐	/SAPCND/BOOLEAN	XFELD	CHAR	1	0	Boolean Variable
94	MNT_UI_SCALE_EXIST	☐	/SAPCND/MNT_UI_SCALE_EXIST	/SAPCND/MNT_UI_SCALE_EXIST	CHAR	4	0	Icon Field that Shows Existence of Scales
95	MWSK1	☐	PRCT_SALES_TAX_CODE	PRC_SALES_TAX_CODE	CHAR	2	0	Sales Tax Code
96	MWSK2	☐	PRCT_WITHHOLDING_TAX	PRC_WITHHOLDING_TAX	CHAR	2	0	Withholding Tax Code
97	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value
98	MXWRT_PRT	☐	PRCT_LOWER_LIMIT_MNT_RATE	PRC_MNT_RATE	CHAR	21	0	Cond maint: Lower Limit of the Cond. Rate
99	OBJECT_ID	☐	/SAPCND/OBJECT_ID	SYSUUID	RAW	16	0	Higher-level object number for condition records
100	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
101	PRODH1	☐	CRMT_PRODH1	CRM_PRODH1	CHAR	5	0	Standard Data Element PRODH1
102	PRODH2	☐	CRMT_PRODH2	CRM_PRODH2	CHAR	5	0	Standard Data Element PRODH2
103	PRODH3	☐	CRMT_PRODH3	CRM_PRODH3	CHAR	8	0	Standard Data Element PRODH3
104	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
105	PRODUCT_OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
106	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
107	PROD_HIER_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
108	PROD_SEG_DESCR	☐	CRMT_MKTTG_PRSEG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	Product Segment Description
109	PROD_SEG_GUID	☐	CRMT_MKTTG_PRSEG_GUID	SYSUUID	RAW	16	0	GUID of a Product Segment
110	PTERM	☐	PRCT_TERMS_OF_PAYMENT	PRC_TERMS_OF_PAYMENT	CHAR	4	0	Terms of Payment Key
111	REB_BONUS_RATE_CURR	☐	REB_BONUS_RATE_CURR	WAERS	CUKY	5	0	Currency Unit for Direct Rebate	*
112	REB_BONUS_RATE_EXT	☐	REB_BONUS_RATE_EXT	REB_RATE_EXT	CHAR	21	0	Condition Maintenance: Direct Rebate Amount
113	REB_CUMUL_CALDR	☐	REB_CUMUL_CALDR	WFCID	CHAR	2	0	Cumulation Calendar	*
114	REB_CUMUL_TYPE	☐	REB_CUMUL_TYPE	REB_CUMUL_TYPE	CHAR	1	0	Cumulation Type
115	REB_FOC_ADD_QTY	☐	REB_FOC_ADD_QNTY	MENGV15_3	QUAN	15	3	Quantity of Free Product
116	REB_FOC_ADD_QTYU	☐	REB_FOC_ADD_QNTY_UNIT	MEINS	UNIT	3	0	Unit for Free Product	*
117	REB_FOC_CAL_TYPE	☐	REB_FOC_CAL_TYPE	REB_FOC_CAL_TYPE	NUMC	3	0	Calculation Rule for Free-Goods Rebate
118	REB_FOC_CURR	☐	REB_FOC_CURR	WAERS	CUKY	5	0	Currency for Free-Goods Rebate	*
119	REB_FOC_VALUE	☐	REB_FOC_VALUE	WERTV8	CURR	15	2	Value for Free-Goods Rebate
120	REB_KNUMA_BO_ITEM_PRT	☐	REB_AG_ITEM_NUMBER	REB_AG_ITEM_NUMBER	CHAR	10	0	Agreement Item Number for External Display
121	REB_PAYMENT_RULE	☐	REB_PAYMENT_RULE	BEA_TRANSM_RULE	CHAR	10	0	Rebate Due List Assembly Rule	*
122	REB_PROC_CNTRL	☐	REB_PROC_CNTRL	REB_PROC_CNTRL	CHAR	1	0	Processing Control
123	REB_PROC_CNTRL_EXT	☐	REB_PROC_CNTRL_EXT	REB_PROC_CNTRL_EXT	CHAR	30	0	Rebate Program Type
124	REB_RECIPIENT_EXT	☐	REB_RECIPIENT_EXT	BU_PARTNER	CHAR	10	0	Rebate Recipient	*
125	REB_RETROACTIVE	☐	REB_RETROACTIVE	REB_RETROACTIVE	CHAR	1	0	Retroactively Created / Changed Condition Record
126	REB_SCALE2_BASE	☐	REB_SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Indicator: Scale Base Type	*
127	REB_SCALE2_CURR	☐	REB_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
128	REB_SCALE2_GROUP	☐	REB_SCALE_GROUP	CHAR10	CHAR	10	0	Grouping Field for Cross-System Scales
129	REB_SCALE2_RULE	☐	REB_SCALE_RULE	REB_SCALE_RULE	CHAR	10	0	Scale Rule ID
130	REB_SCALE2_UNIT	☐	REB_SCALE_UNIT	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
131	REB_SCALE_GROUP	☐	REB_SCALE_GROUP	CHAR10	CHAR	10	0	Grouping Field for Cross-System Scales
132	REB_SCALE_RULE	☐	REB_SCALE_RULE	REB_SCALE_RULE	CHAR	10	0	Scale Rule ID
133	RELEASE_STATUS	☐	/SAPCND/RELEASE_STATUS	/SAPCND/RELEASE_STATUS	CHAR	1	0	Release Status
134	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
135	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
136	SCALE_DIM	☐	/SAPCND/DIMENSION_ID	NUMC2	NUMC	2	0	Dimenstion number
137	SOLD_TO_PARTY_ID	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
138	STFKZ	☐	/SAPCND/SCALE_TYPE	/SAPCND/SCALE_TYPE	CHAR	1	0	Scale Type
139	SUPP_EXIST	☐	/SAPCND/SUPP_EXIST	XFELD	CHAR	1	0	Additional Data Indicator for Condition Record
140	TG_BP_DESCR	☐	CRM_MKTPL_TARGETGRP_DESC	CRM_MARKETING_DESC	CHAR	72	0	Description of Target Group
141	TG_BP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
142	TIME_FROM	☐	/SAPCND/TIME_FROM	SYTIME	TIMS	6	0	Valid From Time
143	TIME_TO	☐	/SAPCND/TIME_TO	SYTIME	TIMS	6	0	Valid until
144	TIME_ZONE	☐	/SAPCND/TIME_ZONE	TZNZONE	CHAR	6	0	Date and Time, Time Difference from Greenwich Mean Time	*
145	VALDT	☐	PRCT_VALUE_DATE	PRC_VALUE_DATE	DATS	8	0	Value date
146	VALTG	☐	PRCT_VALUE_DAYS	PRC_VALUE_DAYS	NUMC	2	0	No. of Value Days
147	VARNUMH	☐	/SAPCND/COND_TABLE_ENTRY_ID	SYSUUID	RAW	16	0	Condition Record ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/1CN/WS_ED_0001200	CLIENT	T000	MANDT

History

Last changed by/on	SAP	20130604
SAP Release Created in