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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

74 columns | Print definition?ERP 6.0  | PRODUCT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_BUND_GRPBundle Groups6PRODUCT_IDExternal CRM Service Product IDnvarchar400
2/MRSS/D_CSG_SPProducts for demands4PRODUCT_IDExternal CRM Service Product IDnvarchar400
3/XLSO/ACCESS_CODAccess Code Details Assigned to a Bulk Sales Order7PRODUCT_IDProduct IDnvarchar80
4/XLSO/ADVERTISEAdvertisements5PRODUCT_IDProduct IDnvarchar80
5/XLSO/ALERTAlerts6PRODUCT_IDProduct IDnvarchar80
6/XLSO/EVOUCH_CONE-Voucher Condition (Stores Product ID of the Voucher)3PRODUCT_IDProduct IDnvarchar80
7/XLSO/RECOM_LRNRRecommendation for Learner5PRODUCT_IDProduct IDnvarchar80
8BBPC_VE_EVENTSEvents for Vendor Evaluation7PRODUCT_IDProduct IDnvarchar400
9BBP_CT_ATTACHMAttachment11PRODUCT_IDProduct ID Buyernvarchar400
10BBP_CT_ATTRAttributes11PRODUCT_IDProduct ID Sellernvarchar400
11BBP_CT_LONGTEXTLong Text11PRODUCT_IDProduct ID Sellernvarchar400
12BBP_CT_PPRODUCTPartner Product11PRODUCT_IDProduct ID Sellernvarchar400
13BBP_PRODUCT_FAVUser-Specific Favorites for Products6PRODUCT_IDProduct IDnvarchar400
14DBA_ALRT_METDBA: Alerting Metrics19PRODUCT_IDntext10737418230
15EPRODDET_SELIS-U: CRM Product Sel Table (for type def, dont populate)2PRODUCT_IDCRM Productnvarchar400
16RTST_OP_STATUSStatus information for a store product3PRODUCT_IDMaterial Numbernvarchar180
17SEPM_DATA_GRIDEPM: Planning Data Grid3PRODUCT_IDEPM: Product IDnvarchar100
18SEPM_GRID_DATAEPM: Planning Grid Data3PRODUCT_IDEPM: Product IDnvarchar100
19VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)19PRODUCT_IDInternal Product IDnvarchar180
20VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)19PRODUCT_IDInternal Product IDnvarchar180
TOPBank Customer Accounts
21TBKK_CLS_BALSettings for accnt. balancing date during accnt. closure3PRODUCT_IDInternal Product IDnvarchar180
22TBKK_CLS_OBJ_TMNSettings for accnt. dependant objects during account closure3PRODUCT_IDInternal Product IDnvarchar180
TOPCentral Part of Product Master
23COMC_PR_TEMPLATEProduct Template for Configurable Products4PRODUCT_IDProduct IDnvarchar400
24COMM_IPRODUCTInactive Product3PRODUCT_IDProduct IDnvarchar400
25COMM_PRODUCTProduct3PRODUCT_IDProduct IDnvarchar400
26COMM_PRODUCTHProduct History4PRODUCT_IDProduct IDnvarchar400
27COMM_PRODUCT_IDXIndex Table for Products5PRODUCT_IDProduct IDnvarchar400
28COMS_ALTID_VALTable for Alternative ID4PRODUCT_IDProduct IDnvarchar400
TOPConfiguration management
29TCM_BASELINEBaseline data (Configuration Management)3PRODUCT_IDConfiguration definitionnvarchar400
30TCM_BASELINETText table for Baseline description3PRODUCT_IDConfiguration definitionnvarchar400
31TCM_PFOLDERConfiguration Folder (Configuration Management)3PRODUCT_IDConfiguration definitionnvarchar400
32TCM_PF_CONTTable for data container for product folder (Conf. Mgmt)3PRODUCT_IDConfiguration definitionnvarchar400
33TCM_PF_CONTTText table for description for configuration folders3PRODUCT_IDConfiguration definitionnvarchar400
34TCM_PMASTERCM: Header data for product2PRODUCT_IDConfiguration definitionnvarchar400
35TCM_PMASTERTText table for language dependent description2PRODUCT_IDConfiguration definitionnvarchar400
36TCM_WORKLISTWorklist for the CM user4PRODUCT_IDConfiguration definitionnvarchar400
TOPControlling
37IAOM_CRMSRV_EXATExt. Attributes of an Ext. Object (Single Obj.Controlling)15PRODUCT_IDProduct IDnvarchar400
TOPIncentive and Commission Management ICM
38YHITEC_B_VAR_OBJVariants for Commission Case Object Data14PRODUCT_IDProduct IDnvarchar400
39YHITEC_DOCRECommission Document, Remuneration and Liability14PRODUCT_IDProduct IDnvarchar400
40YHITEC_OBJCommission Case Object Data16PRODUCT_IDProduct IDnvarchar400
TOPIntegration Customer Relationship Management
41EPPSIMRESULTProduct Proposal Simulation Results6PRODUCT_IDCRM Productnvarchar400
42ESIMCHARSimulation Characteristics4PRODUCT_IDCRM Productnvarchar400
43ESIMCHAR_1Simulation Characteristics4PRODUCT_IDCRM Productnvarchar400
44ESIMPCAT_ISimulation Product Catalog Item3PRODUCT_IDCRM Productnvarchar400
45ESIMPRODUCTSAdmissible Simulation Products2PRODUCT_IDCRM Productnvarchar400
46ESIMPRODUCTSTAdmissible Simulation Products Text3PRODUCT_IDCRM Productnvarchar400
TOPIntercompany Data Exchange
47EDEREG_SIDPROExternal ID of Service4PRODUCT_IDIdentificationnvarchar200
48TINV_INV_LINE_BBill Line with Posting Information11PRODUCT_IDIdentificationnvarchar200
49TINV_INV_LINE_IBill Line Item with Information (Not Relevant to Posting)11PRODUCT_IDIdentificationnvarchar200
50TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines11PRODUCT_IDIdentificationnvarchar200
TOPKnowledge Warehouse
51PRD_ASSIGNKWSTAT: Assignment of Product Context3PRODUCT_IDProject Identificationnvarchar100
52PRD_SUBSTRKWSTAT: Definition of Product Sub-Structures2PRODUCT_IDProject Identificationnvarchar100
TOPLoans Management
53TTONFTVDARLTest neue Fima: Grunddaten und VDARL159PRODUCT_IDInterne Produkt-IDnvarchar180
54VDARLLoans145PRODUCT_IDInternal Product IDnvarchar180
TOPNetWeaver Demonstration
55SDEMO_PDSAP NetWeaver Demo Model - Product3PRODUCT_IDProduct IDnvarchar600
56SDEMO_SO_ISAP NetWeaver Demo Model - Sales Order Item10PRODUCT_IDProduct IDnvarchar600
57SNWD_PDEPM: Product Data Table3PRODUCT_IDEPM: Product IDnvarchar100
TOPPackage Tools
58AKB_PRODCOMPObsolete: Product Components: SW Components of an SW Product1PRODUCT_IDObsolete: Software Product IDnvarchar200
59AKB_RUNLISTObsolete: Information for Decoupling Administration1PRODUCT_IDObsolete: Software Product IDnvarchar200
60AKB_SYSLISTObsolete: BCB System List for Replication1PRODUCT_IDObsolete: Software Product IDnvarchar200
TOPProduct Structure Browser
61USROBJECTSTable of Previous Initial Object in Structure Overview22PRODUCT_IDConfiguration definitionnvarchar400
TOPReusable Components of Business Suite Foundation
62/BOBF/DM_PRD_HDRProduct Header (Demo)4PRODUCT_IDProduct IDnvarchar300
63/BOFU/DM_PRD_HD1Header3PRODUCT_IDProduct IDnvarchar300
64/BOFU/DM_PRD_HDRHeader4PRODUCT_IDProduct IDnvarchar300
65/BOFU/DTSTSORDITSales Order Item9PRODUCT_IDProduct IDnvarchar300
TOPSAP NetWeaver Mobile - Use subcomponents
66MEREP_TORDERMI Testtool - Orders3PRODUCT_IDMI:Testcases - Product IDnvarchar180
67MEREP_TORDERITEMSales Order item4PRODUCT_IDMI:Testcases - Product IDnvarchar180
68MEREP_TORDERITMSales Order item4PRODUCT_IDMI:Testcases - Product IDnvarchar180
69MEREP_TORDERSMI Testtool - Orders3PRODUCT_IDMI:Testcases - Product IDnvarchar180
70MEREP_TPRODUCTMI Testtool - Product2PRODUCT_IDData Element for Test SyncBOnvarchar80
71MEREP_TPRODUCTSMI Testtool - Product2PRODUCT_IDMI:Testcases - Product IDnvarchar180
TOPWorkbench Utilities
72RLB_DB_HLReuse Library: Where-Used List/Hit List3PRODUCT_IDReuse Library: Reuse Product Internal IDnvarchar320
73RLB_DB_PRReuse Library: Product: Data1PRODUCT_IDReuse Library: Reuse Product Internal IDnvarchar320
74RLB_DB_PRTReuse Library: Product: Name1PRODUCT_IDReuse Library: Reuse Product Internal IDnvarchar320