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

21 columns | Print definition?ERP 6.0  | BASIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2IE_PRDPayroll Results: PRD (IE)6BASISPRD: Week1/Month1 basisnvarchar10
2P2RC_CHVSHR-CH: Payroll result insurance20BASISHR-ch: Basis for charging insurance contributionsdecimal92
3T5BPBS01Description of pay scale rules13BASISIndex Basisdecimal63
4TC29SDistribution strategy5BASISBasis for distribution (factory calendar/Gregorian calend..)nvarchar20
5TKKAS_CONVCopy of TKKAS10BASISValuation Basis for Results Analysisnvarchar10
TOPBelgium
6T5BSRReductions for an employee reported on level 312BASISReduction base amountint100
TOPCost Object
7TKKASControl Table for Results Analysis10BASISValuation Basis for Results Analysisnvarchar10
8TKKAUResults Analysis Methods - Default Values in TKKAS6BASISValuation Basis for Results Analysisnvarchar10
TOPData Transfer
9T52CODISTDistribution Groups for Cost Distribution8BASISBasis for T52codistnvarchar10
TOPFunds Management
10TBPCABudget Costing8BASISCosting Basisnvarchar10
TOPGenerating, Monitoring for Mass Data Archiving Solutions
11TADWP007Advanced Efficiency Service - Config Enterprise Introspector3BASISBasisnvarchar10
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
12TFACDFactory calendar definition13BASISStart of factory calendar day numberingnvarchar50
13TFACSFactory calendar (display)15BASISStart of factory day numberingnvarchar50
TOPNorway
14T5V4ACheck table for infotype 00577BASISBasisnvarchar40
15T5V4BControl table for garnishments and union dues7BASISBasisnvarchar40
TOPPayroll General Parts
16T7CCE_DIST_BASISDistribution basis3BASISDistribution Basisnvarchar40
17T7CCE_DIST_RULEDistribution Rule4BASISDistribution Basisnvarchar40
TOPReuse Services for Country Development
18T799BPP04Pension Calculation Schema9BASISBasis Wage Type for Percentage Contributionsnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
19NLDIS_001ISH NL: DIS - Versicherungsgrund4BASISIS-H NL: Verzekeringsreden DIS-aanleveringnvarchar20
TOPSwitzerland
20T5CS1HR-CH: Control of SI11BASISHR-CH: Basis wage type for SInvarchar40
TOPTreasury
21INDEXDIndex definition (security index)5BASISIndex valuedecimal156