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

80 columns | Print definition?ERP 6.0  | SHLPNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_DETFIELDDetermination Fields6SHLPNAMEName of a Search Helpnvarchar300
2/OPT/FIELDSInvoice Header/Item fields configuration17SHLPNAMEName of a Search Helpnvarchar300
3/OPT/X005Approval COA Fields4SHLPNAMEName of a Search Helpnvarchar300
4/OPT/X006Approval Usermap Fields3SHLPNAMEName of a Search Helpnvarchar300
5/OPT/X020Key Determination Template Details4SHLPNAMEName of a Search Helpnvarchar300
6/OPT/X145Screen Config table for /ORS/000005 Development11SHLPNAMEName of a Search Helpnvarchar300
7/OPT/X146Screen configuration for PO approval line item and coding13SHLPNAMEName of a Search Helpnvarchar300
8/OPT/X158Configuration for the header screen5SHLPNAMEName of a Search Helpnvarchar300
9/OPT/X161Configuration for the PO invoice header screen in approval5SHLPNAMEName of a Search Helpnvarchar300
10/OPT/Y005Approval COA Fields4SHLPNAMEName of a Search Helpnvarchar300
11/OPT/Y006Approval Usermap Fields3SHLPNAMEName of a Search Helpnvarchar300
12/OPT/Y020Key Determination Template Details4SHLPNAMEName of a Search Helpnvarchar300
13/OPT/Y145Screen Config table for /ORS/000005 Development11SHLPNAMEName of a Search Helpnvarchar300
14/OPT/Y146Screen configuration for PO approval line item and coding13SHLPNAMEName of a Search Helpnvarchar300
15/OPT/Y158Configuration for the header screen5SHLPNAMEName of a Search Helpnvarchar300
16/OPT/Y161Configuration for the PO invoice header screen in approval5SHLPNAMEName of a Search Helpnvarchar300
17/OPT/Z005Approval COA Fields4SHLPNAMEName of a Search Helpnvarchar300
18/OPT/Z006Approval Usermap Fields3SHLPNAMEName of a Search Helpnvarchar300
19/OPT/Z020Key Determination Template Details4SHLPNAMEName of a Search Helpnvarchar300
20/OPT/Z145Screen Config table for /ORS/000005 Development11SHLPNAMEName of a Search Helpnvarchar300
21/OPT/Z146Screen configuration for PO approval line item and coding13SHLPNAMEName of a Search Helpnvarchar300
22/OPT/Z158Configuration for the header screen5SHLPNAMEName of a Search Helpnvarchar300
23/OPT/Z161Configuration for the PO invoice header screen in approval5SHLPNAMEName of a Search Helpnvarchar300
24/ORS/APPR_GL_CFGScreen Config table for /ORS/000005 Development11SHLPNAMEName of a Search Helpnvarchar300
25/ORS/APPR_PO_CFGScreen configuration for PO approval line item and coding13SHLPNAMEName of a Search Helpnvarchar300
26/ORS/GL_HDR_CFGConfiguration for the header screen5SHLPNAMEName of a Search Helpnvarchar300
27/ORS/PO_HDR_CFGConfiguration for the PO invoice header screen in approval5SHLPNAMEName of a Search Helpnvarchar300
28/OTX/RM_TPWSCECMLink workspace creation configuration5SHLPNAMEName of a Search Helpnvarchar300
29/OTX/RM_WSS_SHSearch Help Parameter Settings2SHLPNAMEName of a Search Helpnvarchar300
30BBP_APP_CUS_F4Customizing for appended customer search helps1SHLPNAMEName of a Search Helpnvarchar300
31CNVCMIS_A_1_DTELSelection of Object Type Master information29SHLPNAMEName of a Search Helpnvarchar300
32CNVCMIS_A_1_LDBDAdministration information for LDB18SHLPNAMEName of a Search Helpnvarchar300
33CNVCMIS_A_1_SHLCSearch Help Data (SUB HELPS)5SHLPNAMEName of a Search Helpnvarchar300
34CNVCMIS_A_1_SHLDSearch Help Data (Parameters)4SHLPNAMEName of a Search Helpnvarchar300
35CNVCMIS_A_1_SHLPSearch Help Data-Header4SHLPNAMEName of a Search Helpnvarchar300
36CVP_DPP_SHLPCustomizing Table for Authority Checks in Search Helps1SHLPNAMEName of a Search Helpnvarchar300
37CVP_SHLP_FILTERCustomizing table for filtering search helps2SHLPNAMEName of a Search Helpnvarchar300
38DMC_FIXEDVALUEMWB: Fixed Values18SHLPNAMEName of a Search Helpnvarchar300
39J_1BNFE_C_CCECFGCC-e Event Correction Letter Fields Configuration6SHLPNAMEName of a Search Helpnvarchar300
40SHLP_FILTER_CVCustomizing Table for Filtering Search Helps2SHLPNAMEName of a Search Helpnvarchar300
41T5UPBSAPPTYPEApplication Type Definitions7SHLPNAMEName of a Search Helpnvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
42CD0F4TESTTabelle mit Feldern mit verschiedenen Eingabehilfen12SHLPNAMEName einer Suchhilfenvarchar300
43DD04LData elements21SHLPNAMEName of a Search Helpnvarchar300
TOPAudit Management
44PLMC_AUDIT_OBJAudit Type - Object Attribute Type8SHLPNAMEName of a Search Helpnvarchar300
TOPBank Customer Accounts
45/FSCAA/ADD_SHLPAdditional search helps3SHLPNAMEName of a Search Helpnvarchar300
TOPBusiness Partner
46TIVBPOBJROLEAllowed Role per Object Type13SHLPNAMEName of a Search Helpnvarchar300
TOPCommand and Support Relationships
47/ISDFPS/CSHLPCustomizing for the HR Search Helps5SHLPNAMEName of a Search Helpnvarchar300
TOPConstruction Equipment Management
48J_3GMCIDMatchcode ID Choice for Selecting PSP Elem. for Proj. Def.2SHLPNAMEName of a Search Helpnvarchar300
TOPCross-Application Components
49/OPT/CP_T911Key Determination Template Details4SHLPNAMEName of a Search Helpnvarchar300
TOPCustomer Interaction Center
50CCMCSEARCHSearch type to matchcode mapping for CCM contact search5SHLPNAMEName of a Search Helpnvarchar300
51CCMCSEARCHMAPMatchcode mapping for CCM contact search4SHLPNAMEName of a Search Helpnvarchar300
TOPData Conversion
52DMC_TRPARMDMC: Recoding Object Parameters (LOOKUP_PARAMETER)11SHLPNAMEName of a Search Helpnvarchar300
TOPEasy Enhancement Workbench
53AXT_RUN_FIELDDEFExtensibility runtime field definition9SHLPNAMESearch Help for Componentnvarchar300
TOPEmployee Interaction Center
54THREIC_CONSTANTVInput Help for EIC Constants4SHLPNAMEName of a Search Helpnvarchar300
TOPF4 Help
55DD30LSearch helps1SHLPNAMEName of a Search Helpnvarchar300
56DD30TSearch help texts1SHLPNAMEName of a Search Helpnvarchar300
57DD31SAssignment of search helps to collective search helps1SHLPNAMEName of a Search Helpnvarchar300
58DD32SSearch Help Parameter1SHLPNAMEName of a Search Helpnvarchar300
59DD33SAssignment of search help fields1SHLPNAMEName of a Search Helpnvarchar300
60DD35LSearch help attachments to structures: Headers4SHLPNAMEName of a Search Helpnvarchar300
61DDF4PSINDXContains Information for Personalizing the F4 Help4SHLPNAMEName of a Search Helpnvarchar300
62DDSHDEFSHDefault value - search help per user and collective s.h.3SHLPNAMEName of a Search Helpnvarchar300
63DDSHENTITYTable of data elements which need the value table help7SHLPNAMEName of a Search Helpnvarchar300
64DDSHPVALUEPersonal Help Values3SHLPNAMEKey for personal helpnvarchar610
TOPFinancial Accounting
65/OPT/BL_T401Approval COA Fields4SHLPNAMEName of a Search Helpnvarchar300
66/OPT/BL_T402Approval Usermap Fields3SHLPNAMEName of a Search Helpnvarchar300
TOPFlexible Real Estate Management
67TIVCAOBJTYPEAllowed Object Type25SHLPNAMEName of a Search Helpnvarchar300
68TIVCASHFLDSearch Field, for Which a Search Strategy Can Be Defined3SHLPNAMESearch Help Namenvarchar300
TOPIntercompany Data Exchange
69EGRIDLTGrid Level Types5SHLPNAMEName of a Search Helpnvarchar300
TOPLocalization
70RFIDPTPRENTCLCDefine Pro-Rata Calculation Entity6SHLPNAMEName of Search Helpnvarchar300
71RFIDPTPRENTVALDefine Pro-Rata Validation Entity6SHLPNAMEName of Search Helpnvarchar300
TOPLogical DB, Selection Screens, Selection Variants
72LDBDAdministration information for LDB14SHLPNAMEName of a Search Helpnvarchar300
TOPMDG Material
73MDG_BS_MAT_SHLPMDG-M: Search Help Directory Buffer5SHLPNAMEName of a Search Helpnvarchar300
TOPOrganizational Flexibility
74/ISDFPS/CHCMSHLPAdditional Search Helps for Object5SHLPNAMEName of a Search Helpnvarchar300
TOPPortfolio Management
75/RPM/SHLP_LISTSearch Help List3SHLPNAMEName of a Search Helpnvarchar300
TOPProject Management
76DPR_CI_FGRP_FLDcProjects: Assignment of Customer Fields to Field Groups11SHLPNAMEProject Management: Search Help for Customer Fieldsnvarchar300
TOPTime Sheet
77TCATS_SHLP_ITSTime Sheet: Possible Entries Help in Internet3SHLPNAMEName of a Search Helpnvarchar300
TOPUse BC-FES-CTL SAP Note 835896
78MCTBC_HISDStore the selections done using the matchcode OCX3SHLPNAMEName of a Search Helpnvarchar300
TOPValuation
79OIUOW_LGL_FLD_ATLegal Description Field Attributes26SHLPNAMEName of a Search Helpnvarchar300
TOPWaste Management
80EHSWAC_ROLE_HELPCD: Role-Dependent Elementary Search Helps4SHLPNAMEName of a Search Helpnvarchar300