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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
Logistics - General :: SAP Retail Store
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TWIC0100451General Settings for SAP Retail Store Goods ReceiptSAP Retail Store
SQL:  selectupdate insert create

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

SELECT MANDT, CSTOBJ, CSTSCM, REF_ID, ART_ID, BWART_ERF, BWART_UML, BWART_STO, BWART_RUE, BWART_RUE_O, BWART_EINL, BWART_AUS, BWART_ZUS, BWART_ZUS_KZ, BWART_KOS_LIE, BWART_SPERR, VELE_KZ, REST_KZ, MHDKZ, DT_POS, DT_VERS, GMCODE, SRS_PDC_PROC, SRS_PDC_GR_DB, SRS_DAYS_BEFORE, SRS_DAYS_AFTER, SRS_PDC_R_DOC, SRS_PDC_R_VP, SRS_PDC_R_MAT, SRS_PDC_R_CUST, MOVE_TYPE_WR_CC, ENTRY_VIA_SH, ENTER_INV_ALLWD, REQ_SOURCE, PO_SRC_DAYS_BACK, DL_SRC_DAYS_BACK, DL_SRC_LINES_MAX, HU_SRC_DAYS_BACK, HU_SRC_LINES_MAX, GM_SRC_DAYS_BACK, GM_SRC_LINES_MAX, DOC_TYPE_ACC, ACCTASSCAT, PUR_GROUP_ACC, GM_DLG_MAX_LINES FROM TWIC0100
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2CSTOBJRetail IACs: Customizing objectnvarchar40 Allow NULL? 
3CSTSCMRetail IACs: Customizing or Grouping Schemanvarchar40 Allow NULL? 
4REF_IDSAP Retail Store: Numeric Key for Reference Documentnvarchar40 Allow NULL? 
5ART_IDSAP Retail Store: Material ID Typenvarchar40 Allow NULL? 
6BWART_ERFSAP Retail Store: GR Movement Type for Reference Documentnvarchar30 Allow NULL? 
7BWART_UMLSAP Retail Store: Movement Type GR for Stock Transfer Del.nvarchar30 Allow NULL? 
8BWART_STOSAP Retail Store: Movement Type Reverse GR for Ref. Documentnvarchar30 Allow NULL? 
9BWART_RUESAP Retail Store: Mvmnt Type GR Return Delivery f. Ref. Doc.nvarchar30 Allow NULL? 
10BWART_RUE_OSAP Retail Store: Mvmnt Type Return Delivery w/o Ref. Doc.nvarchar30 Allow NULL? 
11BWART_EINLSAP Retail Store: Mvmnt Type f. Putaway from Stock Transfersnvarchar30 Allow NULL? 
12BWART_AUSMovement Type of Mat. Doc. That is Allowed (303)nvarchar30 Allow NULL? 
13BWART_ZUSSAP Retail Store: Movement Type for Posting Additional Itemsnvarchar30 Allow NULL? 
14BWART_ZUS_KZPermissibility of Additional Items Indicatorchar10 Allow NULL? 
15BWART_KOS_LIEMovement Type for Free-of-Charge Delivery (StoreEngine Only)nvarchar30 Allow NULL? 
16BWART_SPERRMovementType for Release in Blocked Stock (StoreEngine Only)nvarchar30 Allow NULL? 
17VELE_KZSAP Retail Store: Display Ship. Units in Delivery Indicatorchar10 Allow NULL? 
18REST_KZSAP Retail Store GR: Remaining Quantity Displayed Indicatorchar10 Allow NULL? 
19MHDKZCheck Best Before Date/Production Datechar10 Allow NULL? 
20DT_POSIndicator for item details display SAP Retail Store GRchar10 Allow NULL? 
21DT_VERSInd. for changing item qty for hand. unit SAP Ret. Store GRchar10 Allow NULL? 
22GMCODEAssign code to transaction for BAPI goods movementnvarchar20 Allow NULL? 
23SRS_PDC_PROCRetail Store MDE Scenariochar10 Allow NULL? 
24SRS_PDC_GR_DBSRS MDE Goods Receipt Via Databasechar10 Allow NULL? 
25SRS_DAYS_BEFORESRS MDE Goods Receipt, Days Before Formatting Datenvarchar20 Allow NULL? 
26SRS_DAYS_AFTERSRS MDE Goods Receipt, Days After Formatting Datenvarchar20 Allow NULL? 
27SRS_PDC_R_DOCPDC - Formatting Using SRS (Reference Documents)char10 Allow NULL? 
28SRS_PDC_R_VPMDE - Report on Formatting Using SRS (Vendors/Stores)char10 Allow NULL? 
29SRS_PDC_R_MATMDE - Report on Formatting Using SRS (Article)char10 Allow NULL? 
30SRS_PDC_R_CUSTMDE - Report on Formatting Using SRS (Customizing)char10 Allow NULL? 
31MOVE_TYPE_WR_CCSAP Retail Store: GR Additional Items Cross Company (0101)nvarchar30 Allow NULL? 
32ENTRY_VIA_SHSAP Retail Store: Use Search Helps on GR Entry Screenchar10 Allow NULL? 
33ENTER_INV_ALLWDSAP Retail Store: Entry of Incoming Invoice Allowed After GRchar10 Allow NULL? 
34REQ_SOURCEControl of Source of Quantity Proposalschar10 Allow NULL? 
35PO_SRC_DAYS_BACKSAP Retail Store: Past Period for Purchase Order Searchnvarchar40 Allow NULL? 
36DL_SRC_DAYS_BACKSAP Retail Store: Past Period in Deliveries Searchnvarchar40 Allow NULL? 
37DL_SRC_LINES_MAXSAP Retail Store: Maximum No. of Hits in Deliveries Searchnvarchar40 Allow NULL? 
38HU_SRC_DAYS_BACKSAP Retail Store: Past Period in Search for Shipping Unitsnvarchar40 Allow NULL? 
39HU_SRC_LINES_MAXSAP Retail Store: Max. No. of Hits in Shipping Units Searchnvarchar40 Allow NULL? 
40GM_SRC_DAYS_BACKSAP Retail Store: Past Period in Material Documents Searchnvarchar40 Allow NULL? 
41GM_SRC_LINES_MAXSAP Retail Store: Maximum No. Hits in Material Doc. Searchnvarchar40 Allow NULL? 
42DOC_TYPE_ACCSAP Retail Store GM: Order Type for Items w. Acct Assignmentnvarchar40 Allow NULL? 
43ACCTASSCATSAP Retail Store: Acct Assig.Cat. for Items with Acct Assig.char10 Allow NULL? 
44PUR_GROUP_ACCSAP Retail Store GM: Purchasing Group for Items w. Acct Ass.nvarchar30 Allow NULL? 
45GM_DLG_MAX_LINESSAP Retail Store: Maximum Number of Lines in Entry Dialognvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
TWIC0100~0YesYesCLUSTEREDMANDT, CSTOBJ, CSTSCM