SAP Table DGTPK
DG: Packing Requirement
DGTPK (DG: Packing Requirement) 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 DGTPK to other SAP tables.
DGTPK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||||||
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC | 20 | 0 | |||||||||||
| VALFR | Valid-From Date | ESEVALFR | DATS | 8 | 0 | |||||||||||
| VALTO | Valid-To Date | ESEVALTO | DATS | 8 | 0 | |||||||||||
| AENNR | Change Number | ESEAENNR | AENR | CHAR | 12 | 0 | ||||||||||
| DELFLG | Deletion Indicator | ADGE_DELFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| CRDAT | Created On | ESECRDAT | DATS | 8 | 0 | |||||||||||
| CRNAM | Created By | ESECRNAM | CHAR | 12 | 0 | |||||||||||
| UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | 0 | |||||||||||
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | 0 | |||||||||||
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR | 10 | 0 | ||||||||||
| OWNID | Data Provider | ESEVENDRID | CHAR | 10 | 0 | |||||||||||
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||||||
| RECMAST | Reference to Master Table | ESERECNMST | NUMC | 20 | 0 | |||||||||||
| PACOD | Packaging Code | THME_PACOD | THM073 | CHAR | 5 | 0 | ||||||||||
| PERIP | Permissibility of Inner Packaging | THME_PERIP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| IPMQU | Inner Packaging: Maximum Quantity / Volume | THME_IPMQU | QUAN | 8 | 2 | |||||||||||
| UIPMQ | Unit of measure for inner packaging: max. quantity/volume | THME_UIPMQ | T006 | UNIT | 3 | 0 | ||||||||||
| PEROP | Permissibility of Outer Packaging | THME_PEROP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| OPMQU | Outer Packaging: Maximum Quantity / Volume | THME_OPMQU | QUAN | 8 | 2 | |||||||||||
| UOPMQ | Unit for maximum quantity / volume of outer package | THME_UOPMQ | T006 | UNIT | 3 | 0 | ||||||||||
| TOGWE | Maximum Gross Weight | THME_TOGWE | QUAN | 8 | 2 | |||||||||||
| UTOGW | Unit for packaging gross weight | THME_UTOGW | T006 | UNIT | 3 | 0 | ||||||||||
| PERSP | Permissibility of Single Packaging | THME_PERSP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| SPAQU | Single Packaging: Maximum Quantity / Volume | THME_SPAQU | QUAN | 8 | 2 | |||||||||||
| USPAQ | Unit for single packaging: max. quantity / volume | THME_USPAQ | T006 | UNIT | 3 | 0 | ||||||||||
| IPALL | Pallet / Skeleton Container | THME_IPALL | CHAR | 1 | 0 |
Possible values
|
||||||||||
| AGAUN | Agreement of Authorities Required | THME_AGAUN | CHAR | 1 | 0 |
Possible values
|
||||||||||
| REGNO | Approval no. | ADGE_REGNO | CHAR | 30 | 0 | |||||||||||
| AGRNO | Exception and Agreement Number | ADGE_AGRNO | CHAR | 30 | 0 | |||||||||||
| PAWOS | Processing Status for Basic Data and Master Data | THME_WOS | THM039 | CHAR | 2 | 0 | ||||||||||
| EERIP | Permissibility of Inner Packaging (Limited Quantities) | THME_EERIP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| EIPA | Maximum Inner Packaging - Limited Quantity (Qty/Volume) | THME_EIPA | QUAN | 8 | 2 | |||||||||||
| UEIPA | Unit of Measurement (Ltd. Quantity Max. Inner Packaging) | THME_UEIPA | T006 | UNIT | 3 | 0 | ||||||||||
| EEROP | For limited quantities: max. outer package (limited qty) | THME_EEROP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| EOPA | Maximum Outer Packaging - Limited Quantity (Qty/Volume) | THME_EOPA | QUAN | 8 | 2 | |||||||||||
| UEOPA | Unit of measurement (ltd. quantity max. outer package) | THME_UEOPA | T006 | UNIT | 3 | 0 | ||||||||||
| EGWE | Packaging gross weight limited quantity (mass) | THME_EGWE | QUAN | 8 | 2 | |||||||||||
| UEGWE | Unit of measurement (ltd. quantity packaging gross weight) | THME_UEGWE | T006 | UNIT | 3 | 0 | ||||||||||
| EERSP | Permissibility of Single Packaging (Limited Quantities) | THME_EERSP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ESPA | Max. Single Packaging Limited Quantity (Quantity/Volume) | THME_ESPA | QUAN | 8 | 2 | |||||||||||
| UESPA | Unit of Measurement (Ltd. Quantity Max. Single Packaging) | THME_UESPA | T006 | UNIT | 3 | 0 | ||||||||||
| DAOR | Data Origin (Filling and Distribution) | ADGE_DAOR | CHAR | 1 | 0 |
Possible values
|
||||||||||
DGTPK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| DGTPK | AENNR | SY | MANDT | AENR | Change Master | MANDT |
| DGTPK | AENNR | DGTPK | AENNR | AENR | Change Master | AENNR |
| DGTPK | MANDT | DGTPK | MANDT | T000 | Clients | MANDT |
| DGTPK | PACOD | SY | MANDT | THM073 | DG: Packaging Code Specific to Dangerous Goods Regulations | MANDT |
| DGTPK | PACOD | * | THM073 | DG: Packaging Code Specific to Dangerous Goods Regulations | LWDG | |
| DGTPK | PACOD | DGTPK | PACOD | THM073 | DG: Packaging Code Specific to Dangerous Goods Regulations | PACOD |
| DGTPK | PAWOS | DGTPK | PAWOS | THM039 | DG: Processing Status for Dangerous Goods Basic Data | DGWOS |
| DGTPK | PAWOS | DGTPK | MANDT | THM039 | DG: Processing Status for Dangerous Goods Basic Data | MANDT |
| DGTPK | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| DGTPK | SRSID | DGTPK | SRSID | TCG56 | EHS: Data Origin | SRSID |
| DGTPK | UEGWE | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UEGWE | DGTPK | UEGWE | T006 | Units of Measurement | MSEHI |
| DGTPK | UEIPA | DGTPK | UEIPA | T006 | Units of Measurement | MSEHI |
| DGTPK | UEIPA | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UEOPA | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UEOPA | DGTPK | UEOPA | T006 | Units of Measurement | MSEHI |
| DGTPK | UESPA | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UESPA | DGTPK | UESPA | T006 | Units of Measurement | MSEHI |
| DGTPK | UIPMQ | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UIPMQ | DGTPK | UIPMQ | T006 | Units of Measurement | MSEHI |
| DGTPK | UOPMQ | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UOPMQ | DGTPK | UOPMQ | T006 | Units of Measurement | MSEHI |
| DGTPK | USPAQ | DGTPK | USPAQ | T006 | Units of Measurement | MSEHI |
| DGTPK | USPAQ | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UTOGW | DGTPK | MANDT | T006 | Units of Measurement | MANDT |
| DGTPK | UTOGW | DGTPK | UTOGW | T006 | Units of Measurement | MSEHI |
