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

51 columns | Print definition?ERP 6.0  | OBJ_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/N_DT_EVNT_IDetected events, which potentially need to be reloaded9OBJ_KEYConcatenated Object Keynvarchar700
2DIAN_A_EXTR_INFODocuments information related to the extracted DIAN data5OBJ_KEYText Fieldnvarchar500
3J_3RF_TP_FL_ATTSAttachments links to nodes for folders hierarchy model2OBJ_KEYObject key - SYSUUID 22nvarchar220
4J_3RF_TP_FL_FLDSFolders hierarchy for folders model2OBJ_KEYObject key - SYSUUID 22nvarchar220
5J_3RF_TP_FL_FLKSObject keys for folders hierarchy model4OBJ_KEYObject key - SYSUUID 22nvarchar220
6P2RX_FUNDAccounting Structure for Funds Management14OBJ_KEYReference Keynvarchar200
7VDARC_COL_KEYArchive Key for Collateral Objects and Collaterals9OBJ_KEYKey for Archive Filenvarchar200
8/BOBF/OBM_NODEBOPF Configuration: Node6OBJ_KEYBusiness Object Versionvarbinary160
9/BOBF/OBM_OBJBOPF Configuration: Version4OBJ_KEYBusiness Object Versionvarbinary160
10/BOBF/OBM_OBJTBOPF Configuration: Text Table for /BOPF/OBM_OBJ5OBJ_KEYBusiness Object Versionvarbinary160
11/BOBF/OBM_VRSBOPF Configuration: Model Versions5OBJ_KEYBusiness Object Versionvarbinary160
TOPAccounts Receivable Accounting Process Integration
12FDM_DCOBJFSCM-DM Integration: Disputed Objects4OBJ_KEYObject keynvarchar700
13FDM_DCPROCFSCM-DM Integration: Dispute Case Processes10OBJ_KEYObject keynvarchar700
TOPAdaptor
14UKM_DCDOBJCredit Management Link to DCD Case4OBJ_KEYObject keynvarchar700
TOPBalanced Scorecard
15UMB_CM101Performance Overview: Item5OBJ_KEYScorecard Elements: Object Keynvarchar300
16UMB_SC170Scorecard: Weights for Status Calculation4OBJ_KEYScorecard Elements: Object Keynvarchar300
17UMB_SC171Scorecard: BW Web Report (Obsolete)5OBJ_KEYScorecard Elements: Object Keynvarchar300
18UMB_SC172Scorecard: URL (Obsolete)5OBJ_KEYScorecard Elements: Object Keynvarchar300
19UMB_SC173Scorecard: BW Web Report5OBJ_KEYScorecard Elements: Object Keynvarchar300
20UMB_SC174Scorecard: URL5OBJ_KEYScorecard Elements: Object Keynvarchar300
TOPBudget Management
21HRP1504DB Table for Infotype 150438OBJ_KEYReference Keynvarchar200
22HRP1505DB Table for Infotype 150534OBJ_KEYReference Keynvarchar200
23HRP1518DB Table for Infotype 151820OBJ_KEYReference Keynvarchar200
24HRPADPMAdditional Data PADPM19OBJ_KEYReference Keynvarchar200
TOPClinical System
25N2COMM_LOGDocuments Received in Temporary Storage9OBJ_KEYInternal Key of a Transferred Objectnvarchar1200
26N2COMM_LOGSTATLast Known Status for Transmitted Object8OBJ_KEYInternal Key of a Transferred Objectnvarchar1200
TOPCost Center Accounting
27COPLNCTRLControl Data for Planning Source5OBJ_KEYReference Keynvarchar200
TOPData Replication Framework
28FOX3_FKO_TESTTest Data for the Test of Foreign Key Objects5OBJ_KEYObject Key (Such As Material or BOM)nvarchar1000
29FOX3_INST_DBData Storage for FOX Instances5OBJ_KEYObject Key (Such As Material or BOM)nvarchar1000
TOPDown Payment Chains
30/SAPPCE/TDPC20Down Payment Chain: Document Header22OBJ_KEYReference Keynvarchar200
TOPLease Accounting
31FIOTPOIOne-Time Postings: Items15OBJ_KEYReference Keynvarchar200
TOPLoans Management
32VDARLLoans181OBJ_KEYKey for Archive Filenvarchar200
TOPMaster Data Distribution
33/ISDFPS/EXPO_LISAdditional Objects5OBJ_KEYObject key (such as material, BOM, ...)nvarchar840
34/ISDFPS/FOX_EOBJFOX: Exception Objects3OBJ_KEYObject key (such as material, BOM, ...)nvarchar840
TOPMaterials Management
35/ISDFPS/LOSSMANLoss Management3OBJ_KEYObject Key (Such As Material, BOM, ...)nvarchar840
36/ISDFPS/LOSTMANObsolete3OBJ_KEYObject Key (Such As Material, BOM, ...)nvarchar840
TOPPrint Workbench
37EPRINTACTPrint Action Record4OBJ_KEYObject keynvarchar320
TOPProduct Data Management
38FOX_INST_DBData Storage for FOX Instances5OBJ_KEYObject key (such as material, BOM, ...)nvarchar840
TOPRecords and Case Management
39RMPSD_TRF_IM_IDImport Run - Identifier Look Up3OBJ_KEYObject Keyvarbinary160
40RMPSD_TRF_IM_ITImport Run - Item Work List10OBJ_KEYObject Keyvarbinary160
41RMPS_A2RM_INDEXBOR -> RMS/SPS4OBJ_KEYKey of an SAP objectnvarchar700
TOPRental Accounting
42VIRAINVITEMRE Invoice Item27OBJ_KEYReference Keynvarchar200
TOPResourcen Management
43RMXTT_TRIAL_RELTrial Relationships5OBJ_KEYObject Key of a Trial Relationshipnvarchar600
TOPSAP Utilities
44TEAMI_MSGMessages6OBJ_KEYObject Key of Messagenvarchar640
TOPTools
45T52SPOProcess Manager: Objects of Set7OBJ_KEYProcess Manager: Container for Object Keynvarchar600
46T52SPOTProcess Manager: Objects of Set7OBJ_KEYProcess Manager: Container for Object Keynvarchar600
TOPTransaction Tax Engine
47TTEPD3_DOCUMENT3.0 TTE Persistency Document6OBJ_KEYObject key for reference (AWKEY)nvarchar200
48TTEPDT_DOCUMENTTTE Persistency Document6OBJ_KEYObject key for reference (AWKEY)nvarchar200
49TTESDT_DOCUMENTTTE Simulaton Document30OBJ_KEYObject key for reference (AWKEY)nvarchar200
TOPTravel Expenses
50PTRV_COMM_AMTDetail Data: Transfer to FM When Trip Saved9OBJ_KEYReference Keynvarchar200
51PTRV_COMM_ITMHeader Data: Transfer to FM When Trip Saved8OBJ_KEYReference Keynvarchar200