SAP ABAP View CMS_PROD_ATTRV (Pharma Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH (Application Component) Pharmaceuticals
     ⤷ CMS_PRODUCT_ATTRIBUTES (Package) Product Master - Life Science Attributes

Basic Data

View Type	D	Database View
Database View	CMS_PROD_ATTRV
Short Description	Pharma Attributes
Root table	CMS_PROD_ATTR	Pharma Attributes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CMS_PROD_ATTR	CMS_PROD_ATTR

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	CMS_PROD_ATTR	CLIENT		☐	MANDT	☐	Client
2	FRG_GUID	CMS_PROD_ATTR	FRG_GUID		☐	COMT_FRG_GUID	☐	Set GUID
3	VALID_FROM	CMS_PROD_ATTR	VALID_FROM		☐	COMT_VALID_FROM	☐	Valid From (Time Stamp)
4	VALID_TO	CMS_PROD_ATTR	VALID_TO		☐	COMT_VALID_TO	☐	Valid To (Time Stamp)
5	UPNAME	CMS_PROD_ATTR	UPNAME		☐	COMT_UPNAME	☐	Name of the User Who Last Changed the Set
6	HISTEX	CMS_PROD_ATTR	HISTEX		☐	COMT_HISTEX	☐	History Exists
7	LOGSYS	CMS_PROD_ATTR	LOGSYS		☐	COMT_LOGSYS	☐	Original System
8	FF0010	CMS_PROD_ATTR	FF0010		☐	CMS_THERA_CODE	☐	Therap.Class Code
9	FF0011	CMS_PROD_ATTR	FF0011		☐	CMS_GENERIC	☐	Generic Code
10	FF0012	CMS_PROD_ATTR	FF0012		☐	CMS_PROD_STR	☐	Product Strength
11	FF0013	CMS_PROD_ATTR	FF0013		☐	CMS_DOSAGE	☐	Dosage Form
12	FF0014	CMS_PROD_ATTR	FF0014		☐	CMS_ROUTE_ADM	☐	Route Admin
13	FF0015	CMS_PROD_ATTR	FF0015		☐	CMS_HICL	☐	HICL
14	FF0016	CMS_PROD_ATTR	FF0016		☐	CMS_UNITDOSE	☐	Unit Dose

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	20100421
SAP Release Created in	510