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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

41 columns | Print definition?ERP 6.0  | LEN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMC_FIXEDVALUEMWB: Fixed Values5LENLength of a Fixed Valuenvarchar30
2DMC_VARIABLEMWB: Variables5LENLength of a Variablenvarchar30
3TACOPCVerifikation, Typ 'C', ungepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
4TACOPCAVerifikation, Typ 'CA', ungepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
5TATGPCVerifikation, Typ 'C', gen. gepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
6TATGPCAVerifikation, Typ 'CA', ungepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
7TATOPCVerifikation, Typ 'C', ungepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
8TATOPCAVerifikation, Typ 'CA', ungepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
9TATPPCVerifikation, Typ 'C', Tupelpufferung (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
10TATPPCAVerifikation, Typ 'CA', Tupelpufferung (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
11TATVPCVerifikation, Typ 'C', 100% gepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
12TATVPCAVerifikation, Typ 'CA', 100% gepuffert (Doku Report VERIGEN)22LENDatenelement INT2 für maschinelle Verifikationsmallint50
TOPAccounts Receivable Accounting Process Integration
13EBPPNOThe Counters for the Biller Direct Project are Saved Here3LENCounter Lengthtinyint30
TOPALE Integration Technology
14EDSEGEDI: Convert segments to 3.02LENLength of Field (Number of Characters)nvarchar40
TOPApplication-Specific Upgrade
15/ASU/CONTENTXMLASU: XML of the Content Version4LEN2 byte integer (signed)smallint50
TOPAsset Accounting
16IDPT_A099Checks for Asset Reports8LENLengthtinyint30
TOPCross-Application Components
17/IXOS/DC_TBCROverflow table for duplicate COLD records8LENLength for LRAWsmallint50
18/IXOS/DC_TBRBRecycle bin10LENLength for LRAWsmallint50
TOPData Conversion
19DMC_FIELDDMC: Data Field of a Structure17LENDMC: Field Lengths (of Types)nvarchar60
TOPData Staging
20RSMIMEATTRAttributes of Files in RSMIME2LENFile size of files in RSIMEnvarchar100
TOPeCATT Extended Computer Aided Test Tool
21ECEVT_DATOBSOLETE - Table for Transfer of GUI Event Data2LENNatural Numberint100
TOPElectronic Data Interchange
22PRICAT_K010SPrice Catalog: Last Structure of Structures10LENLength (No. of Characters)nvarchar60
TOPMaterials Management
23OPS_SE_TSTDATTest Data for generic Services Counterpart Test6LEN2 byte integer (signed)smallint50
TOPPatient Management
24NHLPFIELDIS-H: (Personal) Field Selection for F4 Help6LENIS-H: Output Length for Fieldnvarchar30
TOPPrint and Output Management
25TFRT_BLOBTypeface Repo - Binary Storage3LENint100
26TFRT_SRCH_KEYTypeface Repo - Table of Font key for search18LENTypeface Repo - Lengthint100
TOPSAP NetWeaver Mobile - Use subcomponents
27MEREP_10100Replica DB for Synchronization (Base) Segmt12LEN2 byte integer (signed)smallint50
28MEREP_10700DMobile Log Table for TOP Data15LEN2 byte integer (signed)smallint50
29MEREP_201Replica DB for Download (Base)15LEN2 byte integer (signed)smallint50
30MEREP_207Replica DB for Timed 2-Way Sync16LEN2 byte integer (signed)smallint50
31MEREP_210Variant for SyncBO Emulator6LEN2 byte integer (signed)smallint50
32MEREP_504Inbox/Outbox Data6LEN2 byte integer (signed)smallint50
TOPSpecification 2
33SPCIPMAPSPEC2000: MetaData Information on IP Files8LENLength of TEItinyint30
TOPSystem Landscape DirectoryComponent Repository
34LCRT_CLASS_LUAI-LCR: Class Names-Lookup5LENsmallint50
35LCRT_INST_LUAI-LCR: Instance Name-Lookup6LENsmallint50
36LCRT_NAMESP_LUAI-LCR: Namespace-Lookup4LENsmallint50
37LCRT_QUAL_LUAI-LCR: Qualifier Declarations Lookup5LENsmallint50
38LCRT_ROLE_LUAI-LCR: Instance Name-Lookup5LENsmallint50
TOPTransaction Manager
39TCORITS_CHK_CONDCheck Framework: Rule conditions6LENLength of condition fieldtinyint30
TOPTransport Organizer
40TLOCKChange and Transport System: Lock Table3LENActual length of the HIKEY keyint100
41TLOCKTSTLock Table: CTS (Test Copy of TLOCK)3LENActual length of the HIKEY keyint100