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

35 columns | Print definition?ERP 6.0  | CYEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/AVR_PRG_DATBuffer Table for Progress Analysis Data4CYEARFiscal Yearnvarchar40
2/CPD/AVR_PR_DATBuffer Table for Progress Analysis Data5CYEARFiscal Yearnvarchar40
3J_1GMYF0_MMYF data2CYEARCalendar Yearnvarchar40
4J_1GWTR0Vendor Tax Data2CYEARCalendar Yearnvarchar40
5P2MX_GRORDMaintenance payment order18CYEARCalendar year for garnishment payrollnvarchar40
6P2RK_GRORDPayroll results Canada: Garnishment order19CYEARCalendar year for garnishment payrollnvarchar40
7P2VE_ABS_EVALHRMS-VE: Wage Management for Valuation of Vacations5CYEARHoliday and factory calendar function module yearnvarchar40
8PAPBSGB_SWF_ABSSWF: Absences2CYEARSWF: Census Yearnvarchar40
9PAPBSGB_SWF_ATPSWF : Agency TP2CYEARSWF: Census Yearnvarchar40
10PAPBSGB_SWF_CONTSWF: Contract Details2CYEARSWF: Census Yearnvarchar40
11PAPBSGB_SWF_CTRLSWF : Control2CYEARSWF: Census Yearnvarchar40
12PAPBSGB_SWF_CUR2SWF: Curriculum2CYEARSWF: Census Yearnvarchar40
13PAPBSGB_SWF_CURRSWF: Curriculum2CYEARSWF: Census Yearnvarchar40
14PAPBSGB_SWF_EPSWF: Educational Psychologists2CYEARSWF: Census Yearnvarchar40
15PAPBSGB_SWF_INFOSWF: Staff Information2CYEARSWF: Census Yearnvarchar40
16PAPBSGB_SWF_PAYSWF: Additional Payments2CYEARSWF: Census Yearnvarchar40
17PAPBSGB_SWF_QUALSWF: Qualifications2CYEARSWF: Census Yearnvarchar40
18PAPBSGB_SWF_QUL2SWF: Qualifications2CYEARSWF: Census Yearnvarchar40
19PAPBSGB_SWF_STAFSWF: Staff Details2CYEARSWF: Census Yearnvarchar40
20PAPBSGB_SWF_VACASWF: Vacancies2CYEARSWF: Census Yearnvarchar40
21T7PLPITPIT document - form3CYEARCalendar yearnvarchar40
TOPBasic Functions
22T874Elimination of hidden reserves11CYEARFiscal yearnvarchar40
23T875CChanges in depreciation9CYEARFiscal yearnvarchar40
TOPBenefit Integration
24T7USBENPEUS pension related data (e.g. Soc. Sec. wages and taxes)5CYEARCumulation Interval Yearnvarchar40
TOPChina
25T7CN13Salary information (CN)5CYEARCalendar year for all kinds of salarynvarchar40
TOPConsolidation
26TF635Goodwill/Neg.Goodwill8CYEARFiscal yearnvarchar40
27TF635AGoodwill/Neg.Goodwill7CYEARFiscal yearnvarchar40
28TF646Recorded Fair Value Adjustments7CYEARFiscal yearnvarchar40
TOPFinancial Accounting
29J_1GMYF0MYF data2CYEARCalendar Yearnvarchar40
30J_1GWTC0Withholding tax certificates data2CYEARCalendar Yearnvarchar40
TOPGeneral Parts
31T74_FBN11Buying/Selling Holiday Factor3CYEARCalendar yearnvarchar40
TOPPersonnel Administration
32PA0658HR Master Record: Infotype 065824CYEARCalendar yearnvarchar40
TOPPersonnel Time Management
33T554ABreakdown of Absences After Quota Deduction12CYEARCalendar yearnvarchar40
34T556WWage Type Assignment for Att./Absence Quota Compensations13CYEARCalendar yearnvarchar40
TOPVenezuela
35T7VEA1Transfer of External Payroll Results: Vacations5CYEARHoliday and factory calendar function module yearnvarchar40