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

35 columns | Print definition?ERP 6.0  | ITEM_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTTM/BL_T_ERAE-Receipt assignments6ITEM_NOItem number of meta datanvarchar30
2/OTTM/BL_T_ERME-Receipt metadata6ITEM_NOItem number of meta datanvarchar30
3/SYCLO/PSH02Syclo Push Register - Instance items4ITEM_NORecord Idint100
4/SYCLO/SC001Syclo Security Check Profile4ITEM_NOItem no.nvarchar40
5CMCBD_BGT_CLAIMBudget claims based on suggest level9ITEM_NOItem No. in Budget Claimnvarchar50
6CMCBD_CONSUMECash Budgeting Consumption10ITEM_NONumber of Line Item Within Accounting Documentnvarchar30
TOPComplaints and Returns
7/SPE/INSPECRESCInspection Outcome: Item Codes3ITEM_NOInspection Item Numbernvarchar40
8/SPE/INSPECRESPInspection Outcome: Item3ITEM_NOInspection Item Numbernvarchar40
TOPCRM Accruals
9CRM_ACE_OH_DATACRM Accruals: Object Header11ITEM_NOItem Number in CRM Documentnvarchar100
10CRM_ACE_OI_DATACRM Accruals: Item Detail Data of Object14ITEM_NOItem Number in CRM Documentnvarchar100
11CRM_ACE_REFKEYCRM Accruals: REFKEY Decryption5ITEM_NOItem Number in CRM Documentnvarchar100
TOPFinancial Supply Chain Management
12BNK_BATCH_ITEMBatch Payment Items3ITEM_NOItem Count Numbernvarchar50
13BNK_BTCH_STREFStatus reference6ITEM_NOItem Count Numbernvarchar50
TOPGoods Issue Process
14/SPE/CRMD_PO_MAPCorrelation Table Third Party PO <-> CRM Sales Order7ITEM_NOItemnvarchar100
15/SPE/CRMD_PR_MAPMapping Table Purchase Requisition <-> CRM Sales Order7ITEM_NOItemnvarchar100
TOPJapan
16T7JPCP_DTFLSTRDefine Data File Structure6ITEM_NOItem Numbernvarchar30
TOPLogistics - General
17CRMD_CO_ITEMCO Account Assignment of Sales Items3ITEM_NOItemnvarchar100
18CRM_SRV_LOG_SCCRM Service: Logistics Scenarios8ITEM_NOCharacter Field Length = 10nvarchar100
TOPNetwork Operations
19GHO_PP_PTABLE_ITItem Table for Results of GHO Planning Table3ITEM_NOItem Number for OPM Planning Table Resultsnvarchar60
20GHO_PP_PTABLE_IVItem-Validity Table for GHO Planning Table3ITEM_NOItem Number for OPM Planning Table Resultsnvarchar60
21GHO_PP_PTABLE_LNSchedule Lines Table for Results of GHO Planning Table4ITEM_NOItem Number for OPM Planning Table Resultsnvarchar60
TOPOwnership
22OIUOW_DTDDOI Transfer Change Detail4ITEM_NORequest item numbernvarchar60
23OIUOW_RTDRD DOI Transferee Detail19ITEM_NORequest item numbernvarchar60
24OIUOW_RTD_WKRD DOI Transferee Detail Worktable19ITEM_NORequest item numbernvarchar60
TOPPayment Item
25BKKPAYMEX_ITEFT Management: Items in Outgoing Payment Transactions4ITEM_NOSequential Number (5-Figure)nvarchar50
26BKKPAYMEX_PYNOTPayment Notes in Outgoing Payment Transactions4ITEM_NOSequential Number (5-Figure)nvarchar50
27BKKPAYMIN_ITTable of Imported Items5ITEM_NOSequential Number (5-Figure)nvarchar50
28BKKPAYMIN_PYNOTBCA: Table of Payment Notes5ITEM_NOSequential Number (5-Figure)nvarchar50
TOPProduction and Revenue Accounting
29OIU_PM_XREFCross reference for PRA / PM entities5ITEM_NOSequence numbernvarchar30
TOPReusable Components of Business Suite Foundation
30/BOBF/DM_SORD_ITSales Order Item5ITEM_NOItem Nonvarchar30
31/BOFU/DDMOSORDITSales Order Item5ITEM_NOItem Nonvarchar30
32/BOFU/DEM_D_ITEMDelivery Document Item5ITEM_NOItem Nonvarchar30
33/BOFU/DTSTSORDITSales Order Item4ITEM_NOItem Nonvarchar30
TOPSAP NetWeaver Mobile - Use subcomponents
34MEREP_TORDERITEMSales Order item3ITEM_NOItem numbernvarchar100
35MEREP_TORDERITMSales Order item3ITEM_NOItem numbernvarchar100