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

81 columns | Print definition?ERP 6.0  | SGSART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AT14Status Transfers2SGSARTProduct Typenvarchar30
2IDCFM_FRCR_PDVACapitalization Reserve - Product Type4SGSARTProduct Typenvarchar30
3IDCFM_ICLTXFLDIRFlow Types for Tax Types with Sign3SGSARTProduct Typenvarchar30
4TD06UDocument groups dependent on statuses of transaction types2SGSARTProduct Typenvarchar30
5TLRC_TARO_TAR_ASAssignment of Trade Repository3SGSARTProduct Typenvarchar30
6TLRT_TARO_ADMTrade Repository Object Administrative Data14SGSARTProduct Typenvarchar30
TOPAssetLiability Management
7JBNIPLALM Non Interest Profit and Loss8SGSARTProduct Typenvarchar30
TOPBack Office
8TRIL_BWGARTOLD!!! Flow types for Hedge Accounting2SGSARTProduct Typenvarchar30
TOPBasic Functions
9AT85CMF - Generating pmnt advices (prod./trans.type)2SGSARTProduct Typenvarchar30
TOPBusiness Partner
10VTBSTA1Allocation of Payment Details as Standing Instructions7SGSARTProduct Typenvarchar30
11VTBSTA2Standing Instructions for Correspondence6SGSARTProduct Typenvarchar30
12VTBSTA3SI for Business Partner: Transaction Authorizations6SGSARTProduct Typenvarchar30
13VTBSTA4SI for Business Partner: Derived Flows6SGSARTProduct Typenvarchar30
TOPDefault Risk and Limit System
14KLARRZU02Define Default Risk Rule, Limit Product Group for Accounts2SGSARTProduct Typenvarchar30
15KLBESTZUAssignment of Product Type to CL Default Risk Rule2SGSARTProduct Typenvarchar30
16KLEGZUAssignment of TR Product/Tran. Type to CL Default Risk Rule2SGSARTProduct Typenvarchar30
17KLLIMITEXCEEDEDManagement of Exceeded Limits per Product/Transaction Type5SGSARTProduct Typenvarchar30
18KLMAXLIMITLimit per Product Type/Transaction Type3SGSARTProduct Typenvarchar30
19KLORDERZUAssign Prod. Type to CL DRR for Sec. Order and For.Sec.2SGSARTProduct Typenvarchar30
20KLORDERZUARRAssign Prod. Type to CL DRR for Sec. Order and For.Sec.2SGSARTProduct Typenvarchar30
TOPMarket Risk Analyzer
21ATVMOCalculation Methods Risk Management2SGSARTProduct Typenvarchar30
22VTVTRBWRM: Link TR Product Type to Valuation Rule2SGSARTProduct Typenvarchar30
TOPRegulatory reporting for insurance companies
23TZB7VAT Großkreditevidenz: Finanzgeschäftsvogangstyp zu melden2SGSARTProduktartnvarchar30
TOPRisk Analysis
24JBRSVABESTRM: Header Table SDTFT (Additional Info.) for Saved Datasets10SGSARTProduct Typenvarchar30
TOPSingle Transaction Costing
25JBTKREGCosting Rule3SGSARTType of Transaction (Costing-Based)nvarchar20
TOPTransaction Management
26ATALRTTreasury: Alert Category Assignment3SGSARTProduct Typenvarchar30
27ATFWDULAssignment of Underlying to Transaction2SGSARTProduct Typenvarchar30
28ATRELE1Transaction release: Release procedure3SGSARTProduct Typenvarchar30
29ATRELE2Transaction release: Release procedure for detail parameters3SGSARTProduct Typenvarchar30
30TCHT_HD_SFGDTSFGDT Representation of Instruments30SGSARTProduct Typenvarchar30
31VTBMDEXCFM: Mirror Transaction - Initial Table3SGSARTProduct Typenvarchar30
32VTBMDINFKTCFM: Mirror Transaction Mapping Functions3SGSARTProduct Typenvarchar30
33VTBMDMAPCFM: Mirror Transaction - Map PType/TType in Meta Name3SGSARTProduct Typenvarchar30
34VTBMDMAPFLWCFM: Mirror Transaction - Map Flows2SGSARTProduct Typenvarchar30
35VTBMDMAPKONDCFM: Mirror Transaction - Map Conditions2SGSARTProduct Typenvarchar30
36VTB_FMOD_BASICField Modification Values3SGSARTProduct Typenvarchar30
37VTB_FMOD_SFGZUSTField Modification at Activity Category Level3SGSARTProduct Typenvarchar30
38VTB_FMOD_SFHAARTField Modification Values4SGSARTProduct Typenvarchar30
39VTB_FMOD_SFUNKTLField Modification Values4SGSARTProduct Typenvarchar30
40VTB_RULESET_TTFTR Rule Management: Transaction Type Rules4SGSARTProduct Typenvarchar30
TOPTransaction Manager
41AT10Transaction Types2SGSARTProduct Typenvarchar30
42AT10BTreasury: Customizing for Valuation3SGSARTProduct Typenvarchar30
43AT10SSecurities2SGSARTProduct Typenvarchar30
44AT10TName of Transaction Type3SGSARTProduct Typenvarchar30
45AT10XForex Attributes for Transaction Types2SGSARTProduct Typenvarchar30
46AT11Allocation of Condition Types to Transaction Types2SGSARTProduct Typenvarchar30
47AT13Allocation of Flow Types to Transaction Types2SGSARTProduct Typenvarchar30
48AT13UFlow types for transfer posting for activity transition2SGSARTProduct Typenvarchar30
49AT16Treasury: Fixing Settings for Forex Transactions2SGSARTProduct Typenvarchar30
50AT16BTreasury: Settings for mirror transaction types4SGSARTProduct Typenvarchar30
51AT50Future/Option Groups3SGSARTProduct Typenvarchar30
52AT80Treasury: Correspondence Control MM, FX, DE, SE3SGSARTProduct Typenvarchar30
53ATPATreasury: Product Type Supplements2SGSARTProduct Typenvarchar30
54IDCFMBRSETX_HSTHistory table for taxation16SGSARTProduct Typenvarchar30
55IDCFMFLOWCALCFlow calculation using condition technique3SGSARTProduct Typenvarchar30
56IDCFMFLOWCALCINFlow calculation using conditions: map CFM data to KOMK/KOMP3SGSARTProduct Typenvarchar30
57IDCFMFLOWCALCOUTFlow calc.using conditions:map KOMK/KOMP fields to flow data3SGSARTProduct Typenvarchar30
58IDCFMSETX_CUSTCusotmizing for tax posting to FI for funds - Brazil3SGSARTProduct Typenvarchar30
59IDCFMSETX_RATETax rates for tax reports TRM Brazil3SGSARTProduct Typenvarchar30
60IDCFM_FRAM_DICPTAssign Product Types for Alternate Position Mngt. Procedure4SGSARTProduct Typenvarchar30
61IDCFM_FRCR_PDCapitalization Reserve - Product Type3SGSARTProduct Typenvarchar30
62IDCFM_ICLTXCALCIntercompany Loan Tax Calculation Method3SGSARTProduct Typenvarchar30
63IDCFM_ICLTXCATIntercompany Loan Tax Calculation Category3SGSARTProduct Typenvarchar30
64IDCFM_ICLTXFLOWSIntercompany loan tax flow types for different product type3SGSARTProduct Typenvarchar30
65OTC_CONV_FHAZUBackup Table for Financial Transaction Activities11SGSARTProduct Typenvarchar30
66THMHRT_HRHedge Relationship23SGSARTProduct Typenvarchar30
67THMHRT_HR_FLAGSE-HA: Flags that trigger the HR events3SGSARTProduct Typenvarchar30
68TRGC_TAXCFM: Derivation Rules for Tax Flows9SGSARTProduct Typenvarchar30
69TW19Securities: Correspondence Forms (Used Up To Release 4.5B)3SGSARTProduct Typenvarchar30
70VTBFHATransaction13SGSARTProduct Typenvarchar30
71VTBFHAZUTransaction Activity11SGSARTProduct Typenvarchar30
72VTBFININHeader Table for Financial Products3SGSARTProduct Typenvarchar30
73VTBMADTMast. Agreement: Permitted Trans. Types3SGSARTProduct Typenvarchar30
74VTBSIZUHedge Allocation45SGSARTProduct Typenvarchar30
75VTBTRA1Transaction Authoriz. for Traders6SGSARTProduct Typenvarchar30
76VTB_FRGSTControl parameter for Release - Status management2SGSARTProduct Typenvarchar30
77VTB_TRADER_AUTHTransparent Table for Trader Authorizations6SGSARTProduct Typenvarchar30
78VTIFHAUnderlying transaction12SGSARTProduct Typenvarchar30
79VTIFHAZUUnderlying transaction status table10SGSARTProduct Typenvarchar30
80VTIOFAdditional Option Data5SGSARTProduct Typenvarchar30
TOPTreasury
81VTIDERIMaster Data Listed Options and Futures3SGSARTProduct Typenvarchar30