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

26 columns | Print definition?ERP 6.0  | MUNIC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RI_INFO156Payroll results: tax deductions (IT 0156).73MUNICMunicipality keynvarchar80
2P2RV_STST for Norway (Cluster for tax)10MUNICMunicipality Numbernvarchar40
3T5W2MCMunicipality Codes7MUNICMunicipalitynvarchar500
TOPFinland
4T7FI12Time-dependent information for personnel area/subarea8MUNICMunicipality Numbernvarchar30
TOPItaly
5PA0156HR master data, infotype 0156 (Tax deduction)92MUNICMunicipality keynvarchar80
6T5ITM4District indicator table2MUNICMunicipality keynvarchar80
7T5ITM5District tax indicators table2MUNICMunicipality keynvarchar80
8T5ITM6District taxes2MUNICMunicipality keynvarchar80
9T5ITM8District tax settlement6MUNICMunicipality keynvarchar80
10T5ITM9District tax settlement referred to previous year6MUNICMunicipality keynvarchar80
11T5ITMADistrict tax payment steps2MUNICMunicipality keynvarchar80
12T5ITMWDistrict tax indicator description3MUNICMunicipality keynvarchar80
13T5ITMXDistrict indicator descriptions3MUNICMunicipality keynvarchar80
14T5ITNDPlace of work table7MUNICMunicipality keynvarchar80
TOPMexico
15PA0426Garnishment41MUNICMunicipal codenvarchar40
16T77PAYMX65Districts for IT00063MUNICMunicipal codenvarchar40
17T77PAYMX65TDistricts for IT0006 - Name4MUNICMunicipal codenvarchar40
18T7MX01Additional Company Informaton12MUNICMunicipal codenvarchar40
19T7MX24IMSS Employer Regis. nos.11MUNICMunicipal codenvarchar40
20T7MX63Municipalities2MUNICMunicipal codenvarchar40
21T7MX64Economic zones for municipalities2MUNICMunicipal codenvarchar40
TOPNorway
22PA0173Tax card information24MUNICMunicipality Number (allowing zeros "0000")nvarchar40
23T5V2AMunicipality Numbers1MUNICMunicipality Numbernvarchar40
TOPPublic Sector
24PA0509HR-AU-PS: Master Data (Higher Duty Allowance)139MUNICMunicipality Numbernvarchar40
25T7MXPBS10ISSSTE - Mapping of the clinic code and permanent address4MUNICMunicipal codenvarchar40
TOPSpain
26PA0968HR master record infotype 096835MUNICMunicipality codenvarchar50