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/DRMSTAG
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution High Tech :: Distributor-Reseller-Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPHT/DRMSTAG1074DRM Staging AreaDistributor-Reseller-Management
SQL:  selectupdate insert create

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

SELECT MANDT, STAGDOCNO, INT_XMNO, TRANSM_NO, IDOCNO, IDOC_TYPE, EFF_DATE, SALES_ORG, DIST_CHNL, DIVISION, TRANSM_DATE, XN_CODE, EDIXNCODE, PROC_CODE, TRACK_PARTNER, PARTNER, MS_DR_IND, MSBOOKPARTNO, MATERIAL, DR_MATERIAL, LOTTYPE, SELLTHRUQT, QTY_UNIT, DR_STQTY, DR_QTY_UNIT, DR_QTY_EDI_UNIT, ALT_STQTY, ALT_QTY_UNIT, SALES_REP, END_CUST, DR_END_CUST, EXT_REFNO, ECPARTFN, IM_END_CUST, DR_IM_END_CUST, IM_EXT_REFNO, IM_ECPARTFN, EC_INV_NO, EC_INV_ITM, EC_CM_NO, EC_CM_ITM, RESALEPRC, EDIRESLPRC, RESALECURR, EDIRESLCURR, RESL_PRC_UNIT, RESL_PRC_UOM, EDIRESLPRCUOM, RESL_CON_NUM, RESL_CON_DEN, EC_INV_DT, EC_SHP_DT, PROC_STATUS, COST, EDICOSTPRC, COST_CURR, EDICOSTCURR, COST_PRC_UNIT, PRC_UOM, EDICOSTPRCUOM, COST_CON_NUM, COST_CON_DEN, INT_BRANCH, BRANCH, STOCK_LOC, LOGHANDLE, ERRORCODE, REROUTEFLAG, ENDCSTADRNO, IM_ENDCSTADRNO, BRADRNO, TRANS_DATE, VAL_MNCUR, MN_CURR, CUS_REF_FLD, SD_AGR_NO, SD_AGR_ITM, SD_AGR_RATE, SD_AGR_CURR, PRIC_UNIT, SD_AGR_UOM, AGRM_CON_NUM, AGRM_CON_DEN, REP_AGR_RATE, EDI_AGR_RATE, REP_AGR_CURR, EDI_AGR_CURR, REP_PRIC_UNIT, REP_PRC_UOM, EDI_PRC_UOM, AGR_CON_NUM, AGR_CON_DEN, REP_CLAIM_AMOUNT, EDI_CLAIM_AMOUNT, REP_CLAIM_CURR, EDI_CLAIM_CURR, INV_DOCNO, INV_DOCITM, RES_IDOCNO, DESIGN_REG_NO, CREATED_BY, CREATED_DT, CREATED_TM, LASTCHGDBY, LASTCHGDDT, CHANGED_TM, DUMMY_1 FROM /SAPHT/DRMSTAG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2STAGDOCNOIDOC staging table document numbernvarchar100CHAR(N' ')No/SAPHT/DRM_STAGDOCNO Allow NULL? 
3INT_XMNODRM internal transmission numbernvarchar200CHAR(N' ')Yes/SAPHT/DRM_INTXMNO Allow NULL? 
4TRANSM_NOEDI transmission numbernvarchar200CHAR(N' ')Yes/SAPHT/DRM_TRANSMNO Allow NULL? 
5IDOCNOIDoc numbernvarchar160NUMC(N'0000000000000000')YesEDI_DOCNUM Allow NULL? 
6IDOC_TYPEMessage Typenvarchar300CHAR(N' ')Yes*EDI_MESTYP Allow NULL? 
7EFF_DATEEDI transmission effective datenvarchar80DATS(N'00000000')Yes/SAPHT/DRM_EFFDATE Allow NULL? 
8SALES_ORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
9DIST_CHNLDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
10DIVISIONDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
11TRANSM_DATEEDI transmission datenvarchar80DATS(N'00000000')Yes/SAPHT/DRM_TRANSMDATE Allow NULL? 
12XN_CODEDRM relevant transaction codenvarchar200CHAR(N' ')Yes*/SAPHT/DRM_XNCODE Allow NULL? 
13EDIXNCODEEDI transaction codenvarchar20CHAR(N' ')Yes/SAPHT/DRM_EDIXNCODE Allow NULL? 
14PROC_CODEDRM relevant processing codenvarchar20CHAR(N' ')Yes/SAPHT/DRM_PROCCODE Allow NULL? 
15TRACK_PARTNERTracking partnernvarchar100CHAR(N' ')Yes*/SAPHT/DRM_TRACK_PARTNER Allow NULL? 
16PARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
17MS_DR_INDIndicates manufacturer/supplier or distributor/reseller lotchar10CHAR(N' ')Yes/SAPHT/DRM_MSDRIND Allow NULL? 
18MSBOOKPARTNOManufacturer book part numbernvarchar180CHAR(N' ')Yes*/SAPHT/DRM_MSBOOKPARTNO Allow NULL? 
19MATERIALMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
20DR_MATERIALMaterial as maintained in DRM partner's systemnvarchar350CHAR(N' ')Yes/SAPHT/DRM_DR_MATERIAL Allow NULL? 
21LOTTYPEDRM lot typechar10CHAR(N' ')Yes/SAPHT/DRM_LOTTYPE Allow NULL? 
22SELLTHRUQTReported material quantity in base unitdecimal153QUAN((0))Yes/SAPHT/DRM_SELLTTHRUQTY
23QTY_UNITBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
24DR_STQTYQuantity as reported by distributor/ resellerdecimal153QUAN((0))Yes/SAPHT/DRM_DRSTQTY
25DR_QTY_UNITUnit of measure for reported quantitynvarchar30UNIT(N' ')Yes*/SAPHT/DRM_DRUOM Allow NULL? 
26DR_QTY_EDI_UNITReported Unit of measure in IDoc (ISO Format)nvarchar30CHAR(N' ')Yes/SAPHT/DRM_ISODRUOM Allow NULL? 
27ALT_STQTYReported quantity in alternative unitdecimal153QUAN((0))Yes/SAPHT/DRM_ALTSTQTY
28ALT_QTY_UNITAlternative unit of measure for reported quantitynvarchar30UNIT(N' ')Yes*/SAPHT/DRM_ALTUOM Allow NULL? 
29SALES_REPBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
30END_CUSTDRM end customernvarchar100CHAR(N' ')Yes*/SAPHT/DRM_ENDCST Allow NULL? 
31DR_END_CUSTResale customer as reported by distributor/ resellernvarchar200CHAR(N' ')Yes/SAPHT/DRM_DRENDCST Allow NULL? 
32EXT_REFNOResale customer external reference numbernvarchar110CHAR(N' ')Yes/SAPHT/DRM_EXT_CUST_REFNO Allow NULL? 
33ECPARTFNQualifier for partner functionnvarchar30CHAR(N' ')YesEDI_3035 Allow NULL? 
34IM_END_CUSTDRM end customernvarchar100CHAR(N' ')Yes*/SAPHT/DRM_ENDCST Allow NULL? 
35DR_IM_END_CUSTResale customer as reported by distributor/ resellernvarchar200CHAR(N' ')Yes/SAPHT/DRM_DRENDCST Allow NULL? 
36IM_EXT_REFNOResale customer external reference numbernvarchar110CHAR(N' ')Yes/SAPHT/DRM_EXT_CUST_REFNO Allow NULL? 
37IM_ECPARTFNQualifier for partner functionnvarchar30CHAR(N' ')YesEDI_3035 Allow NULL? 
38EC_INV_NOEnd customer invoice numbernvarchar200CHAR(N' ')Yes/SAPHT/DRM_ECINVDOC Allow NULL? 
39EC_INV_ITMResale invoice item numbernvarchar60NUMC(N'000000')Yes*/SAPHT/DRM_ECINVITM Allow NULL? 
40EC_CM_NOEnd customer return credit memo numbernvarchar200CHAR(N' ')Yes/SAPHT/DRM_ECCMDOC Allow NULL? 
41EC_CM_ITMEnd customer return credit memo item numbernvarchar60CHAR(N' ')Yes/SAPHT/DRM_ECCMITM Allow NULL? 
42RESALEPRCResale pricedecimal112CURR((0))Yes/SAPHT/DRM_RESPRC
43EDIRESLPRCReported resale rate in EDInvarchar150CHAR(N' ')Yes/SAPHT/DRM_EDIRESPRC Allow NULL? 
44RESALECURRResale price currencynvarchar50CUKY(N' ')Yes*/SAPHT/DRM_RESCURR Allow NULL? 
45EDIRESLCURRResale currency in EDInvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDIRESCURR Allow NULL? 
46RESL_PRC_UNITPricing quantity for resale pricedecimal50DEC((0))Yes/SAPHT/DRM_RESPRCUNIT
47RESL_PRC_UOMUnit of measure for pricing quantitynvarchar30UNIT(N' ')Yes*/SAPHT/DRM_RESPRCUOM Allow NULL? 
48EDIRESLPRCUOMResale unit of measurement in EDI itemnvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDIRESPRCUOM Allow NULL? 
49RESL_CON_NUMNumerator for coversion to base unitdecimal50DEC((0))Yes/SAPHT/DRM_RESL_COND_NUMER
50RESL_CON_DENDenominator for conversion to base unit of materialdecimal50DEC((0))Yes/SAPHT/DRM_RESL_COND_DENOM
51EC_INV_DTResale invoice datenvarchar80DATS(N'00000000')Yes/SAPHT/DRM_ECINVDATE Allow NULL? 
52EC_SHP_DTResale shipping datenvarchar80DATS(N'00000000')Yes/SAPHT/DRM_ECSHPDATE Allow NULL? 
53PROC_STATUSProcessing status of staging recordchar10CHAR(N' ')Yes/SAPHT/DRM_STAGSTAT Allow NULL? 
54COSTCost price of materialdecimal112CURR((0))Yes/SAPHT/DRM_INVCOST
55EDICOSTPRCReported cost price in EDI line itemnvarchar150CHAR(N' ')Yes/SAPHT/DRM_EDICSTPRC Allow NULL? 
56COST_CURRInventory cost currencynvarchar50CUKY(N' ')Yes*/SAPHT/DRM_INVCURR Allow NULL? 
57EDICOSTCURRReported cost currency in EDI line itemnvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDICSTCURR Allow NULL? 
58COST_PRC_UNITInventory pricing unitdecimal50DEC((0))Yes/SAPHT/DRM_INVCOSTUNIT
59PRC_UOMUnit of measure for inventory cost pricing quantitynvarchar30UNIT(N' ')Yes*/SAPHT/DRM_INVCOSTUOM Allow NULL? 
60EDICOSTPRCUOMCost Unit of measurement in EDInvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDICSTPRCUOM Allow NULL? 
61COST_CON_NUMNumerator for coversion to base unitdecimal50DEC((0))Yes/SAPHT/DRM_COST_COND_NUMER
62COST_CON_DENDenominator for conversion to base unit of materialdecimal50DEC((0))Yes/SAPHT/DRM_COST_COND_DENOM
63INT_BRANCHManufacturer/ supplier's code for reseller unitnvarchar100CHAR(N' ')Yes*/SAPHT/DRM_INTBRANCH Allow NULL? 
64BRANCHDistributor/ reseller's code for reseller unitnvarchar200CHAR(N' ')Yes/SAPHT/DRM_BRANCH Allow NULL? 
65STOCK_LOCStocking locationnvarchar100CHAR(N' ')Yes/SAPHT/DRM_STLOC Allow NULL? 
66LOGHANDLEApplication Log: Log Handlenvarchar220CHAR(N' ')YesBALLOGHNDL Allow NULL? 
67ERRORCODEError Code for storing errors in a recordnvarchar1000CHAR(N' ')Yes/SAPHT/DRM_ERROR_CODE Allow NULL? 
68REROUTEFLAGReroute flagchar10CHAR(N' ')Yes/SAPHT/DRM_RERTFLAG Allow NULL? 
69ENDCSTADRNOAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
70IM_ENDCSTADRNOAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
71BRADRNOAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
72TRANS_DATEReported datenvarchar80DATS(N'00000000')Yes/SAPHT/DRM_XNDT Allow NULL? 
73VAL_MNCURSum of values in the transmission in main currencydecimal152CURR((0))YesVAL_MNCUR
74MN_CURRManufacturer/ supplier's currencynvarchar50CUKY(N' ')Yes*MAIN_CURR Allow NULL? 
75CUS_REF_FLDShip-and-debit claim reference numbernvarchar350CHAR(N' ')Yes/SAPHT/DRM_SDCUSREF Allow NULL? 
76SD_AGR_NOShip-and-debit agreement numbernvarchar100CHAR(N' ')Yes/SAPHT/DRM_SDAGRNO Allow NULL? 
77SD_AGR_ITMShip-and-debit agreement item numbernvarchar60NUMC(N'000000')Yes*/SAPHT/DRM_SDAGRITM Allow NULL? 
78SD_AGR_RATEShip-and-debit agreement ratedecimal112CURR((0))Yes/SAPHT/DRM_SDAGRRATE
79SD_AGR_CURRShip-and-debit agreement rate currencynvarchar50CUKY(N' ')Yes*/SAPHT/DRM_SDAGRCURR Allow NULL? 
80PRIC_UNITShip-and-debit agreement pricing unitdecimal50DEC((0))Yes/SAPHT/DRM_AGR_PRC_UNIT
81SD_AGR_UOMUnit of measure for SD Agreementnvarchar30UNIT(N' ')Yes*/SAPHT/DRM_SDAGRCUOM Allow NULL? 
82AGRM_CON_NUMNumerator for coversion to base unitdecimal50DEC((0))Yes/SAPHT/DRM_AGR_COND_NUMER
83AGRM_CON_DENDenominator for conversion to base unit of materialdecimal50DEC((0))Yes/SAPHT/DRM_AGR_COND_DENOM
84REP_AGR_RATEShip-and-debit agreement rate reported by distributordecimal112CURR((0))Yes/SAPHT/DRM_REPAGRRATE
85EDI_AGR_RATEReported agreement rate in EDInvarchar150CHAR(N' ')Yes/SAPHT/DRM_EDIAGRRATE Allow NULL? 
86REP_AGR_CURRCurrency of reported ship-and-debit agreement ratenvarchar50CUKY(N' ')Yes*/SAPHT/DRM_REPAGRCURR Allow NULL? 
87EDI_AGR_CURRAgreement currency in EDInvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDIAGRCURR Allow NULL? 
88REP_PRIC_UNITPricing unit for reported ship-and-debit agreement pricedecimal50DEC((0))Yes/SAPHT/DRM_REPPRICUNIT
89REP_PRC_UOMUnit of measure for pricing quantitynvarchar30UNIT(N' ')Yes*/SAPHT/DRM_REPPRICUOM Allow NULL? 
90EDI_PRC_UOMReported agreement unit of measure in EDInvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDIPRICUOM Allow NULL? 
91AGR_CON_NUMNumerator for coversion to base unitdecimal50DEC((0))Yes/SAPHT/DRM_AGR_COND_NUMER
92AGR_CON_DENDenominator for conversion to base unit of materialdecimal50DEC((0))Yes/SAPHT/DRM_AGR_COND_DENOM
93REP_CLAIM_AMOUNTReported ship-and-debit claim amountdecimal152CURR((0))Yes/SAPHT/DRM_REPCLAIMAMT
94EDI_CLAIM_AMOUNTReported claim amount in EDInvarchar180CHAR(N' ')Yes/SAPHT/DRM_EDICLAIMAMT Allow NULL? 
95REP_CLAIM_CURRReported ship-and-debit claim amount currencynvarchar50CUKY(N' ')Yes*/SAPHT/DRM_REPCLAIMCURR Allow NULL? 
96EDI_CLAIM_CURRClaim currency in EDInvarchar30CHAR(N' ')Yes/SAPHT/DRM_EDICLAIMCURR Allow NULL? 
97INV_DOCNOCredit/ debit memo numbernvarchar100CHAR(N' ')Yes*/SAPHT/DRM_INVDOC_NO Allow NULL? 
98INV_DOCITMCredit/ debit memo item numbernvarchar60NUMC(N'000000')Yes*/SAPHT/DRM_INVDOC_ITM Allow NULL? 
99RES_IDOCNOResponse IDoc numbernvarchar160NUMC(N'0000000000000000')Yes/SAPHT/DRM_RERT_IDOCNO Allow NULL? 
100DESIGN_REG_NODesign registration numbernvarchar300CHAR(N' ')Yes/SAPHT/DRM_DESIGN_REG_NO Allow NULL? 
101CREATED_BYName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
102CREATED_DTCreated onnvarchar80DATS(N'00000000')Yes/SAPHT/DRM_CRDATE Allow NULL? 
103CREATED_TMTime creatednvarchar60TIMS(N'000000')YesC_TIME Allow NULL? 
104LASTCHGDBYLast Changed Bynvarchar120CHAR(N' ')YesUPNAM Allow NULL? 
105LASTCHGDDTChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
106CHANGED_TMLast changed atnvarchar60TIMS(N'000000')YesAS4TIME Allow NULL? 
107DUMMY_1Dummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPHT/DRMSTAG~0YesYesCLUSTEREDSTAGDOCNO, MANDT
/SAPHT/DRMSTAG~001NoNoNONCLUSTEREDINT_XMNO
/SAPHT/DRMSTAG~002NoNoNONCLUSTEREDTRANSM_NO, TRACK_PARTNER
/SAPHT/DRMSTAG~003NoNoNONCLUSTEREDPROC_CODE, PROC_STATUS, CUS_REF_FLD

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