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  | SOSU
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Basis Services Communication Interfaces :: Use Subcomponents
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SOSU612SAPoffice: Substitute for a userUse Subcomponents
SQL:  selectupdate insert create

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

SELECT MANDT, USRTP, USRYR, USRNO, SUBTP, SUBYR, SUBNO, SUCNT, SBDAT, SBTIM, SEDAT, SETIM, PSTHR1, PSTHR2, AUTINT, AUTEXT, AUSER, PUBDL, BCOPY, OBJAPR, OBJACO, OBJACC, OBJAFC, AUANS, RESUB, AUSSL, PUFOL, PROTI, PROTO, PROT1, PROT2, PROT3, PROT4, PROT5, PROT6, PROT7, PROT8, PROT9, OBJTP1, OBJYR1, OBJNO1, OBJTP2, OBJYR2, OBJNO2, OBJTP3, OBJYR3, OBJNO3, FLAG0, FLAG1, FLAG2, FLAG3, FLAG4, FLAG5, FLAG6, FLAG7, FLAG8, FLAG9, AUTFW, AUTFW1, COMART, LFDNR FROM SOSU
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2USRTPUser type from IDnvarchar30 Allow NULL? 
3USRYRUser year from the IDnvarchar20 Allow NULL? 
4USRNOUser number from the IDnvarchar120 Allow NULL? 
5SUBTPSubstitute type from IDnvarchar30 Allow NULL? 
6SUBYRSubstitute year from the IDnvarchar20 Allow NULL? 
7SUBNOSubstitute: Number from IDnvarchar120 Allow NULL? 
8SUCNTCounter for active periods of a substitutenvarchar20 Allow NULL? 
9SBDATStart date for substitution or automatic forwardingnvarchar80 Allow NULL? 
10SBTIMTime at which substitution or forwarding beginsnvarchar60 Allow NULL? 
11SEDATEnd date for substitution or automatic forwardingnvarchar80 Allow NULL? 
12SETIMTime at which substitution or automatic forwarding endsnvarchar60 Allow NULL? 
13PSTHR1Functional substitute: Forward and deletechar10 Allow NULL? 
14PSTHR2Automatic forwarding without deletionchar10 Allow NULL? 
15AUTINTAuthorization: send internallychar10 Allow NULL? 
16AUTEXTAuthorization to send externallychar10 Allow NULL? 
17AUSERSubstitute can maintain userchar10 Allow NULL? 
18PUBDLSubstitute: Maintain shared distribution listschar10 Allow NULL? 
19BCOPYSubstitute can access blind copieschar10 Allow NULL? 
20OBJAPRSubstitute can access private objectschar10 Allow NULL? 
21OBJACOSubstitute can access confidential objectschar10 Allow NULL? 
22OBJACCSubstitute can access company confidential objectschar10 Allow NULL? 
23OBJAFCSubstitute can access functional objectschar10 Allow NULL? 
24AUANSSubstitute can access automatic replieschar10 Allow NULL? 
25RESUBSubstitute can access resubmissionschar10 Allow NULL? 
26AUSSLSubstitute can access subscription listchar10 Allow NULL? 
27PUFOLAuthorization: Shared folderschar10 Allow NULL? 
28PROTISubstitute can access the inboxchar10 Allow NULL? 
29PROTOSubstitute can access the outboxchar10 Allow NULL? 
30PROT1Substitute can access class 1 folderschar10 Allow NULL? 
31PROT2Substitute can access class 2 folderschar10 Allow NULL? 
32PROT3Substitute can access class 3 folderschar10 Allow NULL? 
33PROT4Substitute can access class 4 folderschar10 Allow NULL? 
34PROT5Substitute can access class 5 folderschar10 Allow NULL? 
35PROT6Substitute can access class 6 folderschar10 Allow NULL? 
36PROT7Substitute can access class 7 folderschar10 Allow NULL? 
37PROT8Substitute can access class 8 folderschar10 Allow NULL? 
38PROT9Substitute can access class 9 folderschar10 Allow NULL? 
39OBJTP1Substitute: Additional folder auth. - object type from IDnvarchar30 Allow NULL? 
40OBJYR1Substitute: Additional folder auth. - year from IDnvarchar20 Allow NULL? 
41OBJNO1Substitute: Additional folder auth. - number from the IDnvarchar120 Allow NULL? 
42OBJTP2Substitute: Note - object type from IDnvarchar30 Allow NULL? 
43OBJYR2Substitute: Note - year from IDnvarchar20 Allow NULL? 
44OBJNO2Substitute: Note number from the IDnvarchar120 Allow NULL? 
45OBJTP3Substitute: Alternative object type from IDnvarchar30 Allow NULL? 
46OBJYR3Substitute: Alternative year from IDnvarchar20 Allow NULL? 
47OBJNO3Substitute: Alternative number from IDnvarchar120 Allow NULL? 
48FLAG0Authorization for private folderschar10 Allow NULL? 
49FLAG1Forward all documents automaticallychar10 Allow NULL? 
50FLAG2Substitute: Flag 2char10 Allow NULL? 
51FLAG3Substitute: Flag 3char10 Allow NULL? 
52FLAG4Substitute: Flag 4char10 Allow NULL? 
53FLAG5Substitute: Flag 5char10 Allow NULL? 
54FLAG6Substitute: Flag 6char10 Allow NULL? 
55FLAG7Substitute: Flag 7char10 Allow NULL? 
56FLAG8Substitute: Flag 8char10 Allow NULL? 
57FLAG9Substitute: Flag 9char10 Allow NULL? 
58AUTFWSAPoffice: Automatic forwardingchar10 Allow NULL? 
59AUTFW1SAPoffice: Automatic forwarding and deletion in inboxchar10 Allow NULL? 
60COMARTSAPoffice: Communication methodnvarchar30 Allow NULL? 
61LFDNRAddresses: Sequence numbernvarchar30 Allow NULL? 
NamePrimaryUniqueTypeColumns
SOSU~0YesYesCLUSTEREDSUCNT, SUBNO, SUBYR, SUBTP, USRNO, USRYR, USRTP, MANDT
SOSU~VNoNoNONCLUSTEREDSUBTP, SUBYR, SUBNO

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