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

32 columns | Print definition?ERP 6.0  | TUNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RP_VAHR-PT: Payroll Results: Vacation allowance grouping (VA)25TUNITTime unitnvarchar30
2PA3321HR Master Record: Infotype 332139TUNITDuration Unitnvarchar20
3T5GPBS24Absence Evaluation: Time Unit Factors3TUNITUnit of time/measurementnvarchar30
4T5GPBS24TAbsence Evaluation: Texts for Time Unit Factor Definition4TUNITUnit of time/measurementnvarchar30
5T5GPBS28Absence Evaluation: Time Unit Grouping3TUNITUnit of time/measurementnvarchar30
6T77PADRU_BONRSParameters for Bonus Reserves8TUNITTime Unit for Reserves Cumulationnvarchar10
7T77WWW_CLLTCSCHMLTC Schemes Master Table9TUNITTime Unitnvarchar10
8T7QAPBS33Education qualification for promotion(No use)9TUNITTime/Measurement Unit Textnvarchar200
9T7QAPBS34Education qualification for promotion8TUNITTime/Measurement Unitnvarchar30
10T7SAPBS31Absence Distribution KSA Public Sector11TUNITTime Unitnvarchar20
11T7SAPBS66Absence Type Limit Condition15TUNITUnit for No. of Times in Yearnvarchar10
TOPAerospace Defence Industry Solution
12ADPMPRIOHDCustomizing : Priority for rotable orders (Header)14TUNITNormal duration/unitnvarchar30
13ADPMPRIOSUBCustomizing Priority ( Priority Level )8TUNITNormal duration/unitnvarchar30
TOPAustralia
14T5QITCalculation rule for transfer frequency10TUNITTime unit for transfer frequencynvarchar30
TOPCompensation Management
15T71LB1Award7TUNITTerm of award (unit)nvarchar30
16T71LV3Life event vesting9TUNITTerm of award (unit)nvarchar30
TOPContract Accounts Receivable and Payable
17TFK052JCustomizing Work Item: Processing Deadline3TUNITTime Unit for Processing Deadline of Work Itemnvarchar30
TOPFinancial Accounting
18T044ABValuation Attributes for OI Valuation By Remaining Term6TUNITTime Unitnvarchar10
19T044ABTDescription for Valuation Attributes By Remaining Term7TUNITTime Unitnvarchar10
TOPIndonesia
20T7ID0AAbsence Split Assignment9TUNITTime Unit for Absence Evaluationnvarchar10
21T7ID0LContinued Absence Linking8TUNITTime Unit for Absence Evaluationnvarchar10
TOPInformation System
22T044KTFurther Specifications for Sorted List6TUNITTime Unitnvarchar10
23T044LSorted List of Open Items5TUNITTime Unitnvarchar10
TOPPublic Sector
24PA0502Letter of appointment41TUNITUnit for duration of full time NSnvarchar30
25PB0502Letter of appointment41TUNITUnit for duration of full time NSnvarchar30
26T5QPBS2GAccrual Transfer Frequency Rules7TUNITTime unit for transfer frequencynvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
27TFMCATUNITDefine Time Units for Time Slices3TUNITTime Unit ID for Time Slicesnvarchar20
28TFMCATUNITTBRF: Text for Time Unit3TUNITTime Unit ID for Time Slicesnvarchar20
29TFMCA_STATLIMStatute of Limitation5TUNITTime Unitnvarchar30
TOPReporting
30S114Fahrzeugverbrauchsanalyse20TUNITPMIS: Eenhedenveld voor bedrijfsurennvarchar30
31S114ES114 - Strukturinformationen13TUNITPMIS: Eenhedenveld voor bedrijfsurennvarchar30
TOPTaiwan
32T7TWABAbsence Split Assignment11TUNITTime Unit for Absence Evaluationnvarchar10