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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

70 columns | Print definition?ERP 6.0  | REWRT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment186REWRTInvoice Value Entered (in Local Currency)decimal132
2BSSEGAccounting Document Segment175REWRTInvoice Value Entered (in Local Currency)decimal132
3FUDT_VDOCBSEGVerification Document Item with Additional Info175REWRTInvoice Value Entered (in Local Currency)decimal132
4FUDT_VDOCBSEGEVVerification Document Item in the Entry View175REWRTInvoice Value Entered (in Local Currency)decimal132
5FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)175REWRTInvoice Value Entered (in Local Currency)decimal132
6S870BIW1S870BIW1 * Reference Structure for Generating Info Structure22REWRTInvoice Amountdecimal152
7S870BIW2S870BIW2 * Reference Structure for Generating Info Structure22REWRTInvoice Amountdecimal152
TOPBalance Sheet Valuation Procedures
8MYMP1RStorage for Invoice Differences (LIFO/FIFO)11REWRTInvoice Value for LIFO/FIFO Valuationdecimal132
TOPData Collection
9S011PURCHIS: Purchasing Group Statistics15REWRTInvoice Amountdecimal152
10S011BIW1S011BIW1 * PURCHIS: Purchasing Group Statistics15REWRTInvoice Amountdecimal152
11S011BIW2S011BIW2 * PURCHIS: Purchasing Group Statistics15REWRTInvoice Amountdecimal152
12S012Purchasing26REWRTInvoice Amountdecimal152
13S012BIW1S012BIW1 * Purchasing26REWRTInvoice Amountdecimal152
14S012BIW2S012BIW2 * Purchasing26REWRTInvoice Amountdecimal152
15S807LO555 Solution One20REWRTInvoice Amountdecimal152
16S808LO555 Solution Two20REWRTInvoice Amountdecimal152
17S850BW220: Connecting LIS-IS to BW22REWRTInvoice Amountdecimal152
18S851Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
19S852Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
20S853Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
21S854Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
22S855Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
23S856Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
24S857Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
25S858Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
26S859Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
27S860Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
28S861Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
29S862Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
30S863Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
31S864Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
32S865Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
33S866Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
34S867Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
35S868Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
36S869Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
37S870Reference Structure for Generating Info Structures22REWRTInvoice Amountdecimal152
38S880LO930 examples23REWRTInvoice Amountdecimal152
39S913LIS: Purchasing (cons. Planng)21REWRTInvoice Amountdecimal152
40S930BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
41S931BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
42S932BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
43S933BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
44S934BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
45S935BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
46S936BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
47S937BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
48S938BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
49S939BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
50S940BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
51S941BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
52S942BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
53S943BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
54S944BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
55S945BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
56S946BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
57S947BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
58S948BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
59S949BW220: Connect LIS-IS to BW(2)22REWRTInvoice Amountdecimal152
TOPFinancial Accounting
60VBSEGKDocument Segment for Vendor Document Parking91REWRTInvoice Value Entered (in Local Currency)decimal132
61VBSEGSDocument Segment for Document Parking - G/L Account Database55REWRTInvoice Value Entered (in Local Currency)decimal132
TOPFunds Management-Specific Postings
62FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years54REWRTInvoice Value Entered (in Local Currency)decimal132
63PSOSEGKRecurring Request Document Segment, Vendors92REWRTInvoice Value Entered (in Local Currency)decimal132
64PSOSEGSRecurring Request Document Segment, G/L Accounts53REWRTInvoice Value Entered (in Local Currency)decimal132
TOPInventory Management
65MWZDM07M1ZDM07M182REWRTInvoice value in local currencydecimal132
TOPInvoice Verification
66RBEXPersistent Key Figures Header and Item16REWRTInvoice value in local currencydecimal132
TOPPurchasing Information System
67MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)26REWRTInvoice value in local currencydecimal132
TOPRemaining Beverage - Obsolete Objects
68/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1177REWRTInvoice Value Entered (in Local Currency)decimal132
69S468IS Beverage EM, Purchasing Information System Empties36REWRTInvoice Amountdecimal152
TOPTraders and Schedulers Workbench
70S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object23REWRTInvoice Amountdecimal152