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

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

SELECT MANDT, RENR, GEPRE, VSGES, REART, REDUA, AVNR, POSNR, POSEX, POSNR_UR, GP_AG, REERG, REERD, XSCRI, XSCRE, REDAU, BEZRE, REZUS, REVSG, MAILN, MAILE, LOEVM, LOEKZ, XDIALOG, XRECHERLED, VKORG, VTWEG, SPART, RUECKGRUND, BANKAUSDAT, BANKBELNR, RUECKBETR, ABWBETRAG, RUECKGEB, WAERK, BANKS, BANKL, BANKN, BKONT, BVTYP, VBELN, GPNR_REGUL, BELNR_SAMM, BELNRRUECK, XERNEZ, XOPERZ, XFKTSTORNO, ZWSCHL, STOGRD, XFKTINDEX, ISPUEBNR, XNOMESS, XRECHDRUCK, XEZERDEL, XEZER, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, XZUGAUFTR, XABGAUFTR, XVRTBEZIRK, XTITBEZIRK, XBLGBEZIRK, XBANKRUECK, GJAHR, BUKRS, RFBSK, MNDID, IBAN FROM JNTRECH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RENRIS-M: Research Numbernvarchar100NUMC(N'0000000000')NoRECHERNR Allow NULL? 
3GEPREIS-M: Researchernvarchar100CHAR(N' ')Yes*GPRECH Allow NULL? 
4VSGESResearcher's Service Companynvarchar100CHAR(N' ')Yes*VSGRCHEUR Allow NULL? 
5REARTIS-M: Research Typenvarchar20CHAR(N' ')YesTJN01RECHART Allow NULL? 
6REDUAIS-M: Research Methodnvarchar20CHAR(N' ')YesTJN03RECHDART Allow NULL? 
7AVNRIS-M/SD: Publishing Sales Ordernvarchar100CHAR(N' ')Yes*AVNR Allow NULL? 
8POSNRSales Order Itemnvarchar60NUMC(N'000000')Yes*APNR Allow NULL? 
9POSEXExternal Item Number (Purchase Order Item)nvarchar60NUMC(N'000000')YesPOSEX_ISP Allow NULL? 
10POSNR_UROriginal Item in Publishing Sales Ordernvarchar60NUMC(N'000000')Yes*APNR_UR Allow NULL? 
11GP_AGIS-M: Sold-to Party from Order Subject to Researchnvarchar100CHAR(N' ')Yes*GP_AG Allow NULL? 
12REERGResearch Resultnvarchar30CHAR(N' ')YesTJN07RECHERG Allow NULL? 
13REERDIS-M: Completion Date of Researchnvarchar80DATS(N'00000000')YesRECHERLDAT Allow NULL? 
14XSCRISAPscript text for internal commentchar10CHAR(N' ')YesXSCRIPTI Allow NULL? 
15XSCRESAPscript text for external commentchar10CHAR(N' ')YesXSCRIPTE Allow NULL? 
16REDAUDuration of Research in Hoursnvarchar60TIMS(N'000000')YesRECHDAUER Allow NULL? 
17BEZRECarrier Route Subject to Researchnvarchar100CHAR(N' ')YesJVTBEZIRKBEZRKRCHRE Allow NULL? 
18REZUSCarrier Subject to Research (Checked)nvarchar100CHAR(N' ')Yes*JZUSTRECH Allow NULL? 
19REVSGService Company Subject to Researchnvarchar100CHAR(N' ')Yes*VSGRECHE Allow NULL? 
20MAILNIndicator: Send Mail when Restart Researchchar10CHAR(N' ')YesMAILNEU Allow NULL? 
21MAILEIS-M: Send mail on completionchar10CHAR(N' ')YesMAILERL Allow NULL? 
22LOEVMDeletion Flag for Master Data in Media Sales & Distributionchar10CHAR(N' ')YesLOEVM_ISP Allow NULL? 
23LOEKZDeletion Indicator for Master Data in Media Sales & Dist.char10CHAR(N' ')YesLOEKZ_ISP Allow NULL? 
24XDIALOGCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
25XRECHERLEDCheckbox: Research completechar10CHAR(N' ')YesXRECHERLED Allow NULL? 
26VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
27VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVKOVVTWEG Allow NULL? 
28SPARTDivisionnvarchar20CHAR(N' ')YesTVTASPART Allow NULL? 
29RUECKGRUNDIS-M: Bank Return Reasonnvarchar30CHAR(N' ')YesTJN09RUECKGRUND Allow NULL? 
30BANKAUSDATIS-M: Bank Statement Datenvarchar80DATS(N'00000000')YesBANKAUSDAT Allow NULL? 
31BANKBELNRIS-M: Bank Document Number for Bank Returnnvarchar100CHAR(N' ')YesBANKBELNR Allow NULL? 
32RUECKBETRIS-M: Billing Amount for Bank Returndecimal132CURR((0))YesRUECKBETR
33ABWBETRAGIS-M: Bank Return Amountdecimal132CURR((0))YesABWBETRAG
34RUECKGEBIS-M: Return Charge for Bank Returndecimal132CURR((0))YesRUECKGEB
35WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
36BANKSBank country keynvarchar30CHAR(N' ')YesT005BANKS Allow NULL? 
37BANKLBank Keysnvarchar150CHAR(N' ')YesBANKK Allow NULL? 
38BANKNBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
39BKONTBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
40BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
41VBELNIS-M/SD: Billing Documentnvarchar100CHAR(N' ')YesJFRKISPVBELN Allow NULL? 
42GPNR_REGULIS-M: Business Partner Number Payernvarchar100CHAR(N' ')Yes*GPNR_REGUL Allow NULL? 
43BELNR_SAMMIS-M: Document Number for Coll.Transfer of Automatic Debitnvarchar100CHAR(N' ')YesBELNR_SAMM Allow NULL? 
44BELNRRUECKIS-M: Accounting Document Number for Bank Returnsnvarchar100CHAR(N' ')YesBELNRRUECK Allow NULL? 
45XERNEZIS-M: Repeat Automatic Debit (Bank Return)char10CHAR(N' ')YesXERNEZ Allow NULL? 
46XOPERZIS-M: Generate Open Item (Bank Return)char10CHAR(N' ')YesXOPERZ Allow NULL? 
47XFKTSTORNOIS-M: Reverse Billing Document (Bank Return)char10CHAR(N' ')YesXFKTSTORNO Allow NULL? 
48ZWSCHLIS-M: Payment Method (Bank Returns)char10CHAR(N' ')YesTJK42JZWSCHL Allow NULL? 
49STOGRDIS-M: Billing Document Reversal Reasonnvarchar30CHAR(N' ')YesTJF27JSTOGRDF Allow NULL? 
50XFKTINDEXIS-M: Set up Billing Index for Reversed Billing Documentchar10CHAR(N' ')YesXFKTINDEX Allow NULL? 
51ISPUEBNRIS-M: Number of Transfer Run to FInvarchar100CHAR(N' ')Yes*ISPUEBNR Allow NULL? 
52XNOMESSIS-M: Indicator - Do Not Perform Output Determinationchar10CHAR(N' ')NoXNOMESS Allow NULL? 
53XRECHDRUCKIS-M: Print Invoice (Bank Returns)char10CHAR(N' ')NoXRECHDRKBR Allow NULL? 
54XEZERDELIndicator: Delete Collection Authorizationchar10CHAR(N' ')NoXEZERDEL Allow NULL? 
55XEZERIndicator: Is there collection authorization ?char10CHAR(N' ')NoXEZER Allow NULL? 
56ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
57ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
58ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME 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? 
62XZUGAUFTRIS-M: Success research for orderchar10CHAR(N' ')NoXZUGAUFTR Allow NULL? 
63XABGAUFTRIS-M: Order failure researchchar10CHAR(N' ')NoXABGAUFTR Allow NULL? 
64XVRTBEZIRKAd pre-print zonechar10CHAR(N' ')NoXVRTBEZIRK Allow NULL? 
65XTITBEZIRKCarrier routechar10CHAR(N' ')NoXTITBEZIRK Allow NULL? 
66XBLGBEZIRKInsert zonechar10CHAR(N' ')NoXBLGBEZIRK Allow NULL? 
67XBANKRUECKIS-M: Checkbox for bank return researchchar10CHAR(N' ')NoXBANKRUECK Allow NULL? 
68GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
69BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
70RFBSKIS-M: Status for Transfer to FI (Bank Returns)char10CHAR(N' ')NoRFBSK_BR Allow NULL? 
71MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
72IBANIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesIBAN Allow NULL? 
NamePrimaryUniqueTypeColumns
JNTRECH~0YesYesCLUSTEREDRENR, MANDT
JNTRECH~1NoNoNONCLUSTEREDVBELN, MANDT
JNTRECH~2NoNoNONCLUSTEREDREART, POSEX, AVNR, MANDT
JNTRECH~3NoNoNONCLUSTEREDGPNR_REGUL, MANDT
JNTRECH~4NoNoNONCLUSTEREDRFBSK
JNTRECH~5NoNoNONCLUSTEREDISPUEBNR
JNTRECH~ANoNoNONCLUSTEREDRUECKGRUND, SPART, VTWEG, VKORG, REART
JNTRECH~BNoNoNONCLUSTEREDBUKRS, XBANKRUECK, BANKBELNR, BANKAUSDAT

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