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

33 columns | Print definition?ERP 6.0  | STRNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RF_SARPayroll Results: Garnishment27STRNRHouse Numbernvarchar100
2P2RH_ADOStructure of table ADO14STRNRPersonal tax numbernvarchar200
3T5H7UCertificate for tax allowance13STRNRnvarchar100
4T5H81KRegistered employment relationships -- for comm. contracts9STRNRPersonal tax numbernvarchar200
5T5H81TRegistered employment relationships (multiple employer)10STRNRPersonal tax numbernvarchar200
6T5H82KRegistered employment relationships -- for comm. contracts10STRNRPersonal tax numbernvarchar200
7T5H82TRegistered employment relationships (multiple employer)10STRNRPersonal tax numbernvarchar200
TOPAssortment Maintenance
8WLK1Listing Conditions SAP Retail Assortments19STRNRStructured materialnvarchar180
TOPCompany Pension Scheme Germany
9PA0746HR Master Record for Infotype 074627STRNRTax Numbernvarchar110
TOPGermany
10PA0512HR Master Record Infotype 051225STRNRTax numbernvarchar120
TOPMaterial Master
11TWZLASplitting types for structured materials10STRNRStructured materialnvarchar180
TOPPayroll
12PA0163Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)34STRNREgyéni adószámnvarchar200
13T5H11Minimális járulékalap - jelentett munkavállalók3STRNREgyéni adószámnvarchar200
14T5H2MAdóvégelsz. - APEH-nek elküldött dolg. rekordokról info.6STRNREgyéni adószámnvarchar200
15T5H81Registered employment relationships6STRNRPersonal tax numbernvarchar200
16T5H81MRegistered employment relationships -- for comm. contracts8STRNRPersonal tax numbernvarchar200
17T5H82Registered employment relationships - sent statuses6STRNRPersonal tax numbernvarchar200
18T5H82MRegistered employment relationships -- for comm. contracts8STRNRPersonal tax numbernvarchar200
19T5H83Data of other legal relationships4STRNRPersonal tax numbernvarchar200
20T5H98Solidarity tax4STRNRPersonal tax numbernvarchar200
21T5HPBS_HAVIBONTComm. - payments monthly breakdown by persons4STRNRPersonal tax numbernvarchar200
22T5HS1HR-H: Havi bevallás - bevallási adatok3STRNREgyéni adószám 10 hosszúnvarchar100
23T5HSJHavi bevallás - bevallási adatok - munkavállalónként3STRNREgyéni adószám 10 hosszúnvarchar100
24T5HSMHavi bevallás - külso bevallási adatok magánszemély (I.né)3STRNREgyéni adószám 10 hosszúnvarchar100
25T5HSTHavi bevallás- külso-belso adatok összesítve - személy3STRNREgyéni adószám 10 hosszúnvarchar100
26T5HSVHR-H: Havi bevallás - bevallási adatok (negyedéves)3STRNREgyéni adószám 10 hosszúnvarchar100
27T5HSYHavi bevallás- külso-belso adatok összesítve személy I.né3STRNREgyéni adószám 10 hosszúnvarchar100
28T5HV0IHavi adóbevallás adatainak (T5HV0) index táblája3STRNREgyéni adószám 10 hosszúnvarchar100
29T5HV0I_BCKHavi adóbevallás adatainak (T5HV0) index táblája backup3STRNREgyéni adószám 10 hosszúnvarchar100
30T5HVJJogviszonyok sorszámai (Havi adóbevallás 2.)3STRNREgyéni adószámnvarchar200
31T7ROG1EE register - ER history14STRNRChar 20nvarchar200
TOPRetail Information System RIS
32TMCWRIS Enhancement20STRNRIndicator: enhance structured materialnvarchar10
TOPTax Reporter
33T5UT3Data to be printed in a tax form17STRNRFirst periodnvarchar30