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  | T5WITA88
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 :: South Africa
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5WITA88421ITA88 Transaction TableSouth Africa
SQL:  selectupdate insert create

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

SELECT MANDT, TRNUM, ISDAT, STDAT, SEQNO, RUNID, TONAM, PAYEREF, PSOFT, EENAM, FTNAM, PERID, ICNUM, REFNO, PERNR, ACDAT, ENDAT, MODED, ERAMT, PREFN, CADAT, CAVAL, CAREA, DFAMT, OTCDE, PAAMT, ITEND, ITED1, ITAM1, ITAD1, ITED2, ITAM2, ITAD2, ITED3, ITAM3, ITAD3, ITED4, ITAM4, ITAD4, ITED5, ITAM5, ITAD5 FROM T5WITA88
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TRNUMITA88 Transaction Numbernvarchar100CHAR(N' ')NoP16_TRNUM Allow NULL? 
3ISDATITA88 Issue Datenvarchar80DATS(N'00000000')NoP16_ISDAT Allow NULL? 
4STDATRecovery Datenvarchar80DATS(N'00000000')NoP16_STDAT Allow NULL? 
5SEQNOSequence Numbertinyint30INT1((0))YesP16_SEQNO
6RUNIDRun Numbernvarchar80NUMC(N'00000000')YesP16_RUNID Allow NULL? 
7TONAMTrading or Other Namenvarchar900CHAR(N' ')YesP16_TONAM Allow NULL? 
8PAYEREFPAYE Reference Numbernvarchar100NUMC(N'0000000000')YesP16_PAYRF Allow NULL? 
9PSOFTPayroll Softwarenvarchar120CHAR(N' ')YesP16_PSOFT Allow NULL? 
10EENAMEmployee Surname or Trading Namenvarchar1200CHAR(N' ')YesP16_EENAM Allow NULL? 
11FTNAMFirst two Namesnvarchar900CHAR(N' ')YesP16_FTNAM Allow NULL? 
12PERIDPersonnel ID Numbernvarchar200CHAR(N' ')YesPRDNI Allow NULL? 
13ICNUMIdentity Numbernvarchar300CHAR(N' ')YesPSG_IDNUM Allow NULL? 
14REFNOTax Reference Number ZAnvarchar100CHAR(N' ')YesP16_REFNO Allow NULL? 
15PERNRPersonnel numbernvarchar80NUMC(N'00000000')Yes*PERSNO Allow NULL? 
16ACDATITA88 Start Datenvarchar80DATS(N'00000000')YesP16_ACDAT Allow NULL? 
17ENDATITA88 End Datenvarchar80DATS(N'00000000')YesP16_ENDAT Allow NULL? 
18MODEDITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
19ERAMTEmployer Amount Duedecimal152CURR((0))YesP16_ERAMT
20PREFNPayment Reference Numbernvarchar190CHAR(N' ')YesP16_PREFN Allow NULL? 
21CADATITA88 Cancellation Datenvarchar80DATS(N'00000000')YesP16_CADAT Allow NULL? 
22CAVALITA88 Cancel Valuedecimal152CURR((0))YesP16_CAVAL
23CAREAITA88 Cancellation Reasonnvarchar900CHAR(N' ')YesP16_CAREA Allow NULL? 
24DFAMTITA88 Default Amount (3345)decimal152CURR((0))YesP16_DFAMT
25OTCDEITA88 Outcome Codenvarchar20NUMC(N'00')YesP16_OTCDE Allow NULL? 
26PAAMTEmployer ITA88 Paid Amountdecimal152CURR((0))YesP16_PAAMT
27ITENDLast Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
28ITED1Last Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
29ITAM1ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
30ITAD1ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
31ITED2Last Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
32ITAM2ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
33ITAD2ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
34ITED3Last Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
35ITAM3ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
36ITAD3ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
37ITED4Last Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
38ITAM4ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
39ITAD4ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
40ITED5Last Infotype 11 Update Datenvarchar80DATS(N'00000000')YesP16_ITEND Allow NULL? 
41ITAM5ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
42ITAD5ITA88 Monthly Deductiondecimal152CURR((0))YesP16_MODED
NamePrimaryUniqueTypeColumns
T5WITA88~0YesYesCLUSTEREDSTDAT, ISDAT, TRNUM, 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