SAP ABAP Table CMSD_DEA_MST (Drug Enforcement Administration (DEA))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-POS (Application Component) Point of Sale
     ⤷ CMS_EXTERNAL_DATA (Package) External data load

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMSD_DEA_MST	Table Relationship Diagram
Short Description	Drug Enforcement Administration (DEA)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DEA_NO	☑	CMST_DEA	CMS_DEA	CHAR	9	0	DEA Number
3	BUSINESS_TYPE	☐	CMST_BUS_TYPE	CMS_CB_BUS_TYPE	CHAR	1	0	Type of Business
4	DRG_SCH	☐	CMST_DRUG_SCH	CMS_CB_DRUG_SCH	CHAR	12	0	Drug Schedule (CSA Entity Approved for)
5	DEA_EXP_DATE	☐	CMST_DEA_EXP	DATS	DATS	8	0	DEA Number Expiry Date
6	ENTITY_NAME	☐	CMST_ENT_NAME	CHAR40	CHAR	40	0	Entity Name
7	ADDRESS1	☐	CMST_ADDRESS1	CHAR40	CHAR	40	0	Address Line 1
8	ADDRESS2	☐	CMST_ADDRESS2	CHAR40	CHAR	40	0	Address Line 2
9	ADDRESS3	☐	CMST_ADDRESS3	CHAR40	CHAR	40	0	Address Line 3
10	CITY	☐	CMST_AD_CITY	CHAR40	CHAR	40	0	City
11	STATE	☐	CMST_STATE	CHAR2	CHAR	2	0	State
12	ZIP_CODE	☐	CMST_ZIP_CODE	PSTLZ	CHAR	10	0	Zip Code
13	CREATE_USER	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
14	CREATE_DATE	☐	CMST_DATE	SYDATS	DATS	8	0	Date
15	CREATE_TIME	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
16	UPDATE_USER	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
17	UPDATE_DATE	☐	CMST_DATE	SYDATS	DATS	8	0	Date
18	UPDATE_TIME	☐	CMST_TIME	SYTIME	TIMS	6	0	Time

History

Last changed by/on	SAP	20110908
SAP Release Created in	400