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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TREAC_DFLOWTYPETreasury: Specify Update Types for Central Clearing2DIS_FLOWTYPEUpdate Typenvarchar80
2TREAT_STATEM_ITMClearing Account Statement Detail11DIS_FLOWTYPEUpdate Typenvarchar80
TOPBack Office
3TRFC_DFTYPE_MPTRF: Update Types for Manual Posting2DIS_FLOWTYPEUpdate Typenvarchar80
4TRFC_PM_FTTreasury: Assignment of Update Type to Flow Category2DIS_FLOWTYPEUpdate Typenvarchar80
5TRFT_FLOWTreasury: Table with TRF Flows5DIS_FLOWTYPEUpdate Typenvarchar80
6TRFT_MAN_PT_FLOWTRF: Flows for Manual Posting5DIS_FLOWTYPEUpdate Typenvarchar80
7TRFT_MATCH_FLOWTreasury: Table with Matching Process Flows5DIS_FLOWTYPEUpdate Typenvarchar80
8TRFT_PACC_BANKPayment Information6DIS_FLOWTYPEUpdate Typenvarchar80
9TRSC_DFLOWTYPETreasury: Attributes of Update Type for TRS2DIS_FLOWTYPEUpdate Typenvarchar80
10TRSC_DFTYPE_IPCFM: Update Types for Incoming Payments2DIS_FLOWTYPEUpdate Typenvarchar80
11TRSC_DFTYPE_MPCFM: Update Types for Manual Posting2DIS_FLOWTYPEUpdate Typenvarchar80
12TRSC_REF_DISFLOTreasury: Referenced Update Types (Incoming payment)3DIS_FLOWTYPEUpdate Typenvarchar80
13TRST_CLASFLOCFM: Class Flows in Securities Account14DIS_FLOWTYPEUpdate Typenvarchar80
14TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account14DIS_FLOWTYPEUpdate Typenvarchar80
15TRST_NOM_CORRTreasury: Nominal Adjustment12DIS_FLOWTYPEUpdate Typenvarchar80
16TRST_POSCHG_FLOWCFM: Flow for Securities Account Position Change22DIS_FLOWTYPEUpdate Typenvarchar80
17TRST_SECACC_BANKPayment Details for Securities Account6DIS_FLOWTYPEUpdate Typenvarchar80
18TRST_SECACC_PAYDownport Payment Information for Securities Management5DIS_FLOWTYPEUpdate Typenvarchar80
TOPMarket Risk Analyzer
19FTBB_FTYPE_CFKZAssign Update Types to Securities Cash Flow Indicator2DIS_FLOWTYPEUpdate Typenvarchar80
TOPPortfolio Analyzer
20PFAIM_TR_UTMATCHAssignment of Update Type to Flow Types in PA2DIS_FLOWTYPEUpdate Typenvarchar80
21PFAIM_UMATCH_TRLAssignment of Flow Types to PA Flow Types2DIS_FLOWTYPEUpdate Typenvarchar80
TOPTransaction Management
22TIDX_INDEX_DFLOWRelation Between the Indexes and the Distribution Flow Type3DIS_FLOWTYPEUpdate Typenvarchar80
TOPTransaction Manager
23AT210Rules for Determining a Taxes for CFM postings7DIS_FLOWTYPEUpdate Typenvarchar80
24ATFTACFM: Assign Transaction Flow Type to Update Type5DIS_FLOWTYPEUpdate Typenvarchar80
25ATFTA_MIGRMigration: Assignment of Flow Type to Update Type2DIS_FLOWTYPEUpdate Typenvarchar80
26IDCFM_FRCR_DFT_MCFM: Update Types for Manual Posting2DIS_FLOWTYPEUpdate Typenvarchar80
27SLDT_FLOWSubledger Distributor Transactions6DIS_FLOWTYPEUpdate Typenvarchar80
28TRDC_DFLOWTYPEDefinition of Update Types2DIS_FLOWTYPEUpdate Typenvarchar80
29TRDC_DFLOWTYPE_TTreasury: Update Type Texts2DIS_FLOWTYPEUpdate Typenvarchar80
30TRDC_DFT_ASSIGNAssignment of Flow Types to Update Types2DIS_FLOWTYPEUpdate Typenvarchar80
31TRDT_FLOWPersistent distributor flows4DIS_FLOWTYPEUpdate Typenvarchar80
32TRGC_DFTSOURCASSAssign Update Types to Usages3DIS_FLOWTYPEUpdate Typenvarchar80
33TRGC_DF_QUANTCATPrel. Solution: Assignm.: Update Type - Pos.Mgmnt Cat. Units2DIS_FLOWTYPEUpdate Typenvarchar80
34TRGC_PAY_RELPayment Relevance of Update Type2DIS_FLOWTYPEUpdate Typenvarchar80
35TRGC_PL_ASGNFTYPAssignment of Profit/Loss Types to Flow Type2DIS_FLOWTYPEFlow Typenvarchar40
36TRGC_PL_ASSIGNAssign Profit/Loss Types to Update Type and Valuation Area3DIS_FLOWTYPEUpdate Typenvarchar80
37TRLT_VCL_FLOWFlows Valuation Class Transfer22DIS_FLOWTYPEUpdate Typenvarchar80
38TRQT_FLOWTreasury: Flow Data Quantity Ledger5DIS_FLOWTYPEUpdate Typenvarchar80
39TRQT_INIT_LOT(obsolete)11DIS_FLOWTYPEUpdate Typenvarchar80
40VWFL_FT_DECFM: Assign Update Type to Flow Type6DIS_FLOWTYPEUpdate Typenvarchar80
TOPTransfer to Financial Accounting
41TLVT_VAL_FLOWTreasury: Valuation Flow5DIS_FLOWTYPEUpdate Typenvarchar80
42TRACC_DFT_RELPosting Relevant Update Types2DIS_FLOWTYPEUpdate Typenvarchar80
43TRACC_MIG_ACCDETTable for Migration of Account Determination8DIS_FLOWTYPEUpdate Typenvarchar80
44TRACT_ACCITEMAccounting Items5DIS_FLOWTYPEUpdate Typenvarchar80
45TRAC_DFTRULE1Treasury: Assignment of Update Type to Posting Specs2DIS_FLOWTYPEUpdate Typenvarchar80
46TRAC_DFTRULE2Treasury: Assgmt of Update Type to Post. Specs per Valn Area2DIS_FLOWTYPEUpdate Typenvarchar80
47TRATT_FLOWTransfer Flows4DIS_FLOWTYPEUpdate Typenvarchar80
48TRILT_DFLOWDerived Flows in the Income Ledger4DIS_FLOWTYPEUpdate Typenvarchar80
49TRLAC_DFT_PMCAssignment of Update Type to Position Change Category Value2DIS_FLOWTYPEUpdate Typenvarchar80
TOPTreasury and Risk Management
50TREAT_EXT_ACC_PMTreasury: External Account Payment Details6DIS_FLOWTYPEUpdate Typenvarchar80
51TREAT_FLOWTreasury: TREA Flows11DIS_FLOWTYPEUpdate Typenvarchar80