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  | JDTVAUSGB
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JDTVAUSGB764IS-M/SD: IssuesPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, VAUSGB, DRERZ, PVA, ERSCHDAT, ERSTVERDAT, EPERDATUM, JAHRGANG, NRIMJAHR, HEFTNUMMER, EANVA, VAVARTYPPL, VAVARTYPTA, ANZSEITEN, GESAMTAUFL, BISBEZDAT, MAXBEILAGE, ANZVORDR, XEDATKORR, XVAVTYKORR, XSONDAUSG, XINDIVANG, XVERGRIFF, XOHNEIVW, XGENMASCH, XPLZUS, FORMATBR, MEINHBREIT, FORMATHOE, MEINHHOE, VAGEWICHT, MEINHGEW, VAGEWPLAN, MEINHGEWP, XPGMANUELL, VAGEWIST, MEINHGEWI, STAERKE, MEINHSTRK, PAPIERGEW, MEINHPAGEW, PAGEWMANTL, MEINHPAGMT, BLATTGEW, MEINHBLGEW, BLATTGWMA, MEINHBGWMA, XMUSTERL, MUSTERLDAT, RK_AUFNR, RK_POSNR, CO_AUFNR, LOEVM, LOEKZ, ERFUSER, ERFDATE, ERFTIME, ERFPROG, AENUSER, AENDATE, AENTIME, AENPROG, MATNR, XANZSEITAE, NRZUSATZ, JGZUSATZ, XHRKNFTPAM, REMIBEGINN, SI_NUMMER, SI_BEARB, SI_TYP, SI_INSERNT, SI_STICHW, SI_ENTSPFL, SI_VERBWER, SI_KENNZIF FROM JDTVAUSGB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VAUSGBIssuenvarchar100CHAR(N' ')NoVAUSGB Allow NULL? 
3DRERZPublicationnvarchar80CHAR(N' ')YesJDTDRERDRERZ Allow NULL? 
4PVAEditionnvarchar80CHAR(N' ')YesJDTPVAPVA Allow NULL? 
5ERSCHDATPublication Datenvarchar80DATS(N'00000000')YesERSCHDAT Allow NULL? 
6ERSTVERDATIS-M: First Shipping Datenvarchar80DATS(N'00000000')YesERSTVERDAT Allow NULL? 
7EPERDATUMIS-M: Starting Date of Individual Periodnvarchar80DATS(N'00000000')YesEPERDATUM Allow NULL? 
8JAHRGANGYear number of issuenvarchar40NUMC(N'0000')YesJAHRGANG Allow NULL? 
9NRIMJAHRIssue number (in year)nvarchar40CHAR(N' ')YesNRIMJAHR Allow NULL? 
10HEFTNUMMERCopy Number of Issuenvarchar90CHAR(N' ')NoHEFTNUM_VA Allow NULL? 
11EANVAEuropean Article Number of issuenvarchar180CHAR(N' ')YesJEANVA Allow NULL? 
12VAVARTYPPLStandard issue variant type (planned)nvarchar20CHAR(N' ')YesTJD05VAVARTYPPL Allow NULL? 
13VAVARTYPTAActual issue variant typenvarchar20CHAR(N' ')YesTJD05VAVARTYPTA Allow NULL? 
14ANZSEITENNumber of Pages in Issuenvarchar80NUMC(N'00000000')YesANZSEITEN Allow NULL? 
15GESAMTAUFLTotal Circulation Produced (Issue)nvarchar80NUMC(N'00000000')YesGESAMTAUFL Allow NULL? 
16BISBEZDATIssue Availability Barnvarchar80DATS(N'00000000')YesBISBEZDAT Allow NULL? 
17MAXBEILAGEGuideline: Maximum number of insertsnvarchar30NUMC(N'000')YesMAXBEILAGE Allow NULL? 
18ANZVORDRNumber of Formsnvarchar30NUMC(N'000')YesANZVORDR Allow NULL? 
19XEDATKORRIndicator: Publication Date Corrected Automaticallychar10CHAR(N' ')YesXEDATKORR Allow NULL? 
20XVAVTYKORRIssue type corrected automaticallychar10CHAR(N' ')YesXVAVTYKORR Allow NULL? 
21XSONDAUSGSpecial issuechar10CHAR(N' ')YesXSONDAUSG Allow NULL? 
22XINDIVANGContains individual specifications (for postal settlement)char10CHAR(N' ')YesXINDIVANG Allow NULL? 
23XVERGRIFFIssue sold outchar10CHAR(N' ')YesXVERGRIFF Allow NULL? 
24XOHNEIVWExclusion from audit reportchar10CHAR(N' ')YesXOHNEIVW Allow NULL? 
25XGENMASCHIndicator: Object generated automaticallychar10CHAR(N' ')YesXGENMASCH Allow NULL? 
26XPLZUSIssue combination from production unit as plannedchar10CHAR(N' ')YesJXPLZUS_VA Allow NULL? 
27FORMATBRPage Widthdecimal93QUAN((0))YesFORMATBR
28MEINHBREITIS-M: Unit of measure for page widthnvarchar30UNIT(N' ')YesT006MEINHBREIT Allow NULL? 
29FORMATHOEPage Lengthdecimal93QUAN((0))YesFORMATHOE
30MEINHHOEIS-M: Unit of measurement for page lengthnvarchar30UNIT(N' ')YesT006MEINHHOE Allow NULL? 
31VAGEWICHTCalculated Issue Weightdecimal93QUAN((0))YesVAGEWICHT
32MEINHGEWUnit of weight for issue (calculated weight)nvarchar30UNIT(N' ')YesT006MEINHVAGEW Allow NULL? 
33VAGEWPLANPlanned Issue Weightdecimal93QUAN((0))YesVAGEWPLAN
34MEINHGEWPUnit of weight for planned issue weightnvarchar30UNIT(N' ')YesT006MEINHVAGEP Allow NULL? 
35XPGMANUELLIndicator: Planned Weight was Changed Manuallychar10CHAR(N' ')YesXPGMANUELL Allow NULL? 
36VAGEWISTActual Issue Weightdecimal93QUAN((0))YesVAGEWIST
37MEINHGEWIUnit of weight for actual issue weightnvarchar30UNIT(N' ')YesT006MEINHVAGEI Allow NULL? 
38STAERKEThickness of Issue (Usually mm/100 Units)decimal93QUAN((0))YesVASTAERKE
39MEINHSTRKUnit of measurement for thicknessnvarchar30UNIT(N' ')YesT006MEINHSTRK Allow NULL? 
40PAPIERGEWWeight of Paperdecimal93QUAN((0))YesPAPIERGEW
41MEINHPAGEWUnit of measure for weight of papernvarchar30UNIT(N' ')YesT006MEINHPAGEW Allow NULL? 
42PAGEWMANTLWeight of Paper for Common Part (Actual)decimal93QUAN((0))YesPAGEWMANTL
43MEINHPAGMTUnit of measure for weight of papernvarchar30UNIT(N' ')YesT006MEINHPAGEW Allow NULL? 
44BLATTGEWLeaf Weightdecimal93QUAN((0))YesBLATTGEW
45MEINHBLGEWUnit of weight for page weightnvarchar30UNIT(N' ')YesT006MEINHBLGEW Allow NULL? 
46BLATTGWMALeaf Weight of Common Partdecimal93QUAN((0))YesBLATTGWMA
47MEINHBGWMAUnit of weight for page weightnvarchar30UNIT(N' ')YesT006MEINHBLGEW Allow NULL? 
48XMUSTERLIndicator: Pass on sample to Production (ad pre-print)char10CHAR(N' ')YesXMUSTERL Allow NULL? 
49MUSTERLDATDate sample passed on to Production (ad pre-print)nvarchar80DATS(N'00000000')YesMUSTERLDAT Allow NULL? 
50RK_AUFNROrder Number of RK Order for Account Assignmentnvarchar80CHAR(N' ')NoJ_RK_AUFNR Allow NULL? 
51RK_POSNRItem Number of RK Order for Account Assignmentnvarchar20NUMC(N'00')NoJ_RK_POSNR Allow NULL? 
52CO_AUFNROrder number of internal CO order for account assignmentnvarchar120CHAR(N' ')NoAUFKJ_CO_AUFNR Allow NULL? 
53LOEVMDeletion Flag for Master Data in Media Sales & Distributionchar10CHAR(N' ')YesLOEVM_ISP Allow NULL? 
54LOEKZDeletion Indicator for Master Data in Media Sales & Dist.char10CHAR(N' ')YesLOEKZ_ISP Allow NULL? 
55ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
56ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
57ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
58ERFPROGProgram Used to Create Objectnvarchar400CHAR(N' ')Yes*ERFPROG Allow NULL? 
59AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
60AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
61AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
62AENPROGProgram that Made Last Changenvarchar400CHAR(N' ')Yes*AENPROG Allow NULL? 
63MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
64XANZSEITAENumber of pages in issue changed after shipping functionchar10CHAR(N' ')YesXANZSEITAE Allow NULL? 
65NRZUSATZIssue number affix for double issuesnvarchar40CHAR(N' ')NoNRIMJAHR2 Allow NULL? 
66JGZUSATZYear number affix of issue for double issuesnvarchar40NUMC(N'0000')NoJAHRGANG2 Allow NULL? 
67XHRKNFTPAMIS-M: Ad pre-print origin indicatorchar10CHAR(N' ')YesXHRKNFTPAM Allow NULL? 
68REMIBEGINNAlternative Start of Returns: Earliest Return Datenvarchar80DATS(N'00000000')NoREMIBEGINN Allow NULL? 
69SI_NUMMERIS-M: Ad Insert Numbernvarchar100CHAR(N' ')NoISM_SI_NUMMER Allow NULL? 
70SI_BEARBIS-M: Ad Insert Processing Typenvarchar20CHAR(N' ')YesTJH03SINSBEARB Allow NULL? 
71SI_TYPIS-M: Ad Insert Typenvarchar20CHAR(N' ')YesTJH29SITYP Allow NULL? 
72SI_INSERNTIS-M: Advertisernvarchar100CHAR(N' ')YesJJVDB_MK_FKINSERENT Allow NULL? 
73SI_STICHWIS-M: Keywordnvarchar400CHAR(N' ')YesSTICHW Allow NULL? 
74SI_ENTSPFLIS-M: Waste Disposal Required Indicatorchar10CHAR(N' ')YesISM_SI_ENTSPFL Allow NULL? 
75SI_VERBWERIS-M: Tie-In Ads Indicatorchar10CHAR(N' ')YesISM_SI_VERBWER Allow NULL? 
76SI_KENNZIFIS-M: Identification Numbernvarchar100CHAR(N' ')YesPAM_KENNZI Allow NULL? 
NamePrimaryUniqueTypeColumns
JDTVAUSGB~0YesYesCLUSTEREDVAUSGB, MANDT
JDTVAUSGB~1NoNoNONCLUSTEREDERSCHDAT, PVA, DRERZ
JDTVAUSGB~2NoNoNONCLUSTEREDNRIMJAHR, JAHRGANG
JDTVAUSGB~3NoNoNONCLUSTEREDSI_NUMMER, MANDT

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