SAP ABAP Table HSMS_MD (EHS: Hazardous Substance Basic Data (MARA-MATNR)), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `HSMS_MD` {EHS: Hazardous Substance Basic Data (MARA-MATNR)}

Home

                title {label: "SAP ABAP table HSMS_MD {EHS: Hazardous Substance Basic Data (MARA-MATNR)}", size: "20"}

# Entities

[HSMS_MD] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+AENNR {label: "CHAR (12)"}
+SRSID {label: "CHAR (10)"}
+MATNR {label: "CHAR (18)"}
+COUNTRY {label: "CHAR (3)"}
+REGION {label: "CHAR (3)"}
+STOKEY1 {label: "CHAR (5)"}
+STOKEY2 {label: "CHAR (5)"}

[AENR] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*AENNR {label: "CHAR (12)"}

[HSMC_013] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+STOCAT {label: "CHAR (5)"}
*STOKEY {label: "CHAR (5)"}

[MARA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MATNR {label: "CHAR (18)"}

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[TCG56] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SRSID {label: "CHAR (10)"}

# Relationships

HSMS_MD 1--* AENR {label: "HSMS_MD-AENNR = AENR-AENNR"}
HSMS_MD 1--* T005 {label: "HSMS_MD-COUNTRY = T005-LAND1"}
HSMS_MD 1--* T000 {label: "HSMS_MD-MANDT = T000-MANDT"}
HSMS_MD 1--* MARA {label: "HSMS_MD-MATNR = MARA-MATNR"}
HSMS_MD 1--* T005S {label: "HSMS_MD-REGION = T005S-BLAND"}
HSMS_MD 1--* TCG56 {label: "HSMS_MD-SRSID = TCG56-SRSID"}
HSMS_MD 1--* HSMC_013 {label: "HSMS_MD-STOKEY1 = HSMC_013-STOKEY"}
HSMS_MD 1--* HSMC_013 {label: "HSMS_MD-STOKEY2 = HSMC_013-STOKEY"}

E-R Diagram for table HSMS_MD (EHS: Hazardous Substance Basic Data (MARA-MATNR))

Foreign Key tables (7)

AENR {Change Master}
HSMC_013 {EHS: Hazard Rating}
MARA {General Material Data}
T000 {Clients}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
TCG56 {EHS: Data Origin}

SAP ABAP Table HSMS_MD {EHS: Hazardous Substance Basic Data (MARA-MATNR)}

Foreign Key tables (7)

SAP ABAP Table `HSMS_MD` {EHS: Hazardous Substance Basic Data (MARA-MATNR)}