SAP ABAP Table /1CN/WS_ID_000PROD_PROV (Internal working set structure)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/1CN/WS_ID_000PROD_PROV	Table Relationship Diagram
Short Description	Internal 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	/SAPCND/MNT_IS_ARCHIVED	☐	/SAPCND/MNT_IS_ARCHIVED	XFELD	CHAR	1	0	Is the Condition Record Only in Archive?
2	/SAPCND/SCPB__LIN	☐	CNLCRMPRSCB__LIN_S_T		TTYP	0	0
3	/SAPCND/SCPC__LIN	☐	CNLCRMPRSCC__LIN_S_T		TTYP	0	0
4	/SAPCND/SCPDEF	☐	CNLCRMPRSCALEDEF_S_T		TTYP	0	0
5	/SAPCND/SCPDIM	☐	CNLCRMPRSCALEDIM_S_T		TTYP	0	0
6	/SAPCND/SCPD__LIN	☐	CNLCRMPRSCD__LIN_S_T		TTYP	0	0
7	/SAPCND/SCPEVL	☐	CNLCRMPRSCALEEVL_S_T		TTYP	0	0
8	/SAPCND/SCPE__LIN	☐	CNLCRMPRSCE__LIN_S_T		TTYP	0	0
9	/SAPCND/SCPF__LIN	☐	CNLCRMPRSCF__LIN_S_T		TTYP	0	0
10	/SAPCND/SCPL__LIN	☐	CNLCRMPRSCL__LIN_S_T		TTYP	0	0
11	/SAPCND/SCPM__LIN	☐	CNLCRMPRSCM__LIN_S_T		TTYP	0	0
12	/SAPCND/SCPN__LIN	☐	CNLCRMPRSCN__LIN_S_T		TTYP	0	0
13	/SAPCND/SCPO__LIN	☐	CNLCRMPRSCO__LIN_S_T		TTYP	0	0
14	/SAPCND/SCPP__LIN	☐	CNLCRMPRSCP__LIN_S_T		TTYP	0	0
15	/SAPCND/SCPR__LIN	☐	CNLCRMPRSCR__LIN_S_T		TTYP	0	0
16	/SAPCND/SCPS__LIN	☐	CNLCRMPRSCS__LIN_S_T		TTYP	0	0
17	/SAPCND/SCPTC1LIN	☐	CNLCRMPRSCTC1LIN_S_T		TTYP	0	0
18	/SAPCND/SCPV01	☐	CNLCRMPRSCALEV01_S_T		TTYP	0	0
19	/SAPCND/SCPV02	☐	CNLCRMPRSCALEV02_S_T		TTYP	0	0
20	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
21	CAMPAIGN_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
22	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
23	COND_GROUP_ID	☐	/SAPCND/COND_GROUP_ID	SYSUUID	RAW	16	0	ID of Group of Condition Records
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	DBACTION_SUPP	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
27	DBACTION_TABL	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
28	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
29	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
30	EXPNT	☐	PRCT_CONV_COND_EXP	EXP10	INT2	5	0	Base 10 Exponent for Conversion to the Base Unit of Measure
31	GKWRT	☐	PRCT_UPPER_LIMIT_COND_RATE	WERTV8	CURR	15	2	Upper Limit for Condition Rate
32	KAPPL	☐	/SAPCND/APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	Application as Condition Technique	/SAPCND/T681A
33	KBETR	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
34	KMEIN	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
35	KOMXWRT	☐	MAXCONVAL	WERTV8	CURR	15	2	Maximum condition value
36	KONMS	☐	PRCT_COND_SCALE_UOM	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
37	KONWA	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
38	KONWS	☐	PRCT_COND_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
39	KOPOS	☐	/SAPCND/SUPP_CONDITION_ID	/SAPCND/SUPP_CONDITION_ID	NUMC	3	0	Condition Supplement ID
40	KOTABNR	☐	/SAPCND/COND_TABLE_ID	/SAPCND/COND_TABLE_ID	CHAR	8	0	Condition Table	*
41	KPEIN	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
42	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
43	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
44	KSCHL_SUPP	☐	/SAPCND/SUPP_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Supplementary Condition Type	*
45	KSTBM	☐	PRCT_COND_SCALE_LEVEL	PRC_QUANTITY	DEC	18	5	Scale Limit
46	KUMNE	☐	PRCT_DENOMINATOR	INT4	INT4	10	0	Denominator for Conversion to Base Unit of Measure
47	KUMZA	☐	PRCT_NUMERATOR	INT4	INT4	10	0	Counter for Conversion to Base Unit of Measure
48	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
49	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
50	KZBZG	☐	/SAPCND/SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Scale Base Type	*
51	KZNEP	☐	PRCT_EXCL_INDICATOR	PRC_EXCL_INDICATOR	CHAR	1	0	Exclusion Indicator in Condition Record (KZNEP)
52	MAINT_STATUS	☐	/SAPCND/MAINT_STATUS	/SAPCND/MAINT_STATUS	CHAR	2	0	Editing status
53	MEINS	☐	PRCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure for a Product	*
54	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
55	MNT_OW_ERROR_BY_COND_REC	☐	/SAPCND/MNT_ERROR_BY_COND_REC	XFELD	CHAR	1	0	Record Contains Errors Due to Own Field Values
56	MNT_OW_ERROR_BY_RELATION	☐	/SAPCND/MNT_ERROR_BY_RELATION	XFELD	CHAR	1	0	Condition Record:Contains Errors w.Reference to Other Record
57	MNT_OW_EXISTS_AT_DB	☐	/SAPCND/MNT_EXISTS_AT_DB	XFELD	CHAR	1	0	Specifies whether a condition record exists in the DB
58	MNT_OW_MAINT_MODE_ON_SELECT	☐	/SAPCND/MAINT_MODE	/SAPCND/MAINT_MODUS	CHAR	1	0	Maintain Mode
59	MNT_OW_RESULT	☐	/SAPCND/MNT_RESULT	SYST_SHORT	INT4	10	0	Return Value in Condition Maintenance
60	MWSK1	☐	PRCT_SALES_TAX_CODE	PRC_SALES_TAX_CODE	CHAR	2	0	Sales Tax Code
61	MWSK2	☐	PRCT_WITHHOLDING_TAX	PRC_WITHHOLDING_TAX	CHAR	2	0	Withholding Tax Code
62	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value
63	MXWRT	☐	PRCT_LOWER_LIMIT_COND_RATE	WERTV8	CURR	15	2	Lower Limit of the Condition Rate
64	OBJECT_ID	☐	/SAPCND/OBJECT_ID	SYSUUID	RAW	16	0	Higher-level object number for condition records
65	PARENT_PRC_PROD	☐	CRMT_PARENT_PRC_PROD	SYSUUID	RAW	16	0	Price Product Guid for Higher-Level Item
66	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
67	PROV_DURATION	☐	CRMT_PROV_DURATION	CRM_PROV_DURATION	NUMC	13	0	Numerical Value of Duration
68	PROV_DURAT_UNIT	☐	CRMT_PROV_DURATION_UNIT	TIMEUNITNA	CHAR	12	0	IS-T: Unit of Duration for a Telco Contract	*
69	PROV_LOCK_REASON	☐	IST_LOCK_REASON	IST_LOCK_REASON	CHAR	8	0	Lock Reason	CRMC_IST_REASN
70	PTERM	☐	PRCT_TERMS_OF_PAYMENT	PRC_TERMS_OF_PAYMENT	CHAR	4	0	Terms of Payment Key
71	RELEASE_STATUS	☐	/SAPCND/RELEASE_STATUS	/SAPCND/RELEASE_STATUS	CHAR	1	0	Release Status
72	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
73	SCALE_DIM	☐	/SAPCND/DIMENSION_ID	NUMC2	NUMC	2	0	Dimenstion number
74	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
75	STFKZ	☐	/SAPCND/SCALE_TYPE	/SAPCND/SCALE_TYPE	CHAR	1	0	Scale Type
76	SUPP_EXIST	☐	/SAPCND/SUPP_EXIST	XFELD	CHAR	1	0	Additional Data Indicator for Condition Record
77	TIMESTAMP_FROM	☐	/SAPCND/TIMESTAMP_FROM	TIMESTAMP	CHAR	14	0	Timestamp for Validity Start Date
78	TIMESTAMP_TO	☐	/SAPCND/TIMESTAMP_TO	TIMESTAMP	CHAR	14	0	Timestamp for Validity End Date
79	VALDT	☐	PRCT_VALUE_DATE	PRC_VALUE_DATE	DATS	8	0	Value date
80	VALTG	☐	PRCT_VALUE_DAYS	PRC_VALUE_DAYS	NUMC	2	0	No. of Value Days
81	VARCOND	☐	COMT_VARIANT_KEY	COMT_VARIANT_KEY	CHAR	26	0	Variant Condition Name
82	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_ID_000PROD_PROV	CLIENT	T000	MANDT
2	/1CN/WS_ID_000PROD_PROV	PROV_LOCK_REASON	CRMC_IST_REASN	LOCK_REASON

History

Last changed by/on	SAP	20130604
SAP Release Created in