SAP ABAP Table CMBSCPSAP40200 (CDB Table to Online Table CNSCRMPRSAP40200)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMBSCPSAP40200	Table Relationship Diagram
Short Description	CDB Table to Online Table CNSCRMPRSAP40200

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	CDB_KEY_GUID	☑	CDBT_CND_GUID	CDB_CND_GUID	CHAR	32	0	GUID for condition technique and Price determination(CDB)
3	VARNUMH	☐	CDBT_CHAR_GUID	SYSUUID_C	CHAR	32	0	Data Element GUID CHAR32 für CDB	CMBCCPSAP40200
4	STFKZ	☐	/SAPCND/SCALE_TYPE	/SAPCND/SCALE_TYPE	CHAR	1	0	Scale Type
5	KZBZG	☐	/SAPCND/SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Scale Base Type	*
6	KUMZA	☐	PRCT_NUMERATOR	INT4	INT4	10	0	Counter for Conversion to Base Unit of Measure
7	KUMNE	☐	PRCT_DENOMINATOR	INT4	INT4	10	0	Denominator for Conversion to Base Unit of Measure
8	EXPNT	☐	PRCT_CONV_COND_EXP	EXP10	INT2	5	0	Base 10 Exponent for Conversion to the Base Unit of Measure
9	MWSK1	☐	PRCT_SALES_TAX_CODE	PRC_SALES_TAX_CODE	CHAR	2	0	Sales Tax Code
10	MWSK2	☐	PRCT_WITHHOLDING_TAX	PRC_WITHHOLDING_TAX	CHAR	2	0	Withholding Tax Code
11	KONMS	☐	PRCT_COND_SCALE_UOM	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
12	KONWS	☐	PRCT_COND_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
13	KSTBM	☐	PRCT_COND_SCALE_LEVEL	PRC_QUANTITY	DEC	18	5	Scale Limit
14	MEINS	☐	PRCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure for a Product	*
15	KZNEP	☐	PRCT_EXCL_INDICATOR	PRC_EXCL_INDICATOR	CHAR	1	0	Exclusion Indicator in Condition Record (KZNEP)
16	MXWRT	☐	CND_MAST_LOWER_LIMIT_CDB	CND_MAST_CURR_CDB	CURR	28	9	Unteres Limit des Konditionsbetrags
17	GKWRT	☐	CND_MAST_UPPER_LIMIT_CDB	CND_MAST_CURR_CDB	CURR	28	9	Oberes Limit des Konditionsbetrags
18	PTERM	☐	PRCT_TERMS_OF_PAYMENT	PRC_TERMS_OF_PAYMENT	CHAR	4	0	Terms of Payment Key
19	VALDT	☐	PRCT_VALUE_DATE	PRC_VALUE_DATE	DATS	8	0	Value date
20	VALTG	☐	PRCT_VALUE_DAYS	PRC_VALUE_DAYS	NUMC	2	0	No. of Value Days
21	KOMXWRT	☐	CND_MAST_MAX_VALUE_CDB	CND_MAST_CURR_CDB	CURR	28	9	Maximum Value Condition Update
22	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
23	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
24	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
25	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMBSCPSAP40200	VARNUMH	CMBCCPSAP40200	VARNUMH

History

Last changed by/on	SAP	20080731
SAP Release Created in