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

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

66 columns | Print definition?ERP 6.0  | ACTION_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_SGX_WGNTCustomizing for the Functions3ACTION_TYPEFunction Typenvarchar40
2/SAPSRM/C_SW_WDTable to switch Web-Dynpro UI Elements6ACTION_TYPEPossible Switch Actions for Web Dynpro View UI Elementsnvarchar10
3/SAPSRM/C_VIEW_MTable to switch FPM Main View7ACTION_TYPEPossible Switch Actions for Web Dynpro View UI Elementsnvarchar10
4/SAPSRM/C_VIEW_STable to switch FPM Sub View7ACTION_TYPEPossible Switch Actions for Web Dynpro View UI Elementsnvarchar10
5/SAPSRM/C_VIEW_UTable to switch UIBB12ACTION_TYPEPossible Switch Actions for Web Dynpro View UI Elementsnvarchar10
6/SLOAP/DOWNUPLOGDownload / upload log3ACTION_TYPEAction type for download / upload lognvarchar10
7CNV_DOWNUP_LOGDownload / upload log3ACTION_TYPEAction type for download / upload lognvarchar10
8CNV_MBT_ACT_RECActivity record - info about DMIS DEL Activities3ACTION_TYPEAction Typesnvarchar10
9GRFNPOLICYRACMNTReviewer and approver comments of Policy object (Policy Ver.5ACTION_TYPEPolicy Action Typenvarchar100
10RSBPCB_ACTIONBPC: Activity action9ACTION_TYPEBPC: Action typenvarchar10
11TLRT_TARO_ADMTrade Repository Object Administrative Data12ACTION_TYPEAction Typenvarchar20
TOPAP-LIM Logistics Inventory Management Engine
12/LIME/COLL_APSCollection for Planning System23ACTION_TYPELIME-Line Category (Internal)nvarchar20
13/LIME/COLL_BWCollection for Business Warehouse23ACTION_TYPELIME-Line Category (Internal)nvarchar20
14/LIME/COLL_FINCollection for Financial System23ACTION_TYPELIME-Line Category (Internal)nvarchar20
15/LIME/COLL_INVCollection for Inventory System23ACTION_TYPELIME-Line Category (Internal)nvarchar20
16/LIME/COLL_LEGCollection for External System23ACTION_TYPELIME-Line Category (Internal)nvarchar20
17/LIME/COLL_MMIMCollection for R/3 Inventory Management23ACTION_TYPELIME-Line Category (Internal)nvarchar20
18/LIME/COLL_W2IMCollection for WME after ERP-MMIM23ACTION_TYPELIME-Line Category (Internal)nvarchar20
TOPAuto-ID Infrastructure
19/AIN/ACTTYPEAction Type2ACTION_TYPEAction Typenvarchar40
20/AIN/ACTTYPEBPRelation of Action Type to Business Process, Device Role2ACTION_TYPEAction Typenvarchar40
21/AIN/ACTTYPETAction Type description text table2ACTION_TYPEAction Typenvarchar40
22/AIN/DM_ACTIONAction3ACTION_TYPEAction Typenvarchar40
23/AIN/DM_ACT_OBJAction object4ACTION_TYPEAction Typenvarchar40
24/AIN/DM_ATBPRelation of Action Type to Business Process3ACTION_TYPEAction Typenvarchar40
25/AIN/DM_ATDGRRelation of Action Type to Device Group Role3ACTION_TYPEAction Typenvarchar40
26/AIN/DM_DOCTable with Document information.6ACTION_TYPEAction Typenvarchar40
27/AIN/DM_DOC_STADocument status3ACTION_TYPEAction Typenvarchar40
28/AIN/DM_UE_NOTEAnnotation for unexpected events7ACTION_TYPEAction Typenvarchar40
29/AIN/TCONDBMCondition table for Backend Messages3ACTION_TYPEAction Typenvarchar40
30/AIN/TCONDBMSCondition table for Backend Messages2ACTION_TYPEAction Typenvarchar40
31/AIN/TCONDBMTText table for /AIN/TCONDBM4ACTION_TYPEAction Typenvarchar40
32/AIN/TCONDBMTSText table for /AIN/TCONDBMS3ACTION_TYPEAction Typenvarchar40
33/AIN/TCONDMMCondition table for Mobile Messages3ACTION_TYPEAction Typenvarchar40
34/AIN/TCONDMMSCondition table for Mobile Messages2ACTION_TYPEAction Typenvarchar40
35/AIN/TCONDMMTText table for Mobile Message condition table4ACTION_TYPEAction Typenvarchar40
36/AIN/TCONDMMTSText table for Mobile Message condition table3ACTION_TYPEAction Typenvarchar40
37/AIN/TDOCASSIGNTable for document <-> device group assignments5ACTION_TYPEAction Typenvarchar40
38/AIN/TU_ERR_MAPAutoID Mapping Vendor Specific Error to Namespace4ACTION_TYPEAction Typenvarchar10
TOPBRFplus - ABAP-Based Business Rules
39FDT_EXTY_0000FDT: Expression Type Data7ACTION_TYPEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
40FDT_EXTY_0000AFDT: Expression Type Data7ACTION_TYPEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
41FDT_EXTY_0000SFDT: Expression Type Data6ACTION_TYPEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
42FDT_EXTY_0000TFDT: Expression Type Data6ACTION_TYPEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPBrowser-Based PI Sheet Cockpit
43POC_DB_C_TRIGGERDomain Model: Trigger Collection8ACTION_TYPEAction in PI Sheet (Execute, Hide, Show)nvarchar300
TOPClinical System
44N2GL_BASEITEMIS-H*MED: Basic Item of Treatment Pathway6ACTION_TYPEAction Typenvarchar100
45N2GL_TM_STEPpathways Step of Patient Pathway20ACTION_TYPEAction Typenvarchar100
TOPCollaboration Folders
46CFS_STAT_ACTIONCFS: Actions for Status4ACTION_TYPEAction Type at Status(Transition)nvarchar320
47CFS_TRANS_ACTIONCFS: Actions for Status Transitions5ACTION_TYPEAction Type at Status(Transition)nvarchar320
48CFX_NTF_ACTIONStatus Managment: Action: Send a Notification3ACTION_TYPEAction Type at Status(Transition)nvarchar320
49CFX_REMIND_QUEUECFX: Queue for Reminder Actions for Status Management4ACTION_TYPEAction Type at Status(Transition)nvarchar320
TOPExternal personnel administration
50T7RSM00APProcess external personnel action types3ACTION_TYPEAction Typenvarchar20
TOPFSCM In-House Cash
51IHC_TAB_XBS_TTIHC: Transaction Type External Inbound Payment8ACTION_TYPEIHC action on uploading a bank statementnvarchar20
TOPGuided Structure Synchronization
52/PLMB/GSS_ACTIRegistration of Action Types1ACTION_TYPEAction Typenvarchar40
53/PLMB/GSS_ACTITAction Type Description2ACTION_TYPEAction Typenvarchar40
54/PLMB/GSS_CONACTAssignment between Conflict and Action Types4ACTION_TYPEAction Typenvarchar40
TOPMusing Tools
55WDKQACTIONSInfoSet Query specific POWL actions3ACTION_TYPEInfoSet Query POWL action typenvarchar10
TOPPayment Transactions
56FPRL_LOGList Log14ACTION_TYPEAction Typenvarchar10
TOPSoftware Agent Framework
57CRMC_SAF_WP_ACTSAF: Actions for work package4ACTION_TYPESAF: Action type for work packagenvarchar100
TOPSuite Inbox
58IBO_C_WF_ACCActions of Inbox4ACTION_TYPEAction Type of Inbox Actionnvarchar400
59IBO_C_WF_ACSActions of Inbox4ACTION_TYPEAction Type of Inbox Actionnvarchar400
TOPTravel Planning
60FTPT_IMRIMR - General Information11ACTION_TYPEnvarchar40
TOPUnique Identification
61IUID_MAN_DATAManually Maintained Values for IUID Messages48ACTION_TYPEAction Typenvarchar30
62IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration48ACTION_TYPEAction Typenvarchar30
TOPWeb Screen Tools - ABAP
63WDY_CTLR_COMPOWeb Dynpro: Methods/Events of a Controller16ACTION_TYPEWeb Dynpro: Action Typenvarchar10
TOPWithout Description
64RSACTION2EVIDMapping of Action types to Event IDs1ACTION_TYPEBW Statistics: Type of processing step WHMnvarchar30
TOPWorkforce Management Application
65WFACS_REQACTIONSrequest actions6ACTION_TYPEaction regarding a calculationtinyint30
TOPWorkforce Management Core
66WFDCS_REQACTIONSrequest actions6ACTION_TYPEaction regarding a calculationtinyint30