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

47 columns | Print definition?ERP 6.0  | DGUEL_KP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VDSEPA_MND_USGOverview of mandates used in Loans Management11DGUEL_KPCondition Item Valid Fromnvarchar80
TOPBack Office
2TRST_CLASFLOCFM: Class Flows in Securities Account101DGUEL_KPCondition Item Valid Fromnvarchar80
3TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account101DGUEL_KPCondition Item Valid Fromnvarchar80
TOPBank Components
4JBAFOKOPOCondition Items4DGUEL_KPCondition Item Valid Fromnvarchar80
5JBASTCPStandard Conditions: Condition Item4DGUEL_KPCondition Item Valid Fromnvarchar80
TOPLoans Management
6TRDC_RECSummarization of Loan Document Items: Carryforward Records17DGUEL_KPCondition Item Valid Fromnvarchar80
7TTONFTVVZZKOPOTest neue Fima: VVZZKOPO7DGUEL_KPKonditionsposition gültig abnvarchar80
8TTONFTVZZBEPPTest neue FIMA: VZZBEPP178DGUEL_KPKonditionsposition gültig abnvarchar80
9VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items18DGUEL_KPCondition Item Valid Fromnvarchar80
10VDBEPIPosted line items for document header90DGUEL_KPCondition Item Valid Fromnvarchar80
11VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)90DGUEL_KPCondition Item Valid Fromnvarchar80
12VDBEPPFlow Data - Planned Item123DGUEL_KPCondition Item Valid Fromnvarchar80
13VDBOBEPPBusiness Operation: Entered and Activated Flow Data123DGUEL_KPCondition Item Valid Fromnvarchar80
14VDCFWAREHOUSECash Flow Management22DGUEL_KPCondition Item Valid Fromnvarchar80
15VDKOPO_EUCondition Item Data Before EURO Conversion (Loans)10DGUEL_KPCondition Item Valid Fromnvarchar80
16VDREPAYMENTPayoff Master Data54DGUEL_KPRepayment Change Effective Fromnvarchar80
17VZFZE_VDBEPPCentral Entry Table for Release Procedure126DGUEL_KPCondition Item Valid Fromnvarchar80
TOPMaster Data
18VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items5DGUEL_KPEscrow Condition Item Effective fromnvarchar80
TOPReal Estate Management
19VZZKOPO_DMAmount fields for VZZKOPO in original currency10DGUEL_KPCondition Item Valid Fromnvarchar80
TOPRemaining Beverage - Obsolete Objects
20/BEV3/CHAKONDALTTest transfer structure cash flow for conditions6DGUEL_KPCondition Item Valid Fromnvarchar80
TOPTransaction Data Pool
21JBDKKOFFixing Table for Variable Transactions3DGUEL_KPCondition Item Valid Fromnvarchar80
22JBDKKOF_BACKUPBackup Table for the Conversion of JBDKKOF3DGUEL_KPCondition Item Valid Fromnvarchar80
23JBDKKOF_NNew Fixing Table for Variable Transactions4DGUEL_KPCondition Item Valid Fromnvarchar80
24JBDKOPOCondition Items5DGUEL_KPCondition Item Valid Fromnvarchar80
25JBDVTCPVariable Transaction - Condition Items4DGUEL_KPCondition Item Valid Fromnvarchar80
TOPTransaction Management
26TCHT_HD_CONDInstrument Conditions5DGUEL_KPCondition Item Valid Fromnvarchar80
TOPTransaction Manager
27BCKVZZKOPOBACKUP: Condition Item Table10DGUEL_KPCondition Item Valid Fromnvarchar80
28OTC_CONV_AFINKOBackup Table for Fin. Transaction Alternative Conditions8DGUEL_KPCondition Item Valid Fromnvarchar80
29OTC_CONV_FHAPOBackup Table for Financial Transaction Flows22DGUEL_KPCondition Item Valid Fromnvarchar80
30OTC_CONV_FINKOBackup Table for Financial Transaction Conditions8DGUEL_KPCondition Item Valid Fromnvarchar80
31OTC_CONV_IAFINKOBackup Table for Transaction Underlying Old Conditions7DGUEL_KPCondition Item Valid Fromnvarchar80
32OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows20DGUEL_KPCondition Item Valid Fromnvarchar80
33OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions7DGUEL_KPCondition Item Valid Fromnvarchar80
34TRDT_SEC_FLOWPersistent distributor flows: Part for BEPP adaptor4DGUEL_KPCondition Item Valid Fromnvarchar80
35VTBAFINKOAlternative Conditions8DGUEL_KPCondition Item Valid Fromnvarchar80
36VTBFHAPOTransaction Flow22DGUEL_KPCondition Item Valid Fromnvarchar80
37VTBFHAPO_MIGRMigrated Financial Flows22DGUEL_KPCondition Item Valid Fromnvarchar80
38VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows22DGUEL_KPCondition Item Valid Fromnvarchar80
39VTBFINKOTransaction Condition8DGUEL_KPCondition Item Valid Fromnvarchar80
40VTBPFHAPOTreasury: Flow Shells21DGUEL_KPCondition Item Valid Fromnvarchar80
41VTIAFINKOAlternative Conditions Underlying7DGUEL_KPCondition Item Valid Fromnvarchar80
42VTIFHAPOUnderlying transaction flows20DGUEL_KPCondition Item Valid Fromnvarchar80
43VTIFINKOUnderlying transaction conditions7DGUEL_KPCondition Item Valid Fromnvarchar80
44VWBEPITreasury Securities: Actual Flows - Item78DGUEL_KPCondition Item Valid Fromnvarchar80
45VWBEPPTreasury Securities: Planned Flows126DGUEL_KPCondition Item Valid Fromnvarchar80
TOPTreasury
46VZZKOPAAlternative condition item - conditions10DGUEL_KPCondition Item Valid Fromnvarchar80
47VZZKOPOTable condition items10DGUEL_KPCondition Item Valid Fromnvarchar80