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

SAP ABAP Table `HSMS_MDAPI` {EHS: API Hazardous Substance Basic Data}

Home

                title {label: "SAP ABAP table HSMS_MDAPI {EHS: API Hazardous Substance Basic Data}", size: "20"}

# Entities

[HSMS_MDAPI] {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_MDAPI 1--* AENR {label: "HSMS_MDAPI-AENNR = AENR-AENNR"}
HSMS_MDAPI 1--* T005 {label: "HSMS_MDAPI-COUNTRY = T005-LAND1"}
HSMS_MDAPI 1--* T000 {label: "HSMS_MDAPI-MANDT = T000-MANDT"}
HSMS_MDAPI 1--* MARA {label: "HSMS_MDAPI-MATNR = MARA-MATNR"}
HSMS_MDAPI 1--* T005S {label: "HSMS_MDAPI-REGION = T005S-BLAND"}
HSMS_MDAPI 1--* TCG56 {label: "HSMS_MDAPI-SRSID = TCG56-SRSID"}
HSMS_MDAPI 1--* HSMC_013 {label: "HSMS_MDAPI-STOKEY1 = HSMC_013-STOKEY"}
HSMS_MDAPI 1--* HSMC_013 {label: "HSMS_MDAPI-STOKEY2 = HSMC_013-STOKEY"}

E-R Diagram for table HSMS_MDAPI (EHS: API Hazardous Substance Basic Data)

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_MDAPI {EHS: API Hazardous Substance Basic Data}

Foreign Key tables (7)

SAP ABAP Table `HSMS_MDAPI` {EHS: API Hazardous Substance Basic Data}