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

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

Home

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

# Entities

[QPRS_SEL_Q] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*PN_NR {label: "NUMC (12)"}
*+QMNUM {label: "CHAR (12)"}
*PHYNR {label: "CHAR (12)"}
+PRART {label: "CHAR (2)"}
+PRTYP {label: "CHAR (1)"}
+GBTYP {label: "CHAR (6)"}
+MEINH {label: "UNIT (3)"}
+MATNR {label: "CHAR (18)"}
+WERKS {label: "CHAR (4)"}
+CHARG {label: "CHAR (10)"}
+LGORT {label: "CHAR (4)"}
+ABORT {label: "CHAR (12)"}
+PRIMPACK {label: "CHAR (8)"}
+STABICON {label: "CHAR (8)"}

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

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

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

[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)"}

[TQ40] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PRART {label: "CHAR (2)"}

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

[TQ42] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*GEBINDETYP {label: "CHAR (6)"}

[TQ43] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*STABICON {label: "CHAR (8)"}

[TQ44] {bgcolor: "#d0e0d0"}
*PRTYP {label: "CHAR (1)"}

[TQ45] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PRIMPACK {label: "CHAR (8)"}

# Relationships

QPRS_SEL_Q ?--* TQ41 {label: "QPRS_SEL_Q-ABORT = TQ41-AUFBEWORT"}
QPRS_SEL_Q ?--* MCH1 {label: "QPRS_SEL_Q-CHARG = MCH1-CHARG"}
QPRS_SEL_Q *--* TQ42 {label: "QPRS_SEL_Q-GBTYP = TQ42-GEBINDETYP"}
QPRS_SEL_Q ?--* T001L {label: "QPRS_SEL_Q-LGORT = T001L-LGORT"}
QPRS_SEL_Q 1--* T000 {label: "QPRS_SEL_Q-MANDT = T000-MANDT"}
QPRS_SEL_Q ?--* MARA {label: "QPRS_SEL_Q-MATNR = MARA-MATNR"}
QPRS_SEL_Q *--* T006 {label: "QPRS_SEL_Q-MEINH = T006-MSEHI"}
QPRS_SEL_Q 1--* TQ40 {label: "QPRS_SEL_Q-PRART = TQ40-PRART"}
QPRS_SEL_Q 1--* TQ45 {label: "QPRS_SEL_Q-PRIMPACK = TQ45-PRIMPACK"}
QPRS_SEL_Q 1--* TQ44 {label: "QPRS_SEL_Q-PRTYP = TQ44-PRTYP"}
QPRS_SEL_Q ?--* QMEL {label: "QPRS_SEL_Q-QMNUM = QMEL-QMNUM"}
QPRS_SEL_Q 1--* TQ43 {label: "QPRS_SEL_Q-STABICON = TQ43-STABICON"}
QPRS_SEL_Q 1--* T001W {label: "QPRS_SEL_Q-WERKS = T001W-WERKS"}

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

Foreign Key tables (13)

MARA {General Material Data}
MCH1 {Batches (if Batch Management Cross-Plant)}
QMEL {Quality Notification}
T000 {Clients}
T001L {Storage Locations}
T001W {Plants/Branches}
T006 {Units of Measurement}
TQ40 {Definition of sample types}
TQ41 {Storage locations for physical samples}
TQ42 {Physical sample containers}
TQ43 {Storage Conditions}
TQ44 {Phys. sample types}
TQ45 {Primary Packaging (Stability Study)}

SAP ABAP Table QPRS_SEL_Q {Generated Table for View QPRS_SEL_Q}

Foreign Key tables (13)

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