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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

98 columns | Print definition?ERP 6.0  | LGTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item58LGTYPnvarchar30
2/SMD/MD_____01AZSID-Tabelle fuer Picking storage type4LGTYPStorage Typenvarchar30
3/SMD/MD_____01BOSID-Tabelle fuer Storage Bin4LGTYPStorage Typenvarchar30
4/SMD/MD_____01BPSID-Tabelle fuer Storage Type4LGTYPStorage Typenvarchar30
5/SMD/MD_____01BRSID-Tabelle fuer Picking Area4LGTYPStorage Typenvarchar30
6SGT_MLGTSegmentation dependent Material Data for Each Storage Type4LGTYPStorage Typenvarchar30
7T064SStock Mngmt Levels for Inventory Sampling6LGTYPStorage Typenvarchar30
8T7INPEL1P2E: Request Log table5LGTYPp2e: log typenvarchar20
9T7INPEL2P2E: Policy Log table5LGTYPp2e: log typenvarchar20
10USRMMUser settings: material master20LGTYPStorage Typenvarchar30
11ZEIM_LIPSSD document: Delivery: Item data51LGTYPStorage Typenvarchar30
12ZT331Multi customer wms putaway & pick strategy3LGTYPStorage Typenvarchar30
TOPConfirmations
13AFFWGoods Movements with Errors from Confirmations31LGTYPStorage Typenvarchar30
TOPData Collection
14S090WM: Stock placements/removals9LGTYPStor.type for stock removal, placement, returnnvarchar30
15S090ES090 - Structural Information4LGTYPStor.type for stock removal, placement, returnnvarchar30
16S261SD - Delivery note59LGTYPStorage Typenvarchar30
17S261BIW1SD - Delivery note59LGTYPStorage Typenvarchar30
18S261BIW2SD - Delivery note59LGTYPStorage Typenvarchar30
TOPDynamic Cycle Counting
19LCDCCCustomization for Dynamic Cycle Count3LGTYPStorage Typenvarchar30
TOPHazardous Substance Management
20HSMC_105Check Schema/WM Objects Assignment3LGTYPStorage Typenvarchar30
TOPInventory Management
21MSEGDocument Segment: Material92LGTYPStorage Typenvarchar30
22MWXMSEGZMSEG: Interface for Posting of Value92LGTYPStorage Typenvarchar30
23MWZMSEGZMSEG:Interface for Posting of Value92LGTYPStorage Typenvarchar30
24RESBReservation/dependent requirements122LGTYPStorage Typenvarchar30
25SBSEStock Mngmt Levels for Inventory Sampling13LGTYPStorage Typenvarchar30
TOPKANBAN
26PKHDControl Cycle15LGTYPStorage Typenvarchar30
TOPMaterial Master
27MABWManagement of Differently Maintained Material Data in Retail7LGTYPStorage Typenvarchar30
28MLGTMaterial Data for Each Storage Type4LGTYPStorage Typenvarchar30
29MLGT_TMPFile for Incorrect Data in Direct Input7LGTYPStorage Typenvarchar30
30MOFFOutstanding Material Master Records12LGTYPStorage Typenvarchar30
31MSTAMaterial Master Status12LGTYPStorage Typenvarchar30
32MVGTMaterial Data for Each Storage Type4LGTYPStorage Typenvarchar30
33USRM1Material Master User Settings: Organizational Levels21LGTYPStorage Typenvarchar30
TOPMaterials Management
34/ISDFPS/DLGPLAAssignment of Dummy Bins to Combination of Plant & SLoc5LGTYPStorage Typenvarchar30
35/ISDFPS/EQUITRPAssignment: Storage Bin --> Equipment (Loading Object)3LGTYPStorage Typenvarchar30
36/ISDFPS/LAGPTTexts for Storage Bins4LGTYPStorage Typenvarchar30
37/ISDFPS/PLATLGBEWM Additional Attributes for Storage Section3LGTYPStorage Typenvarchar30
38/ISDFPS/PLATLGPLWM Additional Attributes for Storage Bin3LGTYPStorage Typenvarchar30
39/ISDFPS/PLATLGTPWM Additional Attributes for Storage Type3LGTYPStorage Typenvarchar30
40/ISDFPS/SERMATWMAssignment: Serial. Material -> Stor. Bin (Loading Object)5LGTYPStorage Typenvarchar30
41/ISDFPS/WMATLGBEWM Additional Attributes for Storage Section3LGTYPStorage Typenvarchar30
42/ISDFPS/WMATLGPLWM Additional Attributes for Storage Bin3LGTYPStorage Typenvarchar30
43/ISDFPS/WMATLGTPWM Additional Attributes for Storage Type3LGTYPStorage Typenvarchar30
44/ISDFPS/WMTPLTXTDescription of WM Storage Bin Templates3LGTYPStorage Typenvarchar30
TOPMobile Applications
45/ISDFPS/CLOADOBJLoading Object Data to Automatically Create Storage Bins3LGTYPStorage Typenvarchar30
46/ISDFPS/LOADOBJ2Storage Types per Plant for Mobile Application5LGTYPStorage Typenvarchar30
TOPMobile data entry
47T313FDefinition User Profile for Mobile Data Entry5LGTYPStorage Typenvarchar30
TOPOther Functions
48T331CControl of storage type for putaway strategy K3LGTYPStorage Typenvarchar30
TOPQuality Inspection
49QALSInspection lot record125LGTYPStorage Typenvarchar30
TOPR2-R3 Link
50T321KDefinition of Accumulated Messages to HOST (R/2)3LGTYPStorage Typenvarchar30
TOPRepetitive Manufacturing
51COMPMOVEGoods Movement of Components68LGTYPStorage Typenvarchar30
TOPShipping
52LIPSSD document: Delivery: Item data51LGTYPStorage Typenvarchar30
53TLASTLoad Table for Calculating Workload3LGTYPStorage Typenvarchar30
TOPSimulation
54VSRESB_CNVersion: Reservation/Dependent requirements123LGTYPStorage Typenvarchar30
TOPTask Resource Management
55T343XYZStorage Bin Structure for X, Y, Z assignment to Storage bins3LGTYPStorage Typenvarchar30
TOPUse AP-MD-BP Components
56BUT001BP: General data II3LGTYPLegitimation Typenvarchar40
57TB029BP legitimation types2LGTYPLegitimation Typenvarchar40
58TB029TBP legitimation types: Texts3LGTYPLegitimation Typenvarchar40
TOPWarehouse Management
59LAGPStorage bins3LGTYPStorage Typenvarchar30
60LEINStorage unit header records5LGTYPStorage Typenvarchar30
61LINKInventory document header in WM7LGTYPStorage Typenvarchar30
62LINVInventory data per quant10LGTYPStorage Typenvarchar30
63LL05Whse Activity Monitor: Critical Stocks5LGTYPStorage Typenvarchar30
64LL06Whse Activity Monitor: Critical Storage Bins4LGTYPStorage Typenvarchar30
65LQUAQuants10LGTYPStorage Typenvarchar30
66LQUABTotal quant counts for certain strategies9LGTYPStorage Typenvarchar30
67LSEGDocument for Inward and Outward Movements14LGTYPStorage Typenvarchar30
68LTHUAssignment of Pick-HUs to Transfer Orders8LGTYPStorage Typenvarchar30
69LUBUPosting Change Document20LGTYPStorage Typenvarchar30
70T301WM Storage Types3LGTYPStorage Typenvarchar30
71T301TStorage Type Descriptions4LGTYPStorage Typenvarchar30
72T302WM Storage Sections3LGTYPStorage Typenvarchar30
73T302TStorage Section Names4LGTYPStorage Typenvarchar30
74T30AWM Picking Areas3LGTYPStorage Typenvarchar30
75T30ATPicking Area Descriptions4LGTYPStorage Typenvarchar30
76T310Pre-Allocated Stock10LGTYPStorage Typenvarchar30
77T320AWM: Storage Location Control3LGTYPStorage Typenvarchar30
78T331Storage Type Control3LGTYPStorage Typenvarchar30
79T331BStorage Type Control for Bulk Storage3LGTYPStorage Typenvarchar30
80T331LStorage Classes Allowed per Storage Type3LGTYPStorage Typenvarchar30
81T334BStorage Section Search3LGTYPStorage Typenvarchar30
82T334EStorage Unit Type Check3LGTYPStorage Typenvarchar30
83T335Default Values for Inventory3LGTYPStorage Typenvarchar30
84T336Difference Indicators4LGTYPDifference storage typenvarchar30
85T337ADivision of Storage Bins into Sections3LGTYPStorage Typenvarchar30
86T337BBulk Storage Sectioning3LGTYPStorage Typenvarchar30
87T337CSearch Range per Level for Stock Placement Strategy K3LGTYPStorage Typenvarchar30
88T337DAssignment Aisle to Shelf for Stock Placement Strategy K3LGTYPStorage Typenvarchar30
89T337ZBin Sectioning per Storage Bin Type/Storage Unit Type3LGTYPStorage Typenvarchar30
90T343Storage Bin Structure for Automatic Creation of Storage Bins3LGTYPStorage Typenvarchar30
91T343IDefinition of Sort Field in Storage Bin3LGTYPStorage Typenvarchar30
92T343JDefinition of Sequence Field in Storage Bin3LGTYPStorage Typenvarchar30
TOPWaste Management
93EHSWAT_ENTAMDisposal Processing (Quantity Entry/Planning)35LGTYPStorage Typenvarchar30
94EWA_EL_WDPPROCPTransaction Within Facility (Items)5LGTYPStorage Typenvarchar30
95EWA_EL_WDPPROTEPProcedure Template (Items)6LGTYPStorage Typenvarchar30
96EWA_WA_WEIGHOFFLOffline Weighing83LGTYPStorage Typenvarchar30
97EWA_WA_WEIGHPROCWeighing Transaction97LGTYPStorage Typenvarchar30
98EWA_WEIGH_FAVORFavorite Table of Suppliers24LGTYPStorage Typenvarchar30