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

28 columns | Print definition?ERP 6.0  | KEY4

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CLF_OBJKEY_MPPNGClassification Object Key Mapping8KEY4Key of object to be classifiednvarchar500
2CNV_10020_ACTALActions for log21KEY4Indicator for key membershipnvarchar10
3CNV_10020_ACTANActions for messages23KEY4Indicator for key membershipnvarchar10
4HRP5354DB Table for Infotype 535427KEY4Extension Data Keynvarchar500
5MDGHDB_LONGTEXTTable for Storing Long texts9KEY4Namenvarchar700
6NWS_EXT_CONKEYCombined Key Fields12KEY4Field Namenvarchar300
7P08P1CLSCLASS CPX INTERFACE Snapshot Table34KEY4CLASS CPX INTERFACE Fourth Keynvarchar120
8T5GPBS_CS_CODESCode Set Codes5KEY4Code Set: Key Length 4nvarchar40
TOPABAP Authorization and Role Management
9AAA_KEYSSAP Authorization Assistant - Definition11KEY4String for Authorization Assistantnvarchar2550
TOPBasic Data
10NC01IS-HCM Dispatch Orders to HCM16KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar300
11NC301IS-HCM: Order Table Data Transmission for EDI18KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
12NC301SIS-HCM: EDI Status Management18KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
13NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records18KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPClinical System
14NC321IS-H: Table for data exchange of §32118KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPCommunication
15NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events15KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPData Retention Tool
16TXW_C_STRCSegment structures7KEY4Index key fieldnvarchar300
TOPDevice Management
17EDTIDIS-U Device Checker: Allocation of Table Names - Table IDs6KEY4Field Namenvarchar300
TOPElectronic Data Interchange
18WRF_PRICAT_010Price Catalog Inbound: Generic Field Storage6KEY4Price Catalog Inbound: Key Field 4nvarchar350
TOPGeneral Ledger Accounting
19FAGL_RSIGReorganization: Signature6KEY4Reorganization: Key Field of the Signature (Data Element)nvarchar300
TOPGeneral Ledger Reorganization
20FAGL_R_OBJTYReorganization: Object Type11KEY4Field Name of the Fourth Key Fieldnvarchar300
TOPGlobal Organization Customizing
21TCUSCCUSC: Customizing Country Version, New Field Contents10KEY4Field Namenvarchar300
TOPInvoicing
22ECHANGE_SERVICEChange Service Database8KEY4Data Type 4 Charactersnvarchar40
TOPPayments
23DFKKBOHBoleto: Header data40KEY4Instruction key 4nvarchar20
TOPProcess Controls
24HRT5320Table Part Infotype 53207KEY4Extension Data Keynvarchar500
TOPProfitability Analysis
25TKEANCO-PA: Control Table for PA Derivation of Characteristics12KEY4Key field namenvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
26ISH_HCF_HEADERHeader for Index Table13KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
27ISH_IDX_HEADERHeader for Index Table15KEY4IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPSAP List Viewer
28SALV_EX_STORAGEALV Data Repository for External Access7KEY4GUID in 'CHAR' Format in Uppercasenvarchar320