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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

43 columns | Print definition?ERP 6.0  | SZART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TREAT_FLOW_PMTreasury: TREA Flow Payment Details7SZARTPayment transactionnvarchar10
TOPAccounting
2TDIOA_TEMPLTemplate for Interest On Arrears Calculation14SZARTPayment transactionnvarchar10
TOPBack Office
3TRFT_PACC_BANKPayment Information11SZARTPayment transactionnvarchar10
4TRST_CLASFLOCFM: Class Flows in Securities Account39SZARTPayment transactionnvarchar10
5TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account39SZARTPayment transactionnvarchar10
6TRST_SECACC_BANKPayment Details for Securities Account11SZARTPayment transactionnvarchar10
7TRST_SECACC_PAYDownport Payment Information for Securities Management10SZARTPayment transactionnvarchar10
TOPBusiness Partner
8VTBSTC1Components of Payment Details for Standing Instruction12SZARTPayment transactionnvarchar10
TOPGermany
9T5DP1PAISY Interface6SZARTPAISY: Record Typenvarchar20
10T5DP2Conversion of Infotype Fields -> PAISY5SZARTPAISY: Record Typenvarchar20
11T5DP4Assignment PAISY Company - Superordinate Company2SZARTPAISY: Record Typenvarchar20
TOPLoans Management
12TTONFTVVZZKOPOTest neue Fima: VVZZKOPO90SZARTZahlungsvorgangnvarchar10
13TTONFTVZZBEPPTest neue FIMA: VZZBEPP204SZARTZahlungsvorgangnvarchar10
14VDBEPIPosted line items for document header117SZARTPayment transactionnvarchar10
15VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)117SZARTPayment transactionnvarchar10
16VDBEPPFlow Data - Planned Item143SZARTPayment transactionnvarchar10
17VDBOBEPPBusiness Operation: Entered and Activated Flow Data143SZARTPayment transactionnvarchar10
18VDCFWAREHOUSECash Flow Management76SZARTPayment transactionnvarchar10
19VDREPAYMENTPayoff Master Data69SZARTPayment transactionnvarchar10
20VDZVPayment Details for the Loan18SZARTPayment transactionnvarchar10
21VZFZE_VDBEPPCentral Entry Table for Release Procedure146SZARTPayment transactionnvarchar10
TOPReal Estate Management
22TIV76Area types for each external usage type4SZARTAssignment typenvarchar10
23TZK01Condition types13SZARTPayment transactionnvarchar10
TOPTransaction Manager
24OTC_CONV_FHAPOBackup Table for Financial Transaction Flows31SZARTPayment transactionnvarchar10
25OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows29SZARTPayment transactionnvarchar10
26REFCCReferences between CO object numbers, currency differences18SZARTPayment transactionnvarchar10
27SLDT_FLOWSubledger Distributor Transactions56SZARTPayment transactionnvarchar10
28TERT_FLOWFlow Table for Rights that can be Exercised25SZARTPayment transactionnvarchar10
29TRDT_FLOWPersistent distributor flows54SZARTPayment transactionnvarchar10
30VTBFHAPOTransaction Flow31SZARTPayment transactionnvarchar10
31VTBFHAPO_MIGRMigrated Financial Flows31SZARTPayment transactionnvarchar10
32VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows31SZARTPayment transactionnvarchar10
33VTBPFHAPOTreasury: Flow Shells30SZARTPayment transactionnvarchar10
34VTBZVPayment Details for Transaction18SZARTPayment transactionnvarchar10
35VTIFHAPOUnderlying transaction flows29SZARTPayment transactionnvarchar10
36VWBEPITreasury Securities: Actual Flows - Item98SZARTPayment transactionnvarchar10
37VWBEPPTreasury Securities: Planned Flows145SZARTPayment transactionnvarchar10
38VWORDEOrder Data98SZARTPayment transactionnvarchar10
TOPTransfer to Financial Accounting
39TRACC_MIG_ACCDETTable for Migration of Account Determination9SZARTPayment Transactionnvarchar10
40TRACT_ACCITEMAccounting Items6SZARTPayment Transactionnvarchar10
41TRAC_DFTRULE1Treasury: Assignment of Update Type to Posting Specs3SZARTPayment Transactionnvarchar10
42TRAC_DFTRULE2Treasury: Assgmt of Update Type to Post. Specs per Valn Area4SZARTPayment Transactionnvarchar10
TOPTreasury and Risk Management
43TREAT_EXT_ACC_PMTreasury: External Account Payment Details11SZARTPayment transactionnvarchar10