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

67 columns | Print definition?ERP 6.0  | PKOND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_CONDITIONCondition within Redemption Schedule8PKONDPercentage rate for condition itemsdecimal107
2TZB11Activity-dependent one-time conditions8PKONDPercentage rate for condition itemsdecimal107
TOPAccounting
3VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation32PKONDPercentage rate for condition itemsdecimal107
4VDIOA_CALC_HEADCalculation Details for Interest on Arrears Calculation29PKONDPercentage rate for condition itemsdecimal107
TOPBack Office
5TRST_CLASFLOCFM: Class Flows in Securities Account91PKONDPercentage rate for condition itemsdecimal107
6TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account91PKONDPercentage rate for condition itemsdecimal107
TOPBank Components
7JBAFOKOPOCondition Items7PKONDPercentage Rate of Condition Itemdecimal107
8JBASTCPStandard Conditions: Condition Item8PKONDPercentage Rate of Condition Itemdecimal107
TOPCondition
9BKK82Bank Condition Item11PKONDPercentage ratedecimal107
10BKK85Bank Account - Individual Condition Position13PKONDPercentage ratedecimal107
TOPLoans Management
11TRDC_RECSummarization of Loan Document Items: Carryforward Records27PKONDPercentage rate for condition itemsdecimal107
12TTONFTVVZZKOPOTest neue Fima: VVZZKOPO11PKONDProzentsatz der Konditionspositiondecimal107
13TTONFTVZZBEPPTest neue FIMA: VZZBEPP75PKONDProzentsatz der Konditionspositiondecimal107
14VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items28PKONDPercentage rate for condition itemsdecimal107
15VDARL_RPadContract - Repayment Plan Data19PKONDPercentage rate for condition itemsdecimal107
16VDBEPIPosted line items for document header43PKONDPercentage rate for condition itemsdecimal107
17VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)43PKONDPercentage rate for condition itemsdecimal107
18VDBEPPFlow Data - Planned Item72PKONDPercentage rate for condition itemsdecimal107
19VDBOBEPPBusiness Operation: Entered and Activated Flow Data72PKONDPercentage rate for condition itemsdecimal107
20VDCFWAREHOUSECash Flow Management32PKONDPercentage rate for condition itemsdecimal107
21VDORDERBorrower's note loan order data44PKONDPercentage rate for condition itemsdecimal107
22VDREPAYMENTPayoff Master Data56PKONDRepayment Rate for Repayment Changedecimal107
23VDVORKTable for preemption conditions12PKONDPercentage rate for condition itemsdecimal107
24VZFZE_VDBEPPCentral Entry Table for Release Procedure75PKONDPercentage rate for condition itemsdecimal107
TOPMaster Data
25VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items10PKONDPercentage rate for condition itemsdecimal107
TOPReal Estate Management
26TZK02Condition group, condition group - condition type allocation37PKONDPercentage rate for condition itemsdecimal107
TOPRemaining Beverage - Obsolete Objects
27/BEV3/CHABEWEALTTest Transfer Structure: Flow Records in Cash Flow Calcul.38PKONDPercentage rate for condition itemsdecimal107
28/BEV3/CHAKONDALTTest transfer structure cash flow for conditions21PKONDPercentage rate for condition itemsdecimal107
TOPRisk Analysis
29JBRBPKSVRM BP Update Administration for Account Balances8PKONDPercentage Rate of Condition Itemdecimal107
30JBRDBBEWEGRM: DB Table BEWEG Extended Category of Primary Transaction20PKONDInterest rate as a percentagedecimal107
31JBRDBFMLRM: Formula Components for Individual Cash Flows6PKONDPercentage rate for condition itemsdecimal107
32JBRHBEWEGRM: Version Table BEWEG for Extended Cat. of Primary Trans.21PKONDInterest rate as a percentagedecimal107
33JBRHFMLRM: Version Table: Formula Components for Individ.Cash Flows7PKONDPercentage rate for condition itemsdecimal107
34JBRKONRM: Account Balance Summarization in Base Portfolio7PKONDPercentage Rate of Condition Itemdecimal107
35JBRSVBEWEGRM: Flow Table for Cat. of Prim. Trans. for Saved Datasets21PKONDInterest rate as a percentagedecimal107
36JBRSVFMLRM: CF Formula Table for Cat. Prim.Trans. for Saved Datasets7PKONDPercentage rate for condition itemsdecimal107
TOPTransaction Data Pool
37JBDKKOFFixing Table for Variable Transactions8PKONDPercentage Rate of Condition Itemdecimal107
38JBDKKOF_BACKUPBackup Table for the Conversion of JBDKKOF8PKONDPercentage Rate of Condition Itemdecimal107
39JBDKKOF_NNew Fixing Table for Variable Transactions9PKONDPercentage Rate of Condition Itemdecimal107
40JBDKOPOCondition Items9PKONDPercentage Rate of Condition Itemdecimal107
41JBDVTCPVariable Transaction - Condition Items7PKONDPercentage Rate of Condition Itemdecimal107
TOPTransaction Management
42TCHT_HD_BEWEG_CFSFGDT FGET Cashflows Table20PKONDInterest rate as a percentagedecimal107
43TCHT_HD_CONDInstrument Conditions6PKONDPercentage rate for condition itemsdecimal107
44TCHT_HD_COND_FORInstrument Condition Formula6PKONDPercentage rate for condition itemsdecimal107
TOPTransaction Manager
45OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions18PKONDPercentage rate for condition itemsdecimal107
46OTC_CONV_FHAPOBackup Table for Financial Transaction Flows70PKONDPercentage rate for condition itemsdecimal107
47OTC_CONV_FINKOBackup Table for Financial Transaction Conditions23PKONDPercentage rate for condition itemsdecimal107
48OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions17PKONDPercentage rate for condition itemsdecimal107
49OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows55PKONDPercentage rate for condition itemsdecimal107
50OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions22PKONDPercentage rate for condition itemsdecimal107
51TRDT_SEC_FLOWPersistent distributor flows: Part for BEPP adaptor5PKONDPercentage rate for condition itemsdecimal107
52TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)34PKONDPercentage rate for condition itemsdecimal107
53VTBAFINKOAlternative Conditions18PKONDPercentage rate for condition itemsdecimal107
54VTBFHAPOTransaction Flow70PKONDPercentage rate for condition itemsdecimal107
55VTBFHAPO_MIGRMigrated Financial Flows70PKONDPercentage rate for condition itemsdecimal107
56VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows70PKONDPercentage rate for condition itemsdecimal107
57VTBFINKOTransaction Condition23PKONDPercentage rate for condition itemsdecimal107
58VTBPFHAPOTreasury: Flow Shells59PKONDPercentage rate for condition itemsdecimal107
59VTIAFINKOAlternative Conditions Underlying17PKONDPercentage rate for condition itemsdecimal107
60VTIFHAPOUnderlying transaction flows55PKONDPercentage rate for condition itemsdecimal107
61VTIFINKOUnderlying transaction conditions22PKONDPercentage rate for condition itemsdecimal107
62VWBEPITreasury Securities: Actual Flows - Item44PKONDPercentage rate for condition itemsdecimal107
63VWBEPPTreasury Securities: Planned Flows63PKONDPercentage rate for condition itemsdecimal107
64VWORDEOrder Data53PKONDPercentage rate for condition itemsdecimal107
TOPTreasury
65VTIDERIMaster Data Listed Options and Futures25PKONDPercentage rate for condition itemsdecimal107
66VZZKOPAAlternative condition item - conditions14PKONDPercentage rate for condition itemsdecimal107
67VZZKOPOTable condition items13PKONDPercentage rate for condition itemsdecimal107