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

31 columns | Print definition?ERP 6.0  | REGNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RK_TAX1Payroll results - master data from infotypes 0461-046312REGNRRegistration Numbernvarchar90
2P2RK_TAXOPayroll results - master data from infotypes 0461-046312REGNRRegistration Numbernvarchar90
3P2RK_TCRTIPayroll Results - Look up table for Tax Cumulations6REGNRRegistration Numbernvarchar90
TOPCanada
4T5KB0Definition of Registration Number, Canada3REGNRRegistration Number of Bus. No./QC Tax IDnvarchar100
5T5KB1Definition of Business Number, Canada3REGNRRegistration Number of Bus. No./QC Tax IDnvarchar100
6T5KB2Canadian tax reporting units3REGNRRegistration Number of Bus. No./QC Tax IDnvarchar100
7T5KB3Registration Number Organizational assignment, Canada7REGNRRegistration Number of Bus. No./QC Tax IDnvarchar100
8T5KB4Account Number Organizational assignment, Canada3REGNRRegistration Number of Bus. No./QC Tax IDnvarchar100
9T5KYHYear end reporting History table4REGNRRegistration Numbernvarchar90
10T5KYRAssociation of wage type with registration number, Canada8REGNRRegistration Numbernvarchar90
TOPDenmark
11PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)25REGNRBank number (Denmark)nvarchar150
TOPElectronic Compliance Reporting
12/ECRS/POIAProvider of Information18REGNRRegistration Numbernvarchar30
TOPGermany
13T5DL1Absence Events6REGNRRule for Absence Eventnvarchar30
14T5DL3Rules for Absence Events3REGNRRule for Absence Eventnvarchar30
15T5DL4Texts for Rules for Absence Events4REGNRRule for Absence Eventnvarchar30
16T5DL5Rule Type for Absence Events3REGNRRule for Absence Eventnvarchar30
TOPGlobal Trade Services
17/SAPSLL/CCMHDCustoms Warehouse Collective Completion - Header13REGNRCustoms Registration Numbernvarchar400
18/SAPSLL/CUPEDSupplementary Customs Declaration Header15REGNRCustoms Registration Numbernvarchar400
19/SAPSLL/TSCHDTax Statement: Hierarchy Customs Declaration Header7REGNRCustoms Registration Numbernvarchar400
20/SAPSLL/TSHDTax Statement: Header11REGNRRegistration Numbernvarchar400
21/SAPSLL/TSPEDTax Statement: Hierarchy of Collective Document7REGNRCustoms Registration Numbernvarchar400
TOPNetherlands
22T5N22Final levy conversion table for special employee groups5REGNRLine Number for Reportingnvarchar20
23T5N2HSpecial Payments Table [Bijzondere Beloningen] (NL)9REGNRLine Number for Reportingnvarchar20
24T5N2ICompens. Allowance [OT] Table for Special Payments (NL)8REGNRLine Number for Reportingnvarchar20
25T5N2XFinal Levy Percentage10REGNRLine Number for Reportingnvarchar20
TOPRegulatory reporting for insurance companies
26TISSR_MAACREFSSR: Zusatzdaten Buchungskreis/Mw-Variante7REGNRISSR: Registernummer Meldewesennvarchar300
TOPReporting
27P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand37REGNRExternal registration numbernvarchar200
28T5N21Final levy5REGNRLine Number for Reportingnvarchar20
TOPReuse Services for Country Development
29PA0652HR Master Record Infotype 065233REGNRRegistration Numbernvarchar120
TOPSpain
30PA0480HR master record for infotype 048035REGNRSpanish Office of Employment (INEM) record numbernvarchar100
31PB0480HR master record infotype 0480 (Candidates)35REGNRSpanish Office of Employment (INEM) record numbernvarchar100