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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

25 columns | Print definition?ERP 6.0  | AINSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRPAYDEPBS_D_DNZDest. Rep. Data: Suppl.Pens. "Business Complete" Information5AINSLKey for Investment Institutionnvarchar80
2PDPBSZVADM_RSPI Confirmation: Administration Table6AINSLKey for Investment Institutionnvarchar80
3T5DREBVV: Conversion Table for AVmG9AINSLKey for Investment Institutionnvarchar80
TOPGermany
4PA0699Personnel Master Record Infotype 069925AINSLKey for Investment Institutionnvarchar80
5T5DRBAVmG: Investment Institute3AINSLKey for Investment Institutionnvarchar80
TOPPublic Sector
6PDPBSZVABMDereg. from Compulsory Insurance (Record Type 40), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
7PDPBSZVABSPeriods (Record Type 60), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
8PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure5AINSLKey for Investment Institutionnvarchar80
9PDPBSZVADRAddress (Record Type 81), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
10PDPBSZVANMReg. for Compulsory Insurance (Record Type 30), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
11PDPBSZVDCARRIERSZVE-PBS Notification Procedure for Data Medium Admin.3AINSLKey for Investment Institutionnvarchar80
12PDPBSZVDIFDifference (Record Type 70), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
13PDPBSZVLOGLog Table for ZVE-PBS Notification Procedure5AINSLKey for Investment Institutionnvarchar80
14PDPBSZVMDCARRSGrouped Data Medium Administration, SP Reporting3AINSLKey for Investment Institutionnvarchar80
15PDPBSZVNAMName (Record Type 80), ZVE-PBS5AINSLKey for Investment Institutionnvarchar80
16PDPBSZVSUMTotals Record (Record Type 90), SPI5AINSLKey for Investment Institutionnvarchar80
17T5D5ZSupplementary Pension Public Sector: SPI Data34AINSLKey for Investment Institutionnvarchar80
18T5DPBSZVABTemporal Validity of Deregistration Reasons3AINSLKey for Investment Institutionnvarchar80
19T5DPBSZVABTValid Deregistration Reasons: Texts4AINSLKey for Investment Institutionnvarchar80
20T5DPBSZVAGEmployer-Specific Settings8AINSLKey for Investment Institutionnvarchar80
21T5DPBSZVAVRing-Fencing of Supplementary Pension Institute3AINSLKey for Investment Institutionnvarchar80
22T5DPBSZVAVTRing-Fencing of Supplementary Pension Institute4AINSLKey for Investment Institutionnvarchar80
23T5DPBSZVRZData Center Information3AINSLKey for Investment Institutionnvarchar80
24T5DPBSZVRZTData Center Information: Text4AINSLKey for Investment Institutionnvarchar80
25T5DPBSZVZVESupplementary Pension Institute3AINSLKey for Investment Institutionnvarchar80