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

77 columns | Print definition?ERP 6.0  | TEXT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_TEXTCATSettings for text type3TEXT_TYPEText Typenvarchar50
2/IWFND/I_MED_TXKLanguage-Independent Table for entity texts4TEXT_TYPEText Type of an Entitynvarchar10
3/IWFND/I_MED_TXTLanguage-Dependent Table for Property Texts5TEXT_TYPEText Type of an Entitynvarchar10
4/SLOAP/TEXTSLOAS text mappings4TEXT_TYPESLOAS text typenvarchar300
5/SLOAP/TEXTTtransport tables for /SLOAS/TEXT6TEXT_TYPESLOAS text typenvarchar300
6/SLOAP/TEXT_2SLOAS text mappings - using SAP documentation3TEXT_TYPESLOAS text typenvarchar300
7/SLOAP/TEXT_2TTransport tbl -SLOAS text mappings - using SAP documentation5TEXT_TYPESLOAS text typenvarchar300
8/SLOAP/TXT_TYPESLOAS text types3TEXT_TYPESLOAS text typenvarchar300
9/SLOAP/TXT_TYPETtransport table for /SLOAS/TXT_TYPE5TEXT_TYPESLOAS text typenvarchar300
10/UI5/TREP_TEXTUI5 mapping table for texts from property files5TEXT_TYPENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
11/UIF/LREPDLTXTLRep long text table4TEXT_TYPELRep text typenvarchar40
12/UIF/LREPDLTXTCDLRep long text table - client-dependent5TEXT_TYPELRep text typenvarchar40
13/UIF/LREPDLTXTULRep long text table - user-dependent6TEXT_TYPELRep text typenvarchar40
14/UIF/LREPDSTXTLRep short text table4TEXT_TYPELRep text typenvarchar40
15/UIF/LREPDSTXTCDLRep short text table - client-dependent5TEXT_TYPELRep text typenvarchar40
16/UIF/LREPDSTXTULRep short text table - user-dependent6TEXT_TYPELRep text typenvarchar40
17/XFT/SSM_DOCC00Section Typ: Definition6TEXT_TYPEText Typnvarchar100
18/XFT/SSM_DOCC10SSM: Protokoll Typen5TEXT_TYPEText Typnvarchar100
19/XFT/SSM_DOC_00Section6TEXT_TYPEnvarchar100
20/XFT/SSM_DOC_10SSM: Protokoll5TEXT_TYPEnvarchar100
21BBPC_SUS_TEXTSUS: Definition of UI Texts2TEXT_TYPEText IDnvarchar40
22EHPRCD_ICH4TXChapter 4: Text table for Chapter 4 data4TEXT_TYPEText Typestinyint30
23PYC_D_TXT_FREEPYC: TEXT FROM FREE INPUT4TEXT_TYPEText ID for Process Step Templatenvarchar500
24PYC_D_TXT_MESSAGPYC: TEXT FROM MESSAGE CLASS3TEXT_TYPEText ID for Process Step Templatenvarchar500
25PYC_D_TXT_OTRPYC: TEXT FROM OTR3TEXT_TYPEText ID for Process Step Templatenvarchar500
26USMD_TXT_FLD_MAPBuffer table for mapping of text fields in BOL/GenIL UI7TEXT_TYPEText Type (Domain Value / Text Table)nvarchar10
TOPBRFplus - ABAP-Based Business Rules
27FDT_EXTY_0100FDT: Expression Type Data - Texts5TEXT_TYPEFDT: Text Typenvarchar40
28FDT_EXTY_0100AFDT: Expression Type Data - Texts5TEXT_TYPEFDT: Text Typenvarchar40
29FDT_EXTY_0100SFDT: Expression Type Data - Texts4TEXT_TYPEFDT: Text Typenvarchar40
30FDT_EXTY_0100TFDT: Expression Type Data - Texts4TEXT_TYPEFDT: Text Typenvarchar40
TOPBusiness Planning and Simulation
31UPC_VARVariables6TEXT_TYPEType of Textnvarchar100
32UPC_VARIABLEVariables - Old Version of Database (New is UPC_VAR)6TEXT_TYPEType of Textnvarchar100
TOPBusiness Service Functions
33RTXTFFormat Table for Report Texts4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
34RTXTHHeader Table for Report Texts4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
35RTXTLText Lines for Report Texts4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
36RTXTTText Header for Report Texts4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
TOPClassification System New
37CHARACTERTEXTDML Text Object6TEXT_TYPEMDF Text Typenvarchar100
38CHARACTERTEXTHDML Text Object7TEXT_TYPEMDF Text Typenvarchar100
39CME_ST_VAL_TXTDML Text Object6TEXT_TYPEMDF Text Typenvarchar100
40CME_ST_VAL_TXTHDML Text Object7TEXT_TYPEMDF Text Typenvarchar100
41DEFSCOPETEXTDML Text Object6TEXT_TYPEMDF Text Typenvarchar100
42DEFSCOPETEXTHDML Text Object7TEXT_TYPEMDF Text Typenvarchar100
43DTYPETEXTDML Text Object6TEXT_TYPEMDF Text Typenvarchar100
44DTYPETEXTHDML Text Object7TEXT_TYPEMDF Text Typenvarchar100
TOPeCATT Extended Computer Aided Test Tool
45ECTD_TEXTeCATT Short Texts: Parameters/Variants6TEXT_TYPEeCATT Type of Text (Defines Where it Belongs)nvarchar10
46ECTD_TEXT_NeCATT Short Texts Parameters/Variants Not Language-Specific5TEXT_TYPEeCATT Type of Text (Defines Where it Belongs)nvarchar10
TOPEnd User Technology
47RSRA_BP_RTXTFReport Agent BP Transport Copy/Versioning of rtxth4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
48RSRA_BP_RTXTHReport Agent BP Transport Copy/Versioning of rtxth4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
49RSRA_BP_RTXTLReport Agent BP Transport Copy/Versioning of rtxtl4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
50RSRA_BP_RTXTTReport Agent BP Transport Copy Versioning of rtxtt4TEXT_TYPEText type ('T'itle page, 'H'eader, 'F'ooter, 'E'nd page)nvarchar10
TOPEnvironment, Health and Safety
51/TDAG/CPA_ICH4TXChapter 4: Text table for Chapter 4 data4TEXT_TYPEText Typestinyint30
TOPExcise Duty
52/BEV2/CS_HDTEMCS Process: Texts for Header Data3TEXT_TYPEText IDnvarchar40
53/BEV2/CS_HDT_HEMCS Process: Texts for Header Data - History3TEXT_TYPEText IDnvarchar40
54/BEV2/CS_ITTEMCS Process: Texts for Items4TEXT_TYPEText IDnvarchar40
55/BEV2/CS_ITT_HEMCS Process: Texts for Items - History4TEXT_TYPEText IDnvarchar40
TOPGuided Procedure
56EUP_TSP_REQ_TXTGuided Procedure Transport Request Texts6TEXT_TYPENatural Numberint100
TOPI18N BiDi
57LST_WDA_DDIC_REPLST repository for DDIC texts5TEXT_TYPEtype of text, as given in propertiesnvarchar300
58LST_WDA_OTR_REPLST repository for OTR texts5TEXT_TYPEtype of text, as given in propertiesnvarchar300
TOPMaintenance Orders
59/MRSS/C_SGU_ATXTAssignment description/tooltip in planning board Gnatt3TEXT_TYPEAssignment Text Typetinyint30
TOPManagement of Internal Controls
60FOPCRBFCASETEXTSReport Buffer: Cases - Texts9TEXT_TYPEnvarchar40
TOPMaster Data Framework
61DML_DELIVERY_TXTMDF Text Object7TEXT_TYPEMDF Text Typenvarchar100
62DML_ST_TEXTDML Text Object6TEXT_TYPEMDF Text Typenvarchar100
63DML_ST_TEXTHDML Text Object7TEXT_TYPEMDF Text Typenvarchar100
TOPNetWeaver Demonstration
64SDEMO_TEXTSAP NetWeaver Demo Model - Text6TEXT_TYPEText Typenvarchar20
TOPOnline Text Repository
65BTFR_TYPES_SObject Type-Specific Text Types for Translation (Long Texts)3TEXT_TYPEText Type for Translationnvarchar40
66BTFR_TYPES_TObject Type-Specific Text Types for Translation(Short Texts)3TEXT_TYPEText Type for Translationnvarchar40
67SOTR_HEADHeader Table for OTR Texts15TEXT_TYPEType of Referenced Textsnvarchar30
68SOTR_HEADUHeader Table for Strings in the OTR15TEXT_TYPEType of Referenced Textsnvarchar30
TOPProcess Controls
69GRPCRBFCASETEXTSReport Buffer: Cases - Texts9TEXT_TYPEnvarchar40
TOPProxy Generation
70SPROXUITEXTSCache for UI Texts3TEXT_TYPEnvarchar400
TOPReusable Components of Business Suite Foundation
71/BOBF/DM_LTXT_CLong Text Content6TEXT_TYPEText Typenvarchar100
72/BOBF/D_TXCTXTText5TEXT_TYPEText Typenvarchar50
TOPSelf-Service Procurement
73/SRMERP/C_TXCPIText Copy Rule Item5TEXT_TYPEText Typenvarchar50
TOPUI Configuration Design Layer
74BSPC_DL_STXTREP2Repository for custom texts5TEXT_TYPEText Typenvarchar10
75BSP_DL_STXTREP2Text Repository4TEXT_TYPEText Typenvarchar10
TOPWithout Description
76RSCR_TEXTSCR: Table of Report Texts6TEXT_TYPECR Text Typenvarchar20
TOPWorkbench Utilities
77TEXTLOGLog of text changes in DW5TEXT_TYPECHAR01 data element for SYSTnvarchar10