SAP VBEPDG Appendix Table for Dangerous Goods Data Table
Overview
VBEPDG is a standard SAP S/4HANA table that stores Appendix Table for Dangerous Goods Data data. There are total 58 fields in the VBEPDG table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBEPDG belongs to Environment, Health and Safety (EHS) module and is located in the package EH&S: Interface Objects (CBEHS).
In addition, following links provide an overview of foreign key relationships, if any, that link VBEPDG to other SAP tables and standard CDS views available based on VBEPDG table in S/4HANA 2020.
Techincal Settings of VBEPDG
Below are technical details of the table VBEPDG
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBEPDG Fields
The following table gives you an overview of the fields available in VBEPDG
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales Document | VBELN_VA | CHAR | 10 | |
| POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| ETENR | Schedule Line Number | ETENR | NUMC | 4 | |
| DGARAND | Exemption | ADGE_KARN | CHAR | 1 | |
| DGREPQU | Indicator: Reportable quantity | ADGE_IRQA | CHAR | 1 | |
| DGPULIM | Packed Under 450 l | ADGE_IPUL | CHAR | 1 | |
| DGPAS | Listed Goods | ADGE_PAS | CHAR | 1 | |
| DGMAN | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| DGMDDAT | Selection date dangerous goods master data | ADGE_MDDAT | DATS | 8 | |
| DGMDDAT1 | Selection date for dangerous goods data (valid to) | ADGE_MDDAT1 | DATS | 8 | |
| DGARANDPR | Regulation Profile for Exemption | ADGE_RPRAR | TDGD1 | CHAR | 4 |
| DGREPQUPR | Regulation Profile for Reportable Quantity | ADGE_RPRRQ | TDGD1 | CHAR | 4 |
| DGPULIMPR | Regulation Profile for Exemption: Highly Viscous (< 450 l) | ADGE_RPRPU | TDGD1 | CHAR | 4 |
| DGPASPR | Regulation Profile for Listed Goods | ADGE_RPRP7 | TDGD1 | CHAR | 4 |
| DGCHKAR | Dangerous Goods Checks Performed for Exemption | ADGE_CHKAR | CHAR | 1 | |
| DGCHKRQ | Dangerous Goods Checks Run for Reportable Quantity | ADGE_CHKRQ | CHAR | 1 | |
| DGCHKPU | Dangerous Goods Checks Run for Exemption: Highly Viscous | ADGE_CHKPU | CHAR | 1 | |
| DGCHKLG | Dangerous Goods Checks Performed for Listed Goods | ADGE_CHKLG | CHAR | 1 | |
| DGMANRQ | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| DGMANLIM | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| DGMANLG | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| DGEXCQU | Excepted Quantity | ADGE_EXC_QUANT | CHAR | 1 | |
| DGMANEQ | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| DGCHKEQ | Dangerous Goods Checks Performed for Excepted Quantity | ADGE_EXC_QUANT_CHK | CHAR | 1 | |
| DGEXCQUPR | Regulation Profile for Excepted Quantity | ADGE_EXC_QUANT_PRF | TDGD1 | CHAR | 4 |
| DGSUP_TRANSIND01 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND02 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND03 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND04 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND05 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND06 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND07 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| DGSUP_TRANSIND08 | Indicator for Transport | ADGE_TRANSPORT_INDICATOR | TDG103 | CHAR | 10 |
| TRANSIND_MAN_01 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_02 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_03 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_04 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_05 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_06 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_07 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_MAN_08 | Not Overwritten by Check Methods | ADGE_MAN | CHAR | 1 | |
| TRANSIND_CHK_01 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_02 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_03 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_04 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_05 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_06 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_07 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_CHK_08 | Indicator for Transport Set by Dangerous Goods Check | ADGE_TRANSPORT_INDICATOR_CHK | CHAR | 1 | |
| TRANSIND_DESC_01 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_02 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_03 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_04 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_05 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_06 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_07 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 | |
| TRANSIND_DESC_08 | Description of Indicator for Transport | ADGE_TRANSPORT_INDICATORD | CHAR | 132 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBEPDG
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBEPDG | DGARANDPR | : | TDGD1 |
| VBEPDG | DGEXCQUPR | : | TDGD1 |
| VBEPDG | DGPASPR | : | TDGD1 |
| VBEPDG | DGPULIMPR | : | TDGD1 |
| VBEPDG | DGREPQUPR | : | TDGD1 |
| VBEPDG | DGSUP_TRANSIND01 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND02 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND03 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND04 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND05 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND06 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND07 | : | TDG103 |
| VBEPDG | DGSUP_TRANSIND08 | : | TDG103 |
| VBEPDG | MANDT | : | T000 |