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

124 columns | Print definition?ERP 6.0  | TDID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_TEXT_EXTTable for replicating text customizing settings from ERP3TDIDText IDnvarchar40
2CCGLT_PRTREQ_PAREHS: Print Request Parameters19TDIDText IDnvarchar40
3CNVTDMSCRM_STXHTDMS4CRM: Fill header table for STXH5TDIDTDID for CNVTDMS_05_*nvarchar40
4CNVTDMSSRM_STXHTDMS SRM: Fill header table for STXH5TDIDText Typenvarchar40
5CNVTDMS_05_STXHCollected Header Object Numbers for TDMS_Time-STXH5TDIDTDID for CNVTDMS_05_*nvarchar40
6LOP_C_TXTGRPIDText ID's in Group4TDIDText IDnvarchar40
7MDGHDB_LONGTEXTTable for Storing Long texts4TDIDText IDnvarchar40
8NWS_EXT_TXTOBJAdmissible Text Objects per Data Object5TDIDText IDnvarchar40
9T159OInv. Mngmt Print Function: Maintain Text Name for Labels3TDIDText IDnvarchar40
10T165KCopying Options: Header Texts5TDIDTarget text ID for adoption of textsnvarchar40
11T165PCopying Options: Item texts4TDIDTarget text ID for adoption of textsnvarchar40
12T169BNotifiable PO Supplement Types3TDIDText IDnvarchar40
13TEWAWATEXTASSGNAllocation of Text IDs to Text Profiles in Fast Entry Wghng3TDIDText IDnvarchar40
14TTXERText Processing: Text ID Groups5TDIDText IDnvarchar40
15TTXF1Word Processing: Linking of Texts with Document Types3TDIDText IDnvarchar40
16TTXSText Processing: Text Type in Text Proc. -> Access Sequence4TDIDText IDnvarchar40
17TZW02User <-> Determine message16TDIDText IDnvarchar40
18YIT_EXAMIDA: Examples10TDIDText IDnvarchar40
19YIT_PROCIDA: Processes in IDES15TDIDText IDnvarchar40
20YIT_TRAIIDA: Training Courses10TDIDText IDnvarchar40
TOPAccounts Receivable Accounting Process Integration
21EBPP_TTXIDText IDs for Biller Direct complaint texts2TDIDText IDnvarchar40
22TEBPPPMNTDESCRSAPScript used for payment descrption per company3TDIDText IDnvarchar40
TOPAgency Business Global Trade
23TCWBCRAB-CWB: Reasons for Complaint8TDIDText ID for text edit controlnvarchar40
24TMFKAgency Business: Billing Document Types47TDIDText ID for text edit controlnvarchar40
TOPAppropriation Requests
25TAIF1LLong text control for approp. request type for req. header3TDIDText IDnvarchar40
26TAIF1VLong text control for approp. request type for variants3TDIDText IDnvarchar40
TOPAudit trail enhancements ILM
27AUT_C_DELTTXIDAudit Trail (ILM): DBTABLOG Long Text Obj. w/o Logging3TDIDText IDnvarchar40
28AUT_D_STXH_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving4TDIDText IDnvarchar40
29AUT_D_STXL_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving4TDIDText IDnvarchar40
30AUT_I_STXLAudit Trail (ILM): SAPscript Text File Lines (Dummy Table)5TDIDText IDnvarchar40
TOPBasic Functions
31TVAKSales Document Types95TDIDText IDnvarchar40
32TVLKDelivery Types61TDIDText IDnvarchar40
33TVLPDeliveries: Item Categories40TDIDText IDnvarchar40
TOPBasis Services Communication Interfaces
34NASTMessage Status48TDIDText IDnvarchar40
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
35NOTE_VIEWViews for Notes4TDIDText IDnvarchar40
TOPBudgeting
36BUKUTEXTCATBudget Text Categories3TDIDText IDnvarchar40
TOPBusiness Application Support
37CNV_10992_TSTRUCStructure of text object keys for texts2TDIDText IDnvarchar40
TOPBusiness Partner
38BPUNOTABusiness Partner: Convert Memos5TDIDText IDnvarchar40
TOPBusiness Partner Enhancements for Financial Services
39TPZ14Business Partner: Role Category Text ID - Assignment4TDIDText IDnvarchar40
TOPCase Management
40SCMGTEXTIDCase: Text IDs for Text Profile3TDIDText IDnvarchar40
TOPChargeback
41TWCBTXTGRPIDText Types in Determination Procedure4TDIDText IDnvarchar40
TOPClaims Management
42TICL044Claims Management Activity or Prompting Message38TDIDText IDnvarchar40
43TICL950Claim Bundle: Task or Prompting Message36TDIDText IDnvarchar40
TOPCollectionsDisbursements
44TKKVNFAELFunction Modules for Determining Later Due Dates5TDIDText ID (SAPScript) for add. note to payee textnvarchar40
TOPConditions
45T685AConditions: Types: Additional Price Element Data57TDIDText ID for text edit controlnvarchar40
46T6B1Rebate : Rebate Agreement Types41TDIDText ID for text edit controlnvarchar40
TOPCross-Application Components
47/IXOS/DC_TBCDOCLink table for changeable word documents17TDIDText IDnvarchar40
48VVBUVSales Document: Incompletion Log6TDIDText IDnvarchar40
TOPCustomer Contact
49BPCT_CRM_TDIDCreation of Text ID Contact -> Activity2TDIDText IDnvarchar40
TOPDangerous Goods Management
50TDG21DG: Link table to text IDs3TDIDText IDnvarchar40
TOPDownloadUpload
51/DSD/HH_DRVTXTDSD: Download HH - Driver Messages6TDIDText IDnvarchar40
TOPDSD Connector
52/DSD/ME_MSG_CUSTDSD Connector: Definitions of Driver Messages4TDIDText IDnvarchar40
53/DSD/ME_MSG_HDDSD CN: Message header data3TDIDText IDnvarchar40
TOPElectonic Signature
54/DSD/ES_TEXT_IDDSD Signature text id3TDIDText IDnvarchar40
TOPElectronic Data Records
55AUTDELTTXIDLong Text Objects Not To Be Logged on DBTABLOG3TDIDText IDnvarchar40
56AUT_STXH_ARCHBuffer and Conversion Table for Archiving4TDIDText IDnvarchar40
57AUT_STXLSAPscript Text File Lines: Dummy Table for Audit Trails5TDIDText IDnvarchar40
58AUT_STXL_ARCHBuffer and Conversion Table for Archiving4TDIDText IDnvarchar40
TOPEnvironment, Health and Safety
59/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten22TDIDText IDnvarchar40
60/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv22TDIDText IDnvarchar40
TOPGeneral Functions
61TASSIGN_IV_T169BAuxiliary Table for Status Information IV Maintenance View3TDIDText IDnvarchar40
TOPGlobal Trade Services
62/SAPSLL/TLETGSMapping Feeder System Text Type to Text ID at FS Group Level5TDIDText IDnvarchar40
63/SAPSLL/TLETVSMapping Feeder System Text Type to Text ID at FS Level5TDIDText IDnvarchar40
TOPInterface to Terminal Automation System
64OIKTTDSTXOIL-TPI: Text IDs per TPP and interface type5TDIDText IDnvarchar40
TOPJoint Venture und Production Sharing Accounting
65T8J67JV EDI Outbound: Company configuration12TDIDText IDnvarchar40
TOPLegal Case Management for ILM
66SLCM_COMMENTSILM: Legal Case Management - Comments5TDIDText IDnvarchar40
TOPLocalization
67IDMX_DI_TXTIDDETDigital Invoice Mexico: Data ID - Text ID Determination5TDIDText IDnvarchar40
68J_3RFTAX_EXTRDTax Extract Detail Lines126TDIDText IDnvarchar40
69RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions125TDIDText IDnvarchar40
70RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions125TDIDText IDnvarchar40
71RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions125TDIDText IDnvarchar40
TOPLogistics - General
72TB2BRTC: Item Texts Types Whose Changes are to be Saved4TDIDText IDnvarchar40
73TB2BSTC: Header Text Types Whose Changes are to be Saved3TDIDText IDnvarchar40
74TB2BTText Types for Display of Changes (Header)3TDIDText IDnvarchar40
75TB2BUText Types for Display of Changes (Item)3TDIDText IDnvarchar40
TOPMaintenance Notifications
76TQ80Notification Types72TDIDText IDnvarchar40
TOPMaintenance Orders
77T350Maintenance Control Parameters: Client/Order Type26TDIDText IDnvarchar40
TOPMarketing
78ECRMMKT_PRCampaign: Header Data Trigger for Print Action Records9TDIDText IDnvarchar40
TOPMaterial Maintenance
79TTXERNText Processing: Text ID Groups covers ttxs & ttxer5TDIDText IDnvarchar40
TOPMaterial Master
80LTX1_TMPFile for Incorrect Data in Direct Input9TDIDText IDnvarchar40
TOPMaterials Management
81/SAPNEA/JSC01Subcontracting Global Maintenance13TDIDText IDnvarchar40
TOPMedia Sales and Distribution
82/NAM/TJKDISPREDispatching reason3TDIDText IDnvarchar40
TOPMessages
83DNOC_TYPE_TEXTText Segment Types6TDIDText IDnvarchar40
TOPMigration
84TIVMIMAPTXTMapping of Text Category4TDIDText IDnvarchar40
TOPOperative Structures
85PSTXBSAPscript: Texts in non-SAPscript format5TDIDText IDnvarchar40
86PSTXHPTXD PS Text File Header4TDIDText IDnvarchar40
TOPOutput Determination
87NACHDetailed output data32TDIDText IDnvarchar40
TOPPayroll
88T5TPSTXT02Texty pro formuláre v doplncích opatrení .3TDIDID textunvarchar40
89T5TPSTXT03Dynamické texty na formulári T5TPSTXT01 - pro infotyp 07297TDIDID textunvarchar40
TOPPeriodical Sales and Distribution
90TJYCIC_TEXTS_IDIS-M: CIC, Texts, Text IDs3TDIDText IDnvarchar40
91TJYCIC_TEXTS_IDTIS-M: CIC, Texts, Description for Text ID3TDIDText IDnvarchar40
92TJYCIC_TEXTS_TPNIS-M: CIC, Texts, Texts per Node5TDIDText IDnvarchar40
TOPPrint Workbench
93EFGSTTXTINFOVersion Information Standard Text2TDIDText IDnvarchar40
94EFGSTTXTOLINESPrint Workbench: Lines of Translated Texts2TDIDText IDnvarchar40
95EPRINTACTFFlyers/Standard Texts for Print Action Records5TDIDText IDnvarchar40
TOPProcess Data Documentation
96REBR5Batch Record: Cover Page5TDIDText IDnvarchar40
TOPProduct Safety
97CVDDPEHS: Parameter Values for Report Shipping22TDIDText IDnvarchar40
98ESTAHEHS: Application-dependent data for report generation9TDIDText IDnvarchar40
TOPPurchasing
99T166ASupplement Text in Purchasing Document Printouts6TDIDText IDnvarchar40
100T166KHeader Texts in Purchasing Document Printouts6TDIDText IDnvarchar40
101T166PItem Texts in Purchasing Document Printouts7TDIDText IDnvarchar40
TOPReal Estate Management
102VIMIMVKATEText Module in Dependence of Category and Rental Agreement6TDIDText IDnvarchar40
TOPRecords and Case Management
103RMPSDOD_RBASEHISTNA: Historical Data Disposal Schedules16TDIDText IDnvarchar40
104RMPSPRO_DP_REP1PRO Disposal Process: Disposal Transaction11TDIDText IDnvarchar40
105RMPSPRO_RBASEHISHistorical Data Disposal Schedules32TDIDText IDnvarchar40
106RMPSTNA_RBASEHISTNA: Historical Data Disposal Schedules16TDIDText IDnvarchar40
TOPRemaining Beverage - Obsolete Objects
107/BEV1/REALLGRental Item: Basic Data11TDIDText IDnvarchar40
108/BEV1/TSABERApplication Area14TDIDText ID Notebooknvarchar40
TOPRouting
109TTXCPObjects and IDs for client copy2TDIDText IDnvarchar40
TOPSales
110VBUVSales Document: Incompletion Log6TDIDText IDnvarchar40
TOPSAPscript
111STXBSAPscript: Texts in non-SAPscript format5TDIDText IDnvarchar40
112STXBITMAPSSAPscript Graphics Management3TDIDSAPscript Graphics Management: IDnvarchar40
113STXHSTXD SAPscript text file header4TDIDText IDnvarchar40
114STXLSTXD SAPscript text file lines5TDIDText IDnvarchar40
115TTXIDValid text IDs2TDIDText IDnvarchar40
116TTXITTexts for Text IDs3TDIDText IDnvarchar40
117TTXPSSAPscript: Tables for Program Symbols2TDIDText IDnvarchar40
TOPService Station Retailing
118OIRBTTXIDSSR Service Station Base: Text ID Activation2TDIDText IDnvarchar40
119OIRBTTXITSSR Service Station Base: Text ID Titles3TDIDText IDnvarchar40
TOPTraders and Schedulers Workbench
120OIJ_RU_CARRFIELDDefine Fields for Carrier Reference Data6TDIDText IDnvarchar40
121OIJ_RU_FI_POSTDefine posting parameters5TDIDText ID for Storing Document Descriptionnvarchar40
TOPTranslation Tools
122LXE_CSN_HD2Notes5TDIDText IDnvarchar40
TOPTransportation and Distribution
123TOIGTXTDefault Texts For Shipment Header8TDIDText IDnvarchar40
TOPTravel Expenses
124T706_DEFAULTTEXTNames of Reference Texts for Entering Trips7TDIDText IDnvarchar40