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

95 columns | Print definition?ERP 6.0  | VALUE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSSCR_DPARSParameters assigned to the Domain10VALUE_TYPEType of parameter value for search activitynvarchar10
2DBA_ALRT_MET_CDBA: Alerting Metric Components15VALUE_TYPEnvarchar100
3EHFNDD_REGL_OELOccupational Exposure Limits9VALUE_TYPEValue Typenvarchar210
4EHFNDD_SHADJROOTShift Adjustment - Root8VALUE_TYPEApplicable Value Typenvarchar210
5EHFNDD_SPLMT_VLTSampling Method - Value Type8VALUE_TYPEValue Typenvarchar210
6EHHSSD_HSP_TCRITProtocol - Triggering Criteria14VALUE_TYPEValue Typenvarchar210
7FIAPPTD_BALANCETable to store the Balances for Vendor/Customer/Bank Account15VALUE_TYPECBR Value Typenvarchar10
8FIAPPTD_TRANSTable to store the transaction details of the CBR PT20VALUE_TYPECBR Value Typenvarchar10
9J_3RF_TTAX_NPRRussian transport new tax priv. values and justifications12VALUE_TYPEType of Privilege Valuenvarchar10
10J_3RF_TTAX_PRIVRussian transport tax privilege values and justifications11VALUE_TYPEType of Privilege Valuenvarchar10
11SRAL_DATARead Access Logging: Data9VALUE_TYPERAL: Field Data Typenvarchar10
12SRAL_EXP_DATARAL expanded log - data11VALUE_TYPERAL: Field Data Typenvarchar10
13SRAL_FRAME_CFGRAL: Framework configuration6VALUE_TYPEnvarchar10
14SRAL_FRAME_CFGSRAL: Framework configuration6VALUE_TYPEnvarchar10
15SWDDUSRATTWorkflow Definition: User Attributes6VALUE_TYPEABAP Type of elementnvarchar10
16SWD_USRATTWorkflow Definition: User Attributes7VALUE_TYPEABAP Type of elementnvarchar10
17T7CNRMP_RPTSTAStatistical Dimension for Report6VALUE_TYPEStatistical Item Value Typenvarchar10
TOPAppraisal, Valuation, and Survey Tool
18T77HAP_C_VALTYAppraisal Category - Value Type Assignment5VALUE_TYPEValue Listnvarchar320
19T77HAP_VALTYAppraisal Value Lists3VALUE_TYPEValue Listnvarchar320
20T77HAP_VALTY_TAppraisal Value Lists Texts4VALUE_TYPEValue Listnvarchar320
TOPAvailability Control
21FMAVC_RBE_FSEAVC Filter Settings for RBE3VALUE_TYPEValue Typenvarchar20
TOPBRFplus - ABAP-Based Business Rules
22FDT_ACTN_6110FDT: Action - Start Workflow Container data8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
23FDT_ACTN_6110AFDT: Action - Start Workflow Container data8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
24FDT_ACTN_6110SFDT: Action - Start Workflow Container data7VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
25FDT_ACTN_6110TFDT: Action - Start Workflow Container data7VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
26FDT_ACTN_6200FDT: Action - Raise Event9VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
27FDT_ACTN_6200AFDT: Action - Raise Event9VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
28FDT_ACTN_6200SFDT: Action - Raise Event8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
29FDT_ACTN_6200TFDT: Action - Raise Event8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
30FDT_ACTN_6210FDT: Action Raise Event Container Data8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
31FDT_ACTN_6210AFDT: Action Raise Event Container Data8VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
32FDT_ACTN_6210SFDT: Action Raise Event Container Data7VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
33FDT_ACTN_6210TFDT: Action Raise Event Container Data7VALUE_TYPEFDT: Universal Unique Identifiernvarchar320
TOPBusiness Application Support
34CNVDOPARSConversion: Parameters for the FORM routines from CNVDOMS10VALUE_TYPEType of parameter value for search activitynvarchar10
TOPBusiness Context Viewer
35/BCV/C_QFPARQuery formula parameter6VALUE_TYPEValue Type (Formula Parameter)nvarchar10
36/BCV/C_QJOINCQuery Join Criterion7VALUE_TYPEValue Type of Join Criterionnvarchar10
TOPBusiness Objects, Common Components
37EHFNDD_AMN_ROOTData Series for Amounts - Root23VALUE_TYPEValue Typenvarchar210
38EHFNDD_PAM_AMTSSpecific Data for Amounts9VALUE_TYPEValue Typenvarchar210
TOPCRM Accruals
39IPM_ACE_CU_BVALCustomizing Settings for Data Values for Rights Usage Conf.5VALUE_TYPEData Valuenvarchar40
40IPM_ACE_CU_VALTYCustomizing Data Values Relevant to Accrual Types5VALUE_TYPEData Valuenvarchar40
TOPData Mining
41RSDMTC_ATTR_DTLAttribute Detail9VALUE_TYPEUse of the Model Field Valuesnvarchar10
TOPE-Recruiting
42T77RCF_WL_SEL_VTSource of Value Help for Fields of Worklists4VALUE_TYPEType of Value Help for Worklistnvarchar20
TOPEngineering Change Record
43/PLMI/ECR_CRT_ATECN Creation attributes at ECR Header5VALUE_TYPEType of Value of EngRec. Attributenvarchar10
44/PLMI/ECR_IT_CRAECN Creation attributes at ECR Item6VALUE_TYPEType of Value of EngRec. Attributenvarchar10
TOPFinancial Accounting
45CRMC_BEAVALTYACCIPM: Assignment of Value Types for Accounts in Company Code5VALUE_TYPEValue Typenvarchar40
TOPFunds Management
46FMBLEXTACBActivation of BL Ext for Value Type - Budgets4VALUE_TYPEBCS Value Typenvarchar20
47FMBLEXTACCActivation of BL Ext for Value Type - Commitments / Actuals4VALUE_TYPEValue Typenvarchar20
48FMBLEXTBUSubstitute BL Doc Types for Budget Docs3VALUE_TYPEBCS Value Typenvarchar20
49FMBLEXTEASubstitute BL Doc Types for Earmarked Funds3VALUE_TYPEEarmarked Funds Documentnvarchar20
50FMBLEXTINSubstitute BL Doc Types for Invoices3VALUE_TYPEFinancial Documentnvarchar20
51FMBUDREVRevenue/Statistical Postings & Open items/actuals Resource8VALUE_TYPEValue Typenvarchar20
52FMBUDSTABudgetary ledger account derivation: Open items/Actuals bdgt8VALUE_TYPEValue Typenvarchar20
53FMCLOSEOUTRules for Closing out Obligations5VALUE_TYPEValue type obligationsnvarchar20
54FMCOMBDefine Combined Documents2VALUE_TYPECombined Documentnvarchar20
55FMCOMBHAdditional lines in BL for Combined Documents5VALUE_TYPECombined Documentnvarchar20
56FMCOMBMTX1Error Matrix for Combined Documents in Customizing1VALUE_TYPECombined Documentnvarchar20
57FMCOMBMTX2Error Matrix for Combined Documents1VALUE_TYPECombined Documentnvarchar20
58FMIUROpen Interval Rules for updating FM4VALUE_TYPEValue Typenvarchar20
59FUNDMSGFund message maintenance4VALUE_TYPEValue Typenvarchar20
TOPGrantee Management
60GMFIUPDFI Settings for Grants Management Update6VALUE_TYPEGM Value Typenvarchar20
61GMVALUETYPEValue Type definition2VALUE_TYPEGM Value Typenvarchar20
62GMVALUETYPE_TEXTValue Type texts3VALUE_TYPEGM Value Typenvarchar20
TOPGRC Risk Management
63HRP1844DB Table for Infotype 184421VALUE_TYPEType of KRI valuenvarchar10
64HRP1850DB Table for Infotype 185023VALUE_TYPEType of KRI valuenvarchar10
65HRP1899DB Table for Infotype 189923VALUE_TYPEType of KRI valuenvarchar10
TOPIncentive and Commission Management ICM
66CACS00_DOCRECommission Document, Remuneration and Liability26VALUE_TYPEValuation Result Categorynvarchar10
67TCACS_REMCommission Remuneration Types10VALUE_TYPEValuation Result Categorynvarchar10
68TCACS_VALComn.: Valuation Types7VALUE_TYPEValuation Result Categorynvarchar10
69YCRM01_DOCRECommission Document, Remuneration and Liability53VALUE_TYPEValuation Result Categorynvarchar10
70YHITEC_DOCRECommission Document, Remuneration and Liability36VALUE_TYPEValuation Result Categorynvarchar10
71YSVMA_DOCRECommission Document, Remuneration and Liability30VALUE_TYPEValuation Result Categorynvarchar10
72YTEL01_DOCRECommission Document, Remuneration and Liability50VALUE_TYPEValuation Result Categorynvarchar10
73YTEL05_DOCRECommission Document, Remuneration and Liability44VALUE_TYPEValuation Result Categorynvarchar10
74ZICMAG_DOCRECommission Document, Remuneration and Liability28VALUE_TYPEValuation Result Categorynvarchar10
TOPLiquidation
75TCMS_OMS_LIQ_VMapping: Object + Value Type with Liquidation Value Cat.5VALUE_TYPEValue Typenvarchar100
TOPMaster Data
76GMBREBilling Rule Elements3VALUE_TYPEGM Value Typenvarchar20
77GMGAAPVTGAAP Accruals VT customizing3VALUE_TYPEGM Value Typenvarchar20
78GMGRVALUETYPEValue type settings for posting control3VALUE_TYPEGM Value Typenvarchar20
79GMIDCRULES_ELEBilling Rule Elements3VALUE_TYPEGM Value Typenvarchar20
80GMSMVALUETYPEValue type control by grant type and status5VALUE_TYPEGM Value Typenvarchar20
81GMSMVALUETYPE_1Value type control by grant type and status4VALUE_TYPEGM Value Typenvarchar20
82TCMS_OMS_VALTYValue type (customizing)2VALUE_TYPEValue Typenvarchar60
83TCMS_OMS_VALTY_TValue type texts2VALUE_TYPEValue Typenvarchar60
84TCMS_OMS_VL_VLSTValue sets3VALUE_TYPEValue Typenvarchar60
TOPQuery Management
85/PLMPCV/D_QFPARQuery formula parameter6VALUE_TYPEValue Type (Formula Parameter)nvarchar10
TOPRisk Assessment
86EHHSSD_AGT_LIMITAgent - Limit9VALUE_TYPEValue Typenvarchar210
87EHHSSD_RSK_OELOEL Comparison Values18VALUE_TYPEValue Typenvarchar210
TOPSales and Distribution
88IPM_RAWRECDue Pre-List for Product Sales15VALUE_TYPEThe Billing Engine Value Typenvarchar40
TOPSAP Media
89JPTRAWRECDue Pre-List for Product Sales15VALUE_TYPEValue Typenvarchar40
TOPSAP NetWeaver Mobile - Use subcomponents
90MEREP_PARAM_CONFmerep parameter configuration (possible parameters)3VALUE_TYPEABAP Elementary Data Typenvarchar10
TOPWorkforce Management Application
91ITC_CALC_RULEiTime Clock Admin Calculation Rule Configuration4VALUE_TYPEiTime Clock Accumulated Value Typetinyint30
92WFAFC_ATTRIB_CODAttribute Code4VALUE_TYPEAttribute Value Typenvarchar20
TOPWorkforce Management Core
93/SAPAPO/LRPSOPROSupplied WD Time Overtime Profile Set8VALUE_TYPEWFD Limits Value Typenvarchar20
94WFDOTPROFOvertime Profile Configuration6VALUE_TYPEWFD Limits Value Typenvarchar20
95WFMFC_ATTRIB_CODAttribute Code4VALUE_TYPEAttribute Value Typenvarchar20