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

27 columns | Print definition?ERP 6.0  | MULTI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNFLDGRPConfigurable Fields Group3MULTIField Group Multiple Value Flagnvarchar10
2P2HK_ENTHR-HK: Payroll structure for the MPF/ORSO Entitlement29MULTIMultiplier for Retirement Entitlement Calculationdecimal52
3T5FDSNFOLLOWUPDSN: It contains the list of the GIP steps5MULTIBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
4T5GPBS24Absence Evaluation: Time Unit Factors6MULTIAbsence Evaluation: Time Unit Multiplier into Daysdecimal166
5T5GPBS28Absence Evaluation: Time Unit Grouping6MULTIAbsence Evaluation: Day Multiplier Time Unitnvarchar10
6ZEIM_VBAKSales Document: Header Data142MULTIMultiple Campaigns/Trade Promotions Active Indicatornvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
7DDTPOOLCNVDD: Names of tablepools to convert5MULTInvarchar20
TOPAustralia
8T5QITCalculation rule for transfer frequency20MULTIMultiplier for transfer frequencynvarchar60
TOPBasic Functions
9T476Parameterization of the Configuration Editor6MULTICarry out check for multiple selectionnvarchar10
TOPBI Content Analyzer
10RSCONTCHECKPROPBI Content Checks Properties4MULTIBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
11RSCONTENTCHECK_CCustomizing for Contentchecks11MULTIExecute Several Checks AT Oncenvarchar10
TOPFunds Management
12TBKZWPayment Method Group Dependency4MULTICheckboxnvarchar10
TOPHong Kong
13T7HK3GVesting Schedule and multiplier13MULTIMultiplier for Retirement Entitlement Calculationdecimal52
TOPMaster Data Framework
14DML_TEXTTYPEMDF Text Types4MULTIMultilinenvarchar10
TOPMigration
15TEMDBIS-U Mig.: Structure of Automation Data9MULTIMultiple datanvarchar10
TOPNew Zealand
16T7NZTIIndependent Earner Tax Credit NZ7MULTITax Calculation Multiplication Factor NZdecimal74
17T7NZTRTaxation Rebates NZ7MULTITax Calculation Multiplication Factor NZdecimal74
18T7NZTSNational Superannuitant Surcharge Codes NZ7MULTITax Calculation Multiplication Factor NZdecimal74
19T7NZTXTax Codes NZ7MULTITax Calculation Multiplication Factor NZdecimal74
TOPNon Profit Organizations
20T7UNPAD_SLQUNPO: Sick Leave Quota Values9MULTINPO Time Typ identifiernvarchar10
TOPPayroll
21T7TRK01Compensation factors - notice periods8MULTIdecimal50
TOPPension fund General Parts
22T5CPAHR-CH: Determination of Wage Types for PF Value Types12MULTIHR-PF: Summary of Work/Insurance Relationships (NOT USED)nvarchar10
TOPPersonnel Administration
23T7CO25Calculation parameters for social benefits6MULTIFactor for time-based calculationdecimal52
24T7CO97Calculation rules for settlement code8MULTIFactor for time-based calculationdecimal52
TOPReporting
25P05_TTFMMapping: Tax Table - Function Module9MULTIMultipliernvarchar30
TOPSales
26VBAKSales Document: Header Data142MULTIMultiple Campaigns/Trade Promotions Active Indicatornvarchar10
TOPSpain
27PA0968HR master record infotype 096865MULTIMore than one worker affectednvarchar10