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

Home | ERP 6.0  | WRS1
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
Logistics - General :: Logistics Basic Data :: Assortment :: Assortment Maintenance
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WRS1255AssortmentAssortment Maintenance
SQL:  selectupdate insert create

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

SELECT MANDT, ASORT, STATU, KZLIK, NLMATFB, VKORG, VTWEG, LSTFL, DATAB, DATBI, KOPRO, LAYPR, SOTYP, LAYVR, POSDS, EXCLU, CATEGORY, LAY_LIST_UTIME, HIER_ID, ASSORTYP, ASSORDIMVAL1, ASSORDIMVAL2, ASSORDIMVAL3, LAYGR, AEDAT FROM WRS1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ASORTAssortmentnvarchar100CHAR(N' ')NoASORT Allow NULL? 
3STATUStatus of assortmentchar10CHAR(N' ')YesW_S_STATUS Allow NULL? 
4KZLIKListing Conditions for Assortmentschar10CHAR(N' ')YesKZLIK Allow NULL? 
5NLMATFBID: Carry out subsequent listingchar10CHAR(N' ')YesNLMATFB Allow NULL? 
6VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
7VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
8LSTFLListing procedurenvarchar20CHAR(N' ')YesTWLVLSTVF Allow NULL? 
9DATABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
10DATBIValid To Datenvarchar80DATS(N'00000000')YesDATBI Allow NULL? 
11KOPROAll material groups can be listed - even if there are errorschar10CHAR(N' ')YesW_S_KOPRO Allow NULL? 
12LAYPRListing check: only use layout defined for the assortmentchar10CHAR(N' ')YesW_S_LAYPR Allow NULL? 
13SOTYPAssortment Categorychar10CHAR(N' ')YesW_SOTYP Allow NULL? 
14LAYVRLayoutnvarchar100CHAR(N' ')YesTWGVLAYVAR Allow NULL? 
15POSDSNo data should be sent to assortment user POS systemschar10CHAR(N' ')YesW_POS_DS Allow NULL? 
16EXCLUExistence of Exclusion Listing Conditionschar10CHAR(N' ')YesW_S_EXCLU Allow NULL? 
17CATEGORYCategory Nodesnvarchar180CHAR(N' ')YesCAT_NODE Allow NULL? 
18LAY_LIST_UTIMETime the layout module was last processednvarchar140CHAR(N' ')YesLAYOUT_LISTING_UPDTTIME Allow NULL? 
19HIER_IDHierarchynvarchar20CHAR(N' ')YesWRF_MATGRP_HIERWRF_HIER_CNT Allow NULL? 
20ASSORTYPAssortment Typenvarchar40CHAR(N' ')YesWRFST_TYPWRFDE_ASSORTYP Allow NULL? 
21ASSORDIMVAL1Value in an Assortment Dimensionnvarchar40CHAR(N' ')YesWRFV_TYPDIMVAL1WRFDE_ASSORDIMVAL Allow NULL? 
22ASSORDIMVAL2Value in an Assortment Dimensionnvarchar40CHAR(N' ')YesWRFV_TYPDIMVAL2WRFDE_ASSORDIMVAL Allow NULL? 
23ASSORDIMVAL3Value in an Assortment Dimensionnvarchar40CHAR(N' ')YesWRFV_TYPDIMVAL3WRFDE_ASSORDIMVAL Allow NULL? 
24LAYGRLayout Modulenvarchar100CHAR(N' ')YesTWMLLAYGR Allow NULL? 
25AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
WRS1~0YesYesCLUSTEREDMANDT, ASORT
WRS1~AHINoNoNONCLUSTEREDMANDT, HIER_ID, CATEGORY, SOTYP
WRS1~LBSNoNoNONCLUSTEREDMANDT, LAYGR
WRS1~TYPNoNoNONCLUSTEREDMANDT, SOTYP, VKORG, VTWEG
WRS1~VTLNoNoNONCLUSTEREDMANDT, VKORG, VTWEG

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy