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

70 columns | Print definition?ERP 6.0  | FIELDVALUE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FILE_EXPVALexpected values table for AIF ECATT5FIELDVALUEValuenvarchar2550
2/AIF/T_FFIXFix values4FIELDVALUEValuenvarchar2550
3/AIF/T_FFIXVTable for variant fix values6FIELDVALUEValuenvarchar2550
4/AIF/T_IFDETVALValues for Interface Determination5FIELDVALUEValue for Interface Determinationnvarchar450
5/AIF/T_INFDET_VLValues for Interface Determination9FIELDVALUEValue for Interface Determinationnvarchar450
6/AIF/T_MFIXFix values for master data (no transport)4FIELDVALUEValuenvarchar2550
7/AIF/T_MFIXVFix values for master data (no transport)6FIELDVALUEValuenvarchar2550
8/AIF/T_MTFIXFix value tables for master data (no transport)5FIELDVALUEValuenvarchar2550
9/AIF/T_MTFIXVFix value tables for master data (no transport)7FIELDVALUEValuenvarchar2550
10/AIF/T_TFIXFix value table5FIELDVALUEValuenvarchar2550
11/AIF/T_TFIXVFix value table7FIELDVALUEValuenvarchar2550
12/CPD/C_MC_OBJMAPTable to map milestone checklist items to project elements5FIELDVALUEField valuenvarchar1320
13/OPT/DT_DET_MAPMapping for Doctype Determination2FIELDVALUEInvoice Characteristicsnvarchar400
14/ORS/PS_ITEMProfitability Segment Fields and Values8FIELDVALUEField valuenvarchar1320
15/WSOPT/NAVILEVLevel Navigation Tree7FIELDVALUEValuenvarchar160
16/XPPM/CRC_C_FIVAFieldvalues4FIELDVALUEFieldvaluenvarchar20
17/XPPM/CRC_C_FI_TFieldvalue Texttable4FIELDVALUEFieldvaluenvarchar20
18CCGLC_WBC_STSFEHS: LWB Subtab Screen Filter Field Value Output7FIELDVALUEField Value as Filter Criterionnvarchar1280
19CCGLC_WBC_TSOFEHS: LWB Tab Screen Filter Field Value Output6FIELDVALUEField Value as Filter Criterionnvarchar1280
20GRACSUPPRULESupplement Rule Header5FIELDVALUEField Valuenvarchar1000
21GRACSUPPRULEARCSupplement Rule -Archive5FIELDVALUEField Valuenvarchar1000
22J_1BTTAXDETTax Determination - Validity4FIELDVALUEField Valuenvarchar100
23NWS_EXT_AP_KEYAlready Extracted Data (Avoid Duplicate Keys)3FIELDVALUEArea for table keynvarchar1200
24TSEXCStandard Values for Performance Monitoring2FIELDVALUETSEXC field value alert thresholds upper and lower casenvarchar300
TOPAssetLiability Management
25JBR_US_ACCT_MAPBalancing Account4FIELDVALUECharacteristic Valuesnvarchar500
TOPAssortment
26WRF_APC_PADAPlanned Article Dynamic Attributes6FIELDVALUEValue of a Field (Dynamic Attribute Table)nvarchar500
TOPBusiness Analytics
27UACRENVCosting Run: Environment7FIELDVALUECosting Run: Field Valuenvarchar1280
TOPEEW Services
28OXT_ER_GOBJDTLGenerated Object Substitution Details6FIELDVALUEField Values for Table Entriesnvarchar2550
29OXT_GENOBJDTLGenerated Object Substitution Details6FIELDVALUEField Values for Table Entriesnvarchar2550
30OXT_GENTABLINOXT Object Template Description7FIELDVALUEParameter Valuenvarchar2550
TOPEngineering Desktop
31EDESK_C_PARA_VALCustomizing for Parameter Values in Engineering Desktop3FIELDVALUEAttribute Value in Engineering Desktopnvarchar2550
TOPGRC Access Control Plug-In
32/VIRSA/CSTMDATAHR Triggers - Custom Field Data4FIELDVALUEText field length 200nvarchar2000
33/VIRSA/DATAHR Triggers - Standard Field Data4FIELDVALUEText field length 200nvarchar2000
TOPMaintenance Orders
34IOCI_FCONVOCI Interface: Field Conversion5FIELDVALUEOCI: HTML Fieldnvarchar400
TOPMaintenance Processing
35/MRSS/ADOBE_OFFTest table5FIELDVALUEText, 255 Charactersnvarchar2550
TOPMulti Currency Accounting
36GLE_MCA_TFIXVALFixed values for postline fields4FIELDVALUEField Valuenvarchar1000
TOPPatient Accounting
37NWVIEW_L01IS-H: NL10 - View Type L01 - Table Control Settings11FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
38NWVIEW_L02IS-H: NL10 - View Type L02 - Table Control Settings11FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
39NWVIEW_L03IS-H: NL10 - View Type L03 - Table Control Settings11FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
40NWVIEW_L04IS-H: NL10 - View Type L04 - Table Control Settings11FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
TOPPatient Management
41NSHIFT_IDIS-H: Details on Case Revision Objects7FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
42NWVIEW_AP1IS-H: View Type AP1 - Search Variant for Standard Search6FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
43NWVIEW_AP2IS-H: View Type AP2 - Search Variant for Enh. Time Slot Sear8FIELDVALUEIS-H: General Field for Field Valuesnvarchar500
TOPPayroll
44T7UAOC1Content of Employee Selection Process15FIELDVALUEVariable contentsnvarchar1320
TOPPeople Centric UI Framework Customizing
45CRMC_BL_QUE_VALSApplication Scenario - User Query - Field Values3FIELDVALUEStringntext10737418230
46CRMC_BL_VAR_VALSApplication Scenario - User Query - Field Values4FIELDVALUEStringntext10737418230
TOPPlant Maintenance
47T392_VPM: Detailed selection for print diversion7FIELDVALUEPM: Field Contents for Print Diversionnvarchar180
TOPPublic Sector Contract Accounts Receivable and Payable
48DFMCACD_FORMDATAForm Data for Change Object4FIELDVALUEField Valuenvarchar2550
TOPRoyalty Reporting
49OIUREP_TEXT_XREFRegulatory Reporting Texts for Diff Reporting Levels5FIELDVALUEValue of Regulatory reporting parametersnvarchar300
50OIUREP_VALTABCReporting general value table - Customizing5FIELDVALUEValue of Regulatory reporting parametersnvarchar300
51OIUREP_VALTABCTXReporting general value table - Customizing6FIELDVALUEValue of Regulatory reporting parametersnvarchar300
52OIUREP_VALTABMReporting general value table - Customizing5FIELDVALUEValue of Regulatory reporting parametersnvarchar300
TOPRussia
53T7RUOC1Content of Employee Selection Process15FIELDVALUEVariable contentsnvarchar1320
TOPSAP NetWeaver Mobile - Use subcomponents
54BWAFSYBODYWAF: Body of Synchronization Container5FIELDVALUEValue of Container Element for WAF Synchronizationnvarchar2550
55MESYBODYWAF: Body of Synchronization Container6FIELDVALUEValue of Container Element for WAF Synchronizationnvarchar2550
TOPSelf-Service Procurement
56/SRMERP/CAT_CUSTCatalog Item Comparison config fields3FIELDVALUECheckboxnvarchar10
TOPTable Analysis
57ARDB_STAT2Table Analyses: Executed Analyses - Fields of a Data Set3FIELDVALUETable Analysis: Field Valuenvarchar1320
TOPTerminologyGlossary
58STERM_DWN2MultiTerm Download: Attribute Values4FIELDVALUEnvarchar300
TOPTime Sheet
59CATS_DEF_ACCOUNTCATS Default Accounting7FIELDVALUEField valuenvarchar1320
TOPTrading Contract
60WB2_C_PF_MTHD_PMExecution Paramter in Method for Processing of Follow-on doc5FIELDVALUEParameter Field value for Processing of Follow-on docnvarchar600
TOPTrading Execution Workbench
61TEWSTEP2PARAParameters for Action8FIELDVALUEField valuenvarchar500
TOPTransaction Variant and Table Control Settings
62SHDFVTransaction variants: Field contents8FIELDVALUEBDC field valuenvarchar1320
63SHDFVCITransaction variants: Field contents (cross-client)7FIELDVALUEBDC field valuenvarchar1320
64SHDGHeidelberg: Global field pre-assignments4FIELDVALUECHAR40 for SYSTnvarchar400
65SHDGVGlobal values5FIELDVALUECHAR40 for SYSTnvarchar400
66SHDGVDEGlobal values: Values and flags for data elements6FIELDVALUEGlobal values: Field contentsnvarchar400
67SHDGVDOGlobal values: Values and flags for domains6FIELDVALUEGlobal values: Field contentsnvarchar400
68SHDSVFVCIScreen variants: Field contents4FIELDVALUEBDC field valuenvarchar1320
TOPUser Administration
69SPERS_OBJPersonalization object repository11FIELDVALUEPersonalization data fieldnvarchar2550
TOPWithout Description
70KAP_PSR_USRUser-specific settings4FIELDVALUEField valuenvarchar600