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

79 columns | Print definition?ERP 6.0  | OBJ_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMM_D_IDXCommodity Management: Index Table4OBJ_IDIndex: Object IDnvarchar350
2CNVMBTDOCMGMTDocument Management5OBJ_IDNumber rangenvarchar80
3CNVTDMS_05_BENEFFill Header table to store Beneficiary Accounts3OBJ_IDRAW16 for TDMSvarbinary160
4CNV_20700_TCMF5HAnalyze table TCMF5 for package 207003OBJ_IDAnalysis for Table TCMF5nvarchar40
5CNV_20700_TCMF5PAnalyze table TCMF5 for package 207003OBJ_IDAnalysis for Table TCMF5nvarchar40
6E2ET_TBOM_ENVBPCA: TBOM collect calculated envireonemnt object for perfm3OBJ_IDBPCA: Long object idnvarchar2000
7EHFNDI_PM_SMPM Safety Measure Table (EAMWS_SAFETY)2OBJ_IDObject ID of Risk-Relevant Objectnvarchar400
8GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header4OBJ_IDNetwork Object IDnvarchar300
9GHO_OBJ_FACTOR_HNetwork Object Factors Header3OBJ_IDObject IDnvarchar400
10MEV_D_AD_ITEMPeriod-End Valuation: Accruals Document Item24OBJ_IDCommodity Management: ID of Reference Documentnvarchar350
11MEV_D_WL_ITEMPeriod-end valuation: Worklist item4OBJ_IDCommodity Management: ID of Reference Documentnvarchar350
12MEV_D_WL_MMPeriod-end valuation: Worklist - Materials Management Data4OBJ_IDCommodity Management: ID of Reference Documentnvarchar350
13MEV_D_WL_SDPeriod-end valuation: Worklist - Sales and Distribution Data4OBJ_IDCommodity Management: ID of Reference Documentnvarchar350
14SIMDQ_DESCRIPIM in HANA description table2OBJ_IDIM in HANA description IDnvarchar330
15SIMDQ_DSC_CLNTIM in HANA description table3OBJ_IDIM in HANA description IDnvarchar330
16SIMDQ_NAMEIM in HANA namele2OBJ_IDIM in HANA description IDnvarchar330
17SIMDQ_NAM_CLNTIM in HANA description table3OBJ_IDIM in HANA description IDnvarchar330
18TCORIT_SWIFT_PGNSWIFT MT535 depot statement pages - fragment adm. with CoCod6OBJ_IDID of a generic mapping objectvarbinary160
19VDARC_COL_KEYArchive Key for Collateral Objects and Collaterals8OBJ_IDData object Identifiernvarchar500
20ZPPMC_CPL_T_COSTplanning positions of project for bapis8OBJ_IDExternal Identification of Linked Objectntext10737418230
TOPApplication-Specific Upgrade
21/ASU/CONTENTASU: Content6OBJ_IDASU: Additional option. ID to distinguish same OBJ_TYPE/NAMEnvarchar200
22/ASU/STEPSASU Steps7OBJ_IDASU: Additional option. ID to distinguish same OBJ_TYPE/NAMEnvarchar200
23/ASU/STEPS_VASU Steps (Version)6OBJ_IDASU: Additional option. ID to distinguish same OBJ_TYPE/NAMEnvarchar200
TOPArchive Development Kit
24ARCH_IDX_SIndex Table for Archiving Demo with BC_SBOOK1OBJ_IDID of Data Object for Direct Access to ADK Archivesnvarchar200
TOPBasic Data
25NCPROXYOBJTable for Class CL_ISH_CM_PROXYOBJ3OBJ_IDObject Services: Object IDnvarchar320
TOPBusiness Navigator
26DF34SDocumentation assignments2OBJ_IDObject definitionnvarchar200
27DF62SID mapping table LM/BE4OBJ_IDnvarchar300
TOPBusiness Package for Manager Self-Service FI
28FPB_LP_OBJCList of Types of Hierarchy Nodes6OBJ_IDObject IDnvarchar40
29FPB_LP_O_I_CAssignment of Hierachy Node -- Report Item2OBJ_IDObject IDnvarchar40
TOPBusiness Process Engine
30SWFXIERRXI Adapter: Information About Last qRFC Error4OBJ_IDXI Adapter: Object in which error occurrednvarchar800
31SWFXILOGHistory of Processing a Message in BPE3OBJ_IDID of Object to which a Log Entry Refersnvarchar320
TOPCustomizing Tools Techniques
32TCTM_LCVALValidity Limits and Component Priorities2OBJ_IDLogical Objectnvarchar400
33TCTM_LOOBCentral Context Management Logical Objects2OBJ_IDLogical Objectnvarchar400
34TCTM_LPVALValidity Limits and Product Priorities2OBJ_IDLogical Objectnvarchar400
35TCTM_PHOBPhysical Objects in Central Context Management2OBJ_IDPhysical Objectnvarchar400
TOPDownloadUpload
36/DSD/HH_RAHDDSD Route Settlement: Tour Header Data4OBJ_IDDSD - RA: Tour Document Number of the Tour Document Typenvarchar100
TOPEnterprise Search Integration
37CRMD_ES_TMPLRELRelations of templates for ES7OBJ_IDNode Namenvarchar200
TOPGateway Business Eventing and Provisioning
38/IWBEP/D_SUBSInformation on the events subscribers6OBJ_IDObject IDnvarchar720
TOPIncentive and Commission Management ICM
39TCACS_LOS_OBJECTLogical Service: Objects4OBJ_IDCalculating Object Identificationnvarchar50
40TCACS_LOS_ST_ODLogical Service: Parameters for Std Tool (Object-Dependent)7OBJ_IDCalculating Object Identificationnvarchar50
41TCACS_LOS_ST_ODTLogical Service: Parameters for Std Tool (for All Functions)5OBJ_IDCalculating Object Identificationnvarchar50
42TCACS_LS_METHODComn: Assignment of Logical Services to Object Methods4OBJ_IDIdentification of Calculating Objectnvarchar50
43TCACS_OTC02_BRTool level param of log. service tool : Busines Rule Editor6OBJ_IDCalculating Object Identificationnvarchar50
44TCACS_OTC02_FEFormula Editor: Tool level parameters for valuation process5OBJ_IDCalculating Object Identificationnvarchar50
45TCACS_OTC03_ODOTC 03 (Liability), Object-Specific Parameters5OBJ_IDCalculating Object Identificationnvarchar50
46TCACS_OTC03_OFOTC 03 (Liability), Obj.- And Function-Dependent Parameters7OBJ_IDCalculating Object Identificationnvarchar50
47TCACS_OTC25_ODOTC 25 (Stt. Schedule), Object-Dependent Parameters5OBJ_IDCalculating Object Identificationnvarchar50
48TCACS_OTC27_ODOTC 27 (Settlement Schedule), Object-Dependent Parameters5OBJ_IDCalculating Object Identificationnvarchar50
49TCACS_OTC2A_CRDObject-Specific Parameters for Credentialing5OBJ_IDCalculating Object Identificationnvarchar50
50TCACS_SD02Parameter Condition Technique by Cat. and ID (Calc. Proced.)4OBJ_IDIdentification of Calculating Objectnvarchar50
TOPInformation System
51CMS_BII_CP_ER_STCMS-Basel II:Objects encountered error during DataExtraction3OBJ_IDGUID for Table CMS_ASTvarbinary160
52CMS_LIQ_CFLCMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0)4OBJ_IDCMS Object Identifiernvarchar700
TOPLoans Management
53VDARC_DOC_INDIndex Table for the Loan Document Data Archiving13OBJ_IDData object Identifiernvarchar500
54VDARLLoans180OBJ_IDData object Identifiernvarchar500
TOPLogbook
55DIACL_DSLogbook digital signatures3OBJ_IDObject numbernvarchar220
TOPMaintenance Processing
56EAMWS_SAFETYSafety Data for Objects3OBJ_IDObject ID of Safety Measurenvarchar400
TOPMaterial Master
57WRF_HIER_OBJObjects of a Hierarchy5OBJ_IDObject IDnvarchar60
58WRF_HIER_OBJBOXObject Container5OBJ_IDObject IDnvarchar60
59WRF_HIER_OBJ_TObject Descriptions5OBJ_IDObject IDnvarchar60
TOPMonitoring
60EWAGGStatistics, hierarchy of devclasses and applications3OBJ_IDStatistics; Id for object of hierarchynvarchar20
61EWEXCStatistics, exceptions for EWAGG3OBJ_IDStatistics; Id for object of hierarchynvarchar20
TOPPackage Tools
62AKB_USG_EDGEObsolete: Index of Base Objects for BCB1OBJ_IDNatural Numberint100
TOPPersonnel Time Management
63PTARQ_EXTRA_INFOLeave Request: Additional Fields for Attendances/Absences4OBJ_IDObject IDnvarchar80
TOPRoute Settlement
64/DSD/SL_SLD_ITEMSettlement Document Item5OBJ_IDDSD - RA: Tour Document Number of the Tour Document Typenvarchar100
TOPSAP Records Management
65SRMGSPRNAMNames of Log Entries2OBJ_IDDocument IDnvarchar420
TOPStock Visibility
66/DSD/SV_LC_CGDSD LC: Loading Confirmation Item on Counting Group Level3OBJ_IDDocumentnvarchar100
67/DSD/SV_LC_HDDSD LC: Loading Confirmation Header3OBJ_IDDocumentnvarchar100
68/DSD/SV_LC_MATDSD LC: Loading confirmation item on material level3OBJ_IDDocumentnvarchar100
69/DSD/SV_ORD_TOURAssignment Reload and Unload Orders to Tour3OBJ_IDDocumentnvarchar100
70/DSD/SV_RLD_HDDSD SV: Reload Header Data3OBJ_IDDocumentnvarchar100
71/DSD/SV_RLD_ITDSD SV: Reload Item Data3OBJ_IDDocumentnvarchar100
72/DSD/SV_SEALNODSD: Seal Number3OBJ_IDDocumentnvarchar100
TOPStructures Workbench
73/ISDFPS/USRSTACKStack for Objects Loaded into Structures Workbench5OBJ_IDObject IDnvarchar80
TOPTransaction Manager
74TCORFT_FRAGMENTParsed generic objects from fragments of inbound messages2OBJ_IDID of a generic mapping objectvarbinary160
75TCORIT_SWIFT_PGSWIFT MT535 depot statement pages - fragment administration5OBJ_IDID of a generic mapping objectvarbinary160
TOPTravel Expenses
76PTRV_COMM_AMTDetail Data: Transfer to FM When Trip Saved12OBJ_IDReference document: Current identificationnvarchar100
77PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved11OBJ_IDReference document: Current identificationnvarchar100
TOPWarranty Claim Processing
78WTY_ARCH_IDXIndex Table for Archiving Warranty Claims1OBJ_IDID of Data Object for Direct Access to ADK Archivesnvarchar200
79WTY_ARCH_IDX_2Index Table for Archiving Warranty Claims1OBJ_IDID of Data Object for Direct Access to ADK Archivesnvarchar200