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

102 columns | Print definition?ERP 6.0  | OBJECTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SOBJECTIDMaster Data IDs: InfoObject Object Identifier1OBJECTIDObject Identification in Segmentsnvarchar100
2/SAPPSSRM/DOBVERSRM and Document Builder versions2OBJECTIDSAP Document Numbernvarchar100
3BUT_UNBLK_REQSTUblocking Request Data2OBJECTIDObject IDnvarchar100
4CDCLS3OBJECTIDnvarchar900
5CDPOSChange document items3OBJECTIDObject valuenvarchar900
6CNVMBTATTACHMENTAttachments5OBJECTIDBusiness Document Service: Object keynvarchar700
7GRACANALYZEDOBJAnalyzed Objects5OBJECTIDExternal object IDnvarchar3000
8GRACBGRULEGENBackground Rule Generation.4OBJECTIDObject IDnvarchar500
9GRACEXTOBJTable for extended length objects3OBJECTIDExternal object IDnvarchar3000
10GRACHROBJACTVLHR Object Action Violation Table2OBJECTIDObject IDnvarchar80
11GRACHROBJCRPVLHR Object Critical Role/Profile Violation Table2OBJECTIDObject IDnvarchar80
12GRACHROBJPRMVLUser Permission Violation Table2OBJECTIDObject IDnvarchar80
13GRACMGRISKDRisk Analysis Mgmt Sum data for Batch Risk Analysis.4OBJECTIDObject IDnvarchar500
14GRACMITMSMPVALIMitigation Assignment Workflow Validation3OBJECTIDGeneric mitigation objectnvarchar500
15GRACMITOBJECTMitigating control assignment3OBJECTIDGeneric mitigation objectnvarchar500
16GRFNFDSSTDMETAFlexible Data Store - Storage Type - DMS, Meta Data6OBJECTIDObject IDnvarchar500
17GRFNFDSSTFMETAFlexible Data Store - Storage Type - File, Meta Data6OBJECTIDObject IDnvarchar500
18GRFNTSVYGROUPSurvey Instance Group4OBJECTIDObject IDnvarchar500
19GRRMCONTEXTGRRM Context data base table for non HR Entities2OBJECTIDObject IDnvarchar500
20PCDCLS3OBJECTIDnvarchar400
21PCDPOSChange document items3OBJECTIDObject valuenvarchar900
22SMI_SRCTRM_OBJTYObject Type and Search Term Mapping4OBJECTIDObject IDnvarchar400
TOPAccounts Payable
23/PTGWFI/F_SMIMTRSMI Process Monitor7OBJECTIDSAP ArchiveLink: Object ID (object identifier)nvarchar500
TOPAppropriation Requests
24ARC_IDX_APPREQIM: Index Table for Archiving Appropriation Requests2OBJECTIDID of Data Object for Direct Access to ADK Archivesnvarchar200
TOPAudit trail enhancements ILM
25AUT_D_ILM_CDHDRAudit Trail (ILM): Storage Change Document Headers (ILM)4OBJECTIDObject valuenvarchar900
26AUT_D_ILM_CDPOSAudit Trail (ILM): Storage Change Document Items (ILM)4OBJECTIDObject valuenvarchar900
27AUT_D_ILM_CD_STRAudit Trail (ILM): Storage for Change Docs (STRING Values)5OBJECTIDObject valuenvarchar900
28AUT_D_ILM_CD_UIDAudit Trail (ILM): Storage of Addl Data (TABKEY > 70 Chars)5OBJECTIDObject valuenvarchar900
TOPBatch-Oriented Parallel Processing of Mass Data
29BANK_PP_PERSMNGTPersistence Management for Process Objects2OBJECTIDID of a Process (in End of Day Processing)nvarchar400
TOPBudgeting
30FMBUDTXTBudget texts register12OBJECTIDGUIDnvarchar320
TOPBudgeting and Availability Control
31GMBDGTHEADERBudget Document Header31OBJECTIDGUIDnvarchar320
TOPBusiness Planning and Simulation
32UPX_KPI_APPUPX_KPI_APP2OBJECTIDCharacteristicnvarchar300
33UPX_KPI_EVALBUFKPI Valuation for Alert: Result Buffer2OBJECTIDField for Any Characteristic Valuenvarchar600
TOPChange Documents
34CDHANDLECD: Dummy Table for Lock Object3OBJECTIDObject valuenvarchar900
35CDHDRChange document header3OBJECTIDObject valuenvarchar900
36CDPOS_STRAdditional Change Document - Table for STRINGs4OBJECTIDObject valuenvarchar900
37CDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Characters4OBJECTIDObject valuenvarchar900
38CDSOLMIG_HDRCDHDR Entries Transferred Through Solution Manager4OBJECTIDObject valuenvarchar900
39PCDHDRChange document header3OBJECTIDObject valuenvarchar900
40PCDPOS_STRAdditional Planned Change Document: Table for STRINGs4OBJECTIDObject valuenvarchar900
41PCDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Chars-Plnnd Chg.4OBJECTIDObject valuenvarchar900
TOPClinical System
42N2DOCCOMPIS-H*MED: Documentation Components6OBJECTIDObject Keynvarchar400
TOPCross-Application Components
43/IXOS/RM_TPROTLog table2OBJECTIDGUIDnvarchar320
TOPData Staging
44RSDSRTCOUNTDataSource: Object ID Counter4OBJECTIDObject IDint100
TOPDB2 for OS39
45DB2CCMO_IN1History of input table 1 for DB13 jobs executed via DSNACCMO3OBJECTIDID of the DB object as input for stored procedure DSNACCMOint100
46DB2CCMO_OBJERRDSNACCMO: History of failed utility executions3OBJECTIDID of the DB object as input for stored procedure DSNACCMOint100
47DB2CCMO_OUTTSHistory of output table for DB13 jobs executed via DSNACCMO3OBJECTIDID of the DB object as input for stored procedure DSNACCMOint100
TOPDistributed System Landscape
48/ISDFPS/CDLOGSYSChange Documents: Local Assignment of Doc. to Doc. Sender4OBJECTIDObject valuenvarchar900
TOPEmployee Interaction Center
49THREIC_ACTIVITYEIC Activity29OBJECTIDObject IDnvarchar80
50THREIC_CONTACTEIC Contact16OBJECTIDObject keynvarchar700
TOPEnd User Technology
51RSIXWWWCluster Table for Storing Web Reporting Components2OBJECTIDBusiness Document Service: Document IDnvarchar420
TOPGRC Access Control Plug-In
52/VIRSA/ZFFCDHDRFirefightId Change Document9OBJECTIDObject valuenvarchar900
TOPGRC Risk Management
53GRRMSVYANALSurvey analysis data table3OBJECTIDObject IDnvarchar500
54GRRMTSVYINSTSurvey Instance table5OBJECTIDObject IDnvarchar500
TOPIntegrated Product and Process Engineering
55PPECIF_LOGMSGiPPE/CIF: Comparison Result of an iPPE Object3OBJECTIDInternal Description of an iPPE Objectvarbinary160
56PPECIF_LOGOBJiPPE/CIF: Different Objects3OBJECTIDInternal Description of an iPPE Objectvarbinary160
TOPInterestCharge Calculation
57BKKMPERSMNGTPersistence Management for Process Objects2OBJECTIDID of a Process (in End of Day Processing)nvarchar400
TOPLease Accounting
58FILA_MIG_SYNCSynchronization of CRM and LAE Legacy Data3OBJECTIDContract Numbernvarchar100
59FILA_RE_TR_ITranche Item: Selection Result for Refinancing7OBJECTIDContract Numbernvarchar100
60LAE_CRM_HEADERLAE: CRM Contract Header5OBJECTIDContract Numbernvarchar100
TOPLoans Management
61LOANREF_AReference Records of Loan Reference Unit for Disbursement4OBJECTIDObject ID of loan unitnvarchar350
62LOANREF_VReference Recs of Loan Ref. Unit for Val-Dated Cumulation4OBJECTIDObject ID of loan unitnvarchar350
63VDARC_DOC_INDIndex Table for the Loan Document Data Archiving8OBJECTIDObject ID of loan unitnvarchar350
TOPMarketing, Accounting and Pricing
64OICSDPCDVERChange document version management3OBJECTIDObject valuenvarchar900
TOPMaster Data
65GMGRGrant Master63OBJECTIDGUIDnvarchar320
66GMSPONSORSponsor Master16OBJECTIDGUIDnvarchar320
TOPMobile Applications
67/ISDFPS/METFLDCustomizing: Field Properties (Mobile Application)2OBJECTIDObject IDnvarchar200
TOPOffice Suite Program
68/OSP/T_ALERT_INFBook keeping table for alert information in budget monitor7OBJECTIDObject IDnvarchar340
69/OSP/T_RULE_OBJBook keeping table to store list of cost objects of a rule6OBJECTIDObject IDnvarchar340
TOPProduct Configurator
70COMM_CFGVALSYMSymbol Table for Characteristic Values3OBJECTIDInternal identifier of a model elementint100
TOPProduct Safety
71ESTALEEHS: ALE - reference to originals6OBJECTIDData Element Type CHAR Length 35nvarchar350
TOPRegulatory reporting for insurance companies
72TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung7OBJECTIDObjektwertnvarchar900
TOPSAP Business Workflow
73SWZAIENTRYObject Table for Work Queues (Entries)3OBJECTIDObject IDnvarchar900
74SWZAIRETReturn Values of Method Call of a WQ Line3OBJECTIDObject IDnvarchar900
TOPSAP NetWeaver Mobile - Use subcomponents
75MEREP_TESTTOOLSmart Sync test tool attribute4OBJECTIDObject IDnvarchar300
76MEREP_TESTTOOLTSmart Sync test tool attribute4OBJECTIDObject IDnvarchar300
TOPSCM Basis
77CIF_MAP_HANDLETable: Conversion of Object ID to Unique Handle1OBJECTIDObject ID for Unique Assignment to HANDLEnvarchar400
TOPScripting
78CRMD_IC_FAVORSTable for maintaining my Favorites3OBJECTIDXML Document Namenvarchar320
TOPSocial Services and Social Security
79PSSCD_GEDGross Entitlement Determination Header Data3OBJECTIDSocial Service Business Object Identifiernvarchar320
80PSSCD_GPDGross Payment Document Header Data3OBJECTIDSocial Service Business Object Identifiernvarchar320
81PSSCD_NCDNet Calculation Document Header Data2OBJECTIDNet Calculation Document Identifiernvarchar320
82PSSCD_SXPSXP Header Data3OBJECTIDSocial Service Business Object Identifiernvarchar320
TOPTakeoverHandover of Technical Objects
83PHINHHeader Table for Take Over10OBJECTIDGUIDnvarchar320
TOPTransport Management System
84CTSOBJLISTCTS+ Object List: DB Main Persistence6OBJECTIDECTS: Object IDntext10737418230
TOPUser and Authorization Management
85SUIM_CHG_IDXChange Document Index for User Data8OBJECTIDObject valuenvarchar900
86USARC_CDREDReloaded Archived Change Documents for User Data2OBJECTIDObject valuenvarchar900
TOPUser Interface Framework
87TPTGCFRMAssignment of GUI Object to Funct. Module (Enhancemnt Layer)3OBJECTIDObject IDnvarchar300
88TPTGCLYTSGUI Layout Structure (Enhancement Layer)5OBJECTIDObject IDnvarchar300
89TPTGCOBJGUI Objects (Enhancement Layer)3OBJECTIDObject IDnvarchar300
90TPTGCOBJTGUI Objects Text (Enhancement Layer)3OBJECTIDObject IDnvarchar300
91TPTGCSCRAssignment of GUI Object to Subscreen (Enhancement Layer)3OBJECTIDObject IDnvarchar300
92TPTGSFRMAssignment of GUI Object to Function Module2OBJECTIDObject IDnvarchar300
93TPTGSLYTSGUI Layout Structure4OBJECTIDObject IDnvarchar300
94TPTGSOBJGUI Objects2OBJECTIDObject IDnvarchar300
95TPTGSOBJTText for GUI Objects2OBJECTIDObject IDnvarchar300
96TPTGSSCRAssignment of GUI Object to Subscreen2OBJECTIDObject IDnvarchar300
97TPTUCLYTSUIA Layout Structure (Enhancement Layer)6OBJECTIDObject IDnvarchar300
98TPTUCOBJUIA Objects (Enhancement Layer)3OBJECTIDObject IDnvarchar300
99TPTUCOBJTTexts for UIA Objects (Enhancement Layer)3OBJECTIDObject IDnvarchar300
100TPTUSLYTSUIA Layout Structure5OBJECTIDObject IDnvarchar300
101TPTUSOBJUIA Objects2OBJECTIDObject IDnvarchar300
102TPTUSOBJTTexts for UIA Objects2OBJECTIDObject IDnvarchar300