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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

136 tablesERP 6.0 

Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ADJTC_DFT_ASSIGN21Update Types for Position ReconciliationTransfer to Financial Accounting
2ERP EHP76.0ADJT_TRANSACTION111Treasury: Reconciliation business transactionsTransfer to Financial Accounting
3ERP EHP76.0BCKTLVT_VAL_FLOW92Backup: Treasury: Valuation FlowTransfer to Financial Accounting
4ERP EHP76.0BCKTRACT_ACCITEM61Treasury: Accounting ItemsTransfer to Financial Accounting
5ERP EHP76.0BCKTRLT_DERIVFLO132Treasury: Flows for Derived Business TransactionsTransfer to Financial Accounting
6ERP EHP76.0BCKTRLT_FLOW143Treasury Ledger FlowsTransfer to Financial Accounting
7ERP EHP76.0BCKTRLT_POSITION62Backup: Treasury Ledger PositionTransfer to Financial Accounting
8ERP EHP76.0BCKTRLT_SUBPOSIT62Backup: Treasury Ledger PositionTransfer to Financial Accounting
9ERP EHP76.0TLVC_DFT_ASSGN2741Assign Update Types for ValuationTransfer to Financial Accounting
10ERP EHP76.0TLVT_MANUAL_VAL191Book Values for Manual Valuation of PositionsTransfer to Financial Accounting
11ERP EHP76.0TLVT_VAL_FLOW211Treasury: Valuation FlowTransfer to Financial Accounting
12ERP EHP76.0TLVT_VAL_STEP281Treasury: Valuation StepTransfer to Financial Accounting
13ERP EHP76.0TLVT_VAL_STEPLOG41Treasury: Valuation Step Additional LogTransfer to Financial Accounting
14ERP EHP76.0TLVT_VAL_TRANS193Treasury: Valuation Business TransactionsTransfer to Financial Accounting
15ERP EHP76.0TRACC_AA_REF21Treasury: Account Assignment ReferenceTransfer to Financial Accounting
16ERP EHP76.0TRACC_AA_REF_T41Treasury: Text Table Account Assignment ReferenceTransfer to Financial Accounting
17ERP EHP76.0TRACC_ACCASSREF151OLD: TR: Account Assignment Ref. Allocation Old->NewTransfer to Financial Accounting
18ERP EHP76.0TRACC_ACCSYMBREP71Acct Determination: Replacement of Acct Symbols by G/L AcctsTransfer to Financial Accounting
19ERP EHP76.0TRACC_ADDACCDATA61Additional Acct Assignments Dependent on Acct Assignm. Ref.Transfer to Financial Accounting
20ERP EHP76.0TRACC_DFT_REL41Posting Relevant Update TypesTransfer to Financial Accounting
21ERP EHP76.0TRACC_GROUP31Definition of Grouping Characteristic ValuesTransfer to Financial Accounting
22ERP EHP76.0TRACC_GROUP_T51Description of Grouping Characteristic ValuesTransfer to Financial Accounting
23ERP EHP76.0TRACC_MIG_AAREF51Migration of Definitions of Account Assignment ReferencesTransfer to Financial Accounting
24ERP EHP76.0TRACC_MIG_ACCDET91Table for Migration of Account DeterminationTransfer to Financial Accounting
25ERP EHP76.0TRACC_OPTIONS31Treasury: Options for the Accounting AdaptorTransfer to Financial Accounting
26ERP EHP76.0TRACC_POST_REL51Exclude Product Types from PostingTransfer to Financial Accounting
27ERP EHP76.0TRACTSLA376Actual Line Item TableTransfer to Financial Accounting
28ERP EHP76.0TRACTSLC32Object Table 2Transfer to Financial Accounting
29ERP EHP76.0TRACTSLO82Object Table 1Transfer to Financial Accounting
30ERP EHP76.0TRACTSLP1175Plan Line Items TableTransfer to Financial Accounting
31ERP EHP76.0TRACTSLT1034Totals TableTransfer to Financial Accounting
32ERP EHP76.0TRACT_ACCITEM442Accounting ItemsTransfer to Financial Accounting
33ERP EHP76.0TRACT_DOCUMENT344Treasury: Accounting Adaptor DocumentTransfer to Financial Accounting
34ERP EHP76.0TRACT_POSCONTEXT112Treasury: Position Context TableTransfer to Financial Accounting
35ERP EHP76.0TRACT_QUEUE121Resubmission for ReversalTransfer to Financial Accounting
36ERP EHP76.0TRAC_ACCASSREF31OLD: Valuation Area-Dependent Account Assignment RefsTransfer to Financial Accounting
37ERP EHP76.0TRAC_ACCASSREF_T51OLD: Text Table for Account Assignment ReferencesTransfer to Financial Accounting
38ERP EHP76.0TRAC_ACCSYMB31Account Determination: Account SymbolsTransfer to Financial Accounting
39ERP EHP76.0TRAC_ACCSYMBREP151OLD: Prelim. Solution for Acct Det.: Acct Symbol ReplacementTransfer to Financial Accounting
40ERP EHP76.0TRAC_ACCSYMBREP271OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref.Transfer to Financial Accounting
41ERP EHP76.0TRAC_ACCSYMB_INI31Alternative Acct Symbols for OTC Transaction InitializationTransfer to Financial Accounting
42ERP EHP76.0TRAC_ACCSYMB_T41Treasury Account Determination: Text Table for Acct SymbolsTransfer to Financial Accounting
43ERP EHP76.0TRAC_DFTRULE141Treasury: Assignment of Update Type to Posting SpecsTransfer to Financial Accounting
44ERP EHP76.0TRAC_DFTRULE251Treasury: Assgmt of Update Type to Post. Specs per Valn AreaTransfer to Financial Accounting
45ERP EHP76.0TRAC_POSTRULE71Treasury Account Determination: Posting SpecificationsTransfer to Financial Accounting
46ERP EHP76.0TRAC_POSTRULE_T41Treasury Account Determination: Text Table Posting SpecsTransfer to Financial Accounting
47ERP EHP76.0TRATC_DFTASS61Update Types for Account Assignment Reference TransferTransfer to Financial Accounting
48ERP EHP76.0TRATT_FLOW112Transfer FlowsTransfer to Financial Accounting
49ERP EHP76.0TRATT_TRANS113Account Assignment Reference Transfer Business TransactionsTransfer to Financial Accounting
50ERP EHP76.0TRGC_STEP_PROC561Procedure for StepsTransfer to Financial Accounting
51ERP EHP76.0TRGC_STEP_PROC_T51Step Procedure TextsTransfer to Financial Accounting
52ERP EHP76.0TRGC_ZATTRIB31Custom Settings for Valuation StepsTransfer to Financial Accounting
53ERP EHP76.0TRGC_ZATTRIB_T51Texts for Custom Settings for Valuation StepsTransfer to Financial Accounting
54ERP EHP76.0TRGTS_STEPDEF11Treasury: Step Categories in Position ManagementTransfer to Financial Accounting
55ERP EHP76.0TRGTS_STEPDEF_T31Treasury: Description of Step CategoriesTransfer to Financial Accounting
56ERP EHP76.0TRGTS_STEPS21Treasury: Permitted Steps per Position Management CategoryTransfer to Financial Accounting
57ERP EHP76.0TRGT_MIGR1152Management Table for CFM Conversion (Custom. Steps)Transfer to Financial Accounting
58ERP EHP76.0TRILC_DFT_ASSGN591Assignment of Update Types for Hedge AccountingTransfer to Financial Accounting
59ERP EHP76.0TRILT_DFLOW112Derived Flows in the Income LedgerTransfer to Financial Accounting
60ERP EHP76.0TRILT_DTRANS174Derived Business Transactions in the Income LedgerTransfer to Financial Accounting
61ERP EHP76.0TRLAC_DFT_PMC51Assignment of Update Type to Position Change Category ValueTransfer to Financial Accounting
62ERP EHP76.0TRLC_CT_INIT21Treasury: Contract Types in Parallel Valuation AreasTransfer to Financial Accounting
63ERP EHP76.0TRLC_DFT_ASSGN_A181Assignment: Update Types to Position Change Category ATransfer to Financial Accounting
64ERP EHP76.0TRLC_DFT_ASSGN_B261Assignment: Update Types to Position Change Category BTransfer to Financial Accounting
65ERP EHP76.0TRLC_DFT_ASSGN_C321Assignment: Update Types to Position Change Category CTransfer to Financial Accounting
66ERP EHP76.0TRLC_DFT_ASSGN_D2101Assignment: Update Types to Position Change Category DTransfer to Financial Accounting
67ERP EHP76.0TRLC_DFT_ASSGN_E1101Assignment: Update Types to Position Change Category ETransfer to Financial Accounting
68ERP EHP76.0TRLC_DFT_ASSGN_F821Assignment: Update Types to Position Change Category FTransfer to Financial Accounting
69ERP EHP76.0TRLC_DFT_ASSGN_G1161Assignment: Update Types to Position Change Category GTransfer to Financial Accounting
70ERP EHP76.0TRLC_DFT_ASSGN_H141Assignment: Update Types to Position Man. Procedure Cat. HTransfer to Financial Accounting
71ERP EHP76.0TRLC_DFT_ASSGN_J661Assign Update Types to Position Management Category JTransfer to Financial Accounting
72ERP EHP76.0TRLC_DFT_ASSGN_K81Assignment: Update Types for Position Change Category KTransfer to Financial Accounting
73ERP EHP76.0TRLC_DFT_ASSGN_L561Assignment: Update Types for Position Change Category LTransfer to Financial Accounting
74ERP EHP76.0TRLC_DFT_ASSGN_M1751Assignment: Update Types for Position Change Category MTransfer to Financial Accounting
75ERP EHP76.0TRLC_DFT_ASSGN_V41Assignment: Update Types to Position Management Category VTransfer to Financial Accounting
76ERP EHP76.0TRLC_IFT_ASSGN1321Assign Update Types for Initializing PositionsTransfer to Financial Accounting
77ERP EHP76.0TRLC_PC_INIT31Treasury: Product Cats in the Parallel Valuation ClassesTransfer to Financial Accounting
78ERP EHP76.0TRLTC_ATTRVAL_M31medium attribute valuesTransfer to Financial Accounting
79ERP EHP76.0TRLTC_ATTRVAL_MT51medium attribute valuesTransfer to Financial Accounting
80ERP EHP76.0TRLTC_ATTRVAL_S31short attribute valuesTransfer to Financial Accounting
81ERP EHP76.0TRLTC_ATTRVAL_ST51short attribute valuesTransfer to Financial Accounting
82ERP EHP76.0TRLTC_POSATT_DEF21position attributesTransfer to Financial Accounting
83ERP EHP76.0TRLTC_POSATT_D_T61position attributesTransfer to Financial Accounting
84ERP EHP76.0TRLTS_DCAT_PCAT21Treasury: Asst of Derivation Method to Pos. Management Cat.Transfer to Financial Accounting
85ERP EHP76.0TRLTS_DERIVDEF51Position Management Category (Definition)Transfer to Financial Accounting
86ERP EHP76.0TRLTS_DERIVDEF_T31Position Management Category (Text)Transfer to Financial Accounting
87ERP EHP76.0TRLTS_DERIV_CAT31Treasury: Asst of Derivation Method to Pos. Management Cat.Transfer to Financial Accounting
88ERP EHP76.0TRLTS_DERIV_REL21Treasury: Relevant BT Categories per Derivation MethodTransfer to Financial Accounting
89ERP EHP76.0TRLTS_INIT_COMP61Mapping of Position Components to Treasury LedgerTransfer to Financial Accounting
90ERP EHP76.0TRLTS_PMCAT51Position Change CategoryTransfer to Financial Accounting
91ERP EHP76.0TRLTS_PMCAT_T31Position Change Category (Text)Transfer to Financial Accounting
92ERP EHP76.0TRLTS_STATE_T41Texts for TRL Posting StatusTransfer to Financial Accounting
93ERP EHP76.0TRLT_BACKUPVORAB651Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol.Transfer to Financial Accounting
94ERP EHP76.0TRLT_DERIVFLOWS292Treasury: Flows for Derived Business TransactionsTransfer to Financial Accounting
95ERP EHP76.0TRLT_DERIVTRANS133Derived Business TransactionsTransfer to Financial Accounting
96ERP EHP76.0TRLT_DOCUMENT81Treasury Ledger DocumentsTransfer to Financial Accounting
97ERP EHP76.0TRLT_FBP_CMP_VAL161Flow Backpack Values for Each Component and SubpositionTransfer to Financial Accounting
98ERP EHP76.0TRLT_FIXINGSUM83TR Ledger Transaction FiguresTransfer to Financial Accounting
99ERP EHP76.0TRLT_FLOW382Treasury Ledger FlowsTransfer to Financial Accounting
100ERP EHP76.0TRLT_FLOWBCKPACK52Flow BackpackTransfer to Financial Accounting
101ERP EHP76.0TRLT_FS_COMP121TR Ledger: Transaction Figures per ComponentTransfer to Financial Accounting
102ERP EHP76.0TRLT_FS_SUB_COMP131Transaction Figures for Each Component and SubpositionTransfer to Financial Accounting
103ERP EHP76.0TRLT_INITIALIZE141Management Data for Initialization of Treasury LedgerTransfer to Financial Accounting
104ERP EHP76.0TRLT_INITSTEP321Function Modules of Treasury Ledger Initialization Step 3Transfer to Financial Accounting
105ERP EHP76.0TRLT_INIT_DES131Init.Hedging Relationship: Bus.Trans.Mgmt, DesignationTransfer to Financial Accounting
106ERP EHP76.0TRLT_INIT_IGT_SE273Initialization Values for Intragroup TransactionsTransfer to Financial Accounting
107ERP EHP76.0TRLT_INIT_POS51Admin. Table: (Obsolete as from Support Package 01)Transfer to Financial Accounting
108ERP EHP76.0TRLT_INIT_SUB_OT561Init.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos.Transfer to Financial Accounting
109ERP EHP76.0TRLT_INIT_SUB_SE781Init.Hedging Relationship for Securities with SubpositionsTransfer to Financial Accounting
110ERP EHP76.0TRLT_INIT_SUB_TR162Init.Hedging Rel.: Bus.Trans.Mgmnt, Designation SubpositionsTransfer to Financial Accounting
111ERP EHP76.0TRLT_INIT_TRANS132List of Initializing Business TransactionsTransfer to Financial Accounting
112ERP EHP76.0TRLT_INIT_VAL_FU252Initialization Values for TRL Futures PositionsTransfer to Financial Accounting
113ERP EHP76.0TRLT_INIT_VAL_HR101Init.Hedging Rel.:Mapping to Hedging Rel.in New Company CodeTransfer to Financial Accounting
114ERP EHP76.0TRLT_INIT_VAL_LO424Initialization Values for TRL Positions: LoansTransfer to Financial Accounting
115ERP EHP76.0TRLT_INIT_VAL_SE953Initialization Values for TRL Positions: SecuritiesTransfer to Financial Accounting
116ERP EHP76.0TRLT_LOCK104Treasury Ledger Position LockTransfer to Financial Accounting
117ERP EHP76.0TRLT_NEW_POS41Treasury: New Initialization or Transfer PositionsTransfer to Financial Accounting
118ERP EHP76.0TRLT_POSITION213Treasury Ledger PositionTransfer to Financial Accounting
119ERP EHP76.0TRLT_POS_ATTRIB111additional attributes of TRL-positionsTransfer to Financial Accounting
120ERP EHP76.0TRLT_SUBPOSITION114Treasury Ledger: SubpositionTransfer to Financial Accounting
121ERP EHP76.0TRLT_TRANSACTION265Treasury Ledger Business TransactionsTransfer to Financial Accounting
122ERP EHP76.0TRL_C_FT_REPLACE51Replacement of Update TypesTransfer to Financial Accounting
123ERP EHP76.0TRPRT_PAYMENTS584Persistent Data for Payment RequestsTransfer to Financial Accounting
124ERP EHP76.0TRSET_BUSTRANS72OLD! Preliminary Solution: Transferred Sec. Bus.TransactionsTransfer to Financial Accounting
125ERP EHP76.0TRSET_FLOW72OLD: Prelim. Solution: Transferred Security FlowsTransfer to Financial Accounting
126ERP EHP76.0TRSET_RUN_HEAD142OLD: Prelim. Solution: Transfer RunsTransfer to Financial Accounting
127ERP EHP76.0TRSET_RUN_POS131OLD: Preliminary Solution: Transfer Run ItemsTransfer to Financial Accounting
128ERP EHP76.0VALC_FORW_PROC111OLD! Rate Valuation Procedure: ForwardTransfer to Financial Accounting
129ERP EHP76.0VALC_FORW_PROC_T41OLD! TR: Texts for Rate Valuation Procedures - ForwardsTransfer to Financial Accounting
130ERP EHP76.0VALC_RPVALPROC_T41OLD! TR: Texts for Price Valuation ProceduresTransfer to Financial Accounting
131ERP EHP76.0VALC_RPVAL_PROC161OLD! TR: Definition - Price Valuation ProceduresTransfer to Financial Accounting
132ERP EHP76.0VALC_TIFE_PROC111OLD! Procedures for One-Step Price Valn, Sec. Valn, FX ValnTransfer to Financial Accounting
133ERP EHP76.0VALC_TIFE_PROC_T51OLD! Texts for One-Step Price Valn, Sec. Valn, FX ValuationTransfer to Financial Accounting
134ERP EHP76.0VALC_VAL_PROC51OLD! TR: Definition - Valuation ProcedureTransfer to Financial Accounting
135ERP EHP76.0VALC_VAL_PROC_T41OLD! TR: Texts for Valuation ProceduresTransfer to Financial Accounting
136ERP EHP76.0VALT_SP_VAL_SEC221Security Prices and NPV for Special ValuationTransfer to Financial Accounting