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

37 columns | Print definition?ERP 6.0  | CUMTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2CN_TCRTPayroll results: Tax accumulation (China)7CUMTYCumulation Typenvarchar10
2P2HK_SVHR-HK: Payroll structure for the MPF/ORSO Contribution33CUMTYCumulation Typenvarchar10
3P2MX_LNCTMX Loans Processing9CUMTYCumulation Typenvarchar10
4P2MX_MXCRTPayroll result: Cumulated results Tax MX7CUMTYCumulation Typenvarchar10
5P2RF_CCRTPayroll Results: Cumulation of Contributions, Wage Types13CUMTYCumulation Typenvarchar10
6P2RF_RECOTPayroll Results: Cumulation of Contributions21CUMTYCumulation Typenvarchar10
7P2RK_GRCUMCumulation for garnishment results8CUMTYCumulation Typenvarchar10
8P2RK_TCRTPayroll Results - Fed. and Prov. Tax Cumulations7CUMTYCumulation Typenvarchar10
9P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)10CUMTYCumulation Typenvarchar10
10P2RU_GRCUMCumulation for garnishment results8CUMTYCumulation Typenvarchar10
11P2RU_NRCTUS Tax 1042S Processing11CUMTYCumulation Typenvarchar10
12P2RU_UTIPSPayroll Results: Cumulated tips result7CUMTYCumulation Typenvarchar10
13P2RX_CRTPayroll Results: Cumulated Results Table6CUMTYCumulation Typenvarchar10
14P2RX_CRT_PERSONCumulated Results Table (Person)8CUMTYCumulation Typenvarchar10
15T7CNIWWagetype Configuration for Income Category5CUMTYCumulation Typenvarchar10
16T7CNIWTWagetype Title6CUMTYCumulation Typenvarchar10
17T7CNRM_FRMOPROperands for Formula7CUMTYCharacter Field with Length 5nvarchar50
TOPBenefit Integration
18T7USBENPEUS pension related data (e.g. Soc. Sec. wages and taxes)8CUMTYCumulation Typenvarchar10
TOPBenefits
19PA0602HR Master Record: Infotype 0602 (Retirement Plan Cumulation)26CUMTYCumulation Typenvarchar10
TOPCanada
20T5K8CTransfer ext. payroll results into Canadian specific tables5CUMTYCumulation Typenvarchar10
TOPHong Kong
21T7HK2BContribution plan attributes14CUMTYCumulation Typenvarchar10
TOPIndia
22T7INAASalary years for Pay scale grouping for allowances7CUMTYCumulation Typenvarchar10
23T7INAEClaims carry forward14CUMTYCumulation Typenvarchar10
TOPJapan
24T7JPLA_OTLIMDefine overtime extension limits4CUMTYCumulation Typenvarchar10
TOPMexico
25T7MX50Administration of investment period for savings fund4CUMTYCumulation Typenvarchar10
TOPPayroll General Parts
26T52IAPayroll Infotypes3CUMTYCumulation Typenvarchar10
27T52IBAssignment of Evaluation Wage Types4CUMTYCumulation Typenvarchar10
28T52ICEvaluation Wage Types3CUMTYCumulation Typenvarchar10
29T52IDTexts for Evaluation Wage Types3CUMTYCumulation Typenvarchar10
30T52IEAssignment for Evaluation Wage Types5CUMTYCumulation Typenvarchar10
31T54C1Calendar for Cumulation6CUMTYCumulation Typenvarchar10
32T54C2Calendar Type2CUMTYCumulation Typenvarchar10
33T54C3Cumulation of Wage Types4CUMTYCumulation Typenvarchar10
34T54C4Valid Calendar Types4CUMTYCumulation Typenvarchar10
35T54C6Cumulation Periods2CUMTYCumulation Typenvarchar10
36T54CTCalendar Types (Texts)3CUMTYCumulation Typenvarchar10
37T56C2Permitted Cumulation Types3CUMTYCumulation Typenvarchar10