SAP ABAP Table V_OPTI_MDRS (Generated Table for View), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `V_OPTI_MDRS` {Generated Table for View}

Home

                title {label: "SAP ABAP table V_OPTI_MDRS {Generated Table for View}", size: "20"}

# Entities

[V_OPTI_MDRS] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*RSNUM {label: "NUMC (10)"}
*RSPOS {label: "NUMC (4)"}
*RSART {label: "CHAR (1)"}
+MATNR {label: "CHAR (18)"}
+WERKS {label: "CHAR (4)"}
+LGORT {label: "CHAR (4)"}
+CHARG {label: "CHAR (10)"}
+ERFME {label: "UNIT (3)"}
+UMLGO {label: "CHAR (4)"}
+UMWRK {label: "CHAR (4)"}
+MEINS {label: "UNIT (3)"}

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

[MCHA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+MATNR {label: "CHAR (18)"}
*+WERKS {label: "CHAR (4)"}
*+CHARG {label: "CHAR (10)"}

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

[T001L] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+WERKS {label: "CHAR (4)"}
*LGORT {label: "CHAR (4)"}

[T001W] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*WERKS {label: "CHAR (4)"}

[T006] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MSEHI {label: "UNIT (3)"}

# Relationships

V_OPTI_MDRS ?--* MCHA {label: "V_OPTI_MDRS-CHARG = MCHA-CHARG"}
V_OPTI_MDRS ?--* T006 {label: "V_OPTI_MDRS-ERFME = T006-MSEHI"}
V_OPTI_MDRS ?--* T001L {label: "V_OPTI_MDRS-LGORT = T001L-LGORT"}
V_OPTI_MDRS 1--* T000 {label: "V_OPTI_MDRS-MANDT = T000-MANDT"}
V_OPTI_MDRS 1--* MARA {label: "V_OPTI_MDRS-MATNR = MARA-MATNR"}
V_OPTI_MDRS 1--* T006 {label: "V_OPTI_MDRS-MEINS = T006-MSEHI"}
V_OPTI_MDRS ?--* T001L {label: "V_OPTI_MDRS-UMLGO = T001L-LGORT"}
V_OPTI_MDRS ?--* T001W {label: "V_OPTI_MDRS-UMWRK = T001W-WERKS"}
V_OPTI_MDRS 1--* T001W {label: "V_OPTI_MDRS-WERKS = T001W-WERKS"}

E-R Diagram for table V_OPTI_MDRS (Generated Table for View)

Foreign Key tables (6)

MARA {General Material Data}
MCHA {Batches}
T000 {Clients}
T001L {Storage Locations}
T001W {Plants/Branches}
T006 {Units of Measurement}

SAP ABAP Table V_OPTI_MDRS {Generated Table for View}

Foreign Key tables (6)

SAP ABAP Table `V_OPTI_MDRS` {Generated Table for View}