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
Payroll :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5ITJ11821Juridical periodical payments (Italy)Italy
SQL:  selectupdate insert create

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

SELECT MANDT, DOC_NUM0014, LGART01, OPKEN01, BETRG01, WAERS01, ANZHL01, ZEINH01, INDBW01, LGART02, OPKEN02, BETRG02, WAERS02, ANZHL02, ZEINH02, INDBW02, LGART03, OPKEN03, BETRG03, WAERS03, ANZHL03, ZEINH03, INDBW03, LGART04, OPKEN04, BETRG04, WAERS04, ANZHL04, ZEINH04, INDBW04, LGART05, OPKEN05, BETRG05, WAERS05, ANZHL05, ZEINH05, INDBW05, LGART06, OPKEN06, BETRG06, WAERS06, ANZHL06, ZEINH06, INDBW06, LGART07, OPKEN07, BETRG07, WAERS07, ANZHL07, ZEINH07, INDBW07, LGART08, OPKEN08, BETRG08, WAERS08, ANZHL08, ZEINH08, INDBW08, LGART09, OPKEN09, BETRG09, WAERS09, ANZHL09, ZEINH09, INDBW09, LGART10, OPKEN10, BETRG10, WAERS10, ANZHL10, ZEINH10, INDBW10, LGART11, OPKEN11, BETRG11, WAERS11, ANZHL11, ZEINH11, INDBW11, LGART12, OPKEN12, BETRG12, WAERS12, ANZHL12, ZEINH12, INDBW12, LGART13, OPKEN13, BETRG13, WAERS13, ANZHL13, ZEINH13, INDBW13, LGART14, OPKEN14, BETRG14, WAERS14, ANZHL14, ZEINH14, INDBW14, LGART15, OPKEN15, BETRG15, WAERS15, ANZHL15, ZEINH15, INDBW15, LGART16, OPKEN16, BETRG16, WAERS16, ANZHL16, ZEINH16, INDBW16, LGART17, OPKEN17, BETRG17, WAERS17, ANZHL17, ZEINH17, INDBW17, LGART18, OPKEN18, BETRG18, WAERS18, ANZHL18, ZEINH18, INDBW18, LGART19, OPKEN19, BETRG19, WAERS19, ANZHL19, ZEINH19, INDBW19, LGART20, OPKEN20, BETRG20, WAERS20, ANZHL20, ZEINH20, INDBW20, BEGDA01, ENDDA01, BEGDA02, ENDDA02, BEGDA03, ENDDA03, BEGDA04, ENDDA04, BEGDA05, ENDDA05, BEGDA06, ENDDA06, BEGDA07, ENDDA07, BEGDA08, ENDDA08, BEGDA09, ENDDA09, BEGDA10, ENDDA10, BEGDA11, ENDDA11, BEGDA12, ENDDA12, BEGDA13, ENDDA13, BEGDA14, ENDDA14, BEGDA15, ENDDA15, BEGDA16, ENDDA16, BEGDA17, ENDDA17, BEGDA18, ENDDA18, BEGDA19, ENDDA19, BEGDA20, ENDDA20 FROM T5ITJ1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DOC_NUM0014nvarchar200(N' ')Yes Allow NULL? 
3LGART01Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
4OPKEN01Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
5BETRG01Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
6WAERS01Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
7ANZHL01Numberdecimal72DEC((0))YesANZHL
8ZEINH01Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
9INDBW01Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
10LGART02Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
11OPKEN02Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
12BETRG02Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
13WAERS02Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
14ANZHL02Numberdecimal72DEC((0))YesANZHL
15ZEINH02Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
16INDBW02Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
17LGART03Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
18OPKEN03Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
19BETRG03Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
20WAERS03Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
21ANZHL03Numberdecimal72DEC((0))YesANZHL
22ZEINH03Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
23INDBW03Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
24LGART04Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
25OPKEN04Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
26BETRG04Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
27WAERS04Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
28ANZHL04Numberdecimal72DEC((0))YesANZHL
29ZEINH04Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
30INDBW04Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
31LGART05Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
32OPKEN05Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
33BETRG05Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
34WAERS05Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
35ANZHL05Numberdecimal72DEC((0))YesANZHL
36ZEINH05Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
37INDBW05Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
38LGART06Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
39OPKEN06Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
40BETRG06Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
41WAERS06Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
42ANZHL06Numberdecimal72DEC((0))YesANZHL
43ZEINH06Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
44INDBW06Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
45LGART07Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
46OPKEN07Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
47BETRG07Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
48WAERS07Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
49ANZHL07Numberdecimal72DEC((0))YesANZHL
50ZEINH07Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
51INDBW07Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
52LGART08Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
53OPKEN08Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
54BETRG08Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
55WAERS08Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
56ANZHL08Numberdecimal72DEC((0))YesANZHL
57ZEINH08Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
58INDBW08Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
59LGART09Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
60OPKEN09Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
61BETRG09Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
62WAERS09Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
63ANZHL09Numberdecimal72DEC((0))YesANZHL
64ZEINH09Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
65INDBW09Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
66LGART10Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
67OPKEN10Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
68BETRG10Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
69WAERS10Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
70ANZHL10Numberdecimal72DEC((0))YesANZHL
71ZEINH10Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
72INDBW10Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
73LGART11Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
74OPKEN11Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
75BETRG11Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
76WAERS11Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
77ANZHL11Numberdecimal72DEC((0))YesANZHL
78ZEINH11Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
79INDBW11Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
80LGART12Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
81OPKEN12Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
82BETRG12Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
83WAERS12Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
84ANZHL12Numberdecimal72DEC((0))YesANZHL
85ZEINH12Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
86INDBW12Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
87LGART13Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
88OPKEN13Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
89BETRG13Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
90WAERS13Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
91ANZHL13Numberdecimal72DEC((0))YesANZHL
92ZEINH13Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
93INDBW13Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
94LGART14Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
95OPKEN14Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
96BETRG14Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
97WAERS14Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
98ANZHL14Numberdecimal72DEC((0))YesANZHL
99ZEINH14Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
100INDBW14Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
101LGART15Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
102OPKEN15Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
103BETRG15Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
104WAERS15Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
105ANZHL15Numberdecimal72DEC((0))YesANZHL
106ZEINH15Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
107INDBW15Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
108LGART16Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
109OPKEN16Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
110BETRG16Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
111WAERS16Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
112ANZHL16Numberdecimal72DEC((0))YesANZHL
113ZEINH16Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
114INDBW16Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
115LGART17Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
116OPKEN17Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
117BETRG17Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
118WAERS17Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
119ANZHL17Numberdecimal72DEC((0))YesANZHL
120ZEINH17Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
121INDBW17Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
122LGART18Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
123OPKEN18Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
124BETRG18Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
125WAERS18Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
126ANZHL18Numberdecimal72DEC((0))YesANZHL
127ZEINH18Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
128INDBW18Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
129LGART19Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
130OPKEN19Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
131BETRG19Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
132WAERS19Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
133ANZHL19Numberdecimal72DEC((0))YesANZHL
134ZEINH19Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
135INDBW19Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
136LGART20Wage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
137OPKEN20Operation Indicator for Wage Typeschar10CHAR(N' ')YesOPKEN Allow NULL? 
138BETRG20Wage Type Amount for Paymentsdecimal132CURR((0))YesPAD_AMT7S
139WAERS20Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
140ANZHL20Numberdecimal72DEC((0))YesANZHL
141ZEINH20Time/Measurement Unitnvarchar30CHAR(N' ')YesT538APT_ZEINH Allow NULL? 
142INDBW20Indicator for indirect valuationchar10CHAR(N' ')YesINDBW Allow NULL? 
143BEGDA01Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
144ENDDA01End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
145BEGDA02Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
146ENDDA02End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
147BEGDA03Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
148ENDDA03End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
149BEGDA04Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
150ENDDA04End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
151BEGDA05Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
152ENDDA05End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
153BEGDA06Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
154ENDDA06End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
155BEGDA07Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
156ENDDA07End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
157BEGDA08Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
158ENDDA08End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
159BEGDA09Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
160ENDDA09End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
161BEGDA10Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
162ENDDA10End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
163BEGDA11Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
164ENDDA11End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
165BEGDA12Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
166ENDDA12End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
167BEGDA13Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
168ENDDA13End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
169BEGDA14Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
170ENDDA14End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
171BEGDA15Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
172ENDDA15End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
173BEGDA16Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
174ENDDA16End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
175BEGDA17Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
176ENDDA17End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
177BEGDA18Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
178ENDDA18End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
179BEGDA19Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
180ENDDA19End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
181BEGDA20Start Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
182ENDDA20End Datenvarchar80DATS(N'00000000')YesENDDA Allow NULL? 
NamePrimaryUniqueTypeColumns
T5ITJ1~0YesYesCLUSTEREDDOC_NUM0014, MANDT