SAP ABAP View DGV_DGTPKDB (DG: Read DGTPK)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ EHS-DGP (Application Component) Dangerous Goods Management
⤷ CBDG (Package) PI-EH&S Dangerous Goods Management
⤷ EHS-DGP (Application Component) Dangerous Goods Management
⤷ CBDG (Package) PI-EH&S Dangerous Goods Management
Basic Data
View Type | D | Database View |
Database View | DGV_DGTPKDB | |
Short Description | DG: Read DGTPK | |
Root table | DGTMD | DG: Dangerous Goods Master |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | DGTMD | DGTMD | ||
2 | DGTPK |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | DGTMD | MANDT | JL | EQ | 0 | 0 | ||||
2 | DGTPK | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | DGTMD | RECN | JL | EQ | 0 | 0 | ||||
4 | DGTPK | RECMAST | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | * | DGTPK | * | |||||
2 | MANDT | DGTPK | MANDT | MANDT | Client | |||
3 | RECN | DGTPK | RECN | ESERECN | Sequential Number of Data Record | |||
4 | ACTN | DGTPK | ACTN | ESEACTN | Sequential Number of the Change State | |||
5 | VALFR | DGTPK | VALFR | ESEVALFR | Valid-From Date | |||
6 | VALTO | DGTPK | VALTO | ESEVALTO | Valid-To Date | |||
7 | AENNR | DGTPK | AENNR | ESEAENNR | Change Number | |||
8 | DELFLG | DGTPK | DELFLG | ADGE_DELFLG | Deletion Indicator | |||
9 | PARKFLG | DGTPK | PARKFLG | ESEPARKFLG | Data Record Is Inactive | |||
10 | CRDAT | DGTPK | CRDAT | ESECRDAT | Created On | |||
11 | CRNAM | DGTPK | CRNAM | ESECRNAM | Created By | |||
12 | UPDDAT | DGTPK | UPDDAT | ESEUPDDAT | Changed On | |||
13 | UPDNAM | DGTPK | UPDNAM | ESEUPDNAM | Last Changed By | |||
14 | SRSID | DGTPK | SRSID | ESESRSID | Source of Data | |||
15 | OWNID | DGTPK | OWNID | ESEVENDRID | Data Provider | |||
16 | RECNROOT | DGTPK | RECNROOT | ESERECN | Sequential Number of Data Record | |||
17 | RECMAST | DGTPK | RECMAST | ESERECNMST | Reference to Master Table | |||
18 | PACOD | DGTPK | PACOD | THME_PACOD | Packaging Code | |||
19 | PERIP | DGTPK | PERIP | THME_PERIP | Permissibility of Inner Packaging | |||
20 | IPMQU | DGTPK | IPMQU | THME_IPMQU | Inner Packaging: Maximum Quantity / Volume | |||
21 | UIPMQ | DGTPK | UIPMQ | THME_UIPMQ | Unit of measure for inner packaging: max. quantity/volume | |||
22 | PEROP | DGTPK | PEROP | THME_PEROP | Permissibility of Outer Packaging | |||
23 | OPMQU | DGTPK | OPMQU | THME_OPMQU | Outer Packaging: Maximum Quantity / Volume | |||
24 | UOPMQ | DGTPK | UOPMQ | THME_UOPMQ | Unit for maximum quantity / volume of outer package | |||
25 | TOGWE | DGTPK | TOGWE | THME_TOGWE | Maximum Gross Weight | |||
26 | UTOGW | DGTPK | UTOGW | THME_UTOGW | Unit for packaging gross weight | |||
27 | PERSP | DGTPK | PERSP | THME_PERSP | Permissibility of Single Packaging | |||
28 | SPAQU | DGTPK | SPAQU | THME_SPAQU | Single Packaging: Maximum Quantity / Volume | |||
29 | USPAQ | DGTPK | USPAQ | THME_USPAQ | Unit for single packaging: max. quantity / volume | |||
30 | IPALL | DGTPK | IPALL | THME_IPALL | Pallet / Skeleton Container | |||
31 | AGAUN | DGTPK | AGAUN | THME_AGAUN | Agreement of Authorities Required | |||
32 | REGNO | DGTPK | REGNO | ADGE_REGNO | Approval no. | |||
33 | AGRNO | DGTPK | AGRNO | ADGE_AGRNO | Exception and Agreement Number | |||
34 | PAWOS | DGTPK | PAWOS | THME_WOS | Processing Status for Basic Data and Master Data | |||
35 | EERIP | DGTPK | EERIP | THME_EERIP | Permissibility of Inner Packaging (Limited Quantities) | |||
36 | EIPA | DGTPK | EIPA | THME_EIPA | Maximum Inner Packaging - Limited Quantity (Qty/Volume) | |||
37 | UEIPA | DGTPK | UEIPA | THME_UEIPA | Unit of Measurement (Ltd. Quantity Max. Inner Packaging) | |||
38 | EEROP | DGTPK | EEROP | THME_EEROP | For limited quantities: max. outer package (limited qty) | |||
39 | EOPA | DGTPK | EOPA | THME_EOPA | Maximum Outer Packaging - Limited Quantity (Qty/Volume) | |||
40 | UEOPA | DGTPK | UEOPA | THME_UEOPA | Unit of measurement (ltd. quantity max. outer package) | |||
41 | EGWE | DGTPK | EGWE | THME_EGWE | Packaging gross weight limited quantity (mass) | |||
42 | UEGWE | DGTPK | UEGWE | THME_UEGWE | Unit of measurement (ltd. quantity packaging gross weight) | |||
43 | EERSP | DGTPK | EERSP | THME_EERSP | Permissibility of Single Packaging (Limited Quantities) | |||
44 | ESPA | DGTPK | ESPA | THME_ESPA | Max. Single Packaging Limited Quantity (Quantity/Volume) | |||
45 | UESPA | DGTPK | UESPA | THME_UESPA | Unit of Measurement (Ltd. Quantity Max. Single Packaging) | |||
46 | DAOR | DGTPK | DAOR | ADGE_DAOR | Data Origin (Filling and Distribution) | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |