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

73 columns | Print definition?ERP 6.0  | TDNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CCGLT_PRTREQ_PAREHS: Print Request Parameters20TDNAMENamenvarchar700
2CNVTDMSCRM_STXHTDMS4CRM: Fill header table for STXH4TDNAMETDNAME for CNVTDMS_05_*nvarchar700
3CNVTDMSSRM_STXHTDMS SRM: Fill header table for STXH4TDNAMEText Descriptionnvarchar700
4CNVTDMS_05_STXHCollected Header Object Numbers for TDMS_Time-STXH4TDNAMETDNAME for CNVTDMS_05_*nvarchar700
5MDGHDB_LONGTEXTTable for Storing Long texts3TDNAMENamenvarchar700
6PSSTXH_KEYSStores Long text key of PS objects(Project,WBS,Netwrk,Actvt)3TDNAMELong text key for Project System objectsnvarchar700
7T159OInv. Mngmt Print Function: Maintain Text Name for Labels4TDNAMENamenvarchar700
8TTXVRText Processing: Copy Control Texts15TDNAMENamenvarchar700
9TTXZIText Processing: Copying Control for Access Sequences13TDNAMENamenvarchar700
10TZW02User <-> Determine message17TDNAMETDIC text namenvarchar160
11YIT_EXAMIDA: Examples12TDNAMENamenvarchar700
12YIT_PROCIDA: Processes in IDES17TDNAMENamenvarchar700
13YIT_TRAIIDA: Training Courses12TDNAMENamenvarchar700
TOPAccounts Receivable Accounting Process Integration
14TEBPPPMNTDESCRSAPScript used for payment descrption per company4TDNAMENamenvarchar700
TOPAudit trail enhancements ILM
15AUT_D_STXH_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving3TDNAMENamenvarchar700
16AUT_D_STXL_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving3TDNAMENamenvarchar700
17AUT_I_STXLAudit Trail (ILM): SAPscript Text File Lines (Dummy Table)4TDNAMENamenvarchar700
TOPBasis Services Communication Interfaces
18NASTMessage Status47TDNAMEObject key (long)nvarchar700
TOPBudgeting
19BUKUTEXTTEMPLTemplates for Budget Texts6TDNAMENamenvarchar700
20FMBUDTXTBudget texts register11TDNAMENamenvarchar700
TOPBusiness Rule Framework
21TBRF042BRF: Text GUIDs for BRF Objects7TDNAMENamenvarchar700
22TBRF100BRF: Application Class (Customer-Specific Features)13TDNAMENamenvarchar700
23TBRF100CBRF: Application Class - C Table13TDNAMENamenvarchar700
24TBRF110BRF: Event17TDNAMENamenvarchar700
25TBRF110CBRF: Event - C Table17TDNAMENamenvarchar700
26TBRF150BRF: Expression24TDNAMENamenvarchar700
27TBRF170BRF: Actions12TDNAMENamenvarchar700
28TBRF180BRF: Implementing Class16TDNAMENamenvarchar700
29TBRF180CBRF: Implementing Class - C Table16TDNAMENamenvarchar700
30TBRF280BRF: Rule Set - Header Data19TDNAMENamenvarchar700
31TBRF280CBRF: Rule Set - Header Data - C Table19TDNAMENamenvarchar700
TOPClaims Management
32TICL044Claims Management Activity or Prompting Message37TDNAMENamenvarchar700
33TICL052_2Assignment Text Module to Category3TDNAMENamenvarchar700
34TICL093SAPscript Texts for Tasks4TDNAMENamenvarchar700
35TICL950Claim Bundle: Task or Prompting Message35TDNAMENamenvarchar700
TOPCross-Application Components
36/IXOS/DC_TBCDOCLink table for changeable word documents16TDNAMENamenvarchar700
TOPDangerous Goods Management
37TDG47DG: Text names for DG material-master independent texts3TDNAMENamenvarchar700
TOPEEW Services
38OXT_ER_EXTTYPOXT Business Object Extension8TDNAMENamenvarchar700
TOPElectronic Data Records
39AUT_STXH_ARCHBuffer and Conversion Table for Archiving3TDNAMENamenvarchar700
40AUT_STXLSAPscript Text File Lines: Dummy Table for Audit Trails4TDNAMENamenvarchar700
41AUT_STXL_ARCHBuffer and Conversion Table for Archiving3TDNAMENamenvarchar700
TOPEnvironment, Health and Safety
42/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben21TDNAMENamenvarchar700
43/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv21TDNAMENamenvarchar700
44/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten21TDNAMENamenvarchar700
45/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv21TDNAMENamenvarchar700
TOPFlexible Real Estate Management
46TIVHOCP03Textbausteinzuordnung4TDNAMEName des Textbausteinsnvarchar700
TOPFunds Management
47BPTXBudgeting Text15TDNAMENamenvarchar700
TOPInterfaces
48VXSITDExpress Delivery Company22TDNAMENamenvarchar700
TOPMaintenance Notifications
49TQ80Notification Types71TDNAMENamenvarchar700
TOPMaintenance Orders
50T350Maintenance Control Parameters: Client/Order Type25TDNAMENamenvarchar700
TOPMarketing
51ECRMMKT_PRCampaign: Header Data Trigger for Print Action Records8TDNAMEName of a standard text for a print action recordnvarchar500
TOPMedia Sales and Distribution
52/NAM/TJKDISPREDispatching reason4TDNAMENamenvarchar700
TOPOperative Structures
53PSTXBSAPscript: Texts in non-SAPscript format4TDNAMENamenvarchar700
54PSTXHPTXD PS Text File Header3TDNAMENamenvarchar700
TOPOutput Determination
55NACHDetailed output data31TDNAMEObject key (long)nvarchar700
TOPPayroll
56T5TPSTXT02Texty pro formuláre v doplncích opatrení .8TDNAMENázevnvarchar700
TOPPrint Workbench
57EPRINTACTFFlyers/Standard Texts for Print Action Records4TDNAMEName of a standard text for a print action recordnvarchar500
TOPProcess Data Documentation
58REBR5Batch Record: Cover Page3TDNAMENamenvarchar700
TOPProduct Safety
59CVDDPEHS: Parameter Values for Report Shipping23TDNAMENamenvarchar700
60ESTAHEHS: Application-dependent data for report generation10TDNAMETDIC text namenvarchar160
TOPReal Estate Management
61TIVKATEDefinition of Categories3TDNAMEDefault text module for additional textsnvarchar700
62VIMI04Old. replaced in 3.0 with VIMIMV100TDNAMENamenvarchar700
63VIMIMVLease-Out80TDNAMENamenvarchar700
64VIMIMVKATEText Module in Dependence of Category and Rental Agreement5TDNAMENamenvarchar700
TOPSAPscript
65STXBSAPscript: Texts in non-SAPscript format4TDNAMENamenvarchar700
66STXBITMAPSSAPscript Graphics Management2TDNAMENamenvarchar700
67STXHSTXD SAPscript text file header3TDNAMENamenvarchar700
68STXLSTXD SAPscript text file lines4TDNAMENamenvarchar700
69TFO14PDF converter: Encoding vector for Adobe type 1 font5TDNAMEAFM linenvarchar720
TOPTranslation Tools
70LXE_CSN_HD2Notes4TDNAMENamenvarchar700
TOPTravel Expenses
71T706_DEFAULTTEXTNames of Reference Texts for Entering Trips8TDNAMENamenvarchar700
72T706_TEXTNAMESNames of Reference Texts for Entering Trips4TDNAMENamenvarchar700
TOPValuation
73OIUVL_CM_STATPRA statement configuration14TDNAMENamenvarchar700