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

78 columns | Print definition?ERP 6.0  | RFHA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FTBCVA_GUID2KEYMapping table GUID - semantic key5RFHAFinancial Transactionnvarchar130
2TLRT_TARO_ADMTrade Repository Object Administrative Data5RFHAFinancial Transactionnvarchar130
3TLRT_TARO_PFIELDTrade Repository: Protected Fields5RFHAFinancial Transactionnvarchar130
4TLRT_TRADE_IDTrade Identifier for Financial Transactions4RFHAFinancial Transactionnvarchar130
5TRTM_CHG_PARTNERTreasury: Change partner4RFHAFinancial Transactionnvarchar130
TOPBasic Functions
6FDT1CMF Line Items for Forex, Money Market, Derivatives3RFHAFinancial Transactionnvarchar130
TOPInformation System
7FTI_MARKET_VALSReporting: Buffer Table for Market Values - Position Crcy2RFHAFinancial Transactionnvarchar130
8FTI_MARKET_VALSTReporting: Buffer Table for Market Values - Evaluation Crcy2RFHAFinancial Transactionnvarchar130
TOPLoans Management
9TTONFTVZZBEPPTest neue FIMA: VZZBEPP254RFHAFinanzgeschäftnvarchar130
10VDZVPayment Details for the Loan3RFHAContract Numbernvarchar130
TOPMarket Risk Analyzer
11VTVBARNPVs of OTC transactions4RFHAFinancial Transactionnvarchar130
TOPTransaction Data Pool
12JBDEUROIndicator Table for EURO Conversion (CC)9RFHAFinancial Transactionnvarchar130
13JBDGSCHIS-B: Transaction Master Data30RFHAFinancial Transactionnvarchar130
TOPTransaction Management
14FTR_AVG_RATEAverage Rates4RFHAFinancial Transactionnvarchar130
15TCHT_HD_SFGDTSFGDT Representation of Instruments11RFHAFinancial Transactionnvarchar130
16TPM_SECACC_GRD2Zuordnung Geschäft Depot-Bestandssperre4RFHAFinanzgeschäftnvarchar130
17VTBPAFin. Transaction: Assignment of Further Business Partners3RFHAFinancial Transactionnvarchar130
18VTBRATINGRating for Financial Transaction3RFHAFinancial Transactionnvarchar130
19VTBRELE1Transaction release: Change history3RFHAFinancial Transactionnvarchar130
TOPTransaction Manager
20BCKVTBFHAPOBackup: Transaction Flows3RFHAFinancial Transactionnvarchar130
21BCK_VTIFHAPOBackup for Currency Changeover of Bond Underlying2RFHAFinancial Transactionnvarchar130
22FTR_AVG_ASGNAssign one flow to many adjustments for average4RFHAFinancial Transactionnvarchar130
23IDCFMBRSETX_HSTHistory table for taxation3RFHAFinancial Transactionnvarchar130
24IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil4RFHAFinancial Transactionnvarchar130
25MIGT_EXCL1Transactions to be Excluded from Migration3RFHAFinancial Transactionnvarchar130
26OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions4RFHAFinancial Transactionnvarchar130
27OTC_CONV_FHAPOBackup Table for Financial Transaction Flows3RFHAFinancial Transactionnvarchar130
28OTC_CONV_FHAZUBackup Table for Financial Transaction Activities3RFHAFinancial Transactionnvarchar130
29OTC_CONV_FINKOBackup Table for Financial Transaction Conditions4RFHAFinancial Transactionnvarchar130
30OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions3RFHAFinancial Transactionnvarchar130
31OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows2RFHAFinancial Transactionnvarchar130
32OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions3RFHAFinancial Transactionnvarchar130
33TCAT_TRANSACTIONBusiness Transaction: Corporate Action28RFHAFinancial Transactionnvarchar130
34TCORT_CODDPDeal: Dividend Plan5RFHAFinancial Transactionnvarchar130
35TCORT_CODRPDeal: Rollover Plan5RFHAFinancial Transactionnvarchar130
36THAHRT_ASS_PROSPRetrospective effectiveness assessment result3RFHAFinancial Transactionnvarchar130
37THAHRT_EXT_RETROExternal Retrospective Assessment3RFHAFinancial Transactionnvarchar130
38THMEXT_PLANNERE-HA: Hedge Plan17RFHAFinancial Transactionnvarchar130
39THMHRT_ASS_RETRORetrospective effectiveness assessment result3RFHAFinancial Transactionnvarchar130
40THMHRT_CASH_FLOWCalculated cash flows for effectiveness3RFHAFinancial Transactionnvarchar130
41THMHRT_EXT_PROSExternal Prospective Assessment3RFHAFinancial Transactionnvarchar130
42THMHRT_HI_MEASFair value change of the hedge comp. in an effective hedge3RFHAFinancial Transactionnvarchar130
43THMHRT_HRHedge Relationship3RFHAFinancial Transactionnvarchar130
44THMHRT_HR_STRATEffectiveness strategy for the hedging relationship3RFHAFinancial Transactionnvarchar130
45THMHRT_HR_VALValuation details for the hedging relationship3RFHAFinancial Transactionnvarchar130
46THMHRT_MEASUREEffectiveness measurement result3RFHAFinancial Transactionnvarchar130
47TPMHRT_EXT_RETROExternal Retrospective Assessment3RFHAFinancial Transactionnvarchar130
48VTB2TRDLink Between Financial Transaction Flow and Distributor Flow3RFHAFinancial Transactionnvarchar130
49VTBAFINKOAlternative Conditions4RFHAFinancial Transactionnvarchar130
50VTBDIVIDENDDividend Data for Forward Securities Transaction3RFHAFinancial Transactionnvarchar130
51VTBFHATransaction3RFHAFinancial Transactionnvarchar130
52VTBFHAPOTransaction Flow3RFHAFinancial Transactionnvarchar130
53VTBFHAPO_MIGRMigrated Financial Flows3RFHAFinancial Transactionnvarchar130
54VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows3RFHAFinancial Transactionnvarchar130
55VTBFHAZUTransaction Activity3RFHAFinancial Transactionnvarchar130
56VTBFINKOTransaction Condition4RFHAFinancial Transactionnvarchar130
57VTBFKTLOGTreasury: Sequence of Functions for Activity Processing3RFHAFinancial Transactionnvarchar130
58VTBKORESCorrespondence Data3RFHAFinancial Transactionnvarchar130
59VTBPFHAPOTreasury: Flow Shells3RFHAFinancial Transactionnvarchar130
60VTBRATERate for Activity3RFHAFinancial Transactionnvarchar130
61VTBROLLOVERRollover Periods for Forward Securities Transactions3RFHAFinancial Transactionnvarchar130
62VTBSIZUHedge Allocation42RFHAFinancial Transactionnvarchar130
63VTBTEKALTreasury: Due Date Management6RFHAFinancial Transactionnvarchar130
64VTBZVPayment Details for Transaction3RFHAFinancial Transactionnvarchar130
65VTB_ADJUSTMENTFiduciary deposit adjustment flow3RFHAFinancial Transactionnvarchar130
66VTIAFINKOAlternative Conditions Underlying3RFHAFinancial Transactionnvarchar130
67VTIFHAUnderlying transaction2RFHAFinancial Transactionnvarchar130
68VTIFHAPOUnderlying transaction flows2RFHAFinancial Transactionnvarchar130
69VTIFHAZUUnderlying transaction status table2RFHAFinancial Transactionnvarchar130
70VTIFINKOUnderlying transaction conditions3RFHAFinancial Transactionnvarchar130
71VTIOFAdditional Option Data6RFHATransaction (underlying) if only onenvarchar130
72VTIOFZUAllocation of Option/Future to Underlying3RFHATransaction (underlying) if only onenvarchar130
73VWBEKITreasury Securities: Actual Flows - Header60RFHAFinancial Transactionnvarchar130
74VWBEPPTreasury Securities: Planned Flows161RFHAFinancial Transactionnvarchar130
75VWFL3Assign Transaction Number to Position Number3RFHAFinancial Transactionnvarchar130
76VWORDEOrder Data104RFHAFinancial Transactionnvarchar130
TOPTransfer to Financial Accounting
77TRILT_DTRANSDerived Business Transactions in the Income Ledger6RFHAFinancial Transactionnvarchar130
TOPTreasury
78FLQITEMT1_FCLiquidity Calculation: Forecast Line Items from TR Trans.3RFHAFinancial Transactionnvarchar130