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  | JHTFK
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 :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JHTFK1131IS-M/AM: Settlement Documents (Billing, Commission) - HeaderAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, SFAKN, XEZER, BANKS, BANKN, BANKL, BKONT, BVTYP, FKART, FKDAT, FKTYP, INCO1, INCO2, KNUMV, KURST, LAND1, REGIO, VKORG, TAXK1, TAXK2, TAXK3, TAXK4, TAXK5, TAXK6, TAXK7, TAXK8, TAXK9, UEBAR, WAERK, ZTERM, VALTG, VALDT, ZLSCH, MSCHL, MANSP, NATIO, ADRNR, CCINS, CCNUM, DATBI, CCNAME, CCAUA, CCACT, AUDAT_CC, AUTIM, CCALL, REACT, AUTWR, CCWAE, AUNUM, AUTRA, SETTL, CGUID, ENCTP, IBAN, MNDID, STTYP, MRNKZ, EXPKZ, EXNUM, POPER, GJAHR, MONAT, XBLNR, ZUONR, BELNR, UNRFI, KURRF, CPKUR, BRTWK, NETWK, MWSBK, STWAE, STAFO, RFBSK, STAFI, MABER, VBTYP, PERFK, BUKRS, KTGRD, PLTYP, KUNRG, KUNRE, STCEG, STCEG_H, STCEG_L, LANDTX, COUNC, CITYC, TXJCD, ZUKRI, LOGSYS, EKORG, KREZE, KRERS, VNR, VTYP, KTGRV, UEBERLART, PERNR, VTNR, ABRGNR, FAB_PROZNT, SD_VBELN_VF, SD_NEWGL_STA FROM JHTFK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNIS-M/AM: Billing Documentnvarchar100CHAR(N' ')NoJJBELNR Allow NULL? 
3ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
4ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
5ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
6AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
7AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
8AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
9SFAKNIS-M: Reversal Referencenvarchar100CHAR(N' ')YesJHTFKJJBELNRSV Allow NULL? 
10XEZERIndicator: Is there collection authorization ?char10CHAR(N' ')YesXEZER Allow NULL? 
11BANKSBank country keynvarchar30CHAR(N' ')YesT005BANKS Allow NULL? 
12BANKNBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
13BANKLBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
14BKONTBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
15BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
16FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40CHAR(N' ')YesTJH05FKART_PAM Allow NULL? 
17FKDATIS-M: Actual Billing/Settlement Datenvarchar80DATS(N'00000000')YesJHFKDAT Allow NULL? 
18FKTYPIS-M/AM: Billing Categorychar10CHAR(N' ')YesTJH19JHFKTYP Allow NULL? 
19INCO1Incoterms (Part 1)nvarchar30CHAR(N' ')YesTINCINCO1 Allow NULL? 
20INCO2Incoterms (Part 2)nvarchar280CHAR(N' ')YesINCO2 Allow NULL? 
21KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
22KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
23LAND1Country of Destinationnvarchar30CHAR(N' ')YesT005LLAND Allow NULL? 
24REGIORegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
25VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
26TAXK1IS-M: Tax classification for business partnerchar10CHAR(N' ')YesJTACLGP1 Allow NULL? 
27TAXK2IS-M: Tax classification 2 for business partnerchar10CHAR(N' ')YesJTACLGP2 Allow NULL? 
28TAXK3IS-M: Tax classification 3 for business partnerchar10CHAR(N' ')YesJTACLGP3 Allow NULL? 
29TAXK4IS-M: Tax classification 4 for business partnerchar10CHAR(N' ')YesJTACLGP4 Allow NULL? 
30TAXK5IS-M: Tax classification 5 for business partnerchar10CHAR(N' ')YesJTACLGP5 Allow NULL? 
31TAXK6IS-M: Tax classification 6 for business partnerchar10CHAR(N' ')YesJTACLGP6 Allow NULL? 
32TAXK7IS-M: Tax classification 7 for business partnerchar10CHAR(N' ')YesJTACLGP7 Allow NULL? 
33TAXK8IS-M: Tax classification 8 for business partnerchar10CHAR(N' ')YesJTACLGP8 Allow NULL? 
34TAXK9IS-M: Tax classification 9 for business partnerchar10CHAR(N' ')YesJTACLGP9 Allow NULL? 
35UEBARIS-M: Transfer typechar10CHAR(N' ')YesTJH41JHUEBART Allow NULL? 
36WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
37ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
38VALTGAdditional value daysnvarchar20NUMC(N'00')YesVALTG Allow NULL? 
39VALDTFixed value datenvarchar80DATS(N'00000000')YesVALDT Allow NULL? 
40ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
41MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
42MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
43NATIOInternational address version IDchar10CHAR(N' ')YesTSAVINTER Allow NULL? 
44ADRNRIS-M: One-Time Customer Addressnvarchar100CHAR(N' ')YesADRCISM_CPDADDRNUM Allow NULL? 
45CCINSPayment cards: Card typenvarchar40CHAR(N' ')NoTVCINCCINS Allow NULL? 
46CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')NoVCNUMCCNUM Allow NULL? 
47DATBIPayment Cards: Valid Tonvarchar80DATS(N'00000000')NoDATBI_CC Allow NULL? 
48CCNAMEPayment cards: Name of cardholdernvarchar400CHAR(N' ')NoCCNAME Allow NULL? 
49CCAUAPayment cards: Authorization typechar10CHAR(N' ')NoCCAUA Allow NULL? 
50CCACTG/L Account Number for Payment Card Receivablesnvarchar100CHAR(N' ')NoSKA1CCACT Allow NULL? 
51AUDAT_CCPayment cards: Authorization datenvarchar80DATS(N'00000000')NoAUDAT_CC Allow NULL? 
52AUTIMPayment cards: Authorization timenvarchar60TIMS(N'000000')NoAUTIM Allow NULL? 
53CCALLPayment cards: Status when external system is called?char10CHAR(N' ')NoCCALL Allow NULL? 
54REACTPayment cards: Response to authorization checkschar10CHAR(N' ')NoREACT_SD Allow NULL? 
55AUTWRPayment cards: Authorized amountdecimal152CURR((0))NoAUTWR
56CCWAECurrency Keynvarchar50CUKY(N' ')NoTCURCWAERS Allow NULL? 
57AUNUMPayment cards: Authorization numbernvarchar100CHAR(N' ')NoAUNUM Allow NULL? 
58AUTRAPayment cards: Authoriz. reference code of clearing housenvarchar150CHAR(N' ')NoAUTRA Allow NULL? 
59SETTLPayment cards: Settlement carried outchar10CHAR(N' ')NoSETTL Allow NULL? 
60CGUIDGUID of a Payment Cardvarbinary160RAWYesCARD_GUID
61ENCTPType of Encryptionchar10CHAR(N' ')YesCCSECA_ENCTYPE Allow NULL? 
62IBANIBAN (International Bank Account Number)nvarchar340CHAR(N' ')YesIBAN Allow NULL? 
63MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
64STTYPIS-M: Reversal Typechar10CHAR(N' ')YesSTORNOTYP Allow NULL? 
65MRNKZManual invoice maintenancechar10CHAR(N' ')YesMRNKZ Allow NULL? 
66EXPKZExport indicatorchar10CHAR(N' ')YesEXPKZ Allow NULL? 
67EXNUMNumber of foreign trade data in MM and SD documentsnvarchar100CHAR(N' ')YesEIKPEXNUM Allow NULL? 
68POPERPosting periodnvarchar30NUMC(N'000')YesPOPER Allow NULL? 
69GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
70MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
71XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
72ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
73BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
74UNRFIIS-M: Field is not usednvarchar100CHAR(N' ')YesJHUNRFI Allow NULL? 
75KURRFExchange rate for FI postingsdecimal95DEC((0))YesKURRF
76CPKURID:Exchange rate setting (no new rate determ.in bill.doc.)char10CHAR(N' ')YesCPKUR Allow NULL? 
77BRTWKIS-M: Gross Value in Document Currency (Header)decimal152CURR((0))YesJHBRTWRK
78NETWKNet Value in Document Currencydecimal152CURR((0))YesNETWR
79MWSBKTax amount in document currencydecimal132CURR((0))YesMWSBP
80STWAEStatistics currencynvarchar50CUKY(N' ')YesTCURCSTWAE Allow NULL? 
81STAFOIS-M: Update group for statistics updatenvarchar60CHAR(N' ')YesTMCBJHSTAFO Allow NULL? 
82RFBSKIS-M/AM: Status for Transfer to Accounting / HRchar10CHAR(N' ')YesJHRFBSK Allow NULL? 
83STAFIIS-M: Status of the Financial Accounting Documentchar10CHAR(N' ')NoISMSTAFI Allow NULL? 
84MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
85VBTYPIS-M/AM: Sales Document Categorychar10CHAR(N' ')YesISPVBTYP Allow NULL? 
86PERFKInvoice dates (calendar identification)nvarchar20CHAR(N' ')YesTFACDPERFK Allow NULL? 
87BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
88KTGRDAccount assignment group for this customernvarchar20CHAR(N' ')YesTVKTKTGRD Allow NULL? 
89PLTYPPrice list typenvarchar20CHAR(N' ')YesT189PLTYP Allow NULL? 
90KUNRGIS-M: Payernvarchar100CHAR(N' ')YesJGTGPNRREGULIERER Allow NULL? 
91KUNREIS-M: Business Partner - Bill-To Partynvarchar100CHAR(N' ')YesJGTGPNRGPNR_RECH Allow NULL? 
92STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
93STCEG_HOrigin of sales tax ID numberchar10CHAR(N' ')YesSTCEG_H Allow NULL? 
94STCEG_LCountry of Sales Tax ID Numbernvarchar30CHAR(N' ')YesT005STCEG_L Allow NULL? 
95LANDTXTax departure countrynvarchar30CHAR(N' ')Yes*LANDTX Allow NULL? 
96COUNCCounty Codenvarchar30CHAR(N' ')Yes*COUNC Allow NULL? 
97CITYCCity Codenvarchar40CHAR(N' ')Yes*CITYC Allow NULL? 
98TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
99ZUKRICombination criteria in the billing documentnvarchar400CHAR(N' ')YesDZUKRI Allow NULL? 
100LOGSYSLogical systemnvarchar100CHAR(N' ')YesTBDLSLOGSYS Allow NULL? 
101EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
102KREZEIS-M: Payeenvarchar100CHAR(N' ')YesJGTGPNRJHKREZE Allow NULL? 
103KRERSIS-M: Invoicing Partynvarchar100CHAR(N' ')YesJGTGPNRJHKRERS Allow NULL? 
104VNRIS-M: Media Sales Agent Contract Numbernvarchar100CHAR(N' ')YesJJTVVJVMVVNR Allow NULL? 
105VTYPIS-M: Contract Category for Media Sales Agent Contractchar10CHAR(N' ')YesJVERMVTYP Allow NULL? 
106KTGRVIS-M: Account Assignment Group for Sales Agent Contractnvarchar20CHAR(N' ')YesTJJAFKTGRV Allow NULL? 
107UEBERLARTIS-M: Transfer Destinationchar10CHAR(N' ')YesUEBERLZIEL Allow NULL? 
108PERNRIS-M: Personnel Numbernvarchar200CHAR(N' ')YesJJPERNR Allow NULL? 
109VTNRIS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVKOABS_VTNR Allow NULL? 
110ABRGNRIS-M/AM: Contract Settlement Numbernvarchar40NUMC(N'0000')YesJHTVAABKABRGNR Allow NULL? 
111FAB_PROZNTIS-M: Percentage Rate for Receivables Charge-Offdecimal63DEC((0))YesFAB_PROZNT
112SD_VBELN_VFIS-M: SD Billing Number Referencednvarchar100CHAR(N' ')No*JHVBELN_VF Allow NULL? 
113SD_NEWGL_STAOrder Status newGL Enhancementchar10CHAR(N' ')YesISM_SPLIT_CRITERION_STATUS Allow NULL? 
NamePrimaryUniqueTypeColumns
JHTFK~0YesYesCLUSTEREDVBELN, 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