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

90 columns | Print definition?ERP 6.0  | KEY1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PDDEPDB Structure for Factor and Distribution Set5KEY1Key for Dependent Attributesnvarchar320
2CLF_OBJKEY_MPPNGClassification Object Key Mapping5KEY1Key of object to be classifiednvarchar500
3CNV_10020_ACTALActions for log9KEY1Indicator for key membershipnvarchar10
4CNV_10020_ACTANActions for messages11KEY1Indicator for key membershipnvarchar10
5CNV_20800_PARAMMulti-purpose generic parameter table4KEY1Additional information for a parameternvarchar300
6CNV_20800_STATStatistics - feedback from projects3KEY1Additional information for a parameternvarchar300
7CNV_20900_PARAMMulti-purpose generic parameter table4KEY1Additional information for a parameternvarchar300
8HRP5354DB Table for Infotype 535424KEY1Extension Data Keynvarchar500
9MDGHDB_LONGTEXTTable for Storing Long texts6KEY1Namenvarchar700
10NWS_EXT_CONKEYCombined Key Fields6KEY1Field Namenvarchar300
11RODPS_HANA_ADMINSAP HANA ODP Administrative Data1KEY1nvarchar40
12SADL_V_DDIC_KEYTest table with several key columns2KEY130 Charactersnvarchar300
13T5GPBS_CS_CODESCode Set Codes2KEY1Code Set: Key Length 1nvarchar10
14TDBSELVERSVER: Testtabelle für Double-Byte Selektionen.1KEY1nvarchar100
15TREXBCTESTTAB9TREX: Test table for Basis Client.1KEY1int100
16TVEP6Transparent Table for Verif. II (All DB field types, len. F)1KEY1Data element NUMC 05 for automatic verificationnvarchar50
17TVEP7transp. Tab. f. Verifik. II (lange F.)1KEY1Datenelement NUMC 05 für maschinelle Verifikationnvarchar50
TOPABAP Authorization and Role Management
18AAA_KEYSSAP Authorization Assistant - Definition8KEY1String for Authorization Assistantnvarchar2550
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
19CRMCACHEOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED2KEY1nvarchar40
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
20OSTESTCL01Object Services Testklasse 01 Tabelle1KEY1nvarchar300
21OSTESTCL02Object Services Testklasse 02 Tabelle1KEY1nvarchar300
22OSTESTCL03Object Services Testklasse 03 Tabelle - Business Key only1KEY1Characterfeld der Länge 10nvarchar100
23OSVERI02Object Services: Tabelle für VERIS / Mapping Type BKey1KEY1nvarchar300
24OSVERI03Object Services: Tabelle für VERIS / Mapping Type BKOID1KEY1nvarchar300
25OSVERI04Object Services: Tabelle für VERIS / TypeMapping Type BKey1KEY1nvarchar300
26OSVERI10Object Services: Tabelle für VERIS / TypeMapping Type BkOID1KEY1nvarchar300
27OSVERI13Object Services: Tabelle für VERIS / TypeMapping Type BKey1KEY1nvarchar300
28TDATSR/3 DD: Control for Generating Data Interfaces7KEY1First key fieldnvarchar300
TOPBasic Data
29NC01IS-HCM Dispatch Orders to HCM13KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar300
30NC301IS-HCM: Order Table Data Transmission for EDI15KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
31NC301SIS-HCM: EDI Status Management15KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
32NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records15KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
33DFPM_NUMBSequential Numbers2KEY1nvarchar800
TOPBusiness Consolidation
34UCF0001Applications: Dynamic Key for Methods3KEY1Key Field for the Methodnvarchar80
TOPClinical System
35NC321IS-H: Table for data exchange of §32115KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPCommunication
36NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events12KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPContract Accounts Receivable and Payable
37DFKKPAYBWTrigger for Delta Extraction for Payments3KEY1Key1 for Trigger Tablenvarchar120
38DPAYNSequential Number Assignment2KEY1nvarchar800
TOPContract Billing
39EBICO_TESTTest TW2KEY1Three-digit character field for IDocsnvarchar30
TOPData Retention Tool
40TXW_C_STRCSegment structures4KEY1Primary key fieldnvarchar300
TOPDB2 for OS39
41DB2MONDB2/390 Monitor Table1KEY1Natural Numberint100
TOPDevice Management
42EDTIDIS-U Device Checker: Allocation of Table Names - Table IDs3KEY1Field Namenvarchar300
TOPEnterprise Service Framework Layer
43SCOL_REF<cool> Reference Implementation: Detail Data2KEY1Numeric Character Field, Length 10nvarchar100
44SCOL_REF_RELAT<cool> Reference Implementation: Detail Data of the Relation2KEY1Numeric Character Field, Length 10nvarchar100
45SCOL_REF_SIB_1<cool> Reference Implementation: First Sibling2KEY1Numeric Character Field, Length 10nvarchar100
46SCOL_REF_SIB_2<cool> Reference Implementation: Second Sibling2KEY1Numeric Character Field, Length 10nvarchar100
TOPGeneral Ledger Accounting
47FAGL_RSIGReorganization: Signature3KEY1Reorganization: Key Field of the Signature (Data Element)nvarchar300
TOPGeneral Ledger Reorganization
48FAGL_R_OBJTYReorganization: Object Type5KEY1Field Name of First Key Fieldnvarchar300
TOPGlobal Organization Customizing
49TCUSCCUSC: Customizing Country Version, New Field Contents7KEY1Field Namenvarchar300
TOPInvoicing
50ECHANGE_SERVICEChange Service Database5KEY1Character field of length 12nvarchar120
TOPList Processing
51TPRI_PARABAP print parameter storage1KEY1nvarchar120
TOPMDG for Financials
52USMDZ5102Assignment of Keys of Entity Types to InfoObjects3KEY1Resolved Attributenvarchar160
TOPObject Services
53OSVERI05Object Services: Tabelle für VERIS / TypeMapping Type BKey1KEY1nvarchar300
54OSVERI06Object Services: Tabelle für VERIS / TypeMapping Type BKey1KEY1nvarchar300
55OSVERI11Object Services: Tabelle für VERIS / TypeMapping Type BkOID1KEY1nvarchar300
56OSVERI12Object Services: Tabelle für VERIS / TypeMapping Type BkOID1KEY1nvarchar300
57OSVERI19Object Services: Tabelle für VERIS / TypeMapping Type BkOID1KEY1nvarchar300
58OSVERIK02Object Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
59OSVERIK02AObject Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
60OSVERIK02BObject Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
61OSVERIK03Object Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
62OSVERIK03AObject Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
63OSVERIK03BObject Services: Tabelle für VERIS / Mapping Type BKey1KEY1Numerisches Characterfeld der Länge 10nvarchar100
64OSVERIV02Object Services: Tabelle für VERIS / Mapping Type OID1KEY1Numerisches Characterfeld der Länge 10nvarchar100
65OSVERIV03Object Services: Tabelle für VERIS / Mapping Type OID1KEY1Numerisches Characterfeld der Länge 10nvarchar100
TOPPayments
66DFKKBOHBoleto: Header data37KEY1Instruction key 1nvarchar20
TOPProcess Controls
67HRT5320Table Part Infotype 53204KEY1Extension Data Keynvarchar500
TOPProfitability Analysis
68TKEANCO-PA: Control Table for PA Derivation of Characteristics9KEY1Key field namenvarchar300
TOPRuntime for ABAP based automated TC
69STC_TEST_TABTest Table for Task Tests2KEY1Character Field Length = 10nvarchar100
TOPSales
70LORD_OBJECTLean Order: Interface Objects5KEY1Field Namenvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
71ISH_HCF_HEADERHeader for Index Table10KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
72ISH_IDX_HEADERHeader for Index Table12KEY1IS-HCM: Key Value for Data Retrieval for Dispatch Ordernvarchar200
TOPSAP List Viewer
73SALV_EX_STORAGEALV Data Repository for External Access4KEY1GUID in 'CHAR' Format in Uppercasenvarchar320
TOPSyntax, Compiler, Runtime
74VERI_OPEN_SQLTesttabelle für Open SQL Veris1KEY1R/2-Tabellenvarchar50
TOPTable History
75TLOGTESTTest Table Logging2KEY1Organization criterion for key-specific authorizationnvarchar300
76TLOGTESTTTest Table Logging and Maintenance2KEY1Organization criterion for key-specific authorizationnvarchar300
TOPTreasury
77VZPARUSUser data central partner and address management3KEY1First key fieldnvarchar300
TOPTREX ABAP JAVA API
78TREXBCTESTTAB1TREX: Test table for Basis Client.1KEY1int100
79TREXBCTESTTAB2TREX: Test table for Basis Client.1KEY1int100
80TREXBCTESTTAB3TREX: Test table for Basis Client.1KEY1int100
81TREXBCTESTTAB4TREX: Test table for Basis Client.1KEY1int100
82TREXBCTESTTAB5TREX: Test table for Basis Client (incl. XSD* domains)1KEY1int100
83TREXBCTESTTAB6TREX: Test table for Basis Client.1KEY1int100
84TREXBCTESTTAB7TREX: Test table for Basis Client.1KEY1int100
85TREXBCTESTTAB8TREX: Test table for Basis Client.1KEY1int100
86TREXBCTEST_BINTREX: binary data test.1KEY1Dummy for B20 int1 (Local Everywhere)tinyint30
87TREXINTTABTabelle with integer and float values only1KEY1int100
TOPUI Services, Screen, Batch Input
88AROSTRINGTEST01Test: Prüftabelle mit String im Funktionsteil2KEY1testnvarchar100
89AROSTRINGTEST02Test: Prüftabelle mit String im Funktionsteil2KEY1testnvarchar100
TOPWarranty Claim Processing
90WTY_OBJNR_INDEXObject Number Index for Warranty Objects3KEY1Key Fieldnvarchar300