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

50 columns | Print definition?ERP 6.0  | BASE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/PWSC_CALCalculated KPI6BASEDenominatornvarchar10
2P2PL_ZLABASEResults of PLZLA operation11BASEAmount included in basedecimal152
3P2RF_RECOTPayroll Results: Cumulation of Contributions15BASEContribution Basisdecimal152
4TSP0ASpool: Device types10BASESpool: Name of a standard device typenvarchar80
5T7PIQSCALEAcademic Scales7BASEBase Value for Conversion to Standard Scaledecimal82
TOPActual Revenues and Forecast
6TORB2Incoming Orders: Settings for Key5BASEOrder receipt re resource-related billingnvarchar10
TOPBasis Services Communication Interfaces
7SIXMLCEXML Conformance Tests Entities1BASECharacterfeld der Länge 10nvarchar100
8SIXMLCTXML Conformance Tests Entities1BASECharacterfeld der Länge 10nvarchar100
TOPClaims Management
9ICLVISIONVision Findings20BASEBasenvarchar50
10ICSVISIONEyeglass Prescription20BASEBasenvarchar50
TOPCondition
11BKK96Account Balancing Detail Data16BASECalculation Base Amountdecimal172
TOPDirectory
12LDAPSERVERLDAP Server7BASEBase directory tree entrynvarchar2550
TOPFreight Processing
13TVFRDRXDefinition of Rounding Rules3BASEBase value for roundingdecimal105
TOPInformation System
14T044IFI Valuation: Determine Base Value3BASEBase Amount for Calculationnvarchar30
TOPInternational Functions for the Public Sector
15T7PBSDEC_COSTSXDEC: Cost Distribution Definition5BASEXDEC: Base Wage Type Groupingnvarchar20
16T7PBSDEC_WTGRPXDEC: Wage Type Group Definition3BASEXDEC: Base Wage Type Groupingnvarchar20
17T7PBSDEC_WTGRPTXDEC: Wage Type Group Definition Description4BASEXDEC: Base Wage Type Groupingnvarchar20
TOPItaly
18T5ITA4Family allowance values - special12BASEBase amountdecimal156
TOPLocalization
19J_1BNFEPARKTAXNota fiscal electronica: Invoice create failed19BASEBase amountdecimal152
20J_1BNFSTXNota Fiscal tax per item5BASEBase amountdecimal152
21J_1BNFTXCONDTax Condition Interface for Notas Fiscais12BASETax Base Condition (Nota Fiscal)nvarchar40
22J_1BPOSCOUPONSPOS-Database Coupons (Brazilian)18BASEBase amountdecimal152
23J_1BPOSREDUCTIONPOS-Database Reduction (Brazilian)20BASEBase amountdecimal152
24J_1BTXCI1Tax calc.: Complement of ICMS rules7BASETax base (%)decimal62
25J_1BTXCOFTax Calculation: COFINS10BASETax base (%)decimal62
26J_1BTXIC2Tax calc.: ICMS rules9BASETax base (%)decimal62
27J_1BTXIC3Grouped ICMS12BASETax base (%)decimal62
28J_1BTXIP1Tax calc.: IPI rules5BASETax base (%)decimal62
29J_1BTXIP2Tax calc.: IPI rules (material dependent)5BASETax base (%)decimal62
30J_1BTXIP3Grouped IPI8BASETax base (%)decimal62
31J_1BTXISSTax Calculation: ISS11BASETax base (%)decimal62
32J_1BTXPISTax Calculation: PIS10BASETax base (%)decimal62
TOPMigration
33VIGWFLRAZUImmobilien gew.: zeitabh. Zuordnung Fläche zu Raum8BASETunnus - perustilavyöhykenvarchar10
TOPPrint and Output Management
34TSP06ASpool: Implemented format type of a device type3BASESpool: Formatnvarchar160
TOPRelationships Between Objects with GUID Identification
35COMC_IL_STRUCStructures and Table Types of Relationship Types8BASEName of Structure with Relship-Type-Dependent Attributesnvarchar300
TOPService Charge Settlement
36VISCAJROSUAdjustment Record SCSE per RO and SU24BASEBasis Amount for Part-Inclusive Rentdecimal152
37VISCCNPARTSettlement Participation for Service Charge Settlement14BASEBasis for Calculation of All-Inclusive Rentnvarchar10
38VISCS_RO_CNCosts and Measurement Amounts for REC + RO (Lease-Out View)35BASEBasis for Calculation of All-Inclusive Rentnvarchar10
TOPTariffs, Duties and Permits
39OIH_J_1BTXCI1Tax calc.: Complement of ICMS rules8BASETax base (%)decimal62
40OIH_J_1BTXIC2Tax calc.: ICMS rules (exceptions)10BASETax base (%)decimal62
41OIH_J_1BTXIS1Tax calc.: ISS rules for sales exeptions8BASETax base (%)decimal62
42OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions14BASETax base (%)decimal62
TOPTraders and Schedulers Workbench
43OIJBRDOIL-TSW: Rundown table for Batch8BASEOIL-TSW: Base inventorydecimal133
44OIJRDOIL-TSW: Rundown table7BASEOIL-TSW: Base inventorydecimal133
TOPVirtual Machine Container
45SVMCRT_CONFVMC Runtime: Configurations3BASEBasis (Customer or SAP)nvarchar10
46SVMCRT_CONF_NODEVMC Runtime: Configuration Node3BASEBasis (Customer or SAP)nvarchar10
47SVMCRT_CONF_NPRPVMC Runtime: Characteristics of Configuration Node3BASEBasis (Customer or SAP)nvarchar10
48SVMCRT_CONF_NVLBVMC Runtime: Binary Configuration Data3BASEBasis (Customer or SAP)nvarchar10
49SVMCRT_CONF_NVLIVMC Runtime: Configuration Data (Integer Values)3BASEBasis (Customer or SAP)nvarchar10
50SVMCRT_CONF_NVLSVMC Runtime: Configuration Data (Character String)3BASEBasis (Customer or SAP)nvarchar10