| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESERECN | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESEACTN | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALFR | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALTO | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | ESEAENNR | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ADGE_DELFLG | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEPARKFLG | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESECRDAT | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESECRNAM | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDAT | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAM | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG56 | ESESRSID | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEVENDRID | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 16 | RECMAST | Reference to Master Table | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECNMST | Allow NULL? |
| 17 | PACOD | Packaging Code | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | THM073 | THME_PACOD | Allow NULL? |
| 18 | PERIP | Permissibility of Inner Packaging | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_PERIP | Allow NULL? |
| 19 | IPMQU | Inner Packaging: Maximum Quantity / Volume | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_IPMQU | |
| 20 | UIPMQ | Unit of measure for inner packaging: max. quantity/volume | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UIPMQ | Allow NULL? |
| 21 | PEROP | Permissibility of Outer Packaging | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_PEROP | Allow NULL? |
| 22 | OPMQU | Outer Packaging: Maximum Quantity / Volume | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_OPMQU | |
| 23 | UOPMQ | Unit for maximum quantity / volume of outer package | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UOPMQ | Allow NULL? |
| 24 | TOGWE | Maximum Gross Weight | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_TOGWE | |
| 25 | UTOGW | Unit for packaging gross weight | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UTOGW | Allow NULL? |
| 26 | PERSP | Permissibility of Single Packaging | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_PERSP | Allow NULL? |
| 27 | SPAQU | Single Packaging: Maximum Quantity / Volume | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_SPAQU | |
| 28 | USPAQ | Unit for single packaging: max. quantity / volume | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_USPAQ | Allow NULL? |
| 29 | IPALL | Pallet / Skeleton Container | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_IPALL | Allow NULL? |
| 30 | AGAUN | Agreement of Authorities Required | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_AGAUN | Allow NULL? |
| 31 | REGNO | Approval no. | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ADGE_REGNO | Allow NULL? |
| 32 | AGRNO | Exception and Agreement Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ADGE_AGRNO | Allow NULL? |
| 33 | PAWOS | Processing Status for Basic Data and Master Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | THM039 | THME_WOS | Allow NULL? |
| 34 | EERIP | Permissibility of Inner Packaging (Limited Quantities) | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_EERIP | Allow NULL? |
| 35 | EIPA | Maximum Inner Packaging - Limited Quantity (Qty/Volume) | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_EIPA | |
| 36 | UEIPA | Unit of Measurement (Ltd. Quantity Max. Inner Packaging) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UEIPA | Allow NULL? |
| 37 | EEROP | For limited quantities: max. outer package (limited qty) | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_EEROP | Allow NULL? |
| 38 | EOPA | Maximum Outer Packaging - Limited Quantity (Qty/Volume) | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_EOPA | |
| 39 | UEOPA | Unit of measurement (ltd. quantity max. outer package) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UEOPA | Allow NULL? |
| 40 | EGWE | Packaging gross weight limited quantity (mass) | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_EGWE | |
| 41 | UEGWE | Unit of measurement (ltd. quantity packaging gross weight) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UEGWE | Allow NULL? |
| 42 | EERSP | Permissibility of Single Packaging (Limited Quantities) | char | 1 | 0 | CHAR | (N' ') | Yes | | THME_EERSP | Allow NULL? |
| 43 | ESPA | Max. Single Packaging Limited Quantity (Quantity/Volume) | decimal | 8 | 2 | QUAN | ((0)) | Yes | | THME_ESPA | |
| 44 | UESPA | Unit of Measurement (Ltd. Quantity Max. Single Packaging) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | THME_UESPA | Allow NULL? |
| 45 | DAOR | Data Origin (Filling and Distribution) | char | 1 | 0 | CHAR | (N' ') | Yes | | ADGE_DAOR | Allow NULL? |
