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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

16 columns | Print definition?ERP 6.0  | PROVN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RI_CIG_ARCHEEF : Result Table7PROVNRegion (State, Province, County)nvarchar30
2P2RI_CIG_EXTREEF: Special Payments8PROVNRegion (State, Province, County)nvarchar30
TOPArgentina
3T7ARM2(Dependents) additional data26PROVNProvincenvarchar20
4T7ARM4My Simplification: Family links18PROVNProvince code for family link eventnvarchar20
5T7ARM5My Simplification: Business activity addresses/addresses17PROVNProvincenvarchar20
TOPBenefits
6PA0172HR Master Record: Infotype 0172 (FSA Claims)32PROVNBenefit Name of Benefit Providernvarchar300
TOPContract Accounts Receivable and Payable
7DFKKCJ_OFFIC_EXExternal ID for Offline Branch/Agent and Assgt to Intern. ID5PROVNActivate Processing of Agent Commissionsnvarchar10
TOPItaly
8T5ITGIINPS authorization table4PROVNRegion (State, Province, County)nvarchar30
9T5ITGRAuthorization grouping table37PROVNRegion (State, Province, County)nvarchar30
TOPPersonnel Administration
10T5ITGAEEF final archive6PROVNProvincenvarchar20
TOPSpain
11PA0062HR master record Infotype 0062 (Tax Spain))46PROVNProvincenvarchar30
12PA0090HR Master Record Infotype 0090 (Additional Income)30PROVNProvincenvarchar30
13PA0968HR master record infotype 096836PROVNRegion (State, Province, County)nvarchar30
14T5E01Personnel areas and subareas16PROVNProvincenvarchar30
15T5E20Provinces2PROVNProvincenvarchar30
TOPTravel Planning
16PA0475HR master record infotype 0475 (customer programs)25PROVNCustomer Program: Provider Codenvarchar30