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

43 columns | Print definition?ERP 6.0  | PARENT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/I_MED_EPCtable to manage internal relationships such as parent-child5PARENT_TYPEtype of parent child relationnvarchar10
2ACMASPECTACM: Aspect Definition Persistence2PARENT_TYPEACM: Type of an DCL Top-Level Objectnvarchar100
3ACMTSTASPECTACMTST: Aspect (Expected test-results)2PARENT_TYPEACM: Type of an DCL Top-Level Objectnvarchar100
4BBP_CT_ATTACHMAttachment5PARENT_TYPEType Parentnvarchar20
5PYD_D_TYPayroll Data Source Type10PARENT_TYPEPayroll Data Source Typenvarchar300
6ZPPMC_CPL_T_CACHCache for Delta Posting14PARENT_TYPEObject Category in Project Planningnvarchar30
7ZPPMC_CPL_T_COSTplanning positions of project for bapis3PARENT_TYPEObject Category in Project Planningnvarchar30
TOPAccounting - General
8TFC_ALL_ORGExtracted Master Data4PARENT_TYPEStructure Data Type for Fast Closenvarchar50
9TFC_INST_ALL_ORExtracted Master Data6PARENT_TYPEStructure Data Type for Fast Closenvarchar50
10TFC_TEMPL_ALL_ORExtracted Master Data6PARENT_TYPEStructure Data Type for Fast Closenvarchar50
TOPBusiness Analytics
11UABSCEBATIMPTable to store SCE variants, PDCE, Ehp44PARENT_TYPEName of a Typenvarchar100
12UABXMLBATIMPtable for XML, batch import, PDCE, Ehp46PARENT_TYPEName of an Object Typenvarchar100
TOPCollaboration Folders
13CFX_STRUCT_PARFather for BOMs (Redundant, as Cache for XML Files)4PARENT_TYPEObject Typenvarchar100
14CFX_STRUCT_PAR_VParent Version for BOM Version (Redundant as Cache)4PARENT_TYPEObject Typenvarchar100
TOPEnd User Technology
15RSRA_BB_LOGLog-Table for the Batch Runs of the ResultSet Precalculation9PARENT_TYPEObject Type of the Reporting Agentnvarchar300
16RSRA_ER_LOGNLog Table for Batch Runs of Exception Reporting12PARENT_TYPEObject Type of the Reporting Agentnvarchar300
17RSRA_MX_LOGLog Table for the Batch Run of MDX Precalculation9PARENT_TYPEObject Type of the Reporting Agentnvarchar300
18RSRWBINDEXList of binary large objects (Excel workbooks)20PARENT_TYPETechnical Name of Variantnvarchar300
TOPIncentive and Commission Management ICM
19CACS00_B_VAR_OBJVariants for Commission Case Object Data17PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
20CACS00_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
21CACS00_OBJCommission Case Object Data13PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
22YCRM01_B_VAR_OBJVariants for Commission Case Object Data64PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
23YCRM01_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
24YCRM01_OBJCommission Case Object Data60PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
25YHITEC_B_VAR_OBJVariants for Commission Case Object Data28PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
26YHITEC_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
27YHITEC_OBJCommission Case Object Data24PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
28YSVMA_B_VAR_OBJVariants for Commission Case Object Data32PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
29YSVMA_DOCOBJCommission Document: Object Data22PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
30YSVMA_OBJCommission Case Object Data24PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
31YTEL01_B_VAR_OBJVariants for Commission Case Object Data52PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
32YTEL01_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
33YTEL01_OBJCommission Case Object Data48PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
34YTEL05_B_VAR_OBJVariants for Commission Case Object Data50PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
35YTEL05_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
36YTEL05_OBJCommission Case Object Data43PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
37ZICMAG_B_VAR_OBJVariants for Commission Case Object Data20PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
38ZICMAG_DOCOBJCommission Document: Object Data10PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
39ZICMAG_OBJCommission Case Object Data16PARENT_TYPEHigher-Level Subobject That Triggers Commissionnvarchar50
TOPProduct Lifecycle Management
40CPROW_LOCK_NULLLocked "Null Resources" in the WebDAV Interface4PARENT_TYPEObject Typenvarchar100
TOPWeb Service and SOAP - ABAP
41SRT_MMASTERWS message (Master table)8PARENT_TYPEParent Typenvarchar10
TOPWorkforce Management Application
42WFAC_PRF_MAPPINGProfile Mapping Table for Multi-Site Configuration3PARENT_TYPEconfiguration profile type idnvarchar30
TOPWorkforce Management Core
43WFMC_PRF_MAPPINGProfile Mapping Table for Multi-Site Configuration3PARENT_TYPEconfiguration profile type idnvarchar30