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
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
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
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
Logistics Execution :: Warehouse Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T340D721WM Default ValuesWarehouse Management
SQL:  selectupdate insert create

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

SELECT MANDT, LGNUM, VOME1, VOME2, MTBPS, MINPS, NUKQU, NUKTA, NUKTB, NUKIV, GEWEI, NAKAP, MFCHA, NUKUB, KOMTK, REPID, TEILV, NUKIT, BWPLU, BWMIN, NUKRF, KAPPC, LENVW, NUKLE, VERLE, LVSDZ, ENQUE, KZSCH, WMPPI, TEILS, MHDKZ, CHSWM, KOSPL, KWVZP, MINWM, BWFRM, APPPR, CHARR, NALEI, LISPL, ZEIEI, VOLEH, MNGPP, DECSY, KUNWE, LIFNR, NUKLB, CHSBL, VKORG, VSTEL, VTWEG, SPART, FGVNQ, YRELA, RRELA, BWUMP, PIPAS, NUKIQ, EATYP, EAPLA, LATER, T340D_DBTCH, SNDEC, CMACT, CMOFF_FOREGROUND, CMOFF_BACKGROUND, SPE_UNCH, SPE_DISPATCHING, BATCH_DETERM_EWM, NO_PP_GR, LOCAT, LGNUMWME FROM T340D
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2LGNUMWarehouse Number / Warehouse Complexnvarchar30CHAR(N' ')NoT300LGNUM Allow NULL? 
3VOME1First default value for unit of measurechar10CHAR(N' ')YesT340DVOME1 Allow NULL? 
4VOME2Second default value for unit of measurechar10CHAR(N' ')YesT340DVOME2 Allow NULL? 
5MTBPSMaximum number of items per transfer requirementdecimal40DEC((0))YesT340DMTBPS
6MINPSMaximum number of items in system inventory recordnvarchar40NUMC(N'0000')YesLVS_MINPS Allow NULL? 
7NUKQUNumber range for assignment of quant numbersnvarchar20CHAR(N' ')YesLVS_NUKQU Allow NULL? 
8NUKTANumber range for the assignment of transfer order numbersnvarchar20CHAR(N' ')YesLVS_NUKTA Allow NULL? 
9NUKTBNumber range for assignment of transfer requirement numbersnvarchar20CHAR(N' ')YesLVS_NUKTB Allow NULL? 
10NUKIVNumber range for assignment of inventory numbersnvarchar20CHAR(N' ')YesLVS_NUKIV Allow NULL? 
11GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
12NAKAPInd: error processing if capacity check data is missingchar10CHAR(N' ')YesT340DNAKAP Allow NULL? 
13MFCHAIndicator: error processing if batch number is missingchar10CHAR(N' ')YesT340DMFCHA Allow NULL? 
14NUKUBNumber range for the assignment of posting change numbersnvarchar20CHAR(N' ')YesLVS_NUKUB Allow NULL? 
15KOMTKPicking technique in warehouse managementchar10CHAR(N' ')YesLVS_KOMTK Allow NULL? 
16REPIDName of print reportnvarchar400CHAR(N' ')YesT340DREPID Allow NULL? 
17TEILVInd: partial picking allowed for (sales) delivery noteschar10CHAR(N' ')YesT340DTEILV Allow NULL? 
18NUKITInventory number range assignment for transfer ordersnvarchar20CHAR(N' ')YesLVS_NUKIT Allow NULL? 
19BWPLUMovement type: posting positive inventory differencesnvarchar30NUMC(N'000')YesT333T340DBWPLU Allow NULL? 
20BWMINMovement type: clearing negative inventory differencesnvarchar30NUMC(N'000')YesT333T340DBWMIN Allow NULL? 
21NUKRFNumber range for assignment of WM reference numbersnvarchar20CHAR(N' ')YesLVS_NUKRF Allow NULL? 
22KAPPCIndicator: activate link to subsystemchar10CHAR(N' ')YesT340DKAPPC Allow NULL? 
23LENVWIndicator: Storage unit management engagedchar10CHAR(N' ')YesT340DLENVW Allow NULL? 
24NUKLENumber range for the assignment of storage unit numbersnvarchar20CHAR(N' ')YesLVS_NUKLE Allow NULL? 
25VERLEType of number assignment for storage unitschar10CHAR(N' ')YesT340DVERLE Allow NULL? 
26LVSDZIndicator: Warehouse Number as Decentralized ECC LVSchar10CHAR(N' ')YesLVS_LVSDZ Allow NULL? 
27ENQUEBlocking logic in Warehouse Managementchar10CHAR(N' ')YesLVS_ENQUE Allow NULL? 
28KZSCHIndicator: Posting to interim stor.bin acc.to movement typechar10CHAR(N' ')YesT340DKZSCH Allow NULL? 
29WMPPIActive WM-PP interfacechar10CHAR(N' ')YesT340DWMPPI Allow NULL? 
30TEILSPartial picking for multiple processingchar10CHAR(N' ')YesLVS_TEILS Allow NULL? 
31MHDKZManagement of shelf life expiration date activechar10CHAR(N' ')YesLVS_MHDKZ Allow NULL? 
32CHSWMSearch procedure for batch determinationnvarchar60CHAR(N' ')YesT683KALSMA_CH Allow NULL? 
33KOSPLSplit transfer order based on the picking areachar10CHAR(N' ')YesT340DKOSPL Allow NULL? 
34KWVZPTime of comparison for forming picking waveschar10CHAR(N' ')YesT340_KWVZP Allow NULL? 
35MINWMStorage bin stock is not managed in this warehouse numberchar10CHAR(N' ')YesT340DMINWM Allow NULL? 
36BWFRMWM Movement Type for Floor Ready Merchandisenvarchar30NUMC(N'000')YesT333T340DBWFRM Allow NULL? 
37APPPRAppointments profilenvarchar30CHAR(N' ')YesTWAP1APPPR Allow NULL? 
38CHARRBatch confirmation to PP for fixed production storage binschar10CHAR(N' ')YesT340D_CHARR Allow NULL? 
39NALEIMessage handing for performance datachar10CHAR(N' ')YesT340DNALEI Allow NULL? 
40LISPLDelivery split according to warehouse numberchar10CHAR(N' ')YesT340DLISPL Allow NULL? 
41ZEIEITime unit for performance datanvarchar30UNIT(N' ')YesT006LVS_ZEIEI Allow NULL? 
42VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
43MNGPPInd. for compl.mat.staging for transf.requirements from PPchar10CHAR(N' ')YesT340DMNGPP Allow NULL? 
44DECSYReference to External Warehouse Managementchar10CHAR(N' ')No/SPE/DECSY Allow NULL? 
45KUNWEShip-to-party for delivery for WMSnvarchar100CHAR(N' ')Yes*LVS_KUNWE Allow NULL? 
46LIFNRAccount number of vendor for inbound delivery WMSnvarchar100CHAR(N' ')Yes*LVS_LIFNR Allow NULL? 
47NUKLBNumber range for assignment of whse material documentsnvarchar20CHAR(N' ')YesLVS_NUKLB Allow NULL? 
48CHSBLConsider batch-neutral bulk areas despite batch searchchar10CHAR(N' ')YesT340DCHSBL Allow NULL? 
49VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
50VSTELShipping Point/Receiving Pointnvarchar40CHAR(N' ')YesTVSTVSTEL Allow NULL? 
51VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
52SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
53FGVNQSeparate confirmation of pick and transferchar10CHAR(N' ')YesT340DFGVNQ Allow NULL? 
54YRELARatio Workload to Usersdecimal153DEC((0))YesLRF_RELAT
55RRELARatio Workload to Usersdecimal153DEC((0))YesLRF_RELAT
56BWUMPMovement type for repacking onto HUsnvarchar30NUMC(N'000')YesT333T340DBWUMP Allow NULL? 
57PIPASPick and pack allowed during TO confirmationchar10CHAR(N' ')YesT340DPIPAS Allow NULL? 
58NUKIQNumber range for inventory numbers in quant inventorynvarchar20CHAR(N' ')YesLVS_NUKIQ Allow NULL? 
59EATYPStorage type to which packed or unpacked qty is postednvarchar30CHAR(N' ')YesT301T340D_EATYP Allow NULL? 
60EAPLAStorage bin to which packed or unpacked qty is postednvarchar100CHAR(N' ')YesLAGPT340D_EAPLA Allow NULL? 
61LATERDelayed Update of Outbound Deliverychar10CHAR(N' ')YesLTAK_LATER Allow NULL? 
62T340D_DBTCHDistribution Mode for the Deliverychar10CHAR(N' ')YesT340D_DBTCH Allow NULL? 
63SNDECIndicator: Allow Serial Numbers in Decentralized WMSchar10CHAR(N' ')YesSNDEC Allow NULL? 
64CMACTCommunication with the Warehouse Systemchar10CHAR(N' ')Yes/SPE/T340D_CMACT Allow NULL? 
65CMOFF_FOREGROUNDEmergency Control of Change Management in Foregroundchar10CHAR(N' ')YesT340D_CMOFF_FOREGROUND Allow NULL? 
66CMOFF_BACKGROUNDEmergency Control of Change Management in Backgroundchar10CHAR(N' ')YesT340D_CMOFF_BACKGROUND Allow NULL? 
67SPE_UNCHDistribute Unchecked Deliveries to Warehousechar10CHAR(N' ')Yes/SPE/T340D_UNCH Allow NULL? 
68SPE_DISPATCHINGMessage Dispatchingchar10CHAR(N' ')Yes/SPE/VL60_DISPATCH Allow NULL? 
69BATCH_DETERM_EWMBatch Determination in EWM via Batch Attribute Replicationchar10CHAR(N' ')Yes/SPE/BATCH_DETERM_FLAG Allow NULL? 
70NO_PP_GRIndicator: Goods Receipt from EWM Onlychar10CHAR(N' ')YesDE_NO_PP_GR Allow NULL? 
71LOCATSitenvarchar40CHAR(N' ')YesLLOCTLTRM_LOCAT Allow NULL? 
72LGNUMWMEWarehouse Number of the Decentralized SCM Systemnvarchar40CHAR(N' ')YesDE_LGNUMWME Allow NULL? 
NamePrimaryUniqueTypeColumns
T340D~0YesYesCLUSTEREDLGNUM, MANDT