LIPSDG SAP (Appendix Table for Dangerous Goods Data) Table details

Dictionary Type: Table
Description: Appendix Table for Dangerous Goods Data




ABAP Code to SELECT data from LIPSDG
Related tables to LIPSDG
Access table LIPSDG




Table field list including key, data, relationships and ABAP select examples

LIPSDG is a standard SAP Table which is used to store Appendix Table for Dangerous Goods Data data and is available within R/3 SAP systems depending on the version and release level.

The LIPSDG table consists of various fields, each holding specific information or linking keys about Appendix Table for Dangerous Goods Data data available in SAP. These include VBELN (Delivery), POSNR (Delivery Item), DGNTGEW (Dangerous goods - net weight), DGBRGEW (Dangerous Goods - Gross Weight).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP LIPSDG table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6VBUPPOSNR
DGNTGEWDangerous goods - net weight ADGE_NTGEWQUAN15(3) MENG15
DGBRGEWDangerous Goods - Gross Weight ADGE_BRGEWQUAN15(3) MENG15
DGGEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
DGVOLUMDangerous goods - volume ADGE_VOLUMQUAN15(3) MENG15
DGVOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
DGARANDExemption ADGE_KARNCHAR1X
DGREPQUIndicator: Reportable quantity ADGE_IRQACHAR1X
DGPULIMPacked Under 450 l ADGE_IPULCHAR1X
DGPASListed Goods ADGE_PASCHAR1X
DGMANNot Overwritten by Check Methods ADGE_MANCHAR1X
DGMANRQNot Overwritten by Check Methods ADGE_MANCHAR1X
DGMANLIMNot Overwritten by Check Methods ADGE_MANCHAR1X
DGMANLGNot Overwritten by Check Methods ADGE_MANCHAR1X
DGMDDATSelection date dangerous goods master data ADGE_MDDATDATS8DATUM
DGARANDPRRegulation Profile for Exemption ADGE_RPRARCHAR4TDGD1ADGD_PROFILE
DGREPQUPRRegulation Profile for Reportable Quantity ADGE_RPRRQCHAR4TDGD1ADGD_PROFILE
DGPULIMPRRegulation Profile for Exemption: Highly Viscous (< 450 l) ADGE_RPRPUCHAR4TDGD1ADGD_PROFILE
DGPASPRRegulation Profile for Listed Goods ADGE_RPRP7CHAR4TDGD1ADGD_PROFILE
DGCHKARDangerous Goods Checks Performed for Exemption ADGE_CHKARCHAR1X
DGCHKRQDangerous Goods Checks Run for Reportable Quantity ADGE_CHKRQCHAR1X
DGCHKPUDangerous Goods Checks Run for Exemption: Highly Viscous ADGE_CHKPUCHAR1X
DGCHKLGDangerous Goods Checks Performed for Listed Goods ADGE_CHKLGCHAR1X
RANDNUMMERTotal Chapter 1.1.3.6 for ADR/ADNR ADGE_RANDNRNUMC6ADGE_DRANDNR
DRIVERSPRASLanguage Key for Driver ADGE_LKDRIVLANG1T002ISOLASPRAS
CODRIVERSPRASLanguage Key for Driver ADGE_LKDRIVLANG1T002ISOLASPRAS
TRANSP_INDEXTransport Index EHS_ADGE_TRANSP_INDEXDEC7(2) DEC5_2
CRIT_SAF_INDEXCriticality Safety Index EHS_ADGE_CRIT_SAF_INDEXDEC7(2) DEC5_2
PACKAGE_CATCategory of Package EHS_ADGE_PACKAGE_CATCHAR15EHS_ADGD_PACKAGE_CAT
ACTVTY_SINGLE_A2Single Activity as Multiple of A2 Value EHS_ADGE_ACTVTY_SINGLE_A2DEC9(2) DEC7_2
ACTVTY_TOTAL_A2Total Activity as Multiple of A2 Value EHS_ADGE_ACTVTY_TOTAL_A2DEC10(2) DEC10_2
EXPL_NET_SUMTotal Net Explosive Substance Mass EHS_ADGE_EXPL_NET_SUMQUAN9(2) ADGD_Q92
EXPL_NET_SUM_UUnit for Net Explosive Substance Mass EHS_ADGE_EXPL_NET_UUNIT3Assigned to domainCUNITMEINS
DGEXCQUExcepted Quantity ADGE_EXC_QUANTCHAR1X
DGMANEQNot Overwritten by Check Methods ADGE_MANCHAR1X
DGCHKEQDangerous Goods Checks Performed for Excepted Quantity ADGE_EXC_QUANT_CHKCHAR1X
DGEXCQUPRRegulation Profile for Excepted Quantity ADGE_EXC_QUANT_PRFCHAR4TDGD1ADGD_PROFILE
DGSUP_TRANSIND01Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND02Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND03Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND04Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND05Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND06Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND07Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
DGSUP_TRANSIND08Indicator for Transport ADGE_TRANSPORT_INDICATORCHAR10TDG103ADGD_TRANSPORT_INDICATOR
TRANSIND_MAN_01Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_02Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_03Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_04Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_05Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_06Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_07Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_MAN_08Not Overwritten by Check Methods ADGE_MANCHAR1X
TRANSIND_CHK_01Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_02Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_03Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_04Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_05Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_06Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_07Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_CHK_08Indicator for Transport Set by Dangerous Goods Check ADGE_TRANSPORT_INDICATOR_CHKCHAR1X
TRANSIND_DESC_01Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_02Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_03Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_04Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_05Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_06Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_07Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT
TRANSIND_DESC_08Description of Indicator for Transport ADGE_TRANSPORT_INDICATORDCHAR132HMD_STXT

Key field Non-key field



How do I retrieve data from SAP table LIPSDG using ABAP code

The following ABAP code Example will allow you to do a basic selection on LIPSDG to SELECT all data from the table
DATA: WA_LIPSDG TYPE LIPSDG.

SELECT SINGLE *
FROM LIPSDG
INTO CORRESPONDING FIELDS OF WA_LIPSDG
WHERE...

How to access SAP table LIPSDG

Within an ECC or HANA version of SAP you can also view further information about LIPSDG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!