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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Mill Products Industry Solution :: Sales and Distribution SD enhancements
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/SAPMP/SD_LEIHG301Returnable Packaging SettlementSales and Distribution SD enhancements
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, KUNNR, MATNR, WERKS, CHARG, /SAPMP/POSTNO_O, /SAPMP/BJAHR_O, /SAPMP/POSTIT_O, /SAPMP/WADAT_O, /SAPMP/VBELN_O, /SAPMP/POSNR_O, /SAPMP/POSTNO_I, /SAPMP/BJAHR_I, /SAPMP/POSTIT_I, /SAPMP/WADAT_I, /SAPMP/VBELN_I, /SAPMP/POSNR_I, RL_ACCTNO, VKORG, VTWEG, SPART, KDGRP, VKGRP, VKBUR, /SAPMP/LEIHGE, /SAPMP/LEIHW, /SAPMP/ABRDAT, /SAPMP/ABRART, /SAPMP/AUSBUCH, /SAPMP/STAT FROM /SAPMP/SD_LEIHG
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2KUNNRCustomer Numbernvarchar100 Allow NULL? 
3MATNRMaterial Numbernvarchar180 Allow NULL? 
4WERKSPlantnvarchar40 Allow NULL? 
5CHARGBatch Numbernvarchar100 Allow NULL? 
6/SAPMP/POSTNO_ONumber of Outbound Delivery Returnable Packaging A/c Postingnvarchar120 Allow NULL? 
7/SAPMP/BJAHR_OStored to Year - Outbound Deliverynvarchar40 Allow NULL? 
8/SAPMP/POSTIT_OItem Number of the Outbound Delivery Account Postingnvarchar40 Allow NULL? 
9/SAPMP/WADAT_ODate of Outbound Deliverynvarchar80 Allow NULL? 
10/SAPMP/VBELN_OOutbound Deliverynvarchar100 Allow NULL? 
11/SAPMP/POSNR_OOutbound Delivery Itemnvarchar60 Allow NULL? 
12/SAPMP/POSTNO_INumber of Return Delivery Returnable Packaging A/C Postingnvarchar120 Allow NULL? 
13/SAPMP/BJAHR_IStored to Year - Return Deliverynvarchar40 Allow NULL? 
14/SAPMP/POSTIT_IItem Number for the Return Delivery Account Postingnvarchar40 Allow NULL? 
15/SAPMP/WADAT_IDate of Return Deliverynvarchar80 Allow NULL? 
16/SAPMP/VBELN_IReturn Deliverynvarchar100 Allow NULL? 
17/SAPMP/POSNR_IReturn Delivery Itemnvarchar60 Allow NULL? 
18RL_ACCTNOReturnable packaging accountnvarchar120 Allow NULL? 
19VKORGSales Organizationnvarchar40 Allow NULL? 
20VTWEGDistribution Channelnvarchar20 Allow NULL? 
21SPARTDivisionnvarchar20 Allow NULL? 
22KDGRPCustomer groupnvarchar20 Allow NULL? 
23VKGRPSales Groupnvarchar30 Allow NULL? 
24VKBURSales Officenvarchar40 Allow NULL? 
25/SAPMP/LEIHGETotal of the Settled Returnable Packaging Feesdecimal112
26/SAPMP/LEIHWCurrency of Returnable Packaging Feesnvarchar50 Allow NULL? 
27/SAPMP/ABRDATDate of Last Settlementnvarchar80 Allow NULL? 
28/SAPMP/ABRARTSettlement Type (Monthly/Daily)char10 Allow NULL? 
29/SAPMP/AUSBUCHIssue Posting per Deliverychar10 Allow NULL? 
30/SAPMP/STATMatching status for posting record or statement transactionchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/SAPMP/SD_LEIHG~0YesYesCLUSTERED/SAPMP/POSTIT_O, /SAPMP/BJAHR_O, /SAPMP/POSTNO_O, CHARG, WERKS, MATNR, KUNNR, MANDT