	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

DRMDETL TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution High Tech :: Distributor-Reseller-Management
1	ERP EHP7	6.0	/SAPHT/DRMDETL	163	5	DRM Audit Trail	Distributor-Reseller-Management

SQL: selectupdate insert create

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

SELECT MANDT, LOTNO, AUDITNO, RUNNUMBER, CHANGE_DOCQTY, CHANGE_INVQTY, CHANGE_AVLQTY, CHANGE_STQTY, CHANGE_PIQTY, CHANGE_ECRQTY, CHANGE_MSRQTY, CHANGE_DSQTY, QTY_UNIT, XN_DATE, XN_CODE, PROC_CODE, INVNO, IDOCNO, COLL_RUN_NO, TRANS_DATE, STEXT, LTEXT, LS_REF_DOC_NO, REF_DOC_TYP, REF_DOC_NO, REF_DOC_ITM, PO_ORDER_TYPE, PRODORD_NO, SELLIN_DN_NO, SELLIN_DN_ITM, MATDOCNO, MATDOCITEM, MATDOCYR, MATDOCDATE, INVDOCNO, INVDOCITM, INVDOCYR, COMP_CODE, INV_DOC_TYPE, INVDATE, PRIC_UNIT, COND_RATE, COND_CURR, COND_NUMER, COND_DENOM, COND_UOM, END_CUST, TRACK_PARTNER, MSBOOKPARTNO, PARTNER, MATERIAL, SALES_REP, LS_EC_SO, EC_ORDR_NO, EC_ORDR_ITM, EC_DN_NO, EC_DN_ITEM, EC_SHP_DT, EC_INV_NO, EC_INV_ITM, EC_INV_DT, EC_CM_NO, EC_CM_ITM, LAST_SELLIN_DT, INT_XMNO, TRANSM_NO, EFF_DATE, STAGDOCNO, RESALEPRC, RESALECURR, RESL_PRC_UNIT, RESL_PRC_UOM, IDOC_TYPE, O_PRIC_UNIT, O_COND_RATE, O_COND_CURR, O_COND_NUMER, O_COND_DENOM, O_COND_UOM, O_PPTYPE, PPCLMQTY, PPRVLQTY, PPEFFDATE, PPRUNDATE, PPANNO, PP_CLM_AMOUNT, CLM_AMOUNT_CURR, LS_PPCLMDOC, PP_SLS_DOCNO, PP_SLS_DOCITM, PP_SLS_DOCQTY, PP_SLS_DOCAMT, PP_SLS_DOCCURR, PP_INV_DOCNO, PP_INV_DOCITM, PP_INV_DOCQTY, PP_INV_DOCAMT, PP_INV_DOCCURR, LS_PPRVLDOC, PPRVLDOCNO, PPRVLDOCYR, PPRVLPOST, PPRECORDNO, CLAIMDOCNO, CUS_REF_FLD, LS_SD_AGR, SD_AGR_NO, SD_AGR_ITM, SD_AGR_RATE, SD_AGR_CURR, SD_PRIC_UNIT, AGR_CON_NUM, AGR_CON_DEN, LOT_COND_RATE, LOT_COND_CURR, LOT_PRIC_UNIT, LOT_COND_NUMER, LOT_COND_DENOM, LOT_CLAIM_QTY, LOT_CLAIM_AMT, LOT_CLAIM_CURR, SD_SLS_DOCQTY, SD_SLS_DOCAMT, SD_SLS_DOCCURR, SD_INV_DOCQTY, SD_INV_DOCAMT, SD_INV_DOCCURR, SD_SLS_DOCNO, SD_SLS_DOCITM, SD_INV_DOCNO, SD_INV_DOCITM, BILLUPDLDOCNO, ECRETNQTY, BILLUPQTY, BU_SLS_DOCQTY, BU_INV_DOCQTY, BILLUPAMT, BILLUPAMTCUR, BU_SLS_DOCAMT, BU_SLS_DOCCURR, BU_INV_DOCAMT, BU_INV_DOCCURR, BU_SLS_DOCNO, BU_SLS_DOCITM, BU_INV_DOCNO, BU_INV_DOCITM, CANCEL_DOCTYP, CANCEL_DOCNO, CANCEL_DOCITM, CANCEL_DOCDATE, CANCEL_RUN_DATE, CANCEL_IND, CANCEL_INVNO, CANCEL_INVITM, CANCEL_INVDATE, REJ_REASON, CREATED_BY, CREATED_DT, CREATED_TM, LASTCHGDBY, LASTCHGDDT, CHANGED_TM, DUMMY_1 FROM /SAPHT/DRMDETL

TOP ERP 6.0 | /SAPHT/DRMDETL COLUMNS

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	*	MANDT	Allow NULL?
2	LOTNO	DRM lot number	nvarchar	10	0	CHAR	(N' ')	No		/SAPHT/DRM_LOTNO	Allow NULL?
3	AUDITNO	Total number of audit trails for DRM lot	nvarchar	6	0	NUMC	(N'000000')	No		/SAPHT/DRM_AUDITM	Allow NULL?
4	RUNNUMBER	run no. for fifo rollback.	nvarchar	30	0	CHAR	(N' ')	Yes		/SAPHT/DRM_RUNNUMBER	Allow NULL?
5	CHANGE_DOCQTY	Change in the material document quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CHMDOCQT
6	CHANGE_INVQTY	Change in the invoiced quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CHIVQT
7	CHANGE_AVLQTY	Change in DRM lot available quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CHAVQT
8	CHANGE_STQTY	Change in sell-through quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CHSTQT
9	CHANGE_PIQTY	Change in material quantity issued to production	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CHPIQT
10	CHANGE_ECRQTY	Change in resale return quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_ECRETQTY
11	CHANGE_MSRQTY	Change in quantity returned by distributor/ reseller	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_MSRQTY
12	CHANGE_DSQTY	Change in Drop-Ship Sell-In qty	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_DSSIQTY
13	QTY_UNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
14	XN_DATE	Lot data modification effective date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_XN_DATE	Allow NULL?
15	XN_CODE	DRM relevant transaction code	nvarchar	20	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_XNCODE	Allow NULL?
16	PROC_CODE	DRM relevant processing code	nvarchar	2	0	CHAR	(N' ')	Yes		/SAPHT/DRM_PROCCODE	Allow NULL?
17	INVNO	Inventory record number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_INVNO	Allow NULL?
18	IDOCNO	IDoc number	nvarchar	16	0	NUMC	(N'0000000000000000')	Yes		EDI_DOCNUM	Allow NULL?
19	COLL_RUN_NO	DRM collective processing number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRMCOLLRUNNO	Allow NULL?
20	TRANS_DATE	Reported date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_XNDT	Allow NULL?
21	STEXT	Short text for audit trail modification	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_STEXT	Allow NULL?
22	LTEXT	Long text for audit trail modification	nvarchar	40	0	CHAR	(N' ')	Yes		/SAPHT/DRM_LTEXT	Allow NULL?
23	LS_REF_DOC_NO	Logical system of reference document	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_LS_REFDOCNO	Allow NULL?
24	REF_DOC_TYP	Reference document type	nvarchar	2	0	CHAR	(N' ')	Yes		/SAPHT/DRM_RFDOCTYP	Allow NULL?
25	REF_DOC_NO	Reference document number	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPHT/DRM_RFDOCNO	Allow NULL?
26	REF_DOC_ITM	Reference document item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_RFDOCITM	Allow NULL?
27	PO_ORDER_TYPE	Purchasing Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	ESART	Allow NULL?
28	PRODORD_NO	Production order number	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPHT/DRM_PRODNO	Allow NULL?
29	SELLIN_DN_NO	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
30	SELLIN_DN_ITM	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
31	MATDOCNO	Goods Issue/ Goods receipt number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_MATDOCNO	Allow NULL?
32	MATDOCITEM	Goods Issue/ Goods receipt item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_MATDCITM	Allow NULL?
33	MATDOCYR	Goods Issue/ Goods receipt document year	nvarchar	4	0	NUMC	(N'0000')	Yes		/SAPHT/DRM_MATDOCYR	Allow NULL?
34	MATDOCDATE	Sell-in goods issue/ receipt document date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_MATDOCDT	Allow NULL?
35	INVDOCNO	Sell-in invoice/ invoice receipt document number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_INVDOCNO	Allow NULL?
36	INVDOCITM	Sell-In invoice/ invoice receipt document item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_INVDOCITM	Allow NULL?
37	INVDOCYR	Fiscal year	nvarchar	4	0	NUMC	(N'0000')	Yes		/SAPHT/DRM_INVDOCYR	Allow NULL?
38	COMP_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
39	INV_DOC_TYPE	Billing Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	FKART	Allow NULL?
40	INVDATE	Sell-in invoice date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_INVDOCDT	Allow NULL?
41	PRIC_UNIT	Pricing unit for price protectable price	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_PRCUNIT
42	COND_RATE	Price protectable price condition rate	decimal	11	2	CURR	((0))	Yes		/SAPHT/DRM_COND_RATE
43	COND_CURR	Price protectable price currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_COND_CURR	Allow NULL?
44	COND_NUMER	Numerator for converting price protectable price	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_COND_NUMERATOR
45	COND_DENOM	Denominator for conversion to base unit	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_COND_DENOM
46	COND_UOM	Pricing unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPHT/DRM_PRIC_UOM	Allow NULL?
47	END_CUST	DRM end customer	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_ENDCST	Allow NULL?
48	TRACK_PARTNER	Tracking partner	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_TRACK_PARTNER	Allow NULL?
49	MSBOOKPARTNO	Manufacturer Book Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_MSBOOKPART	Allow NULL?
50	PARTNER	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
51	MATERIAL	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
52	SALES_REP	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
53	LS_EC_SO	Logical system of end customer sales order	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_LS_ECSO	Allow NULL?
54	EC_ORDR_NO	End customer sales order number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_ECSONO	Allow NULL?
55	EC_ORDR_ITM	End customer sales order item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_ECSOITM	Allow NULL?
56	EC_DN_NO	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VL	Allow NULL?
57	EC_DN_ITEM	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VL	Allow NULL?
58	EC_SHP_DT	Resale shipping date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_ECSHPDATE	Allow NULL?
59	EC_INV_NO	End customer invoice number	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPHT/DRM_ECINVDOC	Allow NULL?
60	EC_INV_ITM	Resale invoice item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_ECINVITM	Allow NULL?
61	EC_INV_DT	Resale invoice date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_ECINVDATE	Allow NULL?
62	EC_CM_NO	End customer return credit memo number	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPHT/DRM_ECCMDOC	Allow NULL?
63	EC_CM_ITM	End customer return credit memo item number	nvarchar	6	0	CHAR	(N' ')	Yes		/SAPHT/DRM_ECCMITM	Allow NULL?
64	LAST_SELLIN_DT	Last Sell-In date at the time of the Transaction	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_SELLINDT_RES	Allow NULL?
65	INT_XMNO	DRM internal transmission number	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPHT/DRM_INTXMNO	Allow NULL?
66	TRANSM_NO	EDI transmission number	nvarchar	20	0	CHAR	(N' ')	Yes		/SAPHT/DRM_TRANSMNO	Allow NULL?
67	EFF_DATE	EDI transmission effective date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_EFFDATE	Allow NULL?
68	STAGDOCNO	IDOC staging table document number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_STAGDOCNO	Allow NULL?
69	RESALEPRC	Resale price	decimal	11	2	CURR	((0))	Yes		/SAPHT/DRM_RESPRC
70	RESALECURR	Resale price currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_RESCURR	Allow NULL?
71	RESL_PRC_UNIT	Pricing quantity for resale price	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_RESPRCUNIT
72	RESL_PRC_UOM	Unit of measure for pricing quantity	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPHT/DRM_RESPRCUOM	Allow NULL?
73	IDOC_TYPE	Message Type	nvarchar	30	0	CHAR	(N' ')	Yes	*	EDI_MESTYP	Allow NULL?
74	O_PRIC_UNIT	Old price protectable price pricing unit	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_OLDPRCUNIT
75	O_COND_RATE	Old price protectable price	decimal	11	2	CURR	((0))	Yes		/SAPHT/DRM_OLDCONDRATE
76	O_COND_CURR	Old price protectable price currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_OLDCONDCURR	Allow NULL?
77	O_COND_NUMER	Nr for converting old PP condition units to base units	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_OLDCONDNR
78	O_COND_DENOM	Dr for converting old PP condition units to base units	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_OLDCONDDR
79	O_COND_UOM	Unit of measure for old price protectable price	nvarchar	3	0	UNIT	(N' ')	Yes	*	/SAPHT/DRM_OLD_UOM	Allow NULL?
80	O_PPTYPE	Old Price Protection Type	char	1	0	CHAR	(N' ')	Yes		/SAPHT/DRM_OLDPPTYPE	Allow NULL?
81	PPCLMQTY	Price protection claim quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_PPCLMQTY
82	PPRVLQTY	Lot quantity eligible for revaluation	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_PPRVLQTY
83	PPEFFDATE	Price protection effective date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_PPEFFDATE	Allow NULL?
84	PPRUNDATE	Price protection run date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_PPRUNDATE	Allow NULL?
85	PPANNO	Price protection announcement number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_PPANNO	Allow NULL?
86	PP_CLM_AMOUNT	Price Protection Claim Amount	decimal	15	2	CURR	((0))	Yes		/SAPHT/PPCLAIM_AMOUNT
87	CLM_AMOUNT_CURR	PP Claim Amount Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/PPCLAIM_CURR	Allow NULL?
88	LS_PPCLMDOC	Logical system of price protection claim document	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_LS_PPCLM	Allow NULL?
89	PP_SLS_DOCNO	Price protection credit/ debit memo request number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_PPSLSDOCNO	Allow NULL?
90	PP_SLS_DOCITM	Price protection credit/ debit memo request item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_PPSLSITMNO	Allow NULL?
91	PP_SLS_DOCQTY	Price protection qty in the credit/debit memo request	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_PP_SLSDOCQTY
92	PP_SLS_DOCAMT	Price protection amount in the credit/debit memo request	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_PP_SLSDOCAMT
93	PP_SLS_DOCCURR	Currency of the credit/debit memo request amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_PP_SLSDOCCURR	Allow NULL?
94	PP_INV_DOCNO	Price protection credit/ debit memo number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_PPINVDOCNO	Allow NULL?
95	PP_INV_DOCITM	Price protection credit/ debit memo item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_PPINVITMNO	Allow NULL?
96	PP_INV_DOCQTY	Price protection claim invoiced quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_PP_INVDOCQTY
97	PP_INV_DOCAMT	Price protection claim invoiced amount	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_PP_INVDOCAMT
98	PP_INV_DOCCURR	Currency for the price protection claim invoced amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_PP_INVDOCCURR	Allow NULL?
99	LS_PPRVLDOC	Logical system of price protection revaluation document	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_LS_PPRVL	Allow NULL?
100	PPRVLDOCNO	Price protection revaluation document number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_PPRVLDOCNO	Allow NULL?
101	PPRVLDOCYR	Document year of Revaluation document	nvarchar	4	0	NUMC	(N'0000')	Yes		/SAPHT/DRM_PPRVLDOCYR	Allow NULL?
102	PPRVLPOST	Posting period of Revaluation document	nvarchar	3	0	NUMC	(N'000')	Yes		/SAPHT/DRM_PPRVLPOST	Allow NULL?
103	PPRECORDNO	Price protection due list record number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_RECORDNO	Allow NULL?
104	CLAIMDOCNO	Ship-and-debit claim document number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_CLAIMDOCNO	Allow NULL?
105	CUS_REF_FLD	Ship-and-debit claim reference number	nvarchar	35	0	CHAR	(N' ')	Yes		/SAPHT/DRM_SDCUSREF	Allow NULL?
106	LS_SD_AGR	Logical system of ship & debit agreement	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_LS_SDAGR	Allow NULL?
107	SD_AGR_NO	Ship-and-debit agreement number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_SDAGRNO	Allow NULL?
108	SD_AGR_ITM	Ship-and-debit agreement item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_SDAGRITM	Allow NULL?
109	SD_AGR_RATE	Ship-and-debit agreement rate	decimal	11	2	CURR	((0))	Yes		/SAPHT/DRM_SDAGRRATE
110	SD_AGR_CURR	Ship-and-debit agreement rate currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_SDAGRCURR	Allow NULL?
111	SD_PRIC_UNIT	Ship-and-debit agreement pricing unit	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_AGR_PRC_UNIT
112	AGR_CON_NUM	Numerator for coversion to base unit	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_AGR_COND_NUMER
113	AGR_CON_DEN	Denominator for conversion to base unit of material	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_AGR_COND_DENOM
114	LOT_COND_RATE	PP Rate of the Lot at the time of SD Claim	decimal	11	2	CURR	((0))	Yes		/SAPHT/DRM_LOTCONDRATE
115	LOT_COND_CURR	PP Curr of the Lot at the time of SD Claim	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_LOTCONDCURR	Allow NULL?
116	LOT_PRIC_UNIT	PP Pricing Unit at the time of SD Claim	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_LOTPRICUNIT
117	LOT_COND_NUMER	PP Condition Numerator at the time of SD Claim	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_LOTCONDNUM
118	LOT_COND_DENOM	PP Condition Denominator at the time of SD Claim	decimal	5	0	DEC	((0))	Yes		/SAPHT/DRM_LOTCONDDEN
119	LOT_CLAIM_QTY	Lot quantity used in the Claim Calculation	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_LOTCLMQTY
120	LOT_CLAIM_AMT	Claim Amount for the Lot	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_LOTCLMAMT
121	LOT_CLAIM_CURR	Claim Currency for the Lot	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_LOTCLMCURR	Allow NULL?
122	SD_SLS_DOCQTY	Ship and Debit qty in the credit/debit memo request	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_SD_SLSDOCQTY
123	SD_SLS_DOCAMT	Ship and Debit amount in the credit/debit memo request	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_SD_SLSDOCAMT
124	SD_SLS_DOCCURR	Currency of the credit/debit memo request amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_SD_SLSDOCCURR	Allow NULL?
125	SD_INV_DOCQTY	Ship-and-debit invoice document quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_SD_INVDOCQTY
126	SD_INV_DOCAMT	Amount paid out as ship-and-debit claim	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_SD_INVDOCAMT
127	SD_INV_DOCCURR	Currency for ship-and-debit amount in credit/ debit memo	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_SD_INVDOCCURR	Allow NULL?
128	SD_SLS_DOCNO	Credit/ debit memo request number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_SLSDOC_NO	Allow NULL?
129	SD_SLS_DOCITM	Credit/ debit memo request item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_SLSDOC_ITM	Allow NULL?
130	SD_INV_DOCNO	Credit/ debit memo number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_INVDOC_NO	Allow NULL?
131	SD_INV_DOCITM	Credit/ debit memo item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_INVDOC_ITM	Allow NULL?
132	BILLUPDLDOCNO	Bill-up due list document number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_BILLUP_DL_DOC_NO	Allow NULL?
133	ECRETNQTY	Lot Return Quantity used for Bill Up Due List Calculation	decimal	15	3	QUAN	((0))	Yes		/SAPHT/LOT_ECRETNQTY
134	BILLUPQTY	Calculated bill-up claim quantity	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_CALCCLAIMQTY
135	BU_SLS_DOCQTY	Bill up claim quantity in credit/ debit memo request	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_BU_SLSDOCQTY
136	BU_INV_DOCQTY	Bill-up claim quantity in credit/ debit memo	decimal	15	3	QUAN	((0))	Yes		/SAPHT/DRM_BU_INVDOCQTY
137	BILLUPAMT	Calculated claim amount	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_CALCCLAIMAMT
138	BILLUPAMTCUR	Currency for calculated claim amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_CALCCLAIMCUR	Allow NULL?
139	BU_SLS_DOCAMT	Bill up claim amount in credit/debit memo request	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_BU_SLSDOCAMT
140	BU_SLS_DOCCURR	Currency of bill-up claim amount in Cr/ Dr memo request	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_BU_SLSDOCCURR	Allow NULL?
141	BU_INV_DOCAMT	Bill-up claim amount in credit/ debit memo	decimal	15	2	CURR	((0))	Yes		/SAPHT/DRM_BU_INVDOCAMT
142	BU_INV_DOCCURR	Bill-up credit/ debit memo amount currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	/SAPHT/DRM_BU_INVDOCCURR	Allow NULL?
143	BU_SLS_DOCNO	Credit/ debit memo request number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_SLSDOC_NO	Allow NULL?
144	BU_SLS_DOCITM	Credit/ debit memo request item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_SLSDOC_ITM	Allow NULL?
145	BU_INV_DOCNO	Credit/ debit memo number	nvarchar	10	0	CHAR	(N' ')	Yes	*	/SAPHT/DRM_INVDOC_NO	Allow NULL?
146	BU_INV_DOCITM	Credit/ debit memo item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_INVDOC_ITM	Allow NULL?
147	CANCEL_DOCTYP	Cancellation document type	nvarchar	2	0	CHAR	(N' ')	Yes		/SAPHT/DRM_CANDOCTYP	Allow NULL?
148	CANCEL_DOCNO	Cancellation document number	nvarchar	12	0	CHAR	(N' ')	Yes		/SAPHT/DRM_CANDOCNO	Allow NULL?
149	CANCEL_DOCITM	Cancellation document item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_CANDOCITM	Allow NULL?
150	CANCEL_DOCDATE	Cancellation document date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_CANDOCDATE	Allow NULL?
151	CANCEL_RUN_DATE	Cancellation run date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRMCANCELRUNDATE	Allow NULL?
152	CANCEL_IND	Cancellation indicator for audit trail	char	1	0	CHAR	(N' ')	Yes		/SAPHT/DRM_CANCEL_IND	Allow NULL?
153	CANCEL_INVNO	Cancellation invoice number	nvarchar	10	0	CHAR	(N' ')	Yes		/SAPHT/DRM_CANCINVNO	Allow NULL?
154	CANCEL_INVITM	Cancellation Invoice item number	nvarchar	6	0	NUMC	(N'000000')	Yes	*	/SAPHT/DRM_CANCINVITM	Allow NULL?
155	CANCEL_INVDATE	Cancellation invoice date	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_CANCINVDATE	Allow NULL?
156	REJ_REASON	Reason for rejection of quotations and sales orders	nvarchar	2	0	CHAR	(N' ')	Yes	*	ABGRU_VA	Allow NULL?
157	CREATED_BY	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
158	CREATED_DT	Created on	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPHT/DRM_CRDATE	Allow NULL?
159	CREATED_TM	Time created	nvarchar	6	0	TIMS	(N'000000')	Yes		C_TIME	Allow NULL?
160	LASTCHGDBY	Last Changed By	nvarchar	12	0	CHAR	(N' ')	Yes		UPNAM	Allow NULL?
161	LASTCHGDDT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
162	CHANGED_TM	Last changed at	nvarchar	6	0	TIMS	(N'000000')	Yes		AS4TIME	Allow NULL?
163	DUMMY_1	Dummy function in length 1	char	1	0	CHAR	(N' ')	Yes		DUMMY	Allow NULL?

TOP ERP 6.0 | /SAPHT/DRMDETL INDEXES

Name	Primary	Unique	Type	Columns
/SAPHT/DRMDETL~0	Yes	Yes	CLUSTERED	AUDITNO, LOTNO, MANDT
/SAPHT/DRMDETL~001	No	No	NONCLUSTERED	CANCEL_IND, LOTNO, PROC_CODE
/SAPHT/DRMDETL~002	No	No	NONCLUSTERED	MATERIAL, MSBOOKPARTNO, TRACK_PARTNER, PROC_CODE
/SAPHT/DRMDETL~003	No	No	NONCLUSTERED	PRODORD_NO
/SAPHT/DRMDETL~004	No	No	NONCLUSTERED	EC_INV_ITM, EC_INV_NO

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

163 COLUMNS | 5 INDEXES | ERP 6.0 | /SAPHT/DRMDETL TABLE

TOP ERP 6.0 | /SAPHT/DRMDETL COLUMNS

TOP ERP 6.0 | /SAPHT/DRMDETL INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

163 COLUMNS | 5 INDEXES | ERP 6.0 | /SAPHT/DRMDETL TABLE

TOPERP 6.0 | /SAPHT/DRMDETL COLUMNS

TOPERP 6.0 | /SAPHT/DRMDETL INDEXES

TOP ERP 6.0 | /SAPHT/DRMDETL COLUMNS

TOP ERP 6.0 | /SAPHT/DRMDETL INDEXES