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

101 columns | Print definition?ERP 6.0  | VOLEH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item56VOLEHnvarchar30
2/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item107VOLEHnvarchar30
3/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule92VOLEHnvarchar30
4/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.66VOLEHnvarchar30
5/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data36VOLEHnvarchar30
6/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item88VOLEHnvarchar30
7/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item94VOLEHnvarchar30
8/SMERP/STG_MM001Data staging - Material master plant view complex table34VOLEHVolume unitnvarchar30
9/SMERP/STG_MM002Data staging - Material storage location view complex table34VOLEHVolume unitnvarchar30
10/SMERP/STG_MM003Data staging - Material UoM view complex table35VOLEHVolume unitnvarchar30
11/SMERP/STG_MM004Data staging - Material warehouse view complex table34VOLEHVolume unitnvarchar30
12/SMERP/STG_MM005Data staging - Material batch view complex table34VOLEHVolume unitnvarchar30
13WB2_D_BVDETAILCCS: Detailed Statement for Settlement18VOLEHVolume unitnvarchar30
14ZEIMMARAUSING FOR STORING EIM MARA DATAS34VOLEHVolume unitnvarchar30
15ZEIM_LIPSSD document: Delivery: Item data26VOLEHVolume unitnvarchar30
16ZEIM_VBAPSales Document: Item Data60VOLEHVolume unitnvarchar30
TOPAccounting Interface
17GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)267VOLEHVolume unitnvarchar30
18GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)267VOLEHVolume unitnvarchar30
TOPAdvertising Management
19JHTAKIS-M/AM: Settlement Run Sales Document Header20VOLEHVolume unitnvarchar30
TOPAgency Business Global Trade
20WBRPAgency business: Item24VOLEHVolume unitnvarchar30
TOPAllocation
21AUVDIWorklist for Deliveries (Follow-on Doc. Generation)30VOLEHVolume unitnvarchar30
TOPBasic functions
22HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting20VOLEHVolume unitnvarchar30
TOPBasic Functions
23VBFASales Document Flow27VOLEHVolume unitnvarchar30
24VBSKCollective Processing for a Sales Document Header12VOLEHVolume unitnvarchar30
TOPBasic functions
25VEKPHandling Unit - Header Table16VOLEHVolume unitnvarchar30
TOPBasic Functions
26VETVGDelivery Due Index for Stock Transfer20VOLEHVolume unitnvarchar30
TOPBilling
27VBRPBilling Document: Item Data17VOLEHVolume unitnvarchar30
TOPConsumption-Based Planning See Also PP-MRP
28TWBO1Customizing table for opt. PO-based load building profiles8VOLEHVolume unitnvarchar30
29TWBO3Text table for restrictions4VOLEHVolume unitnvarchar30
TOPCross-Application Components
30MMARAGeneral material data34VOLEHVolume unitnvarchar30
31VVBAPSales Document: Item Data60VOLEHVolume unitnvarchar30
32VVBFASales Document Flow27VOLEHVolume unitnvarchar30
TOPData Collection
33S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country15VOLEHVolume unit for statistics (CDM)nvarchar30
34S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country15VOLEHVolume unit for statistics (CDM)nvarchar30
35S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country15VOLEHVolume unit for statistics (CDM)nvarchar30
36S005ES005 - Structural Information8VOLEHVolume unitnvarchar30
37S015Subsequent Settlement: Evaluation22VOLEHVolume unitnvarchar30
38S015ES015 - Structural Information15VOLEHVolume unitnvarchar30
39S074Subsequent Settlement: Operative18VOLEHVolume unitnvarchar30
40S074ES074 - Structural Information11VOLEHVolume unitnvarchar30
41S150W&S: Rough Workload Estimate18VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
42S150ES150 - Structural Information11VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
43S152W&S: Rough Workload Estimate - Goods Issue20VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
44S152ES152 - Structural Information13VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
45S159W&S: Picking Waves17VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
46S159ES159 - Structural Information10VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
47S172Vendor billing document data17VOLEHVolume unitnvarchar30
48S172ES172 - Structural Information10VOLEHVolume unitnvarchar30
49S173Vendor billing document item22VOLEHVolume unitnvarchar30
50S173ES173 - Structural Information15VOLEHVolume unitnvarchar30
51S260SD - Sales order77VOLEHVolume unitnvarchar30
52S260BIW1SD - Sales order77VOLEHVolume unitnvarchar30
53S260BIW2SD - Sales order77VOLEHVolume unitnvarchar30
54S261SD - Delivery note40VOLEHVolume unitnvarchar30
55S261BIW1SD - Delivery note40VOLEHVolume unitnvarchar30
56S261BIW2SD - Delivery note40VOLEHVolume unitnvarchar30
57S262SD - Billing document32VOLEHVolume unitnvarchar30
58S262BIW1SD - Billing document32VOLEHVolume unitnvarchar30
59S262BIW2SD - Billing document32VOLEHVolume unitnvarchar30
60S263SD - Sales order/delivery note61VOLEHVolume unitnvarchar30
61S263BIW1SD - Sales order/delivery note61VOLEHVolume unitnvarchar30
62S263BIW2SD - Sales order/delivery note61VOLEHVolume unitnvarchar30
63S264SD- Offer79VOLEHVolume unitnvarchar30
64S264BIW1S264BIW1 * SD - Quotation79VOLEHVolume unitnvarchar30
65S264BIW2S264BIW2 * SD - Quotation79VOLEHVolume unitnvarchar30
TOPFreight Processing
66TVFBWAMinimum Weights for Shipping Units8VOLEHVolume unitnvarchar30
TOPInventory Management
67MWXVM07MFields: Update Control of Module Pool SAPMM07M131VOLEHVolume unitnvarchar30
68MWZVM07MFields: Update Control of Module Pool SAPMM07M131VOLEHVolume unitnvarchar30
TOPLogistics - General
69WBHITrading Contract: Item Data46VOLEHVolume unitnvarchar30
TOPMaterial Master
70MARAGeneral Material Data34VOLEHVolume unitnvarchar30
71MARA_TMPFile for Incorrect Data in Direct Input41VOLEHVolume unitnvarchar30
72MARMUnits of Measure for Material14VOLEHVolume unitnvarchar30
73MARM_TMPFile for Incorrect Data in Direct Input17VOLEHVolume unitnvarchar30
74MVRACross-version fields for MARA34VOLEHVolume unitnvarchar30
75MVRMUnits of Measure for Material14VOLEHVolume unitnvarchar30
TOPPeriodical Sales and Distribution
76JLSKIS-M/SD: Header for Settlement in Collective Processing13VOLEHVolume unitnvarchar30
TOPProfitability Analysis
77CEERRORCO-PA: Incorrect records from SD38VOLEHVolume unitnvarchar30
TOPPurchase Orders
78WBO2Log item file for simulative list for load building29VOLEHVolume unitnvarchar30
TOPPurchasing
79EKPOPurchasing Document Item107VOLEHVolume unitnvarchar30
TOPR2-R3 Link
80LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master25VOLEHVolume unitnvarchar30
TOPRecycling Administration Core Functions
81J_7LC40REA Info System: Recycling Partner-Spec. LIS Update9VOLEHVolume unitnvarchar30
82J_7LE01REA Partner Master Record: General Data (Country-Dependent)17VOLEHVolume unitnvarchar30
83J_7LM03REA Article Master: Sales Units14VOLEHVolume unitnvarchar30
84J_7LV01REA Packaging Master Data: General Data17VOLEHVolume unitnvarchar30
TOPRemaining Beverage - Obsolete Objects
85/BEV1/RBVBAPSales Document: Item Data60VOLEHVolume unitnvarchar30
86/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents12VOLEHVolume unitnvarchar30
TOPRemote Logistics Management
87OIO_MX_OBJECTRLM tracking extract object data51VOLEHVolume unitnvarchar30
TOPRepetitive Manufacturing
88COMPMOVEGoods Movement of Components207VOLEHVolume unitnvarchar30
TOPSales
89VBAPSales Document: Item Data60VOLEHVolume unitnvarchar30
90VEPVGDelivery Due Index21VOLEHVolume unitnvarchar30
TOPShipping
91DVK02R/2-R/3 Link: Delivery Item Data R2 -> R321VOLEHVolume unitnvarchar30
92DVM01R/2-R/3 Link: R/3 Input Data for Material Master55VOLEHVolume unitnvarchar30
93LIKPSD Document: Delivery Header Data39VOLEHVolume unitnvarchar30
94LIPSSD document: Delivery: Item data26VOLEHVolume unitnvarchar30
95TMCL_LVW&S: Control - RWE + Picking Wave Creation3VOLEHVolume unit: Rough Workload Estimate and picking wavesnvarchar30
TOPSimulation
96VSVBAP_CNVersion: Sales document: Item data61VOLEHVolume unitnvarchar30
TOPSubsequent Settlement
97S015BIW1S015BIW1 * Supplementary settlement - Evaluation22VOLEHVolume unitnvarchar30
98S015BIW2S015BIW2 * Supplementary settlement - Evaluation22VOLEHVolume unitnvarchar30
TOPTransportation
99VTRDIShipment Planning Index20VOLEHVolume unitnvarchar30
TOPWarehouse Management
100LTAPTransfer order item122VOLEHVolume unitnvarchar30
101T340DWM Default Values42VOLEHVolume unitnvarchar30