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  | T5LES
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 :: Malaysia
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5LES441ESS Malaysia: TP1 TP2Malaysia
SQL:  selectupdate insert create

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

SELECT MANDT, RETYP, OPDTY, PERNR, ENDDA, SEQNR, BEGDA, REFNO, RQCID, RQCDT, RQCTM, RSNCD, ARDDT, ITUDT, PAYDT, CODAT, ITBDT, PHASE, CSTAT, APUID, APLVL, APGRP, LCUID, LCHDT, LCHTM, ISMST, EEMOB, APMOB, ADMOB, RQAMT, APAMT, UNIT, WAERS, CAPMT, TDAMT, RMAMT, RECNO, RDATE, DESCR, SDAT1, SDAT2, DELFG, PAUID, REJDS FROM T5LES
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RETYPRequest Typenvarchar40CHAR(N' ')NoPMY_RETYP Allow NULL? 
3OPDTYOptional Deduction Typenvarchar50CHAR(N' ')NoPMY_OPDTY Allow NULL? 
4PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
5ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
6SEQNRSequence numbernvarchar40NUMC(N'0000')NoPMY_SEQNR Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
8REFNOReference No.nvarchar170CHAR(N' ')YesPMY_REFNO Allow NULL? 
9RQCIDRequest Creatornvarchar120CHAR(N' ')YesPMY_RQCID Allow NULL? 
10RQCDTRequest Creation Datenvarchar80DATS(N'00000000')YesPMY_RQCDT Allow NULL? 
11RQCTMRequest Creation Timenvarchar60TIMS(N'000000')YesPMY_RQCTM Allow NULL? 
12RSNCDReason Code for Reject / Deletenvarchar30CHAR(N' ')YesPMY_RSNCD Allow NULL? 
13ARDDTApprove / Reject / Delete Datenvarchar80DATS(N'00000000')YesPMY_ARDDT Allow NULL? 
14ITUDTInfotype Update Datenvarchar80DATS(N'00000000')YesPMY_ITUDT Allow NULL? 
15PAYDTPayment Datenvarchar80DATS(N'00000000')YesPMY_PMTDT Allow NULL? 
16CODATCompleted Datenvarchar80DATS(N'00000000')YesPMY_CODAT Allow NULL? 
17ITBDTInfotype Begin Datenvarchar80DATS(N'00000000')YesPMY_ITBDT Allow NULL? 
18PHASEPhase Of the Requestchar10CHAR(N' ')YesPMY_PHASE Allow NULL? 
19CSTATStatus Of the Requestchar10CHAR(N' ')YesPMY_REQSTATUS Allow NULL? 
20APUIDLast / Latest Approver User IDnvarchar120CHAR(N' ')YesPMY_USRID Allow NULL? 
21APLVLApprover Levelnvarchar20CHAR(N' ')YesPMY_APLVL Allow NULL? 
22APGRPApprover Groupnvarchar150CHAR(N' ')YesPMY_APRVR_GRP Allow NULL? 
23LCUIDLast Change By User IDnvarchar120CHAR(N' ')YesPMY_LCUID Allow NULL? 
24LCHDTLast Change Datenvarchar80DATS(N'00000000')YesPMY_LCHDT Allow NULL? 
25LCHTMLast Change Timenvarchar60TIMS(N'000000')YesPMY_LCHTM Allow NULL? 
26ISMSTMail Sentchar10CHAR(N' ')YesPMY_ISMST Allow NULL? 
27EEMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
28APMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
29ADMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
30RQAMTRequested Amountdecimal152CURR((0))YesPMY_RQAMT
31APAMTApproved Amountdecimal152CURR((0))YesPMY_APAMT
32UNITUnit Keynvarchar30CHAR(N' ')Yes*PMY_CLM_UNIT Allow NULL? 
33WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
34CAPMTApproved Amountdecimal152CURR((0))YesPMY_APAMT
35TDAMTApproved Amountdecimal152CURR((0))YesPMY_APAMT
36RMAMTApproved Amountdecimal152CURR((0))YesPMY_APAMT
37RECNOReceipt Numbernvarchar300CHAR(N' ')YesPMY_RECNO Allow NULL? 
38RDATERequest Datenvarchar80DATS(N'00000000')YesPMY_RDATE Allow NULL? 
39DESCRDescriptionnvarchar1200CHAR(N' ')YesPMY_DESCR Allow NULL? 
40SDAT1General Amount Fielddecimal152CURR((0))YesPMY_GENAM
41SDAT2General Amount Fielddecimal152CURR((0))YesPMY_GENAM
42DELFGBoolean Variable (X=True, -=False, Space=Unknown)char10CHAR(N' ')YesBOOLEAN Allow NULL? 
43PAUIDLast / Latest Approver User IDnvarchar120CHAR(N' ')YesPMY_USRID Allow NULL? 
44REJDSRejection Descriptionnvarchar800CHAR(N' ')YesPMY_REJDS Allow NULL? 
NamePrimaryUniqueTypeColumns
T5LES~0YesYesCLUSTEREDSEQNR, ENDDA, PERNR, OPDTY, RETYP, 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