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  | BTRNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P01BN_STATStatus Table for Contribution Statements28BTRNRCompany Numbernvarchar80
TOPConstruction Industry
2PA0190HR Master Data Record Infotype 0190 (BuildingTradePrevERDat)25BTRNRPrevious Employer Company Number for Suppl. Pension Fundnvarchar80
TOPGermany
3T5D11Calculation Procedures and Indicators of Health Ins. Funds7BTRNRCompany Numbernvarchar80
4T5D1KBranch Offices15BTRNRCompany Numbernvarchar80
5T5D3EReduced Hours Compensation/Seasonal RHC: Approval Periods6BTRNRCompany Number for Reduced Hours/Seasonal Reduced Hoursnvarchar80
6T5D3S_EHVEAdditional Data: Reporting Company for Earnings Survey6BTRNRStatistics - Company Number for Earnings Surveynvarchar90
7T5D4THIF Receiving Office for the E-Mail Procedure3BTRNRCompany Numbernvarchar80
8T5D4UFile Numbers for E-Mail Procedure with Health Ins. Funds6BTRNRCompany Numbernvarchar80
9T5D4VE-Mail Procedure Contribution Statement: Admin. of Seq. Nos10BTRNRCompany Numbernvarchar80
10T5D4WHIF Receiving Office for E-Mail Procedure (Forwarding)4BTRNRCompany Numbernvarchar80
11T5D4XAdministration CoNo Certificates E-Mail Procedure3BTRNRB2A: Company Number of Employernvarchar80
12T5D4X_STATStatus - Admin. Contrib. Statmt Certificates E-Mail Proc.3BTRNRB2A: Company Number of Employernvarchar80
13T5D4X_ZERTRCertificate Request - Admin. Contrib. Statmt Certificates3BTRNRB2A: Company Number of Employernvarchar80
TOPPayroll
14T5T1JHealth insurance institutions13BTRNRCorporation namenvarchar80
15T5T1KHealth insurance institutions15BTRNRCorporation namenvarchar80
16T7SK1KHealth insurance institutions16BTRNRCorporation namenvarchar80
TOPSocial Insurance
17P01BD_STATData Module Alternative Correspondence Address16BTRNRCompany Numbernvarchar80
18P01BM_STATControl Records for PPO DEUEV Notifications20BTRNRCompany Numbernvarchar80
19P01BV_STATStatus Table for PPO Contribution Collect. Notif. Procedure19BTRNRCompany Numbernvarchar80
20P01D3_DSAPDEUEV Confirmation: Control Record for Notifications12BTRNRCompany Numbernvarchar80
21P01DS_STATControl Records for DEUEV Immediate Notifications20BTRNRCompany Numbernvarchar80
22P01EA_STATStatus Table for Reimbursement Process17BTRNRCompany Numbernvarchar80
23P01EE_STATAdmin. Records for Data Exchange for Compensation Benefits18BTRNRCompany Numbernvarchar80
24P01EL_PROTLog Table for the ELENA Procedure6BTRNRCompany Numbernvarchar80
25P01EL_STATStatus Table for the ELENA Notification Procedure17BTRNRCompany Numbernvarchar80
26P01SV_B2ATRNSStatus Table Transfer to Social Insurance Agency9BTRNRCompany Numbernvarchar80
27P01SV_MLDTRNSAssignment of Notifications to File Counters6BTRNRCompany Numbernvarchar80
28P01ZS_STATStatus Table for Paying Office Procedure17BTRNRCompany Numbernvarchar80
29T5D31Professionals Pension Organization (PPO)6BTRNRCompany Number of Professional Pension Schemenvarchar80
TOPSouth Africa
30T5W1KPension Funds and Medical Aid Schemes (RSA)18BTRNRCompany numbernvarchar80
31T5W1MSocial insurance companies10BTRNRCompany numbernvarchar80