SAP ABAP Table /SAPHT/DRMR3XN (DRM relevant ERP Transactions)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-HT-DRM (Application Component) Distributor-Reseller-Management
     ⤷ /SAPHT/DRM02 (Package) DRM Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/SAPHT/DRMR3XN	Table Relationship Diagram
Short Description	DRM relevant ERP Transactions

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LS_DOC_NO	☑	/SAPHT/DRM_LS_DOC_NO	LOGSYS	CHAR	10	0	Logical System of the SAP Transaction Document	*
3	DOC_TYP	☑	/SAPHT/DRM_DOCTYP	/SAPHT/DRM_DOCTYP	CHAR	2	0	Transaction Document Type
4	DOC_NO	☑	/SAPHT/DRM_DOCNO	BELNR	CHAR	10	0	Transaction Document Number
5	DOC_ITM	☑	/SAPHT/DRM_DOCITM	/SAPHT/DRM_DOCITM	NUMC	6	0	Transaction Document Item Number
6	DOC_YEAR	☑	/SAPHT/DRM_DOCYR	GJAHR	NUMC	4	0	Transaction Document Year
7	COMP_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	REF_DOC_TYP	☐	/SAPHT/DRM_RFDOCTYP	/SAPHT/DRM_DOCTYP	CHAR	2	0	Reference document type
9	REF_DOC_NO	☐	/SAPHT/DRM_RFDOCNO	XUACCNT	CHAR	12	0	Reference document number
10	REF_DOC_ITM	☐	/SAPHT/DRM_RFDOCITM	POSNR	NUMC	6	0	Reference document item number	*
11	REF_DOC_YEAR	☐	/SAPHT/DRM_RFDOCYR	GJAHR	NUMC	4	0	Reference document year
12	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
13	ORDER_NO	☐	/SAPHT/DRM_ORDERNO	XUACCNT	CHAR	12	0	Order number
14	ORDER_ITM	☐	/SAPHT/DRM_ORDERITM	POSNR	NUMC	6	0	Order item	*
15	PO_ORDER_TYPE	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
16	INV_DOC_TYPE	☐	FKART	FKART	CHAR	4	0	Billing Type	*
17	MATDOCNO	☐	/SAPHT/DRM_MATDOCNO	BELNR	CHAR	10	0	Goods Issue/ Goods receipt number
18	MATDOCITEM	☐	/SAPHT/DRM_MATDCITM	POSNR	NUMC	6	0	Goods Issue/ Goods receipt item number	*
19	MATDOCYR	☐	/SAPHT/DRM_MATDOCYR	GJAHR	NUMC	4	0	Goods Issue/ Goods receipt document year
20	DS_ORD_NO	☐	/SAPHT/DRM_DS_ORD_NO	BELNR	CHAR	10	0	Drop-ship sales order number
21	DS_ORD_ITM	☐	/SAPHT/DRM_DSORDITM	/SAPHT/DRM_DOCITM	NUMC	6	0	Drop-ship sales order item number
22	DOC_QTY	☐	/SAPHT/DRM_DOCQT	MENG15	QUAN	15	3	Document quantity
23	MATCHED_QTY	☐	/SAPHT/DRM_MATQT	MENG15	QUAN	15	3	Matched quantity
24	QTY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	PRIC_UNIT	☐	/SAPHT/DRM_PRCUNIT	KPEIN	DEC	5	0	Pricing unit for price protectable price
26	COND_RATE	☐	/SAPHT/DRM_COND_RATE	WERTV6	CURR	11	2	Price protectable price condition rate
27	COND_CURR	☐	/SAPHT/DRM_COND_CURR	WAERS	CUKY	5	0	Price protectable price currency	*
28	COND_NUMER	☐	/SAPHT/DRM_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting price protectable price
29	COND_DENOM	☐	/SAPHT/DRM_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit
30	COND_UOM	☐	/SAPHT/DRM_PRIC_UOM	MEINS	UNIT	3	0	Pricing unit of measure	*
31	DOC_VALUE	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
32	DOC_VALUE_CURR	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
33	DOC_DATE	☐	/SAPHT/DRM_DOCDATE	DATUM	DATS	8	0	Document creation date
34	MSBOOKPARTNO	☐	/SAPHT/DRM_MSBOOKPARTNO	MATNR	CHAR	18	0	Manufacturer book part number	*
35	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
36	TRACK_PARTNER	☐	/SAPHT/DRM_TRACK_PARTNER	BU_PARTNER	CHAR	10	0	Tracking partner	*
37	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
38	LOTTYPE	☐	/SAPHT/DRM_LOTTYPE	/SAPHT/DRM_LOTTYPE	CHAR	1	0	DRM lot type
39	END_CUST	☐	/SAPHT/DRM_ENDCST	BU_PARTNER	CHAR	10	0	DRM end customer	*
40	RESALEPRC	☐	/SAPHT/DRM_RESPRC	WERTV6	CURR	11	2	Resale price
41	RESALECURR	☐	/SAPHT/DRM_RESCURR	WAERS	CUKY	5	0	Resale price currency	*
42	RESL_PRC_UNIT	☐	/SAPHT/DRM_RESPRCUNIT	KPEIN	DEC	5	0	Pricing quantity for resale price
43	RESL_PRC_UOM	☐	/SAPHT/DRM_RESPRCUOM	MEINS	UNIT	3	0	Unit of measure for pricing quantity	*
44	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
45	DIST_CHNL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
46	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
47	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
48	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
49	PPTYPE	☐	/SAPHT/DRM_PPTYPE	/SAPHT/DRM_PPTYPE	CHAR	1	0	Price protection type
50	RB_LOTNO	☐	/SAPHT/DRM_RBLOTNO	CHAR10	CHAR	10	0	Reconciliation bucket lot number
51	CUS_REF_FLD	☐	/SAPHT/DRM_SDCUSREF	/SAPHT/DRM_SDCUSREF	CHAR	35	0	Ship-and-debit claim reference number
52	IND_ATO_MTS	☐	CCOBJID	CHAR1	CHAR	1	0	Object ID
53	PROD_ORD_NO	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
54	XN_CODE	☐	/SAPHT/DRM_XNCODE	/SAPHT/DRM_XNCODE	CHAR	20	0	DRM relevant transaction code	/SAPHT/DRMCXNCD
55	PROC_CODE	☐	/SAPHT/DRM_PROCCODE	/SAPHT/DRM_PROCCODE	CHAR	2	0	DRM relevant processing code
56	MS_DR_IND	☐	/SAPHT/DRM_MSDRIND	/SAPHT/DRM_MSDRIND	CHAR	1	0	Indicates manufacturer/supplier or distributor/reseller lot
57	PROC_STATUS	☐	/SAPHT/DRM_R3STATUS	/SAPHT/DRM_R3STATUS	CHAR	1	0	Status of transactions
58	LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
59	.INCLUDE	☐				0	0	DRM Structure for tracking Created By/Changed By...
60	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
61	CREATED_DT	☐	/SAPHT/DRM_CRDATE	DATUM	DATS	8	0	Created on
62	CREATED_TM	☐	C_TIME	UZEIT	TIMS	6	0	Time created
63	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
64	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
65	CHANGED_TM	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPHT/DRMR3XN	DIST_CHNL	TVTW	VTWEG
2	/SAPHT/DRMR3XN	DIVISION	TSPA	SPART
3	/SAPHT/DRMR3XN	MANDT	T000	MANDT
4	/SAPHT/DRMR3XN	PURCH_ORG	T024E	EKORG
5	/SAPHT/DRMR3XN	SALES_ORG	TVKO	VKORG
6	/SAPHT/DRMR3XN	XN_CODE	/SAPHT/DRMCXNCD	XN_CODE	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in