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

57 columns | Print definition?ERP 6.0  | TEXT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VT_VA2_TXTVIM Analytics 2: Text Elements2TEXT_IDInternal ABAP/4 text numbernvarchar80
2/SAPSRM/C_WD_TXSettings for Standard Display of Table Extensions on UI1TEXT_IDID of a 100-Character Textnvarchar300
3/SAPSRM/C_WD_TXTSettings for Standard Display of Table Extensions on UI1TEXT_IDID of a 100-Character Textnvarchar300
4/UIF/LREPDLTXTLRep long text table3TEXT_IDLRep text IDnvarchar320
5/UIF/LREPDLTXTCDLRep long text table - client-dependent4TEXT_IDLRep text IDnvarchar320
6/UIF/LREPDLTXTULRep long text table - user-dependent5TEXT_IDLRep text IDnvarchar320
7/UIF/LREPDSTXTLRep short text table3TEXT_IDLRep text IDnvarchar320
8/UIF/LREPDSTXTCDLRep short text table - client-dependent4TEXT_IDLRep text IDnvarchar320
9/UIF/LREPDSTXTULRep short text table - user-dependent5TEXT_IDLRep text IDnvarchar320
10/XLSO/TEXT_IDSales header text ID maintainance2TEXT_IDText IDnvarchar40
11BBPC_TEXT_IDCustomizing Table for Maintenance of Text IDs for TextSchema3TEXT_IDText IDnvarchar40
12BBPC_TEXT_ID_TCustomizing Table for Maintenance of Text IDs for TextSchema3TEXT_IDText IDnvarchar40
13BBPC_TEXT_VALUESFixed Values for Texts from SRM Documents3TEXT_IDText IDnvarchar40
14BBPC_TEXT_XMLXML Communication of Texts4TEXT_IDText IDnvarchar40
15BBPC_TXT_MAP_EXTDatabase Table for External Text Mapping7TEXT_IDText IDnvarchar40
16BBPC_TXT_VAL_TFixed Values for Texts from SRM Documents3TEXT_IDText IDnvarchar40
17REQTEXTText for Requirement Coverage Request Lines6TEXT_IDText IDnvarchar40
18WB2_C_PMR_INCCS: Settings PMR inbound for Condition Contract5TEXT_IDText IDnvarchar40
TOPBelgium
19T5BR3Social Risk Comments7TEXT_IDText Identification in Social Risk Declarationnvarchar50
20T5BR5Text identification for Social Risk Declaration2TEXT_IDText Identification in Social Risk Declarationnvarchar50
21T5BR5TTexts for Social Risk Comments3TEXT_IDText Identification in Social Risk Declarationnvarchar50
TOPBusiness Analytics
22UAB_XML_TRANSLXML Translation5TEXT_IDXML / XSLT Translation: Text IDnvarchar300
TOPClaims Management
23ICL_CNOTE_TEMPLID of a Text Template4TEXT_IDText IDnvarchar40
TOPClinical System
24N2CLIM_TEXTVSVital Signs Long Texts2TEXT_IDInternal Key of Text (GUID)nvarchar320
TOPCollaborative Cross Applications
25/POA/D_TRNPL_DCBUI PS Multi-Language Payload Parts - Default Content4TEXT_IDResource Value: ID of Text Fragment Referenced from Valueint100
26/POA/D_TRNPL_IMPBUI PS Text Fragments - Partition Import4TEXT_IDResource Value: ID of Text Fragment Referenced from Valueint100
27/POA/D_TRNPL_SCBUI PS Multi-Language Payload Parts - System Content4TEXT_IDResource Value: ID of Text Fragment Referenced from Valueint100
28/POA/D_TRN_PAYLBUI PS Resource Value: Texts Referenced from Value4TEXT_IDResource Value: ID of Text Fragment Referenced from Valueint100
TOPCross-Application Components
29ZTEXT_ELEMENTSText Elements for Gagdets3TEXT_IDCharacter field, length 32nvarchar320
TOPCustomer Enhancements
30ENHLOGEnhancement Log14TEXT_IDAbstraction of Possible Doc. Tool Objectsnvarchar400
TOPCustomer Interaction Center
31CCMSCRPROFScript activity profile7TEXT_IDScript Text IDnvarchar40
TOPExpense-Related Billing
32PRSC_CTRLEngagement mgmt: Process Control8TEXT_IDText IDnvarchar40
TOPGuided Procedure
33EUP_TSP_LTXT_DEGuided Procedure Long Text (Original Language German)2TEXT_IDCharacter field, length 32nvarchar320
34EUP_TSP_LTXT_ENGuided Procedure Longtexts (orginal language English)2TEXT_IDCharacter field, length 32nvarchar320
35EUP_TSP_REQ_TXTGuided Procedure Transport Request Texts5TEXT_IDCharacter field, length 32nvarchar320
36EUP_TSP_STXT_DEGuided Procedure Short Texts (Original Language German)2TEXT_IDCharacter field, length 32nvarchar320
37EUP_TSP_STXT_ENGuided Procedure Shorttexts (original language English)2TEXT_IDCharacter field, length 32nvarchar320
TOPLaunchpad
38APB_LPD_OTR_KEYSOTR keys for Launchpad texts5TEXT_ID30 Charactersnvarchar300
39APB_LPD_SH_TEXTSShort Texts4TEXT_IDText Idnvarchar50
TOPOLAP Technology
40RSDDTPS_HIER_IDXPolestar Hierarchy Indexes7TEXT_IDIndex IDnvarchar640
TOPRegulatory reporting for insurance companies
41TISSR_OUT_HINTISSR: Tipps und Tricks zur Ausgabeliste Bez. Doku-Listtyp5TEXT_IDText-IDnvarchar40
TOPResourcen Management
42FRMLC35RMGMT Formula: Key Figures7TEXT_IDObject Name for the Help Textnvarchar400
TOPRoyalty Reporting
43OIUREP_CODE_XREFReg Reporting Product/Volume Type to Report Code Cross Ref15TEXT_IDText IDnvarchar40
44OIUREP_TEXT_STDDRegulatory Reporting Standard Texts Detail5TEXT_IDText IDnvarchar40
45OIUREP_TEXT_STDHRegulatory Reporting Valid Standard Texts Header4TEXT_IDText IDnvarchar40
46OIUREP_TEXT_XREFRegulatory Reporting Texts for Diff Reporting Levels7TEXT_IDText IDnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
47N2DWSWL_TEXTSupplementary Text of an Object in Task List2TEXT_IDKey of Textnvarchar330
TOPWeb Dynpro ABAP
48WDY_CONFIG_COMPTDescription Texts for WDY_CONFIG_APPL5TEXT_IDWeb Dynpro: Configuration: Text Identificationnvarchar60
49WDY_CONF_USERT2Web Dynpro: Configuration Data for User9TEXT_IDWeb Dynpro: Configuration: Text Identificationnvarchar60
TOPWeb Service Tools - ABAP
50VEPHEADERVirtual End Point Definition: Administrative Data12TEXT_IDKey for Logical Object in the OTRnvarchar320
51WSHEADERWeb Services Definition Administrative Data9TEXT_IDKey for Logical Object in the OTRnvarchar320
52WSHEADER_DARKDark table of WSHEADER (only for transport reasons)10TEXT_IDKey for Logical Object in the OTRnvarchar320
TOPWeb Survey
53TUXS_XML_TRANSLXML Translation5TEXT_IDXML / XSLT Translation: Text IDnvarchar300
54TUXS_XSLT_TRANSLForm Services Translation of XSLT programs3TEXT_IDXML / XSLT Translation: Text IDnvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
55CONTCOMPXTControl Composites: Texts for TEXT Properties4TEXT_IDControl Composites: Identifier of a TEXT Propertynvarchar80
56O2XSLTOTROTR Texts for XSLT Programs2TEXT_IDText Alias for XSLT Programnvarchar200
TOPWorkbench Utilities
57TEXTLOGLog of text changes in DW6TEXT_IDObject Name in Object Directorynvarchar400