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  | /ISDFPS/ALE_SYS
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Defense Forces and Public Security :: Basis Technology R3 :: Distributed System Landscape
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/ISDFPS/ALE_SYS321DFPS System Landscape: Connection Parameters and FlagsDistributed System Landscape
SQL:  selectupdate insert create

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

SELECT LOGSYS, PLAN_CON_MODE, CENTRAL_SYS, RFCDEST, DELTA_T, N_MAX_REPEAT_T, DELTA_O, DELTA_S, M_MAX_REPEAT_S, DELTA_ALE_IP, DELTA_ALE_IP_UPS, HANDLE_SYNC, PING_COUNT, PING_TIMEOUT, PING_MAX_LOSS, TRANSPORT_DEST, TR_FTP_HOST, TR_FTP_PW, STATE_INFO_DEST, GNR_ADMIN_DEST, USER_ADMIN_DEST, CUA_SYS, APPL_TYPE, USER_DIST, ADD_ACTGROUPS, US_FILTER, ASSIGN_ACTGROUPS, ASSIGN_PROFILES, ALE_ROUTING_SYS, EH_ORG_TYPE, EH_ORG_PLVAR, EH_ORG_UNIT FROM /ISDFPS/ALE_SYS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1LOGSYSLogical Systemnvarchar100CHAR(N' ')NoTBDLS/ISDFPS/LOGSYS Allow NULL? 
2PLAN_CON_MODEALE System Typenvarchar70CHAR(N' ')Yes/ISDFPS/ALE_CONNECTION_MODE Allow NULL? 
3CENTRAL_SYSCentral Systemnvarchar100CHAR(N' ')Yes/ISDFPS/ALE_SYS/ISDFPS/ALE_CENTRAL_SYSTEM Allow NULL? 
4RFCDESTRFC Destinationnvarchar320CHAR(N' ')YesRFCDES/ISDFPS/SYNC_RFCDEST Allow NULL? 
5DELTA_TTRFC: Time between repeat attemptsnvarchar40CHAR(N' ')YesBTCDELAY_D Allow NULL? 
6N_MAX_REPEAT_TTRFC: Connection attempt up to tasknvarchar30CHAR(N' ')YesBTCTRIES Allow NULL? 
7DELTA_ODelta Onvarchar20NUMC(N'00')Yes/ISDFPS/ALE_DELTA_O Allow NULL? 
8DELTA_SDelta Snvarchar20NUMC(N'00')Yes/ISDFPS/ALE_DELTA_S Allow NULL? 
9M_MAX_REPEAT_SRetriesnvarchar50NUMC(N'00000')Yes/ISDFPS/ALE_REPEAT_COUNT Allow NULL? 
10DELTA_ALE_IPDelta ALE In-Processingnvarchar20NUMC(N'00')Yes/ISDFPS/ALE_DELTA_INPROC Allow NULL? 
11DELTA_ALE_IP_UPSDelta ALE In-Processing After UPSnvarchar20NUMC(N'00')Yes/ISDFPS/ALE_DELTA_INPROC_UPS Allow NULL? 
12HANDLE_SYNCSynchronizechar10CHAR(N' ')Yes/ISDFPS/SYNC_FLAG Allow NULL? 
13PING_COUNTNumber of PINGsnvarchar50NUMC(N'00000')Yes/ISDFPS/PING_COUNT Allow NULL? 
14PING_TIMEOUTPING Timeoutnvarchar50NUMC(N'00000')Yes/ISDFPS/PING_TIMEOUT Allow NULL? 
15PING_MAX_LOSSPING Lossnvarchar30NUMC(N'000')Yes/ISDFPS/PING_LOSS Allow NULL? 
16TRANSPORT_DESTRFC Destination for Transportsnvarchar320CHAR(N' ')YesRFCDES/ISDFPS/TRSP_RFCDEST Allow NULL? 
17TR_FTP_HOSTHost Namenvarchar1000CHAR(N' ')Yes/ISDFPS/HOSTNAME Allow NULL? 
18TR_FTP_PWTransport Passwordnvarchar300CHAR(N' ')Yes/ISDFPS/TR_FTP_PW Allow NULL? 
19STATE_INFO_DESTRFC Destination for Status Informationnvarchar320CHAR(N' ')Yes*/ISDFPS/STATE_INFO_RFCDEST Allow NULL? 
20GNR_ADMIN_DESTRFC Destination for Number Range Checknvarchar320CHAR(N' ')YesRFCDES/ISDFPS/GNR_RFCDEST Allow NULL? 
21USER_ADMIN_DESTRFC Destination for Central User Administrationnvarchar320CHAR(N' ')YesRFCDES/ISDFPS/USER_RFCDEST Allow NULL? 
22CUA_SYSCUA Central Systemnvarchar100CHAR(N' ')YesTBDLS/ISDFPS/CUA_CENTRAL_SYSTEM Allow NULL? 
23APPL_TYPESystem Typenvarchar30CHAR(N' ')Yes/ISDFPS/APPL_TYPE Allow NULL? 
24USER_DISTUser Distribution: Statuschar10CHAR(N' ')Yes/ISDFPS/USER_DIST Allow NULL? 
25ADD_ACTGROUPSUser Distribution: Additional Roleschar10CHAR(N' ')Yes/ISDFPS/ADD_AGR Allow NULL? 
26US_FILTERUser Distribution: User Filterchar10CHAR(N' ')Yes/ISDFPS/US_FILTER Allow NULL? 
27ASSIGN_ACTGROUPSAssign Roles to Userschar10CHAR(N' ')Yes/ISDFPS/ASSIGN_AGR Allow NULL? 
28ASSIGN_PROFILESAssign Profiles to Userschar10CHAR(N' ')Yes/ISDFPS/ASSIGN_PROF Allow NULL? 
29ALE_ROUTING_SYSALE Routing Systemnvarchar100CHAR(N' ')Yes*/ISDFPS/ALE_ROUTING_SYSTEM Allow NULL? 
30EH_ORG_TYPEObject Typenvarchar20CHAR(N' ')Yes*OTYPE Allow NULL? 
31EH_ORG_PLVARPlan Versionnvarchar20CHAR(N' ')Yes*PLVAR Allow NULL? 
32EH_ORG_UNITPerson Responsible for Error Handlingnvarchar120CHAR(N' ')Yes/ISDFPS/ORG_UNIT_ERR_HANDLING Allow NULL? 
NamePrimaryUniqueTypeColumns
/ISDFPS/ALE_SYS~0YesYesCLUSTEREDLOGSYS

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