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

51 columns | Print definition?ERP 6.0  | FISCAL_YEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_CROAFiscalization Croatia: Fiscalized documents6FISCAL_YEARFiscal Yearnvarchar40
2/CCEE/FISC_NUMBRFiscalization Croatia: Number Range Number Assignment5FISCAL_YEARTo fiscal yearnvarchar40
3/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head13FISCAL_YEARFiscal Yearnvarchar40
4/OPT/VT_DOC_HEADDocument Header13FISCAL_YEARFiscal Yearnvarchar40
5/OPT/X149OPENTEXT: Approval Diagnostic data6FISCAL_YEARFiscal Yearnvarchar40
6/OPT/Y149OPENTEXT: Approval Diagnostic data6FISCAL_YEARFiscal Yearnvarchar40
7/OPT/Z149OPENTEXT: Approval Diagnostic data6FISCAL_YEARFiscal Yearnvarchar40
8/ORS/DIAGNOSTICSOPENTEXT: Approval Diagnostic data6FISCAL_YEARFiscal Yearnvarchar40
9/SAPPSSRM/THRESLThresholds7FISCAL_YEARFiscal Yearnvarchar40
10EPIC_CBCEPIC:Cash budgeting control consumption table3FISCAL_YEARFiscal Yearnvarchar40
11J_1UF_TAX_MAINTax Declaration and Clarification Declaration7FISCAL_YEARFiscal Yearnvarchar40
12T7CLCERTIFNBREmployee Income Certificate number assignment2FISCAL_YEARYearnvarchar40
13T7UNPF_FI_OPRHDOperation Header6FISCAL_YEARFiscal Yearnvarchar40
TOPAccounting Interface
14GLE_ECS_BALECS+GL Balances by Company Code, Account, Fiscal Year, Crcy4FISCAL_YEARFiscal Yearnvarchar40
15GLE_ECS_BAL_ITEMGL open items that are not in ECS4FISCAL_YEARFiscal Yearnvarchar40
16GLE_ECS_ITEMECS: Error Correction Items8FISCAL_YEARFiscal Year of Posted Documentnvarchar40
TOPAccounts Receivable Accounting Process Integration
17FDM_INVOICE_MEMInvoice Information Provided4FISCAL_YEARFiscal Yearnvarchar40
18FDM_INV_MEM_OBSInvoice Information Provided Obsolete4FISCAL_YEARFiscal Yearnvarchar40
TOPBudgeting and Availability Control
19GMBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines5FISCAL_YEARFiscal Year of Grantee Organizationnvarchar40
20GMHBDGTFYDLINEGM Budgeting Fiscal Year Distribution Lines6FISCAL_YEARFiscal Year of Grantee Organizationnvarchar40
TOPBusiness Package for Manager Self-Service FI
21FCOM_WHERE_USEDUsage of Master Data Objects12FISCAL_YEARFiscal Yearnvarchar40
TOPCross-Application Components
22/OPT/S_GR_HDRVSS Staging Table: GR Header6FISCAL_YEARMaterial Document Yearnvarchar40
23/OPT/S_GR_LINVSS Stageing Table: GR Line7FISCAL_YEARMaterial Document Yearnvarchar40
24/OPT/S_INV_HDRVSS Staging Table: Invoice Header7FISCAL_YEARFiscal Yearnvarchar40
25/OPT/S_INV_LINVSS Staging Table: Invoice lines8FISCAL_YEARFiscal Yearnvarchar40
26/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices5FISCAL_YEARFiscal Yearnvarchar40
27/OPT/VIM_HD_NPOVIM IE Monitor: Header Data for Parked NPO Invoices4FISCAL_YEARFiscal Yearnvarchar40
28/OPT/VIM_HD_POVIM IE Monitor: Header Data for Parked PO Invoices3FISCAL_YEARFiscal Yearnvarchar40
29/OPT/VIM_NPO_WIDVIM IE Monitortable: WI Header Data for NPO Invoices4FISCAL_YEARFiscal Yearnvarchar40
30/OPT/VIM_NPO_WIHVIM IE Monitortable: WI Header Data for NPO Invoices4FISCAL_YEARFiscal Yearnvarchar40
31/OPT/VIM_PO_WIDVIM Report: WI Header Data for PO Invoices3FISCAL_YEARFiscal Yearnvarchar40
32/OPT/VIM_PO_WIHVIM Report: WI Header Data for PO Invoices3FISCAL_YEARFiscal Yearnvarchar40
TOPFunctions for U.S. Federal Government
33FMFG_ABPParameters for Automatic Budget Postings Functionality4FISCAL_YEARFiscal Yearnvarchar40
34FMFG_ABP_HDR_DEFABP Budget Entry Document default attributes3FISCAL_YEARFiscal Yearnvarchar40
TOPInformation System
35FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW27FISCAL_YEARFiscal Yearnvarchar40
TOPTransaction Management
36TCHT_HD_SFGDTSFGDT Representation of Instruments14FISCAL_YEARFiscal Yearnvarchar40
37THXET_MEAS_HEADEffectiveness Test Results4FISCAL_YEARFiscal Yearnvarchar40
38THXT_HINSTHedge Instrument6FISCAL_YEARFiscal Yearnvarchar40
39THXT_HITEMHedge Item DB table6FISCAL_YEARFiscal Yearnvarchar40
40THXT_HRELHedging Relationship6FISCAL_YEARFiscal Yearnvarchar40
TOPTransaction Manager
41TRDTT_DATSUB_ADMLegacy Data Trnsfr: Admin., Designation of Subposition5FISCAL_YEARFiscal Yearnvarchar40
42TRDTT_DES_ADMINLDT: Admin. of Bus.Trans.Designation in Hedging Relationship3FISCAL_YEARFiscal Yearnvarchar40
43TRDTT_VAD_FUTSUBValuation Area-Dependent Data for Futures with Subpositions5FISCAL_YEARFiscal Yearnvarchar40
44TRDTT_VAD_OTCSUBVal.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos.5FISCAL_YEARFiscal Yearnvarchar40
45TRDTT_VAD_SECSUBValuation Area-Dependent Data for Securities w. Subpositions5FISCAL_YEARFiscal Yearnvarchar40
TOPTransfer to Financial Accounting
46TLVT_VAL_STEPTreasury: Valuation Step10FISCAL_YEARFiscal Yearnvarchar40
47TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.29FISCAL_YEARFiscal Yearnvarchar40
48TRLT_INIT_DESInit.Hedging Relationship: Bus.Trans.Mgmt, Designation3FISCAL_YEARFiscal Yearnvarchar40
49TRLT_INIT_SUB_OTInit.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos.5FISCAL_YEARFiscal Yearnvarchar40
50TRLT_INIT_SUB_SEInit.Hedging Relationship for Securities with Subpositions5FISCAL_YEARFiscal Yearnvarchar40
51TRLT_INIT_SUB_TRInit.Hedging Rel.: Bus.Trans.Mgmnt, Designation Subpositions5FISCAL_YEARFiscal Yearnvarchar40