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

Home | ERP 6.0  | T5ITIN
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
Personnel Management :: Personnel Administration :: Italy
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5ITIN601Accident handling tableItaly
SQL:  selectupdate insert create

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

SELECT MANDT, TRFAR, TRFGB, TRFKZ, TPTRA, SCAGLI, ENDDA, BEGDA, MMLIM, GGLI1, ABY1, WTIN1, ABS1, GGLI2, ABY2, WTIN2, ABS2, GGLI3, ABY3, WTIN3, ABS3, GGLI4, ABY4, WTIN4, ABS4, GGLI5, ABY5, WTIN5, ABS5, GGLA1, ABY6, WTIA1, ABS6, GGLA2, ABY7, WTIA2, ABS7, GGLA3, ABY8, WTIA3, ABS8, GGLA4, ABY9, WTIA4, ABS9, GGLA5, ABY10, WTIA5, ABS10, WTFSA, ABS11, WTCNG, WTPGG, GGCAD, GGCAA, WTGGA, ABS12, WTAZI, WTIAD, UNIMI FROM T5ITIN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TRFARPay scale typenvarchar20CHAR(N' ')NoT510ATRFAR Allow NULL? 
3TRFGBPay Scale Areanvarchar20CHAR(N' ')NoT510GTRFGB Allow NULL? 
4TRFKZES grouping for collective agreement provisionchar10CHAR(N' ')NoTRFKZ Allow NULL? 
5TPTRAAbsence treatment typechar10CHAR(N' ')NoP15_TPTRA Allow NULL? 
6SCAGLISeniority scalenvarchar20NUMC(N'00')NoP15_SCAGL Allow NULL? 
7ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
8BEGDAStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
9MMLIMMaximum number of monthsnvarchar30NUMC(N'000')NoP15_MAMLI Allow NULL? 
10GGLI1INAIL accident categolry: max no. of daysnvarchar30NUMC(N'000')YesP15_GGLMI Allow NULL? 
11ABY1Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
12WTIN1Wage type: INAIL reimbursementnvarchar40CHAR(N' ')YesT512WP15_WTINF Allow NULL? 
13ABS1Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
14GGLI2INAIL accident categolry: max no. of daysnvarchar30NUMC(N'000')YesP15_GGLMI Allow NULL? 
15ABY2Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
16WTIN2Wage type: INAIL reimbursementnvarchar40CHAR(N' ')YesT512WP15_WTINF Allow NULL? 
17ABS2Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
18GGLI3INAIL accident categolry: max no. of daysnvarchar30NUMC(N'000')YesP15_GGLMI Allow NULL? 
19ABY3Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
20WTIN3Wage type: INAIL reimbursementnvarchar40CHAR(N' ')YesT512WP15_WTINF Allow NULL? 
21ABS3Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
22GGLI4INAIL accident categolry: max no. of daysnvarchar30NUMC(N'000')YesP15_GGLMI Allow NULL? 
23ABY4Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
24WTIN4Wage type: INAIL reimbursementnvarchar40CHAR(N' ')YesT512WP15_WTINF Allow NULL? 
25ABS4Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
26GGLI5INAIL accident categolry: max no. of daysnvarchar30NUMC(N'000')YesP15_GGLMI Allow NULL? 
27ABY5Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
28WTIN5Wage type: INAIL reimbursementnvarchar40CHAR(N' ')YesT512WP15_WTINF Allow NULL? 
29ABS5Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
30GGLA1Range days for accidentnvarchar30NUMC(N'000')YesP15_GGINF Allow NULL? 
31ABY6Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
32WTIA1Wage type: company integrationnvarchar40CHAR(N' ')YesT512WP15_WTINT Allow NULL? 
33ABS6Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
34GGLA2Range days for accidentnvarchar30NUMC(N'000')YesP15_GGINF Allow NULL? 
35ABY7Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
36WTIA2Wage type: company integrationnvarchar40CHAR(N' ')YesT512WP15_WTINT Allow NULL? 
37ABS7Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
38GGLA3Range days for accidentnvarchar30NUMC(N'000')YesP15_GGINF Allow NULL? 
39ABY8Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
40WTIA3Wage type: company integrationnvarchar40CHAR(N' ')YesT512WP15_WTINT Allow NULL? 
41ABS8Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
42GGLA4Range days for accidentnvarchar30NUMC(N'000')YesP15_GGINF Allow NULL? 
43ABY9Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
44WTIA4Wage type: company integrationnvarchar40CHAR(N' ')YesT512WP15_WTINT Allow NULL? 
45ABS9Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
46GGLA5Range days for accidentnvarchar30NUMC(N'000')YesP15_GGINF Allow NULL? 
47ABY10Percentage typenvarchar20CHAR(N' ')YesT5ITI3P15_TPPER Allow NULL? 
48WTIA5Wage type: company integrationnvarchar40CHAR(N' ')YesT512WP15_WTINT Allow NULL? 
49ABS10Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
50WTFSAWage type: company public holidaynvarchar40CHAR(N' ')YesT512WP15_WTFSA Allow NULL? 
51ABS11Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
52WTCNGWage type: INAIL accident settlementnvarchar40CHAR(N' ')YesT512WP15_WTCNG Allow NULL? 
53WTPGGWage type: accident calculation basenvarchar40CHAR(N' ')YesT512WP15_WTCRE Allow NULL? 
54GGCADGrace days for accident from/tonvarchar20NUMC(N'00')YesP15_GCAIN Allow NULL? 
55GGCAAGrace days for accident from/tonvarchar20NUMC(N'00')YesP15_GCAIN Allow NULL? 
56WTGGAWage type: company grace daysnvarchar40CHAR(N' ')YesT512WP15_WTGGA Allow NULL? 
57ABS12Absence/attendance categorychar10CHAR(N' ')YesT554PABSTP Allow NULL? 
58WTAZIWT company calculation base - Accidentnvarchar40CHAR(N' ')YesT512WP15_WTAZI Allow NULL? 
59WTIADWage-type company integration 2nvarchar40CHAR(N' ')YesT512WP15_WTIAD Allow NULL? 
60UNIMIUnit of measure for the integration of protected actionschar10CHAR(N' ')YesP15_UNIMI Allow NULL? 
NamePrimaryUniqueTypeColumns
T5ITIN~0YesYesCLUSTEREDENDDA, SCAGLI, TPTRA, TRFKZ, TRFGB, TRFAR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy