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

70 columns | Print definition?ERP 6.0  | OPTIONS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/FC_TRNMTTransfer Method6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
2/CPD/FC_TSTRG_PITransfer Strategy and Plan Item Source6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
3/OPT/VIM_STR_DETShip-To-Region Maintenance7OPTIONSOptions for determining Regionnvarchar100
4GRFNJOBPOLSPSNPJob Step OLSP Snapshot9OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
5HRP5347DB Table for Infotype 534722OPTIONSSelection Table Optionnvarchar20
TOPAuthentication and SSO
6USRCERTRULEActive Rules for Rule-Based Certificate Logon9OPTIONSOptions for a Certificate Rulevarbinary40
TOPBRFplus - ABAP-Based Business Rules
7FDT_EXPR_0212FDT: Expression - Search Tree simpl. Ranges (Nodes)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
8FDT_EXPR_0212AFDT: Expression - Search Tree simpl. Ranges (Nodes)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
9FDT_EXPR_0212SFDT: Expression - Search Tree simpl. Ranges (Nodes)6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
10FDT_EXPR_0212TFDT: Expression - Search Tree simpl. Ranges (Nodes)6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
11FDT_EXPR_0231FDT: Expression - Decision Tree Simple Ranges (Nodes)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
12FDT_EXPR_0231AFDT: Expression - Decision Tree Simple Ranges (Nodes)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
13FDT_EXPR_0231SFDT: Expression - Decision Tree Simple Ranges (Nodes)6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
14FDT_EXPR_0231TFDT: Expression - Decision Tree Simple Ranges (Nodes)6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
15FDT_EXPR_0244FDT: Expression - Decision Table (implicit ranges)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
16FDT_EXPR_0244AFDT: Expression - Decision Table (implicit ranges)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
17FDT_EXPR_0244SFDT: Expression - Decision Table (implicit ranges)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
18FDT_EXPR_0244TFDT: Expression - Decision Table (implicit ranges)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
19FDT_EXPR_0247FDT: Decision Table Packed Values8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
20FDT_EXPR_0247AFDT: Decision Table Packed Values8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
21FDT_EXPR_0247SFDT: Decision Table Packed Values7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
22FDT_EXPR_0247TFDT: Decision Table Packed Values7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
23FDT_EXPR_1100FDT: Expression - Range OLD4OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
24FDT_EXPR_1100AFDT: Expression - Range OLD4OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
25FDT_EXPR_1100SFDT: Expression - Range OLD3OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
26FDT_EXPR_1100TFDT: Expression - Range OLD3OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
27FDT_EXPR_1104FDT: Expression - Range NEW6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
28FDT_EXPR_1104AFDT: Expression - Range NEW6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
29FDT_EXPR_1104SFDT: Expression - Range NEW5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
30FDT_EXPR_1104TFDT: Expression - Range NEW5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
31FDT_EXPR_1304FDT: Expression - Boolean Logic (AND/OR Operands)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
32FDT_EXPR_1304AFDT: Expression - Boolean Logic (AND/OR Operands)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
33FDT_EXPR_1304SFDT: Expression - Boolean Logic (AND/OR Operands)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
34FDT_EXPR_1304TFDT: Expression - Boolean Logic (AND/OR Operands)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
35FDT_EXPR_2201FDT: Expression - DB Lookup Fields5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
36FDT_EXPR_2201AFDT: Expression - DB Lookup Fields5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
37FDT_EXPR_2201SFDT: Expression - DB Lookup Fields4OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
38FDT_EXPR_2201TFDT: Expression - DB Lookup Fields4OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
39FDT_EXPR_2603FDT: Flow Gateways Conditions8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
40FDT_EXPR_2603AFDT: Flow Gateways Conditions8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
41FDT_EXPR_2603SFDT: Flow Gateways Conditions7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
42FDT_EXPR_2603TFDT: Flow Gateways Conditions7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
43FDT_EXPR_3002FDT: Rule - simpilfied condition range6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
44FDT_EXPR_3002AFDT: Rule - simpilfied condition range6OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
45FDT_EXPR_3002SFDT: Rule - simpilfied condition range5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
46FDT_EXPR_3002TFDT: Rule - simpilfied condition range5OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
47FDT_EXPR_9003FDT: Expression - Loop (implicit ranges for Conditions)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
48FDT_EXPR_9003AFDT: Expression - Loop (implicit ranges for Conditions)8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
49FDT_EXPR_9003SFDT: Expression - Loop (implicit ranges for Conditions)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
50FDT_EXPR_9003TFDT: Expression - Loop (implicit ranges for Conditions)7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
51FDT_RLST_0001FDT: Reorganized Range for Rule and Ruleset Precondition8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
52FDT_RLST_0001AFDT: Reorganized Range for Rule and Ruleset Precondition8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
53FDT_RLST_0001SFDT: Reorganized Range for Rule and Ruleset Precondition7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
54FDT_RLST_0001TFDT: Reorganized Range for Rule and Ruleset Precondition7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
TOPClinical System
55N1MEINDEXi.s.h.med: Medication; Standardized Search Strings12OPTIONSi.s.h.med: Medication; Additional Optionsnvarchar200
56N1MESTARIDXi.s.h.med: Medication; Standardized Search Strimngs *-Search10OPTIONSi.s.h.med: Medication; Additional Optionsnvarchar200
TOPEnergy Data Management
57EEDMSETTLDOCVARIVariant on Settlement Document7OPTIONSABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPFoundation for EHS Management
58EHFNDI_ATC_LT_EXEHSM Label Text check Exception2OPTIONSEHSM Label Text Select Optionnvarchar20
TOPGRC Process Control Plug-in
59/GRCPI/GRIABRSELAM - Selection (Temp Storage for A Sync)6OPTIONSAM - Selection optionnvarchar20
TOPMonitoring
60CSMBK_OBJObject Repository in CCMS System Repository5OPTIONSFull name of CCMS Repository objectnvarchar2550
TOPOracle Database Monitors
61ORA_ISQ_HEADERIndex Storage Quality - Header of a Workingset15OPTIONSProcessing Optionsnvarchar2000
TOPProcess Controls
62GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group9OPTIONSOptionnvarchar20
63GRPCRVVALRule Criteria Value9OPTIONSOptionnvarchar20
64GRPCRVVAL_SNPRule Criteria Value10OPTIONSOptionnvarchar20
65GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group11OPTIONSOptionnvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
66TFMCA_ACTN_0012TRM BRF+: Customizing Table for Check Condition8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
67TFMCA_ACTN_0012ATRM BRF+: Application Table for Check Condition8OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
68TFMCA_ACTN_0012STRM BRF+: System Table for Check Condition7OPTIONSType of OPTION component in row type of a Ranges typenvarchar20
TOPRouting
69CWB_SEL_VARIANTSEWB: User-Specific Initial Variants12OPTIONSABAP: Selection option (EQ/BT/CP/...)nvarchar20
TOPSyntax, Compiler, Runtime
70TPDASESSIONSTPDA: Debug Sessions10OPTIONSTPDA: Sessions - Optionennvarchar10