SAP ABAP View CNACRMPRSAP20103 (Access View for a Condition Table)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	CNACRMPRSAP20103
Short Description	Access View for a Condition Table
Root table	CNCCRMPRSAP20103	Sales Org./Dis. Chan./Prod. GUID/Exp. Code

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CNCCRMPRSAP20103	CNCCRMPRSAP20103

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CNCCRMPRSAP20103	CLIENT		☐	MANDT	☐	Client
2	SALES_ORG	CNCCRMPRSAP20103	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
3	DIS_CHANNEL	CNCCRMPRSAP20103	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
4	PRODUCT	CNCCRMPRSAP20103	PRODUCT		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
5	EFFORT_CODE	CNCCRMPRSAP20103	EFFORT_CODE		☐	CRMT_EFFORT_CODE	☐	Concatenated string of effort 'catalog codegroup code'
6	KSCHL	CNCCRMPRSAP20103	KSCHL		☐	/SAPCND/COND_TYPE	☐	Condition Type
7	OBJECT_ID	CNCCRMPRSAP20103	OBJECT_ID		☐	/SAPCND/OBJECT_ID	☐	Higher-level object number for condition records
8	TIMESTAMP_TO	CNCCRMPRSAP20103	TIMESTAMP_TO		☐	/SAPCND/TIMESTAMP_TO	☐	Timestamp for Validity End Date
9	RELEASE_STATUS	CNCCRMPRSAP20103	RELEASE_STATUS		☐	/SAPCND/RELEASE_STATUS	☐	Release Status
10	KOPOS	CNCCRMPRSAP20103	KOPOS		☐	/SAPCND/SUPP_CONDITION_ID	☐	Condition Supplement ID
11	CREATED_ON	CNCCRMPRSAP20103	CREATED_ON		☐	/SAPCND/CREATED_ON	☐	Date on which Condition Record was Created
12	VARNUMH	CNCCRMPRSAP20103	VARNUMH		☐	/SAPCND/COND_TABLE_ENTRY_ID	☐	Condition Record ID
13	TIMESTAMP_FROM	CNCCRMPRSAP20103	TIMESTAMP_FROM		☐	/SAPCND/TIMESTAMP_FROM	☐	Timestamp for Validity Start Date
14	KSCHL_SUPP	CNCCRMPRSAP20103	KSCHL_SUPP		☐	/SAPCND/SUPP_COND_TYPE	☐	Supplementary Condition Type
15	COND_GROUP_ID	CNCCRMPRSAP20103	COND_GROUP_ID		☐	/SAPCND/COND_GROUP_ID	☐	ID of Group of Condition Records
16	MAINT_STATUS	CNCCRMPRSAP20103	MAINT_STATUS		☐	/SAPCND/MAINT_STATUS	☐	Editing status
17	CREATED_BY	CNCCRMPRSAP20103	CREATED_BY		☐	/SAPCND/CREATED_BY	☐	Name of User that Created the Condition Record
18	SUPP_EXIST	CNCCRMPRSAP20103	SUPP_EXIST		☐	/SAPCND/SUPP_EXIST	☐	Additional Data Indicator for Condition Record
19	SCALE_DIM	CNCCRMPRSAP20103	SCALE_DIM		☐	/SAPCND/DIMENSION_ID	☐	Dimenstion number
20	KBETR	CNCCRMPRSAP20103	KBETR		☐	PRCT_COND_RATE	☐	Condition Rate
21	KPEIN	CNCCRMPRSAP20103	KPEIN		☐	PRCT_COND_PRICING_UNIT	☐	Condition Pricing Unit
22	KMEIN	CNCCRMPRSAP20103	KMEIN		☐	PRCT_PROD_UOM	☐	Unit of Measure for Product-Specific Quantity
23	KONWA	CNCCRMPRSAP20103	KONWA		☐	PRCT_COND_CURR	☐	Condition Currency
24	KRECH	CNCCRMPRSAP20103	KRECH		☐	PRCT_CALCULATION_TYPE	☐	Calculation Type for Condition

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in