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  | JFRK
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JFRK994IS-M/SD: Billing - Header DataPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, FKART, VBTYP, WAERK, VKORG, VTWEG, KALSM, KNUMV, FKDAT, BELNR, GJAHR, POPER, KONDA, KDGRP, PLTYP, RFBSK, KURRF, ZTERM, ZLSCH, KTGRD, LAND1, REGIO, COUNC, CITYC, BUKRS, TAXK1, TAXK2, TAXK3, TAXK4, TAXK5, TAXK6, TAXK7, TAXK8, TAXK9, NETWR, ZUKRI, ERNAM, ERZET, ERDAT, STAFO, KUNRG, KUNAG, MABER, STWAE, STCEG, AEDAT, KURST, SPART, STCEG_H, STCEG_L, MWSBK, SAMMG, ISPOBJART, ISPBANKS, ISPBANKL, ISPBANKN, ISPBVTYP, ISPXEZER, ISPBKONT, ISPJAVNR, ISPJAPNR, ISPZLSCH, ISPSFAKT, ISPJSTORN, ISPJSNFAK, ISPBRTWR, ISPSFKOPF, ISPJUEBART, ISPXDRUCK, ISPANZFPOS, ISPSHKZGK, ISPBUPER, ISPUMSKZ, ISPSTOGRD, ISPXJSIND, ISPUKONT, ISPUEBDAT, ISPUEBNR, ISPXINK, ISPXUINK, ISPXWBZABO, ISPINKVSG, ISPINKGP, ISPXVDICHT, ISPJUEBARH, ISPXNOMESS, MNDID, IBAN, XRENEWAL, AMORTN, XINVAUTHOR, AWREF, XTRANSFER, JAVCYCLENR, VKONT, XPAYMODE_FIX, BELNR_FKK, NRZAS FROM JFRK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNIS-M/SD: Billing Documentnvarchar100CHAR(N' ')NoISPVBELN Allow NULL? 
3FKARTIS-M: Billing/Settlement Typenvarchar40CHAR(N' ')NoTJFKJFKART Allow NULL? 
4VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
5WAERKSD Document Currencynvarchar50CUKY(N' ')NoTCURCWAERK Allow NULL? 
6VKORGSales Organizationnvarchar40CHAR(N' ')NoTVKOVKORG Allow NULL? 
7VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVTWVTWEG Allow NULL? 
8KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')NoT683KALSMASD Allow NULL? 
9KNUMVNumber of the document conditionnvarchar100CHAR(N' ')NoKNUMV Allow NULL? 
10FKDATBilling date for billing index and printoutnvarchar80DATS(N'00000000')NoFKDAT Allow NULL? 
11BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
12GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
13POPERPosting periodnvarchar30NUMC(N'000')NoPOPER Allow NULL? 
14KONDAPrice group (customer)nvarchar20CHAR(N' ')NoT188KONDA Allow NULL? 
15KDGRPCustomer groupnvarchar20CHAR(N' ')NoT151KDGRP Allow NULL? 
16PLTYPPrice list typenvarchar20CHAR(N' ')NoT189PLTYP Allow NULL? 
17RFBSKIS-M/SD: Status for transfer to Accountingchar10CHAR(N' ')NoJFRFBSK Allow NULL? 
18KURRFExchange rate for FI postingsdecimal95DEC((0))NoKURRF
19ZTERMTerms of Payment Keynvarchar40CHAR(N' ')NoDZTERM Allow NULL? 
20ZLSCHPayment Methodchar10CHAR(N' ')NoT042ZSCHZW_BSEG Allow NULL? 
21KTGRDAccount assignment group for this customernvarchar20CHAR(N' ')NoTVKTKTGRD Allow NULL? 
22LAND1Country of Destinationnvarchar30CHAR(N' ')NoT005LLAND Allow NULL? 
23REGIORegion (State, Province, County)nvarchar30CHAR(N' ')NoT005SREGIO Allow NULL? 
24COUNCCounty Codenvarchar30CHAR(N' ')NoT005ECOUNC Allow NULL? 
25CITYCCity Codenvarchar40CHAR(N' ')NoT005GCITYC Allow NULL? 
26BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
27TAXK1Tax classification 1 for customerchar10CHAR(N' ')No*TAXK1 Allow NULL? 
28TAXK2Tax classification 2 for customerchar10CHAR(N' ')No*TAXK2 Allow NULL? 
29TAXK3Tax classification 3 for customerchar10CHAR(N' ')No*TAXK3 Allow NULL? 
30TAXK4Tax Classification 4 Customerchar10CHAR(N' ')No*TAXK4 Allow NULL? 
31TAXK5Tax classification 5 for customerchar10CHAR(N' ')No*TAXK5 Allow NULL? 
32TAXK6Tax classification 6 for customerchar10CHAR(N' ')No*TAXK6 Allow NULL? 
33TAXK7Tax classification 7 for customerchar10CHAR(N' ')No*TAXK7 Allow NULL? 
34TAXK8Tax classification 8 for customerchar10CHAR(N' ')No*TAXK8 Allow NULL? 
35TAXK9Tax classification 9 for customerchar10CHAR(N' ')No*TAXK9 Allow NULL? 
36NETWRNet Value in Document Currencydecimal152CURR((0))NoNETWR
37ZUKRICombination criteria in the billing documentnvarchar400CHAR(N' ')NoDZUKRI Allow NULL? 
38ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
39ERZETEntry timenvarchar60TIMS(N'000000')NoERZET Allow NULL? 
40ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
41STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')No*STAFO Allow NULL? 
42KUNRGPayernvarchar100CHAR(N' ')NoKNA1KUNRG Allow NULL? 
43KUNAGSold-to partynvarchar100CHAR(N' ')NoKNA1KUNAG Allow NULL? 
44MABERDunning Areanvarchar20CHAR(N' ')NoT047MMABER Allow NULL? 
45STWAEStatistics currencynvarchar50CUKY(N' ')NoTCURCSTWAE Allow NULL? 
46STCEGVAT Registration Numbernvarchar200CHAR(N' ')NoSTCEG Allow NULL? 
47AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
48KURSTExchange Rate Typenvarchar40CHAR(N' ')NoTCURVKURST Allow NULL? 
49SPARTDivisionnvarchar20CHAR(N' ')NoTSPASPART Allow NULL? 
50STCEG_HOrigin of sales tax ID numberchar10CHAR(N' ')NoSTCEG_H Allow NULL? 
51STCEG_LTax Destination Countrynvarchar30CHAR(N' ')No*LAND1TX Allow NULL? 
52MWSBKTax amount in document currencydecimal132CURR((0))NoMWSBP
53SAMMGIS-M: Group Numbernvarchar100CHAR(N' ')NoJFSKISPSAMMG Allow NULL? 
54ISPOBJARTIS-M: Object type for document flownvarchar40CHAR(N' ')YesLABART Allow NULL? 
55ISPBANKSBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
56ISPBANKLBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
57ISPBANKNBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
58ISPBVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
59ISPXEZERIndicator: Is there collection authorization ?char10CHAR(N' ')YesXEZER Allow NULL? 
60ISPBKONTBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
61ISPJAVNRIS-M: Merge criterion for ordernvarchar100CHAR(N' ')Yes*JAVNR Allow NULL? 
62ISPJAPNRIS-M: Merge criterion for sales order itemnvarchar60NUMC(N'000000')Yes*JAPNR Allow NULL? 
63ISPZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
64ISPSFAKTIS-M: Number of Billing Document Reversednvarchar100CHAR(N' ')Yes*ISPSFAKT Allow NULL? 
65ISPJSTORNIS-M: Reversal Numbernvarchar100CHAR(N' ')Yes*JSTORN Allow NULL? 
66ISPJSNFAKIS-M: Number of Reversal in Subsequent Documentnvarchar100CHAR(N' ')Yes*ISPSNFAK Allow NULL? 
67ISPBRTWRIS-M: Gross Value in Document Currencydecimal152CURR((0))YesISPBRTWR
68ISPSFKOPFSeparate billing document for sales orderchar10CHAR(N' ')YesXSEPFKKOPF Allow NULL? 
69ISPJUEBARTIS-M: Transfer Typechar10CHAR(N' ')YesJUEBART Allow NULL? 
70ISPXDRUCKIS-M: Print Invoicechar10CHAR(N' ')YesXRECHDRUCK Allow NULL? 
71ISPANZFPOSIS-M: Number of billing items in billing documentnvarchar40NUMC(N'0000')YesJANZFPOS Allow NULL? 
72ISPSHKZGKDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
73ISPBUPERFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
74ISPUMSKZSpecial G/L Indicatorchar10CHAR(N' ')YesT074UUMSKZ Allow NULL? 
75ISPSTOGRDIS-M: Billing Document Reversal Reasonnvarchar30CHAR(N' ')YesTJF27JSTOGRDF Allow NULL? 
76ISPXJSINDRepeat Billing After Reversalchar10CHAR(N' ')YesXJSIND Allow NULL? 
77ISPUKONTG/L Account to be Posted to (Bank Subaccount)nvarchar100CHAR(N' ')Yes*UKONT_042I Allow NULL? 
78ISPUEBDATIS-M: Accrual Datenvarchar80DATS(N'00000000')YesISPUEBDAT Allow NULL? 
79ISPUEBNRIS-M: Number of Transfer Run to FInvarchar100CHAR(N' ')Yes*ISPUEBNR Allow NULL? 
80ISPXINKIS-M: Payment by field collectorchar10CHAR(N' ')YesXKINKASSO Allow NULL? 
81ISPXUINKIS-M: Collection billing doc.transferred to company codechar10CHAR(N' ')YesXJUINK Allow NULL? 
82ISPXWBZABOIS-M: WBZ subscriptionchar10CHAR(N' ')YesXWBZABO Allow NULL? 
83ISPINKVSGIS-M: Field Collector is Service Companynvarchar100CHAR(N' ')Yes*ISPINKVSG Allow NULL? 
84ISPINKGPIS-M: Field Collector is Employeenvarchar100CHAR(N' ')Yes*ISPINKGP Allow NULL? 
85ISPXVDICHTIS-M: Summarize deliveries according to billing itemchar10CHAR(N' ')YesXFKVDICHT Allow NULL? 
86ISPJUEBARHIS-M: Transfer type at time of billingchar10CHAR(N' ')YesJUEBARTFKH Allow NULL? 
87ISPXNOMESSIS-M: Indicator - Do Not Perform Output Determinationchar10CHAR(N' ')YesXNOMESS Allow NULL? 
88MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
89IBANIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesIBAN Allow NULL? 
90XRENEWALIS-M/SD: Order extended by renewal offerchar10CHAR(N' ')NoXRENEWAL Allow NULL? 
91AMORTNIS-M/SD: Use of Liability Account in Orderchar10CHAR(N' ')NoAMORTN Allow NULL? 
92XINVAUTHORIS-M/SD: Billing document authorizedchar10CHAR(N' ')NoXINVAUTHOR Allow NULL? 
93AWREFReference Document Numbernvarchar100CHAR(N' ')NoAWREF Allow NULL? 
94XTRANSFERIS-M/SD: Transfer billing documentchar10CHAR(N' ')NoXTRANSFER_INV Allow NULL? 
95JAVCYCLENRIS-M: Merge Criterion for Order Billing Cyclenvarchar30NUMC(N'000')No*JAVCYCLENR Allow NULL? 
96VKONTContract Account Numbernvarchar120CHAR(N' ')No*VKONT_KK Allow NULL? 
97XPAYMODE_FIXIS-M/SD: Payment Arrangement in Order Fixedchar10CHAR(N' ')NoXPAYMODE_FIX Allow NULL? 
98BELNR_FKKNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')No*OPBEL_KK Allow NULL? 
99NRZASPayment Form Numbernvarchar120CHAR(N' ')NoNRZAS_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
JFRK~0YesYesCLUSTEREDVBELN, MANDT
JFRK~1NoNoNONCLUSTEREDSAMMG
JFRK~2NoNoNONCLUSTEREDISPUEBNR
JFRK~3NoNoNONCLUSTEREDKUNRG, 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