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
1ERP EHP76.0/GBT/O_DLVY_ITM372Delivery Item for Tracking
SQL:  selectupdate insert create

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

SELECT MANDT, OBJ_GUID, DLVYNR, CRYEAR, DLVYIT, LOGSYS, DELIV_ITEM_CAT, PLANT, STGE_LOC, MATNR, BATNR, MOVE_TYPE, TRANS_GRP, LOADINGGRP, WHSENUMBER, STGE_TYPE, STGE_BIN, BUS_AREA, SALES_OFF, SALES_GRP, DISTR_CHAN, DIVISION, SALNR, SALIT, REC_POINT, MVT_IND, MOVE_MATL, MOVE_PLANT, MOVE_STLOC, MOVE_BATCH, DLV_QTY, SALES_UNIT, FLAG_TRANSFER, HU_COUNT_S, HU_LIST_COMPACT_S, HU_COUNT_D, HU_LIST_COMPACT_D FROM /GBT/O_DLVY_ITM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2OBJ_GUIDObject GUIDvarbinary160RAWNo/GBT/OBJ_GUID
3DLVYNRDeliverynvarchar100CHAR(N' ')Yes*/GBT/DLVYNR Allow NULL? 
4CRYEARYear of Delivery Creationnvarchar40NUMC(N'0000')Yes/GBT/DLVYYR Allow NULL? 
5DLVYITDelivery Itemnvarchar60NUMC(N'000000')Yes*/GBT/DLVYIT Allow NULL? 
6LOGSYSLogical Systemnvarchar100CHAR(N' ')Yes*/GBT/LOGSYS Allow NULL? 
7DELIV_ITEM_CATDelivery Item Categorynvarchar40CHAR(N' ')Yes*/GBT/DLVY_PSTYV Allow NULL? 
8PLANTPlantnvarchar100CHAR(N' ')Yes/GBT/PLANT Allow NULL? 
9STGE_LOCStorage Locationnvarchar40CHAR(N' ')Yes*/GBT/STGE_LOC Allow NULL? 
10MATNRMaterial Numbernvarchar400CHAR(N' ')Yes/GBT/MATNR Allow NULL? 
11BATNRBatch Numbernvarchar200CHAR(N' ')Yes/GBT/BATNR Allow NULL? 
12MOVE_TYPEMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*/GBT/MVMNT_TYPE Allow NULL? 
13TRANS_GRPTransportation Groupnvarchar40CHAR(N' ')Yes/GBT/DLVY_TRAGR Allow NULL? 
14LOADINGGRPLoading Groupnvarchar40CHAR(N' ')Yes/GBT/DLVY_LADGR Allow NULL? 
15WHSENUMBERWarehousenvarchar100CHAR(N' ')Yes/GBT/WHOUSE Allow NULL? 
16STGE_TYPEStorage Typenvarchar30CHAR(N' ')Yes/GBT/DLVY_LGTYP Allow NULL? 
17STGE_BINStorage Binnvarchar100CHAR(N' ')Yes/GBT/DLVY_LGPLA Allow NULL? 
18BUS_AREABusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
19SALES_OFFSales Officenvarchar40CHAR(N' ')Yes*VKBUR Allow NULL? 
20SALES_GRPSales Groupnvarchar30CHAR(N' ')Yes*VKGRP Allow NULL? 
21DISTR_CHANDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
22DIVISIONDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
23SALNRSales Order Numbernvarchar100CHAR(N' ')Yes*/GBT/SALONR Allow NULL? 
24SALITItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
25REC_POINTReceiving Pointnvarchar250CHAR(N' ')Yes/GBT/DLVY_EMPST Allow NULL? 
26MVT_INDMovement Indicatorchar10CHAR(N' ')YesKZBEW Allow NULL? 
27MOVE_MATLMaterial Numbernvarchar400CHAR(N' ')Yes/GBT/MATNR Allow NULL? 
28MOVE_PLANTReceiving Plant for Deliveriesnvarchar100CHAR(N' ')Yes/GBT/RCV_PLANT Allow NULL? 
29MOVE_STLOCReceiving/Issuing Storage Locationnvarchar40CHAR(N' ')Yes*UMLGO Allow NULL? 
30MOVE_BATCHBatch Numbernvarchar200CHAR(N' ')Yes/GBT/BATNR Allow NULL? 
31DLV_QTYActual Quantity Delivered in Sales Unitsdecimal133QUAN((0))Yes/GBT/DLVY_LFIMG
32SALES_UNITSales unitnvarchar30UNIT(N' ')Yes*VRKME Allow NULL? 
33FLAG_TRANSFERStock Transfer/Transfer Postingchar10CHAR(N' ')Yes/GBT/DLVY_KZUML Allow NULL? 
34HU_COUNT_SNumber of HUs in Listnvarchar40NUMC(N'0000')Yes/GBT/HU_COUNT Allow NULL? 
35HU_LIST_COMPACT_SHU Listnvarchar400CHAR(N' ')Yes/GBT/HU_LIST_COMPACT Allow NULL? 
36HU_COUNT_DNumber of HUs in Destination Listnvarchar40NUMC(N'0000')Yes/GBT/HU_COUNT_D Allow NULL? 
37HU_LIST_COMPACT_DHU Destination Listnvarchar400CHAR(N' ')Yes/GBT/HU_LIST_COMPACT_D Allow NULL? 
NamePrimaryUniqueTypeColumns
/GBT/O_DLVY_ITM~0YesYesCLUSTEREDOBJ_GUID, MANDT
/GBT/O_DLVY_ITM~KENoYesNONCLUSTEREDDLVYIT, CRYEAR, DLVYNR, LOGSYS, MANDT