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

82 columns | Print definition?ERP 6.0  | ELEMENT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTDEXTYPEDEFDMIS PCL Data Extract Types - Definition of elements4ELEMENT_TYPEObject Name in Object Directorynvarchar400
2FDT_EXPR_2203FDT: Expression - DB Lookup(Parameter Binding)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
3FDT_EXPR_2203AFDT: Expression - DB Lookup(Parameter Binding)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
4FDT_EXPR_2203SFDT: Expression - DB Lookup(Parameter Binding)6ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
5FDT_EXPR_2203TFDT: Expression - DB Lookup(Parameter Binding)6ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
TOPAppraisal, Valuation, and Survey Tool
6HRHAP_BASICAppraisal Document: Basic Element Data10ELEMENT_TYPEAppraisal Element Typenvarchar20
7HRHAP_EL_CONFUI Configurations for an Appraisal Element3ELEMENT_TYPEAppraisal Element Typenvarchar20
8HRHAP_P_DAppraisal Document: Reference Appraisal (Structure)10ELEMENT_TYPEAppraisal Element Typenvarchar20
9HRHAP_TAB_DATAAppraisal: Layout Configuration Data10ELEMENT_TYPEAppraisal Element Typenvarchar20
10T77HAP_ASSIGNExternal Objectes Assigned to Template Elements4ELEMENT_TYPEAppraisal Element Typenvarchar20
TOPAuto-ID Infrastructure
11/AIN/TPRFELEMATRAttribute of element in an elementset2ELEMENT_TYPEType of Elementnvarchar20
12/AIN/TPRFELEMENTElements of element set2ELEMENT_TYPEType of Elementnvarchar20
13/AIN/TPRFELEMSETElement Set2ELEMENT_TYPEType of Elementnvarchar20
14/AIN/TPRFELESETTElement Set Text2ELEMENT_TYPEType of Elementnvarchar20
15/AIN/TPRFELMENTDOES NOT Contain any entry. Only used for namespace check2ELEMENT_TYPEType of Elementnvarchar20
16/AIN/TPRFELMENTTDescription of element2ELEMENT_TYPEType of Elementnvarchar20
17/AIN/TPRFETYPUSEElement usage and type relationship3ELEMENT_TYPEType of Elementnvarchar20
18/AIN/TPRFPRFESETElement sets of a profile and their usage5ELEMENT_TYPEType of Elementnvarchar20
TOPBRFplus - ABAP-Based Business Rules
19FDT_ACTN_1107FDT: Action - Static method Exceptions10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
20FDT_ACTN_1107AFDT: Action - Static method Exceptions10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
21FDT_ACTN_1107SFDT: Action - Static method Exceptions9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
22FDT_ACTN_1107TFDT: Action - Static method Exceptions9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
23FDT_DOBJ_0100FDT: Data Object Element - Attributes4ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
24FDT_DOBJ_0100AFDT: Data Object Element - Attributes4ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
25FDT_DOBJ_0100SFDT: Data Object Element - Attributes3ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
26FDT_DOBJ_0100TFDT: Data Object Element - Attributes3ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
27FDT_EXPR_0210FDT: Expression - Search Tree (Nodes)10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
28FDT_EXPR_0210AFDT: Expression - Search Tree (Nodes)10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
29FDT_EXPR_0210SFDT: Expression - Search Tree (Nodes)9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
30FDT_EXPR_0210TFDT: Expression - Search Tree (Nodes)9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
31FDT_EXPR_0230FDT: Expression - Decision Tree (Nodes)10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
32FDT_EXPR_0230AFDT: Expression - Decision Tree (Nodes)10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
33FDT_EXPR_0230SFDT: Expression - Decision Tree (Nodes)9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
34FDT_EXPR_0230TFDT: Expression - Decision Tree (Nodes)9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
35FDT_EXPR_0242FDT: Expression - Decision Table (Cells)8ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
36FDT_EXPR_0242AFDT: Expression - Decision Table (Cells)8ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
37FDT_EXPR_0242SFDT: Expression - Decision Table (Cells)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
38FDT_EXPR_0242TFDT: Expression - Decision Table (Cells)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
39FDT_EXPR_1200FDT: Expression - Case (case attribute)8ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
40FDT_EXPR_1200AFDT: Expression - Case (case attribute)8ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
41FDT_EXPR_1200SFDT: Expression - Case (case attribute)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
42FDT_EXPR_1200TFDT: Expression - Case (case attribute)7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
43FDT_EXPR_1507FDT: Expression - Static Method Mappings10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
44FDT_EXPR_1507AFDT: Expression - Static Method Mappings10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
45FDT_EXPR_1507SFDT: Expression - Static Method Mappings9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
46FDT_EXPR_1507TFDT: Expression - Static Method Mappings9ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
47FDT_EXPR_3001FDT: Expression - Rule11ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
48FDT_EXPR_3001AFDT: Expression - Rule11ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
49FDT_EXPR_3001SFDT: Expression - Rule10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
50FDT_EXPR_3001TFDT: Expression - Rule10ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
51FDT_EXPR_E0242FDT: Enhancement for Decision Table - Cell data8ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
52FDT_EXPR_E0242SFDT: Enhancement for Decision Table - Cell data7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
53FDT_EXPR_E0242TFDT: Enhancement for Decision Table - Cell data7ELEMENT_TYPEFDT: Elementary Data Typenvarchar10
TOPBusiness Rule Framework
54TBRF167BRF: Trigger Action BOR Event - Container17ELEMENT_TYPEBRF: Category of Element in Container (Workflow, BOR ...)nvarchar10
55TBRF169BRF: Start Workflow Action - Container15ELEMENT_TYPEBRF: Category of Element in Container (Workflow, BOR ...)nvarchar10
TOPEnterprise Service Framework Layer
56SCOL_BO_PROPERTYESF : Business Object - Property2ELEMENT_TYPEESF: Element Typenvarchar20
57SCOL_CONFIGCool : Configuration1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
58SCOL_CONFIGTCool : Configuration - Short Text1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
59SCOL_GROUPCool: Group1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
60SCOL_GROUPMEMBERCool : Group Member1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
61SCOL_GROUPTCool : Group - Short Text1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
62SCOL_PROPERTYCool : Property1ELEMENT_TYPECool : Type of Cool Elementnvarchar20
63SCOL_WB_DATASETESF Test Environment : Test Data Management3ELEMENT_TYPECool : Type of Cool Elementnvarchar20
TOPHR Administrative Services
64T5ASRDPFELEMENTSAssignment of Anchors to Element Types3ELEMENT_TYPEElement Type IDnvarchar320
TOPI18N BiDi
65LST_WDA_DDIC_REPLST repository for DDIC texts6ELEMENT_TYPEWeb Dynpro: Web Dynpro UI Element Definitionnvarchar600
66LST_WDA_OTR_REPLST repository for OTR texts6ELEMENT_TYPEWeb Dynpro: Web Dynpro UI Element Definitionnvarchar600
TOPNetWeaver Enterprise Search
67ESH_OM_PC_EXEMPTPlausibility Check: Exemptions7ELEMENT_TYPEnvarchar500
TOPObjective Setting and Appraisals
68HRHAP_VA_CLL_USESources and Targets for Reuse3ELEMENT_TYPEAppraisal Element Typenvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
69DFMCA_BRF169BRF: Start Workflow Action - Container15ELEMENT_TYPEBRF: Category of Element in Container (Workflow, BOR ...)nvarchar10
TOPRecords and Case Management
70RMPS_PROP_NAMEAttribute Name2ELEMENT_TYPEElement Type IDnvarchar320
71RMPS_PROP_NAMESNames for attribute properties3ELEMENT_TYPEElement Type IDnvarchar320
72RMPS_TOOLBARToolbar Customizing Table4ELEMENT_TYPEDocument classnvarchar100
73RMPS_TOOLBARTToolbar Customizing Text Table5ELEMENT_TYPEDocument classnvarchar100
TOPStatus and Action Management
74SAMDT_ELEMENTSS&AM Elements8ELEMENT_TYPEStatus Model Element Typenvarchar20
75SAMSDELEMStatus Model Actions, Operators and Derivators5ELEMENT_TYPEStatus Model Element Typenvarchar20
76SAM_ELEMENTSSAM elements4ELEMENT_TYPEStatus Model Element Typenvarchar20
TOPTalent Management
77T5TMCSRRESELAES Elements for the Results List of the Search3ELEMENT_TYPEObject Typenvarchar20
78T77TMCAESFIELDAES Field Customizing7ELEMENT_TYPEAppraisal Element Typenvarchar20
79T77TMCELEMPRCAssignments of Elements of Templates to Processes3ELEMENT_TYPEAppraisal Element Typenvarchar20
TOPTravel Planning
80FTPT_IMR_FAREELMIMR: Passenger Information for Price Determination8ELEMENT_TYPEnvarchar30
81FTPT_IMR_FQTVIMR: Customer Programs8ELEMENT_TYPEnvarchar20
82TA20RMRKCompany-Specific PNR Elements4ELEMENT_TYPERemarks Classnvarchar20