SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | DGTM2
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Cross-Application Components :: General Application Functions :: Environment, Health and Safety Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DGTM22171DG: Dangerous Goods Master (App. Table)Environment, Health and Safety Master Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, RECN, ACTN, PDGNUD, PRES1, PRES2, PRES3, PREMP1, PRERQ1, PRERQ2, PSTOSU, PDAIN1, PDAIN2, PDAIN3, PDAIN4, PDAIN5, PDAIN6, PDAIN7, PDAIN8, PDAIN9, PDAIN10, MIOWA, UMIOW, PHYGRO, PDGF1, PDGF2, PDGF3, PDGF4, PDGF5, PDGF6, PDGF7, PDGF8, PDGF9, PDGFA, PDGFB, PDGFC, PDGFD, PDGFE, PDGFF, PTXTPATT, MSEPR1, MSEPR2, MSEPR3, MSEPR4, MSEPR5, MSEPR6, MSEPR7, MSEPR8, MSEPR9, MSEPRA, MSEPRB, MSEPRC, MSEPRD, MSEPRE, MSEPRF, MSEPRG, MSEPRH, MLOAR1, MLOAR2, MLOAR3, MLOAR4, MLOAR5, MLOAR6, MLOAR7, MLOAR8, MLOAR9, MLOARA, RSMLG1, RSMLG2, RSMLG3, ESMLG1, ESMLG2, ESMLG3, PREMP2, RQA2, RQU2, PPDG1, PPDG2, PPDG3, PPDG4, PPDG5, PPDG6, PPDG7, PPDG8, PPDG9, PPDGA, PPDGB, PPDGC, PPDGE, PPDGF, PPDGG, DAOR, FORM_PHYS_CHEM, EXPL_NET, EXPL_NET_U, EXPL_REL_PERCENT, ACTVTY_MAX, ACTVTY_MAX_U, ACTVTY_MAX_REL, ACTVTY_MAX_REL_U, LTSK, EMV, FSAK, SFK, MUNAKODE, EXNUMBER, CERTIFIC, HAZCHEM_CODE, FLG_EMSN1_U, FLG_EMSN2_U, STOWAGE, CARR_TYPE, FLG_PAI, FLG_PAO, FLG_PASI, FLG_PAGW, FLG_RELQ, FLG_MULRQ, FLG_RELQ_UNLIMIT, FLG_MULRQ_FORBID, PDGNUDPRE, PDGNUDSUF, TEXTPATT_PROF01, TEXTPATT01, TEXTPATT_PROF02, TEXTPATT02, TEXTPATT_PROF03, TEXTPATT03, TEXTPATT_PROF04, TEXTPATT04, TEXTPATT_PROF05, TEXTPATT05, TEXTPATT_PROF06, TEXTPATT06, TEXTPATT_PROF07, TEXTPATT07, TEXTPATT_PROF08, TEXTPATT08, TEXTPATT_PROF09, TEXTPATT09, TEXTPATT_PROF10, TEXTPATT10, TEXTPATT_PROF11, TEXTPATT11, TEXTPATT_PROF12, TEXTPATT12, TEXTPATT_PROF13, TEXTPATT13, TEXTPATT_PROF14, TEXTPATT14, TEXTPATT_PROF15, TEXTPATT15, ABS_ACT, ABS_ACT_U, REL_SPEC_ACT, REL_SPEC_ACT_U, CONTAMINATION, CONTAMINATION_U, DOSE_RATE, DOSE_RATE_U, MAX_ACT1, MAX_ACT1_U, ACT1_UNLIMIT, MAX_ACT2, MAX_ACT2_U, ACT2_UNLIMIT, ACT_SUB_PACK, ACT_SUB_PACK_U, MAX_ACT_CONSG, MAX_ACT_CONSG_U, MULT_ACT_SGL, REF_ACT_SGL, MULT_ACT_PACK, REF_ACT_PACK, MAX_CONT_A, MAX_CONT_A_U, MAX_CONT_B_G, MAX_CONT_B_G_U, MAX_DOSE_UNP, MAX_DOSE_UNP_U, DIST_DOSE_UNP, DIST_DOSE_UNP_U, NO_DIST_UNP, MAX_DOSE_PACK, MAX_DOSE_PACK_U, DIST_DOSE_PACK, DIST_DOSE_PACK_U, NO_DIST_PACK, MAX_ACT_SGL_DC, MAX_ACT_SGL_U_DC, ACT_SGL_UNLIM_DC, MAX_ACT_PAC_DC, MAX_ACT_PAC_U_DC, ACT_PAC_UNLIM_DC, EXCPT_PAC_OPT_DC, MAX_GRS_WGHT_DC, U_MAX_GRS_WGT_DC, EXCEPTID01, EXCEPTID02, EXCEPTID03, EXCEPTID04, EXCEPTID05, EXCEPTID06, EXCEPTID07, EXCEPTID08, EXCEPTID09, EXCEPTID10, ACT_EMIS_TYPE, MAX_NEM_DC, MAX_NEM_U_DC, PINEQ, EXC_QUANT_IP, EXC_QUANT_IP_U, EXC_QUANT_OP, EXC_QUANT_OP_U, FLG_EXC_QUANT_IP, FLG_EXC_QUANT_OP FROM DGTM2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RECNSequential Number of Data Recordnvarchar200NUMC(N'00000000000000000000')NoESERECN Allow NULL? 
3ACTNSequential Number of the Change Statenvarchar200NUMC(N'00000000000000000000')NoESEACTN Allow NULL? 
4PDGNUDDangerous Goods Descriptionnvarchar210CHAR(N' ')YesADGE_PDGND Allow NULL? 
5PRES1Hazard-Inducing Substancenvarchar210CHAR(N' ')YesADGE_PRES Allow NULL? 
6PRES2Hazard-Inducing Substancenvarchar210CHAR(N' ')YesADGE_PRES Allow NULL? 
7PRES3Hazard-Inducing Substancenvarchar210CHAR(N' ')YesADGE_PRES Allow NULL? 
8PREMP1Hazard-inducing substance (marine pollutant)nvarchar210CHAR(N' ')YesADGE_PRMP Allow NULL? 
9PRERQ1Hazard-inducing substance (reportable quantity)nvarchar210CHAR(N' ')YesADGE_PRRQ Allow NULL? 
10PRERQ2Hazard-inducing substance (reportable quantity)nvarchar210CHAR(N' ')YesADGE_PRRQ Allow NULL? 
11PSTOSUAggregate State for Transportnvarchar210CHAR(N' ')YesADGE_PSTOS Allow NULL? 
12PDAIN1Hazard Note 1nvarchar210CHAR(N' ')YesADGE_PDAI1 Allow NULL? 
13PDAIN2Hazard Note 2nvarchar210CHAR(N' ')YesADGE_PDAI2 Allow NULL? 
14PDAIN3Hazard Note 3nvarchar210CHAR(N' ')YesADGE_PDAI3 Allow NULL? 
15PDAIN4Hazard Note 4nvarchar210CHAR(N' ')YesADGE_PDAI4 Allow NULL? 
16PDAIN5Hazard Note 5nvarchar210CHAR(N' ')YesADGE_PDAI5 Allow NULL? 
17PDAIN6Hazard Note 6nvarchar210CHAR(N' ')YesADGE_PDAI6 Allow NULL? 
18PDAIN7Hazard Note 7nvarchar210CHAR(N' ')YesADGE_PDAI7 Allow NULL? 
19PDAIN8Hazard Note 8nvarchar210CHAR(N' ')YesADGE_PDAI8 Allow NULL? 
20PDAIN9Hazard Note 9nvarchar210CHAR(N' ')YesADGE_PDAI9 Allow NULL? 
21PDAIN10Hazard Note 10nvarchar210CHAR(N' ')YesADGE_PDAIA Allow NULL? 
22MIOWAMiscibility with Waterdecimal82QUAN((0))YesADGE_MIOWA
23UMIOWUnit for Miscibility with Waternvarchar30UNIT(N' ')YesT006ADGE_UMIOW Allow NULL? 
24PHYGROHygroscopicitynvarchar210CHAR(N' ')YesADGE_PHYGR Allow NULL? 
25PDGF1User-Defined Text Key 1nvarchar210CHAR(N' ')YesADGE_PDGF1 Allow NULL? 
26PDGF2User-Defined Text Key 2nvarchar210CHAR(N' ')YesADGE_PDGF2 Allow NULL? 
27PDGF3User-Defined Text Key 3nvarchar210CHAR(N' ')YesADGE_PDGF3 Allow NULL? 
28PDGF4User-Defined Text Key 4nvarchar210CHAR(N' ')YesADGE_PDGF4 Allow NULL? 
29PDGF5User-Defined Text Key 5nvarchar210CHAR(N' ')YesADGE_PDGF5 Allow NULL? 
30PDGF6User-Defined Text Key 6nvarchar210CHAR(N' ')YesADGE_PDGF6 Allow NULL? 
31PDGF7User-Defined Text Key 7nvarchar210CHAR(N' ')YesADGE_PDGF7 Allow NULL? 
32PDGF8User-Defined Text Key 8nvarchar210CHAR(N' ')YesADGE_PDGF8 Allow NULL? 
33PDGF9User-Defined Text Key 9nvarchar210CHAR(N' ')YesADGE_PDGF9 Allow NULL? 
34PDGFAUser-Defined Text Key 10nvarchar210CHAR(N' ')YesADGE_PDGFA Allow NULL? 
35PDGFBUser-Defined Text Key 11nvarchar210CHAR(N' ')YesADGE_PDGFB Allow NULL? 
36PDGFCUser-Defined Text Key 12nvarchar210CHAR(N' ')YesADGE_PDGFC Allow NULL? 
37PDGFDUser-Defined Text Key 13nvarchar210CHAR(N' ')YesADGE_PDGFD Allow NULL? 
38PDGFEUser-Defined Text Key 14nvarchar210CHAR(N' ')YesADGE_PDGFE Allow NULL? 
39PDGFFUser-Defined Text Key 15nvarchar210CHAR(N' ')YesADGE_PDGFF Allow NULL? 
40PTXTPATTDangerous Goods Text Patternnvarchar210CHAR(N' ')YesADGE_PTXTPATT Allow NULL? 
41MSEPR1Segregation Key 1nvarchar40CHAR(N' ')YesTHM091THME_DYKY1 Allow NULL? 
42MSEPR2Segregation Key 2nvarchar40CHAR(N' ')YesTHM091THME_DYKY2 Allow NULL? 
43MSEPR3Segregation Key 3nvarchar40CHAR(N' ')YesTHM091THME_DYKY3 Allow NULL? 
44MSEPR4Segregation Key 4nvarchar40CHAR(N' ')YesTHM091THME_DYKY4 Allow NULL? 
45MSEPR5Segregation Key 5nvarchar40CHAR(N' ')YesTHM091THME_DYKY5 Allow NULL? 
46MSEPR6Segregation Key 6nvarchar40CHAR(N' ')YesTHM091THME_DYKY6 Allow NULL? 
47MSEPR7Segregation Key 7nvarchar40CHAR(N' ')YesTHM091THME_DYKY7 Allow NULL? 
48MSEPR8Segregation Key 8nvarchar40CHAR(N' ')YesTHM091THME_DYKY8 Allow NULL? 
49MSEPR9Segregation Key 9nvarchar40CHAR(N' ')YesTHM091THME_DYKY9 Allow NULL? 
50MSEPRASegregation Key 10nvarchar40CHAR(N' ')YesTHM091THME_DYKYA Allow NULL? 
51MSEPRBSegregation Key 11nvarchar40CHAR(N' ')YesTHM091THME_DYKYB Allow NULL? 
52MSEPRCSegregation Key 12nvarchar40CHAR(N' ')YesTHM091THME_DYKYC Allow NULL? 
53MSEPRDSegregation Key 13nvarchar40CHAR(N' ')YesTHM091THME_DYKYD1 Allow NULL? 
54MSEPRESegregation Key 14nvarchar40CHAR(N' ')YesTHM091THME_DYKYE Allow NULL? 
55MSEPRFSegregation Key 15nvarchar40CHAR(N' ')YesTHM091THME_DYKYF Allow NULL? 
56MSEPRGSegregation Key 16nvarchar40CHAR(N' ')YesTHM091THME_DYKYG Allow NULL? 
57MSEPRHSegregation Key 17nvarchar40CHAR(N' ')YesTHM091THME_DYKYH Allow NULL? 
58MLOAR1Mixed Loading Rule 1nvarchar60CHAR(N' ')YesTHM097THME_MLOAR1 Allow NULL? 
59MLOAR2Mixed Loading Rule 2nvarchar60CHAR(N' ')YesTHM097THME_MLOAR2 Allow NULL? 
60MLOAR3Mixed Loading Rule 3nvarchar60CHAR(N' ')YesTHM097THME_MLOAR3 Allow NULL? 
61MLOAR4Mixed Loading Rule 4nvarchar60CHAR(N' ')YesTHM097THME_MLOAR4 Allow NULL? 
62MLOAR5Mixed Loading Rule 5nvarchar60CHAR(N' ')YesTHM097THME_MLOAR5 Allow NULL? 
63MLOAR6Mixed Loading Rule 6nvarchar60CHAR(N' ')YesTHM097THME_MLOAR6 Allow NULL? 
64MLOAR7Mixed Loading Rule 7nvarchar60CHAR(N' ')YesTHM097THME_MLOAR7 Allow NULL? 
65MLOAR8Mixed Loading Rule 8nvarchar60CHAR(N' ')YesTHM097THME_MLOAR8 Allow NULL? 
66MLOAR9Mixed Loading Rule 9nvarchar60CHAR(N' ')YesTHM097THME_MLOAR9 Allow NULL? 
67MLOARAMixed Loading Rule 10nvarchar60CHAR(N' ')YesTHM097THME_MLOARA Allow NULL? 
68RSMLG1Regulation-Dependent Mixed Loading Group 1nvarchar40CHAR(N' ')YesTHM101THME_RSMLG1 Allow NULL? 
69RSMLG2Regulation-Dependent Mixed Loading Group 2nvarchar40CHAR(N' ')YesTHM101THME_RSMLG2 Allow NULL? 
70RSMLG3Regulation-Dependent Mixed Loading Group 3nvarchar40CHAR(N' ')YesTHM101THME_RSMLG3 Allow NULL? 
71ESMLG1Enterprise-Specific Mixed Loading Group 1nvarchar40CHAR(N' ')YesTHM103THME_ESMLG1 Allow NULL? 
72ESMLG2Enterprise-Specific Mixed Loading Group 2nvarchar40CHAR(N' ')YesTHM103THME_ESMLG2 Allow NULL? 
73ESMLG3Enterprise-Specific Mixed Loading Group 3nvarchar40CHAR(N' ')YesTHM103THME_ESMLG3 Allow NULL? 
74PREMP2Hazard-inducing substance (marine pollutant)nvarchar210CHAR(N' ')YesADGE_PRMP Allow NULL? 
75RQA2Reportable Quantitydecimal82QUAN((0))YesADGE_RQA
76RQU2Unit of measure for reportable quantitiesnvarchar30UNIT(N' ')YesT006ADGE_RQU Allow NULL? 
77PPDG1Profile for Dangerous Goods User-Defined Text 1nvarchar20CHAR(N' ')YesTHME_PPDG1 Allow NULL? 
78PPDG2Profile for Dangerous Goods User-Defined Text 2nvarchar20CHAR(N' ')YesTHME_PPDG2 Allow NULL? 
79PPDG3Profile for Dangerous Goods User-Defined Text 3nvarchar20CHAR(N' ')YesTHME_PPDG3 Allow NULL? 
80PPDG4Profile for Dangerous Goods User-Defined Text 4nvarchar20CHAR(N' ')YesTHME_PPDG4 Allow NULL? 
81PPDG5Profile for Dangerous Goods User-Defined Text 5nvarchar20CHAR(N' ')YesTHME_PPDG5 Allow NULL? 
82PPDG6Profile for Dangerous Goods User-Defined Text 6nvarchar20CHAR(N' ')YesTHME_PPDG6 Allow NULL? 
83PPDG7Profile for Dangerous Goods User-Defined Text 7nvarchar20CHAR(N' ')YesTHME_PPDG7 Allow NULL? 
84PPDG8Profile for Dangerous Goods User-Defined Text 8nvarchar20CHAR(N' ')YesTHME_PPDG8 Allow NULL? 
85PPDG9Profile for Dangerous Goods User-Defined Text 9nvarchar20CHAR(N' ')YesTHME_PPDG9 Allow NULL? 
86PPDGAProfile for Dangerous Goods User-Defined Text 10nvarchar20CHAR(N' ')YesTHME_PPDGA Allow NULL? 
87PPDGBProfile for Dangerous Goods User-Defined Text 11nvarchar20CHAR(N' ')YesTHME_PPDGB Allow NULL? 
88PPDGCProfile for Dangerous Goods User-Defined Text 12nvarchar20CHAR(N' ')YesTHME_PPDGC Allow NULL? 
89PPDGEProfile for Dangerous Goods User-Defined Text 13nvarchar20CHAR(N' ')YesTHME_PPDGE Allow NULL? 
90PPDGFProfile for Dangerous Goods User-Defined Text 14nvarchar20CHAR(N' ')YesTHME_PPDGF Allow NULL? 
91PPDGGProfile for Dangerous Goods User-Defined Text 15nvarchar20CHAR(N' ')YesTHME_PPDGG Allow NULL? 
92DAORData Origin (Filling and Distribution)char10CHAR(N' ')YesADGE_DAOR Allow NULL? 
93FORM_PHYS_CHEMPhysical and Chemical Formnvarchar210CHAR(N' ')YesEHS_ADGE_FORM_PHYS_CHEM Allow NULL? 
94EXPL_NETNet Explosive Substance Massdecimal93QUAN((0))YesEHS_ADGE_EXPL_NET
95EXPL_NET_UUnit for Net Explosive Substance Massnvarchar30UNIT(N' ')YesT006EHS_ADGE_EXPL_NET_U Allow NULL? 
96EXPL_REL_PERCENTRelative Net Explosive Substance Percentagedecimal63DEC((0))YesEHS_ADGE_EXPL_REL_PERCENT
97ACTVTY_MAXMaximum Activitydecimal82QUAN((0))YesEHS_ADGE_ACTVTY_MAX
98ACTVTY_MAX_UUnit of Maximum Activitynvarchar30UNIT(N' ')YesT006EHS_ADGE_ACTVTY_MAX_U Allow NULL? 
99ACTVTY_MAX_RELRelative Maximum Activitydecimal82QUAN((0))YesEHS_ADGE_ACTVTY_MAX_REL
100ACTVTY_MAX_REL_UUnit of Relative Maximum Activitynvarchar30UNIT(N' ')YesT006EHS_ADGE_ACTVTY_MAX_REL_U Allow NULL? 
101LTSKAir Transport Safety Codechar10CHAR(N' ')YesEHS_ADGE_LTSK Allow NULL? 
102EMVElectromagnetic Compatibilitychar10CHAR(N' ')YesEHS_ADGE_EMV Allow NULL? 
103FSAKParachute Drop Codechar10CHAR(N' ')YesEHS_ADGE_FSAK Allow NULL? 
104SFKThrust Codechar10CHAR(N' ')YesEHS_ADGE_SFK Allow NULL? 
105MUNAKODEAmmunition Codenvarchar40CHAR(N' ')YesEHS_ADGE_MUNAKODE Allow NULL? 
106EXNUMBEREX-Numbernvarchar120CHAR(N' ')YesEHS_ADGE_EXNUMBER Allow NULL? 
107CERTIFICIdentification Mark for Approval Certificatenvarchar210CHAR(N' ')YesEHS_ADGE_APPROV_CERTIFIC Allow NULL? 
108HAZCHEM_CODECode for Chemical Hazardnvarchar100CHAR(N' ')YesCBDUE_HAZCHEM_CODE Allow NULL? 
109FLG_EMSN1_UEmS Number 1 Underlinedchar10CHAR(N' ')YesCBDUE_FLG_EMSN1_U Allow NULL? 
110FLG_EMSN2_UEmS Number 2 Underlinedchar10CHAR(N' ')YesCBDUE_FLG_EMSN2_U Allow NULL? 
111STOWAGEStowage Categorynvarchar30CHAR(N' ')YesCCUNC111CBDUE_STOWAGE Allow NULL? 
112CARR_TYPETransport Categorynvarchar30CHAR(N' ')YesCBDUE_CARR_TYPE Allow NULL? 
113FLG_PAIValue Entered for Limited Quantity (LQ) Inner Packagingchar10CHAR(N' ')YesCBDUE_FLG_PAI Allow NULL? 
114FLG_PAOValue Entered for Limited Quantity (LQ) Outer Packagingchar10CHAR(N' ')YesCBDUE_FLG_PAO Allow NULL? 
115FLG_PASIValue Entered for Maximum Quantity per Packagechar10CHAR(N' ')YesCBDUE_FLG_PASI Allow NULL? 
116FLG_PAGWValue Entered for Limited Quantity (LQ) Gross Weightchar10CHAR(N' ')YesCBDUE_FLG_PAGW Allow NULL? 
117FLG_RELQValue Entered for Exemptionchar10CHAR(N' ')YesCBDUE_FLG_RELQ Allow NULL? 
118FLG_MULRQValue Entered for Multiplication Factorchar10CHAR(N' ')YesCBDUE_FLG_MULRQ Allow NULL? 
119FLG_RELQ_UNLIMITUnlimited Set for Exemptionchar10CHAR(N' ')YesCBDUE_FLG_RELQ_UNLIMIT Allow NULL? 
120FLG_MULRQ_FORBIDProhibited Set for Multiplication Factorchar10CHAR(N' ')YesCBDUE_FLG_MULRQ_FORBID Allow NULL? 
121PDGNUDPREDangerous Goods Description Prefixnvarchar210CHAR(N' ')YesCBDUE_PDGNUDPRE Allow NULL? 
122PDGNUDSUFDangerous Goods Description Suffixnvarchar210CHAR(N' ')YesCBDUE_PDGNUDSUF Allow NULL? 
123TEXTPATT_PROF01Text Pattern Profile 01nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF01 Allow NULL? 
124TEXTPATT01Dangerous Goods Text Pattern 01nvarchar210CHAR(N' ')YesADGE_PTXTPATT01 Allow NULL? 
125TEXTPATT_PROF02Text Pattern Profile 02nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF02 Allow NULL? 
126TEXTPATT02Dangerous Goods Text Pattern 02nvarchar210CHAR(N' ')YesADGE_PTXTPATT02 Allow NULL? 
127TEXTPATT_PROF03Text Pattern Profile 03nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF03 Allow NULL? 
128TEXTPATT03Dangerous Goods Text Pattern 03nvarchar210CHAR(N' ')YesADGE_PTXTPATT03 Allow NULL? 
129TEXTPATT_PROF04Text Pattern Profile 04nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF04 Allow NULL? 
130TEXTPATT04Dangerous Goods Text Pattern 04nvarchar210CHAR(N' ')YesADGE_PTXTPATT04 Allow NULL? 
131TEXTPATT_PROF05Text Pattern Profile 05nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF05 Allow NULL? 
132TEXTPATT05Dangerous Goods Text Pattern 05nvarchar210CHAR(N' ')YesADGE_PTXTPATT05 Allow NULL? 
133TEXTPATT_PROF06Text Pattern Profile 06nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF06 Allow NULL? 
134TEXTPATT06Dangerous Goods Text Pattern 06nvarchar210CHAR(N' ')YesADGE_PTXTPATT06 Allow NULL? 
135TEXTPATT_PROF07Text Pattern Profile 07nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF07 Allow NULL? 
136TEXTPATT07Dangerous Goods Text Pattern 07nvarchar210CHAR(N' ')YesADGE_PTXTPATT07 Allow NULL? 
137TEXTPATT_PROF08Text Pattern Profile 08nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF08 Allow NULL? 
138TEXTPATT08Dangerous Goods Text Pattern 08nvarchar210CHAR(N' ')YesADGE_PTXTPATT08 Allow NULL? 
139TEXTPATT_PROF09Text Pattern Profile 09nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF09 Allow NULL? 
140TEXTPATT09Dangerous Goods Text Pattern 09nvarchar210CHAR(N' ')YesADGE_PTXTPATT09 Allow NULL? 
141TEXTPATT_PROF10Text Pattern Profile 10nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF10 Allow NULL? 
142TEXTPATT10Dangerous Goods Text Pattern 10nvarchar210CHAR(N' ')YesADGE_PTXTPATT10 Allow NULL? 
143TEXTPATT_PROF11Text Pattern Profile 11nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF11 Allow NULL? 
144TEXTPATT11Dangerous Goods Text Pattern 11nvarchar210CHAR(N' ')YesADGE_PTXTPATT11 Allow NULL? 
145TEXTPATT_PROF12Text Pattern Profile 12nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF12 Allow NULL? 
146TEXTPATT12Dangerous Goods Text Pattern 12nvarchar210CHAR(N' ')YesADGE_PTXTPATT12 Allow NULL? 
147TEXTPATT_PROF13Text Pattern Profile 13nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF13 Allow NULL? 
148TEXTPATT13Dangerous Goods Text Pattern 13nvarchar210CHAR(N' ')YesADGE_PTXTPATT13 Allow NULL? 
149TEXTPATT_PROF14Text Pattern Profile 14nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF14 Allow NULL? 
150TEXTPATT14Dangerous Goods Text Pattern 14nvarchar210CHAR(N' ')YesADGE_PTXTPATT14 Allow NULL? 
151TEXTPATT_PROF15Text Pattern Profile 15nvarchar100CHAR(N' ')YesTDG91ADGE_TEXTPATT_PROF15 Allow NULL? 
152TEXTPATT15Dangerous Goods Text Pattern 15nvarchar210CHAR(N' ')YesADGE_PTXTPATT15 Allow NULL? 
153ABS_ACTAbsolute Activitydecimal114QUAN((0))YesADGE_ABS_ACT
154ABS_ACT_UUnit of Absolute Activitynvarchar30UNIT(N' ')YesT006ADGE_ABS_ACT_U Allow NULL? 
155REL_SPEC_ACTRelative Specific Activitydecimal114QUAN((0))YesADGE_REL_SPEC_ACT
156REL_SPEC_ACT_UUnit of Relative Specific Activitynvarchar30UNIT(N' ')YesT006ADGE_REL_SPEC_ACT_U Allow NULL? 
157CONTAMINATIONContaminationdecimal83QUAN((0))YesADGE_CONTAMINATION
158CONTAMINATION_UUnit of Contaminationnvarchar30UNIT(N' ')YesT006ADGE_CONTAMINATION_U Allow NULL? 
159DOSE_RATERadiation Level (Unpacked)decimal95QUAN((0))YesADGE_DOSE_RATE
160DOSE_RATE_UUnit of Radiation Level (Unpacked)nvarchar30UNIT(N' ')YesT006ADGE_DOSE_RATE_U Allow NULL? 
161MAX_ACT1A1 Activity Limitdecimal114QUAN((0))YesADGE_MAX_ACT1
162MAX_ACT1_UA1 Activity Limit: Unitnvarchar30UNIT(N' ')YesT006ADGE_MAX_ACT1_U Allow NULL? 
163ACT1_UNLIMITA1 Activity Limit: Unlimitedchar10CHAR(N' ')YesADGE_ACT1_UNLIMIT Allow NULL? 
164MAX_ACT2A2 Activity Limitdecimal114QUAN((0))YesADGE_MAX_ACT2
165MAX_ACT2_UA2 Activity Limit: Unitnvarchar30UNIT(N' ')YesT006ADGE_MAX_ACT2_U Allow NULL? 
166ACT2_UNLIMITA2 Activity Limit: Unlimitedchar10CHAR(N' ')YesADGE_ACT2_UNLIMIT Allow NULL? 
167ACT_SUB_PACKActivity Concentration for Substances in Excepted Packagesdecimal114QUAN((0))YesADGE_ACT_SUB_PACK
168ACT_SUB_PACK_UActivity Concentration Unit for Substances in Excepted Pkgsnvarchar30UNIT(N' ')YesT006ADGE_ACT_SUB_PACK_U Allow NULL? 
169MAX_ACT_CONSGActivity Limit for Exempt Consignmentdecimal114QUAN((0))YesADGE_MAX_ACT_CONSG
170MAX_ACT_CONSG_UUnit of Activity Limit for Exempt Consignmentnvarchar30UNIT(N' ')YesT006ADGE_MAX_ACT_CONSG_U Allow NULL? 
171MULT_ACT_SGLMultiplier Activity Limit Itemdecimal117DEC((0))YesADGE_MULT_ACT_SGL
172REF_ACT_SGLReference Value for Multiplier Itemnvarchar20CHAR(N' ')YesADGE_REF_ACT_SGL Allow NULL? 
173MULT_ACT_PACKMultiplier Activity Limit Packagedecimal117DEC((0))YesADGE_MULT_ACT_PACK
174REF_ACT_PACKReference Value for Multiplier Packagenvarchar20CHAR(N' ')YesADGE_REF_ACT_PACK Allow NULL? 
175MAX_CONT_AContamination Limit (Alpha)decimal83QUAN((0))YesADGE_MAX_CONT_A
176MAX_CONT_A_UUnit of Contamination Limit (Alpha)nvarchar30UNIT(N' ')YesT006ADGE_MAX_CONT_A_U Allow NULL? 
177MAX_CONT_B_GContamination Limit (Beta, Gamma)decimal83QUAN((0))YesADGE_MAX_CONT_B_G
178MAX_CONT_B_G_UUnit of Contamination Limit (Beta, Gamma)nvarchar30UNIT(N' ')YesT006ADGE_MAX_CONT_B_G_U Allow NULL? 
179MAX_DOSE_UNPLimit Radiation Level Unpackeddecimal95QUAN((0))YesADGE_MAX_DOSE_UNP
180MAX_DOSE_UNP_UUnit of Limit Radiation Level Unpackednvarchar30UNIT(N' ')YesT006ADGE_MAX_DOSE_UNP_U Allow NULL? 
181DIST_DOSE_UNPMeasured Distance for Limit Unpackeddecimal53QUAN((0))YesADGE_DIST_DOSE_UNP
182DIST_DOSE_UNP_UUnit of Measured Distance for Limit Unpackednvarchar30UNIT(N' ')YesT006ADGE_DIST_DOSE_UNP_U Allow NULL? 
183NO_DIST_UNPMeasurement Unpacked at Surfacechar10CHAR(N' ')YesADGE_NO_DIST_UNP Allow NULL? 
184MAX_DOSE_PACKLimit Radiation Level Packeddecimal95QUAN((0))YesADGE_MAX_DOSE_PACK
185MAX_DOSE_PACK_UUnit of Limit Radiation Level Packednvarchar30UNIT(N' ')YesT006ADGE_MAX_DOSE_PACK_U Allow NULL? 
186DIST_DOSE_PACKMeasured Distance for Limit Packeddecimal53QUAN((0))YesADGE_DIST_DOSE_PACK
187DIST_DOSE_PACK_UUnit of Measured Distance for Limit Packednvarchar30UNIT(N' ')YesT006ADGE_DIST_DOSE_PACK_U Allow NULL? 
188NO_DIST_PACKMeasurement Packed at Surfacechar10CHAR(N' ')YesADGE_NO_DIST_PACK Allow NULL? 
189MAX_ACT_SGL_DCMaximum Activity: Itemdecimal114QUAN((0))YesADGE_MAX_ACT_SGL_DC
190MAX_ACT_SGL_U_DCMaximum Activity Unit: Itemnvarchar30UNIT(N' ')YesT006ADGE_MAX_ACT_SGL_DYN_U Allow NULL? 
191ACT_SGL_UNLIM_DCMaximum Activity of Item Unlimitedchar10CHAR(N' ')YesADGE_ACT_SGL_UNLIM_DC Allow NULL? 
192MAX_ACT_PAC_DCMaximum Activity: Packagedecimal114QUAN((0))YesADGE_MAX_ACT_PAC_DC
193MAX_ACT_PAC_U_DCMaximum Activity Unit: Packagenvarchar30UNIT(N' ')YesT006ADGE_MAX_ACT_PACK_DYN_U Allow NULL? 
194ACT_PAC_UNLIM_DCMaximum Activity of Package Unlimitedchar10CHAR(N' ')YesADGE_ACT_PAC_UNLIM_DC Allow NULL? 
195EXCPT_PAC_OPT_DCExcepted Package: Optionalchar10CHAR(N' ')YesADGE_EXCPT_PAC_OPT_DC Allow NULL? 
196MAX_GRS_WGHT_DCMaximum Gross Massdecimal82QUAN((0))YesADGE_MAX_GRS_WGHT_DC
197U_MAX_GRS_WGT_DCUnit for Maximum Gross Massnvarchar30UNIT(N' ')YesT006ADGE_U_MAX_GROSS_WGHT Allow NULL? 
198EXCEPTID01Exception to Dangerous Goods Regulations 01nvarchar180CHAR(N' ')YesADGE_EXCEPTID01 Allow NULL? 
199EXCEPTID02Exception to Dangerous Goods Regulations 02nvarchar180CHAR(N' ')YesADGE_EXCEPTID02 Allow NULL? 
200EXCEPTID03Exception to Dangerous Goods Regulations 03nvarchar180CHAR(N' ')YesADGE_EXCEPTID03 Allow NULL? 
201EXCEPTID04Exception to Dangerous Goods Regulations 04nvarchar180CHAR(N' ')YesADGE_EXCEPTID04 Allow NULL? 
202EXCEPTID05Exception to Dangerous Goods Regulations 05nvarchar180CHAR(N' ')YesADGE_EXCEPTID05 Allow NULL? 
203EXCEPTID06Exception to Dangerous Goods Regulations 06nvarchar180CHAR(N' ')YesADGE_EXCEPTID06 Allow NULL? 
204EXCEPTID07Exception to Dangerous Goods Regulations 07nvarchar180CHAR(N' ')YesADGE_EXCEPTID07 Allow NULL? 
205EXCEPTID08Exception to Dangerous Goods Regulations 08nvarchar180CHAR(N' ')YesADGE_EXCEPTID08 Allow NULL? 
206EXCEPTID09Exception to Dangerous Goods Regulations 09nvarchar180CHAR(N' ')YesADGE_EXCEPTID09 Allow NULL? 
207EXCEPTID10Exception to Dangerous Goods Regulations 10nvarchar180CHAR(N' ')YesADGE_EXCEPTID10 Allow NULL? 
208ACT_EMIS_TYPERadioactive Emission Typenvarchar30CHAR(N' ')YesADGE_ACT_EMIS_TYPE Allow NULL? 
209MAX_NEM_DCMaximum Net Explosive Substance Massdecimal93QUAN((0))YesADGE_MAX_NEM_DC
210MAX_NEM_U_DCUnit of Maximum Net Explosive Substance Massnvarchar30UNIT(N' ')Yes*ADGE_MAX_NEM_DC_U Allow NULL? 
211PINEQExcepted Quantity: Packing Instruction Numbernvarchar250CHAR(N' ')Yes*ADGE_PINEQ Allow NULL? 
212EXC_QUANT_IPExcepted Quantity: Maximum Quantity/Volume Inner Packagingdecimal82QUAN((0))YesADGE_EXC_QUANT_IP
213EXC_QUANT_IP_UExcepted Quantity: Unit of Meas. for Max.Qty Inner Packagingnvarchar30UNIT(N' ')Yes*ADGE_EXC_QUANT_IP_U Allow NULL? 
214EXC_QUANT_OPExcepted Quantity: Maximum Quantity/Volume Outer Packagingdecimal82QUAN((0))YesADGE_EXC_QUANT_OP
215EXC_QUANT_OP_UExcepted Quantity: Unit of Meas. for Max.Qty Outer Packagingnvarchar30UNIT(N' ')Yes*ADGE_EXC_QUANT_OP_U Allow NULL? 
216FLG_EXC_QUANT_IPValue Entered for Max. Qty Inner Packaging (Excepted Qty)char10CHAR(N' ')YesADGE_FLG_EXC_QUANT_IP Allow NULL? 
217FLG_EXC_QUANT_OPValue Entered for Max. Qty Outer Packaging (Excepted Qty)char10CHAR(N' ')YesADGE_FLG_EXC_QUANT_OP Allow NULL? 
NamePrimaryUniqueTypeColumns
DGTM2~0YesYesCLUSTEREDACTN, RECN, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy