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

58 columns | Print definition?ERP 6.0  | KEY2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PDDEPDB Structure for Factor and Distribution Set6KEY2Key for Dependent Attributesnvarchar320
2CLF_OBJKEY_MPPNGClassification Object Key Mapping6KEY2Key of object to be classifiednvarchar500
3CNV_10020_ACTALActions for log13KEY2Indicator for key membershipnvarchar10
4CNV_10020_ACTANActions for messages15KEY2Indicator for key membershipnvarchar10
5CNV_20800_PARAMMulti-purpose generic parameter table5KEY2Additional information for a parameternvarchar300
6CNV_20800_STATStatistics - feedback from projects4KEY2Additional information for a parameternvarchar300
7CNV_20900_PARAMMulti-purpose generic parameter table5KEY2Additional information for a parameternvarchar300
8HRP5354DB Table for Infotype 535425KEY2Extension Data Keynvarchar500
9MDGHDB_LONGTEXTTable for Storing Long texts7KEY2Namenvarchar700
10NWS_EXT_CONKEYCombined Key Fields8KEY2Field Namenvarchar300
11P08P1CLSCLASS CPX INTERFACE Snapshot Table8KEY2CLASS CPX INTERFACE Second Keynvarchar120
12RODPS_HANA_ADMINSAP HANA ODP Administrative Data2KEY2nvarchar400
13SADL_V_DDIC_KEYTest table with several key columns3KEY230 Charactersnvarchar300
14T5GPBS_CS_CODESCode Set Codes3KEY2Code Set: Key Length 2nvarchar20
TOPABAP Authorization and Role Management
15AAA_KEYSSAP Authorization Assistant - Definition9KEY2String for Authorization Assistantnvarchar2550
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
16CRMCACHEOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED3KEY2nvarchar140
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
17OSTESTCL01Object Services Testklasse 01 Tabelle2KEY2nvarchar300
18OSTESTCL03Object Services Testklasse 03 Tabelle - Business Key only2KEY2Characterfeld der Länge 10nvarchar100
19TDATSR/3 DD: Control for Generating Data Interfaces8KEY2Second key field (if there is one)nvarchar300
TOPBasic Data
20NC01IS-HCM Dispatch Orders to HCM14KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar300
21NC301IS-HCM: Order Table Data Transmission for EDI16KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
22NC301SIS-HCM: EDI Status Management16KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
23NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records16KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
24DFPM_NUMBSequential Numbers3KEY2nvarchar200
TOPClinical System
25NC321IS-H: Table for data exchange of §32116KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPCommunication
26NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events13KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPContract Accounts Receivable and Payable
27DFKKPAYBWTrigger for Delta Extraction for Payments4KEY2Key2 for Trigger Tablenvarchar60
28DPAYNSequential Number Assignment3KEY2nvarchar200
TOPData Retention Tool
29TXW_C_STRCSegment structures5KEY2Index key fieldnvarchar300
TOPDevice Management
30EDTIDIS-U Device Checker: Allocation of Table Names - Table IDs4KEY2Field Namenvarchar300
TOPEnterprise Service Framework Layer
31SCOL_REF<cool> Reference Implementation: Detail Data3KEY2Numeric Character Field, Length 10nvarchar100
32SCOL_REF_RELAT<cool> Reference Implementation: Detail Data of the Relation3KEY2Numeric Character Field, Length 10nvarchar100
33SCOL_REF_SIB_1<cool> Reference Implementation: First Sibling3KEY2Numeric Character Field, Length 10nvarchar100
34SCOL_REF_SIB_2<cool> Reference Implementation: Second Sibling3KEY2Numeric Character Field, Length 10nvarchar100
TOPGeneral Ledger Accounting
35FAGL_RSIGReorganization: Signature4KEY2Reorganization: Key Field of the Signature (Data Element)nvarchar300
TOPGeneral Ledger Reorganization
36FAGL_R_OBJTYReorganization: Object Type7KEY2Field Name of the Second Key Fieldnvarchar300
TOPGlobal Organization Customizing
37TCUSCCUSC: Customizing Country Version, New Field Contents8KEY2Field Namenvarchar300
TOPInvoicing
38ECHANGE_SERVICEChange Service Database6KEY2Data Type 4 Charactersnvarchar40
TOPList Processing
39TPRI_PARABAP print parameter storage2KEY2Current index for PRI_PARAMS archive (buffer)nvarchar40
TOPObject Services
40OSVERIK02Object Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
41OSVERIK02AObject Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
42OSVERIK02BObject Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
43OSVERIK03Object Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
44OSVERIK03AObject Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
45OSVERIK03BObject Services: Tabelle für VERIS / Mapping Type BKey2KEY2Komponente der Versionsnummernvarchar20
TOPPayments
46DFKKBOHBoleto: Header data38KEY2Instruction key 2nvarchar20
TOPProcess Controls
47HRT5320Table Part Infotype 53205KEY2Extension Data Keynvarchar500
TOPProfitability Analysis
48TKEANCO-PA: Control Table for PA Derivation of Characteristics10KEY2Key field namenvarchar300
TOPSales
49LORD_OBJECTLean Order: Interface Objects6KEY2Field Namenvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
50ISH_HCF_HEADERHeader for Index Table11KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
51ISH_IDX_HEADERHeader for Index Table13KEY2IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPSAP List Viewer
52SALV_EX_STORAGEALV Data Repository for External Access5KEY2GUID in 'CHAR' Format in Uppercasenvarchar320
TOPSyntax, Compiler, Runtime
53VERI_OPEN_SQLTesttabelle für Open SQL Veris2KEY2R/2-Tabellenvarchar50
TOPTable History
54TLOGTESTTest Table Logging3KEY2Flight Connection Numbernvarchar40
55TLOGTESTTTest Table Logging and Maintenance3KEY2Flight Connection Numbernvarchar40
TOPTREX ABAP JAVA API
56TREXINTTABTabelle with integer and float values only2KEY2int100
TOPUI Services, Screen, Batch Input
57AROSTRINGTEST02Test: Prüftabelle mit String im Funktionsteil3KEY2CHAR05 fuer SYSTnvarchar50
TOPWarranty Claim Processing
58WTY_OBJNR_INDEXObject Number Index for Warranty Objects4KEY2Key Fieldnvarchar300