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

52 columns | Print definition?ERP 6.0  | FLOWTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TIVXCESPTPSTNGProperty Tax: Posting3FLOWTYPEFlow Typenvarchar40
2VIYCADVPAYAdvance Payments73FLOWTYPEFlow Typenvarchar40
3VIYCRECEIVABLEReceivables from Settlement28FLOWTYPEFlow Typenvarchar40
TOPContract Accounts Receivable and Payable
4TIVXAFCTRANSDETFI-CA: Main and Subtransaction for Transaction Type2FLOWTYPEFlow Typenvarchar40
TOPFlexible Real Estate Management
5TIVXCITIBPARAIB Stamp tax parameter6FLOWTYPEFlow Typenvarchar40
6VISCS_RECEIVEOBSOLETE: Receivables (Replaced by VISCRECEIVABLE)3FLOWTYPEFlow Typenvarchar40
TOPLoans Management
7VDCHK_GROSS_NETStorage of data for report RFVD_GROSS_TO_NET9FLOWTYPEFlow Typenvarchar40
TOPLocalization
8TIVXCHUFFService continuity3FLOWTYPEFlow Typenvarchar40
9TIVXCJPFLWTYPFlow Type Defined for Service Charge Keys4FLOWTYPEFlow Typenvarchar40
10TIVXCJPPCATFPayment Categories and Flow Types Customizing2FLOWTYPEFlow Typenvarchar40
TOPPortfolio Analyzer
11PFAIM_CF_FTMATCHAssignment Cash flow type to PA flowtype5FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
12PFAIM_FTYPEMATCHAssignment of Flow Types to PA Flow Types6FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
13PFAIM_TR_UTMATCHAssignment of Update Type to Flow Types in PA5FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
14PFAIM_UMATCH_TRLAssignment of Flow Types to PA Flow Types6FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
15PFA_FLOWTYPESTRM-PA Flow Types2FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
16PFA_FLOWTYPESTTRM-PA Flow Types: Text Table3FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
17RDBPA_REC_FLWKey Figure Values FLW: Single Record Items with Currency6FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
18RDBPA_SUM_FLWKey Figure Values FLW: Totals Records with Currency6FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
19RDBPA_SUM_FLWCCKey Figure Values FLW: Totals Records w/o Currency6FLOWTYPEPortfolio Analyzer: Flow Typenvarchar40
TOPReal Estate Contract
20TIVCDCONDTYPECondition Type4FLOWTYPEFlow Typenvarchar40
21TIVCDFLOWRELReference Flow Type3FLOWTYPEFlow Typenvarchar40
22TIVCDFLOWTYPEFlow Type2FLOWTYPEFlow Typenvarchar40
23TIVCDFLOWTYPETFlow Type (Text)3FLOWTYPEFlow Typenvarchar40
24VICDCFOBJObject-Related Cash Flow70FLOWTYPEFlow Typenvarchar40
25VICDCFPAYPayment-Related Cash Flow69FLOWTYPEFlow Typenvarchar40
TOPRegulatory reporting for insurance companies
26ISSRFLDEOObject table 121FLOWTYPEnvarchar80
TOPRental Accounting
27TIVEXFIBANKSTATCOA Mandate: Flow Types of Bank Statement3FLOWTYPEFlow Typenvarchar40
28TIVEXFIDOCTYPEDocument Type Determination4FLOWTYPEFlow Typenvarchar40
29TIVRAACCDETAccount Determination2FLOWTYPEFlow Typenvarchar40
30TIVRAFLOWTPCNDSFlow Type for Summarization2FLOWTYPESummarization Flow Typenvarchar40
31TIVRAOPACTISettings for Line Item9FLOWTYPEFlow Typenvarchar40
32VIRAADVPAYOBSOLETE: Advance Payment12FLOWTYPEFlow Typenvarchar40
33VIRAADVPAYEXTAdvance Payment - Legacy Data Transfer12FLOWTYPEFlow Typenvarchar40
34VIRAADVPAYPROCAdvance Payments per Settlement14FLOWTYPEFlow Typenvarchar40
35VIRAADVPAYSPLITSplit Advance Payments13FLOWTYPEFlow Typenvarchar40
36VIRADOCITEMRE Document Item23FLOWTYPEFlow Typenvarchar40
37VIRAINVITEMRE Invoice Item8FLOWTYPEFlow Typenvarchar40
TOPRoom Reservations and Seating Arrangements
38TIVORSRVGRPRELService Types for Service Group11FLOWTYPEFlow Typenvarchar40
39VIORRSCOSTReservation - Costs12FLOWTYPEFlow Typenvarchar40
TOPSales-Based Rent and Settlement
40VISRCALCSUMCalculation Results per Sales Rule14FLOWTYPEFlow Typenvarchar40
TOPService Charge Settlement
41TIVSCEXTRACHRGSurcharge Schema for Surcharges in SCS9FLOWTYPEOriginal Flow Type for Surchargenvarchar40
42TIVSCSETTLMODESettlement Methods10FLOWTYPEMust Be Possible to Determine Flow Typenvarchar10
43VISCRECEIVABLEReceivables from Settlement11FLOWTYPEFlow Typenvarchar40
44VISCS_RO_CNCosts and Measurement Amounts for REC + RO (Lease-Out View)15FLOWTYPEFlow Typenvarchar40
TOPTransaction Manager
45IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil22FLOWTYPEUpdate Typenvarchar80
46TCORT_CODFLDeal: Flows7FLOWTYPEFlow Typenvarchar40
47TCORT_CODUL2FLDeal: 2nd Underlying's Flows10FLOWTYPEFlow Typenvarchar40
48TCORT_CODULFLDeal: Underlying Flows9FLOWTYPEFlow Typenvarchar40
49TRLIC_AD_EX1TR: Accrual/Deferral: Further Update Types9FLOWTYPEUpdate Typenvarchar80
50TRLIT_AD_TRANSAccrual/Deferral Business Transactions (Documentation avail)11FLOWTYPEAccrual/Deferral: Update Type for Profit-Related Flownvarchar80
TOPTransfer to Financial Accounting
51TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.14FLOWTYPEUpdate Typenvarchar80
52TRLT_FLOWTreasury Ledger Flows7FLOWTYPEUpdate Typenvarchar80