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

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 :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JHTFP1492IS-M/AM: Billing/Settlement Documents - ItemAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, VTWEG, SPART, KDGRP, KONDA, KAPPL, KALSM, ARKTX, AUBEL, AUPOS, AUGRP, AUETE, AVMAUART, AUREF, BEINH, BEINH_BAS, DRERZ, PVA, IHKOMP, INHK_KFM, INHK_TECH2, AZAFOV, AZAFO, AZAFA, AZAGST, TERMINSPEZ, VAVTYP, CHIFFRE, ABSRB, ABSBO, ABSFMPR, GO_PREIS, INSERENT, STICHW, DIENSTL, DITYP, MATNR, EAN11, FBUDA, FSART, KTGRM, KTGRB, PRSFD, KURSK, PRSDT, SHKZG, SMENG, FKIMG, MEINS, BRGEW, NTGEW, GEWEI, VGBEL, VGPOS, VGETE, VGTYP, VGOBJ, VGFKTYP, VBELV, POSNV, VKBUR, VKGRP, VRKME, WERKS, POSAR, PRODH, PSTYV, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, GSBER, AUFNR, KOSTL, PRCTR, RK_AUFNR, RK_POSNR, KOSTL_R2, STGRB, STAFO, SKTOF, RRREL, RRSTA, CAMPAIGN, PACKAGE_ID, PK_REF_AVM_NR, PK_REF_POS_NR, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, KUNAG, ELAND, POSPA, PLTYP_AUFT, MPROK, KOWRR, BONBA, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, WAVWR, SKFBP, BRTWP, NETWP, MWSBP, CMPRE, CMPRE_FLT, UVPRS, UVALL, XERLV, XPEAB, TXJCD, UMVKZ, UMVKN, STCUR, PAOBJNR, KOKRS, ZUONR, KOUPD, XCNCL, BEDNR, PROVTYP, VZUONR, BERART, PBSCHL, SCBAS, VERMART, PR_BETRAG, PBBASIS, ISPBEDART, ALAND, XSTEIG, VKORG_AUFT, EPROZ, NETWPV, KTGRP FROM JHTFP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNIS-M/AM: Billing Documentnvarchar100CHAR(N' ')NoJHTFKJJBELNR Allow NULL? 
3POSNRIS-M/AM: Item (number) in settlement documentnvarchar60NUMC(N'000000')NoJJPOSNR Allow NULL? 
4VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
5SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
6KDGRPCustomer groupnvarchar20CHAR(N' ')YesT151KDGRP Allow NULL? 
7KONDAPrice group (customer)nvarchar20CHAR(N' ')YesT188KONDA Allow NULL? 
8KAPPLApplicationnvarchar20CHAR(N' ')YesT681AKAPPL Allow NULL? 
9KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')YesT683KALSMASD Allow NULL? 
10ARKTXIS-M: Short Text for Document Item (Billing Doc.,Settlement)nvarchar400CHAR(N' ')YesISM_ARKTX Allow NULL? 
11AUBELIS-M/AM: Sales Document Numbernvarchar100CHAR(N' ')YesJHAKAVM_NR Allow NULL? 
12AUPOSIS-M: Order Item Numbernvarchar30NUMC(N'000')YesJHAPPOS_NR Allow NULL? 
13AUGRPIS-M/AM: Billing Datasetnvarchar30NUMC(N'000')YesJHAGAGRUPPABRNR Allow NULL? 
14AUETEIS-M: Schedule Linenvarchar60NUMC(N'000000')YesJHAEEIN_NR Allow NULL? 
15AVMAUARTIS-M: Sales Document Typenvarchar40CHAR(N' ')YesTJHAKAUART_PAM Allow NULL? 
16AUREFSales document was created from referencechar10CHAR(N' ')YesAUREF Allow NULL? 
17BEINHIS-M/AM: Booking Unitnvarchar100CHAR(N' ')YesJJTBEBELEGEINH Allow NULL? 
18BEINH_BASIS-M: Basic Booking Unitnvarchar100CHAR(N' ')YesJJTBEBE_BASIS Allow NULL? 
19DRERZIS-M: Publicationnvarchar80CHAR(N' ')YesJDTDRERJHDRERZ Allow NULL? 
20PVAEditionnvarchar80CHAR(N' ')YesJDTPVAPVA Allow NULL? 
21IHKOMPIS-M: Content component for pricing callnvarchar80CHAR(N' ')YesJJTIKOIKO_PREIS Allow NULL? 
22INHK_KFMIS-M: Business Content Componentnvarchar80CHAR(N' ')YesJJTIKOINHK_KFM Allow NULL? 
23INHK_TECH2IS-M: Special Publication Content Componentnvarchar80CHAR(N' ')YesJJTIKOINHK_SOVER Allow NULL? 
24AZAFOVIS-M/AM: Fixed Format Proposal /Ad Dimensionsnvarchar40CHAR(N' ')YesTJJ13AZART_AREA Allow NULL? 
25AZAFOIS-M: Shape Ad Typenvarchar40CHAR(N' ')YesTJJ17AZART_FORM Allow NULL? 
26AZAFAIS-M: Color Scheme Ad Typenvarchar40CHAR(N' ')YesTJJ11AZART_FARB Allow NULL? 
27AZAGSTIS-M: Design Ad Typenvarchar40CHAR(N' ')YesTJJ19AZART_GEST Allow NULL? 
28TERMINSPEZIS-M/AM: Specify Dates for Date Combinationsnvarchar60CHAR(N' ')Yes*TERMINSPEZ Allow NULL? 
29VAVTYPIssue Variant Typenvarchar20CHAR(N' ')YesTJD05VAVARTYP Allow NULL? 
30CHIFFREIS-M: Box Number Indicatorchar10CHAR(N' ')YesTJH59CHIFFRE_KZ Allow NULL? 
31ABSRBIS-M: Current Valid Contract Discount Ratedecimal52DEC((0))YesAB_RABATT
32ABSBOIS-M/AM: Current Valid Contract Bonusdecimal52DEC((0))YesAKTBONUS
33ABSFMPRIS-M: Current Valid Price from Contractdecimal152CURR((0))YesAB_PREIS
34GO_PREISIS-M: Basic/Local Pricechar10CHAR(N' ')YesGO_PREIS Allow NULL? 
35INSERENTIS-M: Advertisernvarchar100CHAR(N' ')YesJJVDB_MK_FKINSERENT Allow NULL? 
36STICHWIS-M: Keywordnvarchar400CHAR(N' ')YesSTICHW Allow NULL? 
37DIENSTLIS-M: Service material numbernvarchar180CHAR(N' ')YesJJTDIENMATNR_DIEN Allow NULL? 
38DITYPIS-M: Service Typenvarchar40CHAR(N' ')YesTJH71DIENTYP Allow NULL? 
39MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
40EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
41FBUDADate on which services renderednvarchar80DATS(N'00000000')YesFBUDA Allow NULL? 
42FSARTIS-M/AM: Billing Methodchar10CHAR(N' ')YesISP_FSART Allow NULL? 
43KTGRMAccount assignment group for this materialnvarchar20CHAR(N' ')YesTVKMKTGRM Allow NULL? 
44KTGRBIS-M: Booking Unit Account Assignment Groupnvarchar20CHAR(N' ')YesTJJ39KTGRB Allow NULL? 
45PRSFDCarry out pricingchar10CHAR(N' ')YesPRSFD Allow NULL? 
46KURSKExchange Rate for Price Determinationdecimal95DEC((0))YesKURSK
47PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
48SHKZGIS-M: Debit/Credit indicatorchar10CHAR(N' ')YesJHSHKZG Allow NULL? 
49SMENGScale quantity in base unit of measuredecimal133QUAN((0))YesSMENG
50FKIMGActual Invoiced Quantitydecimal133QUAN((0))YesFKIMG
51MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
52BRGEWGross Weightdecimal133QUAN((0))YesBRGEW
53NTGEWNet Weightdecimal133QUAN((0))YesNTGEW
54GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
55VGBELIS-M: Document Number of Template Documentnvarchar100CHAR(N' ')Yes*JHVGBEL Allow NULL? 
56VGPOSIS-M: Item Number of the Template Business Itemnvarchar60NUMC(N'000000')YesJHVGPOS Allow NULL? 
57VGETEIS-M: Group/Settlement Number of Template Documentnvarchar30NUMC(N'000')Yes*GRABR_VG Allow NULL? 
58VGTYPIS-M: Preceding Sales Document Categorychar10CHAR(N' ')YesISPVBTYP_V Allow NULL? 
59VGOBJIS-M: Preceding object typenvarchar20CHAR(N' ')YesTJH97JHOBJAR_V Allow NULL? 
60VGFKTYPIS-M: Billing Category for Preceding Billing Documentchar10CHAR(N' ')YesTJH19JHVGFKTYP Allow NULL? 
61VBELVIS-M: Originating sales documentnvarchar100CHAR(N' ')YesISMVBELV Allow NULL? 
62POSNVIS-M: Originating itemnvarchar60NUMC(N'000000')YesISMPOSNV Allow NULL? 
63VKBURSales Officenvarchar40CHAR(N' ')YesTVBURVKBUR Allow NULL? 
64VKGRPSales Groupnvarchar30CHAR(N' ')YesTVKGRVKGRP Allow NULL? 
65VRKMESales unitnvarchar30UNIT(N' ')YesT006VRKME Allow NULL? 
66WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
67POSARIS-M: Order-Publishing-Media - Item Typenvarchar20CHAR(N' ')YesTJH17AVMPOS_ART Allow NULL? 
68PRODHIS-M/AM: Product Hierarchynvarchar180CHAR(N' ')YesJJT179J_PRODH Allow NULL? 
69PSTYVIS-M: Item Category for Sales Documentnvarchar40CHAR(N' ')YesTJHAPPSTYV_PAM Allow NULL? 
70TAXM1Tax classification materialchar10CHAR(N' ')Yes*TAXM1 Allow NULL? 
71TAXM2Tax classification 2 for materialchar10CHAR(N' ')Yes*TAXM2 Allow NULL? 
72TAXM3Tax classification 3 for materialchar10CHAR(N' ')Yes*TAXM3 Allow NULL? 
73TAXM4Tax Classification 4 Materialchar10CHAR(N' ')Yes*TAXM4 Allow NULL? 
74TAXM5Tax classification 5 for materialchar10CHAR(N' ')Yes*TAXM5 Allow NULL? 
75TAXM6Tax classification 6 for materialchar10CHAR(N' ')Yes*TAXM6 Allow NULL? 
76TAXM7Tax classification 7 for materialchar10CHAR(N' ')Yes*TAXM7 Allow NULL? 
77TAXM8Tax Classification 8 Materialchar10CHAR(N' ')Yes*TAXM8 Allow NULL? 
78TAXM9Tax Classification 9 Materialchar10CHAR(N' ')Yes*TAXM9 Allow NULL? 
79GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
80AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
81KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
82PRCTRProfit Centernvarchar100CHAR(N' ')YesCEPCPRCTR Allow NULL? 
83RK_AUFNROrder Number of RK Order for Account Assignmentnvarchar80CHAR(N' ')YesJ_RK_AUFNR Allow NULL? 
84RK_POSNRItem Number of RK Order for Account Assignmentnvarchar20NUMC(N'00')YesJ_RK_POSNR Allow NULL? 
85KOSTL_R2Cost center in R/2nvarchar80CHAR(N' ')YesKOSTL_R2 Allow NULL? 
86STGRBIS-M: BU Grouping for Statisticsnvarchar40CHAR(N' ')YesTJJ67BEGRP_STAT Allow NULL? 
87STAFOIS-M: Update group for statistics updatenvarchar60CHAR(N' ')YesTMCBJHSTAFO Allow NULL? 
88SKTOFCash discount indicatorchar10CHAR(N' ')YesSKTOF Allow NULL? 
89RRRELIS-M/AM: Revenue Recognition Categorychar10CHAR(N' ')YesISMRR_RELTYP Allow NULL? 
90RRSTAchar10(N' ')Yes Allow NULL? 
91CAMPAIGNIS-M: Marketing Campaignvarbinary160RAWYesISM_MARKETING_CAMPAIGN
92PACKAGE_IDPackagenvarchar100CHAR(N' ')YesJJTPCISM_PACKAGE_ID Allow NULL? 
93PK_REF_AVM_NROrder Number for Package Reference Ordernvarchar100CHAR(N' ')Yes*ISM_PK_REF_AVM_NR Allow NULL? 
94PK_REF_POS_NRItem Number of Package Item to be Referencednvarchar30NUMC(N'000')Yes*ISM_PK_REF_POS_NR Allow NULL? 
95ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
96ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
97ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
98AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
99AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
100AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
101KUNAGBusiness Partner: Sold-to Partynvarchar100CHAR(N' ')YesJGTGPNRGPAG Allow NULL? 
102ELANDCountry of Destinationnvarchar30CHAR(N' ')YesT005LLAND Allow NULL? 
103POSPAItem number in the partner segmentnvarchar60NUMC(N'000000')Yes*POSPA Allow NULL? 
104PLTYP_AUFTPrice list type of sales ordernvarchar20CHAR(N' ')Yes*PLTYP_AUFT Allow NULL? 
105MPROKStatus manual price changechar10CHAR(N' ')YesMPROK Allow NULL? 
106KOWRRStatistical valueschar10CHAR(N' ')YesKOWRR Allow NULL? 
107BONBARebate basis 1decimal132CURR((0))YesBONBA
108KZWI1Subtotal 1 from pricing procedure for conditiondecimal132CURR((0))YesKZWI1
109KZWI2Subtotal 2 from pricing procedure for conditiondecimal132CURR((0))YesKZWI2
110KZWI3Subtotal 3 from pricing procedure for conditiondecimal132CURR((0))YesKZWI3
111KZWI4Subtotal 4 from pricing procedure for conditiondecimal132CURR((0))YesKZWI4
112KZWI5Subtotal 5 from pricing procedure for conditiondecimal132CURR((0))YesKZWI5
113KZWI6Subtotal 6 from pricing procedure for conditiondecimal132CURR((0))YesKZWI6
114WAVWRCost in document currencydecimal132CURR((0))YesWAVWR
115SKFBPAmount eligible for cash discount in document currencydecimal132CURR((0))YesSKFBP
116BRTWPIS-M: Gross Value in Document Currency (Item)decimal152CURR((0))YesJHBRTWRP
117NETWPNet value of the billing item in document currencydecimal152CURR((0))YesNETWR_FP
118MWSBPTax amount in document currencydecimal132CURR((0))YesMWSBP
119CMPREdecimal110((0))Yes
120CMPRE_FLTItem credit pricefloat1516FLTP((0))NoCMPRE_FLT
121UVPRSIncomplete with Regard to Pricingchar10CHAR(N' ')YesISM_UVPRS Allow NULL? 
122UVALLIS-M: Generally incompletechar10CHAR(N' ')YesJHUVALL Allow NULL? 
123XERLVIS-M: Revenue Distribution Statuschar10CHAR(N' ')YesJHXERLV Allow NULL? 
124XPEABIS-M: Period end accrual performed indicatorchar10CHAR(N' ')YesJHXPEAB Allow NULL? 
125TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
126UMVKZNumerator (factor) for conversion of sales quantity into SKUdecimal50DEC((0))YesUMVKZ
127UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUdecimal50DEC((0))YesUMVKN
128STCURExchange rate for statistics (Exch.rate at time of creation)decimal95DEC((0))YesSTCUR_AP
129PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
130KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
131ZUONRIS-M: Assignment number in FI documentnvarchar180CHAR(N' ')YesJHZUONR Allow NULL? 
132KOUPDCondition updatechar10CHAR(N' ')YesKOUPD Allow NULL? 
133XCNCLIS-M/AM: Reversal Indicator for Billing Itemchar10CHAR(N' ')NoJH_XCNCL Allow NULL? 
134BEDNRIS-M: Number of Media Sales Agent Contract Requirementnvarchar60NUMC(N'000000')YesJJTVBVM_BEDNR Allow NULL? 
135PROVTYPIS-M/AM: Commission Categorychar10CHAR(N' ')YesPROVTYP Allow NULL? 
136VZUONRIS-M/AM: Sales Agent Assignment Number (Corrections)nvarchar20NUMC(N'00')No*JH_VZUONR Allow NULL? 
137BERARTIS-M/AM: Calculation Type for Media Sales Agent Commissionchar10CHAR(N' ')YesJBERART Allow NULL? 
138PBSCHLIS-M/AM: Commission Key for Media Sales Agentnvarchar50CHAR(N' ')YesTJH23JPROVSCHL Allow NULL? 
139SCBASIS-M/AM: Scale Base Value for Commission Keychar10CHAR(N' ')NoJHSCBAS Allow NULL? 
140VERMARTIS-M: Media Sales Agent Type: General/City/Special Agentnvarchar20CHAR(N' ')YesTJJ09JVERMART Allow NULL? 
141PR_BETRAGIS-M: Sales Agent Share of Commission (in %)decimal73DEC((0))YesVPROZP
142PBBASISIS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)decimal132CURR((0))YesJPBBASIS
143ISPBEDARTIS-M/AM: Requirement Type in Media Sales Agent Contractnvarchar20CHAR(N' ')Yes*VMBEDART Allow NULL? 
144ALANDDeparture country (country from which the goods are sent)nvarchar30CHAR(N' ')YesT005ALAND Allow NULL? 
145XSTEIGIS-M: Can be Incremented Indicatorchar10CHAR(N' ')YesXJSTEIG Allow NULL? 
146VKORG_AUFTIS-M: Sales Organization for Customer Ordernvarchar40CHAR(N' ')YesTVKOJHVKORGAUF Allow NULL? 
147EPROZIS-M: Percentage rate from rev.distributed billing itemdecimal85DEC((0))YesISPPROZERL
148NETWPVNet value of the billing item in document currencydecimal152CURR((0))YesNETWR_FP
149KTGRPAccount assignment grouping for editionnvarchar20CHAR(N' ')YesTVKMJPVAKNTGRP Allow NULL? 
NamePrimaryUniqueTypeColumns
JHTFP~0YesYesCLUSTEREDPOSNR, VBELN, MANDT
JHTFP~ANoNoNONCLUSTEREDAUGRP, AUPOS, AUBEL