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

42 columns | Print definition?ERP 6.0  | SLART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PA3310HR Master Record: Infotype 331027SLARTEducational establishmentnvarchar20
2PA3321HR Master Record: Infotype 332124SLARTScholarship Typenvarchar40
3T517AEducational Establishment Types/Final Certificates2SLARTEducational establishmentnvarchar20
4T517ZSchool Types/Branches of Study2SLARTEducational establishmentnvarchar20
5T5PPBS9OPortugal Public Sector - Education2SLARTEducational establishmentnvarchar20
6T7AEPBS56Job classification based education details for UAE PBS7SLARTEducational establishmentnvarchar20
7T7CNA2check table for category of educational institution2SLARTEducational establishmentnvarchar20
8T7CNA2TText table for category of educational institution3SLARTEducational establishmentnvarchar20
9T7CNA4Check table for academic qualification2SLARTEducational establishmentnvarchar20
10T7CNA4TText table for academic qualification3SLARTEducational establishmentnvarchar20
11T7RUPA0022PA0022 Copy24SLARTEducational establishmentnvarchar20
12T7RUPA0022_AIT-0022 converting: Education <-> Education OKIN6SLARTEducational establishmentnvarchar20
13T7SAPBS48Scholarship Type for KSA Public Sector2SLARTScholarship Typenvarchar40
14T7SAPBS48TScholarship Type for KSA Public Scholarship3SLARTScholarship Typenvarchar40
15T7SAPBS49Scholarship Relationship2SLARTScholarship Typenvarchar40
16T7SAPBS65Job Relational Education8SLARTEducational establishmentnvarchar20
TOPArgentina
17T7ARM7MS: Level of training - school type relationship2SLARTEducational establishmentnvarchar20
TOPBelgium
18T5BVDMapping Table Educational Type2SLARTEducational establishmentnvarchar20
TOPCollectionsDisbursements
19TKKVSLARTSelection Type for Clearing5SLARTSelection Categorynvarchar10
20VVKKFAPOSInvoicing Items in FS-CD16SLARTSelection Categorynvarchar10
TOPGermany
21T5D4FWage Types for Contribution Calculation Sec.23c3SLARTType of Social Benefitnvarchar10
22T5D4FLProperties of Notional Run Controls Sec. 23c7SLARTType of Social Benefitnvarchar10
23T5D4NTypes of Benefits for Unpaid Absence2SLARTType of Social Benefitnvarchar10
24T5D4NTTexts for Benefit Types3SLARTType of Social Benefitnvarchar10
TOPJapan
25T5J65HR School Japan2SLARTEducational establishmentnvarchar20
26T5J65THR School Japan3SLARTEducational establishmentnvarchar20
TOPKorea
27T7KRE0Definition school career (conversion table)2SLARTEducational establishmentnvarchar20
TOPMalaysia
28T5LTETax relief information on Education (Malaysia)2SLARTEducational establishmentnvarchar20
TOPNon Profit Organizations
29T7UNPAD_EGSNNPO: Education Grant Schools / Colleges7SLARTEducational establishmentnvarchar20
TOPPayroll
30T5H2BYear-end (tax) certificates elements8SLARTWage type or variable (coll.) namenvarchar50
31T5HB4EMMA Végzettség kódok2SLARTIskolafajtanvarchar20
32T7TRS08Egitim Türlerinin Yasal Gruplamalar ile eslestirilmesi2SLARTOkul türünvarchar20
TOPPayroll General Parts
33T512EForm-Related Control of Wage Types12SLARTWage Typenvarchar40
TOPPersonnel Administration
34PA0022HR Master Record: Infotype 0022 (Education)24SLARTEducational establishmentnvarchar20
35PA0607HR Master Record: Infotype 0022 (Education SI )24SLARTAchieved level of educationnvarchar30
36PB0607HR Master Record: Infotype 0022 (Education SI )24SLARTAchieved level of educationnvarchar30
37T517TEducational Establishment Type Designations3SLARTEducational establishmentnvarchar20
38T7SI0TFinal Certificates3SLARTAchieved level of educationnvarchar30
39T7SI0VEducational Establishment Types/Final Certificates2SLARTAchieved level of educationnvarchar30
40T7SIEVEducation SI2SLARTAchieved level of educationnvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
41DFMCAINVInvoice in IS-PS-CA: Header Data12SLARTSelection Categorynvarchar10
TOPRecruitment
42PB0022HR Master Record: Infotype 0022 (Education)24SLARTEducational establishmentnvarchar20