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

53 columns | Print definition?ERP 6.0  | ATTRIBUTE_VALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/D_WF_018Table for persistent class /SAPSRM/CL_WF_RUNTIME10ATTRIBUTE_VALUEConfiguration Attribute Valuenvarchar2550
2GRACCONATTRConnector Attribute4ATTRIBUTE_VALUEAttribute valuenvarchar300
3TREAC_ATTR_LAttribute Values For Long Attributes3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
4TREAC_ATTR_L_TTexts For Attribute Values For Long Attributes3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
5TREAC_ATTR_MAttribute Values For Medium Attributes3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
6TREAC_ATTR_M_TTexts For Attribute Values For Medium Attributes3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
7TREAC_ATTR_SAttribute Values For Short Attributes3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
8TREAC_ATTR_S_TTexts For Attribute Values For Short Attributes3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
9ZPPMC_CPL_C_CHCKDefine WBS Element Attribute Checks5ATTRIBUTE_VALUEWBS Element Attribute Valuenvarchar400
TOPBack Office
10TRFC_ATTR_LAttribute Values For Long Attributes3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
11TRFC_ATTR_L_TTexts For Attribute Values For Long Attributes3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
12TRFC_ATTR_MAttribute Values For Medium Attributes3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
13TRFC_ATTR_M_TTexts For Attribute Values For Medium Attributes3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
14TRFC_ATTR_SAttribute Values For Short Attributes3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
15TRFC_ATTR_S_TTexts For Attribute Values For Short Attributes3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
16TRFT_ATTR_LValues for Long attributes3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
17TRFT_ATTR_L_TTexts for Long Attribute Values3ATTRIBUTE_VALUEValue of Long Attribute (20 Characters)nvarchar200
18TRFT_ATTR_MValues for Medium attributes3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
19TRFT_ATTR_M_TTexts for Medium Attribute Values3ATTRIBUTE_VALUEValue of the Medium Attribute (10 Characters)nvarchar100
20TRFT_ATTR_SValues for Short attributes3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
21TRFT_ATTR_S_TTexts for Short Attribute Values3ATTRIBUTE_VALUEValue of the Short Attribute (4 Characters)nvarchar40
TOPCentral Part of Product Master
22COMM_PRFREEATTRFree Attributes for a Product9ATTRIBUTE_VALUEValue of Free Attributenvarchar2550
23COMM_PRFREEATTRHFree Attributes for a Product - History9ATTRIBUTE_VALUEValue of Free Attributenvarchar2550
TOPChange Request Management
24SI_RQ_ATTR_VALSi-SODIS: Possible values for Attribute values1ATTRIBUTE_VALUESI-SODIS: Possible Attribute Values (Check Table)nvarchar2500
25SI_RQ_ATTR_VALTSODIS deprecated1ATTRIBUTE_VALUESI-SODIS: Possible Attribute Values (Check Table)nvarchar2500
TOPCondition Technique
26/SAPCND/T687IData for Personalized Variant6ATTRIBUTE_VALUEValue of a Personalization Attributenvarchar500
TOPE-Recruiting
27T77RCF_AS_RULESRules for Periodic Services of Job Agent4ATTRIBUTE_VALUEValue of Attribute of Service for Job Agentnvarchar100
28T77RCF_PS_RULESRules for Periodic Services4ATTRIBUTE_VALUEValue of Attribute in a Periodic Servicenvarchar100
TOPFunds Management
29FMFGF2_SGLATRVALFMFG2 - FACTS II SGL Account Attribute Allowable Values4ATTRIBUTE_VALUEFMFG - FACTS2 Attribute Attribute Valuesnvarchar40
TOPProduct Safety
30TCGES_ATTRIBUTESEHS: Search Form - Enterprise Search - Attributes4ATTRIBUTE_VALUEChar255nvarchar2550
TOPSAP NetWeaver Mobile - Use subcomponents
31MEALERTSTable for Client Alert Information for CCMS7ATTRIBUTE_VALUEAttribute Valuedecimal80
32MEALERTS_SAVETable for Client Alert Information for CCMS7ATTRIBUTE_VALUEAttribute Valuedecimal80
33MEMGMT_DEV_ALERTME: Current device alerts7ATTRIBUTE_VALUEAttribute Valuedecimal80
34MEMSD_CUSTMobile Solution Descriptor: Customizing Table8ATTRIBUTE_VALUEMobile Component Descriptor Customizing Attribute Valuenvarchar2550
35MEMSD_SOURCEMSD for Description of Installation Files9ATTRIBUTE_VALUEMobile Component Descriptor Customizing Attribute Valuenvarchar2550
36MIDEVICEPROFILEStores The Attributes Per Device ID4ATTRIBUTE_VALUECharacter field, length 70nvarchar700
TOPSelf-Service Procurement
37/SRMERP/D_WF_018Table for persistent class /SRMERP/CL_WF_RUNTIME10ATTRIBUTE_VALUEConfiguration Attribute Valuenvarchar2550
TOPServices
38SSRVBINDINGATTXI Services: Binding Attributes3ATTRIBUTE_VALUEXI Services: Attributes in XML Formatntext10737418230
39SSRVCHANNELATTXI Services: Channel Attributes3ATTRIBUTE_VALUEXI Services: Attributes in XML Formatntext10737418230
TOPTransaction Manager
40TEMC_ATTRIBUTEValue Table for Attribute Fields3ATTRIBUTE_VALUEValue of a Free Attributenvarchar200
41TEMC_ATTRIB_TTexts For Attribute Values4ATTRIBUTE_VALUEValue of a Free Attributenvarchar200
42TEXC_ATTR_LAttribute values for Long attributes3ATTRIBUTE_VALUEValue of a free attribute (Char 20)nvarchar200
43TEXC_ATTR_L_TTexts for attribute values of short attributes4ATTRIBUTE_VALUEValue of a free attribute (Char 20)nvarchar200
44TEXC_ATTR_MAttribute values for short attributes3ATTRIBUTE_VALUEValue of a free attribute (Char10)nvarchar100
45TEXC_ATTR_M_TTexts for attribute values of short attributes4ATTRIBUTE_VALUEValue of a free attribute (Char10)nvarchar100
46TEXC_ATTR_SAttribute values for short attributes3ATTRIBUTE_VALUEValue of a free attribute (Char4)nvarchar40
47TEXC_ATTR_S_TTexts for attribute values of short attributes4ATTRIBUTE_VALUEValue of a free attribute (Char4)nvarchar40
TOPTransport Organizer
48SI_RQ_FILECNTRLAttributes of a file object4ATTRIBUTE_VALUEvalue of a file object attributenvarchar2550
49SI_RQ_FILECNTRLPTransport preview: Attributes of a file object4ATTRIBUTE_VALUEvalue of a file object attributenvarchar2550
TOPTreasury
50VWPT_ATTR_LAttribute Values for Long Attributes3ATTRIBUTE_VALUEValue of the Free Attribute (20 Characters)nvarchar200
51VWPT_ATTR_L_TTexts for Attribute Values for Long Attributes4ATTRIBUTE_VALUEValue of the Free Attribute (20 Characters)nvarchar200
52VWPT_ATTR_SAttribute Values for Short Attributes3ATTRIBUTE_VALUEValue of the Free Attribute (5 Characters)nvarchar50
53VWPT_ATTR_S_TTexts for Attribute Values for Long Attributes4ATTRIBUTE_VALUEValue of the Free Attribute (5 Characters)nvarchar50