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

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
Financials :: Financial Supply Chain Management :: Collections Management :: Accounts Receivable Accounting Process Integration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FDM_DOC_MIRROR513Document Information (Raw Data in Substitute System)Accounts Receivable Accounting Process Integration
SQL:  selectupdate insert create

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

SELECT MANDT, M_BUKRS, ITEM_TYPE, ITEM_KEY, INVOICE_REF_TYPE, INVOICE_REF_KEY, M_XPOSTED, M_KUNNR, M_BELNR, M_GJAHR, M_BUZEI, M_REBZT, M_BELNR_CORR, M_GJAHR_CORR, M_BUZEI_CORR, M_FILKD, AMT_DOCCUR, CURRENCY, LC_AMOUNT, DB_CR_IND, XPAYMT_ON_ACCT, XCLOSED, CLOSED_AT, XREVERSED, DOC_DATE, INV_REF, BLINE_DATE, DSCT_DAYS1, DSCT_DAYS2, NETTERMS, DSCT_PCT1, DSCT_PCT2, FIXEDTERMS, DISC_BASE, DSC_AMT_DC, PYMT_METH, PMNT_BLOCK, DUNN_BLOCK, LAST_DUNN, DUNN_LEVEL, DUNN_AREA, ITEM_TEXT, REF_DOC_NO, REF_KEY_1, REF_KEY_2, ALLOC_NMBR, AW_OBJ_TYPE, AW_OBJ_KEY, AW_LOGSYSTEM, M_TIMESTAMP, M_UNAME FROM FDM_DOC_MIRROR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2M_BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3ITEM_TYPEObject Type of Accounting Documentnvarchar100CHAR(N' ')No*FDM_MIRR_SWO_OBJTYP Allow NULL? 
4ITEM_KEYObject Key of Accounting Document in Original Systemnvarchar700CHAR(N' ')NoFDM_MIRR_SWO_TYPEID Allow NULL? 
5INVOICE_REF_TYPEObject Type of Accounting Doc to which Transaction Belongsnvarchar100CHAR(N' ')No*FDM_MIRR_INV_REF_SWO_OBJTYP Allow NULL? 
6INVOICE_REF_KEYKey of Accounting Document to which Transaction Belongsnvarchar700CHAR(N' ')NoFDM_MIRR_INV_REF_SWO_TYPEID Allow NULL? 
7M_XPOSTEDLine Item Posted in Substitute Systemchar10CHAR(N' ')NoFDM_MIRR_XPOSTED Allow NULL? 
8M_KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
9M_BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
10M_GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
11M_BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
12M_REBZTType of Documentchar10CHAR(N' ')YesFDM_MIRR_REBZT Allow NULL? 
13M_BELNR_CORRDocument Number of Posted Adjustment Documentnvarchar100CHAR(N' ')YesFDM_MIRR_BELNR_CORR Allow NULL? 
14M_GJAHR_CORRFiscal Year of Posted Adjustment Documentnvarchar40NUMC(N'0000')YesFDM_MIRR_GJAHR_CORR Allow NULL? 
15M_BUZEI_CORRNumber of Posting Item Within Adjustment Documentnvarchar30NUMC(N'000')YesFDM_MIRR_BUZEI_CORR Allow NULL? 
16M_FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
17AMT_DOCCURAmount in document currencydecimal234DEC((0))YesBAPIWRBTR
18CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
19LC_AMOUNTAmount in Local Currencydecimal234DEC((0))YesBAPIDMBTR
20DB_CR_INDDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
21XPAYMT_ON_ACCTItem is a Payment On Accountchar10CHAR(N' ')YesFDM_MIRR_XPAYMT_ON_ACCT Allow NULL? 
22XCLOSEDInvoice Completedchar10CHAR(N' ')YesFDM_MIRR_XCLOSED Allow NULL? 
23CLOSED_ATDate on which the item was closednvarchar80DATS(N'00000000')YesFDM_MIRR_CLOSED_AT Allow NULL? 
24XREVERSEDLine Item Reversedchar10CHAR(N' ')YesFDM_MIRR_XREVERSED Allow NULL? 
25DOC_DATEDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
26INV_REFNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
27BLINE_DATEBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
28DSCT_DAYS1Cash discount days 1decimal30DEC((0))YesDZBD1T
29DSCT_DAYS2Cash discount days 2decimal30DEC((0))YesDZBD2T
30NETTERMSNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
31DSCT_PCT1Cash Discount Percentage 1decimal53DEC((0))YesDZBD1P
32DSCT_PCT2Cash Discount Percentage 2decimal53DEC((0))YesDZBD2P
33FIXEDTERMSFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
34DISC_BASEAmount Eligible for Cash Discount in Document Currencydecimal234DEC((0))YesBAPISKFBT
35DSC_AMT_DCCash Discount Amount in Document Currencydecimal234DEC((0))YesBAPIWSKTO
36PYMT_METHPayment Method in Substitute Systemchar10CHAR(N' ')Yes*FDM_MIRR_DZLSCH Allow NULL? 
37PMNT_BLOCKLine Item Blocked for Payment?char10CHAR(N' ')Yes*FDM_MIRR_DZLSPR Allow NULL? 
38DUNN_BLOCKLine Item Blocked for Dunning?char10CHAR(N' ')Yes*FDM_MIRR_MANSP Allow NULL? 
39LAST_DUNNLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
40DUNN_LEVELDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
41DUNN_AREADunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
42ITEM_TEXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
43REF_DOC_NOReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
44REF_KEY_1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
45REF_KEY_2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
46ALLOC_NMBRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
47AW_OBJ_TYPEReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
48AW_OBJ_KEYReference Keynvarchar200CHAR(N' ')YesAWKEY Allow NULL? 
49AW_LOGSYSTEMLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
50M_TIMESTAMPTime Stamep: Time Data Was Created or Updateddecimal150DEC((0))YesBDM_COLL_TIMESTAMP
51M_UNAMEUser Namenvarchar120CHAR(N' ')YesSYUNAME Allow NULL? 
NamePrimaryUniqueTypeColumns
FDM_DOC_MIRROR~0YesYesCLUSTEREDM_XPOSTED, INVOICE_REF_KEY, INVOICE_REF_TYPE, ITEM_KEY, ITEM_TYPE, M_BUKRS, MANDT
FDM_DOC_MIRROR~001NoNoNONCLUSTEREDM_XPOSTED, M_BUZEI, M_GJAHR, M_BELNR, M_BUKRS
FDM_DOC_MIRROR~002NoNoNONCLUSTEREDM_REBZT, XCLOSED, M_XPOSTED, M_KUNNR, M_BUKRS