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  | JFRP
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.0JFRP1483IS-M/SD: Billing Document - Item 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, POSNR, FKIMG, VRKME, MEINS, GSBER, PRSDT, FBUDA, KURSK, NETWR, MATKL, SPART, POSPA, WERKS, ALAND, WKREG, WKCOU, WKCTY, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, SKTOF, SKFBP, SPARA, SHKZG, ERNAM, ERDAT, ERZET, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, STCUR, UVPRS, TXJCD, ISPAUART, ISPAUAGRP, ISPKOSTL_L, ISPDRERZ, ISPPVA, ISPBEZ, ISPLIFART, ISPDRUCK, ISPGUTSCH, ISPXLOGO, ISPPVAKNTG, ISPPVAKONG, ISPPVABONG, ISPFKPER, ISPPERFK, ISPZAHLW, ISPPOSEX, ISPJPERIOD, ISPVBELN, ISPPOSNR, ISPETENR, ISPETEEX, ISPETART, ISPETMENGE, ISPETMEINS, ISPETVOR, ISPKPOSN, ISPPRBAS, ISPPRSPER, ISPBZPERF, ISPPRSMLT, ISPPRSDIV, ISPAEART, ISPANZET, ISPERSDAT, ISPWRBAKT, ISPFAKVON, ISPFAKBIS, ISPKONDA, ISPKDGRP, ISPPOART, ISPPRSANTZ, ISPPRSANTN, ISPPRSANZP, ISPBRTWR_P, ISPPRBAS_V, ISPLAGRP_V, ISPXFKKOMP, ISPXFKENDE, ISPSFPOS, ISPXKOMPP, ISPVERSDAT, ISPLANDE, ISPRKAUFNR, ISPRKPOSNR, ISPCOAUFNR, ISPVAUSGB, ISPXFKBALF, ISPXFKBAAU, ISPVKBURZU, ISPXSTABGR, ISPXIMMAT, ISPIMMATD, ISPXFKRUEK, ISPIVWKN, ISPXIVW, ISPJKPAVRG, ISPJKPABRG, XNEGOPTION, IVWDATUM, CAMPAIGN, ISPBDPER, FKPERVON, FKPERBIS, ISPZSKLS, ISPWRBART, POSNR_UR, CYCLENR, FAKNRRUECK, XFIXED, RCODE, XAUTO_REN, STBFREI, XNFAK, DELIVSPLIT, DELIVSPLITGRP, POSNR_MAIN, POSNR_SUB, X_MONTAG, X_DIENSTAG, X_MITTWOCH, X_DONNETAG, X_FREITAG, X_SAMSTAG, X_SONNTAG, VBELN_FROM, POSNR_UR_FROM, CYCLENR_FROM, XPRICEALTER, REFUNDTYPE, XAUTO_ACCEPT, BONUSTYPE FROM JFRP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNIS-M/SD: Billing Documentnvarchar100CHAR(N' ')NoJFRKISPVBELN Allow NULL? 
3POSNRIS-M: Billing Itemnvarchar60NUMC(N'000000')NoISPPOSNR Allow NULL? 
4FKIMGActual Invoiced Quantitydecimal133QUAN((0))NoFKIMG
5VRKMESales unitnvarchar30UNIT(N' ')NoT006VRKME Allow NULL? 
6MEINSBase Unit of Measurenvarchar30UNIT(N' ')NoT006MEINS Allow NULL? 
7GSBERBusiness Areanvarchar40CHAR(N' ')NoTGSBGSBER Allow NULL? 
8PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')NoPRSDT Allow NULL? 
9FBUDADate on which services renderednvarchar80DATS(N'00000000')NoFBUDA Allow NULL? 
10KURSKExchange Rate for Price Determinationdecimal95DEC((0))NoKURSK
11NETWRNet value of the billing item in document currencydecimal152CURR((0))NoNETWR_FP
12MATKLMaterial Groupnvarchar90CHAR(N' ')NoT023MATKL Allow NULL? 
13SPARTDivisionnvarchar20CHAR(N' ')NoTSPASPART Allow NULL? 
14POSPAIS-M: Item Number of Partner Segmentnvarchar60NUMC(N'000000')NoJFRPISPPOSPA Allow NULL? 
15WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
16ALANDDeparture country (country from which the goods are sent)nvarchar30CHAR(N' ')NoT005ALAND Allow NULL? 
17WKREGRegion in which plant is locatednvarchar30CHAR(N' ')NoT005SWKREG Allow NULL? 
18WKCOUCounty in which plant is locatednvarchar30CHAR(N' ')NoWKCOU Allow NULL? 
19WKCTYCity in which plant is locatednvarchar40CHAR(N' ')NoWKCTY Allow NULL? 
20TAXM1Tax classification materialchar10CHAR(N' ')No*TAXM1 Allow NULL? 
21TAXM2Tax classification 2 for materialchar10CHAR(N' ')No*TAXM2 Allow NULL? 
22TAXM3Tax classification 3 for materialchar10CHAR(N' ')No*TAXM3 Allow NULL? 
23TAXM4Tax Classification 4 Materialchar10CHAR(N' ')No*TAXM4 Allow NULL? 
24TAXM5Tax classification 5 for materialchar10CHAR(N' ')No*TAXM5 Allow NULL? 
25TAXM6Tax classification 6 for materialchar10CHAR(N' ')No*TAXM6 Allow NULL? 
26TAXM7Tax classification 7 for materialchar10CHAR(N' ')No*TAXM7 Allow NULL? 
27TAXM8Tax Classification 8 Materialchar10CHAR(N' ')No*TAXM8 Allow NULL? 
28TAXM9Tax Classification 9 Materialchar10CHAR(N' ')No*TAXM9 Allow NULL? 
29SKTOFCash discount indicatorchar10CHAR(N' ')NoSKTOF Allow NULL? 
30SKFBPAmount eligible for cash discount in document currencydecimal132CURR((0))NoSKFBP
31SPARADivision for order headernvarchar20CHAR(N' ')NoTSPASPART_AK Allow NULL? 
32SHKZGReturns Itemchar10CHAR(N' ')NoSHKZG_VA Allow NULL? 
33ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
34ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
35ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
36STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')No*STAFO Allow NULL? 
37WAVWRCost in document currencydecimal132CURR((0))NoWAVWR
38KZWI1Subtotal 1 from pricing procedure for conditiondecimal132CURR((0))NoKZWI1
39KZWI2Subtotal 2 from pricing procedure for conditiondecimal132CURR((0))NoKZWI2
40KZWI3Subtotal 3 from pricing procedure for conditiondecimal132CURR((0))NoKZWI3
41KZWI4Subtotal 4 from pricing procedure for conditiondecimal132CURR((0))NoKZWI4
42KZWI5Subtotal 5 from pricing procedure for conditiondecimal132CURR((0))NoKZWI5
43KZWI6Subtotal 6 from pricing procedure for conditiondecimal132CURR((0))NoKZWI6
44STCURExchange rate for statistics (Exch.rate at time of creation)decimal95DEC((0))NoSTCUR_AP
45UVPRSIncomplete with respect to pricingchar10CHAR(N' ')NoUVPRS Allow NULL? 
46TXJCDTax Jurisdictionnvarchar150CHAR(N' ')No*TXJCD Allow NULL? 
47ISPAUARTIS-M/SD: Sales Document Typesnvarchar40CHAR(N' ')NoTJAKAUART_ISP Allow NULL? 
48ISPAUAGRPIS-M: Sales Document Type Grouping for Sales Orderchar10CHAR(N' ')NoISPAUAGRP Allow NULL? 
49ISPKOSTL_LIS-M: Cost Center to be Chargednvarchar100CHAR(N' ')No*ISPKOSTL_L Allow NULL? 
50ISPDRERZPublicationnvarchar80CHAR(N' ')NoJDTDRERDRERZ Allow NULL? 
51ISPPVAEditionnvarchar80CHAR(N' ')NoJDTPVAPVA Allow NULL? 
52ISPBEZMix Typenvarchar20CHAR(N' ')NoJDTBEZTYPBEZUGSTYP_JE_PVA Allow NULL? 
53ISPLIFARTDelivery Typenvarchar20CHAR(N' ')NoTJV01LIEFERART Allow NULL? 
54ISPDRUCKIS-M: Plant (Printing Works)nvarchar40CHAR(N' ')NoT001WISPDRUCK Allow NULL? 
55ISPGUTSCHIS-M: Coupon Numbernvarchar80NUMC(N'00000000')NoISPGUTSCH Allow NULL? 
56ISPXLOGOPrint Logochar10CHAR(N' ')NoXLOGO Allow NULL? 
57ISPPVAKNTGIS-M: Account Assignment Grouping for Editionnvarchar20CHAR(N' ')NoTVKMISPPVAKNTG Allow NULL? 
58ISPPVAKONGIS-M: Edition Condition Groupingnvarchar20CHAR(N' ')NoT178ISPPVAKONG Allow NULL? 
59ISPPVABONGIS-M: Bonus Grouping for Editionnvarchar20CHAR(N' ')NoTVBOISPPVABONG Allow NULL? 
60ISPFKPERBilling Frequencynvarchar20CHAR(N' ')NoTJK01FKPER Allow NULL? 
61ISPPERFKInvoice dates (calendar identification)nvarchar20CHAR(N' ')NoTFACDPERFK Allow NULL? 
62ISPZAHLWBilling methodchar10CHAR(N' ')NoJZAHLW Allow NULL? 
63ISPPOSEXExternal Item Number (Purchase Order Item)nvarchar60NUMC(N'000000')NoPOSEX_ISP Allow NULL? 
64ISPJPERIODIS-M: Periodic settlementchar10CHAR(N' ')NoJPERIOD Allow NULL? 
65ISPVBELNIS-M/SD: Publishing Sales Ordernvarchar100CHAR(N' ')NoJKAKAVNR Allow NULL? 
66ISPPOSNRSales Order Itemnvarchar60NUMC(N'000000')NoJKAPAPNR Allow NULL? 
67ISPETENRSales Order Schedule Linenvarchar40NUMC(N'0000')NoJKEPJAENR Allow NULL? 
68ISPETEEXIS-M: External Schedule Line Numbernvarchar60NUMC(N'000000')NoETEEX_ISP Allow NULL? 
69ISPETARTSchedule Line Type for Internal Sales Order Schedule Linenvarchar20CHAR(N' ')NoTJEPETART_ISP Allow NULL? 
70ISPETMENGEIS-M: Sales Order Schedule Line Quantitydecimal100QUAN((0))NoETMENGE
71ISPETMEINSIS-M: Sales Unit for Sales Ordernvarchar30UNIT(N' ')NoT006ETMEINS Allow NULL? 
72ISPETVORIS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Orderchar10CHAR(N' ')NoISPETVOR Allow NULL? 
73ISPKPOSNCondition item numbernvarchar60NUMC(N'000000')NoKPOSN Allow NULL? 
74ISPPRBASIS-M: Price Basischar10CHAR(N' ')NoISPPRBAS Allow NULL? 
75ISPPRSPERIS-M: Price Frequencynvarchar20CHAR(N' ')NoTJK03ISPPRSPER Allow NULL? 
76ISPBZPERFIS-M: Service Type for Billingnvarchar50CHAR(N' ')NoTJD09ISPBZPERF Allow NULL? 
77ISPPRSMLTIS-M: Numerator in Conversion Factor for Frequenciesdecimal50DEC((0))NoISPPRSMLT
78ISPPRSDIVIS-M: Denominator for Frequency Conversion Factordecimal50DEC((0))NoISPPRSDIV
79ISPAEARTIS-M: Order Change Typechar10CHAR(N' ')NoISPAEART Allow NULL? 
80ISPANZETIS-M: Number of Publication Datesdecimal50DEC((0))NoISPANZET
81ISPERSDATPublication Datenvarchar80DATS(N'00000000')NoERSCHDAT Allow NULL? 
82ISPWRBAKTSales Promotionnvarchar80CHAR(N' ')NoTJWAKWERBEAKT Allow NULL? 
83ISPFAKVONIS-M: Billing Period Fromnvarchar80DATS(N'00000000')NoFAKVON Allow NULL? 
84ISPFAKBISIS-M: Billing Period Tonvarchar80DATS(N'00000000')NoFAKBIS Allow NULL? 
85ISPKONDAPrice group (customer)nvarchar20CHAR(N' ')NoT188KONDA Allow NULL? 
86ISPKDGRPCustomer groupnvarchar20CHAR(N' ')NoT151KDGRP Allow NULL? 
87ISPPOARTInternal Item Type for Sales Ordernvarchar20CHAR(N' ')NoTJAPPOART_ISP Allow NULL? 
88ISPPRSANTZIS-M: Numerator for proportional pricesdecimal80DEC((0))NoPRSANTZ
89ISPPRSANTNIS-M: Denominator for proportional pricesdecimal80DEC((0))NoPRSANTN
90ISPPRSANZPIS-M: Number of periods in billing perioddecimal80DEC((0))NoPRSANZP
91ISPBRTWR_PIS-M: Gross Value in Document Currencydecimal152CURR((0))NoISPBRTWR
92ISPPRBAS_VPrice Basis for Shipping Costschar10CHAR(N' ')NoPRBAS_VK Allow NULL? 
93ISPLAGRP_VCountry grouping for shipping costsnvarchar20CHAR(N' ')NoTJG92LANDGRP_VK Allow NULL? 
94ISPXFKKOMPIndicator: Perform Billing in Full for Billing Periodchar10CHAR(N' ')NoXFKKOMP Allow NULL? 
95ISPXFKENDEIndicator: Billing at end of calculationchar10CHAR(N' ')NoXFKENDE Allow NULL? 
96ISPSFPOSSeparate billing document for order itemchar10CHAR(N' ')NoXSEPFKPOS Allow NULL? 
97ISPXKOMPPIS-M: Full period (billing)char10CHAR(N' ')NoXKOMPP Allow NULL? 
98ISPVERSDATIS-M: Shipping Datenvarchar80DATS(N'00000000')NoVRSNDDATUM Allow NULL? 
99ISPLANDECurrent country being suppliednvarchar30CHAR(N' ')No*LANDE_ISP Allow NULL? 
100ISPRKAUFNROrder Number of RK Order for Account Assignmentnvarchar80CHAR(N' ')NoJ_RK_AUFNR Allow NULL? 
101ISPRKPOSNRItem Number of RK Order for Account Assignmentnvarchar20NUMC(N'00')NoJ_RK_POSNR Allow NULL? 
102ISPCOAUFNROrder number of internal CO order for account assignmentnvarchar120CHAR(N' ')NoAUFKJ_CO_AUFNR Allow NULL? 
103ISPVAUSGBIssuenvarchar100CHAR(N' ')NoJDTVAUSGBVAUSGB Allow NULL? 
104ISPXFKBALFIS-M: Billing based on deliverychar10CHAR(N' ')NoXFKBASLIEF Allow NULL? 
105ISPXFKBAAUIS-M: Billing based on orderchar10CHAR(N' ')NoXFKBASAUFT Allow NULL? 
106ISPVKBURZUSales office responsiblenvarchar40CHAR(N' ')No*VKBURZUS Allow NULL? 
107ISPXSTABGRVAT to be accrued proportionally for payment in billingchar10CHAR(N' ')NoJXMWSTABGR Allow NULL? 
108ISPXIMMATIndicator: Proof of matriculation providedchar10CHAR(N' ')NoXIMMATRIK Allow NULL? 
109ISPIMMATDMatriculation Certificate Valid Tonvarchar80DATS(N'00000000')NoIMMATDAT Allow NULL? 
110ISPXFKRUEKIS-M: Retroactive Billing of Period Already Billedchar10CHAR(N' ')NoXFKRUECK Allow NULL? 
111ISPIVWKNCirculation Audit Report Category IDnvarchar80CHAR(N' ')No*IVWKN Allow NULL? 
112ISPXIVWIndicator: Relevant for audit reportchar10CHAR(N' ')NoXIVW Allow NULL? 
113ISPJKPAVRGNormal Start of Address Validity for Retro.Order Itemsnvarchar80DATS(N'00000000')NoJKPAVONREG Allow NULL? 
114ISPJKPABRGEnd of Address Validity if End of Billing Delayednvarchar80DATS(N'00000000')NoJKPABISREG Allow NULL? 
115XNEGOPTIONIS-M: Item with Automatic Transformation to Chargeablechar10CHAR(N' ')NoXNEGOPTION Allow NULL? 
116IVWDATUMDate of Audit Report for Returnsnvarchar80DATS(N'00000000')NoIVWDATUM Allow NULL? 
117CAMPAIGNIS-M: Marketing Campaignvarbinary160RAWNoISM_MARKETING_CAMPAIGN
118ISPBDPERIS-M: Basic Date for Billing Frequencynvarchar80DATS(N'00000000')YesBDPER Allow NULL? 
119FKPERVONIS-M: Initial Date of Full Billing Periodnvarchar80DATS(N'00000000')NoFKPERVON Allow NULL? 
120FKPERBISIS-M: Closing Date of Full Billing Periodnvarchar80DATS(N'00000000')NoFKPERBIS Allow NULL? 
121ISPZSKLSTime slice classification for sales orderchar10CHAR(N' ')YesJZSKLS Allow NULL? 
122ISPWRBARTSales Sourcenvarchar40CHAR(N' ')YesTJWARWERBEART Allow NULL? 
123POSNR_UROriginal Item in Publishing Sales Ordernvarchar60NUMC(N'000000')No*APNR_UR Allow NULL? 
124CYCLENRIS-M/SD: Billing Cycle Numbernvarchar30NUMC(N'000')No*CYCLENR Allow NULL? 
125FAKNRRUECKIS-M: Recalculated Billing Documentnvarchar100CHAR(N' ')No*ISPFAKNRRUECK Allow NULL? 
126XFIXEDIndicator: Billing Index Fixed and Cannot be Deletedchar10CHAR(N' ')NoXINDEXFIXED Allow NULL? 
127RCODEIS-M/SD: Rate Codenvarchar40CHAR(N' ')No*RATE_CODE Allow NULL? 
128XAUTO_RENIS-M/SD: Customer Requests Automatic Renewalchar10CHAR(N' ')NoXAUTO_REN Allow NULL? 
129STBFREIType of Tax Exemptionnvarchar20CHAR(N' ')NoTJFSBJSTBFREI Allow NULL? 
130XNFAKIS-M: Indicator - Repeat Billing After Reversalchar10CHAR(N' ')NoISPXNFAK Allow NULL? 
131DELIVSPLITIS-M/SD: Alternating Address Elementnvarchar80CHAR(N' ')NoTJD23DELIVSPLIT Allow NULL? 
132DELIVSPLITGRPIS-M/SD: Address Alternation Groupnvarchar100CHAR(N' ')NoTJD63DELIVSPLITGRP Allow NULL? 
133POSNR_MAINIS-M/SD: Main Item in Sales Ordernvarchar60NUMC(N'000000')NoJKAPAPNR_MAIN Allow NULL? 
134POSNR_SUBIS-M/SD: Sub-Item in Sales Ordernvarchar60NUMC(N'000000')NoJKAPAPNR_SUB Allow NULL? 
135X_MONTAGIS-M: Mondaychar10CHAR(N' ')NoX_MONTAG Allow NULL? 
136X_DIENSTAGIS-M: Tuesdaychar10CHAR(N' ')NoX_DIENSTAG Allow NULL? 
137X_MITTWOCHIS-M: Wednesdaychar10CHAR(N' ')NoX_MITTWOCH Allow NULL? 
138X_DONNETAGIS-M: Thursdaychar10CHAR(N' ')NoX_DONNETAG Allow NULL? 
139X_FREITAGIS-M: Fridaychar10CHAR(N' ')NoX_FREITAG Allow NULL? 
140X_SAMSTAGIS-M: Saturdaychar10CHAR(N' ')NoX_SAMSTAG Allow NULL? 
141X_SONNTAGIS-M: Sundaychar10CHAR(N' ')NoX_SONNTAG Allow NULL? 
142VBELN_FROMIS-M/SD: Publishing Sales Ordernvarchar100CHAR(N' ')No*AVNR Allow NULL? 
143POSNR_UR_FROMSales Order Itemnvarchar60NUMC(N'000000')No*APNR Allow NULL? 
144CYCLENR_FROMIS-M/SD: Billing Cycle Numbernvarchar30NUMC(N'000')No*CYCLENR Allow NULL? 
145XPRICEALTERIndicator: Generated Index for Price Changechar10CHAR(N' ')NoXPRICEALTERNATION Allow NULL? 
146REFUNDTYPEIS-M/SD: Refund Typenvarchar20CHAR(N' ')YesTJK19REFUNDTYPE Allow NULL? 
147XAUTO_ACCEPTIS-M/SD: Indicator - Accept Cycle Without Paymentchar10CHAR(N' ')YesXAUTO_ACCEPT Allow NULL? 
148BONUSTYPEIS-M/SD: Bonus Typenvarchar20CHAR(N' ')YesJBONUSTYPE Allow NULL? 
NamePrimaryUniqueTypeColumns
JFRP~0YesYesCLUSTEREDPOSNR, VBELN, MANDT
JFRP~1NoNoNONCLUSTEREDISPETENR, ISPPOSNR, ISPVBELN
JFRP~4NoNoNONCLUSTEREDISPFAKBIS, ISPPVA, ISPDRERZ

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