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

79 columns | Print definition?ERP 6.0  | DATA_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/C_SEL_RANGESelection Range for Simplification7DATA_TYPEData Type for Range Valuesnvarchar10
2ARBFND_I_DCXML_DDDIC objects generated for the DTD elements and attributes12DATA_TYPEData Type in ABAP Dictionarynvarchar40
3CNV_INDX_STRUCTSStructures of INDX RELIDs8DATA_TYPEGeneral Type of Saved Data Objectnvarchar10
4DOCR_LOG_DATADBOSC-CR: Logging and Tracing Data4DATA_TYPEnvarchar300
5DOCR_TRC_DATADBOSC-CR: Trace Data4DATA_TYPEnvarchar300
6GRFNATSAudit Trail Framework Sub data repository6DATA_TYPEAbap Data Typenvarchar10
7IUUC_REPL_FIELDFieldname table for table creation / replication / init load5DATA_TYPEdata type of fieldnvarchar300
8RSBPCB_SOBJ_LKPBPC: Semantic object link parameter5DATA_TYPEBPC: Typenvarchar200
9SRAL_FIELDSRAL: Generic channel fields8DATA_TYPERAL: Data type (procesing step in UI)nvarchar10
10SRAL_FIELDS_DYNPRAL: Channel specific fields8DATA_TYPERAL: Data type (procesing step in UI)nvarchar10
11SRAL_FIELDS_RFCRAL: Channel specific fields7DATA_TYPERAL: Data type (procesing step in UI)nvarchar10
12SRAL_FIELDS_SYRAL: System Field5DATA_TYPERAL: Field Data Typenvarchar10
13SRAL_FIELDS_WDRAL: Channel specific fields20DATA_TYPERAL: Data type (procesing step in UI)nvarchar10
14SRAL_FIELDS_WSRAL: Channel specific fields8DATA_TYPERAL: Field Data Typenvarchar10
15T7CNRMP_VALUEITMValue Item of Statistical Item with Value Reading Type6DATA_TYPEData Type of Statistical Item with Value Reading Typenvarchar10
16/BOBF/OBM_ALTKEYBOPF Configuration: Alternative Keys9DATA_TYPEName of a structurenvarchar300
17/BOBF/OBM_NODEBOPF Configuration: Node11DATA_TYPEName of a structurenvarchar300
18/BOBF/OBM_QUERYBOPF Configuration: Query10DATA_TYPEName of a structurenvarchar300
TOPAdaptor
19UKM_TRANSFER_ARVData from AR for SAP Credit Management5DATA_TYPEIdentification for Payment Behavior Summarynvarchar20
TOPBusiness Configuration Sets
20SCPRTEMPBC Sets: Save temporary table data in DB2DATA_TYPEBC Sets: Categories for Internal Tablesnvarchar10
TOPBusiness Partner
21BP3100Additional information5DATA_TYPEInformation Typenvarchar20
22TP19Business Partner Additional Information3DATA_TYPEInformation Typenvarchar20
23TP19TBusiness Partner Additional Information4DATA_TYPEInformation Typenvarchar20
24TP22Business Partner Additional Information3DATA_TYPEInformation Typenvarchar20
25TP22TBusiness Partner Additional Information4DATA_TYPEInformation Typenvarchar20
TOPCentral Part of Product Master
26COMS_ALTID_CONTContext Fields for Alternative IDs2DATA_TYPEData Types for Environment Data Fields Alternative IDsnvarchar40
TOPClinical System
27N2BCPCLIMAdditional Data Item Catalog Type Clinical Measurements5DATA_TYPEData Typenvarchar30
TOPCommon Functions
28INM_M_C_MET_GRPMetrics Group4DATA_TYPEData Typenvarchar40
TOPCountry-Specific Objects
29DMEE_NODE_ABADMEE: Format Tree Nodes12DATA_TYPEDMEE: data type of DMEE nodenvarchar10
TOPData Mining
30RSDMTPN_MOD_COLColumns that make the analytical model4DATA_TYPEData Typenvarchar40
31RSDMTPN_SRV_PARParameters required for the services4DATA_TYPEData Typenvarchar40
32RSDMTP_MOD_COLColumns that make the analytical model4DATA_TYPEData Typenvarchar40
33RSDMTP_SRV_PARAMParameters required for the services5DATA_TYPEData Typenvarchar40
TOPDSD Connector
34/DSD/ME_RPL_STATDSD Connector: Replication Result4DATA_TYPEDSD Connector: Data Typenvarchar10
TOPE-Recruiting
35T77RCF_CTRL_PARController Parameter3DATA_TYPEName of an ABAP Dictionary objectnvarchar300
TOPEasy Enhancement Workbench
36AXT_DATATYPEExtensibility Field Datatypes1DATA_TYPEField Data Typenvarchar100
37AXT_DATATYPE_TExtensibility Field Datatypes Texttable2DATA_TYPEField Data Typenvarchar100
38AXT_RUN_FIELDDEFExtensibility runtime field definition3DATA_TYPEField Data Typenvarchar100
TOPeCATT Extended Computer Aided Test Tool
39ECOQ_LOGeCATT OQ Log10DATA_TYPEeCATT OQ Log Type of Data Fieldntext10737418230
TOPEnd User Technology
40RSDASSERVPARService Parameter of the Data Access Service6DATA_TYPEData Type of a Parameter for a Data Access Servicenvarchar100
41RSKPI_KPI_INKPI: Input Parameters5DATA_TYPEData Type of a Parameter for a Data Access Servicenvarchar100
TOPGovernance, Risk and Compliance
42GRFNATFAudit Trail Framework data repository10DATA_TYPEAbap Data Typenvarchar10
TOPIncentive and Commission Management ICM
43TCACS_RESPComn.: Liability Types10DATA_TYPEVersion Number Componentnvarchar20
TOPInformation Retention Manager
44IRM_T_OBJ_TYPEIRM: Object Types8DATA_TYPEIRM: Data Typenvarchar10
TOPIRM Run Time
45LRM_T_OTILM Objects4DATA_TYPEData Typenvarchar10
TOPJapan
46T7JPCP_DTFLSTRDefine Data File Structure9DATA_TYPEData Typenvarchar10
TOPLocalization
47DMEE_TREE_NODEDMEE: Format Tree Nodes12DATA_TYPEDMEE: data type of DMEE nodenvarchar10
TOPMaintenance Orders
48/MRSS/C_HRES_DATCommunication Data2DATA_TYPEType of Resource Informationnvarchar50
49/MRSS/D_CHG_HISTChange Documents (Field Changes)10DATA_TYPEName of Dictionary Typenvarchar300
TOPMusing Tools
50WDKOSRFIELDFields in an OSR transaction5DATA_TYPEField typenvarchar300
51WDKOSRFIELDSFields in an OSR transaction6DATA_TYPEField typenvarchar300
TOPNetWeaver Enterprise Search
52ESH_OM_ADATATYData Types4DATA_TYPEData Typenvarchar300
53ESH_OM_CDATATYData Types4DATA_TYPEData Typenvarchar300
54ESH_OM_IDATATYData Types4DATA_TYPEData Typenvarchar300
55ESH_OM_SDATATYData Types4DATA_TYPEData Typenvarchar300
TOPOffice Suite Program
56/OSP/T_CON_GRPTable to store context groups4DATA_TYPEData Type in ABAP Dictionarynvarchar40
57/OSP/T_RAUI_CPVLOSP Chart Report Parameterization Value Table8DATA_TYPEData Typenvarchar40
58/OSP/T_RAUI_PBHOSP Report Parameterization Table8DATA_TYPEData Typenvarchar40
59/OSP/T_RAUI_TPBHOSP Triggered Report Parameterization Table8DATA_TYPEData Typenvarchar40
TOPOverhead Cost Controlling
60KCR_T_APPLAllowed Data Types for Application Type4DATA_TYPEData Assignment Typenvarchar40
61KCR_T_APPL_TEXTAllowed Data Types for Application Type: Text4DATA_TYPEData Assignment Typenvarchar40
62KCR_T_LINKAssignment of Link to Data (Double-Concatenated List)6DATA_TYPEData Assignment Typenvarchar40
TOPProcess Controls
63GRPCVERSIONDETEvent Monitoring: Event format version5DATA_TYPEField Data Typenvarchar40
TOPSAP Business Workflow
64SWBRULEBINWF: Runtime Representation of a Rule4DATA_TYPEWF: Data Type in Table SWB_RULEBINnvarchar120
65SWN_FILTPARWF Notif: Filter Parameter4DATA_TYPEData Element Namenvarchar300
66SWN_SETTINGSWF Notif: General Settings4DATA_TYPEData Element Namenvarchar300
67SWN_SETTINGSSWF Notif: General Settings3DATA_TYPEData Element Namenvarchar300
68SWN_SUBSPARWF Notif: Subscription Parameters6DATA_TYPEData Element Namenvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
69ISH_IDX_HEADERHeader for Index Table22DATA_TYPEData Type of Message (Data Sent or Received)nvarchar10
TOPSecurity
70SEC_TEST_MAPTable with Test Data4DATA_TYPEnvarchar1280
TOPTrading Execution Workbench
71TEWDOC2DATATYPEMapping from Document Category to Data Type2DATA_TYPEDocument Data Typenvarchar20
72TEWENHANCEClasses for Data Enhancement4DATA_TYPEDocument Data Typenvarchar20
73TEWFILTERClasses That Filter Out Documents Before Display4DATA_TYPEDocument Data Typenvarchar20
TOPVirtual Machine Container
74CPT_METRIC_DEFUnit of Measure Definition in CPT (Common Performance Trace)4DATA_TYPEint100
TOPWeb Dynpro ALV for ABAP
75SALV_CSQ_TR_DATAData For Log Records4DATA_TYPEData Type (Viewer Specific Information)ntext10737418230
76SALV_CSQ_TR_TYPEMapping between data/viewer specific type and saved alias4DATA_TYPEData Type (Viewer Specific Information)ntext10737418230
TOPWorkbench Tools Editors, Painters, Modelers
77SADT_SRL_DATAExternal data names <-> internal data types mappings2DATA_TYPEConcrete data typenvarchar300
TOPWorkforce Management Application
78WFAC_WKRL_DEFDefault Work Rules Definitions3DATA_TYPEWorkrule definition data typenvarchar20
TOPWorkforce Management Core
79WFMC_WKRL_DEFDefault Work Rules Definitions3DATA_TYPEWorkrule definition data typenvarchar20