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

33 columns | Print definition?ERP 6.0  | FIELD_VALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/FC_RT_SELResource Type Selection Criteria4FIELD_VALUEField valuenvarchar1320
2/CPD/FC_TRNMT_TFRelationship Between Transfer Method and Target Filed6FIELD_VALUEField Value for Valuation Methodnvarchar400
3/CPD/FC_TSTRG_PITransfer Strategy and Plan Item Source7FIELD_VALUEField Value for Valuation Methodnvarchar400
4/MRSS/D_LN_ATTRGeneric Attributes of Logical Nodes7FIELD_VALUEField value of logical node attributenvarchar320
5/MRSS/D_LN_ATT_TTexts for Generic Attributes of Logical Nodes6FIELD_VALUEField value of logical node attributenvarchar320
6/SAPSRM/C_YN_DEFValues of a Yes/No Flag with Modifyable Default Values1FIELD_VALUEYes/No Checkbox with Modifiable Default Valuesnvarchar10
7/SAPSRM/C_YN_DETTexts of a Yes/No Flag with Modifyable Default Values1FIELD_VALUEYes/No Checkbox with Modifiable Default Valuesnvarchar10
8BBPC_CMS_DEFAULTCMS User Default Values5FIELD_VALUEText (80 Characters)nvarchar800
9CBESH_ANNO_KFConfiguration Table for8FIELD_VALUEValue for Key Fact fieldntext10737418230
10FMFGUSFLDVAL2Field Value Definition3FIELD_VALUEGeneric Value for FG Fieldnvarchar400
11FMFGUSFLDVAL2TText to Field Values4FIELD_VALUEGeneric Value for FG Fieldnvarchar400
12LRM_T_OC_RG_FRule Groups - Fields6FIELD_VALUEValue of a Result Field in the Policynvarchar600
13LTR_BO_SUB_CONDLTR: Business Object6FIELD_VALUELTR: Content of a Key Fieldnvarchar2550
14LTR_LNK_CONDLTR: Business Object Link - Fixed Value Conditions7FIELD_VALUELTR: Content of a Key Fieldnvarchar2550
15SLIN_LOGGeneric SLIN Log Table5FIELD_VALUEnvarchar1000
16SNWD_EXTENSIONSEPM: Extensions Table5FIELD_VALUEntext10737418230
17T7CNRMP_DETITMDetermining Factor Item17FIELD_VALUEField Valuenvarchar380
TOPAuto-ID Infrastructure
18/AIN/DM_AOBJ_CTXAction Object Context (tag data history)5FIELD_VALUEField value of action object contextnvarchar1000
19/AIN/DM_DOC_CTXDocument Context Table5FIELD_VALUEField value of document contextnvarchar1000
20/AIN/DM_OBJ_CTXObject Context (object user data)4FIELD_VALUEField value of object contextnvarchar1000
TOPBank Customer Accounts
21TRTP_US_DFLTDefault values for screen input fields9FIELD_VALUEField valuenvarchar300
TOPCAD Integration
22CDESK_PDOC_LOGTrace Files for CAD Desktop7FIELD_VALUEnvarchar2550
TOPFunds Management
23FMSPLIT_VALUESAssignment field values for Rule-Based Account Distribution4FIELD_VALUEAccount assignment value for Rule-Based Acct Asst Disbtnnvarchar600
TOPMaintenance Orders
24/MRSS/C_SGU_CFLDTo customize fied name & corresponding value for a color key4FIELD_VALUEField Valuenvarchar1000
TOPPortfolio Management
25RPM_SCN_ADD_FLDSRPM : Scenario Additional fields4FIELD_VALUEPortfolio Management: Field Valuenvarchar240
TOPProvisioning
26SPCIPSPLMNTSPEC2000: Stores Additional/Long/MultipleOccurance fields18FIELD_VALUESPEC2000: Field Valuenvarchar2550
TOPProxy Generation
27SPROXSVARDATservice variant data10FIELD_VALUEField value in service variantimage21474836470
TOPPublic Sector Contract Accounts Receivable and Payable
28DFMCA_BRF170BRF: Progressive Calculation13FIELD_VALUEField Name of Structurenvarchar300
29DFMCA_BRF171BRF: Progressive Calculation13FIELD_VALUEField Name of Structurenvarchar300
TOPRoyalty Reporting
30OIUREP_ROY_PRFLDField Values in the Royalty Reporting Profiles7FIELD_VALUEField Value/Subroutine Name to obtain field Valuenvarchar400
TOPSAP NetWeaver Mobile - Use subcomponents
31UQFIELDVALUEField Values of differend forms5FIELD_VALUECharacter field of length 40nvarchar400
TOPTax Reporting
32OIUX1_FLD_VALBBase table for field level data8FIELD_VALUEField Contentsnvarchar600
33OIUX1_FLD_VALLLog for field level data11FIELD_VALUEField Contentsnvarchar600