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
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

77 columns | Print definition?ERP 6.0  | VOLUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item108VOLUMdecimal150
2/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data37VOLUMdecimal150
3/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item89VOLUMdecimal150
4/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item95VOLUMdecimal150
5/SMERP/STG_MM001Data staging - Material master plant view complex table33VOLUMVolumedecimal133
6/SMERP/STG_MM002Data staging - Material storage location view complex table33VOLUMVolumedecimal133
7/SMERP/STG_MM003Data staging - Material UoM view complex table34VOLUMVolumedecimal133
8/SMERP/STG_MM004Data staging - Material warehouse view complex table33VOLUMVolumedecimal133
9/SMERP/STG_MM005Data staging - Material batch view complex table33VOLUMVolumedecimal133
10SGT_MARMSegmentation | Weights and Volumes6VOLUMVolumedecimal133
11WB2_D_BVDETAILCCS: Detailed Statement for Settlement17VOLUMVolumedecimal133
12ZEIMMARAUSING FOR STORING EIM MARA DATAS33VOLUMVolumedecimal133
13ZEIM_LIPSSD document: Delivery: Item data25VOLUMVolumedecimal153
14ZEIM_VBAPSales Document: Item Data59VOLUMVolume of the itemdecimal153
TOPAccounting Interface
15GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)266VOLUMVolumedecimal153
16GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)266VOLUMVolumedecimal153
TOPAdvertising Management
17JHTAKIS-M/AM: Settlement Run Sales Document Header19VOLUMVolume of all processed documentsdecimal133
TOPAgency Business Global Trade
18WBRPAgency business: Item23VOLUMVolumedecimal153
TOPAllocation
19AUVDIWorklist for Deliveries (Follow-on Doc. Generation)29VOLUMOpen volume of all schedule lines for this keydecimal153
TOPBasic Functions
20VBFASales Document Flow26VOLUMVolumedecimal153
21VBSKCollective Processing for a Sales Document Header11VOLUMVolume of all processed documentsdecimal133
22VETVGDelivery Due Index for Stock Transfer19VOLUMOpen volume of all schedule lines for this keydecimal153
TOPBilling
23VBRPBilling Document: Item Data16VOLUMVolumedecimal153
TOPCross-Application Components
24MMARAGeneral material data33VOLUMVolumedecimal133
25VVBAPSales Document: Item Data59VOLUMVolume of the itemdecimal153
26VVBFASales Document Flow26VOLUMVolumedecimal153
TOPData Collection
27CF701IDES Marketing18VOLUMSales Volumedecimal153
28S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country18VOLUMVolume of deliveriesdecimal153
29S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country18VOLUMVolume of deliveriesdecimal153
30S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country18VOLUMVolume of deliveriesdecimal153
31S015Subsequent Settlement: Evaluation31VOLUMVendor business volume: physical volume (subseq. settlement)decimal153
32S074Subsequent Settlement: Operative29VOLUMVendor business volume: physical volume (subseq. settlement)decimal153
33S260SD - Sales order107VOLUMVolume of the itemdecimal153
34S260BIW1SD - Sales order107VOLUMVolume of the itemdecimal153
35S260BIW2SD - Sales order107VOLUMVolume of the itemdecimal153
36S261SD - Delivery note88VOLUMVolumedecimal153
37S261BIW1SD - Delivery note88VOLUMVolumedecimal153
38S261BIW2SD - Delivery note88VOLUMVolumedecimal153
39S262SD - Billing document84VOLUMVolumedecimal153
40S262BIW1SD - Billing document84VOLUMVolumedecimal153
41S262BIW2SD - Billing document84VOLUMVolumedecimal153
42S264SD- Offer110VOLUMVolume of the itemdecimal153
43S264BIW1S264BIW1 * SD - Quotation110VOLUMVolume of the itemdecimal153
44S264BIW2S264BIW2 * SD - Quotation110VOLUMVolume of the itemdecimal153
TOPFreight Processing
45TVFBWAMinimum Weights for Shipping Units7VOLUMVolumedecimal153
TOPInventory Management
46MWXVM07MFields: Update Control of Module Pool SAPMM07M138VOLUMVolumedecimal153
47MWZVM07MFields: Update Control of Module Pool SAPMM07M138VOLUMVolumedecimal153
TOPLogistics - General
48WBHITrading Contract: Item Data45VOLUMVolume of the itemdecimal153
TOPMaterial Master
49MARAGeneral Material Data33VOLUMVolumedecimal133
50MARA_TMPFile for Incorrect Data in Direct Input40VOLUMVolumedecimal133
51MARMUnits of Measure for Material13VOLUMVolumedecimal133
52MARM_TMPFile for Incorrect Data in Direct Input16VOLUMVolumedecimal133
53MVRACross-version fields for MARA33VOLUMVolumedecimal133
54MVRMUnits of Measure for Material13VOLUMVolumedecimal133
TOPPeriodical Sales and Distribution
55JLSKIS-M/SD: Header for Settlement in Collective Processing12VOLUMVolume of all processed documentsdecimal133
TOPPricing
56PRCD_SIM_ITEMPricing Document Item (Simulation)20VOLUMVolumedecimal185
TOPProfitability Analysis
57CEERRORCO-PA: Incorrect records from SD37VOLUMVolumedecimal153
TOPPurchasing
58EKPOPurchasing Document Item106VOLUMVolumedecimal133
TOPR2-R3 Link
59LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master24VOLUMVolume (NUM format)nvarchar140
TOPRecycling Administration Core Functions
60J_7LM03REA Article Master: Sales Units13VOLUMVolumedecimal133
61J_7LV01REA Packaging Master Data: General Data18VOLUMVolumedecimal133
TOPRemaining Beverage - Obsolete Objects
62/BEV1/RBVBAPSales Document: Item Data59VOLUMVolume of the itemdecimal153
63/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents11VOLUMVolume of all processed documentsdecimal133
TOPRemote Logistics Management
64OIO_MX_OBJECTRLM tracking extract object data50VOLUMVolumedecimal153
TOPRepetitive Manufacturing
65COMPMOVEGoods Movement of Components206VOLUMVolumedecimal153
TOPSales
66VBAPSales Document: Item Data59VOLUMVolume of the itemdecimal153
67VEPVGDelivery Due Index20VOLUMOpen volume of all schedule lines for this keydecimal153
TOPShipping
68DVK02R/2-R/3 Link: Delivery Item Data R2 -> R320VOLUMVolume (special storage for decentralized shipping)nvarchar160
69DVM01R/2-R/3 Link: R/3 Input Data for Material Master54VOLUMVolume (special storage for decentralized shipping)nvarchar140
70LIKPSD Document: Delivery Header Data38VOLUMVolumedecimal153
71LIPSSD document: Delivery: Item data25VOLUMVolumedecimal153
TOPSimulation
72VSVBAP_CNVersion: Sales document: Item data60VOLUMVolume of the itemdecimal153
TOPSubsequent Settlement
73S015BIW1S015BIW1 * Supplementary settlement - Evaluation31VOLUMVendor business volume: physical volume (subseq. settlement)decimal153
74S015BIW2S015BIW2 * Supplementary settlement - Evaluation31VOLUMVendor business volume: physical volume (subseq. settlement)decimal153
TOPTransportation
75VTRDIShipment Planning Index18VOLUMVolumedecimal153
TOPWarehouse Management
76LTAPTransfer order item121VOLUMVolumedecimal133
TOPWaste Management
77EEWA_BULK_DATABulk refuse order data14VOLUMVolumedecimal133