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

36 columns | Print definition?ERP 6.0  | BUSTW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment185BUSTWPosting string for valuesnvarchar40
2BSSEGAccounting Document Segment174BUSTWPosting string for valuesnvarchar40
3FUDT_VDOCBSEGVerification Document Item with Additional Info174BUSTWPosting string for valuesnvarchar40
4FUDT_VDOCBSEGEVVerification Document Item in the Entry View174BUSTWPosting string for valuesnvarchar40
5FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)174BUSTWPosting string for valuesnvarchar40
6GLPOS_C_CTFI Document: Entry View69BUSTWPosting string for valuesnvarchar40
7GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items69BUSTWPosting string for valuesnvarchar40
8GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items69BUSTWPosting string for valuesnvarchar40
9GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items69BUSTWPosting string for valuesnvarchar40
10GLPOS_N_CTNew General Ledger: Line Item with Currency Type69BUSTWPosting string for valuesnvarchar40
11GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type69BUSTWPosting string for valuesnvarchar40
12T169APosting String for Invoice Verification1BUSTWPosting string for valuesnvarchar40
13T169WPosting Strings (Values) for SAPMM08R3BUSTWPosting string for valuesnvarchar40
14T169XTransaction Texts: Invoice Verification2BUSTWPosting string for valuesnvarchar40
TOPAccounting Interface
15GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)225BUSTWPosting string for valuesnvarchar40
16GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)225BUSTWPosting string for valuesnvarchar40
TOPActual CostingMaterial Ledger
17CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 91298428BUSTWPosting string for valuesnvarchar40
18MLITMBMaterial valuation document row information16BUSTWPosting string for valuesnvarchar40
TOPAgency Business Global Trade
19TMFKAgency Business: Billing Document Types63BUSTWAlternative Posting String for Valuesnvarchar40
TOPAlternative Valuation Run
20CKMLAVRDOCITLines for Cumulation Posting Document7BUSTWPosting string for valuesnvarchar40
TOPBalance Sheet Valuation Procedures
21MYSEG_EXTRACTDocument Segment: Material25BUSTWPosting string for valuesnvarchar40
TOPFinancial Accounting
22ACCTITCompressed Data from FI/CO Document133BUSTWPosting string for valuesnvarchar40
TOPInventory Management
23MSEGDocument Segment: Material151BUSTWPosting string for valuesnvarchar40
24MWXMSEGZMSEG: Interface for Posting of Value151BUSTWPosting string for valuesnvarchar40
25MWZMSEGZMSEG:Interface for Posting of Value151BUSTWPosting string for valuesnvarchar40
26T156SMovement Type: Quantities/Value Posting (Until Rel. 4.5B)9BUSTWPosting string for valuesnvarchar40
27T156SYMvt Type: Qty/Value Update: System Table; Rel. 4.6A8BUSTWPosting string for valuesnvarchar40
28T156WPosting string values1BUSTWPosting string for valuesnvarchar40
29T156XTrans./Event Key Modification8BUSTWPosting string for valuesnvarchar40
TOPInvoice Verification
30RSEGDocument Item: Incoming Invoice40BUSTWPosting string for valuesnvarchar40
TOPJoint Venture und Production Sharing Accounting
31T8J156WJV additions to T156W2BUSTWPosting string for valuesnvarchar40
32T8J156XJV Appendix for T156X8BUSTWPosting string for valuesnvarchar40
33T8JRIJV Recovery indicator determination method2BUSTWPosting string for valuesnvarchar40
TOPLocalization
34J_1BIM01MM-IM: Tax posting strings for inventory management2BUSTWPosting string for valuesnvarchar40
TOPRemaining Beverage - Obsolete Objects
35/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1176BUSTWPosting string for valuesnvarchar40
TOPSpare Part Sharing and Stock Providede by Customer
36DICS_T156SYBack Up - Movement Type Quantity/Value Posting: Sys8BUSTWPosting string for valuesnvarchar40