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
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2USRTPUser type from IDnvarchar30CHAR(N' ')NoTSOTDSO_USR_TP Allow NULL? 
3USRYRUser year from the IDnvarchar20CHAR(N' ')NoSO_USR_YR Allow NULL? 
4USRNOUser number from the IDnvarchar120CHAR(N' ')No*SO_USR_NO Allow NULL? 
5SUBTPSubstitute type from IDnvarchar30CHAR(N' ')NoTSOTDSO_SUB_TP Allow NULL? 
6SUBYRSubstitute year from the IDnvarchar20CHAR(N' ')NoSO_SUB_YR Allow NULL? 
7SUBNOSubstitute: Number from IDnvarchar120CHAR(N' ')No*SO_SUB_NO Allow NULL? 
8SUCNTCounter for active periods of a substitutenvarchar20NUMC(N'00')NoSO_SUCNT Allow NULL? 
9SBDATStart date for substitution or automatic forwardingnvarchar80DATS(N'00000000')YesSO_DAT_SB Allow NULL? 
10SBTIMTime at which substitution or forwarding beginsnvarchar60TIMS(N'000000')YesSO_TIM_SB Allow NULL? 
11SEDATEnd date for substitution or automatic forwardingnvarchar80DATS(N'00000000')YesSO_DAT_SE Allow NULL? 
12SETIMTime at which substitution or automatic forwarding endsnvarchar60TIMS(N'000000')YesSO_TIM_SE Allow NULL? 
13PSTHR1Functional substitute: Forward and deletechar10CHAR(N' ')YesSO_PSTHR1 Allow NULL? 
14PSTHR2Automatic forwarding without deletionchar10CHAR(N' ')YesSO_PSTHR2 Allow NULL? 
15AUTINTAuthorization: send internallychar10CHAR(N' ')YesSO_AUT_INT Allow NULL? 
16AUTEXTAuthorization to send externallychar10CHAR(N' ')YesSO_AUT_EXT Allow NULL? 
17AUSERSubstitute can maintain userchar10CHAR(N' ')YesSO_AUSER Allow NULL? 
18PUBDLSubstitute: Maintain shared distribution listschar10CHAR(N' ')YesSO_PUBDL Allow NULL? 
19BCOPYSubstitute can access blind copieschar10CHAR(N' ')YesSO_BCOPY Allow NULL? 
20OBJAPRSubstitute can access private objectschar10CHAR(N' ')YesSO_OBJA_PR Allow NULL? 
21OBJACOSubstitute can access confidential objectschar10CHAR(N' ')YesSO_OBJA_CO Allow NULL? 
22OBJACCSubstitute can access company confidential objectschar10CHAR(N' ')YesSO_OBJA_CC Allow NULL? 
23OBJAFCSubstitute can access functional objectschar10CHAR(N' ')YesSO_OBJA_FC Allow NULL? 
24AUANSSubstitute can access automatic replieschar10CHAR(N' ')YesSO_AUANS Allow NULL? 
25RESUBSubstitute can access resubmissionschar10CHAR(N' ')YesSO_RESUB Allow NULL? 
26AUSSLSubstitute can access subscription listchar10CHAR(N' ')YesSO_AUSSL Allow NULL? 
27PUFOLAuthorization: Shared folderschar10CHAR(N' ')YesSO_PUFOL Allow NULL? 
28PROTISubstitute can access the inboxchar10CHAR(N' ')YesSO_PROTI Allow NULL? 
29PROTOSubstitute can access the outboxchar10CHAR(N' ')YesSO_PROTO Allow NULL? 
30PROT1Substitute can access class 1 folderschar10CHAR(N' ')YesSO_PROT1 Allow NULL? 
31PROT2Substitute can access class 2 folderschar10CHAR(N' ')YesSO_PROT2 Allow NULL? 
32PROT3Substitute can access class 3 folderschar10CHAR(N' ')YesSO_PROT3 Allow NULL? 
33PROT4Substitute can access class 4 folderschar10CHAR(N' ')YesSO_PROT4 Allow NULL? 
34PROT5Substitute can access class 5 folderschar10CHAR(N' ')YesSO_PROT5 Allow NULL? 
35PROT6Substitute can access class 6 folderschar10CHAR(N' ')YesSO_PROT6 Allow NULL? 
36PROT7Substitute can access class 7 folderschar10CHAR(N' ')YesSO_PROT7 Allow NULL? 
37PROT8Substitute can access class 8 folderschar10CHAR(N' ')YesSO_PROT8 Allow NULL? 
38PROT9Substitute can access class 9 folderschar10CHAR(N' ')YesSO_PROT9 Allow NULL? 
39OBJTP1Substitute: Additional folder auth. - object type from IDnvarchar30CHAR(N' ')YesTSOTDSO_SUTP1 Allow NULL? 
40OBJYR1Substitute: Additional folder auth. - year from IDnvarchar20CHAR(N' ')YesSO_SUYR1 Allow NULL? 
41OBJNO1Substitute: Additional folder auth. - number from the IDnvarchar120CHAR(N' ')Yes*SO_SUNO1 Allow NULL? 
42OBJTP2Substitute: Note - object type from IDnvarchar30CHAR(N' ')YesTSOTDSO_SUTP2 Allow NULL? 
43OBJYR2Substitute: Note - year from IDnvarchar20CHAR(N' ')YesSO_SUYR2 Allow NULL? 
44OBJNO2Substitute: Note number from the IDnvarchar120CHAR(N' ')Yes*SO_SUNO2 Allow NULL? 
45OBJTP3Substitute: Alternative object type from IDnvarchar30CHAR(N' ')YesTSOTDSO_SUTP3 Allow NULL? 
46OBJYR3Substitute: Alternative year from IDnvarchar20CHAR(N' ')YesSO_SUYR3 Allow NULL? 
47OBJNO3Substitute: Alternative number from IDnvarchar120CHAR(N' ')Yes*SO_SUNO3 Allow NULL? 
48FLAG0Authorization for private folderschar10CHAR(N' ')YesSO_SUFLAG0 Allow NULL? 
49FLAG1Forward all documents automaticallychar10CHAR(N' ')YesSO_SUFLAG1 Allow NULL? 
50FLAG2Substitute: Flag 2char10CHAR(N' ')YesSO_SUFLAG2 Allow NULL? 
51FLAG3Substitute: Flag 3char10CHAR(N' ')YesSO_SUFLAG3 Allow NULL? 
52FLAG4Substitute: Flag 4char10CHAR(N' ')YesSO_SUFLAG4 Allow NULL? 
53FLAG5Substitute: Flag 5char10CHAR(N' ')YesSO_SUFLAG5 Allow NULL? 
54FLAG6Substitute: Flag 6char10CHAR(N' ')YesSO_SUFLAG6 Allow NULL? 
55FLAG7Substitute: Flag 7char10CHAR(N' ')YesSO_SUFLAG7 Allow NULL? 
56FLAG8Substitute: Flag 8char10CHAR(N' ')YesSO_SUFLAG8 Allow NULL? 
57FLAG9Substitute: Flag 9char10CHAR(N' ')YesSO_SUFLAG9 Allow NULL? 
58AUTFWSAPoffice: Automatic forwardingchar10CHAR(N' ')YesSO_AUTFOR Allow NULL? 
59AUTFW1SAPoffice: Automatic forwarding and deletion in inboxchar10CHAR(N' ')YesSO_AUTFOR1 Allow NULL? 
60COMARTSAPoffice: Communication methodnvarchar30CHAR(N' ')YesSO_COM_ART Allow NULL? 
61LFDNRAddresses: Sequence numbernvarchar30CHAR(N' ')YesSO_LFDNR 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