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

82 columns | Print definition?ERP 6.0  | K1C4

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CVEP11K1C4nvarchar40
2CVEP11Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
3CVEP12Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
4CVEP13Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
5CVEP14Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
6CVEP21K1C4nvarchar40
7CVEP21Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
8CVEP22Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
9CVEP23Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
10CVEP24Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
11CVER11K1C4nvarchar40
12CVER11Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
13CVER12Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
14CVER13Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
15CVER14Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
16CVER15Cluster Table for Verification Runs (for Buffer Overwrites)1K1C4Data element CHAR 04 for machine verificationnvarchar40
17CVER21K1C4nvarchar40
18CVER21Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
19CVER22Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
20CVER23Cluster Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
21CVER24Cluster Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
22CVER25Cluster Table for Verification Runs (for Buffer Overwrites)1K1C4Data element CHAR 04 for machine verificationnvarchar40
23CVER51K1C4nvarchar40
24CVER50Cluster-Tabelle für Verifikationsläufe (diverse Felder)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
25CVER51Cluster-Tabelle für Verifikationsläufe (diverse Felder)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
26PVEU11Pooled Table for Verification Runs (Various Fields, Unbuff.)1K1C4Data element CHAR 04 for machine verificationnvarchar40
27PVEU12Pool. Tab. for Verif. Runs (Various Unaligned Fields, Unbuf)1K1C4Data element CHAR 04 for machine verificationnvarchar40
28PVEU13Pooled Table for Verification Runs (Various Fields, Unbuff.)1K1C4Data element CHAR 04 for machine verificationnvarchar40
29PVEU14Pool. Tab. for Verif. Runs (Various Unaligned Fields, Unbuf)1K1C4Data element CHAR 04 for machine verificationnvarchar40
30TACOPAVerifikation, Typ 'A', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
31TACOPABVerifikation, Typ 'AB', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
32TACOPACVerifikation, Typ 'AC', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
33TACOPADVerifikation, Typ 'A', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
34TAPOPAVerifikation, Typ 'A', ungepuffert (s. Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
35TAPOPMVerifikation, Typ 'M', ungepuffert (s. Doku Report VERIGEN)2K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
36TAPPPAVerifikation, Typ 'A', Tupelpufferung (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
37TAPVPAVerifikation, Typ 'A', 100% gepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
38TATGPAVerifikation, Typ 'A', gen. gepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
39TATOPAVerifikation, Typ 'A', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
40TATOPABVerifikation, Typ 'AB', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
41TATOPMVerifikation, Typ 'M', ungepuffert (Doku Report VERIGEN)2K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
42TATOPXVerifikation, Typ 'X', ungepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
43TATPPAVerifikation, Typ 'A', Tupelpufferung (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
44TATPPDVerifikation, Typ 'D', Tupelpufferung (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
45TATVPAVerifikation, Typ 'A', 100% gepuffert (Doku Report VERIGEN)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
46TATVPMVerifikation, Typ 'M', 100% gepuffert (Doku Report VERIGEN)2K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
47TBIGTransparent table for mass data generation1K1C4Data element CHAR 04 for machine verificationnvarchar40
48TUPROTTransparent, Unbuffered Table Logging1K1C4Data element CHAR 04 for machine verificationnvarchar40
49TUPROTSTransparent, ungepuffert Tabellenprotokollierung1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
50TVEM1Primary Table for Matchcode Verification, J. Nalik, 30.4.932K1C4nvarchar40
51TVEM1_OPrimaertabelle fuer Matchcode-Veri (vgl.TVEM1) ohne Mandant1K1C4VERY für Test von einem mandantenunabhängigen Matchcode-Objnvarchar40
52TVEM22K1C4nvarchar40
53TVEM2_OSekundaertabelle, VER003231K1C4VERY für Test von einem mandantenunabhängigen Matchcode-Objnvarchar40
54TVEMK2K1C4nvarchar40
55TVEMK_OTexttabelle, VER003231K1C4VERY für Test von einem mandantenunabhängigen Matchcode-Objnvarchar40
56TVEN1Wurzeltabelle für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
57TVEN2Basistabelle Stufe 1 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
58TVEN3Basistabelle Stufe 1 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
59TVEN4Basistabelle Stufe 2 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
60TVEN5Basistabelle Stufe 2 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
61TVEN6Basistabelle Stufe 2 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
62TVEN7Basistabelle Stufe 3 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
63TVEN8Basistabelle Stufe 3 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
64TVEN9Basistabelle Stufe 4 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
65TVENT1Texttabelle Stufe 1 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
66TVENT2Texttabelle Stufe 2 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
67TVENT3Texttabelle Stufe 2 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
68TVENT4Texttabelle Stufe 3 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
69TVENT5Texttabelle Stufe 3 für Stored Procedure - Matchcode - Test2K1C41. Schlüsselfeld zum Test von stored proceduresnvarchar40
70TVEP1Transparent Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
71TVEP2Transparent Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
72TVEP3Transparent Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
73TVEP4Transparent Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
74TVEU1Transparent Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
75TVEU2Transparent Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
76TVEU3Transparent Table for Verification Runs (Various Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
77TVEU4Transparent Table for Verif. Runs (Various Unaligned Fields)1K1C4Data element CHAR 04 for machine verificationnvarchar40
78TVIP4Pooltabelle für Verifikationsläufe (partiell gepuffert)1K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
79TVIT4Pooled table for verification runs (partially buffered)1K1C4Data element CHAR 04 for machine verificationnvarchar40
80TVMP4Pooltabelle für Verifikationsläufe (partiell gepuffert)2K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
81TVMT4Pooltabelle für Verifikationsläufe (partiell gepuffert)2K1C4Datenelement CHAR 04 für maschinelle Verifikationnvarchar40
82TVPP2Transparent Table for Verification Runs (Partially Buffered)1K1C4Data element CHAR 04 for machine verificationnvarchar40