CMSD_DEA_MST is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of CMSD_DEA_MST in SAP.
- Table description : Drug Enforcement Administration (DEA)
- Module : CRM-CHM-POS
- Parent Module : CRM
- Package : CMS_EXTERNAL_DATA
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMSD_DEA_MST Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| DEA_NO | DEA Number | CMST_DEA | CMS_DEA |
| BUSINESS_TYPE | Type of Business | CMST_BUS_TYPE | CMS_CB_BUS_TYPE |
| DRG_SCH | Drug Schedule (CSA Entity Approved for) | CMST_DRUG_SCH | CMS_CB_DRUG_SCH |
| DEA_EXP_DATE | DEA Number Expiry Date | CMST_DEA_EXP | DATS |
| ENTITY_NAME | Entity Name | CMST_ENT_NAME | CHAR40 |
| ADDRESS1 | Address Line 1 | CMST_ADDRESS1 | CHAR40 |
| ADDRESS2 | Address Line 2 | CMST_ADDRESS2 | CHAR40 |
| ADDRESS3 | Address Line 3 | CMST_ADDRESS3 | CHAR40 |
| CITY | City | CMST_AD_CITY | CHAR40 |
| STATE | State | CMST_STATE | CHAR2 |
| ZIP_CODE | Zip Code | CMST_ZIP_CODE | PSTLZ |
| CREATE_USER | User that created the transaction | CMST_CREATED_BY | UNAME |
| CREATE_DATE | Date | CMST_DATE | SYDATS |
| CREATE_TIME | Time | CMST_TIME | SYTIME |
| UPDATE_USER | Transaction last changed by | CMST_CHANGED_BY | UNAME |
| UPDATE_DATE | Date | CMST_DATE | SYDATS |
| UPDATE_TIME | Time | CMST_TIME | SYTIME |
CMSD_DEA_MST related tables
| Table | Note |
|---|---|
| CMSD_DEA_MST | Drug Enforcement Administration (DEA) |
| CDBC_DEA_SCHED | DEA drug schedules master table(Customizable) |
| CRMPHA_DEA_SCHED | DEA drug schedules master table(Customizable) |
| CMS_LIQ_PROC | Process details for an enforcement measure |
| N1EDRUG | IS-H*MED: Drug Event - Drug Assignment |
| TN17E | IS-H: Drug Allergies - Routes of Administration |
| TN17Q | IS-H: Drug allergy - texts for routes of administration |
| CDBC_DEA_SC_T | DEA Schedule Description |
| CDBD_PH_FRG050 | CDB Pharma BP: assigned DEA schedules |
| CRMPHAC_DEA_SC_T | DEA Schedule Description |
| CRMPHAM_BP_FRG50 | CRM Pharma BP: assigned DEA schedules |
| CRMPHAM_BP_FRG60 | CRM Pharma BP: assigned DEA schedules |
| DEA_INFO | Pharma: DEA Information |
| DEA_INFOH | Pharma: DEA Information |
| TSADC | Address administration: Communications types administration |
User ser administration TablesCentral user administration TablesSap security user administration TablesUser administration in sap security TablesSap hana administration guide TablesWhat is user administration in sap security TablesCentral user administration in sap security TablesSap ewm error in handling unit administration Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP