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  | SOPR
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
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
10OINM101Whse Journal
Basis Components :: Basis Services Communication Interfaces :: Use Subcomponents
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SOPR921SAPoffice: System-wide profileUse Subcomponents
SQL:  selectupdate insert create

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

SELECT MANDT, DELRE, DELRR, DELAC, DELREM, DELRRM, DELACM, IN_DEX, OBJENC, EXPIN, EXPEX, EXPNA, EXMAX, RCMAX, USRAU, INMAX, CRGDL, CRFCL, CRFCC, CRFPL, CRFDP, CRFAD, CRFGR, HOMAX, GLMAX, GFMAX, AUTEXT, NOTTP, CALEN, OUTFL, SQWIN, SYUSR, SYUSRINB, SYUSROUT, WSTYR, WSTNO, PFRYR, PFRNO, PDLYR, PDLNO, AFRYR, AFRNO, RSWORKDAY, RSFACID, USRADR, LFDNR, SNDART, FLAG1, FLAG2, FLAG3, NATIO, RFCDES, DEFEXP, LADAT, UNIX_DESTI, RETURN_ADR, EXTTELE, EXTSMTP, EXTX400, EXTSAP, NO_DIR_SND, NO_EXT_SND, NO_INT_SND, OUTEXP, EXTX500, UNX_CONFIG, DOC_LENGTH, RESUB_DATE, RESUB_TIME, RS_BATCHID, FAX_EXIST, TLX_EXIST, SMTP_EXIST, X400_EXIST, SAP_EXIST, X500_EXIST, ORG_EXIST, ARCH_EXIST, OBJ_EXIST, DIRADDRESS, ADDRBUFCLR, ADDRBUFINV, REORGDAILY, REMOTEDEST, REMOTENAME, REMOTECLNT, REMOTERELS, DISTRIB, MAIL_SYSID, MAIL_MANDT, MAIL_CLNT, IBND_UPD FROM SOPR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DELRESAPoffice: delete unviewed objectschar10CHAR(N' ')YesSO_DEL_RE Allow NULL? 
3DELRRSAPoffice: delete unanswered objectschar10CHAR(N' ')YesSO_DEL_RR Allow NULL? 
4DELACSAPoffice: delete ToDo objects - no action takenchar10CHAR(N' ')YesSO_DEL_AC Allow NULL? 
5DELREMSAPoffice: delete unviewed objects with messagechar10CHAR(N' ')YesSO_DEL_REM Allow NULL? 
6DELRRMSAPoffice: delete unanswered objects with messagechar10CHAR(N' ')YesSO_DEL_RRM Allow NULL? 
7DELACMSAPoffice: del. ToDo objects (no action taken) with messagechar10CHAR(N' ')YesSO_DEL_ACM Allow NULL? 
8IN_DEXSAPoffice: Indexing on/offchar10CHAR(N' ')YesSO_IN_DEX Allow NULL? 
9OBJENCObject: codedchar10CHAR(N' ')YesSO_OBJ_ENC Allow NULL? 
10EXPINNo notification of unviewed mails at logonchar10CHAR(N' ')YesSO_EXPIN Allow NULL? 
11EXPEXExecution of express messages in new sessionchar10CHAR(N' ')YesSO_EXPEX Allow NULL? 
12EXPNAName of exit routine for express messagesnvarchar400CHAR(N' ')YesSO_EXPNA Allow NULL? 
13EXMAXMaximum number of express messages allowed per sendvarbinary20RAWYesSO_EXMAX
14RCMAXMaximum number of recipients allowed per sendvarbinary20RAWYesSO_RCMAX
15USRAUMaintain user: only the administrator is authorizedchar10CHAR(N' ')YesSO_USRAU Allow NULL? 
16INMAXMaximum number of documents allowed in the inboxvarbinary20RAWYesSO_INMAX
17CRGDLAuthorization to create shared distribution listschar10CHAR(N' ')YesSO_CRGDL Allow NULL? 
18CRFCLAuthorization to create client folderschar10CHAR(N' ')YesSO_CRFCL Allow NULL? 
19CRFCCAuthorization to create company-code-wide folderschar10CHAR(N' ')YesSO_CRFCC Allow NULL? 
20CRFPLAuthorization to create plant-wide folderschar10CHAR(N' ')YesSO_CRFPL Allow NULL? 
21CRFDPAuthorization to create department-wide folderschar10CHAR(N' ')YesSO_CRFDP Allow NULL? 
22CRFADAuthorization to create cost-center-wide folderschar10CHAR(N' ')YesSO_CRFAD Allow NULL? 
23CRFGRAuthorization to create group folderschar10CHAR(N' ')YesSO_CRFGR Allow NULL? 
24HOMAXMax. no. of documents a user can protect from archivingvarbinary10RAWYesSO_HOMAX
25GLMAXMaximum size of the access lists of a uservarbinary10RAWYesSO_GLMAX
26GFMAXMax. number of group folders which a user can createvarbinary10RAWYesSO_GFMAX
27AUTEXTAuthorization to send externallychar10CHAR(N' ')YesSO_AUT_EXT Allow NULL? 
28NOTTPDefault setting of document classnvarchar30CHAR(N' ')Yes*SO_NOT_TP Allow NULL? 
29CALENDay on which the week beginschar10CHAR(N' ')YesSO_CALEN Allow NULL? 
30OUTFLDocuments are copied to the outbox when sentchar10CHAR(N' ')YesSO_OUTFL Allow NULL? 
31SQWINSwitch confirmation prompt on or off when deletingchar10CHAR(N' ')YesSO_SQWIN Allow NULL? 
32SYUSRYour user view is set when you start SAPofficechar10CHAR(N' ')YesSO_SYUSR Allow NULL? 
33SYUSRINBInbox filter (unviewed documents only)char10CHAR(N' ')YesSO_SYUSRIN Allow NULL? 
34SYUSROUTSAPoffice: Storage informationchar10CHAR(N' ')YesSO_CONT Allow NULL? 
35WSTYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
36WSTNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
37PFRYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
38PFRNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
39PDLYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
40PDLNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
41AFRYRObject: Year from IDnvarchar20CHAR(N' ')YesSO_OBJ_YR Allow NULL? 
42AFRNOObject: Number from IDnvarchar120CHAR(N' ')Yes*SO_OBJ_NO Allow NULL? 
43RSWORKDAYResubmission on workdays onlychar10CHAR(N' ')YesSO_RSWD Allow NULL? 
44RSFACIDFactory calendar identification code for the resubmissionnvarchar20CHAR(N' ')YesTFACDSO_RSFACID Allow NULL? 
45USRADRNumber of internal company addressnvarchar100CHAR(N' ')YesSO_USRIADR Allow NULL? 
46LFDNRAddresses: Sequence numbernvarchar30CHAR(N' ')YesSO_LFDNR Allow NULL? 
47SNDARTText field length 3: for use as requirednvarchar30CHAR(N' ')YesSO_TEXT003 Allow NULL? 
48FLAG1Text field length 1char10CHAR(N' ')YesSO_TEXT001 Allow NULL? 
49FLAG2Text field length 1char10CHAR(N' ')YesSO_TEXT001 Allow NULL? 
50FLAG3Text field length 1char10CHAR(N' ')YesSO_TEXT001 Allow NULL? 
51NATIOSAPoffice: international code for character setchar10CHAR(N' ')Yes*SO_NATIO Allow NULL? 
52RFCDESRFC destination for SAPoffice servernvarchar320CHAR(N' ')Yes*SO_RFCDES Allow NULL? 
53DEFEXPDefault expiry time for documentnvarchar30NUMC(N'000')YesSO_DEFEXP Allow NULL? 
54LADATDefault for last access date (last changed)nvarchar30NUMC(N'000')YesSO_DEF_LAD Allow NULL? 
55UNIX_DESTISAPoffice: RFC destination of the UNIX mail servernvarchar320CHAR(N' ')YesSO_UNX_DES Allow NULL? 
56RETURN_ADRSAPoffice: UNIX address for this Office (UNIX server)nvarchar500CHAR(N' ')YesSO_RET_ADR Allow NULL? 
57EXTTELEAuthorization to send via telematic serviceschar10CHAR(N' ')YesSO_EXTTELE Allow NULL? 
58EXTSMTPAuthorization to send via the Internetchar10CHAR(N' ')YesSO_EXTSMTP Allow NULL? 
59EXTX400Authorization to send via X.400char10CHAR(N' ')YesSO_EXTX400 Allow NULL? 
60EXTSAPAuthorization to send within SAP system groupchar10CHAR(N' ')YesSO_EXTSAP Allow NULL? 
61NO_DIR_SNDDirect external sending is not allowed in this systemchar10CHAR(N' ')YesSO_NDRSND Allow NULL? 
62NO_EXT_SNDSending to an external address recipient type not allowedchar10CHAR(N' ')YesSO_NEXTSND Allow NULL? 
63NO_INT_SNDSend internally not allowed in this systemchar10CHAR(N' ')YesSO_NINTSND Allow NULL? 
64OUTEXPExpiration time for documents in outboxnvarchar30NUMC(N'000')YesSO_OUT_EXP Allow NULL? 
65EXTX500Authorization to access the LDAP serviceschar10CHAR(N' ')YesSO_EXTX500 Allow NULL? 
66UNX_CONFIGPath specification for a UNIX filenvarchar2410CHAR(N' ')YesSO_UNXCONF Allow NULL? 
67DOC_LENGTHQuery PC documents from this sizenvarchar120NUMC(N'000000000000')YesSO_MAX_LEN Allow NULL? 
68RESUB_DATEDate of next resubmissionnvarchar80DATS(N'00000000')YesSO_RES_DAT Allow NULL? 
69RESUB_TIMETime of next resubmission in systemnvarchar60TIMS(N'000000')YesSO_RES_TIM Allow NULL? 
70RS_BATCHIDID of the batch item supervising the resubmissionnvarchar120NUMC(N'000000000000')YesSO_RS_BTID Allow NULL? 
71FAX_EXISTConnection to fax communications componentchar10CHAR(N' ')YesSO_EX_FAX Allow NULL? 
72TLX_EXISTConnection to telex communications componentchar10CHAR(N' ')YesSO_EX_TLX Allow NULL? 
73SMTP_EXISTConnection to Internet Gatewaychar10CHAR(N' ')YesSO_EX_SMTP Allow NULL? 
74X400_EXISTConnection to X.400 componentchar10CHAR(N' ')YesSO_EX_X400 Allow NULL? 
75SAP_EXISTThe SAP system is part of a mail system groupchar10CHAR(N' ')YesSO_EX_SAP Allow NULL? 
76X500_EXISTLDAP service connectionchar10CHAR(N' ')YesSO_EX_X500 Allow NULL? 
77ORG_EXISTHR Org is connected and maintainedchar10CHAR(N' ')YesSO_EX_ORG Allow NULL? 
78ARCH_EXISTConnection to an archivechar10CHAR(N' ')YesSO_EX_ARCH Allow NULL? 
79OBJ_EXISTSend to Business Objectschar10CHAR(N' ')YesSO_EX_OBJ Allow NULL? 
80DIRADDRESSCompany address for direct addresses (empty or "unknown")nvarchar100CHAR(N' ')Yes*SO_DIR_ADR Allow NULL? 
81ADDRBUFCLRTime stamp for invalidation of buffered addressesnvarchar140NUMC(N'00000000000000')YesSO_ADBUFCL Allow NULL? 
82ADDRBUFINVNo. of hours (interval) before invalidation of addr. buffernvarchar40NUMC(N'0000')NoSO_ADBUFIV Allow NULL? 
83REORGDAILYSearch of private or shared folderschar10CHAR(N' ')YesSO_FLAG Allow NULL? 
84REMOTEDESTRFC destination for SAPoffice servernvarchar320CHAR(N' ')Yes*SO_RFCDES Allow NULL? 
85REMOTENAMEName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
86REMOTECLNTClient IDnvarchar30CLNT(N'000')Yes*SYMANDT Allow NULL? 
87REMOTERELSRelease of SAP Systemnvarchar40CHAR(N' ')YesSYSAPRL Allow NULL? 
88DISTRIBThis system is part of a system groupchar10CHAR(N' ')YesSO_DISTRIB Allow NULL? 
89MAIL_SYSIDName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
90MAIL_MANDTClient IDnvarchar30CLNT(N'000')Yes*SYMANDT Allow NULL? 
91MAIL_CLNTAddresses: Clientnvarchar30CHAR(N' ')YesSO_RML_MD Allow NULL? 
92IBND_UPDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
NamePrimaryUniqueTypeColumns
SOPR~0YesYesCLUSTEREDMANDT

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