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

52 columns | Print definition?ERP 6.0  | BSTME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item10BSTMEPurchase Order Unit of Measurenvarchar30
2/OPT/VIM_TITEMDocument Item10BSTMEPurchase Order Unit of Measurenvarchar30
3/SMERP/STG_MM001Data staging - Material master plant view complex table15BSTMEPurchase Order Unit of Measurenvarchar30
4/SMERP/STG_MM002Data staging - Material storage location view complex table15BSTMEPurchase Order Unit of Measurenvarchar30
5/SMERP/STG_MM003Data staging - Material UoM view complex table16BSTMEPurchase Order Unit of Measurenvarchar30
6/SMERP/STG_MM004Data staging - Material warehouse view complex table15BSTMEPurchase Order Unit of Measurenvarchar30
7/SMERP/STG_MM005Data staging - Material batch view complex table15BSTMEPurchase Order Unit of Measurenvarchar30
8FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice17BSTMEPurchase Order Unit of Measurenvarchar30
9MLAUFHHistory table for summarized MLAUF data27BSTMEPurchase Order Unit of Measurenvarchar30
10S955ES955 - Strukturinformationen19BSTMEBestellmengeneinheitnvarchar30
11YVIM_1ITEMDocument Item10BSTMEPurchase Order Unit of Measurenvarchar30
12ZEIMMARAUSING FOR STORING EIM MARA DATAS15BSTMEPurchase Order Unit of Measurenvarchar30
TOPActual CostingMaterial Ledger
13MLAUFMaterial Ledger Item Table for Order History26BSTMEPurchase Order Unit of Measurenvarchar30
TOPAllocation
14AUBSIWorklist for PO (Follow-on Document Generation)22BSTMEPurchase Order Unit of Measurenvarchar30
15AUFIAllocation Table, Document Sub-item, Stores45BSTMEPurchase Order Unit of Measurenvarchar30
16AULWDelivery Phases23BSTMEPurchase Order Unit of Measurenvarchar30
17AUVWDelivery Phase for Distribution Center19BSTMEPurchase Order Unit of Measurenvarchar30
18AUVZDistribution Center20BSTMEPurchase Order Unit of Measurenvarchar30
19AUWEIIndex, Adjust Alloc Tbl After Entering Doc.12BSTMEPurchase Order Unit of Measurenvarchar30
TOPConditions
20A066Info record per order unit8BSTMEPurchase Order Unit of Measurenvarchar30
21A067Plant Info Record per Order Unit9BSTMEPurchase Order Unit of Measurenvarchar30
22KOTN001Info Record: Plant-Specific per Order Unit9BSTMEPurchase Order Unit of Measurenvarchar30
23KOTN002Info record per order unit8BSTMEPurchase Order Unit of Measurenvarchar30
TOPCross-Application Components
24MMARAGeneral material data15BSTMEPurchase Order Unit of Measurenvarchar30
TOPData Collection
25S270Do not use!17BSTMEPurchase Order Unit of Measurenvarchar30
26S270BIW1Do not use!17BSTMEPurchase Order Unit of Measurenvarchar30
27S270BIW2Do not use!17BSTMEPurchase Order Unit of Measurenvarchar30
28S270ES270 - Structural Information10BSTMEPurchase Order Unit of Measurenvarchar30
29S275Transfer BW: Einkaufsdaten16BSTMEBestelhoeveelheidseenheidnvarchar30
30S275BIW1S275BIW1 * Transfer to BW: Purchasing Data16BSTMEPurchase Order Unit of Measurenvarchar30
31S275BIW2S275BIW2 * Transfer to BW: Purchasing Data16BSTMEPurchase Order Unit of Measurenvarchar30
32S955Istdatenspeicher MAP - BW26BSTMEBestellmengeneinheitnvarchar30
TOPFinancial Accounting
33/OPT/VIM_1ITEMDocument Item10BSTMEPurchase Order Unit of Measurenvarchar30
TOPInventory Management
34MSEGDocument Segment: Material122BSTMEPurchase Order Unit of Measurenvarchar30
35MWXMSEGZMSEG: Interface for Posting of Value122BSTMEPurchase Order Unit of Measurenvarchar30
36MWZMSEGZMSEG:Interface for Posting of Value122BSTMEPurchase Order Unit of Measurenvarchar30
TOPInvoice Verification
37RKWAConsignment Withdrawals17BSTMEUnit of measure for settlementnvarchar30
38RSEGDocument Item: Incoming Invoice18BSTMEPurchase Order Unit of Measurenvarchar30
TOPMaterial Master
39MARAGeneral Material Data15BSTMEPurchase Order Unit of Measurenvarchar30
40MARA_TMPFile for Incorrect Data in Direct Input22BSTMEPurchase Order Unit of Measurenvarchar30
41MVRACross-version fields for MARA15BSTMEPurchase Order Unit of Measurenvarchar30
TOPMaterials Management
42/SAPNEA/ROWAChargeable component consumptions17BSTMEUnit of measure for settlementnvarchar30
43ROWAIndex table : Chargeable component consumptions17BSTMEPurchase Order Unit of Measurenvarchar30
TOPMerchandise and Assortment Planning
44TWISPC_MARARetail Planning: Materials for Provisional Planning26BSTMEPurchase Order Unit of Measurenvarchar30
TOPPurchase Orders
45WBO2Log item file for simulative list for load building31BSTMEPurchase Order Unit of Measurenvarchar30
TOPPurchasing
46WRF_POHF_POLOrder list16BSTMEPurchase Order Unit of Measurenvarchar30
TOPR2-R3 Link
47LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master19BSTMEPurchase Order Unit of Measurenvarchar30
TOPRemaining Beverage - Obsolete Objects
48S468IS Beverage EM, Purchasing Information System Empties18BSTMEPurchase Order Unit of Measurenvarchar30
49S468ES468 - Structure Information11BSTMEPurchase Order Unit of Measurenvarchar30
TOPShipping
50DVM01R/2-R/3 Link: R/3 Input Data for Material Master27BSTMEPurchase Order Unit of Measurenvarchar30
TOPTariffs, Duties and Permits
51OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature37BSTMEPurchase Order Unit of Measurenvarchar30
TOPVendor Evaluation
52ABS_IV_KEYFI_ITMAbsolute Key Figures at Item Level17BSTMEPurchase Order Unit of Measurenvarchar30