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  | T340D
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
5OVPM154Outgoing Payments
6OINM101Whse Journal
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2LGNUMWarehouse Number / Warehouse Complexnvarchar30 Allow NULL? 
3VOME1First default value for unit of measurechar10 Allow NULL? 
4VOME2Second default value for unit of measurechar10 Allow NULL? 
5MTBPSMaximum number of items per transfer requirementdecimal40
6MINPSMaximum number of items in system inventory recordnvarchar40 Allow NULL? 
7NUKQUNumber range for assignment of quant numbersnvarchar20 Allow NULL? 
8NUKTANumber range for the assignment of transfer order numbersnvarchar20 Allow NULL? 
9NUKTBNumber range for assignment of transfer requirement numbersnvarchar20 Allow NULL? 
10NUKIVNumber range for assignment of inventory numbersnvarchar20 Allow NULL? 
11GEWEIWeight Unitnvarchar30 Allow NULL? 
12NAKAPInd: error processing if capacity check data is missingchar10 Allow NULL? 
13MFCHAIndicator: error processing if batch number is missingchar10 Allow NULL? 
14NUKUBNumber range for the assignment of posting change numbersnvarchar20 Allow NULL? 
15KOMTKPicking technique in warehouse managementchar10 Allow NULL? 
16REPIDName of print reportnvarchar400 Allow NULL? 
17TEILVInd: partial picking allowed for (sales) delivery noteschar10 Allow NULL? 
18NUKITInventory number range assignment for transfer ordersnvarchar20 Allow NULL? 
19BWPLUMovement type: posting positive inventory differencesnvarchar30 Allow NULL? 
20BWMINMovement type: clearing negative inventory differencesnvarchar30 Allow NULL? 
21NUKRFNumber range for assignment of WM reference numbersnvarchar20 Allow NULL? 
22KAPPCIndicator: activate link to subsystemchar10 Allow NULL? 
23LENVWIndicator: Storage unit management engagedchar10 Allow NULL? 
24NUKLENumber range for the assignment of storage unit numbersnvarchar20 Allow NULL? 
25VERLEType of number assignment for storage unitschar10 Allow NULL? 
26LVSDZIndicator: Warehouse Number as Decentralized ECC LVSchar10 Allow NULL? 
27ENQUEBlocking logic in Warehouse Managementchar10 Allow NULL? 
28KZSCHIndicator: Posting to interim stor.bin acc.to movement typechar10 Allow NULL? 
29WMPPIActive WM-PP interfacechar10 Allow NULL? 
30TEILSPartial picking for multiple processingchar10 Allow NULL? 
31MHDKZManagement of shelf life expiration date activechar10 Allow NULL? 
32CHSWMSearch procedure for batch determinationnvarchar60 Allow NULL? 
33KOSPLSplit transfer order based on the picking areachar10 Allow NULL? 
34KWVZPTime of comparison for forming picking waveschar10 Allow NULL? 
35MINWMStorage bin stock is not managed in this warehouse numberchar10 Allow NULL? 
36BWFRMWM Movement Type for Floor Ready Merchandisenvarchar30 Allow NULL? 
37APPPRAppointments profilenvarchar30 Allow NULL? 
38CHARRBatch confirmation to PP for fixed production storage binschar10 Allow NULL? 
39NALEIMessage handing for performance datachar10 Allow NULL? 
40LISPLDelivery split according to warehouse numberchar10 Allow NULL? 
41ZEIEITime unit for performance datanvarchar30 Allow NULL? 
42VOLEHVolume unitnvarchar30 Allow NULL? 
43MNGPPInd. for compl.mat.staging for transf.requirements from PPchar10 Allow NULL? 
44DECSYReference to External Warehouse Managementchar10 Allow NULL? 
45KUNWEShip-to-party for delivery for WMSnvarchar100 Allow NULL? 
46LIFNRAccount number of vendor for inbound delivery WMSnvarchar100 Allow NULL? 
47NUKLBNumber range for assignment of whse material documentsnvarchar20 Allow NULL? 
48CHSBLConsider batch-neutral bulk areas despite batch searchchar10 Allow NULL? 
49VKORGSales Organizationnvarchar40 Allow NULL? 
50VSTELShipping Point/Receiving Pointnvarchar40 Allow NULL? 
51VTWEGDistribution Channelnvarchar20 Allow NULL? 
52SPARTDivisionnvarchar20 Allow NULL? 
53FGVNQSeparate confirmation of pick and transferchar10 Allow NULL? 
54YRELARatio Workload to Usersdecimal153
55RRELARatio Workload to Usersdecimal153
56BWUMPMovement type for repacking onto HUsnvarchar30 Allow NULL? 
57PIPASPick and pack allowed during TO confirmationchar10 Allow NULL? 
58NUKIQNumber range for inventory numbers in quant inventorynvarchar20 Allow NULL? 
59EATYPStorage type to which packed or unpacked qty is postednvarchar30 Allow NULL? 
60EAPLAStorage bin to which packed or unpacked qty is postednvarchar100 Allow NULL? 
61LATERDelayed Update of Outbound Deliverychar10 Allow NULL? 
62T340D_DBTCHDistribution Mode for the Deliverychar10 Allow NULL? 
63SNDECIndicator: Allow Serial Numbers in Decentralized WMSchar10 Allow NULL? 
64CMACTCommunication with the Warehouse Systemchar10 Allow NULL? 
65CMOFF_FOREGROUNDEmergency Control of Change Management in Foregroundchar10 Allow NULL? 
66CMOFF_BACKGROUNDEmergency Control of Change Management in Backgroundchar10 Allow NULL? 
67SPE_UNCHDistribute Unchecked Deliveries to Warehousechar10 Allow NULL? 
68SPE_DISPATCHINGMessage Dispatchingchar10 Allow NULL? 
69BATCH_DETERM_EWMBatch Determination in EWM via Batch Attribute Replicationchar10 Allow NULL? 
70NO_PP_GRIndicator: Goods Receipt from EWM Onlychar10 Allow NULL? 
71LOCATSitenvarchar40 Allow NULL? 
72LGNUMWMEWarehouse Number of the Decentralized SCM Systemnvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
T340D~0YesYesCLUSTEREDLGNUM, 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