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

98 columns | Print definition?ERP 6.0  | SZBMETH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FTBB_YCCSPRD_DEFExtension of Credit-Spread Definition8SZBMETHInterest Calculation Methodnvarchar10
2RDPT_CONDITIONCondition within Redemption Schedule30SZBMETHInterest Calculation Methodnvarchar10
3VIYCADVPAYAdvance Payments42SZBMETHInterest Calculation Methodnvarchar10
TOPAccounting
4TDIOA_SCHEME_DEFProfile Definition for Interest on Arrears Calculation6SZBMETHInterest Calculation Methodnvarchar10
5VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation28SZBMETHInterest Calculation Methodnvarchar10
TOPAgency Business Global Trade
6TMZRAgency Business: Payment Types26SZBMETHMethod of calculating interest for additional cash discountnvarchar10
TOPAssetLiability Management
7JBAPLANPARALM Assignment of Planning Parameters to Planning Variant9SZBMETHInterest Calculation Methodnvarchar10
8JBASIMAPALM Simulation Type: Parameters9SZBMETHInterest Calculation Methodnvarchar10
9JBASIMPARASAVEDBALM: Additional Information when Saving Sim. Transactions22SZBMETHInterest Calculation Methodnvarchar10
10JBRALMPARASAVEALM: Evaluation Parameters20SZBMETHInterest Calculation Methodnvarchar10
11JBRBG2Gap Analysis - Global Control7SZBMETHInterest Calculation Method in Gapnvarchar10
12JBRSIMZSimulated Interest - Definition4SZBMETHInterest Calculation Methodnvarchar10
13JBRSVGAPHDRM: Header Data (Saved Gap Evaluation Results)21SZBMETHInterest Calculation Methodnvarchar10
14JBRSVGAPHEADRM: Header Data (Saved Gap Evaluation Results)21SZBMETHInterest Calculation Methodnvarchar10
TOPBack Office
15TRST_CLASFLOCFM: Class Flows in Securities Account82SZBMETHInterest Calculation Methodnvarchar10
16TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account82SZBMETHInterest Calculation Methodnvarchar10
TOPBank Components
17JBAFOKOKOCondition Header4SZBMETHInterest Calculation Methodnvarchar10
18JBASAKOKOCollective Conditions, Condition Header5SZBMETHInterest Calculation Methodnvarchar10
19JBASTCHStandard Conditions: Condition Header4SZBMETHInterest Calculation Methodnvarchar10
TOPInformation System
20FTI_BI_REP_ODSReparation Records for Inconsistent Data in ODS 0CFM_O01 /BW55SZBMETHInterest Calculation Methodnvarchar10
TOPLease Accounting
21FILA_RE_PRGRefinancing Program23SZBMETHInterest Calculation Methodnvarchar10
22TFILAFM_IRCMAssignment of Acct Prin. to Interest Rate Calc. Methods5SZBMETHInterest Calculation Methodnvarchar10
TOPLoans Management
23TRDC_RECSummarization of Loan Document Items: Carryforward Records23SZBMETHInterest Calculation Methodnvarchar10
24TTONFTVVZZKOPOTest neue Fima: VVZZKOPO42SZBMETHZinsberechnungsmethodenvarchar10
25TTONFTVZZBEPPTest neue FIMA: VZZBEPP73SZBMETHZinsberechnungsmethodenvarchar10
26TTONFTVZZKOKOTest neue FIMA: VZZKOKO20SZBMETHZinsberechnungsmethodenvarchar10
27VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items24SZBMETHInterest Calculation Methodnvarchar10
28VDBEPIPosted line items for document header61SZBMETHInterest Calculation Methodnvarchar10
29VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)61SZBMETHInterest Calculation Methodnvarchar10
30VDBEPPFlow Data - Planned Item54SZBMETHInterest Calculation Methodnvarchar10
31VDBOBEPPBusiness Operation: Entered and Activated Flow Data54SZBMETHInterest Calculation Methodnvarchar10
32VDCFWAREHOUSECash Flow Management28SZBMETHInterest Calculation Methodnvarchar10
33VDMEPOVCondition Table: Variant Item32SZBMETHInterest Calculation Methodnvarchar10
34VDORDERBorrower's note loan order data40SZBMETHInterest Calculation Methodnvarchar10
35VZFZE_VDBEPPCentral Entry Table for Release Procedure57SZBMETHInterest Calculation Methodnvarchar10
TOPMaster Data
36VDESCROWKOKO0TEMPORARY USE: Escrow Condition Headers21SZBMETHInterest Calculation Methodnvarchar10
37VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items41SZBMETHInterest Calculation Methodnvarchar10
TOPReal Estate Contract
38VICDCFOBJObject-Related Cash Flow38SZBMETHInterest Calculation Methodnvarchar10
39VICDCFPAYPayment-Related Cash Flow38SZBMETHInterest Calculation Methodnvarchar10
TOPReal Estate Management
40TZK02Condition group, condition group - condition type allocation22SZBMETHInterest Calculation Methodnvarchar10
41VIBEPPFlow data - Planned items for real estate management58SZBMETHInterest Calculation Methodnvarchar10
42VIKOKOReal Estate condition header26SZBMETHCalculation method for time-dependent periodsnvarchar10
TOPRemaining Beverage - Obsolete Objects
43/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.37SZBMETHInterest Calculation Methodnvarchar10
44/BEV3/CHABRSTZ_PCH Settlement Items - With Translations85SZBMETHInterest Calculation Methodnvarchar10
45/BEV3/CHAKONDALTTest transfer structure cash flow for conditions31SZBMETHInterest Calculation Methodnvarchar10
46/BEV3/CHASTEUControl Table4SZBMETHInterest Calculation Methodnvarchar10
47/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items86SZBMETHInterest Calculation Methodnvarchar10
48/BEV3/CHCVBFIMA1FIMA converter 1 AC/RI control record setting5SZBMETHInterest Calculation Methodnvarchar10
49/BEV3/CHERGSTZ_PCH Settlement Items - With Translations85SZBMETHInterest Calculation Methodnvarchar10
50/BEV3/CHERGSTZ_SCH Settlement Statistics86SZBMETHInterest Calculation Methodnvarchar10
51/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics85SZBMETHInterest Calculation Methodnvarchar10
52/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)85SZBMETHInterest Calculation Methodnvarchar10
53/BEV3/CHSHTSTZ_PCH Settlement Item85SZBMETHInterest Calculation Methodnvarchar10
54/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions86SZBMETHInterest Calculation Methodnvarchar10
55/BEV3/CHSIMSTZ_PCH Simulation Items85SZBMETHInterest Calculation Methodnvarchar10
56/BEV3/CHSIMSTZ_SCH Simulation Statistics86SZBMETHInterest Calculation Methodnvarchar10
57/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item86SZBMETHInterest Calculation Methodnvarchar10
58/BEV3/CHTRMSTZ_PCH Date Item85SZBMETHInterest Calculation Methodnvarchar10
59/BEV3/CHTRMSTZ_SCH Date Statistics86SZBMETHInterest Calculation Methodnvarchar10
60/BEV3/CHVABRSTZSCH Settlement Statistics86SZBMETHInterest Calculation Methodnvarchar10
TOPRisk Analysis
61JBRBG0Gap Analysis - Global Control6SZBMETHInterest Calculation Method in Gapnvarchar10
62JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction14SZBMETHInterest Calculation Methodnvarchar10
63JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.15SZBMETHInterest Calculation Methodnvarchar10
64JBRKNZRM: External Key Figures for Financial Object10SZBMETHInterest Calculation Methodnvarchar10
65JBROZRM Gap Opportunity Interest Rates from Single Trans. Costing5SZBMETHInterest Calculation Methodnvarchar10
66JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets15SZBMETHInterest Calculation Methodnvarchar10
67JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)21SZBMETHInterest Calculation Methodnvarchar10
TOPTransaction Data Pool
68JBCFBEWEGCash Flow Transaction: Flows23SZBMETHInterest Calculation Methodnvarchar10
69JBCFBZRCash Flow Transaction: Analysis Period11SZBMETHInterest Calculation Methodnvarchar10
70JBCFZSTRBEWEGCash Flow Transaction: Flow Data for Cash Flow24SZBMETHInterest Calculation Methodnvarchar10
71JBDKOKOCondition Header6SZBMETHInterest Calculation Methodnvarchar10
72JBDVTCHVariable Transaction - Condition Headers4SZBMETHInterest Calculation Methodnvarchar10
73JBDZSKOCash Flow Header15SZBMETHInterest Calculation Method for Cash Flow Headernvarchar10
TOPTransaction Management
74TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table14SZBMETHInterest Calculation Methodnvarchar10
75TCHT_HD_CONDInstrument Conditions17SZBMETHInterest Calculation Methodnvarchar10
TOPTransaction Manager
76OTC_CONV_FHAPOBackup Table for Financial Transaction Flows73SZBMETHInterest Calculation Methodnvarchar10
77OTC_CONV_FINKOBackup Table for Financial Transaction Conditions28SZBMETHInterest Calculation Methodnvarchar10
78OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows58SZBMETHInterest Calculation Methodnvarchar10
79OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions27SZBMETHInterest Calculation Methodnvarchar10
80TRDT_SEC_FLOWPersistent distributor flows: Part for BEPP adaptor14SZBMETHInterest Calculation Methodnvarchar10
81TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)36SZBMETHInterest Calculation Methodnvarchar10
82VTBFHAPOTransaction Flow73SZBMETHInterest Calculation Methodnvarchar10
83VTBFHAPO_MIGRMigrated Financial Flows73SZBMETHInterest Calculation Methodnvarchar10
84VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows73SZBMETHInterest Calculation Methodnvarchar10
85VTBFINKOTransaction Condition28SZBMETHInterest Calculation Methodnvarchar10
86VTBPFHAPOTreasury: Flow Shells65SZBMETHInterest Calculation Methodnvarchar10
87VTIFHAPOUnderlying transaction flows58SZBMETHInterest Calculation Methodnvarchar10
88VTIFINKOUnderlying transaction conditions27SZBMETHInterest Calculation Methodnvarchar10
89VWBEPITreasury Securities: Actual Flows - Item50SZBMETHInterest Calculation Methodnvarchar10
90VWBEPPTreasury Securities: Planned Flows88SZBMETHInterest Calculation Methodnvarchar10
91VWORDEOrder Data78SZBMETHInterest Calculation Methodnvarchar10
TOPTreasury
92AT56RSupplements to Analysis System for Table T056R6SZBMETHInterest Calculation Methodnvarchar10
93JBD14Yield Curve Types (Header Information)4SZBMETHInterest Calculation Methodnvarchar10
94TZPAFinancial Assets Management Product Types14SZBMETHInterest Calculation Methodnvarchar10
95TZPABFinancial Assets Management product types14SZBMETHInterest Calculation Methodnvarchar10
96VTIDERIMaster Data Listed Options and Futures27SZBMETHInterest Calculation Methodnvarchar10
97VZZKOPOTable condition items44SZBMETHInterest Calculation Methodnvarchar10
TOPTreasury and Risk Management
98VZZKOKOTable condition header19SZBMETHInterest Calculation Methodnvarchar10