SAP ABAP View CNACRMPRSAP2900 (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	CNACRMPRSAP2900
Short Description	Access View for a Condition Table
Root table	CNCCRMPRSAP2900	Sales Organization/Distribution Channel/Level/Product

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CNCCRMPRSAP2900	CNCCRMPRSAP2900

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	CNCCRMPRSAP2900	CLIENT		☐	MANDT	☐	Client
2	SALES_ORG	CNCCRMPRSAP2900	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
3	DIS_CHANNEL	CNCCRMPRSAP2900	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
4	BASIC_TIER	CNCCRMPRSAP2900	BASIC_TIER		☐	CRMT_LOY_BASIC_TIER_CODE	☐	Basic Tier Code
5	LIFETIME_TIER	CNCCRMPRSAP2900	LIFETIME_TIER		☐	CRMT_LOY_LIFETIME_TIER_CODE	☐	Lifetime Tier Code
6	PRODUCT	CNCCRMPRSAP2900	PRODUCT		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
7	KSCHL	CNCCRMPRSAP2900	KSCHL		☐	/SAPCND/COND_TYPE	☐	Condition Type
8	OBJECT_ID	CNCCRMPRSAP2900	OBJECT_ID		☐	/SAPCND/OBJECT_ID	☐	Higher-level object number for condition records
9	TIMESTAMP_TO	CNCCRMPRSAP2900	TIMESTAMP_TO		☐	/SAPCND/TIMESTAMP_TO	☐	Timestamp for Validity End Date
10	RELEASE_STATUS	CNCCRMPRSAP2900	RELEASE_STATUS		☐	/SAPCND/RELEASE_STATUS	☐	Release Status
11	KOPOS	CNCCRMPRSAP2900	KOPOS		☐	/SAPCND/SUPP_CONDITION_ID	☐	Condition Supplement ID
12	CREATED_ON	CNCCRMPRSAP2900	CREATED_ON		☐	/SAPCND/CREATED_ON	☐	Date on which Condition Record was Created
13	VARNUMH	CNCCRMPRSAP2900	VARNUMH		☐	/SAPCND/COND_TABLE_ENTRY_ID	☐	Condition Record ID
14	TIMESTAMP_FROM	CNCCRMPRSAP2900	TIMESTAMP_FROM		☐	/SAPCND/TIMESTAMP_FROM	☐	Timestamp for Validity Start Date
15	KSCHL_SUPP	CNCCRMPRSAP2900	KSCHL_SUPP		☐	/SAPCND/SUPP_COND_TYPE	☐	Supplementary Condition Type
16	COND_GROUP_ID	CNCCRMPRSAP2900	COND_GROUP_ID		☐	/SAPCND/COND_GROUP_ID	☐	ID of Group of Condition Records
17	MAINT_STATUS	CNCCRMPRSAP2900	MAINT_STATUS		☐	/SAPCND/MAINT_STATUS	☐	Editing status
18	CREATED_BY	CNCCRMPRSAP2900	CREATED_BY		☐	/SAPCND/CREATED_BY	☐	Name of User that Created the Condition Record
19	SUPP_EXIST	CNCCRMPRSAP2900	SUPP_EXIST		☐	/SAPCND/SUPP_EXIST	☐	Additional Data Indicator for Condition Record
20	SCALE_DIM	CNCCRMPRSAP2900	SCALE_DIM		☐	/SAPCND/DIMENSION_ID	☐	Dimenstion number
21	KBETR	CNCCRMPRSAP2900	KBETR		☐	PRCT_COND_RATE	☐	Condition Rate
22	KPEIN	CNCCRMPRSAP2900	KPEIN		☐	PRCT_COND_PRICING_UNIT	☐	Condition Pricing Unit
23	KMEIN	CNCCRMPRSAP2900	KMEIN		☐	PRCT_PROD_UOM	☐	Unit of Measure for Product-Specific Quantity
24	KONWA	CNCCRMPRSAP2900	KONWA		☐	PRCT_COND_CURR	☐	Condition Currency
25	KRECH	CNCCRMPRSAP2900	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