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

61 columns | Print definition?ERP 6.0  | ROBJNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
2ZSEMBPSTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
3ZSPLITTSummentabelle6ROBJNRObjekt-Nummer für Objekte (Kontierungselemente)nvarchar180
4ZZ001TSummary Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
5ZZLINETSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
6ZZSL01TSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
7ZZSPECTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPAvailability Control
8FMAVCTAVC Summary Table (BCS)6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPBank Components
9JBSSAMOBRegulatory Reporting - Grouping Objects4ROBJNRGrouping Object No.nvarchar140
TOPBasic Functions
10FILCTFI-LC: Global totals table with 2 object tables6ROBJNRObject number for FI-SL tablesnvarchar180
11GGREFTExample for Global FI-SL Summary Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
12GLFUNCTTotals Table for Cost of Sales Accounting6ROBJNRObject number for objects (account assignment elements)nvarchar180
13GLPO1Plan Line Items for Object Table6ROBJNRObject number for FI-SL tablesnvarchar180
14GLPO2Plan Line Items for Object Table Global6ROBJNRObject number for FI-SL tablesnvarchar180
15GLPO3Plan Line Items for Object Table6ROBJNRObject number for FI-SL tablesnvarchar180
16GLREFTExample for Local FI-SL Summary Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
17GLSO1FI-SL Line Item Table with Objects for GLTO16ROBJNRObject number for FI-SL tablesnvarchar180
18GLSO2FI-SL Table with Objects, Structure corresponds to GLS26ROBJNRObject number for FI-SL tablesnvarchar180
19GLSO3FI-SL LI Table with Objects for GLTO36ROBJNRObject number for FI-SL tablesnvarchar180
20GLTO1FI-SL Table with Objects, Structure Corresponds to GLT16ROBJNRObject number for FI-SL tablesnvarchar180
21GLTO2FI-SL Table with Objects, Structure Corresponds to GLT26ROBJNRObject number for FI-SL tablesnvarchar180
22GLTO3FISL Table with Objects, Amounts and Quantities in Format P96ROBJNRObject number for FI-SL tablesnvarchar180
TOPBudgeting
23FMBDTFM budget totals table6ROBJNRObject number for objects (account assignment elements)nvarchar180
24FMRBTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPCollectionsDisbursements
25GLISDETSummary Table for Insurance (DE)6ROBJNRObject number for objects (account assignment elements)nvarchar180
26GRISDETSummary Table for Insurance (DE) - Rollup6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPConsolidation
27ECMCTSAP Cons.: Totals Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPCost Element Accounting
28COFITTotals Records for Reconciliation Ledger6ROBJNRObject number for FI-SL tablesnvarchar180
TOPFinancial Accounting
29FBICRC001TICRC: Open Items GL Accounts: Totals6ROBJNRObject number for objects (account assignment elements)nvarchar180
30FBICRC002TICRC: GL Accounts: Totals6ROBJNRObject number for objects (account assignment elements)nvarchar180
31FBICRC003TICRC: Open Items Customers/Vendors: Totals6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPFinancial Services Localization
32/CEEIS/RUTTotals Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPFlexible Real Estate Management
33VIPRLEDTAGRTSummentabelle Ledger 7A Mandate6ROBJNRObjekt-Nummer für Objekte (Kontierungselemente)nvarchar180
TOPFund Accounting
34FMCCAVCTTotals Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPFunds Management
35FMITTotals Table for Funds Management6ROBJNRObject number for objects (account assignment elements)nvarchar180
36FMSPLITTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
37FMUSFGFACTS1TSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
38FMUSFGFACTS2TSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
39FMUSFGTSummary table for US Federal Government6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPGrantee Management
40GMAVCTSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
41GMITSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPJoint Venture und Production Sharing Accounting
42JVPSC01TSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
43JVTO1JV Summary Table with Objects6ROBJNRObject number for objects (account assignment elements)nvarchar180
44JVTO2JV Billing FI-SL Summary Table6ROBJNRObject number for FI-SL tablesnvarchar180
45T8JTPMJoint Venture Production Month Summary Data5ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPLoans Management
46VDARLOBJLoan objects relationship table4ROBJNRCollateral object numbernvarchar100
47VDHOBJCollateral Objects2ROBJNRCollateral object numbernvarchar100
48VDHOBJBLDetermination of collateral value/Expert report of object11ROBJNRCollateral object numbernvarchar100
49VDHOBJGTObject building parts2ROBJNRCollateral object numbernvarchar100
TOPLocalization
50J_3RFTAXRTTax Accounting: Summary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
51J_3RFTAXRVTTax Accounting: Summary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPProfit Center Accounting
52GLPCTEC-PCA: Totals Table6ROBJNRObject number for FI-SL tablesnvarchar180
53T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material6ROBJNRObject number for FI-SL tablesnvarchar180
TOPRegulatory reporting for insurance companies
54ISSRFLDETSummary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPRemaining Beverage - Obsolete Objects
55/BEV3/CHFITTotals table6ROBJNRObject number for objects (account assignment elements)nvarchar180
56/BEV3/CHVGRTTotals table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPRetail Ledger
57PCRRETAILTTotals Table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPSpecial Purpose Ledger
58/CCIS/PBU18TPBU18: Summary table x6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPTariffs, Duties and Permits
59OIHEDTSummary table, IS-OIL Excise Duty Special Ledger6ROBJNRObject number for objects (account assignment elements)nvarchar180
60OIHSLTTDP (excise duty) special ledger summary table6ROBJNRObject number for objects (account assignment elements)nvarchar180
TOPTransfer to Financial Accounting
61TRACTSLTTotals Table6ROBJNRObject number for objects (account assignment elements)nvarchar180