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

78 columns | Print definition?ERP 6.0  | PARAMETER_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTCPARAMPIFD Concrete Parameters for a Variant3PARAMETER_IDPIFD Parameter IDnvarchar320
2CNVMBTIFPARAMWCAdditional settings for PIFD objects in the Work Center3PARAMETER_IDPIFD Parameter IDnvarchar320
3DBA_ALRT_MET_CDBA: Alerting Metric Components7PARAMETER_IDntext10737418230
4FDT_DDBV_0012BRFplus: Dynamic Database View - Input Parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
5FDT_DDBV_0012ABRFplus: Dynamic Database View - Input Parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
6FDT_DDBV_0012SBRFplus: Dynamic Database View - Input Parameters4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
7FDT_DDBV_0012TBRFplus: Dynamic Database View - Input Parameters4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
8FDT_DDBV_0020BRFplus: Dynamic Database View - Result Field Definition6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
9FDT_DDBV_0020ABRFplus: Dynamic Database View - Result Field Definition6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
10FDT_DDBV_0020SBRFplus: Dynamic Database View - Result Field Definition5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
11FDT_DDBV_0020TBRFplus: Dynamic Database View - Result Field Definition5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
12FDT_EXPR_2203FDT: Expression - DB Lookup(Parameter Binding)6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
13FDT_EXPR_2203AFDT: Expression - DB Lookup(Parameter Binding)6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
14FDT_EXPR_2203SFDT: Expression - DB Lookup(Parameter Binding)5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
15FDT_EXPR_2203TFDT: Expression - DB Lookup(Parameter Binding)5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
16GRACPARAMDETAILTable to get the details of Paramater id3PARAMETER_IDParameter IDnvarchar200
17GRACREQUSERPARAMObselete -- Request User Parameters4PARAMETER_IDParameter IDnvarchar200
18GRACREQUSERPRMRequest User Parameters4PARAMETER_IDParameter IDnvarchar200
19LTR_FDEF_PARAMLTR: Function - Parameters2PARAMETER_IDLTR: Function Parameter IDnvarchar320
20LTR_KEYC_IUSGLTR: Key Component Usages in Intransparent Fields5PARAMETER_IDLTR: Function Parameter IDnvarchar320
21LTR_KEYC_USG_PLTR: Key Component - Intransparent Function Params.4PARAMETER_IDLTR: Function Parameter IDnvarchar320
22TCGLABBCPAREHS: Assignment Bar Code - Parameter3PARAMETER_IDParameters for Bar Codes and Sequence Numbersnvarchar400
23TCGLABPAREHS: Parameter2PARAMETER_IDParameters for Bar Codes and Sequence Numbersnvarchar400
24TCGLABSQNPAREHS: Assignment of Sequence Number - Parameter3PARAMETER_IDParameters for Bar Codes and Sequence Numbersnvarchar400
TOPBRFplus - ABAP-Based Business Rules
25FDT_ACTN_1210FDT: Action - Start workflow container data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
26FDT_ACTN_1210AFDT: Action - Start workflow container data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
27FDT_ACTN_1210SFDT: Action - Start workflow container data5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
28FDT_ACTN_1210TFDT: Action - Start workflow container data5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
29FDT_ACTN_1220FDT: Action - Start workflow BOR data7PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
30FDT_ACTN_1220AFDT: Action - Start workflow BOR data7PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
31FDT_ACTN_1220SFDT: Action - Start workflow BOR data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
32FDT_ACTN_1220TFDT: Action - Start workflow BOR data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
33FDT_ACTN_1310FDT: Action - Raise BOR event data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
34FDT_ACTN_1310AFDT: Action - Raise BOR event data6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
35FDT_ACTN_1310SFDT: Action - Raise BOR event data5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
36FDT_ACTN_1310TFDT: Action - Raise BOR event data5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
37FDT_ACTN_1410FDT: Action - Call BadI parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
38FDT_ACTN_1410AFDT: Action - Call BadI parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
39FDT_ACTN_1410SFDT: Action - Call BadI parameters4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
40FDT_ACTN_1410TFDT: Action - Call BadI parameters4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
41FDT_EXPR_1700FDT: Expression - Dynamic Expression Call5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
42FDT_EXPR_1700AFDT: Expression - Dynamic Expression Call5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
43FDT_EXPR_1700SFDT: Expression - Dynamic Expression Call4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
44FDT_EXPR_1700TFDT: Expression - Dynamic Expression Call4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
45FDT_EXPR_2101FDT: Expression - XSL Transformation (parameter)4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
46FDT_EXPR_2101AFDT: Expression - XSL Transformation (parameter)4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
47FDT_EXPR_2101SFDT: Expression - XSL Transformation (parameter)3PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
48FDT_EXPR_2101TFDT: Expression - XSL Transformation (parameter)3PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
49FDT_EXPR_4002OBSOLETE - DO NOT USE4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
50FDT_EXPR_4002AOBSOLETE - DO NOT USE4PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
51FDT_EXPR_4002SOBSOLETE - DO NOT USE3PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
52FDT_EXPR_4002TOBSOLETE - DO NOT USE3PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
53FDT_EXPR_4003FDT: BRMS Connector Call Parameters6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
54FDT_EXPR_4003AFDT: BRMS Connector Call Parameters6PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
55FDT_EXPR_4003SFDT: BRMS Connector Call Parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
56FDT_EXPR_4003TFDT: BRMS Connector Call Parameters5PARAMETER_IDFDT: Universal Unique Identifiernvarchar320
TOPBusiness Context Viewer
57/BCV/C_QFPARQuery formula parameter4PARAMETER_IDParameter ID from BRFplus Elementnvarchar320
TOPData Mining
58RSDMTPN_PARA_DSCDescription of Service and parameters - Different Language2PARAMETER_IDService Parameter GUIDnvarchar300
59RSDMTP_PARAM_DSCDescription of Service and parameters - Different Language2PARAMETER_IDService Parameter GUIDnvarchar300
60RSDMTP_SRV_PARAMParameters required for the services2PARAMETER_IDService Parameter GUIDnvarchar300
TOPEnd User Technology
61RSDASSERVPARService Parameter of the Data Access Service5PARAMETER_IDID of a Parameter of a Data Access Servicenvarchar400
62RSRDE_DOC_ATTRDocuments for Broadcasting: Attributes3PARAMETER_IDParameter IDnvarchar300
TOPPerformance Monitors TCC
63ORA_HISTPARParameter values for oracle history collector1PARAMETER_IDOracle history: ID of history collector parameternvarchar20
TOPQuery Management
64/PLMPCV/D_QFPARQuery formula parameter4PARAMETER_IDParameter ID from BRFplus Elementnvarchar320
TOPSAP Business Workflow
65SWN_SETTINGSWF Notif: General Settings2PARAMETER_IDID of a Settings Parameternvarchar320
66SWN_SETTINGSSWF Notif: General Settings1PARAMETER_IDID of a Settings Parameternvarchar320
67SWN_SETTINGSSTWF Notif: General Settings, Texts1PARAMETER_IDID of a Settings Parameternvarchar320
68SWN_SETTINGSTWF Notif: General Settings, Texts2PARAMETER_IDID of a Settings Parameternvarchar320
69SWN_SUBSPARWF Notif: Subscription Parameters2PARAMETER_IDSubscription Parameter IDnvarchar320
70SWN_SUBSPARTWF Notif: Subscription Parameters, Texts2PARAMETER_IDSubscription Parameter IDnvarchar320
TOPSAP NetWeaver Mobile - Use subcomponents
71MEMGMT_CFG_VALUEConfiguration Data for Device Management4PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
72MEMGMT_PARAMETERParameters for the Configuration Service2PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
73MEMGMT_PARA_CONDPossible Parameter Values for a Parameter1PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
74MEMGMT_PARA_PATTParameter Patterns for the Parameters1PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
75MEMGMT_PARA_PROPDevice Configuration: Properties of a Parameter1PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
76MEMGMT_PARA_TEXTParameter Description for Device Management1PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
77MEMGMT_PARA_VALParameter Value for Device Configuration1PARAMETER_IDParameter ID for Monitoring Function Parameternvarchar120
TOPWorkbench Tools Editors, Painters, Modelers
78SADT_CT_DEVELFor development only3PARAMETER_IDSet/Get parameter IDnvarchar200