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

24 columns | Print definition?ERP 6.0  | RSZKN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RB_CIPayroll Result: Complementary Indemnity- CI (BE)21RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
2P2RB_SVSocial Insurance payroll Belgium56RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
3P2RB_SVEVLPayroll Results: DMFA Social Insurance table for Evaluation9RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
4T5B0AText Table SI Categories Employees (B)3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
5T5B9GEmployee Groups/Subgroups (B)12RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
6T5BVYBase Rates for SI Contributions3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
TOPBelgium
7PA0100HR Master Record: Infotype 0100 (SI B)28RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
8PA3270HR Master Record: Infotype 327035RSZKNWorker Codenvarchar30
9T5B01SI Categories Employees (B)2RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
10T5B0JUsage for SI Category Employee2RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
11T5BCISICComplementary Indemnity: Social Insurance Contributions2RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
12T5BD3Additional Social Insurance Contributions (obsolete)4RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
13T5BDAAdditional Social Insurance Contributions4RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
14T5BS3Employee information except reductions ( level 3 )6RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
15T5BS4Employee remuneration and absence information ( level 4)6RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
16T5BSRReductions for an employee reported on level 36RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
17T5BV2Percentages SI-part per category employer/employee3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
18T5BV3Total SI per employer/employee category3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
19T5BV5Rate for existance insurance fund3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
20T5BV7Rates for wage moderation3RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
21T5BVOQuarterly control ticket SI declaration2RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
22T5BVTLogic of the social security payments4RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
23T5BVULogic of the social security reductions5RSZKNWorker Code (SI Employee Category) (00037)nvarchar30
24T5BVVLevel/block sequence of the social insurance declaration10RSZKNSI category employee sequencenvarchar20