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

41 columns | Print definition?ERP 6.0  | LINK_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_SGX_WLLKLink Settings3LINK_TYPERelationship Typenvarchar20
2EHFNDD_CHM_LNKCChemical - Linked Chemcial10LINK_TYPEChemical Link Type Codenvarchar10
3GRFNCASEISCase table of Issue5LINK_TYPEEntity IDnvarchar200
4RSBPCB_SOBJ_LKBPC: Semantic object link5LINK_TYPEBPC: Typenvarchar200
TOPABAP Authorization and Role Management
5AGR_BUFFIInternet Links for a Role4LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10
6AGR_BUFFI2Internet links table - Customer version of SAP roles4LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10
7AGR_BUFFI3Internet links table - SAP versions of SAP roles4LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
8DTELLINKSsddo4LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
9DTLIDOKCRSet of conflicts for renaming the links to data elem. docu.4LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
TOPApplication Frame
10CRMC_UI_LLINKDefine Logical Link3LINK_TYPELogical Link Typenvarchar10
11CRMC_UI_WEB_LExternal Links (URLs)3LINK_TYPEType of a Web Link (External or Widget)nvarchar30
TOPControl Plan
12QPCPD_LINKControl Plan - Links to FMEA,..3LINK_TYPELink Typenvarchar20
TOPData Replication Framework
13FOX0_LINK_BACKInverse Relationship2LINK_TYPEType of Relationship Between Objectsnvarchar100
14FOX0_LINK_TYPERelationships Between Objects2LINK_TYPEType of Relationship Between Objectsnvarchar100
15FOX0_LTYPE_TXText Table for FOX Links3LINK_TYPEType of Relationship Between Objectsnvarchar100
16FOX3_EXPL_BU_DBBottom-Up Explosions4LINK_TYPEType of Relationship Between Objectsnvarchar100
17FOX3_EXPL_TD_DBTop-Down Explosions4LINK_TYPEType of Relationship Between Objectsnvarchar100
TOPEnvironment, Health and Safety
18/TDAG/RCSA_CREQAOBSOLETE: Assignment of Study Object to Specification Instan4LINK_TYPEOBSOLETE: Type of link between study and spezification instanvarchar10
TOPForms
19T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference12LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
TOPHR Administrative Services
20T5ASRFSCNLNKPossible Links for Additional Information4LINK_TYPELink for Additional Informationnvarchar320
21T5ASRFSCNSTGLNKUse of Hyperlinks in Steps of Process5LINK_TYPELink for Additional Informationnvarchar320
22T5ASRLINKHyperlink Types for Additional Information2LINK_TYPELink for Additional Informationnvarchar320
23T5ASRLINKTTexts for Hyperlink Types for Additional Information3LINK_TYPELink for Additional Informationnvarchar320
TOPImplementation Guide
24DOKCRList of links between documentation objects4LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
25DSYCRList of Links Between Documentation Modules7LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
26DSYLIList of available link types1LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
27DSYLTList of link type names2LINK_TYPELink type for links between documentation/hypertext modulesnvarchar10
TOPProcess Controls
28GRPCNWBCLINKLinks4LINK_TYPEURL Typenvarchar30
TOPProduct Data Management
29EXPO_LTYPELink Types in EXPO Layer (FOX Explosion)1LINK_TYPEType of Relationship Between Objectsnvarchar100
30EXPO_LTYPE_TXText Table for Link Types in EXPO Layer2LINK_TYPEType of Relationship Between Objectsnvarchar100
TOPRecipe Development
31/PLMB/RFO_FRMITMFormula items26LINK_TYPEType of Relationship Between Recipe Subobjectsnvarchar10
32/PLMB/RPR_EQREquipment Requirements11LINK_TYPEType of Relationship Between Recipe Subobjectsnvarchar10
33/PLMB/RPR_PEProcess Element11LINK_TYPEType of Relationship Between Recipe Subobjectsnvarchar10
34/PLMB/RPR_PP_VALProcess Parameter Values19LINK_TYPEType of Relationship Between Recipe Subobjectsnvarchar10
TOPRemaining Beverage - Obsolete Objects
35/BEV3/CHCDPLINKCDP: Contract References4LINK_TYPEID for Contract Referencenvarchar60
TOPRisk Assessment
36EHHSSD_RAS_RSNReasons11LINK_TYPELink Type for Reasonsnvarchar20
TOPSales
37LINKAGERelationships3LINK_TYPELink Categorynvarchar100
TOPSession Manager
38ADMI_BUFFIBuffer table4LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10
39IDES_LINKSTable to enter links for the Session Manager4LINK_TYPEType of Internet linknvarchar10
40SMEN_BUFFILinks for Favorites4LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10
41SSM_LINKSTable to enter links for the Session Manager3LINK_TYPECustomized ('C') or standard menu ('S') flagnvarchar10