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

SAP ABAP Table `OIJLOCMAT` {OIL-TSW: Location Rundown/Planning material table}

Home

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

# Entities

[OIJLOCMAT] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*+LOCID {label: "CHAR (10)"}
*+PMATNR {label: "CHAR (18)"}
+PWERK {label: "CHAR (4)"}
+CHARG {label: "CHAR (10)"}
+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)"}
+VERID {label: "CHAR (4)"}
+BOMUSE {label: "CHAR (1)"}
+BOMMAT {label: "CHAR (18)"}
+DEFSITYP {label: "CHAR (2)"}
LBUOM {label: "UNIT (3)"}

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

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

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

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

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

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

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

# Relationships

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

E-R Diagram for table OIJLOCMAT (OIL-TSW: Location Rundown/Planning material table)

Foreign Key tables (17)

MARA {General Material Data}
MCHB {Batch Stocks}
MKAL {Production Versions of Material}
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}
T416 {BOM Usage - Item Statuses}
TFACD {Factory calendar definition}
TOIJ_EL_SITYPES {TSW: Define valid sitypes}

SAP ABAP Table OIJLOCMAT {OIL-TSW: Location Rundown/Planning material table}

Foreign Key tables (17)

SAP ABAP Table `OIJLOCMAT` {OIL-TSW: Location Rundown/Planning material table}