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

31 columns | Print definition?ERP 6.0  | DELFZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data17DELFZRBD: End of Term for Source System Contractnvarchar80
2/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data18DELFZRBD: End of Term for Source System Contractnvarchar80
3/IBS/TRB_ECI_HDRBD ECF - Import Table Header Data14DELFZRBD: End of Term for Source System Contractnvarchar80
4/IBS/TRB_ECM_HDRBD ECF: Manual Contract Management - Header Data15DELFZRBD: End of Term for Source System Contractnvarchar80
TOPBank Components
5JBSSPARRegulatory Reporting - Savings19DELFZEnd of Termnvarchar80
TOPDefault Risk and Limit System
6KLARPDefault Risk Line Items32DELFZTerm End (Original Term)nvarchar80
7KLREPRisk Line Items31DELFZTerm End (Original Term)nvarchar80
8KLSI01Collateral Provision (Header)11DELFZEnd of Validity of Collateral Provisionnvarchar80
9KLSI01_BAKBackup for Euro Changeover for Collateral Provision (Header)11DELFZEnd of Validity of Collateral Provisionnvarchar80
TOPLoans Management
10TTONFTVDARLTest neue Fima: Grunddaten und VDARL57DELFZLaufzeitende des Darlehensnvarchar80
11TTONFTVZZKOKOTest neue FIMA: VZZKOKO27DELFZLaufzeitendenvarchar80
12VDARLLoans43DELFZEnd of Loan Termnvarchar80
13VDARL_RPadContract - Repayment Plan Data16DELFZEnd of Termnvarchar80
14VDPOPOFile item17DELFZEnd of Termnvarchar80
15VDREPAYMENTPayoff Master Data46DELFZPrevious Term End Without Payoff (Calculated)nvarchar80
16VDSDV5Collateral in securities in acc. with BAV/PRF532DELFZEnd of Termnvarchar80
TOPMaster Data
17VDESCROWKOKO0TEMPORARY USE: Escrow Condition Headers28DELFZEnd of Termnvarchar80
TOPRemaining Beverage - Obsolete Objects
18/BEV3/CHASTEUControl Table10DELFZValidity Period Endnvarchar80
TOPRisk Analysis
19JBRDBKOETRM: DB Table Header, HIERA and BEST Extended Cat.Prim.Trans.13DELFZEnd of Term/End of Period of Noticenvarchar80
20JBRHKOETRM: Version Table Header, HIERA and BEST Ext.Cat.Prim.Trans.14DELFZEnd of Term/End of Period of Noticenvarchar80
21JBRSVKOETRM: Header Table of Cat. of Prim. Trans for Saved Datasets12DELFZEnd of Term/End of Period of Noticenvarchar80
TOPTransaction Management
22TCHT_HD_FGETSFGDT FGET Structure11DELFZEnd of Term/End of Period of Noticenvarchar80
TOPTransaction Manager
23OTC_CONV_FHAZUBackup Table for Financial Transaction Activities27DELFZTerm Endnvarchar80
24VTBFHATransaction39DELFZTerm Endnvarchar80
25VTBFHAZUTransaction Activity27DELFZTerm Endnvarchar80
26VTIFHAUnderlying transaction37DELFZEnd of Termnvarchar80
27VTIFHAZUUnderlying transaction status table26DELFZTerm Endnvarchar80
TOPTreasury and Risk Management
28VZZKOKOTable condition header26DELFZEnd of Termnvarchar80
TOPValue Adjustment
29/IBS/TRB_IASGHDRBD IAS-GATE Header Data13DELFZRBD: End of Term for Source System Contractnvarchar80
30/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet18DELFZRBD: End of Term for Source System Contractnvarchar80
31/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet19DELFZRBD: End of Term for Source System Contractnvarchar80