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  | SOBJNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWTSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
2ZSEMBPSTSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
3ZSPLITTSummentabelle8SOBJNRObjekt-Nummer für Partnerobjekte (Kontierungselemente)nvarchar180
4ZZ001TSummary Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
5ZZLINETSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
6ZZSL01TSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
7ZZSPECTSummary table7SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPAvailability Control
8FMAVCTAVC Summary Table (BCS)8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPBasic Functions
9FILCTFI-LC: Global totals table with 2 object tables8SOBJNRObject number for FI-SL tablesnvarchar180
10GGREFTExample for Global FI-SL Summary Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
11GLFUNCTTotals Table for Cost of Sales Accounting8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
12GLPO1Plan Line Items for Object Table7SOBJNRObject number for FI-SL tablesnvarchar180
13GLPO2Plan Line Items for Object Table Global7SOBJNRObject number for FI-SL tablesnvarchar180
14GLPO3Plan Line Items for Object Table7SOBJNRObject number for FI-SL tablesnvarchar180
15GLREFTExample for Local FI-SL Summary Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
16GLSO1FI-SL Line Item Table with Objects for GLTO17SOBJNRObject number for FI-SL tablesnvarchar180
17GLSO2FI-SL Table with Objects, Structure corresponds to GLS27SOBJNRObject number for FI-SL tablesnvarchar180
18GLSO3FI-SL LI Table with Objects for GLTO37SOBJNRObject number for FI-SL tablesnvarchar180
19GLTO1FI-SL Table with Objects, Structure Corresponds to GLT17SOBJNRObject number for FI-SL tablesnvarchar180
20GLTO2FI-SL Table with Objects, Structure Corresponds to GLT27SOBJNRObject number for FI-SL tablesnvarchar180
21GLTO3FISL Table with Objects, Amounts and Quantities in Format P97SOBJNRObject number for FI-SL tablesnvarchar180
TOPBudgeting
22FMBDTFM budget totals table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
23FMRBTSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPCollectionsDisbursements
24GLISDETSummary Table for Insurance (DE)8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
25GRISDETSummary Table for Insurance (DE) - Rollup8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPConsolidation
26ECMCTSAP Cons.: Totals Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPCost Element Accounting
27COFITTotals Records for Reconciliation Ledger8SOBJNRObject number for FI-SL tablesnvarchar180
TOPFinancial Accounting
28FBICRC001TICRC: Open Items GL Accounts: Totals8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
29FBICRC002TICRC: GL Accounts: Totals8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
30FBICRC003TICRC: Open Items Customers/Vendors: Totals8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPFinancial Services Localization
31/CEEIS/RUTTotals Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPFlexible Real Estate Management
32VIPRLEDTAGRTSummentabelle Ledger 7A Mandate7SOBJNRObjekt-Nummer für Partnerobjekte (Kontierungselemente)nvarchar180
TOPFund Accounting
33FMCCAVCTTotals Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPFunds Management
34FMITTotals Table for Funds Management8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
35FMREAS_INDEX_FCReassignment Tool Index Table of Commitment Items5SOBJNRObject numbernvarchar220
36FMSPLITTSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
37FMUSFGFACTS1TSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
38FMUSFGFACTS2TSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
39FMUSFGTSummary table for US Federal Government8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPGeneral Ledger
40/EACA/GL_DOCNR_SValue Table for Number Range Subobject for GL Doc. Numbers2SOBJNRTechnical Subobject for Number Range Object /EACA/GLDCnvarchar60
41/EACA/GL_DOCNR_TInverse Value Table for GL Number Range Subobject4SOBJNRTechnical Subobject for Number Range Object /EACA/GLDCnvarchar60
42/EACA/GL_DOCNR_XG/L Number Ranges: Counter for Generated Subobjects2SOBJNRData Field Character 3nvarchar30
TOPGrantee Management
43GMAVCTSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
44GMITSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPJoint Venture und Production Sharing Accounting
45JVPSC01TSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
46JVTO1JV Summary Table with Objects8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
47JVTO2JV Billing FI-SL Summary Table7SOBJNRObject number for FI-SL tablesnvarchar180
48T8JTPMJoint Venture Production Month Summary Data7SOBJNRObject number for transaction attributesnvarchar180
TOPLocalization
49J_3RFTAXRTTax Accounting: Summary table7SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
50J_3RFTAXRVTTax Accounting: Summary table7SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPProfit Center Accounting
51GLPCTEC-PCA: Totals Table8SOBJNRObject number for FI-SL tablesnvarchar180
52T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material8SOBJNRObject number for FI-SL tablesnvarchar180
TOPRegulatory reporting for insurance companies
53ISSRFLDETSummary table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPRemaining Beverage - Obsolete Objects
54/BEV3/CHFITTotals table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
55/BEV3/CHVGRTTotals table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPRetail Ledger
56PCRRETAILTTotals Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPSingle Transaction Costing
57JBDI0000Template Structure for Generated Qty Table in STC for ABC4SOBJNRSender Objectnvarchar220
TOPSpecial Purpose Ledger
58/CCIS/PBU18TPBU18: Summary table x8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPTariffs, Duties and Permits
59OIHEDTSummary table, IS-OIL Excise Duty Special Ledger8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
60OIHSLTTDP (excise duty) special ledger summary table7SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180
TOPTransfer to Financial Accounting
61TRACTSLTTotals Table8SOBJNRObject number for partner objects (accnt assignmnt elements)nvarchar180