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

40 columns | Print definition?ERP 6.0  | TERMTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VIYCCAPCapping Parameters3TERMTYPETerm Categorynvarchar40
2VIYCMAJTENANTMajor Tenant Parameters3TERMTYPETerm Categorynvarchar40
3VIYCMARKMark-up Parameters3TERMTYPETerm Categorynvarchar40
4VIYCPROVProvision Parameters3TERMTYPETerm Categorynvarchar40
5VIYCRHYTHMCAM Expense Recovery Frequency Rule3TERMTYPETerm Categorynvarchar40
TOPCommodity Pricing Engine
6CPEC_TERMCPE Term6TERMTYPECPE Term - Term Calculation Typenvarchar70
7CPEC_TERMTYPEFLDCPE - Field Control Dependent on Term Type4TERMTYPECPE Term - Term Calculation Typenvarchar70
8CPED_TERMINPUTCPE Term - Changed Input for General Data3TERMTYPECPE Term - Term Calculation Typenvarchar70
TOPFunds Management
9FMFG_RE_PMT_EXTRECN Condition:Payment Term Extension3TERMTYPETerm Categorynvarchar40
10RECN_OA_SPLITRECN: Group Number of Organizazional Assignment Split3TERMTYPETerm Categorynvarchar40
TOPLocalization
11VIXCPTRACONTRACTThe table will store the years for the rent adjustment at t3TERMTYPETerm Categorynvarchar40
TOPReal Estate Contract
12TIVTMTERMTYPETerm Category2TERMTYPETerm Categorynvarchar40
13TIVTMTERMTYPETClause Types (Text)3TERMTYPETerm Categorynvarchar40
14TIVTMXTERMDEFProposed Term Name3TERMTYPETerm Categorynvarchar40
15TIVTMXTERMDEFTProposed Term Name (Text)4TERMTYPETerm Categorynvarchar40
16VITMNTNotice Term3TERMTYPETerm Categorynvarchar40
17VITMNTPROCRELIndividual Notice Procedure3TERMTYPETerm Categorynvarchar40
18VITMNTRULEDRIndividual Deadline Regulation3TERMTYPETerm Categorynvarchar40
19VITMNTRULEPRIndividual Period Regulation3TERMTYPETerm Categorynvarchar40
20VITMOBJRELObject Assignment3TERMTYPETerm Categorynvarchar40
21VITMRNRenewal Term3TERMTYPETerm Categorynvarchar40
22VITMRNRULEPRIndividual Renewal Rule3TERMTYPETerm Categorynvarchar40
23VITMTERMTerm3TERMTYPETerm Categorynvarchar40
TOPRental Accounting
24VIEXFIWTITEMTerm: Withholding Tax Item3TERMTYPETerm Categorynvarchar40
25VIRAADVPAYOBSOLETE: Advance Payment23TERMTYPETerm Categorynvarchar40
26VIRAADVPAYPROCAdvance Payments per Settlement17TERMTYPETerm Categorynvarchar40
27VITMOATerm: Organizational Assignment3TERMTYPETerm Categorynvarchar40
28VITMPYTerm: Posting Rule3TERMTYPETerm Categorynvarchar40
29VITMPYSPLITTerm: Split for Posting Rule3TERMTYPETerm Categorynvarchar40
30VITMRHTerms: Frequency Rule3TERMTYPETerm Categorynvarchar40
31VITMWTTerm: Withholding Tax3TERMTYPETerm Categorynvarchar40
TOPSales-Based Rent and Settlement
32TIVSRRHTType of Frequency1TERMTYPETerm Categorynvarchar40
33TIVSRRHTTType of Frequency (Text)2TERMTYPETerm Categorynvarchar40
34VISRCALCSUMCalculation Results per Sales Rule4TERMTYPETerm Categorynvarchar40
35VISRSTATUSStatus per Contract and Sales Rule (Dependent on Version)4TERMTYPETerm Categorynvarchar40
36VISRTMRPReporting Rule3TERMTYPETerm Categorynvarchar40
37VISRTMRPHDRHeader Data of Reporting Rule3TERMTYPETerm Categorynvarchar40
38VISRTMSBSales Rule3TERMTYPETerm Categorynvarchar40
39VISRTMSBHDRHeader Data of Sales Rule3TERMTYPETerm Categorynvarchar40
TOPService Charge Settlement
40VISCSUSESettings per Settlement Purpose3TERMTYPETerm Categorynvarchar40