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

Home | ERP 6.0 
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

66 columns | Print definition?ERP 6.0  | PRODUCT_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_CSG_SPProducts for demands3PRODUCT_GUIDProduct guidvarbinary160
2/MRSS/D_CSG_SPLKLink between service product and MRS demand3PRODUCT_GUIDGUIDvarbinary160
3BBP_CCM_ITEMList of Catalog Entries Already Sent to XI2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
4BBP_CT_ATTRAttributes4PRODUCT_GUIDProduct GUIDvarbinary160
5BBP_CT_PPRODUCTPartner Product4PRODUCT_GUIDProduct GUIDvarbinary160
6BBP_CT_PRDPRICEProduct Price4PRODUCT_GUIDProduct GUIDvarbinary160
7BBP_CT_PRODUCTProduct2PRODUCT_GUIDProduct GUIDvarbinary160
8BBP_PRODUCT_FAVUser-Specific Favorites for Products4PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPArchiving
9COMM_PRARCVERIFYTable of Selected Non-Archivable/Non-Deletable Products2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPAuto-ID Infrastructure
10AIN_PROD_TGRAIGRAI-Global Returnable Asset Identifier2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
11AIN_PROD_TGRAIHGRAI-Global Returnable Asset Identifier2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPCentral Part of Product Master
12COMM_IPRODUCTInactive Product2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
13COMM_PRFREEATTRFree Attributes for a Product2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
14COMM_PRFREEATTRHFree Attributes for a Product - History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
15COMM_PRODUCTProduct2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
16COMM_PRODUCTHProduct History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
17COMM_PRODUCT_IDXIndex Table for Products2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
18COMM_PRPRDCATRProduct - Product Category Assignment2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
19COMM_PRPRDCATRHProduct - Product Category Assignment: History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
20COMM_PRSHTEXTProduct Description2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
21COMM_PRSHTEXTHProduct Description (History)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
22COMM_PR_FRG_REGProduct-Set Assignment (Gen. Link-Handler)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
23COMM_PR_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
24COMM_PR_FRG_RELProduct - Set - Assignment2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
25COMM_PR_FRG_RELHProduct - Set - Assignment History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
26COMM_PR_GTINGTIN - Global Trade Item Number2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
27COMM_PR_GTINHGTIN - Global Trade Item Number History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
28COMM_PR_UNITProduct Unit of Measurement2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
29COMM_PR_UNITHProduct Unit of Measurement History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
30COMS_ALTID_VALTable for Alternative ID3PRODUCT_GUIDInternal Unique ID of Productvarbinary160
31COM_COMMERCIALBusiness data2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
32COM_COMMERCIALHBusiness data2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
33CRMM_PR_TAXProduct Sales Tax2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
34CRMM_PR_TAXHProduct Sales Tax - History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPConfiguration management
35TCM_PFOLDERConfiguration Folder (Configuration Management)7PRODUCT_GUIDGlobally Unique Identifiervarbinary160
36TCM_PMASTERCM: Header data for product3PRODUCT_GUIDGlobally Unique Identifiervarbinary160
TOPIntegration Customer Relationship Management
37ECRM_REPL_HDHeader Data for IS-U Sales Replication Error Handling15PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
38EVER_CRMQISU Contract CRM-Entry Queue10PRODUCT_GUIDGlobally Unique Identifiervarbinary160
TOPMaster Data
39EVERHIS-U Contract History11PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
TOPMaster Data Framework
40DML_LH_FRG_REGProduct-Set Assignment (Gen. Link-Handler)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
41DML_LH_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPNetWeaver Demonstration
42SDEMO_PDSAP NetWeaver Demo Model - Product2PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
43SDEMO_PD_PRSAP NetWeaver Demo Model - Product Price2PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
44SDEMO_PD_STOCKStock of products2PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
45SDEMO_PD_WRSAP NetWeaver Demo Model - Product Web Resource3PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
46SDEMO_SO_ISAP NetWeaver Demo Model - Sales Order Item9PRODUCT_GUIDGUID in 'RAW' formatvarbinary160
47SNWD_GI_IEPM: Goods Issue Item Table8PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
48SNWD_GR_IEPM: Goods Received Item Table8PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
49SNWD_PO_IEPM: Purchase Order Item Table5PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
50SNWD_PO_INV_ITEMEPM: Purchase Order Invoice Items Table11PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
51SNWD_PR_I_TPLEPM: Purchase Requisition Item Database Table Template5PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
52SNWD_SO_IEPM: Sales Order Item Table5PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
53SNWD_SO_INV_ITEMEPM: Sales Order Invoice Items Table11PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
54SNWD_STOCKEPM: Stock Table3PRODUCT_GUIDEPM: Generic Node Keyvarbinary160
TOPObjects
55COM_TA_MANUFACManufacturer Information2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
56COM_TA_MANUFACHManufacturer Information2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
57COM_TA_R3_IDR3 Identification2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
58COM_TA_R3_IDHR3 Identification2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
TOPSet Types and Attributes
59COMM_EXTENSIONHExtension Table History (Template)2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
60COMT_EXT_TEMPTemplate for Extension Tables2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
61COMT_EXT_TEMPHTemplate for Extension Tables History2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
62COMT_EXT_TEMP_DBTemplate for Extension Tables2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
63COMT_SETT_XMaster Data of Set Type <SETTYPE_ID>2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
64COMT_SETT_XMLMaster Data of Set Type <SETTYPE_ID>2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
65COMT_SETT_XML_HHistory of Set Type <SETTYPE_ID>2PRODUCT_GUIDInternal Unique ID of Productvarbinary160
66COMT_SETT_X_HHistory of Set Type <SETTYPE_ID>2PRODUCT_GUIDInternal Unique ID of Productvarbinary160

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy