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  | TERMNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CPED_EXTENSIONCPE Extension Data4TERMNOCPE Term - Number in Formulanvarchar50
2REFXCN_SMAPMapping of Store and Contract4TERMNOReporting Rule Numbernvarchar40
3VIYCCAPCapping Parameters4TERMNOTerm Numbernvarchar40
4VIYCMAJTENANTMajor Tenant Parameters4TERMNOTerm Numbernvarchar40
5VIYCMARKMark-up Parameters4TERMNOTerm Numbernvarchar40
6VIYCPROVProvision Parameters4TERMNOTerm Numbernvarchar40
7VIYCRHYTHMCAM Expense Recovery Frequency Rule4TERMNOTerm Numbernvarchar40
TOPCommodity Pricing Engine
8CPEC_TERMGRPCPE Term - Grouping of Terms5TERMNOCPE Term - Number in Formulanvarchar50
9CPED_DEFTERMGRPCPE Term - Default for Grouping and General Data in Docume3TERMNOCPE Term - Number in Formulanvarchar50
10CPED_TERMGRPOUTCPE Term - Changed Grouping and General Term Result3TERMNOCPE Term - Number in Formulanvarchar50
11CPED_TERMOUTCPE Term - General Result4TERMNOCPE Term - Number in Formulanvarchar50
TOPFlexible Real Estate Management
12VIXCAJOBJCH01Contract/Rental Object: Adjustment Term Data CH013TERMNOTerm Numbernvarchar40
13VIXCAJSPECH01Contract/Rental Object: Adjustment Rule CH013TERMNOTerm Numbernvarchar40
TOPFunds Management
14FMFG_RE_PMT_EXTRECN Condition:Payment Term Extension4TERMNOTerm Numbernvarchar40
15RECN_OA_SPLITRECN: Group Number of Organizazional Assignment Split4TERMNOTerm Numbernvarchar40
TOPLocalization
16VIXCPTRACONTRACTThe table will store the years for the rent adjustment at t4TERMNOTerm Numbernvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
17TFMCA_PT_TAXCONDCustomizing for Tax Conditions (Property Tax)9TERMNONumber of Frequency Termnvarchar40
TOPReal Estate Contract
18TIVTMXTERMDEFProposed Term Name4TERMNOTerm Numbernvarchar40
19TIVTMXTERMDEFTProposed Term Name (Text)5TERMNOTerm Numbernvarchar40
20VITMNTNotice Term4TERMNOTerm Numbernvarchar40
21VITMNTPROCRELIndividual Notice Procedure4TERMNOTerm Numbernvarchar40
22VITMNTRULEDRIndividual Deadline Regulation4TERMNOTerm Numbernvarchar40
23VITMNTRULEPRIndividual Period Regulation4TERMNOTerm Numbernvarchar40
24VITMOBJRELObject Assignment4TERMNOTerm Numbernvarchar40
25VITMRNRenewal Term4TERMNOTerm Numbernvarchar40
26VITMRNRULEPRIndividual Renewal Rule4TERMNOTerm Numbernvarchar40
27VITMTERMTerm4TERMNOTerm Numbernvarchar40
TOPRent Adjustment
28VIAJNEXTADJMDate of Next Adjustment to Condition3TERMNOTerm Numbernvarchar40
29VIAJOBJCOMPContract/Rental Object: COMP3TERMNOTerm Numbernvarchar40
30VIAJOBJINDXContract/Rental Object: INDX3TERMNOTerm Numbernvarchar40
31VIAJRECORDAdjustment record5TERMNOTerm Numbernvarchar40
32VIAJRULEContract/Rental Object: Adjustment Rule3TERMNOTerm Numbernvarchar40
33VIAJSPECINDXContract/Rental Object: Adjustment Method INDX3TERMNOTerm Numbernvarchar40
34VIAJTERMContract/Rental Object: Adjustment Term3TERMNOTerm Numbernvarchar40
TOPRental Accounting
35VIEXFIWTITEMTerm: Withholding Tax Item4TERMNOTerm Numbernvarchar40
36VIRAADVPAYOBSOLETE: Advance Payment24TERMNOTerm Numbernvarchar40
37VIRAADVPAYPROCAdvance Payments per Settlement18TERMNOTerm Numbernvarchar40
38VITMOATerm: Organizational Assignment4TERMNOTerm Numbernvarchar40
39VITMPYTerm: Posting Rule4TERMNOTerm Numbernvarchar40
40VITMPYSPLITTerm: Split for Posting Rule4TERMNOTerm Numbernvarchar40
41VITMRHTerms: Frequency Rule4TERMNOTerm Numbernvarchar40
42VITMWTTerm: Withholding Tax4TERMNOTerm Numbernvarchar40
TOPSales-Based Rent and Settlement
43VISRCALCSALESReference to Sales Report Used4TERMNOTerm Number of Reporting Rulenvarchar40
44VISRCALCSUMCalculation Results per Sales Rule5TERMNOTerm Numbernvarchar40
45VISRREPORTSales Report3TERMNOTerm Number of Reporting Rulenvarchar40
46VISRSETTLSettlement Identification with Log Reference9TERMNOTerm Number of Reporting Rulenvarchar40
47VISRSTATUSStatus per Contract and Sales Rule (Dependent on Version)5TERMNOTerm Numbernvarchar40
48VISRTMRPReporting Rule4TERMNOTerm Numbernvarchar40
49VISRTMRPHDRHeader Data of Reporting Rule4TERMNOTerm Numbernvarchar40
50VISRTMSBSales Rule4TERMNOTerm Numbernvarchar40
51VISRTMSBHDRHeader Data of Sales Rule4TERMNOTerm Numbernvarchar40
TOPService Charge Settlement
52VISCSUSESettings per Settlement Purpose4TERMNOTerm Numbernvarchar40