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

107 columns | Print definition?ERP 6.0  | RCOMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003KSID-Tabelle fuer Trading Partner3RCOMPCompanynvarchar60
2/SMD/MD_____00IQSID-Tabelle fuer Company ID3RCOMPCompanynvarchar60
3/SMD/MD_____00PLSID-Tabelle fuer Trading Partner3RCOMPCompanynvarchar60
4CNV_20100_T001CNV backup copy for T00124RCOMPCompanynvarchar60
5CNV_20200_T001ADOriginal settings of company codes (additional fields)8RCOMPCompanynvarchar60
6CNV_20200_T880Original list of companies3RCOMPCompanynvarchar60
7CNV_20305_T001backup table of T001 (certain fields only)11RCOMPCompanynvarchar60
8EPIDXC6RCOMPnvarchar60
9FBICRC_C_CONFICR: Customizing Table for Assign Confirm Dialog3RCOMPCompanynvarchar60
10FBICRC_C_OVICR: Overview Chart with Single Company Displayed3RCOMPCompanynvarchar60
11FSBPCC_T880Company with Description2RCOMPCompanynvarchar60
12GLIDXCLine Item Index for FI-SL Global Company6RCOMPCompanynvarchar60
13T868Elimination of IC profit and loss6RCOMPCompanynvarchar60
14T887CActivity/Ledger/Company Information4RCOMPCompanynvarchar60
15T891CValidation for Special Purpose Ledger / Global Company2RCOMPCompanynvarchar60
16T892CSubstitution for Special Purpose Ledger / Global Company2RCOMPCompanynvarchar60
17T895CGlobal Fiscal Year-Dependent Version Parameters4RCOMPCompanynvarchar60
18TSTGCConsolidation test data4RCOMPCompanynvarchar60
TOPBasic Functions
19ARC_IDX_ITArchive index table for FI-SL line items6RCOMPCompanynvarchar60
20EWULC03FI-LC: Companies for conversion3RCOMPCompany for conversionnvarchar60
21FILCAFI-LC: Actual journal entry table with 2 object tables14RCOMPCompanynvarchar60
22FILCPFI-LC: Plan line items for object table14RCOMPCompanynvarchar60
23FILCTFI-LC: Global totals table with 2 object tables13RCOMPCompanynvarchar60
24GGREFAExample for Global FI-SL Line Items (Actual)14RCOMPCompanynvarchar60
25GGREFPExample for Global FI-SL Line Items (Plan)14RCOMPCompanynvarchar60
26GGREFTExample for Global FI-SL Summary Table13RCOMPCompanynvarchar60
27GLIDXAIndex to Find FI-SL Documents Based on AWKEY12RCOMPCompanynvarchar60
28GLPO2Plan Line Items for Object Table Global16RCOMPCompanynvarchar60
29GLSO2FI-SL Table with Objects, Structure corresponds to GLS216RCOMPCompanynvarchar60
30GLTO2FI-SL Table with Objects, Structure Corresponds to GLT213RCOMPCompanynvarchar60
31SMFISLSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)9RCOMPCompanynvarchar60
32T001CValid Posting Periods for Global Companies3RCOMPCompanynvarchar60
33T807RFI-SL Rollup: History of Executions11RCOMPCompanynvarchar60
34T850Company data for Consolidation2RCOMPCompanynvarchar60
35T850DAssignment of business segment2RCOMPCompanynvarchar60
36T850IVersion-dependent assignment: Company/data import + validtn2RCOMPCompanynvarchar60
37T850KCompany correspondence data2RCOMPCompanynvarchar60
38T850STax rates2RCOMPCompanynvarchar60
39T851Changes in Investments4RCOMPInvestornvarchar60
40T852GSubgroup companies5RCOMPCompany belonging to the subgroupnvarchar60
41T852USubgroup companies5RCOMPCompany belonging to the subgroupnvarchar60
42T853Company status4RCOMPCompanynvarchar60
43T863BReport groups7RCOMPCompanynvarchar60
44T868BElimination of IC profit/loss: Inventory management co.s5RCOMPInventory managing companynvarchar60
45T868LElimination of IC profit/loss: Vendor data6RCOMPInventory managing companynvarchar60
46T870Consolidation method assignment4RCOMPCompanynvarchar60
47T871Changes in investee equity4RCOMPCompanynvarchar60
48T872Equity Holdings Adjustments5RCOMPParent company IDnvarchar60
49T872IPeriodic entry for affiliated companies4RCOMPParent company IDnvarchar60
50T873Hidden reserves4RCOMPCompanynvarchar60
51T874Elimination of hidden reserves5RCOMPCompanynvarchar60
52T875Asset transfers within the group4RCOMPCompany ID of retiring companynvarchar60
53T875CChanges in depreciation4RCOMPCompany ID of retiring companynvarchar60
54T875DAsset transfers4RCOMPCompany ID of retiring companynvarchar60
55T875EChange in depreciation of asset transfers4RCOMPCompany ID of retiring companynvarchar60
56T880BValuation methods3RCOMPCompanynvarchar60
57T880GConsolidation companies2RCOMPCompanynvarchar60
58T882CGlobal Company-Ledger Assignment in FI-SL2RCOMPCompanynvarchar60
59T886CActivity/Ledger/Company Information3RCOMPCompanynvarchar60
TOPBasis Components
60ZDS400_T001Buchungskreise23RCOMPGesellschaftnvarchar60
TOPBudgeting
61FMBHFunds management budget header (entry documents)35RCOMPCompany ID of trading partnernvarchar60
62FMHBHFunds management budget header (held documents)27RCOMPCompany ID of trading partnernvarchar60
63FMPEP_VARIANTHSession variants (header part) for transaction FMPEP23RCOMPCompany ID of trading partnernvarchar60
TOPConsolidation
64ECMCASAP Cons.: Journal Entry Table (Actual)14RCOMPCompanynvarchar60
65ECMCTSAP Cons.: Totals Table13RCOMPCompanynvarchar60
66TFIN010Consolidation Unit Integration8RCOMPCompanynvarchar60
67TFMIG02Allocation: Company -> Consolidation Unit2RCOMPCompanynvarchar60
TOPContract Accounts Receivable and Payable
68TFK880Global Company Data (for KONS Ledger)3RCOMPCompany ID of trading partnernvarchar60
TOPData Transfer
69PPDITTransfer to Accounting: Lines in HR IDOCs43RCOMPCompany ID of trading partnernvarchar60
TOPFinancial Accounting
70FBICRC001AICRC: Open Items GL Accounts: Documents13RCOMPCompanynvarchar60
71FBICRC001PNot in use13RCOMPCompanynvarchar60
72FBICRC001TICRC: Open Items GL Accounts: Totals12RCOMPCompanynvarchar60
73FBICRC002AICRC: GL Accounts: Documents13RCOMPCompanynvarchar60
74FBICRC002PNot in use13RCOMPCompanynvarchar60
75FBICRC002TICRC: GL Accounts: Totals12RCOMPCompanynvarchar60
76FBICRC003AICRC: Open Items Customers/Vendors: Documents13RCOMPCompanynvarchar60
77FBICRC003PNot in use13RCOMPCompanynvarchar60
78FBICRC003TICRC: Open Items Customers/Vendors: Totals12RCOMPCompanynvarchar60
79FBICRC01010Reconciliation Processes: Attributes per Company3RCOMPCompanynvarchar60
80FBICRC01020Not in use3RCOMPCompanynvarchar60
81FBICRC01021Not in use3RCOMPCompanynvarchar60
82FBICRC01025Not in use4RCOMPCompanynvarchar60
83FBICRC01026Not in use5RCOMPCompanynvarchar60
84FBICRC01027Reconciliation: Current Status per Company4RCOMPCompanynvarchar60
85FBICRC01028Reconciliation Process 003: Lock Table for Company Pairs5RCOMPCompanynvarchar60
86FBICRC01040IC Reconciliation: Current Status per Company6RCOMPCompanynvarchar60
87FBICRC01045IC Reconciliation: Lock Table for Company Pairs6RCOMPCompanynvarchar60
88FBICRC01050Differences per Company Pair and Display Category6RCOMPCompanynvarchar60
89ICRC01Document Table for G/L Account Reconciliation11RCOMPCompany ID of trading partnernvarchar60
90ICRCAICRC: Items to be Reconciled2RCOMPCompanynvarchar60
91ICRCLOGICRC: Log Numbers of Automatic Reconciliation2RCOMPCompanynvarchar60
92ICRCSICRC: Status of Data Procurement2RCOMPCompanynvarchar60
93ICRCUICRC: Potentially Differing Document Groups2RCOMPCompanynvarchar60
94ICRCZICRC: Reconciled, Completed Items2RCOMPCompanynvarchar60
95T001Company Codes12RCOMPCompanynvarchar60
96TICRC1RFC Destination and Contact Person in Company2RCOMPCompanynvarchar60
TOPFunds Management
97FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 60012RCOMPCompanynvarchar60
TOPGeneral Ledger Accounting
98FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records47RCOMPCompanynvarchar60
99FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis48RCOMPCompanynvarchar60
TOPIntegrated Product and Process Engineering
100CRPTYPEType of Reporting Point4RCOMPPost Goods Movements and Production Activitiesnvarchar10
TOPInvestment Programs
101IMPRInvestment Program Positions32RCOMPCompanynvarchar60
102TAI11Group shares in Inv. Program Info System4RCOMPCompanynvarchar60
TOPLocal Currency Changeover
103EUROFISLEMU: Information on record level for FI-SL5RCOMPCompanynvarchar60
104EWUSLEMU: Currencies from special ledger6RCOMPCompanynvarchar60
105EWUTSLEMU: Combinations for TSL fields to be converted in FI-SL5RCOMPCompanynvarchar60
TOPProfit Center Accounting
106ARC_IPC_ITArchive index table for FI-SL line items6RCOMPCompanynvarchar60
TOPSchedule Manager
107T880Global Company Data (for KONS Ledger)2RCOMPCompanynvarchar60