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  | LOG_SYS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/THHOMPAssign Product Categories to Homogeneous Categories5LOG_SYSSource System Namenvarchar100
2/SAPSRM/PRSEL_PTTable of Process Types per System for Preselection Screen2LOG_SYSLogical systemnvarchar100
3/SAPSRM/PRSEL_TXTable of Process Type Texts Preselection Screen2LOG_SYSLogical systemnvarchar100
4/SAPSRM/SH_ASCATTable for ERP Search Help Account Assignmen Category3LOG_SYSLogical systemnvarchar100
5/SAPSRM/SH_COMPCTable for ERP Search Help Company Codes2LOG_SYSLogical systemnvarchar100
6/SAPSRM/SH_CONFCTable for ERP Search Help Confirmation Control3LOG_SYSLogical systemnvarchar100
7/SAPSRM/SH_MATCLTable for ERP Search Help Material Class2LOG_SYSLogical systemnvarchar100
8/SAPSRM/SH_MATPLTable for ERP Search Help Maintenance Plan of SES2LOG_SYSLogical systemnvarchar100
9/SAPSRM/SH_MCTXTText Table for ERP Search Help Material Class3LOG_SYSLogical systemnvarchar100
10/SAPSRM/SH_MOVTYTable for ERP Search Help Movement Type3LOG_SYSLogical systemnvarchar100
11/SAPSRM/SH_MTYPETable for ERP Search Help Material Type2LOG_SYSLogical systemnvarchar100
12/SAPSRM/SH_MTYTXText Table for ERP Search Help Material Type2LOG_SYSLogical systemnvarchar100
13/SAPSRM/SH_PGRPTable for ERP Search Help Purchasing Groups2LOG_SYSLogical systemnvarchar100
14/SAPSRM/SH_PLANTTable for ERP Search Help Plants2LOG_SYSLogical systemnvarchar100
15/SAPSRM/SH_PORGTable for ERP Search Help Purchase Organizations2LOG_SYSLogical systemnvarchar100
16/SAPSRM/SH_PO_RCTable for ERP Search Help Purchase Requisition Release Code3LOG_SYSLogical systemnvarchar100
17/SAPSRM/SH_PO_RGTable for ERP Search Help Purchase Order Release Group3LOG_SYSLogical systemnvarchar100
18/SAPSRM/SH_PR_RCTable for ERP Search Help Purchase Requisition Release Code3LOG_SYSLogical systemnvarchar100
19/SAPSRM/SH_PR_RGTable for ERP Search Help Purchase Requisition Release Group3LOG_SYSLogical systemnvarchar100
20/SAPSRM/SH_PSTYPText Table for ERP Search Help Process Type3LOG_SYSLogical systemnvarchar100
21/SAPSRM/SH_SCNOTable for ERP Search Help Shipment Cost Number of SES2LOG_SYSLogical systemnvarchar100
22/SAPSRM/SH_SPECNTable for ERP Search Help Model Service Specification of SES2LOG_SYSLogical systemnvarchar100
23/SAPSRM/SH_STLOCTable for ERP Search Help Storage Locations2LOG_SYSLogical systemnvarchar100
24/SAPSRM/SH_STOCITable for ERP Search Help Special stock (indicator) of GR3LOG_SYSLogical systemnvarchar100
25/SAPSRM/WSLPCONFWeb Service Logical Port Configuration2LOG_SYSLogical systemnvarchar100
26BBPD_SUS_BP_DUPLSUS/BP: Staging Table for Duplicate Check2LOG_SYSLogical systemnvarchar100
27BBP_BACKEND_DESTDefinition of Back-End Systems in SAP SRM2LOG_SYSLogical systemnvarchar100
28BBP_BACKEND_NRRGDefinition of No. Range Intervals for Documents in Backend2LOG_SYSLogical systemnvarchar100
29BBP_BACKEND_TEXTLogical Systems Description3LOG_SYSLogical systemnvarchar100
30BBP_DET_ACCOUNTDetermination G/L Account by Product Categories6LOG_SYSSource System Namenvarchar100
31BBP_DET_LOGSYSDetermination of Target System by Product Categories5LOG_SYSTarget System Namenvarchar100
32BBP_LOGSYS_FAVUser-Specific Favorites for Logical Systems3LOG_SYSLogical systemnvarchar100
33BBP_PAYMENT_MAPMapping Table for Terms of Payment (EBP <--> Backend)3LOG_SYSLogical systemnvarchar100
34BBP_RET_BLKDPP EOP Table3LOG_SYSLogical systemnvarchar100
35BBP_STD_ACCLocal Accounting Data2LOG_SYSLogical systemnvarchar100
36BBP_STD_ACCDLocal Account Assignment Data - Value Description2LOG_SYSLogical systemnvarchar100
37BBP_STD_T001Local Company Data For Standalone Scenario2LOG_SYSLogical systemnvarchar100
38BBP_SUS_BPCMPMAPMapping Table for Business Partner (Buyer; Goods Recipient)3LOG_SYSLogical systemnvarchar100
39BBP_TMP_VENObsolete from 2.0C Onwards. Was Never used Before18LOG_SYSLogical systemnvarchar100
40BBP_TMP_VENDNOObsolete from 2.0C Onwards. Was Never used Before7LOG_SYSLogical systemnvarchar100
41BBP_TMP_VENMAPTemporary: Request 'Bidder', Backend System Reference3LOG_SYSLogical systemnvarchar100
42BBP_VDSYNC_CUSTCustomizing Table for Vendor Synchronization3LOG_SYSLogical systemnvarchar100
43GRRMEHSIMPMAPMapping RM and EH&S Impact Level/Severity Values2LOG_SYSLogical systemnvarchar100
44GRRMEHSPROBMAPMapping RM and EH&S probability values2LOG_SYSLogical systemnvarchar100
45GRRMEHSSYSTDefine EH&S systems2LOG_SYSLogical systemnvarchar100
46PERSMAPMapping (People) EBP Partner Number <-> Ext. Partner Number3LOG_SYSLogical systemnvarchar100
47VENMAPMapping Table Partner GUID - R/3 Number3LOG_SYSLogical systemnvarchar100
48VMP_PLNSCP_HDRDocument and BOM Links5LOG_SYSLogical Destination (Specified in Function Call)nvarchar320
49VMP_PLSCP_LOGHVMP Planning Scope Sync log history header table5LOG_SYSLogical Destination (Specified in Function Call)nvarchar320
TOPInformation System
50FTI_BI_REQFLDSFields Requested from BI System3LOG_SYSLogical systemnvarchar100
TOPMaterials Management
51BBPC_RFC_DESTRFC Destinations that Refer to an SRM System2LOG_SYSLogical systemnvarchar100