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

63 columns | Print definition?ERP 6.0  | SFHAART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AT14Status Transfers3SFHAARTFinancial Transaction Typenvarchar30
2IDCFM_ICLTXFLDIRFlow Types for Tax Types with Sign5SFHAARTFinancial Transaction Typenvarchar30
3TLRC_TARO_TAR_ASAssignment of Trade Repository4SFHAARTFinancial Transaction Typenvarchar30
4TLRT_TARO_ADMTrade Repository Object Administrative Data15SFHAARTFinancial Transaction Typenvarchar30
5ZCMM_MTM_01MtM Persistency per Transaction67SFHAARTFinancial Transaction Typenvarchar30
TOPAssetLiability Management
6JBNIPLALM Non Interest Profit and Loss9SFHAARTFinancial Transaction Typenvarchar30
TOPBack Office
7TRIL_BWGARTOLD!!! Flow types for Hedge Accounting3SFHAARTFinancial Transaction Typenvarchar30
TOPBasic Functions
8AT85CMF - Generating pmnt advices (prod./trans.type)3SFHAARTFinancial Transaction Typenvarchar30
TOPBusiness Partner
9VTBSTA1Allocation of Payment Details as Standing Instructions8SFHAARTFinancial Transaction Typenvarchar30
10VTBSTA2Standing Instructions for Correspondence7SFHAARTFinancial Transaction Typenvarchar30
11VTBSTA3SI for Business Partner: Transaction Authorizations7SFHAARTFinancial Transaction Typenvarchar30
12VTBSTA4SI for Business Partner: Derived Flows7SFHAARTFinancial Transaction Typenvarchar30
TOPDefault Risk and Limit System
13KLEGZUAssignment of TR Product/Tran. Type to CL Default Risk Rule3SFHAARTFinancial Transaction Typenvarchar30
14KLLIMITEXCEEDEDManagement of Exceeded Limits per Product/Transaction Type6SFHAARTFinancial Transaction Typenvarchar30
15KLMAXLIMITLimit per Product Type/Transaction Type4SFHAARTFinancial Transaction Typenvarchar30
TOPRisk Analysis
16JBRSVABESTRM: Header Table SDTFT (Additional Info.) for Saved Datasets12SFHAARTFinancial Transaction Typenvarchar30
TOPTransaction Data Pool
17JBDFUNCDEAKTDeactivate Datapool Functions4SFHAARTFinancial Transaction Typenvarchar30
TOPTransaction Management
18ATALRTTreasury: Alert Category Assignment4SFHAARTFinancial Transaction Typenvarchar30
19ATRELE1Transaction release: Release procedure4SFHAARTFinancial Transaction Typenvarchar30
20ATRELE2Transaction release: Release procedure for detail parameters4SFHAARTFinancial Transaction Typenvarchar30
21TCHT_HD_SFGDTSFGDT Representation of Instruments32SFHAARTFinancial Transaction Typenvarchar30
22VTBMDEXCFM: Mirror Transaction - Initial Table4SFHAARTFinancial Transaction Typenvarchar30
23VTBMDINFKTCFM: Mirror Transaction Mapping Functions4SFHAARTFinancial Transaction Typenvarchar30
24VTBMDMAPCFM: Mirror Transaction - Map PType/TType in Meta Name4SFHAARTFinancial Transaction Typenvarchar30
25VTBMDMAPFLWCFM: Mirror Transaction - Map Flows3SFHAARTFinancial Transaction Typenvarchar30
26VTBMDMAPKONDCFM: Mirror Transaction - Map Conditions3SFHAARTFinancial Transaction Typenvarchar30
27VTB_FMOD_SFGZUSTField Modification at Activity Category Level5SFHAARTFinancial Transaction Typenvarchar30
28VTB_FMOD_SFHAARTField Modification Values5SFHAARTFinancial Transaction Typenvarchar30
29VTB_FMOD_SFUNKTLField Modification Values5SFHAARTFinancial Transaction Typenvarchar30
30VTB_RULESET_TTFTR Rule Management: Transaction Type Rules5SFHAARTFinancial Transaction Typenvarchar30
TOPTransaction Manager
31AT10Transaction Types3SFHAARTFinancial Transaction Typenvarchar30
32AT10BTreasury: Customizing for Valuation4SFHAARTFinancial Transaction Typenvarchar30
33AT10SSecurities3SFHAARTFinancial Transaction Typenvarchar30
34AT10TName of Transaction Type4SFHAARTFinancial Transaction Typenvarchar30
35AT10XForex Attributes for Transaction Types3SFHAARTFinancial Transaction Typenvarchar30
36AT11Allocation of Condition Types to Transaction Types3SFHAARTFinancial Transaction Typenvarchar30
37AT13Allocation of Flow Types to Transaction Types3SFHAARTFinancial Transaction Typenvarchar30
38AT13UFlow types for transfer posting for activity transition3SFHAARTFinancial Transaction Typenvarchar30
39AT16Treasury: Fixing Settings for Forex Transactions3SFHAARTFinancial Transaction Typenvarchar30
40AT16BTreasury: Settings for mirror transaction types5SFHAARTFinancial Transaction Typenvarchar30
41AT200Rules for Determining a Tax Indicator6SFHAARTFinancial Transaction Typenvarchar30
42AT210Rules for Determining a Taxes for CFM postings6SFHAARTFinancial Transaction Typenvarchar30
43AT80Treasury: Correspondence Control MM, FX, DE, SE4SFHAARTFinancial Transaction Typenvarchar30
44IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts6SFHAARTFinancial Transaction Typenvarchar30
45IDCFMFLOWCALCFlow calculation using condition technique4SFHAARTFinancial Transaction Typenvarchar30
46IDCFMFLOWCALCINFlow calculation using conditions: map CFM data to KOMK/KOMP4SFHAARTFinancial Transaction Typenvarchar30
47IDCFMFLOWCALCOUTFlow calc.using conditions:map KOMK/KOMP fields to flow data4SFHAARTFinancial Transaction Typenvarchar30
48IDCFM_ICLTXCALCIntercompany Loan Tax Calculation Method4SFHAARTFinancial Transaction Typenvarchar30
49IDCFM_ICLTXCATIntercompany Loan Tax Calculation Category4SFHAARTFinancial Transaction Typenvarchar30
50OTC_CONV_FHAZUBackup Table for Financial Transaction Activities12SFHAARTFinancial Transaction Typenvarchar30
51THMHRT_HRHedge Relationship24SFHAARTFinancial Transaction Typenvarchar30
52THMHRT_HR_FLAGSE-HA: Flags that trigger the HR events4SFHAARTFinancial Transaction Typenvarchar30
53TW19Securities: Correspondence Forms (Used Up To Release 4.5B)4SFHAARTTransaction Type in Securities Managementnvarchar30
54VTBFHATransaction14SFHAARTFinancial Transaction Typenvarchar30
55VTBFHAZUTransaction Activity12SFHAARTFinancial Transaction Typenvarchar30
56VTBMADTMast. Agreement: Permitted Trans. Types4SFHAARTFinancial Transaction Typenvarchar30
57VTBSIZUHedge Allocation46SFHAARTFinancial Transaction Typenvarchar30
58VTBTRA1Transaction Authoriz. for Traders7SFHAARTFinancial Transaction Typenvarchar30
59VTB_FRGSTControl parameter for Release - Status management3SFHAARTFinancial Transaction Typenvarchar30
60VTB_TRADER_AUTHTransparent Table for Trader Authorizations7SFHAARTFinancial Transaction Typenvarchar30
61VTIFHAUnderlying transaction13SFHAARTFinancial Transaction Typenvarchar30
62VTIFHAZUUnderlying transaction status table11SFHAARTFinancial Transaction Typenvarchar30
63VWFL_FT_DECFM: Assign Update Type to Flow Type3SFHAARTFinancial Transaction Typenvarchar30