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

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
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JDTPVA603IS-M/SD: EditionsPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, DRERZ, PVA, PVAART, POVERKZ, ERSCHWWO, POTAEULAND, POTAEULUFT, POTAWELAND, POTAWELUFT, BEZEI10, LBEZEIINT, LBEZEIEXT, PERREGEL, FKALENDID, XNUMPVA, SFORMATBR, MEINHBREIT, SFORMATHOE, MEINHHOE, SPAPIERGEW, MEINHPAGEW, STDBLTTGEW, MEINHSBLGW, SPAGEWMANT, MEINHPAGEM, STDBLGEWMA, MEINHSBGMA, ISPCNROB, ISPCNRTO, ISSNNR, VDZVERTRKZ, IVWNR, AUFMELDART, GNGRP, PVASTAGRP, BERGRP1, BERGRP2, BZBKDAU, BASJAHR, MANZBEIL, VERSVLEVS, REM_NACHLF, RK_AUFNR, RK_POSNR, CO_AUFNR, LOEVM, LOEKZ, KOSTL, KOSTL_R2, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, KZEIGFRE, GPNR, ISMTMCPRODTYPE, BOTENART FROM JDTPVA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DRERZPublicationnvarchar80CHAR(N' ')NoJDTDRERDRERZ Allow NULL? 
3PVAEditionnvarchar80CHAR(N' ')NoPVA Allow NULL? 
4PVAARTContent Categorynvarchar20CHAR(N' ')YesTJD13ISMCONTTYPE Allow NULL? 
5POVERKZIS-M: Postal distribution indicatornvarchar80CHAR(N' ')YesPOVERKZ Allow NULL? 
6ERSCHWWOIndicator for Publication Frequency Relative to Weekchar10CHAR(N' ')YesERSCHWWO Allow NULL? 
7POTAEULANDPostal charges for Europe/land (reduced charge packages)char10CHAR(N' ')YesPOTAEULAND Allow NULL? 
8POTAEULUFTPostal charges for Europe/airmail (reduced charge packages)char10CHAR(N' ')YesPOTAEULUFT Allow NULL? 
9POTAWELANDPostal charges for world/land (reduced charge packages)char10CHAR(N' ')YesPOTAWELAND Allow NULL? 
10POTAWELUFTPostal charge for airmail/world (for reduced charge package)char10CHAR(N' ')YesPOTAWELUFT Allow NULL? 
11BEZEI10Short text for editionnvarchar100CHAR(N' ')YesKBEZPVA Allow NULL? 
12LBEZEIINTInternal long textnvarchar500CHAR(N' ')YesLBEZEIINT Allow NULL? 
13LBEZEIEXTExternal long textnvarchar500CHAR(N' ')YesLBEZEIEXT Allow NULL? 
14PERREGELFrequency rulenvarchar50CHAR(N' ')YesTJD03PERREGEL Allow NULL? 
15FKALENDIDFactory Calendar for Productionnvarchar20CHAR(N' ')YesTFACDFKALENDID Allow NULL? 
16XNUMPVAAutomatic numbering for individual editionschar10CHAR(N' ')NoXNUMPVA Allow NULL? 
17SFORMATBRStandard page widthdecimal93QUAN((0))YesSFORMATBR
18MEINHBREITIS-M: Unit of measure for page widthnvarchar30UNIT(N' ')YesT006MEINHBREIT Allow NULL? 
19SFORMATHOEStandard page lengthdecimal93QUAN((0))YesSFORMATHOE
20MEINHHOEIS-M: Unit of measurement for page lengthnvarchar30UNIT(N' ')YesT006MEINHHOE Allow NULL? 
21SPAPIERGEWStandard weight of paper (inside pages)decimal93QUAN((0))YesSPAPIERGEW
22MEINHPAGEWUnit of measure for weight of papernvarchar30UNIT(N' ')YesT006MEINHPAGEW Allow NULL? 
23STDBLTTGEWStandard page weight (inside)decimal93QUAN((0))YesSTDBLTTGEW
24MEINHSBLGWUnit of weight for page weightnvarchar30UNIT(N' ')YesT006MEINHBLGEW Allow NULL? 
25SPAGEWMANTStandard weight of paper for coverdecimal93QUAN((0))YesSPAGEWMANT
26MEINHPAGEMUnit of measure for weight of papernvarchar30UNIT(N' ')YesT006MEINHPAGEW Allow NULL? 
27STDBLGEWMAStandard page weight (cover)decimal93QUAN((0))YesSTDBLGEWMA
28MEINHSBGMAUnit of weight for page weightnvarchar30UNIT(N' ')YesT006MEINHBLGEW Allow NULL? 
29ISPCNROBISPC Number of Objectnvarchar60NUMC(N'000000')YesISPCNROB Allow NULL? 
30ISPCNRTOISPC Number of Sub-Objectnvarchar20NUMC(N'00')YesISPCNRTO Allow NULL? 
31ISSNNRISSN Number of Editionnvarchar90CHAR(N' ')YesISSNNR Allow NULL? 
32VDZVERTRKZIS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)nvarchar50CHAR(N' ')YesTJKWEJWBZVKENNZ Allow NULL? 
33IVWNRCirculation Audit Report ID for Editionnvarchar100NUMC(N'0000000000')YesIVWNR Allow NULL? 
34AUFMELDARTAudit Report Type for Editionnvarchar20CHAR(N' ')YesTJD57AUFMELDART Allow NULL? 
35GNGRPEdition generation groupingnvarchar60CHAR(N' ')YesTJD37PVAGNGRP Allow NULL? 
36PVASTAGRPStatistics grouping for editionchar10CHAR(N' ')YesTJD51PVASTAGRP Allow NULL? 
37BERGRP1Report group 1 - editionnvarchar100CHAR(N' ')YesTJD31PVABERGRP1 Allow NULL? 
38BERGRP2Report group 2 - editionnvarchar100CHAR(N' ')YesTJD33PVABERGRP2 Allow NULL? 
39BZBKDAUAvailability Period for Edition in Daysnvarchar50NUMC(N'00000')YesBEZBKDAU Allow NULL? 
40BASJAHRBase Year for Determining Year Numbernvarchar40NUMC(N'0000')YesPVABJAHR Allow NULL? 
41MANZBEILGuideline: Maximum number of insertsnvarchar30NUMC(N'000')YesMAXBEILAGE Allow NULL? 
42VERSVLEVSShipping lead time in days for first shipmentdecimal30DEC((0))YesVERSVLEVS
43REM_NACHLFReturn Follow-Up Time in Days for Alternative Return Startdecimal30DEC((0))NoREM_NACHLF
44RK_AUFNROrder Number of RK Order for Account Assignmentnvarchar80CHAR(N' ')YesJ_RK_AUFNR Allow NULL? 
45RK_POSNRItem Number of RK Order for Account Assignmentnvarchar20NUMC(N'00')YesJ_RK_POSNR Allow NULL? 
46CO_AUFNROrder number of internal CO order for account assignmentnvarchar120CHAR(N' ')YesAUFKJ_CO_AUFNR Allow NULL? 
47LOEVMDeletion Flag for Master Data in Media Sales & Distributionchar10CHAR(N' ')YesLOEVM_ISP Allow NULL? 
48LOEKZDeletion Indicator for Master Data in Media Sales & Dist.char10CHAR(N' ')YesLOEKZ_ISP Allow NULL? 
49KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
50KOSTL_R2Cost center in R/2nvarchar80CHAR(N' ')YesKOSTL_R2 Allow NULL? 
51ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
52ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
53ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
54AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
55AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
56AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
57KZEIGFREExternal Delivery Orderchar10CHAR(N' ')NoXPVAFRE Allow NULL? 
58GPNRIS-M: Business Partner Publishernvarchar100CHAR(N' ')No*GPNRVERLAG Allow NULL? 
59ISMTMCPRODTYPEMarket Coverage Product Typechar10CHAR(N' ')NoISMTMCPRODTYP Allow NULL? 
60BOTENARTIS-M: Courier type for Swiss postal service PTT (CH)char10CHAR(N' ')YesJ_1SBOTART Allow NULL? 
NamePrimaryUniqueTypeColumns
JDTPVA~0YesYesCLUSTEREDPVA, DRERZ, MANDT
JDTPVA~INoNoNONCLUSTEREDIVWNR
JDTPVA~PNoNoNONCLUSTEREDPOVERKZ

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