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

Hierarchy

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

Basic Data

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

History

Last changed by/on	SAP	20130604
SAP Release Created in