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

74 columns | Print definition?ERP 6.0  | SCHEME_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/D_WF_018Table for persistent class /SAPSRM/CL_WF_RUNTIME5SCHEME_IDProcess Level Schemanvarchar320
2BBPC_TXT_MAP_EXTDatabase Table for External Text Mapping6SCHEME_IDText Schemanvarchar40
3UKMDB_KEYADDR0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
4UKMDB_KEYPROD0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
5UKMDB_SCHADDR0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
6UKMDB_SCHPROD0UKM: Key schema2SCHEME_IDUKM: Key schema IDvarbinary160
TOPAccounting
7TDIOA_SCHEMETText Table for Profile Definition IOA Calculation3SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
8TDIOA_SCHEME_BALAssignment of Product Type to Profile and Flow Type Grouping4SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
9TDIOA_SCHEME_DEFProfile Definition for Interest on Arrears Calculation2SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
10TDIOA_TRIV_AMTTrivial Amount per Currency and Profile IOA Calculation5SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
TOPAgency Business Global Trade
11WBRKAgency business: Header167SCHEME_IDAB: Identifier for the ID Schemenvarchar600
12WBRPAgency business: Item160SCHEME_IDAB: Identifier for the ID Schemenvarchar600
TOPCentral Part of Product Master
13COMC_SCHEMENumbering Scheme2SCHEME_IDNumbering Schemenvarchar100
14COMC_SCHEME_SEGNumbering Scheme Segment2SCHEME_IDNumbering Schemenvarchar100
15COMC_SCHEME_TNumbering Scheme Description2SCHEME_IDNumbering Schemenvarchar100
16COMM_SCHEMENumbering Scheme3SCHEME_IDNumbering Schemenvarchar100
TOPClient-System Adapter
17MDM_DISTR_XLOGMDM : Request Logging4SCHEME_IDMDM: Scheme ID.nvarchar600
TOPCollateral Management System
18CMS_MESSAGE_CRMKeymapping bei Datenaustausch via XI3SCHEME_IDEsquemanvarchar220
19TCMS_SCHEME_CRMSchema1SCHEME_IDProfilenvarchar220
TOPHealthcare Communication Framework
20TNHCF_ID_DESCDescription of Business Object identification4SCHEME_IDScheme IDnvarchar600
TOPKey Mapping
21UKMDB_KEYBNSS0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
22UKMDB_KEYCCGH0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
23UKMDB_KEYCHRT0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
24UKMDB_KEYCMPN0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
25UKMDB_KEYCSTC0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
26UKMDB_KEYENGN0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
27UKMDB_KEYFINA0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
28UKMDB_KEYFNCL0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
29UKMDB_KEYFNNC0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
30UKMDB_KEYGLAM0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
31UKMDB_KEYINDV0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
32UKMDB_KEYINST0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
33UKMDB_KEYLGST0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
34UKMDB_KEYMATE0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
35UKMDB_KEYORGC0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
36UKMDB_KEYPCGH0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
37UKMDB_KEYPLNT0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
38UKMDB_KEYPRFT0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
39UKMDB_KEYSLSF0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
40UKMDB_SCHBNSS0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
41UKMDB_SCHCCGH0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
42UKMDB_SCHCHRT0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
43UKMDB_SCHCMPN0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
44UKMDB_SCHCSTC0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
45UKMDB_SCHENGN0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
46UKMDB_SCHFINA0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
47UKMDB_SCHFNCL0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
48UKMDB_SCHFNNC0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
49UKMDB_SCHGLAM0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
50UKMDB_SCHINDV0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
51UKMDB_SCHINST0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
52UKMDB_SCHLGST0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
53UKMDB_SCHMATE0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
54UKMDB_SCHORGC0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
55UKMDB_SCHPCGH0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
56UKMDB_SCHPLNT0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
57UKMDB_SCHPRFT0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
58UKMDB_SCHSLSF0UKM: Key Schema2SCHEME_IDUKM: Key schema IDvarbinary160
TOPLoans Management
59TDIOA_SCHM_TPLDefault Calculation Profile for New Loan4SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
60TTONFTVDARLTest neue Fima: Grunddaten und VDARL170SCHEME_IDBerechnungsschema für die Verzugszinsberechnungnvarchar30
61VDARLLoans156SCHEME_IDCalculation Profile for Interest on Arrears Calculationnvarchar30
TOPSelf-Service Procurement
62/SRMERP/D_WF_018Table for persistent class /SRMERP/CL_WF_RUNTIME5SCHEME_IDProcess Level Schemanvarchar320
TOPSingapore
63PA0739HR Master Record: Infotype 0739 [Stock Option] (SG)24SCHEME_IDStock Option Plannvarchar40
64T5RSOP_P_SCHEMEStock Option Scheme Assignment to Plan2SCHEME_IDStock Option Plannvarchar40
65T5RSOP_SCHEMEStock Option Scheme2SCHEME_IDStock Option Plannvarchar40
66T5RSOP_SCHEME_TText table for Scheme3SCHEME_IDStock Option Plannvarchar40
67T5RSOP_SCH_ESOWStock Option Scheme for ESOW2SCHEME_IDStock Option Plan for ESOWnvarchar40
68T5RSOP_SC_ESOW_TText table for Schemes under ESOW3SCHEME_IDStock Option Plan for ESOWnvarchar40
TOPStandardized Key Mapping
69UKMDB_KEY00000UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
70UKMDB_KEYUNIT0UKM: Key5SCHEME_IDUKM: Key schema IDvarbinary160
71UKMDB_SCH00000UKM: Key schema2SCHEME_IDUKM: Key schema IDvarbinary160
72UKMDB_SCHUNIT0UKM: Key schema2SCHEME_IDUKM: Key schema IDvarbinary160
73UKM_SCHEMEUKM: Key schema1SCHEME_IDUKM: Key schema IDvarbinary160
TOPUse AP-MD-BP Components
74TB039BP ID Categories5SCHEME_IDIdentification Schemanvarchar600