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

34 columns | Print definition?ERP 6.0  | REGNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RF_SVPayroll Result: Social Insurance (F)11REGNOSI contrib. modelnvarchar40
2P2RG_CARCO2Payroll Results: GB Company Cars (CO2 based calculation)5REGNOLicense plate numbernvarchar100
3P2RW_CSTPayroll Result: Cumulated Tax Data for South Africa.21REGNOOld version - Use P16_REGNO_C insteadnvarchar160
4P2RW_STPayroll Result: Tax Data for South Africa.22REGNOOld version - Use P16_REGNO_C insteadnvarchar160
5PA0617HR Master Record: Infotype 061726REGNORegistration numbernvarchar160
6T5FPBS1IEffacement de bases pour les cotisations des organismes2REGNOModèle de chargesnvarchar40
7T7RU1655Infotype 1655 Fields: Legal properties (Russia)27REGNORegistration Numbernvarchar140
8T7RU9AAddresses of organizations33REGNORegistration Numbernvarchar140
TOPBelgium
9T5B1HRelationships Betw. Companies and Institutions7REGNORegistration Number at Institutionnvarchar200
10T5B1RRelationships Betw. Pers. Subareas and Institutions8REGNORegistration Number at Institutionnvarchar200
11T5B1TRelationships Betw. Companies and Institutions8REGNORegistration Number at Institutionnvarchar200
12T5B1URelationships Betw. Personnel Subareas and Institutions9REGNORegistration Number at Institutionnvarchar200
TOPEnvironment, Health and Safety
13DGTPKDG: Packing Requirement31REGNOApproval no.nvarchar300
TOPEnvironment, Health and Safety Master Data
14CCDUTPACKPackaging Code Approvals34REGNOApproval no.nvarchar300
TOPFrance
15PA0064Infotype 0064 : Social Insurance - France27REGNOExpense template for other plansnvarchar40
16T5F1DContributions plan4REGNOSI contrib. modelnvarchar40
17T5F1FAssignment to social insurance fund model (France)2REGNOSI contrib. modelnvarchar40
18T5F1IFund model2REGNOSI contrib. modelnvarchar40
19T5F1MAssignment to social insurance fund model (France)2REGNOSI contrib. modelnvarchar40
20T5F1TName of SI contribution plans3REGNOSI contrib. modelnvarchar40
21T5F4SEmployee groups associated with SI contribution models2REGNOSI contrib. modelnvarchar40
22T5F4VDo not use: replaced by T5F4W12REGNOSI contrib. modelnvarchar40
23T5F4WContributions linked to personnel type12REGNOSI contrib. modelnvarchar40
TOPGreat Britain
24PA0222HR Master Record for Infotype 0222 (Company Cars GB)25REGNOLicense Plate Numbernvarchar100
25T5G_P46ARVHR-GB: Archive for P46(Car)-Forms4REGNOLicense plate numbernvarchar100
TOPKorea
26PA0539HR Master Record: Infotype 053928REGNOKorean Registration Numbernvarchar130
27PA0540Family KOR26REGNOKorean Registration Numbernvarchar130
28PB0539HR Master Record: Infotype 053928REGNOKorean Registration Numbernvarchar130
TOPLocalization
29J_1BECD_CUST05ECD Register Category2REGNOECD Register Numbernvarchar40
30J_1ISERVCService tax details11REGNOService tax registration numbernvarchar300
TOPPayroll
31PA0770Personnel master data: Info type 077036REGNORegistration Nonvarchar100
32PB0770Personnel master data: Info type 077036REGNORegistration Nonvarchar100
TOPPersonnel Administration
33PA0442HR Master Record: Infotype 044228REGNOLicense plate numbernvarchar100
TOPSouth Africa
34PA0149HR Master Record Infotype 0149 (Tax Data South Africa)44REGNORegistered Number for Trust, CC and Company for IRP5nvarchar160