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

71 columns | Print definition?ERP 6.0  | POSITION_CURR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BCKTRLIT_AD_TRANAccrual/Deferral Business Transactions Backup8POSITION_CURRPosition Currencynvarchar50
2BCKTRLT_VCL_FLOWFlows Valuation Class Transfer9POSITION_CURRPosition Currencynvarchar50
3TREAT_CASH_POSTREA: Cash Position6POSITION_CURRPosition Currencynvarchar50
4TREAT_MLM_PRCLOGTreasury: Margin Limit Result Procedure Log8POSITION_CURRPosition Currencynvarchar50
5TREAT_MLM_RESULTTreasury: Margin Limit Result Entity8POSITION_CURRPosition Currencynvarchar50
TOPBack Office
6TRFB_CLASS_POSCFM: Backup Table for TRF Class Position4POSITION_CURRPosition Currencynvarchar50
7TRFB_FLOWCFM: Backup Table with TRF Flows4POSITION_CURRPosition Currencynvarchar50
8TRFB_SUBTOTALCFM: Backup Table with TRF Transaction Figures5POSITION_CURRPosition Currencynvarchar50
9TRFB_SUBTRANSCFM: Backup Table for TRF Business Subtransaction5POSITION_CURRPosition Currencynvarchar50
10TRFT_CLASS_POSTreasury: TRF Class Position6POSITION_CURRPosition Currencynvarchar50
11TRFT_FLOWTreasury: Table with TRF Flows10POSITION_CURRPosition Currencynvarchar50
12TRFT_MAN_PT_FLOWTRF: Flows for Manual Posting6POSITION_CURRPosition Currencynvarchar50
13TRFT_MATCH_FLOWTreasury: Table with Matching Process Flows10POSITION_CURRPosition Currencynvarchar50
14TRFT_SUBTOTALTreasury: Table with TRF Transaction Figure6POSITION_CURRPosition Currencynvarchar50
15TRFT_SUBTRANSTreasury: TRF Business Subtransaction8POSITION_CURRPosition Currencynvarchar50
16TRSB_CLASFLOCFM: Backup Table for Class Flows in Securities Account4POSITION_CURRPosition Currencynvarchar50
17TRSB_CLASFLO_REVCFM: Backup Table for Class Flows in Securities Account4POSITION_CURRPosition Currencynvarchar50
18TRSB_POSCHG_FLOWCFM: Backup Table for Flow Rel. to Change in Sec. Acct Pos.7POSITION_CURRPosition Currencynvarchar50
19TRST_CLASFLOCFM: Class Flows in Securities Account17POSITION_CURRPosition Currencynvarchar50
20TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account17POSITION_CURRPosition Currencynvarchar50
21TRST_POSCHG_FLOWCFM: Flow for Securities Account Position Change8POSITION_CURRPosition Currencynvarchar50
TOPTransaction Manager
22BCKSLDT_FLOWBackup: Subledger Distributor: Trans. Before Issue Currency10POSITION_CURRPosition Currencynvarchar50
23BCKTCAT_FLOWBACKUP: Flow Table of Capital Actions16POSITION_CURRPosition Currencynvarchar50
24BCKTERT_FLOWBACKUP: Flow Table for Executable Rights18POSITION_CURRPosition Currencynvarchar50
25BCKTRDT_FLOWBackup: Distributor Flows Before Issue Currency Changeover8POSITION_CURRPosition Currencynvarchar50
26IDCFM_DATA_SECValuation-Area-Independent Data for Securities12POSITION_CURRPosition Currencynvarchar50
27SLDT_FLOWSubledger Distributor Transactions32POSITION_CURRPosition Currencynvarchar50
28TCAT_FLOWFlow Table of the Corporate Actions19POSITION_CURRPosition Currencynvarchar50
29TERT_FLOWFlow Table for Rights that can be Exercised40POSITION_CURRPosition Currencynvarchar50
30TRDTT_DATA_SECValuation-Area-Independent Data for Securities11POSITION_CURRPosition Currencynvarchar50
31TRDTT_IGTDATA_SEIntragroup Transaction (IGT) Data for Securities14POSITION_CURRPosition Currencynvarchar50
32TRDTT_VADATA_FUTValuation-Area-Dependent Data for Futures12POSITION_CURRPosition Currencynvarchar50
33TRDTT_VADATA_OTCValuation-Area-Dependent Data for MM, FX, OTC Derivatives.10POSITION_CURRPosition Currencynvarchar50
34TRDTT_VADATA_SECValuation-Area-Dependent Data for Securities12POSITION_CURRPosition Currencynvarchar50
35TRDTT_VAD_FUTSUBValuation Area-Dependent Data for Futures with Subpositions10POSITION_CURRPosition Currencynvarchar50
36TRDTT_VAD_OTCSUBVal.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos.10POSITION_CURRPosition Currencynvarchar50
37TRDTT_VAD_SECSUBValuation Area-Dependent Data for Securities w. Subpositions10POSITION_CURRPosition Currencynvarchar50
38TRDT_FLOWPersistent distributor flows30POSITION_CURRPosition Currencynvarchar50
39TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)18POSITION_CURRPosition Currencynvarchar50
40TRLT_VCL_FLOWFlows Valuation Class Transfer28POSITION_CURRPosition Currencynvarchar50
41TRQB_FLOWCFM: Backup Table for Flow Data in Quantity Ledger7POSITION_CURRPosition Currencynvarchar50
42TRQB_LOTFLOWCFM: Backup Table with Lot Flows7POSITION_CURRPosition Currencynvarchar50
43TRQT_FLOWTreasury: Flow Data Quantity Ledger11POSITION_CURRPosition Currencynvarchar50
44TRQT_LOTFLOWTreasury: Table with Lot Flows9POSITION_CURRPosition Currencynvarchar50
45TRXT_FLOWTRM Tax Transaction Flows12POSITION_CURRPosition Currencynvarchar50
TOPTransfer to Financial Accounting
46BCKTLVT_VAL_FLOWBackup: Treasury: Valuation Flow8POSITION_CURRPosition Currencynvarchar50
47BCKTRACT_ACCITEMTreasury: Accounting Items6POSITION_CURRTransaction Currencynvarchar50
48BCKTRLT_DERIVFLOTreasury: Flows for Derived Business Transactions10POSITION_CURRPosition Currencynvarchar50
49BCKTRLT_FLOWTreasury Ledger Flows13POSITION_CURRPosition Currencynvarchar50
50BCKTRLT_POSITIONBackup: Treasury Ledger Position6POSITION_CURRPosition Currencynvarchar50
51TLVT_MANUAL_VALBook Values for Manual Valuation of Positions17POSITION_CURRPosition Currencynvarchar50
52TLVT_VAL_FLOWTreasury: Valuation Flow8POSITION_CURRPosition Currencynvarchar50
53TLVT_VAL_STEPTreasury: Valuation Step13POSITION_CURRPosition Currencynvarchar50
54TRACT_ACCITEMAccounting Items13POSITION_CURRTransaction Currencynvarchar50
55TRAC_ACCSYMBREP2OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref.6POSITION_CURRPosition Currencynvarchar50
56TRILT_DFLOWDerived Flows in the Income Ledger7POSITION_CURRPosition Currencynvarchar50
57TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.21POSITION_CURRPosition Currencynvarchar50
58TRLT_DERIVFLOWSTreasury: Flows for Derived Business Transactions13POSITION_CURRPosition Currencynvarchar50
59TRLT_FBP_CMP_VALFlow Backpack Values for Each Component and Subposition9POSITION_CURRPosition Currencynvarchar50
60TRLT_FLOWTreasury Ledger Flows17POSITION_CURRPosition Currencynvarchar50
61TRLT_FS_COMPTR Ledger: Transaction Figures per Component8POSITION_CURRPosition Currencynvarchar50
62TRLT_FS_SUB_COMPTransaction Figures for Each Component and Subposition9POSITION_CURRPosition Currencynvarchar50
63TRLT_INIT_IGT_SEInitialization Values for Intragroup Transactions16POSITION_CURRPosition Currencynvarchar50
64TRLT_INIT_SUB_OTInit.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos.10POSITION_CURRPosition Currencynvarchar50
65TRLT_INIT_SUB_SEInit.Hedging Relationship for Securities with Subpositions10POSITION_CURRPosition Currencynvarchar50
66TRLT_INIT_VAL_FUInitialization Values for TRL Futures Positions11POSITION_CURRPosition Currencynvarchar50
67TRLT_INIT_VAL_LOInitialization Values for TRL Positions: Loans8POSITION_CURRPosition Currencynvarchar50
68TRLT_INIT_VAL_SEInitialization Values for TRL Positions: Securities14POSITION_CURRPosition Currencynvarchar50
69TRLT_POSITIONTreasury Ledger Position4POSITION_CURRPosition Currencynvarchar50
TOPTreasury and Risk Management
70TREAT_FLOWTreasury: TREA Flows24POSITION_CURRPosition Currencynvarchar50
71TREAT_SUBTOTAL_CTREA: Subtotal Components4POSITION_CURRPosition Currencynvarchar50