SAP Table SPL_MARA
Data Division MARA
SPL_MARA (Data Division MARA) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SPL_MARA to other SAP tables.
SPL_MARA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HUTYP_DFLT | Standard HU Type | CIFHUTYPDF | THUTYP | CHAR | 4 | 0 | ||||||
| PILFERABLE | Pilferable | CIFPILFRBL | CHAR | 1 | 0 |
Possible values
|
||||||
| WHSTC | Warehouse Storage Condition | CIFWHSTC | TWHSTC | CHAR | 2 | 0 | ||||||
| WHMATGR | Warehouse Material Group | CIFWHMATGR | TWHMATGR | CHAR | 4 | 0 | ||||||
| HNDLCODE | Handling Indicator | CIFHDLCODE | THNDLCD | CHAR | 4 | 0 | ||||||
| HAZMAT | Relevant for Hazardous Substances | CIFHAZMAT | CHAR | 1 | 0 |
Possible values
|
||||||
| HUTYP | Handling Unit Type | CIFHUTYP | THUTYP | CHAR | 4 | 0 | ||||||
| TARE_VAR | Variable Tare Weight | CIFTAREVAR | CHAR | 1 | 0 |
Possible values
|
||||||
| MAXC | Maximum Allowed Capacity of Packaging Material | CIFMAXC | DEC | 15 | 3 | |||||||
| MAXC_TOL | Overcapacity Tolerance of the Handling Unit | CIFMAXCTOL | DEC | 3 | 1 | |||||||
| MAXL | Maximum Packing Length of Packaging Material | CIFMAXL | QUAN | 15 | 3 | |||||||
| MAXB | Maximum Packing Width of Packaging Material | CIFMAXB | QUAN | 15 | 3 | |||||||
| MAXH | Maximum Packing Height of Packaging Material | CIFMAXH | QUAN | 15 | 3 | |||||||
| MAXDIM_UOM | Unit of Measure for Maximum Packing Length/Width/Height | CIFMAXDUOM | UNIT | 3 | 0 | |||||||
| HERKL | Country of origin of the material | HERKL | T005 | CHAR | 3 | 0 | ||||||
| MFRGR | Material freight group | MFRGR | TMFG | CHAR | 8 | 0 | ||||||
| QQTIME | Quarantine Period | CIFQQTIME | QUAN | 3 | 0 | |||||||
| QQTIMEUOM | Time Unit for Quarantine Period | CIFQQTIMEUOM | T006 | UNIT | 3 | 0 | ||||||
| QGRP | Quality Inspection Group | CIFQGRP | TQGRP | CHAR | 4 | 0 | ||||||
| SERIAL | Serial Number Profile | CIFSERIAL | TSERIAL | CHAR | 4 | 0 | ||||||
| PS_SMARTFORM | Form Name | CIFPSSFNAME | STXFADM | CHAR | 30 | 0 | ||||||
SPL_MARA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SPL_MARA | HERKL | SYST | MANDT | T005 | Countries | MANDT |
| SPL_MARA | HERKL | SPL_MARA | HERKL | T005 | Countries | LAND1 |
| SPL_MARA | HNDLCODE | SYST | MANDT | THNDLCD | Handling Indicator | MANDT |
| SPL_MARA | HNDLCODE | SPL_MARA | HNDLCODE | THNDLCD | Handling Indicator | HNDLCODE |
| SPL_MARA | HUTYP | SYST | MANDT | THUTYP | Handling Unit Types | MANDT |
| SPL_MARA | HUTYP | SPL_MARA | HUTYP | THUTYP | Handling Unit Types | HUTYP |
| SPL_MARA | HUTYP_DFLT | SPL_MARA | HUTYP_DFLT | THUTYP | Handling Unit Types | HUTYP |
| SPL_MARA | HUTYP_DFLT | SYST | MANDT | THUTYP | Handling Unit Types | MANDT |
| SPL_MARA | MFRGR | SYST | MANDT | TMFG | Material freight groups | MANDT |
| SPL_MARA | MFRGR | SPL_MARA | MFRGR | TMFG | Material freight groups | MFRGR |
| SPL_MARA | PS_SMARTFORM | SPL_MARA | PS_SMARTFORM | STXFADM | Smart Forms: Administration | FORMNAME |
| SPL_MARA | QGRP | SYST | MANDT | TQGRP | Quality Inspection Group | MANDT |
| SPL_MARA | QGRP | SPL_MARA | QGRP | TQGRP | Quality Inspection Group | QGRP |
| SPL_MARA | QQTIMEUOM | SPL_MARA | QQTIMEUOM | T006 | Units of Measurement | MSEHI |
| SPL_MARA | QQTIMEUOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| SPL_MARA | SERIAL | SYST | MANDT | TSERIAL | Serial Number Profile | MANDT |
| SPL_MARA | SERIAL | SPL_MARA | SERIAL | TSERIAL | Serial Number Profile | SERIAL |
| SPL_MARA | WHMATGR | SYST | MANDT | TWHMATGR | Warehouse Material Group | MANDT |
| SPL_MARA | WHMATGR | SPL_MARA | WHMATGR | TWHMATGR | Warehouse Material Group | WHMATGR |
| SPL_MARA | WHSTC | SPL_MARA | WHSTC | TWHSTC | Warehouse Storage Condition | WHSTC |
| SPL_MARA | WHSTC | SYST | MANDT | TWHSTC | Warehouse Storage Condition | MANDT |
