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  | MMINKON_UP
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
Materials Management :: Inventory Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MMINKON_UP461Corrections due to Technical Problems with StockInventory Management
SQL:  selectupdate insert create

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

SELECT MANDT, LFYEAR, LFDNR, TABNAME, FIELD, MATNR, BWKEY, BWTAR, WERKS, LGORT, CHARG, SOBKZ, LIFNR, KUNNR, VBELN, POSNR, PSPNR, LFGJA, LFMON, DATUM, UZEIT, ERNAME, PROG_KEY, VERSION, SAPRL, OLD_VALUE, NEW_VALUE, OLD_VAL_C, NEW_VAL_C, CANCEL_YR, CANCEL_NR, OWNER, MESSAGE_NR, MESSAGE_YEAR, MBLNR, MJAHR, ZEILE, EBELN, EBELP, STUNR, ZAEHK, ZEKKN, VGABE, GJAHR, BELNR, BUZEI FROM MMINKON_UP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2LFYEARYear in which the correction was carried outnvarchar40NUMC(N'0000')NoLFYEAR Allow NULL? 
3LFDNRSequential Number of Correction in Current Yearnvarchar100NUMC(N'0000000000')NoLFDNR_MM Allow NULL? 
4TABNAMETable name (30)nvarchar300CHAR(N' ')YesTABN_30 Allow NULL? 
5FIELDField name (30)nvarchar300CHAR(N' ')YesFELD_30 Allow NULL? 
6MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
7BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
8BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
9WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
10LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
11CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
12SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
13LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
14KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
15VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
16POSNRItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
17PSPNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
18LFGJAFiscal Year of Current Periodnvarchar40NUMC(N'0000')YesLFGJA Allow NULL? 
19LFMONCurrent period (posting period)nvarchar20NUMC(N'00')YesLFMON Allow NULL? 
20DATUMDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
21UZEITTime of Entrynvarchar60TIMS(N'000000')YesCPUTM Allow NULL? 
22ERNAMEChanged bynvarchar120CHAR(N' ')YesUSER Allow NULL? 
23PROG_KEYProgram used to carry out the updatenvarchar300CHAR(N' ')YesPROG_KEY Allow NULL? 
24VERSIONProgram versionnvarchar50CHAR(N' ')YesVERS_MM Allow NULL? 
25SAPRLSAP Releasenvarchar40CHAR(N' ')YesSAPRL Allow NULL? 
26OLD_VALUEValue of field before updatedecimal153DEC((0))YesOLD_VALUE
27NEW_VALUEValue of field after updatedecimal153DEC((0))YesNEW_VALUE
28OLD_VAL_CValue Before the Update (Character)nvarchar300CHAR(N' ')YesOLD_VAL_C Allow NULL? 
29NEW_VAL_CValue After the Update (Character)nvarchar300CHAR(N' ')YesNEW_VAL_C Allow NULL? 
30CANCEL_YRYear in which the correction was carried outnvarchar40NUMC(N'0000')YesLFYEAR Allow NULL? 
31CANCEL_NRSequential Number of Correction in Current Yearnvarchar100NUMC(N'0000000000')YesLFDNR_MM Allow NULL? 
32OWNERAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
33MESSAGE_NRNumber of Customer Message in CSNnvarchar100NUMC(N'0000000000')YesMMIM_MESSAGE_NUMBER Allow NULL? 
34MESSAGE_YEARYear of Customer Message in CSNnvarchar40NUMC(N'0000')YesMMIM_MESSAGE_YEAR Allow NULL? 
35MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
36MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
37ZEILEItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
38EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
39EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
40STUNRStep numbernvarchar30NUMC(N'000')Yes*STUNR Allow NULL? 
41ZAEHKCondition counternvarchar20NUMC(N'00')YesDZAEHK Allow NULL? 
42ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
43VGABETransaction/event type, purchase order historychar10CHAR(N' ')YesVGABE Allow NULL? 
44GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
45BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
46BUZEIItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
NamePrimaryUniqueTypeColumns
MMINKON_UP~0YesYesCLUSTEREDLFDNR, LFYEAR, MANDT

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