1. Home
  2. Resources
  3. SAP Tables
  4. ZZDEA_MST - Drug Enforcement Administration (DEA)

SAP Table ZZDEA_MST

Drug Enforcement Administration (DEA)

ZZDEA_MST (Drug Enforcement Administration (DEA)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ZZDEA_MST to other SAP tables.

ZZDEA_MST table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
DEA_NO DEA Number ZZDEA_NO CHAR 9 0
SHIP_TO Ship-to party KUNWE KNA1 CHAR 10 0
BUSINESS_TYPE Business Activity Code (BAC) ZZDEA_BUSINESS_TYPE ZZDEA_BUS_TYPE CHAR 1 0
DRG_SCH Drug Schedule (CSA Entity Approved for) ZZDEA_DRUG_SCH CHAR 12 0
DEA_EXP_DATE DEA Number Expiry Date ZZDEA_DEA_EXP DATS 8 0
ENTITY_NAME Entity Name ZZDEA_ENT_NAME CHAR 40 0
ADDRESS1 Address Line 1 ZZDEA_ADDRESS1 CHAR 40 0
ADDRESS2 Address Line 2 ZZDEA_ADDRESS2 CHAR 40 0
ADDRESS3 Address Line 3 ZZDEA_ADDRESS3 CHAR 40 0
CITY City ZZDEA_AD_CITY CHAR 40 0
STATE State ZZDEA_STATE CHAR 2 0
ZIP_CODE Zip Code ZZDEA_ZIP_CODE CHAR 10 0
CREATE_USER User that created the transaction ZZDEA_CREATED_BY CHAR 12 0
CREATE_DATE Date ZZDEA_DATE DATS 8 0
CREATE_TIME Time ZZDEA_TIME TIMS 6 0
UPDATE_USER Transaction last changed by ZZDEA_CHANGED_BY CHAR 12 0
UPDATE_DATE Date ZZDEA_DATE DATS 8 0
UPDATE_TIME Time ZZDEA_TIME TIMS 6 0

ZZDEA_MST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ZZDEA_MST BUSINESS_TYPE ZZDEA_MST MANDT ZZDEA_BUS_TYPE DEA Business Activity Codes MANDT
ZZDEA_MST BUSINESS_TYPE ZZDEA_MST BUSINESS_TYPE ZZDEA_BUS_TYPE DEA Business Activity Codes BUSINESS_TYPE
ZZDEA_MST SHIP_TO ZZDEA_MST MANDT KNA1 General Data in Customer Master MANDT
ZZDEA_MST SHIP_TO ZZDEA_MST SHIP_TO KNA1 General Data in Customer Master KUNNR