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

49 columns | Print definition?ERP 6.0  | ITEM_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/LOCSRM/T_LAW_BRLAW 123 Bidders and corresponding Item line for an auction3ITEM_GUIDGlobally Unique Identifiervarbinary160
2/PLMI/GSS_R2B_ABSplit Points for Additional BOMs in R2B Synchronization5ITEM_GUIDFormula Item GUIDvarbinary160
3/SAPSRM/D_WF_006Table for persistent class /SAPSRM/CL_WF_DS_ITEM6ITEM_GUIDPurchasing Document Item GUIDvarbinary160
4/SAPSRM/D_WF_015Item to Ad Hoc Process Level3ITEM_GUIDPurchasing Document Item GUIDvarbinary160
5/SLCE/ITEM_XMLLinking of Item to Configuration XML2ITEM_GUIDCommentnvarchar500
6/SYCLO/PSH02Syclo Push Register - Instance items2ITEM_GUIDPush instance item GUIDnvarchar320
7/SYCLO/PSH05User Push history10ITEM_GUIDPush instance item GUIDnvarchar320
8BBPD_PD_INDEX_IIndex Table for a Selective First Access in GetList3ITEM_GUIDGlobally Unique identifiervarbinary160
9BBP_PDSDLNBusiness Transaction Item - Schedule Line8ITEM_GUIDGUID of a CRM Order Objectvarbinary160
10LOP_D_LIST_ITOption list items4ITEM_GUIDOption List Item GUIDvarbinary160
11LOP_D_MASTER_ITOption List items as master data4ITEM_GUIDOption List Item GUIDvarbinary160
12ZZRPM_ITEM_LOCKStore entries of all items that are sent for approval2ITEM_GUIDGuid for application objectsvarbinary160
TOPChargeback
13WCOCOICondition Contract: Eligible Partner3ITEM_GUIDCondition Contract: Item GUIDvarbinary160
14WCOCOPCondition Contract: Partner Assignment18ITEM_GUIDCondition Contract: Item GUIDvarbinary160
TOPCollaborative Cross Applications
15/POA/D_CTX_ITEMPOA SBC Context Item3ITEM_GUIDBusiness Context IDnvarchar320
TOPCommon Functions
16INM_INITIATIVEInitiative Master Table3ITEM_GUIDGuid for application objectsvarbinary160
17INM_INIT_CDInitiative- Pseudo table for change documents3ITEM_GUIDGuid for application objectsvarbinary160
TOPControl Plan
18QPCPD_ITEMItem of Control Plan2ITEM_GUIDGUID of an Element in Control Planvarbinary160
TOPCRM Accruals
19IPM_ACE_BTA_DATAAssignment Table for Revenue Distribution from CRM2ITEM_GUIDGUID of a CRM Order Objectvarbinary160
TOPGoods Issue Process
20/SPE/CRMD_PO_MAPCorrelation Table Third Party PO <-> CRM Sales Order5ITEM_GUIDGUID of a CRM Order Objectvarbinary160
21/SPE/CRMD_PR_MAPMapping Table Purchase Requisition <-> CRM Sales Order5ITEM_GUIDGUID of a CRM Order Objectvarbinary160
TOPIncentive and Commission Management ICM
22YCRM01_B_VAR_OBJVariants for Commission Case Object Data27ITEM_GUIDTransaction GUIDnvarchar320
23YCRM01_DOCRECommission Document, Remuneration and Liability8ITEM_GUIDTransaction GUIDnvarchar320
24YCRM01_DOCVACommission Document, Valuation30ITEM_GUIDTransaction GUIDnvarchar320
25YCRM01_OBJCommission Case Object Data13ITEM_GUIDTransaction GUIDnvarchar320
26YHITEC_B_VAR_OBJVariants for Commission Case Object Data10ITEM_GUIDTransaction GUIDnvarchar320
27YHITEC_DOCRECommission Document, Remuneration and Liability8ITEM_GUIDTransaction GUIDnvarchar320
28YHITEC_DOCVACommission Document, Valuation10ITEM_GUIDTransaction GUIDnvarchar320
29YHITEC_OBJCommission Case Object Data12ITEM_GUIDTransaction GUIDnvarchar320
30YTEL05_B_VAR_OBJVariants for Commission Case Object Data27ITEM_GUIDTransaction GUIDnvarchar320
31YTEL05_DOCRECommission Document, Remuneration and Liability8ITEM_GUIDTransaction GUIDnvarchar320
32YTEL05_DOCVACommission Document, Valuation11ITEM_GUIDTransaction GUIDnvarchar320
33YTEL05_OBJCommission Case Object Data25ITEM_GUIDTransaction GUIDnvarchar320
TOPIntegration Customer Relationship Management
34ECONSEG_I_PARCustomer Consumption Segment Item Parameter2ITEM_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPLogistics - General
35CMDET_S06667Individual Records for Updating External Credit Data7ITEM_GUIDItem GUID for CRM Transaction or Billing Engine Billing Doc.nvarchar320
36CRM_SRV_LOG_SCCRM Service: Logistics Scenarios4ITEM_GUIDExternal Object Technical Keynvarchar340
TOPPortfolio Management
37/RPM/CO_DOWNLOADCO Download persisted data2ITEM_GUIDGuid for application objectsvarbinary160
38/RPM/DECISIONDecision Point Object Data4ITEM_GUIDGuid for application objectsvarbinary160
39/RPM/DP_DERDecision Point Derived Table4ITEM_GUIDGuid for application objectsvarbinary160
40RPM_DECISION_CDDecision Point - Pseudo table for change documents4ITEM_GUIDGuid for application objectsvarbinary160
TOPRecipe Development
41/PLMB/RCP_ASSIGNAssignment of Recipe Items3ITEM_GUIDFormula Item GUIDvarbinary160
42/PLMB/RFO_FRMITMFormula items4ITEM_GUIDFormula Item GUIDvarbinary160
TOPResourcen Management
43MRTRST_STR_RELRMS-MRTRS: Stream with QM to Master Recipe Phase6ITEM_GUIDUniversal Unique Identifiervarbinary160
TOPSelf-Service Procurement
44/SRMERP/D_WF_006Table for persistent class /SRMERP/CL_WF_DS_ITEM6ITEM_GUIDPurchasing Document Item GUIDvarbinary160
45/SRMERP/D_WF_015Item to Ad Hoc Process Level3ITEM_GUIDPurchasing Document Item GUIDvarbinary160
TOPWorkforce Management Core
46WFDSD_DEMANDWork Force Deployment Demand2ITEM_GUIDGUIDvarbinary160
47WFDS_DEM_DATESTimestamps to an CRM Order Item2ITEM_GUIDGUIDvarbinary160
48WFDS_DEM_STAFFLVWFDS Demand Staffing Status2ITEM_GUIDGUIDvarbinary160
49WFDS_QUA_REQQualification Requirements2ITEM_GUIDGUIDvarbinary160