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

142 columns | Print definition?ERP 6.0  | GEWEI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item49GEWEInvarchar30
2/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule59GEWEInvarchar30
3/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.43GEWEInvarchar30
4/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data15GEWEInvarchar30
5/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item44GEWEInvarchar30
6/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item41GEWEInvarchar30
7/SMERP/STG_MM001Data staging - Material master plant view complex table32GEWEIWeight Unitnvarchar30
8/SMERP/STG_MM002Data staging - Material storage location view complex table32GEWEIWeight Unitnvarchar30
9/SMERP/STG_MM003Data staging - Material UoM view complex table33GEWEIWeight Unitnvarchar30
10/SMERP/STG_MM004Data staging - Material warehouse view complex table32GEWEIWeight Unitnvarchar30
11/SMERP/STG_MM005Data staging - Material batch view complex table32GEWEIWeight Unitnvarchar30
12/SMERP/STG_PM001Data staging - Equipment complex table21GEWEIUnit of weightnvarchar30
13/SMERP/STG_PM002Data staging - Functional Location complex table49GEWEIWeight Unitnvarchar30
14/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab21GEWEIUnit of weightnvarchar30
15/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab49GEWEIWeight Unitnvarchar30
16BBPT_T023Material groups9GEWEIDefault unit of weight in the material masternvarchar30
17J_1I_PM_COODETEXIM: COO line items12GEWEIWeight Unitnvarchar30
18J_1I_PM_PACKLISTEXIM: Packing List Items14GEWEIWeight Unitnvarchar30
19J_3RFGTD_ITEMImport Customs Declaration Items12GEWEIWeight Unitnvarchar30
20S955ES955 - Strukturinformationen18GEWEIGewichtseinheitnvarchar30
21WB2_D_BVDETAILCCS: Detailed Statement for Settlement16GEWEIWeight Unitnvarchar30
22ZEIMMARAUSING FOR STORING EIM MARA DATAS32GEWEIWeight Unitnvarchar30
23ZEIM_LIPSSD document: Delivery: Item data24GEWEIWeight Unitnvarchar30
24ZEIM_VBAPSales Document: Item Data58GEWEIWeight Unitnvarchar30
TOPAccounting Interface
25GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)265GEWEIWeight Unitnvarchar30
26GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)265GEWEIWeight Unitnvarchar30
TOPAdvertising Management
27JHTAKIS-M/AM: Settlement Run Sales Document Header18GEWEIWeight Unitnvarchar30
28JHTFPIS-M/AM: Billing/Settlement Documents - Item54GEWEIWeight Unitnvarchar30
TOPAgency Business Global Trade
29WBRPAgency business: Item22GEWEIWeight Unitnvarchar30
TOPAllocation
30AUVDIWorklist for Deliveries (Follow-on Doc. Generation)28GEWEIWeight Unitnvarchar30
TOPBasic functions
31HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting13GEWEIWeight Unitnvarchar30
TOPBasic Functions
32VBFASales Document Flow25GEWEIWeight Unitnvarchar30
33VBSKCollective Processing for a Sales Document Header10GEWEIWeight Unitnvarchar30
TOPBasic functions
34VEKPHandling Unit - Header Table11GEWEIWeight Unitnvarchar30
TOPBasic Functions
35VETVGDelivery Due Index for Stock Transfer18GEWEIWeight Unitnvarchar30
TOPBilling
36VBRPBilling Document: Item Data15GEWEIWeight Unitnvarchar30
TOPConstruction Equipment Management
37J_3GBELKDocument File - Header Data146GEWEIWeight Unitnvarchar30
TOPConsumption-Based Planning See Also PP-MRP
38TWBO1Customizing table for opt. PO-based load building profiles10GEWEIWeight Unitnvarchar30
39TWBO3Text table for restrictions5GEWEIWeight Unitnvarchar30
TOPCross-Application Components
40MMARAGeneral material data32GEWEIWeight Unitnvarchar30
41VVBAPSales Document: Item Data58GEWEIWeight Unitnvarchar30
42VVBFASales Document Flow25GEWEIWeight Unitnvarchar30
TOPData Collection
43S005SIS: Shipping Point/Route/Forwarding Agent/Receiving Country14GEWEIUnit of weight for statistics (kg)nvarchar30
44S005BIW1S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country14GEWEIUnit of weight for statistics (kg)nvarchar30
45S005BIW2S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country14GEWEIUnit of weight for statistics (kg)nvarchar30
46S005ES005 - Structural Information7GEWEIWeight Unitnvarchar30
47S015Subsequent Settlement: Evaluation21GEWEIWeight Unitnvarchar30
48S015ES015 - Structural Information14GEWEIWeight Unitnvarchar30
49S074Subsequent Settlement: Operative17GEWEIWeight Unitnvarchar30
50S074ES074 - Structural Information10GEWEIWeight Unitnvarchar30
51S090WM: Stock placements/removals20GEWEIWeight Unitnvarchar30
52S090ES090 - Structural Information13GEWEIWeight Unitnvarchar30
53S091WM: Quantity flows18GEWEIWeight Unitnvarchar30
54S091BIW1S091BIW1 * WM: Quantity flows18GEWEIWeight Unitnvarchar30
55S091BIW2S091BIW2 * WM: Quantity Flows18GEWEIWeight Unitnvarchar30
56S091ES091 - Structural Information11GEWEIWeight Unitnvarchar30
57S172Vendor billing document data16GEWEIWeight Unitnvarchar30
58S172ES172 - Structural Information9GEWEIWeight Unitnvarchar30
59S173Vendor billing document item21GEWEIWeight Unitnvarchar30
60S173ES173 - Structural Information14GEWEIWeight Unitnvarchar30
61S260SD - Sales order76GEWEIWeight Unitnvarchar30
62S260BIW1SD - Sales order76GEWEIWeight Unitnvarchar30
63S260BIW2SD - Sales order76GEWEIWeight Unitnvarchar30
64S261SD - Delivery note39GEWEIWeight Unitnvarchar30
65S261BIW1SD - Delivery note39GEWEIWeight Unitnvarchar30
66S261BIW2SD - Delivery note39GEWEIWeight Unitnvarchar30
67S262SD - Billing document33GEWEIWeight Unitnvarchar30
68S262BIW1SD - Billing document33GEWEIWeight Unitnvarchar30
69S262BIW2SD - Billing document33GEWEIWeight Unitnvarchar30
70S263SD - Sales order/delivery note60GEWEIWeight Unitnvarchar30
71S263BIW1SD - Sales order/delivery note60GEWEIWeight Unitnvarchar30
72S263BIW2SD - Sales order/delivery note60GEWEIWeight Unitnvarchar30
73S264SD- Offer78GEWEIWeight Unitnvarchar30
74S264BIW1S264BIW1 * SD - Quotation78GEWEIWeight Unitnvarchar30
75S264BIW2S264BIW2 * SD - Quotation78GEWEIWeight Unitnvarchar30
76S955Istdatenspeicher MAP - BW25GEWEIGewichtseinheitnvarchar30
TOPEquipment
77EQUIEquipment master data15GEWEIUnit of weightnvarchar30
TOPFreight Processing
78TVFBWAMinimum Weights for Shipping Units6GEWEIWeight Unitnvarchar30
TOPFunctional Locations
79IFLOTFunctional Location (Table)43GEWEIWeight Unitnvarchar30
80IFLOT_VSFunctional Location (Version Table)44GEWEIWeight Unitnvarchar30
TOPInterfaces
81VXSIGExpress Delivery Company: Weight Codes6GEWEIWeight Unitnvarchar30
TOPInventory Management
82MWXVM07MFields: Update Control of Module Pool SAPMM07M137GEWEIWeight Unitnvarchar30
83MWZVM07MFields: Update Control of Module Pool SAPMM07M137GEWEIWeight Unitnvarchar30
TOPLocalization
84J_1BAANota Fiscal type14GEWEIWeight Unitnvarchar30
85J_1BNFDOCNota Fiscal Header48GEWEIWeight Unitnvarchar30
86J_1IEXCDTLExcise invoice line item details79GEWEIWeight Unitnvarchar30
87J_3RSCCDITEMCargo Customs Declaration Item14GEWEIWeight Unitnvarchar30
TOPLogistics - General
88WBHITrading Contract: Item Data44GEWEIWeight Unitnvarchar30
TOPLogistics - General LO Enhancements
89/SAPMP/VERPARTWeight Allowances for Packing Types8GEWEIWeight Unitnvarchar30
90/SAPMP/VERSARTWeight Allowances for Lagging Types8GEWEIWeight Unitnvarchar30
TOPMaterial Groups
91T023Material Groups9GEWEIDefault unit of weight in the material masternvarchar30
TOPMaterial Master
92MARAGeneral Material Data32GEWEIWeight Unitnvarchar30
93MARA_TMPFile for Incorrect Data in Direct Input39GEWEIWeight Unitnvarchar30
94MARMUnits of Measure for Material16GEWEIWeight Unitnvarchar30
95MARM_TMPFile for Incorrect Data in Direct Input19GEWEIWeight Unitnvarchar30
96MVRACross-version fields for MARA32GEWEIWeight Unitnvarchar30
97MVRMUnits of Measure for Material16GEWEIWeight Unitnvarchar30
TOPPeriodical Sales and Distribution
98JLSKIS-M/SD: Header for Settlement in Collective Processing11GEWEIWeight Unitnvarchar30
TOPProfitability Analysis
99CEERRORCO-PA: Incorrect records from SD36GEWEIWeight Unitnvarchar30
TOPPurchase Orders
100WBO2Log item file for simulative list for load building30GEWEIWeight Unitnvarchar30
TOPPurchasing
101EKPOPurchasing Document Item85GEWEIUnit of Weightnvarchar30
TOPR2-R3 Link
102LDK01Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP31GEWEIWeight Unitnvarchar30
103LDK02Communicat.Record 02 Decentralized WMS: Transfer R/2 -> ERP37GEWEIWeight Unitnvarchar30
104LDK03Communication Rec. 03 Decentralized WMS: Del.Doc. R/2 -> ERP24GEWEIWeight Unitnvarchar30
105LDK05Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master23GEWEIWeight Unitnvarchar30
TOPRecycling Administration Core Functions
106J_7LC40REA Info System: Recycling Partner-Spec. LIS Update7GEWEIWeight Unitnvarchar30
107J_7LE01REA Partner Master Record: General Data (Country-Dependent)13GEWEIWeight Unitnvarchar30
108J_7LE04REA Partner Master Record: Volume/Area Classes10GEWEIWeight Unitnvarchar30
109J_7LE05REA Partner Master Record: Packaging Types12GEWEIWeight Unitnvarchar30
110J_7LM03REA Article Master: Sales Units12GEWEIWeight Unitnvarchar30
111J_7LS01REA Fractions: Internal Fractions5GEWEIWeight Unitnvarchar30
112J_7LS02REA Fractions: Partner Fractions7GEWEIWeight Unitnvarchar30
113J_7LV01REA Packaging Master Data: General Data15GEWEIWeight Unitnvarchar30
114J_7LV02REA Packaging Master Data: Fraction Assignment (Weight)9GEWEIWeight Unitnvarchar30
115J_7LV1PREA Document: Item Data26GEWEIWeight Unitnvarchar30
116J_7LV2PREA Assortment Declaration Declar. Objects: Line Items22GEWEIWeight Unitnvarchar30
TOPRemaining Beverage - Obsolete Objects
117/BEV1/CLCONT1Container Information19GEWEIUnit of Measure from Ordernvarchar30
118/BEV1/RBVBAPSales Document: Item Data58GEWEIWeight Unitnvarchar30
119/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents10GEWEIWeight Unitnvarchar30
TOPRemote Logistics Management
120OIO_MX_OBJECTRLM tracking extract object data49GEWEIWeight Unitnvarchar30
121OIO_RT_RTDOC_CTReturns document - container items14GEWEIWeight Unitnvarchar30
TOPRepetitive Manufacturing
122COMPMOVEGoods Movement of Components225GEWEIWeight Unitnvarchar30
TOPSales
123VBAPSales Document: Item Data58GEWEIWeight Unitnvarchar30
124VEPVGDelivery Due Index19GEWEIWeight Unitnvarchar30
TOPShipping
125DVK02R/2-R/3 Link: Delivery Item Data R2 -> R319GEWEIWeight Unitnvarchar30
126DVM01R/2-R/3 Link: R/3 Input Data for Material Master53GEWEIWeight Unitnvarchar30
127LIKPSD Document: Delivery Header Data37GEWEIWeight Unitnvarchar30
128LIPSSD document: Delivery: Item data24GEWEIWeight Unitnvarchar30
TOPSimulation
129VSVBAP_CNVersion: Sales document: Item data59GEWEIWeight Unitnvarchar30
TOPSubsequent Settlement
130S015BIW1S015BIW1 * Supplementary settlement - Evaluation21GEWEIWeight Unitnvarchar30
131S015BIW2S015BIW2 * Supplementary settlement - Evaluation21GEWEIWeight Unitnvarchar30
TOPTraders and Schedulers Workbench
132OIJHUOMOIL-TSW: Ticket additional units of measure11GEWEIWeight unitnvarchar30
133OIJ_EL_TCKET_UOMUniversal ticket additional units of measure11GEWEIWeight unitnvarchar30
TOPTransportation
134VTRDIShipment Planning Index19GEWEIWeight Unitnvarchar30
TOPWarehouse Management
135LAGPStorage bins20GEWEIWeight Unitnvarchar30
136LEINStorage unit header records17GEWEIWeight Unitnvarchar30
137LQUAQuants39GEWEIWeight Unitnvarchar30
138LTAPTransfer order item31GEWEIWeight Unitnvarchar30
139LTBKTransfer requirement header27GEWEIWeight Unitnvarchar30
140LTBPTransfer requirement item31GEWEIWeight Unitnvarchar30
141T340DWM Default Values11GEWEIWeight Unitnvarchar30
142T343Storage Bin Structure for Automatic Creation of Storage Bins13GEWEIWeight Unitnvarchar30