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  | T77WWW_CLTRANSD
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
1ERP EHP76.0T77WWW_CLTRANSD461Cluster table for storing transaction data.
SQL:  selectupdate insert create

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

SELECT MANDT, SRTFD, PERNR, REFNR, RETYP, RQTYP, CREFM, RQCID, RQCDT, RQCTM, RQCAN, RSNCD, ARDDT, ITUDT, PAYDT, CODAT, ITBDT, PHASE, CSTAT, ASREF, TSR01, TSR02, OCFLG, TEXRQ, WRKID, OCPVD, DCLAG, ERRFG, ERRNO, APUID, APLVL, APGRP, LCUID, LCHDT, LCHTM, ISMST, EEMOB, APMOB, ADMOB, SCMCD, PCLMD, ISCMP, PRTNO, TRPNO, BEGDA, ENNDA FROM T77WWW_CLTRANSD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2SRTFDPCLx keynvarchar400CHAR(N' ')NoPCLKEY Allow NULL? 
3PERNRPersonnel numbernvarchar80NUMC(N'00000000')Yes*PERSNO Allow NULL? 
4REFNRRequest Reference Numbernvarchar130CHAR(N' ')YesPIN_REFNR Allow NULL? 
5RETYPReimbursement Typenvarchar40CHAR(N' ')Yes*PIN_REIMB_TYP Allow NULL? 
6RQTYPRequest Typenvarchar20CHAR(N' ')YesPIN_REQ_TYP Allow NULL? 
7CREFMRequest Created Sourcenvarchar20CHAR(N' ')YesPIN_CL_REQ_SOURCE Allow NULL? 
8RQCIDRequest Created Bynvarchar120CHAR(N' ')YesPIN_RQCID Allow NULL? 
9RQCDTRequest Creation Datenvarchar80DATS(N'00000000')YesPIN_RQCDT Allow NULL? 
10RQCTMRequest Creation Timenvarchar60TIMS(N'000000')YesPIN_RQCTM Allow NULL? 
11RQCANRequest Creation Solution Typenvarchar50NUMC(N'00000')YesPIN_RQCAN Allow NULL? 
12RSNCDReason Code for Reject / Deletenvarchar30CHAR(N' ')YesPIN_RSNCD Allow NULL? 
13ARDDTApprove / Reject / Delete Datenvarchar80DATS(N'00000000')YesPIN_ARDDT Allow NULL? 
14ITUDTInfotype Update Datenvarchar80DATS(N'00000000')YesPIN_ITUDT Allow NULL? 
15PAYDTPayment Datenvarchar80DATS(N'00000000')YesPIN_PMTDT Allow NULL? 
16CODATCompleted Datenvarchar80DATS(N'00000000')YesPIN_CODAT Allow NULL? 
17ITBDTInfotype Begin Datenvarchar80DATS(N'00000000')YesPIN_ITBDT Allow NULL? 
18PHASEPhase Of the Requestchar10CHAR(N' ')YesPIN_PHASE Allow NULL? 
19CSTATStatus Of the Requestchar10CHAR(N' ')YesPIN_REQSTATUS Allow NULL? 
20ASREFRequest Reference Numbernvarchar130CHAR(N' ')YesPIN_REFNR Allow NULL? 
21TSR01Trigger Screen Rendering Fieldnvarchar40CHAR(N' ')YesPIN_TRSCR Allow NULL? 
22TSR02Trigger Screen Rendering Fieldnvarchar40CHAR(N' ')YesPIN_TRSCR Allow NULL? 
23OCFLGOffcycle Requestedchar10CHAR(N' ')YesPIN_OCREQ Allow NULL? 
24TEXRQTax Exemption Requestedchar10CHAR(N' ')YesPIN_TEXRQ Allow NULL? 
25WRKIDWork item IDnvarchar120NUMC(N'000000000000')Yes*SWW_WIID Allow NULL? 
26OCPVDOffcycle Providedchar10CHAR(N' ')YesPIN_OCPVD Allow NULL? 
27DCLAGDeclaration Agreementchar10CHAR(N' ')YesPIN_DCLAG Allow NULL? 
28ERRFGError Flagchar10CHAR(N' ')YesPIN_ERRFG Allow NULL? 
29ERRNOMessage numbernvarchar30CHAR(N' ')Yes*MSGNR Allow NULL? 
30APUIDLast / Latest Approver User IDnvarchar120CHAR(N' ')YesPIN_USRID Allow NULL? 
31APLVLApprover Levelnvarchar20CHAR(N' ')YesPIN_APLVL Allow NULL? 
32APGRPApprover Groupnvarchar150CHAR(N' ')YesPIN_APRVR_GRP Allow NULL? 
33LCUIDLast Change By User IDnvarchar120CHAR(N' ')YesPIN_LCUID Allow NULL? 
34LCHDTLast Change Datenvarchar80DATS(N'00000000')YesPIN_LCHDT Allow NULL? 
35LCHTMLast Change Timenvarchar60TIMS(N'000000')YesPIN_LCHTM Allow NULL? 
36ISMSTMail Sentchar10CHAR(N' ')YesPIN_ISMST Allow NULL? 
37EEMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
38APMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
39ADMOBSAPoffice: ID of a SAPoffice objectnvarchar170CHAR(N' ')YesSO_OBJ_ID Allow NULL? 
40SCMCDLTC Scheme Codenvarchar40CHAR(N' ')YesPIN_LTC_SCHEME_CODE Allow NULL? 
41PCLMDPartial Claimchar10CHAR(N' ')YesPIN_PARTIALLY_CLAIM Allow NULL? 
42ISCMPTrip Completedchar10CHAR(N' ')YesPIN_IS_COMPLETED Allow NULL? 
43PRTNOPart Numbernvarchar20NUMC(N'00')YesPIN_PART_NUMBER Allow NULL? 
44TRPNOObject Identificationnvarchar20CHAR(N' ')YesOBJPS Allow NULL? 
45BEGDALTC Block Begin Datenvarchar80DATS(N'00000000')YesPIN_LTC_BEGDA Allow NULL? 
46ENNDALTC Block End Datenvarchar80DATS(N'00000000')YesPIN_LTC_ENDDA Allow NULL? 
NamePrimaryUniqueTypeColumns
T77WWW_CLTRANSD~0YesYesCLUSTEREDSRTFD, 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