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

126 tablesERP 6.0 

Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transaction Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0AT2621Non Deliverable CurrenciesTransaction Management
2ERP EHP76.0AT81M131Assignment Table: SWIFT Code of Sender -> Business PartnerTransaction Management
3ERP EHP76.0ATALRT71Treasury: Alert Category AssignmentTransaction Management
4ERP EHP76.0ATARCHIVE0031Archiving: Minimum retention period per company codeTransaction Management
5ERP EHP76.0ATARCHIVE0131Archiving: Minimum retention period of transaction in systemTransaction Management
6ERP EHP76.0ATFWDUL51Assignment of Underlying to TransactionTransaction Management
7ERP EHP76.0ATRELE151Transaction release: Release procedureTransaction Management
8ERP EHP76.0ATRELE291Transaction release: Release procedure for detail parametersTransaction Management
9ERP EHP76.0FTR_AVG_RATE132Average RatesTransaction Management
10ERP EHP76.0FTR_AVG_SCHEDULE101Schedule with RatesTransaction Management
11ERP EHP76.0FTR_CRDT_DEF41Definition of Line of CreditTransaction Management
12ERP EHP76.0FTR_CRDT_DEF_T41Definition of Line of CreditTransaction Management
13ERP EHP76.0FTR_TIER_DEF31Definition of RankTransaction Management
14ERP EHP76.0FTR_TIER_DEF_T51Description of RankTransaction Management
15ERP EHP76.0FTR_TIER_LEVEL71Tier LevelTransaction Management
16ERP EHP76.0TCHT_HD_BEWEG_CF331SFGDT FGET Cashflows TableTransaction Management
17ERP EHP76.0TCHT_HD_BEWEG_CY131SFGDT Commodity Flows TableTransaction Management
18ERP EHP76.0TCHT_HD_COND231Instrument ConditionsTransaction Management
19ERP EHP76.0TCHT_HD_COND_FOR81Instrument Condition FormulaTransaction Management
20ERP EHP76.0TCHT_HD_FGET311SFGDT FGET StructureTransaction Management
21ERP EHP76.0TCHT_HD_OPTION251SFGDT FGET Option StructureTransaction Management
22ERP EHP76.0TCHT_HD_SFGDT342SFGDT Representation of InstrumentsTransaction Management
23ERP EHP76.0THXC_FLOWTYPE91Treasury: Update types based on a Product TypeTransaction Management
24ERP EHP76.0THXC_HINST_PTYPE61Hedge scenerio : List of product types allowedTransaction Management
25ERP EHP76.0THXC_HITEM_PTYPE61Hedge scenerio : List of product types allowedTransaction Management
26ERP EHP76.0THXC_HR_CLASS21Classes of Hedging RelationshipsTransaction Management
27ERP EHP76.0THXC_HR_CLASS_T41Classes of hedging relationsshipsTransaction Management
28ERP EHP76.0THXC_HR_PROFL141Profile of hedging relationshipsTransaction Management
29ERP EHP76.0THXC_HR_PROFL_T41descriptions for profiles of hedging relationsshipsTransaction Management
30ERP EHP76.0THXC_NR_RNG_ASS71Number Ranges Assignment for P-Hedge AccountingTransaction Management
31ERP EHP76.0THXEC_CRIT_TERM31Effectiveness Test Critical Term(Obsolete)Transaction Management
32ERP EHP76.0THXEC_CRIT_TYPE171Effectiveness Test Critical Term TypeTransaction Management
33ERP EHP76.0THXEC_CRIT_TYP_T41Effectiveness Test Critical Term TypeTransaction Management
34ERP EHP76.0THXEC_EFFCONDTY21Effectiveness Condition TypeTransaction Management
35ERP EHP76.0THXEC_EFFCONDY_T41Effectiveness Condition Type Text TableTransaction Management
36ERP EHP76.0THXEC_EFF_CONDS71To capture the Effectiveness ConditionsTransaction Management
37ERP EHP76.0THXEC_EFF_TMET331Effectiveness Test Method DefinitionTransaction Management
38ERP EHP76.0THXEC_EFF_TMET_T41Effectiveness Test Method Definition text tableTransaction Management
39ERP EHP76.0THXETS_EFF_TCA11Effectiveness test method categoryTransaction Management
40ERP EHP76.0THXETS_EFF_TCA_T31Effectiveness test method category text tableTransaction Management
41ERP EHP76.0THXETS_HDG_CCT21Hedge Effectiveness: Current value calculation categoryTransaction Management
42ERP EHP76.0THXETS_HDG_CCT_T31Hedge Effectiveness: Current value calculation categoryTransaction Management
43ERP EHP76.0THXET_ITEM_BP132Effectiveness Test: Results per HItem & HInstr.Transaction Management
44ERP EHP76.0THXET_MEAS_EFFRT161Effectiveness Test: Hedge Ratio Results.Transaction Management
45ERP EHP76.0THXET_MEAS_HEAD253Effectiveness Test ResultsTransaction Management
46ERP EHP76.0THXET_MEAS_ITEM122Effectiveness Test: Results per HItem & HInstr.Transaction Management
47ERP EHP76.0THXET_MEAS_LOG31Effectiveness Test Detailed LogTransaction Management
48ERP EHP76.0THXET_MEAS_USER42Users of the Effectiveness TestTransaction Management
49ERP EHP76.0THXTS_HDG_SCEN101Hedge Relationship scenerioTransaction Management
50ERP EHP76.0THXTS_HDG_SCEN_T31Hedge Relationship scenerioTransaction Management
51ERP EHP76.0THXTS_HINST_PCAT31Hedge Scenerio : List of product categories allowedTransaction Management
52ERP EHP76.0THXTS_HITEM_PCAT31Hedge scenerio : List of product categories allowedTransaction Management
53ERP EHP76.0THXT_GROUP1_VAL21Table for values of grouping 1Transaction Management
54ERP EHP76.0THXT_GROUP2_VAL21Table for values of grouping 1Transaction Management
55ERP EHP76.0THXT_GROUP_CUST31Customizing for Hedge Relationship GroupingsTransaction Management
56ERP EHP76.0THXT_GROUP_CUSTT41Text Customizing for Hedge Relationship GroupingsTransaction Management
57ERP EHP76.0THXT_HDOC112DB table for storing the Hedge Documentation.Transaction Management
58ERP EHP76.0THXT_HDOC_DMS71Storing the hedge documentation documentsTransaction Management
59ERP EHP76.0THXT_HINST113Hedge InstrumentTransaction Management
60ERP EHP76.0THXT_HITEM173Hedge Item DB tableTransaction Management
61ERP EHP76.0THXT_HREL242Hedging RelationshipTransaction Management
62ERP EHP76.0THXT_HR_FLOWS141Treasury: Hedging Relationship FlowsTransaction Management
63ERP EHP76.0THXT_HR_TESTPLAN131Hedging - Effectivity Test PlanTransaction Management
64ERP EHP76.0THXT_HR_TRANS103Treasury: Hedging Relationship TransactionsTransaction Management
65ERP EHP76.0THXT_MD_ET_INTR41market data reference interest rateTransaction Management
66ERP EHP76.0THXT_MD_ET_YC41market data yield curve typeTransaction Management
67ERP EHP76.0THXT_MD_HEADER32market data: header informationTransaction Management
68ERP EHP76.0THXT_MD_HRPARAMS41Market Data: Hedge related parametersTransaction Management
69ERP EHP76.0THXT_MD_INTR41market data reference interest rateTransaction Management
70ERP EHP76.0THXT_MD_PV171market data present valueTransaction Management
71ERP EHP76.0THXT_MD_SEC61market data securities priceTransaction Management
72ERP EHP76.0THXT_MD_YC41market data yield curve typeTransaction Management
73ERP EHP76.0TIDX_FLOW_CAT21Treasury: Flow Categories for Price IndexesTransaction Management
74ERP EHP76.0TIDX_FM_FLOW_CAT11Treasury: Calc. Categories of Cash Flow Calculator for PITransaction Management
75ERP EHP76.0TIDX_INDEX_DFLOW41Relation Between the Indexes and the Distribution Flow TypeTransaction Management
76ERP EHP76.0TIDX_INDEX_FLOW51Relation Between the Indexes and the FlowsTransaction Management
77ERP EHP76.0TIDX_INDEX_FLOWC51Relation Between the Indexes and the FlowsTransaction Management
78ERP EHP76.0TIDX_PRICE_INDEX81Price Index Main EntityTransaction Management
79ERP EHP76.0TIDX_PRICE_VALUE41Values for the IndexTransaction Management
80ERP EHP76.0TPM_SECACC_GRD253Zuordnung Geschäft Depot-BestandssperreTransaction Management
81ERP EHP76.0TPM_SECACC_GUARD32Assign Transaction - Securities Acct BlockTransaction Management
82ERP EHP76.0TRCPAT231TR: Commodity Price Adjustment-Registration and FixingTransaction Management
83ERP EHP76.0TRIAT152Treasury: Int.Rate Adjust. - Registration and Int.Rate Adj.Transaction Management
84ERP EHP76.0TRIGC_COMPANY_ID21Customizing view for Dummy Company IDTransaction Management
85ERP EHP76.0TRIGC_IGI_PC61IGT - Product Cats of the Parallel Valn Areas to be IncludedTransaction Management
86ERP EHP76.0TRIGC_IGI_PT71IGT - ProdCat / ProdType in Valn Areas to be IncludedTransaction Management
87ERP EHP76.0TRSPAT171TR: Security Price Adjustment - Registration and FixingTransaction Management
88ERP EHP76.0VTBAT_PROCESS11Transaction ProcessesTransaction Management
89ERP EHP76.0VTBAT_PROCESS_TX31Transaction ProcessesTransaction Management
90ERP EHP76.0VTBCSPREAD61Credit Spread per OTC TransactionTransaction Management
91ERP EHP76.0VTBMARGIN51Int. FX: Rate Markups or Markdowns per Currency PairTransaction Management
92ERP EHP76.0VTBMDEX71CFM: Mirror Transaction - Initial TableTransaction Management
93ERP EHP76.0VTBMDIN61CFM: Mirror Trans.- Incoming Mapping Log. System CounterprtyTransaction Management
94ERP EHP76.0VTBMDINFKT91CFM: Mirror Transaction Mapping FunctionsTransaction Management
95ERP EHP76.0VTBMDLS51CFM: Mirror Transaction - Assign Partner - Logical SystemTransaction Management
96ERP EHP76.0VTBMDMAP71CFM: Mirror Transaction - Map PType/TType in Meta NameTransaction Management
97ERP EHP76.0VTBMDMAPFLW51CFM: Mirror Transaction - Map FlowsTransaction Management
98ERP EHP76.0VTBMDMAPKOND51CFM: Mirror Transaction - Map ConditionsTransaction Management
99ERP EHP76.0VTBMDPARTNER31CFM: Mirror Trans.- Unique Assignment of Partner - CoCdTransaction Management
100ERP EHP76.0VTBPA121Fin. Transaction: Assignment of Further Business PartnersTransaction Management
101ERP EHP76.0VTBRATING61Rating for Financial TransactionTransaction Management
102ERP EHP76.0VTBRELE1111Transaction release: Change historyTransaction Management
103ERP EHP76.0VTB_ASGN_LIMIT71FTR Assignment Mgmt: Limit Profile of Assignment ObjectTransaction Management
104ERP EHP76.0VTB_ASGN_POS91FTR Assignment Management: Assigned Position ChangesTransaction Management
105ERP EHP76.0VTB_ASGN_POSOBJ71FTR Assignment Management: Assigned Position ObjectsTransaction Management
106ERP EHP76.0VTB_ASGN_RELAT122FTR Assignment Management: Assignment ObjectTransaction Management
107ERP EHP76.0VTB_FMOD_BASIC61Field Modification ValuesTransaction Management
108ERP EHP76.0VTB_FMOD_FTR121Field Modification DefinitionTransaction Management
109ERP EHP76.0VTB_FMOD_PROCESS61BDT Field Grouping per Activity CategoryTransaction Management
110ERP EHP76.0VTB_FMOD_SFGZUST101Field Modification at Activity Category LevelTransaction Management
111ERP EHP76.0VTB_FMOD_SFHAART71Field Modification ValuesTransaction Management
112ERP EHP76.0VTB_FMOD_SFUNKTL101Field Modification ValuesTransaction Management
113ERP EHP76.0VTB_FX_WEB_QUOTE341FX Quotes for Transfer as TransactionTransaction Management
114ERP EHP76.0VTB_PCAT_FMOD61BDT Field Modification per Product CategoryTransaction Management
115ERP EHP76.0VTB_RULESET71FTR Rule Management: RuleTransaction Management
116ERP EHP76.0VTB_RULESET_CC41FTR Rule Management: Company Code RulesTransaction Management
117ERP EHP76.0VTB_RULESET_CR41FTR Rule Management: Transaction Currency RulesTransaction Management
118ERP EHP76.0VTB_RULESET_PA51FTR Rule Management: Business Partner RulesTransaction Management
119ERP EHP76.0VTB_RULESET_TT71FTR Rule Management: Transaction Type RulesTransaction Management
120ERP EHP76.0VTB_WEB_ORGA51FTR Web: Organization Mapping to ServiceTransaction Management
121ERP EHP76.0VTB_WEB_QUOTES192FX Quotes ReceivedTransaction Management
122ERP EHP76.0VTB_WEB_SERVICE41Define Web Service and Link to Business ConnectorTransaction Management
123ERP EHP76.0VTB_WEB_SERV_URL31FTR Web: Service DeclarationTransaction Management
124ERP EHP76.0VTB_WEB_SUSER51FTR Web: Service UsersTransaction Management
125ERP EHP76.0VTB_WEB_SUSERSAP41FTR Web: Service UsersTransaction Management
126ERP EHP76.0VTB_WEB_URLS51FTR Web: Service URLsTransaction Management