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
Personnel Management :: Personnel Administration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA08471061HR master record for infotypes 0847Personnel Administration
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TIPTE, EGGRP, WAERS, COI01, NUM01, AMT01, PCT01, COI02, NUM02, AMT02, PCT02, COI03, NUM03, AMT03, PCT03, COI04, NUM04, AMT04, PCT04, COI05, NUM05, AMT05, PCT05, COI06, NUM06, AMT06, PCT06, COI07, NUM07, AMT07, PCT07, COI08, NUM08, AMT08, PCT08, COI09, NUM09, AMT09, PCT09, COI10, NUM10, AMT10, PCT10, COI11, NUM11, AMT11, PCT11, COI12, NUM12, AMT12, PCT12, COI13, NUM13, AMT13, PCT13, COI14, NUM14, AMT14, PCT14, COI15, NUM15, AMT15, PCT15, COI16, NUM16, AMT16, PCT16, COI17, NUM17, AMT17, PCT17, COI18, NUM18, AMT18, PCT18, COI19, NUM19, AMT19, PCT19, COI20, NUM20, AMT20, PCT20 FROM PA0847
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PERNRPersonnel numbernvarchar80 Allow NULL? 
3SUBTYSubtypenvarchar40 Allow NULL? 
4OBJPSObject Identificationnvarchar20 Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10 Allow NULL? 
6ENDDAEnd Datenvarchar80 Allow NULL? 
7BEGDAStart Datenvarchar80 Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30 Allow NULL? 
9AEDTMChanged Onnvarchar80 Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120 Allow NULL? 
11HISTOHistorical Record Flagchar10 Allow NULL? 
12ITXEXText Exists for Infotypechar10 Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10 Allow NULL? 
14ORDEXConfirmation Fields Existchar10 Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20 Allow NULL? 
16PREASReason for Changing Master Datanvarchar20 Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10 Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10 Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10 Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10 Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40 Allow NULL? 
24TIPTEWork contract termination reasonnvarchar40 Allow NULL? 
25EGGRPEmployee grouping for calculationnvarchar40 Allow NULL? 
26WAERSCurrency Keynvarchar50 Allow NULL? 
27COI01Settlement itemnvarchar40 Allow NULL? 
28NUM01Number/Amount for severance paymentdecimal72
29AMT01Severance payment amountdecimal152
30PCT01Percentage applied to the calculated amountdecimal52
31COI02Settlement itemnvarchar40 Allow NULL? 
32NUM02Number/Amount for severance paymentdecimal72
33AMT02Severance payment amountdecimal152
34PCT02Percentage applied to the calculated amountdecimal52
35COI03Settlement itemnvarchar40 Allow NULL? 
36NUM03Number/Amount for severance paymentdecimal72
37AMT03Severance payment amountdecimal152
38PCT03Percentage applied to the calculated amountdecimal52
39COI04Settlement itemnvarchar40 Allow NULL? 
40NUM04Number/Amount for severance paymentdecimal72
41AMT04Severance payment amountdecimal152
42PCT04Percentage applied to the calculated amountdecimal52
43COI05Settlement itemnvarchar40 Allow NULL? 
44NUM05Number/Amount for severance paymentdecimal72
45AMT05Severance payment amountdecimal152
46PCT05Percentage applied to the calculated amountdecimal52
47COI06Settlement itemnvarchar40 Allow NULL? 
48NUM06Number/Amount for severance paymentdecimal72
49AMT06Severance payment amountdecimal152
50PCT06Percentage applied to the calculated amountdecimal52
51COI07Settlement itemnvarchar40 Allow NULL? 
52NUM07Number/Amount for severance paymentdecimal72
53AMT07Severance payment amountdecimal152
54PCT07Percentage applied to the calculated amountdecimal52
55COI08Settlement itemnvarchar40 Allow NULL? 
56NUM08Number/Amount for severance paymentdecimal72
57AMT08Severance payment amountdecimal152
58PCT08Percentage applied to the calculated amountdecimal52
59COI09Settlement itemnvarchar40 Allow NULL? 
60NUM09Number/Amount for severance paymentdecimal72
61AMT09Severance payment amountdecimal152
62PCT09Percentage applied to the calculated amountdecimal52
63COI10Settlement itemnvarchar40 Allow NULL? 
64NUM10Number/Amount for severance paymentdecimal72
65AMT10Severance payment amountdecimal152
66PCT10Percentage applied to the calculated amountdecimal52
67COI11Settlement itemnvarchar40 Allow NULL? 
68NUM11Number/Amount for severance paymentdecimal72
69AMT11Severance payment amountdecimal152
70PCT11Percentage applied to the calculated amountdecimal52
71COI12Settlement itemnvarchar40 Allow NULL? 
72NUM12Number/Amount for severance paymentdecimal72
73AMT12Severance payment amountdecimal152
74PCT12Percentage applied to the calculated amountdecimal52
75COI13Settlement itemnvarchar40 Allow NULL? 
76NUM13Number/Amount for severance paymentdecimal72
77AMT13Severance payment amountdecimal152
78PCT13Percentage applied to the calculated amountdecimal52
79COI14Settlement itemnvarchar40 Allow NULL? 
80NUM14Number/Amount for severance paymentdecimal72
81AMT14Severance payment amountdecimal152
82PCT14Percentage applied to the calculated amountdecimal52
83COI15Settlement itemnvarchar40 Allow NULL? 
84NUM15Number/Amount for severance paymentdecimal72
85AMT15Severance payment amountdecimal152
86PCT15Percentage applied to the calculated amountdecimal52
87COI16Settlement itemnvarchar40 Allow NULL? 
88NUM16Number/Amount for severance paymentdecimal72
89AMT16Severance payment amountdecimal152
90PCT16Percentage applied to the calculated amountdecimal52
91COI17Settlement itemnvarchar40 Allow NULL? 
92NUM17Number/Amount for severance paymentdecimal72
93AMT17Severance payment amountdecimal152
94PCT17Percentage applied to the calculated amountdecimal52
95COI18Settlement itemnvarchar40 Allow NULL? 
96NUM18Number/Amount for severance paymentdecimal72
97AMT18Severance payment amountdecimal152
98PCT18Percentage applied to the calculated amountdecimal52
99COI19Settlement itemnvarchar40 Allow NULL? 
100NUM19Number/Amount for severance paymentdecimal72
101AMT19Severance payment amountdecimal152
102PCT19Percentage applied to the calculated amountdecimal52
103COI20Settlement itemnvarchar40 Allow NULL? 
104NUM20Number/Amount for severance paymentdecimal72
105AMT20Severance payment amountdecimal152
106PCT20Percentage applied to the calculated amountdecimal52
NamePrimaryUniqueTypeColumns
PA0847~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT