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

96 columns | Print definition?ERP 6.0  | TDOBJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_TEXT_EXTTable for replicating text customizing settings from ERP2TDOBJECTTexts: Application Objectnvarchar100
2CCGLT_PRTREQ_PAREHS: Print Request Parameters18TDOBJECTTexts: Application Objectnvarchar100
3CNVTDMSCRM_STXHTDMS4CRM: Fill header table for STXH3TDOBJECTTDOBJECT for CNVTDMS_05_*nvarchar100
4CNVTDMSSRM_STXHTDMS SRM: Fill header table for STXH3TDOBJECTApplication Object of the Textnvarchar100
5CNVTDMS_05_STXHCollected Header Object Numbers for TDMS_Time-STXH3TDOBJECTTDOBJECT for CNVTDMS_05_*nvarchar100
6CNV_10992CONTROLControl table for 'Find unknown texts'3TDOBJECTTexts: Application Objectnvarchar100
7CNV_10992_STXHSchedule existing TDOBJECT in STXH for optimization3TDOBJECTTexts: Application Objectnvarchar100
8J_3RF_REGCUS_TXTText Objects for Invoices (Russia)2TDOBJECTTexts: Application Objectnvarchar100
9LOP_C_TXTGRPGroup for Text ID2TDOBJECTLogistical Contract Option Application Objectnvarchar100
10LOP_C_TXTGRPIDText ID's in Group2TDOBJECTLogistical Contract Option Application Objectnvarchar100
11LOP_C_TXTGRPTDescription of Group for Text ID3TDOBJECTLogistical Contract Option Application Objectnvarchar100
12MDGHDB_LONGTEXTTable for Storing Long texts2TDOBJECTTexts: Application Objectnvarchar100
13NWS_EXT_TXTCODABAP Coding for Text Selection4TDOBJECTTexts: Application Objectnvarchar100
14NWS_EXT_TXTOBJAdmissible Text Objects per Data Object4TDOBJECTTexts: Application Objectnvarchar100
15RVTXOBJSD Text Determination: Allowed Text Objects1TDOBJECTTexts: Application Objectnvarchar100
16STXXFILTERFilter for Logging SAP Script Texts2TDOBJECTTexts: Application Objectnvarchar100
17T159MInv. Managmt Print Function: Active Form Version, Labels6TDOBJECTText: application objectnvarchar100
18T159OInv. Mngmt Print Function: Maintain Text Name for Labels2TDOBJECTText: application objectnvarchar100
19T165KCopying Options: Header Texts3TDOBJECTTarget object for adoption of textsnvarchar100
20T165PCopying Options: Item texts3TDOBJECTTarget object for adoption of textsnvarchar100
21TTABTax Table Dependent Parameters (Foreign Key)3TDOBJECTTexts: Application Objectnvarchar100
22TTXERText Processing: Text ID Groups2TDOBJECTTexts: Application Objectnvarchar100
23TTXF1Word Processing: Linking of Texts with Document Types2TDOBJECTTexts: Application Objectnvarchar100
24TTXSText Processing: Text Type in Text Proc. -> Access Sequence2TDOBJECTTexts: Application Objectnvarchar100
25TZW02User <-> Determine message15TDOBJECTTexts: Application Objectnvarchar100
TOPAccount Determination
26TTXGText Processing: Text ID Groups2TDOBJECTTexts: Application Objectnvarchar100
27TTXGTText processing: Text ID groups: Texts3TDOBJECTTexts: Application Objectnvarchar100
TOPAudit trail enhancements ILM
28AUT_C_DELTTXIDAudit Trail (ILM): DBTABLOG Long Text Obj. w/o Logging2TDOBJECTTexts: Application Objectnvarchar100
29AUT_I_STXLAudit Trail (ILM): SAPscript Text File Lines (Dummy Table)3TDOBJECTTexts: Application Objectnvarchar100
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
30NOTE_VIEWViews for Notes3TDOBJECTTexts: Application Objectnvarchar100
TOPBusiness Application Support
31CNV_10992_TSTRUCStructure of text object keys for texts1TDOBJECTTexts: Application Objectnvarchar100
TOPBusiness Partner
32BPUNOTABusiness Partner: Convert Memos4TDOBJECTTexts: Application Objectnvarchar100
TOPBusiness Partner Enhancements for Financial Services
33TPZ14Business Partner: Role Category Text ID - Assignment3TDOBJECTTexts: Application Objectnvarchar100
TOPChargeback
34TWCBTXTGRPText Determination Procedure2TDOBJECTCondition Contract Application Objectnvarchar100
35TWCBTXTGRPIDText Types in Determination Procedure2TDOBJECTCondition Contract Application Objectnvarchar100
36TWCBTXTGRPTText Determination Procedure3TDOBJECTCondition Contract Application Objectnvarchar100
TOPClaims Management
37TICL044Claims Management Activity or Prompting Message36TDOBJECTTexts: Application Objectnvarchar100
38TICL950Claim Bundle: Task or Prompting Message34TDOBJECTTexts: Application Objectnvarchar100
TOPCross-Application Components
39/IXOS/DC_TBCDOCLink table for changeable word documents15TDOBJECTTexts: Application Objectnvarchar100
TOPDownloadUpload
40/DSD/HH_DRVTXTDSD: Download HH - Driver Messages5TDOBJECTTexts: Application Objectnvarchar100
TOPDSD Connector
41/DSD/ME_MSG_CUSTDSD Connector: Definitions of Driver Messages3TDOBJECTTexts: Application Objectnvarchar100
42/DSD/ME_MSG_HDDSD CN: Message header data2TDOBJECTTexts: Application Objectnvarchar100
TOPElectronic Data Records
43AUTDELTTXIDLong Text Objects Not To Be Logged on DBTABLOG2TDOBJECTTexts: Application Objectnvarchar100
44AUT_STXLSAPscript Text File Lines: Dummy Table for Audit Trails3TDOBJECTTexts: Application Objectnvarchar100
TOPEnvironment, Health and Safety
45/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten20TDOBJECTTexts: Application Objectnvarchar100
46/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv20TDOBJECTTexts: Application Objectnvarchar100
TOPGlobal Trade Services
47/SAPSLL/TLETGSMapping Feeder System Text Type to Text ID at FS Group Level4TDOBJECTTexts: Application Objectnvarchar100
48/SAPSLL/TLETVSMapping Feeder System Text Type to Text ID at FS Level4TDOBJECTTexts: Application Objectnvarchar100
TOPInterface to Terminal Automation System
49OIKIFTYPTXOIL-TPI: Interface type - level control (text objects etc.3TDOBJECTTexts: Application Objectnvarchar100
TOPLegal Case Management for ILM
50SLCM_COMMENTSILM: Legal Case Management - Comments4TDOBJECTTexts: Application Objectnvarchar100
TOPLocalization
51IDMX_DI_TXTIDDETDigital Invoice Mexico: Data ID - Text ID Determination4TDOBJECTTexts: Application Objectnvarchar100
52IDMX_DI_TXTOBDigital Invoice Mexico: Valid Text Objects3TDOBJECTTexts: Application Objectnvarchar100
TOPMaintenance Notifications
53TQ80Notification Types70TDOBJECTTexts: Application Objectnvarchar100
TOPMaintenance Orders
54T350Maintenance Control Parameters: Client/Order Type24TDOBJECTTexts: Application Objectnvarchar100
TOPMaterial Maintenance
55TTXERNText Processing: Text ID Groups covers ttxs & ttxer2TDOBJECTTexts: Application Objectnvarchar100
TOPMessages
56DNOC_TYPE_TEXTText Segment Types5TDOBJECTTexts: Application Objectnvarchar100
TOPMigration
57TIVMIMAPTXTMapping of Text Category3TDOBJECTTexts: Application Objectnvarchar100
TOPNetWeaver Enterprise Search
58ESH_TTXOBESH: Indexed text objects2TDOBJECTTexts: Application Objectnvarchar100
TOPOperative Structures
59PSTXBSAPscript: Texts in non-SAPscript format3TDOBJECTTexts: Application Objectnvarchar100
60PSTXHPTXD PS Text File Header2TDOBJECTTexts: Application Objectnvarchar100
TOPPayroll
61T5TPSTXT02Texty pro formuláre v doplncích opatrení .2TDOBJECTTexty: Aplikacní objektnvarchar100
62T5TPSTXT03Dynamické texty na formulári T5TPSTXT01 - pro infotyp 07296TDOBJECTTexty: Aplikacní objektnvarchar100
TOPPeriodical Sales and Distribution
63TJKTBControl Table-Dependent Parameters3TDOBJECTTexts: Application Objectnvarchar100
64TJYCIC_TEXTS_IDIS-M: CIC, Texts, Text IDs2TDOBJECTTexts: Application Objectnvarchar100
65TJYCIC_TEXTS_IDTIS-M: CIC, Texts, Description for Text ID2TDOBJECTTexts: Application Objectnvarchar100
66TJYCIC_TEXTS_PTIS-M: CIC, Texts, Possible Text Objects per Node2TDOBJECTTexts: Application Objectnvarchar100
67TJYCIC_TEXTS_TPNIS-M: CIC, Texts, Texts per Node4TDOBJECTTexts: Application Objectnvarchar100
TOPPlant Master
68WRFT2Tables for an Object8TDOBJECTTexts: Application Objectnvarchar100
TOPProcess Data Documentation
69REBR5Batch Record: Cover Page4TDOBJECTTexts: Application Objectnvarchar100
TOPProduct Safety
70CVDDPEHS: Parameter Values for Report Shipping21TDOBJECTTexts: Application Objectnvarchar100
71ESTAHEHS: Application-dependent data for report generation8TDOBJECTTexts: Application Objectnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
72DFMCA_BRF112BRF: Text Name and Text ID for Additional Items16TDOBJECTTexts: Application Objectnvarchar100
TOPPurchasing
73T166ASupplement Text in Purchasing Document Printouts5TDOBJECTTexts: Application Objectnvarchar100
74T166KHeader Texts in Purchasing Document Printouts5TDOBJECTTexts: Application Objectnvarchar100
75T166PItem Texts in Purchasing Document Printouts6TDOBJECTTexts: Application Objectnvarchar100
TOPReal Estate Management
76TIV26Real Estate Contract Type (Entities)19TDOBJECTTexts: Application Objectnvarchar100
77VIMIMVKATEText Module in Dependence of Category and Rental Agreement4TDOBJECTTexts: Application Objectnvarchar100
TOPRecords and Case Management
78RMPSDOD_RBASEHISTNA: Historical Data Disposal Schedules15TDOBJECTTexts: Application Objectnvarchar100
79RMPSPRO_DP_REP1PRO Disposal Process: Disposal Transaction10TDOBJECTTexts: Application Objectnvarchar100
80RMPSPRO_RBASEHISHistorical Data Disposal Schedules31TDOBJECTTexts: Application Objectnvarchar100
81RMPSTNA_RBASEHISTNA: Historical Data Disposal Schedules15TDOBJECTTexts: Application Objectnvarchar100
TOPRemaining Beverage - Obsolete Objects
82/BEV1/TSABERApplication Area13TDOBJECTTexts: Application Object Notebooknvarchar100
TOPRouting
83TTXCPObjects and IDs for client copy1TDOBJECTTexts: Application Objectnvarchar100
TOPSAPscript
84STXBSAPscript: Texts in non-SAPscript format3TDOBJECTTexts: Application Objectnvarchar100
85STXBITMAPSSAPscript Graphics Management1TDOBJECTSAPscript Graphics Management: Application objectnvarchar100
86STXHSTXD SAPscript text file header2TDOBJECTTexts: Application Objectnvarchar100
87STXLSTXD SAPscript text file lines3TDOBJECTTexts: Application Objectnvarchar100
88TTXIDValid text IDs1TDOBJECTTexts: Application Objectnvarchar100
89TTXITTexts for Text IDs2TDOBJECTTexts: Application Objectnvarchar100
90TTXOBValid text objects1TDOBJECTTexts: Application Objectnvarchar100
91TTXOTShort Texts for Text Objects2TDOBJECTTexts: Application Objectnvarchar100
92TTXPSSAPscript: Tables for Program Symbols1TDOBJECTTexts: Application Objectnvarchar100
TOPShipping
93SHP_SRQ_TEXTPROCText Procedure with relevant texts for ShipmentRequestReq2TDOBJECTTexts: Application Objectnvarchar100
TOPTranslation Tools
94LXE_CSN_HD2Notes3TDOBJECTTexts: Application Objectnvarchar100
TOPTransportation and Distribution
95TOIGTXTDefault Texts For Shipment Header6TDOBJECTTexts: Application Objectnvarchar100
TOPVisit Control
96/DSD/VC_RVTXOBJVisit Control - Text Determination: Allowed Text Objects1TDOBJECTTexts: Application Objectnvarchar100