SAP ABAP Table OIJTSMAT (OIL-TSW: TS Rundown/Planning material table), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `OIJTSMAT` {OIL-TSW: TS Rundown/Planning material table}

Home

                title {label: "SAP ABAP table OIJTSMAT {OIL-TSW: TS Rundown/Planning material table}", size: "20"}

# Entities

[OIJTSMAT] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*+TSYST {label: "CHAR (10)"}
*+PMATNR {label: "CHAR (18)"}
+PWERK {label: "CHAR (4)"}
+RDUOM {label: "UNIT (3)"}
+SRCTYPE {label: "CHAR (1)"}
PLCAL {label: "CHAR (3)"}
+DATUOM {label: "UNIT (3)"}
+PTSYST {label: "CHAR (10)"}
+PLUOM {label: "UNIT (3)"}
+CYCUOM {label: "UNIT (3)"}
+INVUOM {label: "UNIT (3)"}
+STSYST {label: "CHAR (10)"}
+SLOCID {label: "CHAR (10)"}
+OFFUOM {label: "UNIT (3)"}
+COVPROF {label: "CHAR (3)"}
+CALPROF {label: "CHAR (3)"}
+FACTORY {label: "CHAR (2)"}
+SFTTYPE {label: "CHAR (3)"}
+TGTTYPE {label: "CHAR (3)"}
+FCCAL {label: "CHAR (2)"}
+FCPRF {label: "CHAR (3)"}
+DEFSITYP {label: "CHAR (2)"}

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

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

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

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

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

[OIJSFTYP] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SFTTYPE {label: "CHAR (3)"}
*+SPRAS {label: "LANG (1)"}

[OIJSRCTYPE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*SRCTYPE {label: "CHAR (1)"}

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

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

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

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

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

[TFACD] {bgcolor: "#d0e0d0"}
*IDENT {label: "CHAR (2)"}

[TOIJ_EL_SITYPES] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*SITYP {label: "CHAR (2)"}

# Relationships

OIJTSMAT 1--* OIJSCAL {label: "OIJTSMAT-CALPROF = OIJSCAL-CALPROF"}
OIJTSMAT 1--* OIJCOV {label: "OIJTSMAT-COVPROF = OIJCOV-COVPROF"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-CYCUOM = T006-MSEHI"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-DATUOM = T006-MSEHI"}
OIJTSMAT *--* TOIJ_EL_SITYPES {label: "OIJTSMAT-DEFSITYP = TOIJ_EL_SITYPES-SITYP"}
OIJTSMAT 1--* TFACD {label: "OIJTSMAT-FACTORY = TFACD-IDENT"}
OIJTSMAT 1--* TFACD {label: "OIJTSMAT-FCCAL = TFACD-IDENT"}
OIJTSMAT *--* OIJFCPRF {label: "OIJTSMAT-FCPRF = OIJFCPRF-FCPRF"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-INVUOM = T006-MSEHI"}
OIJTSMAT 1--* T000 {label: "OIJTSMAT-MANDT = T000-MANDT"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-OFFUOM = T006-MSEHI"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-PLUOM = T006-MSEHI"}
OIJTSMAT 1--* MARA {label: "OIJTSMAT-PMATNR = MARA-MATNR"}
OIJTSMAT 1--* OIJTS {label: "OIJTSMAT-PTSYST = OIJTS-TSYST"}
OIJTSMAT 1--* T001W {label: "OIJTSMAT-PWERK = T001W-WERKS"}
OIJTSMAT 1--* T006 {label: "OIJTSMAT-RDUOM = T006-MSEHI"}
OIJTSMAT 1--* OIJSFTYP {label: "OIJTSMAT-SFTTYPE = OIJSFTYP-SFTTYPE"}
OIJTSMAT 1--* OIJLOC {label: "OIJTSMAT-SLOCID = OIJLOC-LOCID"}
OIJTSMAT 1--* OIJSRCTYPE {label: "OIJTSMAT-SRCTYPE = OIJSRCTYPE-SRCTYPE"}
OIJTSMAT 1--* OIJTS {label: "OIJTSMAT-STSYST = OIJTS-TSYST"}
OIJTSMAT *--* OIJTGTYP {label: "OIJTSMAT-TGTTYPE = OIJTGTYP-TGTTYPE"}
OIJTSMAT 1--* OIJTS {label: "OIJTSMAT-TSYST = OIJTS-TSYST"}

E-R Diagram for table OIJTSMAT (OIL-TSW: TS Rundown/Planning material table)

Foreign Key tables (14)

MARA {General Material Data}
OIJCOV {OIL-TSW: Safety stock coverage period profile}
OIJFCPRF {OIL-TSW: Rack issue forecast profile}
OIJLOC {Location table}
OIJSCAL {OIL-TSW: Safety stock calendar usage profile}
OIJSFTYP {OIL-TSW: Safety stock calculation type}
OIJSRCTYPE {OIL-TSW: Physical inventory update type}
OIJTGTYP {OIL-TSW: Target stock calculation type}
OIJTS {Transport system (IS-Oil TSW standard/core object )}
T000 {Clients}
T001W {Plants/Branches}
T006 {Units of Measurement}
TFACD {Factory calendar definition}
TOIJ_EL_SITYPES {TSW: Define valid sitypes}

SAP ABAP Table OIJTSMAT {OIL-TSW: TS Rundown/Planning material table}

Foreign Key tables (14)

SAP ABAP Table `OIJTSMAT` {OIL-TSW: TS Rundown/Planning material table}