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

49 columns | Print definition?ERP 6.0  | DEAL_NUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TLRT_THM_RES_POSThreshold Result Position Data4DEAL_NUMBERFinancial Transactionnvarchar130
2TRCCT_TRANSCurrency Changeover Transaction13DEAL_NUMBERFinancial Transactionnvarchar130
3TREAT_STATEM_ITMClearing Account Statement Detail9DEAL_NUMBERFinancial Transactionnvarchar130
TOPBack Office
4TRFT_MAN_POSTManual Posting15DEAL_NUMBERFinancial Transactionnvarchar130
TOPInformation System
5FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW12DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
TOPTransaction Management
6FTR_TIER_LEVELTier Level3DEAL_NUMBERFinancial Transactionnvarchar130
7THXT_MD_PVmarket data present value5DEAL_NUMBERFinancial Transactionnvarchar130
8VTBCSPREADCredit Spread per OTC Transaction3DEAL_NUMBERFinancial Transactionnvarchar130
9VTB_ASGN_RELATFTR Assignment Management: Assignment Object7DEAL_NUMBERFinancial Transactionnvarchar130
TOPTransaction Manager
10DIFT_POS_IDENTPersistent Flow Selectors21DEAL_NUMBERFinancial Transactionnvarchar130
11FDC1Cash Management Shadow table14DEAL_NUMBERFinancial Transactionnvarchar130
12POGT_POS_GUARDLock Objects35DEAL_NUMBERFinancial Transactionnvarchar130
13SLDT_FLOWSubledger Distributor Transactions20DEAL_NUMBERFinancial Transactionnvarchar130
14SLDT_TRANSACTIONSubledger Distributor Business Transactions25DEAL_NUMBERFinancial Transactionnvarchar130
15TCORT_CODCODeal: Conditions5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
16TCORT_CODCOFODeal: Condition's Formula6DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
17TCORT_CODCPADeal: Commodity Price Adjustment5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
18TCORT_CODFLDeal: Flows5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
19TCORT_CODIADeal: Interest Rate Adjustment5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
20TCORT_CODMDDeal: Main Data4DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
21TCORT_CODPIDeal: Payment Information5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
22TCORT_CODSRADeal: Security Rate Adjustment5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
23TCORT_CODULDeal: Underlying5DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
24TCORT_CODUL2Deal: 2nd Underlying6DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
25TCORT_CODUL2FLDeal: 2nd Underlying's Flows7DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
26TCORT_CODULCODeal : Underlying's Conditions6DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
27TCORT_CODULCOFODeal: Underlying's Formula7DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
28TCORT_CODULFLDeal: Underlying Flows6DEAL_NUMBERPosition-Generating Financial Transactionnvarchar130
29THAHRT_EFF_HEADEffectiveness test result header5DEAL_NUMBERFinancial Transactionnvarchar130
30TRDTT_DATA_ADMINLegacy Data Transfer Admin. Entries Business Transactions9DEAL_NUMBERFinancial Transactionnvarchar130
31TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities26DEAL_NUMBERFinancial Transactionnvarchar130
32TRDTT_POS_ADMINLegacy Data Transfer Admin. Entries Subledger Positions8DEAL_NUMBERFinancial Transactionnvarchar130
33TRDTT_VADATA_FUTValuation-Area-Dependent Data for Futures21DEAL_NUMBERFinancial Transactionnvarchar130
34TRDTT_VADATA_OTCValuation-Area-Dependent Data for MM, FX, OTC Derivatives.6DEAL_NUMBERFinancial Transactionnvarchar130
35TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities66DEAL_NUMBERFinancial Transactionnvarchar130
36TRDTT_VAD_FUTSUBValuation Area-Dependent Data for Futures with Subpositions17DEAL_NUMBERFinancial Transactionnvarchar130
37TRDTT_VAD_SECSUBValuation Area-Dependent Data for Securities w. Subpositions53DEAL_NUMBERFinancial Transactionnvarchar130
38TRDT_FLOWPersistent distributor flows18DEAL_NUMBERFinancial Transactionnvarchar130
39TRDT_TRDBUSTRANSTreasury: Persistent distributor business transaction26DEAL_NUMBERFinancial Transactionnvarchar130
40TRGT_KEY_ASSGNTable for Persistent Class CL_KEY_ASSIGNMENT_TRG4DEAL_NUMBERFinancial Transactionnvarchar130
41TRGT_MIGPS_OTCAssignment of PS Account Assignments to Transactions3DEAL_NUMBERFinancial Transactionnvarchar130
42TRLIT_AD_MIGRATEAccrual/Deferral: Log Data of Migration to EP 2:4DEAL_NUMBERFinancial Transactionnvarchar130
43TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)39DEAL_NUMBERFinancial Transactionnvarchar130
44TRLT_VCL_FLOWFlows Valuation Class Transfer26DEAL_NUMBERFinancial Transactionnvarchar130
45VWKMPOCorporate actions (items)18DEAL_NUMBERFinancial Transactionnvarchar130
TOPTransfer to Financial Accounting
46TLVT_MANUAL_VALBook Values for Manual Valuation of Positions12DEAL_NUMBERFinancial Transactionnvarchar130
47TRACT_DOCUMENTTreasury: Accounting Adaptor Document26DEAL_NUMBERFinancial Transactionnvarchar130
48TRACT_QUEUEResubmission for Reversal12DEAL_NUMBERFinancial Transactionnvarchar130
TOPTreasury and Risk Management
49TREAT_FHA_DIFFTreasury: TREA Differentiation for Deal Position4DEAL_NUMBERFinancial Transactionnvarchar130