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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Payroll
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T7ROA2981Insurance result table - Person 1:1 with RGDIRPayroll
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, SEQNR, CMODE, STATU, SENDN, A_INO, B_INO, C_INO, D_INO, E_INO, F_INO, G_INO, H_INO, I_INO, J_INO, A_BAS, A_DIF, A_RDT, A_RDE, A_RDA1, A_RDA2, A_RDA3, A_RDA4, A_RDA5, A_RDA6, A_RDA7, A_RDA8, A_RDA9, A_RDAA, A_RDAB, A_RDAC, A_RDAD, A_RDAE, A_RDAF, A_RDAG, A_RDAH, A_RDAI, A_RDAJ, A_RDAK, A_TCI, A_BC, A_BCSC, A_TASCA, A_NOS, A_CON, B_TVA, B_DVA, B_TVN, B_DVN, B_TVD, B_DVD, B_TVS, B_DVS, B_TNN, B_TDD, B_TSS, B_CAS, B_CSS, B_CON, B_PAR, B_NOR, B_ABS, B_SUD, B_NRM, B_TBN, B_TBD, B_TBS, B_863, B_WKC, C_BAS, C_DIF, D_BAS, D_DIF, E_BAS, E_DIF, F_BAS, F_DIF, G_GRU, G_ART, G_STP, G_AWF, G_AWD, G_AWC, H_BAS, H_DIF, I_BAS, I_DIF, J_BAS, J_DIF, WAERS, K_INO, K_BAS, K_DIF, B_TVO, B_TBO, B_DVO, B_TSO FROM T7ROA2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3SEQNRSequence Numbernvarchar50NUMC(N'00000')NoCDSEQ Allow NULL? 
4CMODESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
5STATUSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
6SENDNSequence Numbernvarchar50NUMC(N'00000')YesCDSEQ Allow NULL? 
7A_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
8B_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
9C_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
10D_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
11E_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
12F_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
13G_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
14H_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
15I_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
16J_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
17A_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
18A_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
19A_RDTHR-RO Reduction / Deduction Typenvarchar30CHAR(N' ')YesPRO_REDET Allow NULL? 
20A_RDEHR Payroll: Amountdecimal152CURR((0))YesMAXBT
21A_RDA1HR Payroll: Amountdecimal152CURR((0))YesMAXBT
22A_RDA2HR Payroll: Amountdecimal152CURR((0))YesMAXBT
23A_RDA3HR Payroll: Amountdecimal152CURR((0))YesMAXBT
24A_RDA4HR Payroll: Amountdecimal152CURR((0))YesMAXBT
25A_RDA5HR Payroll: Amountdecimal152CURR((0))YesMAXBT
26A_RDA6HR Payroll: Amountdecimal152CURR((0))YesMAXBT
27A_RDA7HR Payroll: Amountdecimal152CURR((0))YesMAXBT
28A_RDA8HR Payroll: Amountdecimal152CURR((0))YesMAXBT
29A_RDA9HR Payroll: Amountdecimal152CURR((0))YesMAXBT
30A_RDAAHR Payroll: Amountdecimal152CURR((0))YesMAXBT
31A_RDABHR Payroll: Amountdecimal152CURR((0))YesMAXBT
32A_RDACHR Payroll: Amountdecimal152CURR((0))YesMAXBT
33A_RDADHR Payroll: Amountdecimal152CURR((0))YesMAXBT
34A_RDAEHR Payroll: Amountdecimal152CURR((0))YesMAXBT
35A_RDAFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
36A_RDAGHR Payroll: Amountdecimal152CURR((0))YesMAXBT
37A_RDAHHR Payroll: Amountdecimal152CURR((0))YesMAXBT
38A_RDAIHR Payroll: Amountdecimal152CURR((0))YesMAXBT
39A_RDAJHR Payroll: Amountdecimal152CURR((0))YesMAXBT
40A_RDAKHR Payroll: Amountdecimal152CURR((0))YesMAXBT
41A_TCIHR Payroll: Amountdecimal152CURR((0))YesMAXBT
42A_BCHR Payroll: Amountdecimal152CURR((0))YesMAXBT
43A_BCSCHR Payroll: Amountdecimal152CURR((0))YesMAXBT
44A_TASCAHR-RO Ass.Type-ER contr.exemptchar10CHAR(N' ')YesPRO_TYRER Allow NULL? 
45A_NOSNumc3, internal usenvarchar30NUMC(N'000')YesNUMC3 Allow NULL? 
46A_CONHR-RO contract type 1nvarchar20CHAR(N' ')YesPRO_CONT1 Allow NULL? 
47B_TVAHR Payroll: Amountdecimal152CURR((0))YesMAXBT
48B_DVAHR Payroll: Amountdecimal152CURR((0))YesMAXBT
49B_TVNHR Payroll: Amountdecimal152CURR((0))YesMAXBT
50B_DVNHR Payroll: Amountdecimal152CURR((0))YesMAXBT
51B_TVDHR Payroll: Amountdecimal152CURR((0))YesMAXBT
52B_DVDHR Payroll: Amountdecimal152CURR((0))YesMAXBT
53B_TVSHR Payroll: Amountdecimal152CURR((0))YesMAXBT
54B_DVSHR Payroll: Amountdecimal152CURR((0))YesMAXBT
55B_TNNnvarchar20(N'00')Yes Allow NULL? 
56B_TDDnvarchar20(N'00')Yes Allow NULL? 
57B_TSSnvarchar20(N'00')Yes Allow NULL? 
58B_CASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
59B_CSSHR Payroll: Amountdecimal152CURR((0))YesMAXBT
60B_CONHR-RO contract type 2nvarchar20CHAR(N' ')YesPRO_CONT2 Allow NULL? 
61B_PARHR-RO Partial Timenvarchar20NUMC(N'00')YesPRO_PARTI Allow NULL? 
62B_NORHR-RO NORMAchar10CHAR(N' ')YesPRO_NORMA Allow NULL? 
63B_ABSHR Payroll: Amountdecimal152CURR((0))YesMAXBT
64B_SUDHR Payroll: Amountdecimal152CURR((0))YesMAXBT
65B_NRMAttendance and Absence Daysdecimal62DEC((0))YesABWTG
66B_TBNHR Payroll: Amountdecimal152CURR((0))YesMAXBT
67B_TBDHR Payroll: Amountdecimal152CURR((0))YesMAXBT
68B_TBSHR Payroll: Amountdecimal152CURR((0))YesMAXBT
69B_863HR Payroll: Amountdecimal152CURR((0))YesMAXBT
70B_WKCHR-RO Work Conditionchar10CHAR(N' ')YesPRO_WORKC Allow NULL? 
71C_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
72C_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
73D_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
74D_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
75E_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
76E_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
77F_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
78F_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
79G_GRUChallenge groupnvarchar20CHAR(N' ')Yes*SBGRU Allow NULL? 
80G_ARTType of Challengenvarchar20CHAR(N' ')Yes*SBART Allow NULL? 
81G_STPHR-RO Stop Calculationchar10CHAR(N' ')YesPRO_STOPC Allow NULL? 
82G_AWFAttendance and Absence Daysdecimal62DEC((0))YesABWTG
83G_AWDAttendance and Absence Daysdecimal62DEC((0))YesABWTG
84G_AWCAttendance and Absence Daysdecimal62DEC((0))YesABWTG
85H_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
86H_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
87I_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
88I_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
89J_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
90J_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
91WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
92K_INOHR-RO Insurance no.nvarchar20CHAR(N' ')YesPRO_INSNO Allow NULL? 
93K_BASHR Payroll: Amountdecimal152CURR((0))YesMAXBT
94K_DIFHR Payroll: Amountdecimal152CURR((0))YesMAXBT
95B_TVOHR Payroll: Amountdecimal152CURR((0))YesMAXBT
96B_TBOHR Payroll: Amountdecimal152CURR((0))YesMAXBT
97B_DVOHR Payroll: Amountdecimal152CURR((0))YesMAXBT
98B_TSOnvarchar20(N'00')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
T7ROA2~0YesYesCLUSTEREDSEQNR, PERNR, MANDT