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

94 columns | Print definition?ERP 6.0  | RASSC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances25RASSCnvarchar60
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.26RASSCnvarchar60
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs28RASSCnvarchar60
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)28RASSCnvarchar60
5FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT35RASSCCompany ID of trading partnernvarchar60
6FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT37RASSCCompany ID of trading partnernvarchar60
7FAGLFLEXT_BAKGeneral Ledger: Totals37RASSCCompany ID of trading partnernvarchar60
8FAGLFLEXT_DIFDelta Table: G/L Totals37RASSCCompany ID of trading partnernvarchar60
9GLPCA_CTProfit Center Documents97RASSCCompany ID of trading partnernvarchar60
10GLPCA_T_CTProfit Center Documents113RASSCCompany ID of trading partnernvarchar60
11T868Elimination of IC profit and loss7RASSCCompany ID of trading partnernvarchar60
12TSTGCConsolidation test data9RASSCCompany ID of trading partnernvarchar60
TOPBasic Functions
13FILCAFI-LC: Actual journal entry table with 2 object tables17RASSCCompany ID of trading partnernvarchar60
14FILCPFI-LC: Plan line items for object table17RASSCCompany ID of trading partnernvarchar60
15FILCTFI-LC: Global totals table with 2 object tables16RASSCCompany ID of trading partnernvarchar60
16GLFUNCAActual Line Items Table for Cost of Sales Accounting21RASSCCompany ID of trading partnernvarchar60
17GLFUNCCObject Table 2 for Cost of Sales Accounting6RASSCCompany ID of trading partnernvarchar60
18GLFUNCPPlan Line Items Table for Cost of Sales Accounting21RASSCCompany ID of trading partnernvarchar60
19GLFUNCTTotals Table for Cost of Sales Accounting20RASSCCompany ID of trading partnernvarchar60
20GLFUNCURollup line item tables with function area for IDES21RASSCCompany ID of trading partnernvarchar60
21GLFUNCVRollup plan line items table with function area for IDES21RASSCCompany ID of trading partnernvarchar60
22GLPO1Plan Line Items for Object Table21RASSCCompany ID of trading partnernvarchar60
23GLPO2Plan Line Items for Object Table Global25RASSCCompany ID of trading partnernvarchar60
24GLPO3Plan Line Items for Object Table21RASSCCompany ID of trading partnernvarchar60
25GLSO1FI-SL Line Item Table with Objects for GLTO121RASSCCompany ID of trading partnernvarchar60
26GLSO2FI-SL Table with Objects, Structure corresponds to GLS225RASSCCompany ID of trading partnernvarchar60
27GLSO3FI-SL LI Table with Objects for GLTO321RASSCCompany ID of trading partnernvarchar60
28GLT3Summary Data Preparations for Consolidation10RASSCCompany ID of trading partnernvarchar60
29GLTO1FI-SL Table with Objects, Structure Corresponds to GLT118RASSCCompany ID of trading partnernvarchar60
30GLTO2FI-SL Table with Objects, Structure Corresponds to GLT222RASSCCompany ID of trading partnernvarchar60
31GLTO3FISL Table with Objects, Amounts and Quantities in Format P918RASSCCompany ID of trading partnernvarchar60
32T851Changes in Investments5RASSCInvesteenvarchar60
33T864Reclassifications7RASSCTrading partner (reclassifications)nvarchar60
34T868BElimination of IC profit/loss: Inventory management co.s8RASSCSupplying companynvarchar60
35T868LElimination of IC profit/loss: Vendor data3RASSCSupplying companynvarchar60
36T872Equity Holdings Adjustments4RASSCCompany ID of the investeenvarchar60
37T872IPeriodic entry for affiliated companies3RASSCCompany ID of the investeenvarchar60
38T874Elimination of hidden reserves6RASSCCompany ID of trading partnernvarchar60
39T875Asset transfers within the group7RASSCAcquiring companynvarchar60
40T875CChanges in depreciation10RASSCAcquiring companynvarchar60
41T875DAsset transfers5RASSCAcquiring companynvarchar60
42T875EChange in depreciation of asset transfers5RASSCAcquiring companynvarchar60
TOPCollectionsDisbursements
43GLISDEAActual Line Item Tables for Insurance (DE)21RASSCCompany ID of trading partnernvarchar60
44GLISDEPPlan Line Item Table for Insurance (DE)21RASSCCompany ID of trading partnernvarchar60
45GLISDETSummary Table for Insurance (DE)20RASSCCompany ID of trading partnernvarchar60
46GRISDEAActual Line Item Table for Insurance (DE) - Rollup21RASSCCompany ID of trading partnernvarchar60
47GRISDEPPlan Line Item Table for Insurance (DE) - Rollup21RASSCCompany ID of trading partnernvarchar60
48GRISDETSummary Table for Insurance (DE) - Rollup20RASSCCompany ID of trading partnernvarchar60
TOPFinancial Accounting
49FBICRC001AICRC: Open Items GL Accounts: Documents17RASSCCompany ID of trading partnernvarchar60
50FBICRC001PNot in use16RASSCCompany ID of trading partnernvarchar60
51FBICRC001TICRC: Open Items GL Accounts: Totals16RASSCCompany ID of trading partnernvarchar60
52FBICRC002AICRC: GL Accounts: Documents17RASSCCompany ID of trading partnernvarchar60
53FBICRC002PNot in use16RASSCCompany ID of trading partnernvarchar60
54FBICRC002TICRC: GL Accounts: Totals16RASSCCompany ID of trading partnernvarchar60
55FBICRC003AICRC: Open Items Customers/Vendors: Documents18RASSCCompany ID of trading partnernvarchar60
56FBICRC003PNot in use17RASSCCompany ID of trading partnernvarchar60
57FBICRC003TICRC: Open Items Customers/Vendors: Totals17RASSCCompany ID of trading partnernvarchar60
58FBICRC01021Not in use4RASSCCompany ID of trading partnernvarchar60
59FBICRC01026Not in use6RASSCCompany ID of trading partnernvarchar60
60FBICRC01028Reconciliation Process 003: Lock Table for Company Pairs6RASSCCompany ID of trading partnernvarchar60
61FBICRC01045IC Reconciliation: Lock Table for Company Pairs7RASSCCompany ID of trading partnernvarchar60
62FBICRC01050Differences per Company Pair and Display Category7RASSCCompany ID of trading partnernvarchar60
TOPFund Accounting
63FMGLFLEX06General ledger: Sender SAP additional account assignment4RASSCCompany ID of trading partnernvarchar60
64FMGLFLEXAGeneral Ledger: Actual Line Items22RASSCCompany ID of trading partnernvarchar60
65FMGLFLEXPGeneral Ledger: Plan Line Items24RASSCCompany ID of trading partnernvarchar60
66FMGLFLEXTGeneral Ledger Public Sector: Total31RASSCCompany ID of trading partnernvarchar60
67PSGLFLEX06General ledger: Sender SAP additional account assignment4RASSCCompany ID of trading partnernvarchar60
68PSGLFLEXAGeneral Ledger: Actual Line Items24RASSCCompany ID of trading partnernvarchar60
69PSGLFLEXPGeneral Ledger: Plan Line Items26RASSCCompany ID of trading partnernvarchar60
70PSGLFLEXTGeneral Ledger Public Sector: Total33RASSCCompany ID of trading partnernvarchar60
TOPGeneral Ledger Accounting
71FAGLFLEX06General ledger: Sender SAP additional account assignment6RASSCCompany ID of trading partnernvarchar60
72FAGLFLEXAGeneral Ledger: Actual Line Items28RASSCCompany ID of trading partnernvarchar60
73FAGLFLEXPGeneral Ledger: Plan Line Items30RASSCCompany ID of trading partnernvarchar60
74FAGLFLEXTGeneral Ledger: Totals37RASSCCompany ID of trading partnernvarchar60
75FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records29RASSCCompany ID of trading partnernvarchar60
76FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis27RASSCCompany ID of trading partnernvarchar60
77GLFLEX06General ledger: Sender SAP additional account assignment6RASSCCompany ID of trading partnernvarchar60
78GLFLEXAFlexible general ledger: Actual line items23RASSCCompany ID of trading partnernvarchar60
79GLFLEXPFlexible G/L: Plan line items23RASSCCompany ID of trading partnernvarchar60
80GLFLEXTFlexible G/L: Totals29RASSCCompany ID of trading partnernvarchar60
TOPInventory Accounting
81CFIOCONSI0CFIN Objects for Consignment13RASSCCompany ID of trading partnernvarchar60
82CFIOGMVMT0CFIN Objects for Material Documents (GR-Based IV)13RASSCCompany ID of trading partnernvarchar60
83CFIORPURITM0CFIN Objects for Purchase Order Items14RASSCCompany ID of trading partnernvarchar60
84CFIOSENTR0CFIN Objects for Services13RASSCCompany ID of trading partnernvarchar60
TOPJoint Venture und Production Sharing Accounting
85JVGLFLEX06General ledger: Sender SAP additional account assignment6RASSCCompany ID of trading partnernvarchar60
86JVGLFLEXAGeneral Ledger: Actual Line Items27RASSCCompany ID of trading partnernvarchar60
87JVGLFLEXPGeneral Ledger: Plan Line Items29RASSCCompany ID of trading partnernvarchar60
88JVGLFLEXTGeneral Ledger: Totals36RASSCCompany ID of trading partnernvarchar60
TOPProfit Center Accounting
89GLPCAEC-PCA: Actual Line Items21RASSCCompany ID of trading partnernvarchar60
90GLPCCEC-PCA: Transaction Attributes12RASSCCompany ID of trading partnernvarchar60
91GLPCPEC-PCA: Plan Line Items21RASSCCompany ID of trading partnernvarchar60
92GLPCTEC-PCA: Totals Table20RASSCCompany ID of trading partnernvarchar60
93T8A50Acct determination of P+L acct for chrg off valuation diff.3RASSCCompany ID of trading partnernvarchar60
94T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material22RASSCCompany ID of trading partnernvarchar60