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

111 columns | Print definition?ERP 6.0  | PROJECT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/SM_MAPPTTransport table for /SLOAS/SM_MAPPI5PROJECT_ID3-Byte fieldnvarchar30
2BBP_PDIGPBusiness Transaction Item-Purchasing Information140PROJECT_IDProject Keynvarchar320
3CNVCDMCCTS_DISPCDMC : CTS Display Results - Last Changed1PROJECT_IDCDMC - Project IDnvarchar50
4CNVCDMCUCIA_EXCLList Of excluded Objects1PROJECT_IDCDMC - Project IDnvarchar50
5CNVCDMCUCIA_FUGRCDMC:UCIA: FUGR information for referred SAP objects1PROJECT_IDCDMC - Project IDnvarchar50
6CNVCDMC_SELTable to store the selectionin the Cntrl sys for Prj ID1PROJECT_IDCDMC - Project IDnvarchar50
7CNVCDOPCA_COMPCDOP - Results from Remote comparision1PROJECT_IDCDOP - Project IDnvarchar50
8CNVCDOPCA_SQLTRACDOP : SQL Trace File analysis results1PROJECT_IDCDOP - Project IDnvarchar50
9CNVCDOPUCIA_ADJCDOP : UCIA - Adjustment Times1PROJECT_IDCDOP - Project IDnvarchar50
10CNVCDOPUCIA_BDCCDOP: UCIA-Collect the BDC Program Comparison data1PROJECT_IDCDOP - Project IDnvarchar50
11CNVCDOPUCIA_FORMCDOP: UCIA: Impact on SAP Subroutines called externally1PROJECT_IDCDOP - Project IDnvarchar50
12CNVCDOPUCIA_LIMUCDOP : UCIA: Subobject table of used SAP objects1PROJECT_IDCDOP - Project IDnvarchar50
13CNVCDOPUCIA_OBJSCDOP : UCIA - Objects in the Customer Namespace1PROJECT_IDCDOP - Project IDnvarchar50
14CNVCDOPUCIA_OREFCDOP : UCIA - References to SAP Objects in Custom Objects1PROJECT_IDCDOP - Project IDnvarchar50
15CNVCDOPUCIA_PDEFCDOP: UCIA: Table to define UCIA Proj is from KB / Ref Sys1PROJECT_IDCDOP - Project IDnvarchar50
16CNVCDOPUCIA_PLCDOP : UCIA - SAP Objects impacted in an Upgrade or Patch1PROJECT_IDCDOP - Project IDnvarchar50
17CNVCDOPUCIA_RESCDOP : UCIA - Result of Remote Comparison of SAP Objects1PROJECT_IDCDOP - Project IDnvarchar50
18CNVCDOP_ADHOCCDOP : Adhoc Users3PROJECT_IDCDOP - Project IDnvarchar50
19CNVCDOP_CUST_NAMCDOP - Customer Namespaces1PROJECT_IDCDOP - Project IDnvarchar50
20CNVCDOP_PROJECTSCDOP - Projects1PROJECT_IDCDOP - Project IDnvarchar50
21CNVCDOP_STATECDOP : Status of the activities in a Project1PROJECT_IDCDOP - Project IDnvarchar50
22CNV_10993_ACTIActivity Tables2PROJECT_IDProject idnvarchar100
23CNV_10993_EXCELTable for excel download1PROJECT_IDProject idnvarchar100
24CNV_10993_FORMRSResult table for Forms2PROJECT_IDProject idnvarchar100
25CNV_10993_LOGLog activities in a project.2PROJECT_IDProject idnvarchar100
26CNV_10993_MAILMaiing details2PROJECT_IDProject idnvarchar100
27CNV_10993_OBJCNTTable to have count for Objects2PROJECT_IDProject idnvarchar100
28CNV_10993_OBJECTCoding Scan 10993 Object Table2PROJECT_IDProject idnvarchar100
29CNV_10993_OBJSTSTable for Object Status2PROJECT_IDProject idnvarchar100
30CNV_10993_PROJCoding Scan 10993 Project Header Table2PROJECT_IDProject idnvarchar100
31CNV_10993_PRORUNCoding Scan 10993 Project Run Table2PROJECT_IDProject idnvarchar100
32CNV_10993_RESHDRCoding Scan Result header table2PROJECT_IDProject idnvarchar100
33CNV_10993_RESULTCoding Scan 10993 Search Run Result Table2PROJECT_IDProject idnvarchar100
34CNV_10993_SCNJBSTable for all the jobs in scan.1PROJECT_IDProject idnvarchar100
35CNV_10993_SCRPRGObjects For SAP script programs2PROJECT_IDProject idnvarchar100
36CNV_10993_STATEJob status state table2PROJECT_IDProject idnvarchar100
37CNV_10993_VASUMSValidation and substitution Messages2PROJECT_IDProject idnvarchar100
38CNV_10993_VASURUValidation and Substitution Rule2PROJECT_IDProject idnvarchar100
39SCTS_PROJECTTEAMCentral CTS: Generic Project Persistence - Teams3PROJECT_IDCentral CTS: Project IDnvarchar320
40SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO69PROJECT_IDProject Keynvarchar320
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
41SATC_RT_RUNMovement data (runtime repository) - Header2PROJECT_IDProject IDvarbinary160
TOPASAP AcceleratedSAP
42SASAPBCSETBC Sets in Q&Adb3PROJECT_IDProject Namenvarchar100
43SASAPCUDOCASAP Tools: Customer Documents1PROJECT_IDProject Namenvarchar100
44SASAPCUURLASAP Tools: Customer-Specific URLs1PROJECT_IDProject Namenvarchar100
TOPControl Plan
45QPCPD_CPLANControl Plan - Header24PROJECT_IDProject Numbernvarchar240
TOPControlling
46IAOM_CPRO_EXATExternal Characteristics of an Object in cProjects3PROJECT_IDProject Number in cProjectsnvarchar240
TOPCross-System Tools
47SCDTSYNCSynchronization Settings2PROJECT_IDProject Namenvarchar100
TOPCustom Development Management Cockpit
48CNVCDMCCA_COMPCDMC - Results from Remote comparision1PROJECT_IDCDMC - Project IDnvarchar50
49CNVCDMCCA_DEVCTab to store selectd Dev Classes in the Cntrl sys for Prj ID1PROJECT_IDCDMC - Project IDnvarchar50
50CNVCDMCCA_SQLTRACDMC : SQL Trace File analysis results1PROJECT_IDCDMC - Project IDnvarchar50
51CNVCDMCCTS_ADHOCCDMC : Adhoc Users for Change and Transport Analysis3PROJECT_IDCDMC - Project IDnvarchar50
52CNVCDMCCTS_OBJSCDMC : Customer Objects and SAP Mods for CTS project1PROJECT_IDCDMC - Project IDnvarchar50
53CNVCDMCCTS_OREFCDMC:CTS - Customer and Reffered SAP Objects1PROJECT_IDCDMC - Project IDnvarchar50
54CNVCDMCUCIA_ADJCDMC : UCIA - Adjustment Times1PROJECT_IDCDMC - Project IDnvarchar50
55CNVCDMCUCIA_BDCCDMC: UCIA-Collect the BDC Program Comparison data1PROJECT_IDCDMC - Project IDnvarchar50
56CNVCDMCUCIA_FORMCDMC: UCIA: Impact on SAP Subroutines called externally1PROJECT_IDCDMC - Project IDnvarchar50
57CNVCDMCUCIA_LIMUCDMC : UCIA: Subobject table of used SAP objects1PROJECT_IDCDMC - Project IDnvarchar50
58CNVCDMCUCIA_OBJSCDMC : UCIA - Objects in the Customer Namespace1PROJECT_IDCDMC - Project IDnvarchar50
59CNVCDMCUCIA_OREFCDMC : UCIA - References to SAP Objects in Custom Objects1PROJECT_IDCDMC - Project IDnvarchar50
60CNVCDMCUCIA_PDEFCDMC: UCIA: Table to define UCIA Proj is from RIB / Ref Sys1PROJECT_IDCDMC - Project IDnvarchar50
61CNVCDMCUCIA_PLCDMC : UCIA - SAP Objects impacted in an Upgrade or Patch1PROJECT_IDCDMC - Project IDnvarchar50
62CNVCDMCUCIA_RESCDMC : UCIA - Result of Remote Comparison of SAP Objects1PROJECT_IDCDMC - Project IDnvarchar50
63CNVCDMCUCIA_RESDCDMC : UCIA - Table for Reason Categories of Sub Objects1PROJECT_IDCDMC - Project IDnvarchar50
64CNVCDMC_ADHOCCDMC : Adhoc Users3PROJECT_IDCDMC - Project IDnvarchar50
65CNVCDMC_CUST_NAMCDMC - Customer Namespaces1PROJECT_IDCDMC - Project IDnvarchar50
66CNVCDMC_PROJECTSCDMC - Projects1PROJECT_IDCDMC - Project IDnvarchar50
67CNVCDMC_STATECDMC : Status of the activities in a Project1PROJECT_IDCDMC - Project IDnvarchar50
TOPCustomizing Project Management IMG
68TPR_INDEXList of nodes sorted by project1PROJECT_IDProject Namenvarchar100
69TPR_VINDXList of IMG Activities in a Project View1PROJECT_IDProject Namenvarchar100
70TPR_XREF_DIndex for Where-Used List1PROJECT_IDProject Namenvarchar100
71TPR_XREF_PProjects: Constraint on Where-Used List1PROJECT_IDProject Namenvarchar100
TOPImplementation Guide
72SPROUPGRADE_TLogical Components and Product Versions in Upgrade Project1PROJECT_IDProject Namenvarchar100
73TDEVOBJPObject List of Program Objects in a Project1PROJECT_IDProject Namenvarchar100
74TENABPAssignment of Projects to Enablement Map Nodes1PROJECT_IDProject Namenvarchar100
75TKEYPProject Keywords1PROJECT_IDProject Namenvarchar100
76TKEYTPProject Keywords2PROJECT_IDProject Namenvarchar100
77TNOTEPProject note type1PROJECT_IDProject Namenvarchar100
78TOBJECTPObjects assigned to a project1PROJECT_IDProject Namenvarchar100
79TPRIOPProject Priorities1PROJECT_IDProject Namenvarchar100
80TPROJDISTAssigned Subprojects1PROJECT_IDProject Namenvarchar100
81TPROJECTSPROJECT: Project Table1PROJECT_IDProject Namenvarchar100
82TPROJECTFProject Management Favorites List2PROJECT_IDProject Namenvarchar100
83TPROJECTTProject Table Text Table2PROJECT_IDProject Namenvarchar100
84TPROJMILESTONEProject Milestones1PROJECT_IDProject Namenvarchar100
85TPROJ_GENProject Additional Data Table1PROJECT_IDProject Namenvarchar100
86TPRORGUNITSOrganizational Units Affected in a Project1PROJECT_IDProject Namenvarchar100
87TRESSPProject Resources1PROJECT_IDProject Namenvarchar100
88TRESTPProject Resources Text2PROJECT_IDProject Namenvarchar100
89TSTATPStatus Assignment to a Project1PROJECT_IDProject Namenvarchar100
90TTABPTabs Used in Project1PROJECT_IDProject Namenvarchar100
TOPPackage Tools
91PAK_PROJECTSF4 Values for cPro Projects3PROJECT_IDExternal cPro Project IDnvarchar240
TOPService Implementation Workbench
92TSIW_CONTEXTContext of SIW project1PROJECT_IDSIW Project IDnvarchar400
93TSIW_CONTEXT_VARproject variables1PROJECT_IDSIW Project IDnvarchar400
94TSIW_HISTORYHistory of project Data1PROJECT_IDSIW Project IDnvarchar400
95TSIW_IMPLSIW Implementation Project Head Table1PROJECT_IDSIW Project IDnvarchar400
96TSIW_IMPL_PIECEStück einer Projektimplementation1PROJECT_IDSIW Project IDnvarchar400
97TSIW_LINKSIW Signature Field/Type Mapping1PROJECT_IDSIW Project IDnvarchar400
98TSIW_LRULeast recently used projects3PROJECT_IDSIW Project IDnvarchar400
99TSIW_MAPPINGSIW Mapping Header1PROJECT_IDSIW Project IDnvarchar400
100TSIW_NAME_RESERVreserved names1PROJECT_IDSIW Project IDnvarchar400
101TSIW_PROJRoot Table for project1PROJECT_IDSIW Project IDnvarchar400
102TSIW_PROJTTexttabelle zu TSIW_PROJ_HEAD2PROJECT_IDSIW Project IDnvarchar400
103TSIW_SXF_APISignature Exchange Format - API Component1PROJECT_IDSIW Project IDnvarchar400
104TSIW_SXF_FIELDSignature Exchange Format - Field1PROJECT_IDSIW Project IDnvarchar400
105TSIW_SXF_FIELDRLField relations1PROJECT_IDSIW Project IDnvarchar400
106TSIW_SXF_TYPESignature Exchange Format - Type1PROJECT_IDSIW Project IDnvarchar400
107TSIW_TESTDATATest data1PROJECT_IDSIW Project IDnvarchar400
TOPStructure
108DPR_PROJECTProject Definition5PROJECT_IDProject Numbernvarchar240
TOPTest Organizer
109TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes32PROJECT_IDProject Namenvarchar100
TOPTransport Organizer
110SCTS_PROJECTCentral CTS: Generic Project Persistence3PROJECT_IDCentral CTS: Project IDnvarchar320
111SCTS_PROJECTTCentral CTS: Generic Project Persistence - Texts3PROJECT_IDCentral CTS: Project IDnvarchar320