SAP ABAP Table CMST_DEA_WRK (DEA Structure for External Identifier 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	INTTAB	Structure
Structure	CMST_DEA_WRK	Table Relationship Diagram
Short Description	DEA Structure for External Identifier DEA

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

History

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