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

54 columns | Print definition?ERP 6.0  | DATA_ELEMENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_FPSB: Function Import Parameters7DATA_ELEMENTData element (semantic domain)nvarchar300
2/OTX/SEA_TEMREGRegions used in a search template6DATA_ELEMENTData element (semantic domain)nvarchar300
3/UI2/NWBC_CFG_GTSAP GUI Tags: SAP Delivery9DATA_ELEMENTData Elementnvarchar300
4/UI2/NWBC_C_GTSAP GUI Tags: Tags of Customer10DATA_ELEMENTData Elementnvarchar300
5/UI2/NWBC_L_GTSAP GUI Tags: Buffer Table9DATA_ELEMENTData Elementnvarchar300
6CNVMBTCPARAMPIFD Concrete Parameters for a Variant4DATA_ELEMENTData element (semantic domain)nvarchar300
7CNVMBTPARAMPIFD Parameter Definitions3DATA_ELEMENTData element (semantic domain)nvarchar300
8DPP_MASKData Privacy: Customizing table for masking5DATA_ELEMENTPersonal Data Destruction: Data Elementnvarchar300
9DPP_MASK_RSTRCTData Privacy: Restriction Table for Masking4DATA_ELEMENTPersonal Data Destruction: Data Elementnvarchar300
10GRFNREPFIELDMAPReport: Special fields for reporting2DATA_ELEMENTField typenvarchar300
11IDREPFW_SEELM_CDynamic Sel.: Selection Parameters12DATA_ELEMENTData element (semantic domain)nvarchar300
12IDREPFW_SELPAR_ARep. Framework: Data Storage - Selection Parameters16DATA_ELEMENTData element (semantic domain)nvarchar300
13SXVIEW_MOCK_COLXView Mock Data: Columns6DATA_ELEMENTData element (semantic domain)nvarchar300
14T77SFI_COMP_MPFDField definitions for import of compensation data from SFSF7DATA_ELEMENTName of Dictionary Typenvarchar300
15T77SFI_VARPY_MPDField definitions for import of Variable Pay data from SFSF7DATA_ELEMENTName of Dictionary Typenvarchar300
16T77XXB_IRM02Map class with the condition field4DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
17T799IRM02Map class with the condition field4DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
TOPAccounting Engine
18/EACC/ENGINECHARAccounting Engine Characteristics4DATA_ELEMENTData element (semantic domain)nvarchar300
TOPAdditional Material Functions
19WSDT_MAT_SEARCHMaterial Search Configuration4DATA_ELEMENTData elementnvarchar300
TOPAudit Management
20PLMC_AUDIT_OBJAudit Type - Object Attribute Type4DATA_ELEMENTData element (semantic domain)nvarchar300
TOPBusiness Configuration Tools Runtime
21SC2_BCO_PROP_DFC2 Server: Configuration Object Attributes (Definition)2DATA_ELEMENTName of Dictionary Typenvarchar300
TOPBusiness Objects, Common Components
22EHFNDC_BOBusiness Objects relevant for EHSM2DATA_ELEMENTData element (semantic domain)nvarchar300
TOPClaims Management
23ICL_CCONTEXT_FLDContext-Dependent FS-CM Data Selection - Fields8DATA_ELEMENTData Element for Virtual TREX Fieldnvarchar300
24TIMP130IMP: Permitted Parameters per Trigger Cat.f.IMP_PARAMETERS_15DATA_ELEMENTData element (semantic domain)nvarchar300
25TIMP140IMP: No Apparent Usage - Purpose Unclear4DATA_ELEMENTData element (semantic domain)nvarchar300
TOPConfiguration Check Framework
26DFIT_UNIT_PARAMParameters for Check Units4DATA_ELEMENTData Element for a Parameter for a Configuration Checknvarchar300
TOPData Mining
27RSDMTPN_MOD_COLColumns that make the analytical model22DATA_ELEMENTData element (semantic domain)nvarchar300
TOPEasy Enhancement Workbench
28AXT_RUN_FIELDDEFExtensibility runtime field definition6DATA_ELEMENTNamenvarchar300
TOPEnterprise Service Framework Layer
29SCOL_BO_PROP_DFESF : Business Object - Property Definition2DATA_ELEMENTName of Dictionary Typenvarchar300
30SCOL_PROP_DEFCool : Attribute Definition2DATA_ELEMENTName of Dictionary Typenvarchar300
TOPGovernance, Risk and Compliance
31GRFNFIELDMAPNOT USED! Mapping of fields to entity3DATA_ELEMENTField typenvarchar300
TOPInformation Retention Manager
32IRM_T_OBJ_CAT_MFIRM: Object Categories - Mandatory Fields for Policies3DATA_ELEMENTIRM: Data Element That Describes a Mandatory Fieldnvarchar300
33IRM_T_OT_POL_FLDIRM: Allowed Fields for Policies of an Object Type4DATA_ELEMENTIRM: Data Element that Describes a Registered Fieldnvarchar300
34LRM_BS_RST_CONDSIRM: Conditions for Business Suite and Residence Times9DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
35LRM_BS_RTP_CONDSIRM: Conditions for Business Suite and Retention Periods9DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
36LRM_PD_RTP_CONDSIRM: Conditions for Retention Rules for Paper Documents9DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
TOPIRM Run Time
37LRM_T_OC_MFMandatory Condition Fields for Policies4DATA_ELEMENTData Element Describing a Mandatory Fieldnvarchar300
38LRM_T_OC_RFResult Fields of Policies5DATA_ELEMENTData Element Describing a Mandatory Fieldnvarchar300
39LRM_T_OC_SFStandard Condition Fields for Policies3DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
40LRM_T_OT_FLDAvailable Condition Fields for Policies4DATA_ELEMENTData Element Describing a Condition Fieldnvarchar300
TOPMetadata Repository
41RSOS_ES_OBJ_ATRAttributes of an object type4DATA_ELEMENTData Element (For the Text of the Search Attribute)nvarchar300
TOPNetweaver Business Client
42NWBC_CFG_GUI_TAGDefinition of SAPGUI Tags which can be linked to Chips9DATA_ELEMENTData Elementnvarchar300
43NWBC_C_GUI_TAGDefinition of SAPGUI Tags by Customer10DATA_ELEMENTData Elementnvarchar300
TOPNetWeaver Enterprise Search
44ESH_OM_ADATATYData Types18DATA_ELEMENTDDIC Data Elementnvarchar300
45ESH_OM_CDATATYData Types18DATA_ELEMENTDDIC Data Elementnvarchar300
46ESH_OM_IDATATYData Types18DATA_ELEMENTDDIC Data Elementnvarchar300
47ESH_OM_SDATATYData Types18DATA_ELEMENTDDIC Data Elementnvarchar300
TOPRegulatory reporting for insurance companies
48TISSR_ASTVW_CRTISSR: Customizingtabelle für Durchsichtskriterien4DATA_ELEMENTISSR Durchsicht-Datenelementnvarchar300
TOPShift Planning for Public Sector
49HRSP_ABS_INF_COLInfo Columns for Absence Planner: Public Sector Germany5DATA_ELEMENTData element (semantic domain)nvarchar300
50T7PBS_SP_TSN_ETime Statement for Nurses: Column Customizing for UI6DATA_ELEMENTData element (semantic domain)nvarchar300
TOPTime Sheet
51CATS_MY_TEXTSObsolete3DATA_ELEMENTData element (semantic domain)nvarchar300
52CATS_MY_TEXTS2References to Data Elements for CATS notebook Field Texts2DATA_ELEMENTData element (semantic domain)nvarchar300
TOPTransaction Manager
53IDCFM_FRIM_CELMSData Elements for Selection Parameters - Impairment5DATA_ELEMENTData element (semantic domain)nvarchar300
54IDCFM_FRIM_SELPRSelection Parameters for Impairment Report Run9DATA_ELEMENTData elementnvarchar300