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

98 columns | Print definition?ERP 6.0  | RMVCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances7RMVCTnvarchar30
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.7RMVCTnvarchar30
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs7RMVCTnvarchar30
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)7RMVCTnvarchar30
5FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT16RMVCTTransaction Typenvarchar30
6FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT18RMVCTTransaction Typenvarchar30
7FAGLFLEXT_BAKGeneral Ledger: Totals15RMVCTTransaction Typenvarchar30
8FAGLFLEXT_DIFDelta Table: G/L Totals15RMVCTTransaction Typenvarchar30
9GLPCA_CTProfit Center Documents108RMVCTTransaction Typenvarchar30
10GLPCA_T_CTProfit Center Documents124RMVCTTransaction Typenvarchar30
11TSTGCConsolidation test data8RMVCTTransaction Typenvarchar30
12ZZLINEAActual line item table21RMVCTTransaction Typenvarchar30
13ZZLINECObject table 24RMVCTTransaction Typenvarchar30
14ZZLINEPPlan line items table21RMVCTTransaction Typenvarchar30
15ZZLINETSummary table20RMVCTTransaction Typenvarchar30
TOPAccounting Interface
16GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)152RMVCTTransaction Typenvarchar30
17GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)152RMVCTTransaction Typenvarchar30
TOPBasic Functions
18FILCAFI-LC: Actual journal entry table with 2 object tables22RMVCTTransaction Typenvarchar30
19FILCCFI-LC: Transaction-related fields for table FILCT6RMVCTTransaction Typenvarchar30
20FILCPFI-LC: Plan line items for object table22RMVCTTransaction Typenvarchar30
21FILCTFI-LC: Global totals table with 2 object tables21RMVCTTransaction Typenvarchar30
22GLFUNCAActual Line Items Table for Cost of Sales Accounting20RMVCTTransaction Typenvarchar30
23GLFUNCCObject Table 2 for Cost of Sales Accounting5RMVCTTransaction Typenvarchar30
24GLFUNCPPlan Line Items Table for Cost of Sales Accounting20RMVCTTransaction Typenvarchar30
25GLFUNCTTotals Table for Cost of Sales Accounting19RMVCTTransaction Typenvarchar30
26GLFUNCURollup line item tables with function area for IDES20RMVCTTransaction Typenvarchar30
27GLFUNCVRollup plan line items table with function area for IDES20RMVCTTransaction Typenvarchar30
28GLPO1Plan Line Items for Object Table20RMVCTTransaction Typenvarchar30
29GLPO2Plan Line Items for Object Table Global22RMVCTTransaction Typenvarchar30
30GLPO3Plan Line Items for Object Table20RMVCTTransaction Typenvarchar30
31GLSO1FI-SL Line Item Table with Objects for GLTO120RMVCTTransaction Typenvarchar30
32GLSO2FI-SL Table with Objects, Structure corresponds to GLS222RMVCTTransaction Typenvarchar30
33GLSO3FI-SL LI Table with Objects for GLTO320RMVCTTransaction Typenvarchar30
34GLT3Summary Data Preparations for Consolidation9RMVCTTransaction Typenvarchar30
35GLTO1FI-SL Table with Objects, Structure Corresponds to GLT117RMVCTTransaction Typenvarchar30
36GLTO2FI-SL Table with Objects, Structure Corresponds to GLT219RMVCTTransaction Typenvarchar30
37GLTO3FISL Table with Objects, Amounts and Quantities in Format P917RMVCTTransaction Typenvarchar30
38T851Changes in Investments10RMVCTTransaction type: Investmentsnvarchar30
39T854SSelected FS items7RMVCTTransaction type for the selected itemnvarchar30
40T863BReport groups9RMVCTTransaction type group for the standard reportnvarchar30
41T865Intercompany Elimination14RMVCTIndicator: Document per transaction typenvarchar10
42T866Elimination of IC profit/loss: FS items10RMVCTTransaction type for elimination of intercompany profit/lossnvarchar30
43T866ZElimination of IC P/L: Assignment of additional fields3RMVCTTransaction type for elimination of intercompany profit/lossnvarchar30
44T871Changes in investee equity10RMVCTTransaction Typenvarchar30
TOPCollectionsDisbursements
45GLISDEAActual Line Item Tables for Insurance (DE)25RMVCTTransaction Typenvarchar30
46GLISDECObject Table 2 for Insurance (DE)4RMVCTTransaction Typenvarchar30
47GLISDEPPlan Line Item Table for Insurance (DE)25RMVCTTransaction Typenvarchar30
48GLISDETSummary Table for Insurance (DE)24RMVCTTransaction Typenvarchar30
49GRISDEAActual Line Item Table for Insurance (DE) - Rollup25RMVCTTransaction Typenvarchar30
50GRISDECObject Table 2 for Insurance (DE) - Rollup4RMVCTTransaction Typenvarchar30
51GRISDEPPlan Line Item Table for Insurance (DE) - Rollup25RMVCTTransaction Typenvarchar30
52GRISDETSummary Table for Insurance (DE) - Rollup24RMVCTTransaction Typenvarchar30
TOPConsolidation
53TFMIG05Allocation: Transaction Type -> Subitem2RMVCTTransaction Typenvarchar30
TOPElectronic Bank Statement
54FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)19RMVCTTransaction Typenvarchar30
55FEB_ACTAcct Assignment Templates19RMVCTTransaction Typenvarchar30
TOPFinancial Accounting
56ACCTITCompressed Data from FI/CO Document46RMVCTTransaction Typenvarchar30
57VBSEGSDocument Segment for Document Parking - G/L Account Database29RMVCTTransaction Typenvarchar30
TOPFund Accounting
58FMGLFLEX00General ledger: Transaction attributes3RMVCTTransaction Typenvarchar30
59FMGLFLEXAGeneral Ledger: Actual Line Items8RMVCTTransaction Typenvarchar30
60FMGLFLEXPGeneral Ledger: Plan Line Items10RMVCTTransaction Typenvarchar30
61FMGLFLEXTGeneral Ledger Public Sector: Total15RMVCTTransaction Typenvarchar30
62PSGLFLEX00General ledger: Transaction attributes3RMVCTTransaction Typenvarchar30
63PSGLFLEXAGeneral Ledger: Actual Line Items8RMVCTTransaction Typenvarchar30
64PSGLFLEXPGeneral Ledger: Plan Line Items10RMVCTTransaction Typenvarchar30
65PSGLFLEXTGeneral Ledger Public Sector: Total15RMVCTTransaction Typenvarchar30
TOPFunds Management-Specific Postings
66FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years30RMVCTTransaction Typenvarchar30
67PSOSEGSRecurring Request Document Segment, G/L Accounts29RMVCTTransaction Typenvarchar30
TOPGeneral Ledger Accounting
68FAGLFLEX00General ledger: Transaction attributes3RMVCTTransaction Typenvarchar30
69FAGLFLEXAGeneral Ledger: Actual Line Items8RMVCTTransaction Typenvarchar30
70FAGLFLEXPGeneral Ledger: Plan Line Items10RMVCTTransaction Typenvarchar30
71FAGLFLEXTGeneral Ledger: Totals15RMVCTTransaction Typenvarchar30
72FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records8RMVCTTransaction Typenvarchar30
73FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis6RMVCTTransaction Typenvarchar30
74FAGL_RMAP_SAPReorganization: Object Number of the Signature Values4RMVCTTransaction Typenvarchar30
75FAGL_RSNAPSHOTReorganization: Snapshot27RMVCTTransaction Typenvarchar30
76GLFLEX07General ledger: Transaction attributes3RMVCTTransaction Typenvarchar30
77GLFLEXAFlexible general ledger: Actual line items25RMVCTTransaction Typenvarchar30
78GLFLEXPFlexible G/L: Plan line items25RMVCTTransaction Typenvarchar30
79GLFLEXTFlexible G/L: Totals31RMVCTTransaction Typenvarchar30
TOPGeneral Ledger Reorganization
80FAGL_R_BLNCEReorganization: Balances to Be Transferred24RMVCTTransaction Typenvarchar30
81FAGL_R_MAP_SAPReorganization: Object Number of the Included SAP Fields4RMVCTTransaction Typenvarchar30
TOPGL Account Posting
82TCJ_POSITIONSCash Journal Document Items26RMVCTTransaction Typenvarchar30
TOPInformation System
83BWPOSValuations for Open Items55RMVCTTransaction Typenvarchar30
TOPInventory Management
84MWZDM07M2ZDM07M282RMVCTTransaction Typenvarchar30
TOPJoint Venture und Production Sharing Accounting
85JVGLFLEX00General ledger: Transaction attributes3RMVCTTransaction Typenvarchar30
86JVGLFLEXAGeneral Ledger: Actual Line Items8RMVCTTransaction Typenvarchar30
87JVGLFLEXPGeneral Ledger: Plan Line Items10RMVCTTransaction Typenvarchar30
88JVGLFLEXTGeneral Ledger: Totals15RMVCTTransaction Typenvarchar30
TOPProfit Center Accounting
89GLPCAEC-PCA: Actual Line Items64RMVCTTransaction Typenvarchar30
90GLPCCEC-PCA: Transaction Attributes16RMVCTTransaction Typenvarchar30
91GLPCPEC-PCA: Plan Line Items124RMVCTTransaction Typenvarchar30
92GLPCTEC-PCA: Totals Table105RMVCTTransaction Typenvarchar30
93T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material104RMVCTTransaction Typenvarchar30
TOPSpecial Purpose Ledger
94/CCIS/PROFTAX00Object Table Number:003RMVCTTransaction Typenvarchar30
95/CCIS/PROFTAXAActual Line Items Table for General Ledger8RMVCTTransaction Typenvarchar30
96/CCIS/PROFTAXPPlan Line Items Table for General Ledger10RMVCTTransaction Typenvarchar30
97/CCIS/PROFTAXTTotals Table for General Ledger15RMVCTTransaction Typenvarchar30
TOPTransfer to Financial Accounting
98TRACT_ACCITEMAccounting Items39RMVCTTransaction Typenvarchar30