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  | PNWTYV
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 :: Warranty Claim Processing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PNWTYV452Warranty Claim Version (PVS Node)Warranty Claim Processing
SQL:  selectupdate insert create

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

SELECT MANDT, PNGUID, PNCNT, PNTXCNT, VERSN, KATEG, V_REJCD, V_PARNR, V_PARVW, REFKT, REFNR, AKTIV, FKDAT, KNUMV, V_CRNCY, PRSDT, KURSK, V_LOG_HANDLE, LOG_HDL_DFCT, PREV_VERSION, VKORG, VTWEG, SPART, V_MDOCM, REVERSAL, ENDVN, EKORG, SDVBELN, SDPOSNR, REFDT_VERS, V_MGANR, V_GWLDT, RESULT_OUT_MWTYV, RESULT_IN_MWTYV, V_DUMMY, PRICING_OK, NEW_VERSION, COMPSEND, TIMSTMP, CREADAT, CREABY, CHNGDAT, CHNGBY, HEADER_GUID, PNTEXT FROM PNWTYV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PNGUIDInternal Number of iPPE Nodevarbinary160RAWNoWTY_PNGUID
3PNCNTInternal Counternvarchar80NUMC(N'00000000')NoWTY_COUNT Allow NULL? 
4PNTXCNTCounter for Text Tablesnvarchar50NUMC(N'00000')YesWTY_TXTCOUNT Allow NULL? 
5VERSNVersion Numbernvarchar40NUMC(N'0000')YesWTY_VERSN Allow NULL? 
6KATEGCategorynvarchar20CHAR(N' ')YesWTY_KATEG Allow NULL? 
7V_REJCDDecision Codenvarchar80CHAR(N' ')YesWTY_REJCD Allow NULL? 
8V_PARNRPartnernvarchar100CHAR(N' ')YesWTY_PARNR Allow NULL? 
9V_PARVWPartner Rolenvarchar20CHAR(N' ')Yes*WTY_PARVW Allow NULL? 
10REFKTReference Typenvarchar20CHAR(N' ')YesWTY_REFKT Allow NULL? 
11REFNRReference Numbernvarchar350CHAR(N' ')YesWTY_REFNR Allow NULL? 
12AKTIVActive Versionchar10CHAR(N' ')YesWTY_AKTIV Allow NULL? 
13FKDATBilling Document Datenvarchar80DATS(N'00000000')YesWTY_FKDAT Allow NULL? 
14KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
15V_CRNCYVersion Currencynvarchar50CUKY(N' ')Yes*WTY_CRNCY Allow NULL? 
16PRSDTDate for Pricing and Exchange Ratenvarchar80DATS(N'00000000')YesWTY_PRSDT Allow NULL? 
17KURSKExchange Rate for Pricingdecimal95DEC((0))YesWTY_KURSK
18V_LOG_HANDLEApplication Log: Log Handlenvarchar220CHAR(N' ')YesBALLOGHNDL Allow NULL? 
19LOG_HDL_DFCTApplication Log: Log Handlenvarchar220CHAR(N' ')YesBALLOGHNDL Allow NULL? 
20PREV_VERSIONNumber of Preceding Versionnvarchar40NUMC(N'0000')YesWTY_PREV_VERSN Allow NULL? 
21VKORGSales Organizationnvarchar40CHAR(N' ')YesWTY_VKORG Allow NULL? 
22VTWEGDistribution Channelnvarchar20CHAR(N' ')YesWTY_VTWEG Allow NULL? 
23SPARTDivisionnvarchar20CHAR(N' ')YesWTY_SPART Allow NULL? 
24V_MDOCMMeasurement Document Numbernvarchar200CHAR(N' ')YesWTY_MDOCM Allow NULL? 
25REVERSALVersion for Reverse Posting in Accountingchar10CHAR(N' ')YesWTY_REVERSAL Allow NULL? 
26ENDVNNo Further Incoming Versions Are Expectedchar10CHAR(N' ')YesWTY_ENDVERSION Allow NULL? 
27EKORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*WTY_EKORG Allow NULL? 
28SDVBELNContract Document Numbernvarchar100CHAR(N' ')Yes*WTY_SDVBELN Allow NULL? 
29SDPOSNRContract Item Numbernvarchar60NUMC(N'000000')YesVBUPWTY_SDPOSNR Allow NULL? 
30REFDT_VERSReference Date of Versionnvarchar80DATS(N'00000000')YesWTY_REFDT_VERS Allow NULL? 
31V_MGANRMaster Warrantynvarchar200CHAR(N' ')Yes*WTY_MGANR Allow NULL? 
32V_GWLDTStart Date of Assigned Warrantynvarchar80DATS(N'00000000')YesWTY_GWLDT Allow NULL? 
33RESULT_OUT_MWTYVResult of Object Warranty Check (Customer)nvarchar20NUMC(N'00')YesWTY_CHECK_RESULT Allow NULL? 
34RESULT_IN_MWTYVResult of Warranty Check for Object (Vendor)nvarchar20NUMC(N'00')YesWTY_CHECK_RESULT2 Allow NULL? 
35V_DUMMYDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
36PRICING_OKPricing Statuschar10CHAR(N' ')YesWTY_STATUS_PRICING Allow NULL? 
37NEW_VERSIONNew Statuschar10CHAR(N' ')YesWTY_STATUS_NEW Allow NULL? 
38COMPSENDRelease Version for Shipping to Partnerchar10CHAR(N' ')YesWTY_STATUS_COMPLETE Allow NULL? 
39TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)decimal217DEC((0))YesWTY_TIMSTMP
40CREADATDate of Applicationnvarchar80DATS(N'00000000')YesWTY_CREADAT Allow NULL? 
41CREABYUser Who Created Recordnvarchar120CHAR(N' ')YesWTY_CREABY Allow NULL? 
42CHNGDATDate of Last Changenvarchar80DATS(N'00000000')YesWTY_CHNGDAT Allow NULL? 
43CHNGBYName of Person Responsible Who Changed Objectnvarchar120CHAR(N' ')YesWTY_CHNGBY Allow NULL? 
44HEADER_GUIDInternal Number of iPPE Nodevarbinary160RAWYesWTY_PNGUID
45PNTEXTText for Version of Warranty Claimnvarchar600CHAR(N' ')YesWTY_PNVTX Allow NULL? 
NamePrimaryUniqueTypeColumns
PNWTYV~0YesYesCLUSTEREDPNCNT, PNGUID, MANDT
PNWTYV~I01NoNoNONCLUSTEREDHEADER_GUID

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