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  | /SAPHT/DRMDETL
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Industry Solution High Tech :: Distributor-Reseller-Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPHT/DRMDETL1635DRM Audit TrailDistributor-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
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2LOTNODRM lot numbernvarchar100 Allow NULL? 
3AUDITNOTotal number of audit trails for DRM lotnvarchar60 Allow NULL? 
4RUNNUMBERrun no. for fifo rollback.nvarchar300 Allow NULL? 
5CHANGE_DOCQTYChange in the material document quantitydecimal153
6CHANGE_INVQTYChange in the invoiced quantitydecimal153
7CHANGE_AVLQTYChange in DRM lot available quantitydecimal153
8CHANGE_STQTYChange in sell-through quantitydecimal153
9CHANGE_PIQTYChange in material quantity issued to productiondecimal153
10CHANGE_ECRQTYChange in resale return quantitydecimal153
11CHANGE_MSRQTYChange in quantity returned by distributor/ resellerdecimal153
12CHANGE_DSQTYChange in Drop-Ship Sell-In qtydecimal153
13QTY_UNITBase Unit of Measurenvarchar30 Allow NULL? 
14XN_DATELot data modification effective datenvarchar80 Allow NULL? 
15XN_CODEDRM relevant transaction codenvarchar200 Allow NULL? 
16PROC_CODEDRM relevant processing codenvarchar20 Allow NULL? 
17INVNOInventory record numbernvarchar100 Allow NULL? 
18IDOCNOIDoc numbernvarchar160 Allow NULL? 
19COLL_RUN_NODRM collective processing numbernvarchar100 Allow NULL? 
20TRANS_DATEReported datenvarchar80 Allow NULL? 
21STEXTShort text for audit trail modificationnvarchar100 Allow NULL? 
22LTEXTLong text for audit trail modificationnvarchar400 Allow NULL? 
23LS_REF_DOC_NOLogical system of reference documentnvarchar100 Allow NULL? 
24REF_DOC_TYPReference document typenvarchar20 Allow NULL? 
25REF_DOC_NOReference document numbernvarchar120 Allow NULL? 
26REF_DOC_ITMReference document item numbernvarchar60 Allow NULL? 
27PO_ORDER_TYPEPurchasing Document Typenvarchar40 Allow NULL? 
28PRODORD_NOProduction order numbernvarchar120 Allow NULL? 
29SELLIN_DN_NODeliverynvarchar100 Allow NULL? 
30SELLIN_DN_ITMDelivery Itemnvarchar60 Allow NULL? 
31MATDOCNOGoods Issue/ Goods receipt numbernvarchar100 Allow NULL? 
32MATDOCITEMGoods Issue/ Goods receipt item numbernvarchar60 Allow NULL? 
33MATDOCYRGoods Issue/ Goods receipt document yearnvarchar40 Allow NULL? 
34MATDOCDATESell-in goods issue/ receipt document datenvarchar80 Allow NULL? 
35INVDOCNOSell-in invoice/ invoice receipt document numbernvarchar100 Allow NULL? 
36INVDOCITMSell-In invoice/ invoice receipt document item numbernvarchar60 Allow NULL? 
37INVDOCYRFiscal yearnvarchar40 Allow NULL? 
38COMP_CODECompany Codenvarchar40 Allow NULL? 
39INV_DOC_TYPEBilling Typenvarchar40 Allow NULL? 
40INVDATESell-in invoice datenvarchar80 Allow NULL? 
41PRIC_UNITPricing unit for price protectable pricedecimal50
42COND_RATEPrice protectable price condition ratedecimal112
43COND_CURRPrice protectable price currencynvarchar50 Allow NULL? 
44COND_NUMERNumerator for converting price protectable pricedecimal50
45COND_DENOMDenominator for conversion to base unitdecimal50
46COND_UOMPricing unit of measurenvarchar30 Allow NULL? 
47END_CUSTDRM end customernvarchar100 Allow NULL? 
48TRACK_PARTNERTracking partnernvarchar100 Allow NULL? 
49MSBOOKPARTNOManufacturer Book Part Numbernvarchar180 Allow NULL? 
50PARTNERBusiness Partner Numbernvarchar100 Allow NULL? 
51MATERIALMaterial Numbernvarchar180 Allow NULL? 
52SALES_REPBusiness Partner Numbernvarchar100 Allow NULL? 
53LS_EC_SOLogical system of end customer sales ordernvarchar100 Allow NULL? 
54EC_ORDR_NOEnd customer sales order numbernvarchar100 Allow NULL? 
55EC_ORDR_ITMEnd customer sales order item numbernvarchar60 Allow NULL? 
56EC_DN_NODeliverynvarchar100 Allow NULL? 
57EC_DN_ITEMDelivery Itemnvarchar60 Allow NULL? 
58EC_SHP_DTResale shipping datenvarchar80 Allow NULL? 
59EC_INV_NOEnd customer invoice numbernvarchar200 Allow NULL? 
60EC_INV_ITMResale invoice item numbernvarchar60 Allow NULL? 
61EC_INV_DTResale invoice datenvarchar80 Allow NULL? 
62EC_CM_NOEnd customer return credit memo numbernvarchar200 Allow NULL? 
63EC_CM_ITMEnd customer return credit memo item numbernvarchar60 Allow NULL? 
64LAST_SELLIN_DTLast Sell-In date at the time of the Transactionnvarchar80 Allow NULL? 
65INT_XMNODRM internal transmission numbernvarchar200 Allow NULL? 
66TRANSM_NOEDI transmission numbernvarchar200 Allow NULL? 
67EFF_DATEEDI transmission effective datenvarchar80 Allow NULL? 
68STAGDOCNOIDOC staging table document numbernvarchar100 Allow NULL? 
69RESALEPRCResale pricedecimal112
70RESALECURRResale price currencynvarchar50 Allow NULL? 
71RESL_PRC_UNITPricing quantity for resale pricedecimal50
72RESL_PRC_UOMUnit of measure for pricing quantitynvarchar30 Allow NULL? 
73IDOC_TYPEMessage Typenvarchar300 Allow NULL? 
74O_PRIC_UNITOld price protectable price pricing unitdecimal50
75O_COND_RATEOld price protectable pricedecimal112
76O_COND_CURROld price protectable price currencynvarchar50 Allow NULL? 
77O_COND_NUMERNr for converting old PP condition units to base unitsdecimal50
78O_COND_DENOMDr for converting old PP condition units to base unitsdecimal50
79O_COND_UOMUnit of measure for old price protectable pricenvarchar30 Allow NULL? 
80O_PPTYPEOld Price Protection Typechar10 Allow NULL? 
81PPCLMQTYPrice protection claim quantitydecimal153
82PPRVLQTYLot quantity eligible for revaluationdecimal153
83PPEFFDATEPrice protection effective datenvarchar80 Allow NULL? 
84PPRUNDATEPrice protection run datenvarchar80 Allow NULL? 
85PPANNOPrice protection announcement numbernvarchar100 Allow NULL? 
86PP_CLM_AMOUNTPrice Protection Claim Amountdecimal152
87CLM_AMOUNT_CURRPP Claim Amount Currencynvarchar50 Allow NULL? 
88LS_PPCLMDOCLogical system of price protection claim documentnvarchar100 Allow NULL? 
89PP_SLS_DOCNOPrice protection credit/ debit memo request numbernvarchar100 Allow NULL? 
90PP_SLS_DOCITMPrice protection credit/ debit memo request item numbernvarchar60 Allow NULL? 
91PP_SLS_DOCQTYPrice protection qty in the credit/debit memo requestdecimal153
92PP_SLS_DOCAMTPrice protection amount in the credit/debit memo requestdecimal152
93PP_SLS_DOCCURRCurrency of the credit/debit memo request amountnvarchar50 Allow NULL? 
94PP_INV_DOCNOPrice protection credit/ debit memo numbernvarchar100 Allow NULL? 
95PP_INV_DOCITMPrice protection credit/ debit memo item numbernvarchar60 Allow NULL? 
96PP_INV_DOCQTYPrice protection claim invoiced quantitydecimal153
97PP_INV_DOCAMTPrice protection claim invoiced amountdecimal152
98PP_INV_DOCCURRCurrency for the price protection claim invoced amountnvarchar50 Allow NULL? 
99LS_PPRVLDOCLogical system of price protection revaluation documentnvarchar100 Allow NULL? 
100PPRVLDOCNOPrice protection revaluation document numbernvarchar100 Allow NULL? 
101PPRVLDOCYRDocument year of Revaluation documentnvarchar40 Allow NULL? 
102PPRVLPOSTPosting period of Revaluation documentnvarchar30 Allow NULL? 
103PPRECORDNOPrice protection due list record numbernvarchar100 Allow NULL? 
104CLAIMDOCNOShip-and-debit claim document numbernvarchar100 Allow NULL? 
105CUS_REF_FLDShip-and-debit claim reference numbernvarchar350 Allow NULL? 
106LS_SD_AGRLogical system of ship & debit agreementnvarchar100 Allow NULL? 
107SD_AGR_NOShip-and-debit agreement numbernvarchar100 Allow NULL? 
108SD_AGR_ITMShip-and-debit agreement item numbernvarchar60 Allow NULL? 
109SD_AGR_RATEShip-and-debit agreement ratedecimal112
110SD_AGR_CURRShip-and-debit agreement rate currencynvarchar50 Allow NULL? 
111SD_PRIC_UNITShip-and-debit agreement pricing unitdecimal50
112AGR_CON_NUMNumerator for coversion to base unitdecimal50
113AGR_CON_DENDenominator for conversion to base unit of materialdecimal50
114LOT_COND_RATEPP Rate of the Lot at the time of SD Claimdecimal112
115LOT_COND_CURRPP Curr of the Lot at the time of SD Claimnvarchar50 Allow NULL? 
116LOT_PRIC_UNITPP Pricing Unit at the time of SD Claimdecimal50
117LOT_COND_NUMERPP Condition Numerator at the time of SD Claimdecimal50
118LOT_COND_DENOMPP Condition Denominator at the time of SD Claimdecimal50
119LOT_CLAIM_QTYLot quantity used in the Claim Calculationdecimal153
120LOT_CLAIM_AMTClaim Amount for the Lotdecimal152
121LOT_CLAIM_CURRClaim Currency for the Lotnvarchar50 Allow NULL? 
122SD_SLS_DOCQTYShip and Debit qty in the credit/debit memo requestdecimal153
123SD_SLS_DOCAMTShip and Debit amount in the credit/debit memo requestdecimal152
124SD_SLS_DOCCURRCurrency of the credit/debit memo request amountnvarchar50 Allow NULL? 
125SD_INV_DOCQTYShip-and-debit invoice document quantitydecimal153
126SD_INV_DOCAMTAmount paid out as ship-and-debit claimdecimal152
127SD_INV_DOCCURRCurrency for ship-and-debit amount in credit/ debit memonvarchar50 Allow NULL? 
128SD_SLS_DOCNOCredit/ debit memo request numbernvarchar100 Allow NULL? 
129SD_SLS_DOCITMCredit/ debit memo request item numbernvarchar60 Allow NULL? 
130SD_INV_DOCNOCredit/ debit memo numbernvarchar100 Allow NULL? 
131SD_INV_DOCITMCredit/ debit memo item numbernvarchar60 Allow NULL? 
132BILLUPDLDOCNOBill-up due list document numbernvarchar100 Allow NULL? 
133ECRETNQTYLot Return Quantity used for Bill Up Due List Calculationdecimal153
134BILLUPQTYCalculated bill-up claim quantitydecimal153
135BU_SLS_DOCQTYBill up claim quantity in credit/ debit memo requestdecimal153
136BU_INV_DOCQTYBill-up claim quantity in credit/ debit memodecimal153
137BILLUPAMTCalculated claim amountdecimal152
138BILLUPAMTCURCurrency for calculated claim amountnvarchar50 Allow NULL? 
139BU_SLS_DOCAMTBill up claim amount in credit/debit memo requestdecimal152
140BU_SLS_DOCCURRCurrency of bill-up claim amount in Cr/ Dr memo requestnvarchar50 Allow NULL? 
141BU_INV_DOCAMTBill-up claim amount in credit/ debit memodecimal152
142BU_INV_DOCCURRBill-up credit/ debit memo amount currencynvarchar50 Allow NULL? 
143BU_SLS_DOCNOCredit/ debit memo request numbernvarchar100 Allow NULL? 
144BU_SLS_DOCITMCredit/ debit memo request item numbernvarchar60 Allow NULL? 
145BU_INV_DOCNOCredit/ debit memo numbernvarchar100 Allow NULL? 
146BU_INV_DOCITMCredit/ debit memo item numbernvarchar60 Allow NULL? 
147CANCEL_DOCTYPCancellation document typenvarchar20 Allow NULL? 
148CANCEL_DOCNOCancellation document numbernvarchar120 Allow NULL? 
149CANCEL_DOCITMCancellation document item numbernvarchar60 Allow NULL? 
150CANCEL_DOCDATECancellation document datenvarchar80 Allow NULL? 
151CANCEL_RUN_DATECancellation run datenvarchar80 Allow NULL? 
152CANCEL_INDCancellation indicator for audit trailchar10 Allow NULL? 
153CANCEL_INVNOCancellation invoice numbernvarchar100 Allow NULL? 
154CANCEL_INVITMCancellation Invoice item numbernvarchar60 Allow NULL? 
155CANCEL_INVDATECancellation invoice datenvarchar80 Allow NULL? 
156REJ_REASONReason for rejection of quotations and sales ordersnvarchar20 Allow NULL? 
157CREATED_BYName of Person who Created the Objectnvarchar120 Allow NULL? 
158CREATED_DTCreated onnvarchar80 Allow NULL? 
159CREATED_TMTime creatednvarchar60 Allow NULL? 
160LASTCHGDBYLast Changed Bynvarchar120 Allow NULL? 
161LASTCHGDDTChanged Onnvarchar80 Allow NULL? 
162CHANGED_TMLast changed atnvarchar60 Allow NULL? 
163DUMMY_1Dummy function in length 1char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPHT/DRMDETL~0YesYesCLUSTEREDAUDITNO, LOTNO, MANDT
/SAPHT/DRMDETL~001NoNoNONCLUSTEREDCANCEL_IND, LOTNO, PROC_CODE
/SAPHT/DRMDETL~002NoNoNONCLUSTEREDMATERIAL, MSBOOKPARTNO, TRACK_PARTNER, PROC_CODE
/SAPHT/DRMDETL~003NoNoNONCLUSTEREDPRODORD_NO
/SAPHT/DRMDETL~004NoNoNONCLUSTEREDEC_INV_ITM, EC_INV_NO

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