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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DFKKMOP1485Items in contract account documentContract Accounts Receivable and Payable
SQL:  selectupdate insert create

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

SELECT MANDT, OPBEL, OPUPW, OPUPK, OPUPZ, BUKRS, GSBER, BUPLA, SEGMENT, PRCTR, AUGST, GPART, VTREF, VTPOS, VTRE2, VKONT, ABWBL, ABWTP, ABWKT, APPLK, HVORG, TVORG, KOFIZ, SPART, HKONT, MWSKZ, MWSZKZ, XANZA, STAKZ, BLDAT, BUDAT, OPTXT, WAERS, FAEDN, FAEDS, VERKZ, STUDT, SKTPZ, XMANL, KURSF, BETRH, BETRW, BETR2, BETR3, SKFBT, SBETH, SBETW, SBET2, SBET3, MWSKO, MWVKO, TXRUL, SPZAH, PYMET, PYBUK, PERNR, GRKEY, PERSL, XAESP, AUGDT, AUGBL, AUGBD, AUGRD, AUGWA, AUGBT, AUGBS, AUGSK, AUGVD, AUGOB, WHANG, WHGRP, XEIPH, MAHNV, MANSP, XAUGP, ABRZU, ABRZO, FDGRP, FDLEV, FDZTG, FDWBT, XTAUS, AUGRS, PYGRP, PDTYP, SPERZ, INFOZ, TXJCD, TXDAT, VBUND, KONTT, KONTL, OPSTA, BLART, EMGPA, EMBVT, EMADR, IKEY, EUROU, XRAGL, ASTKZ, ASBLG, XBLNR, INKPS, RNDPS, QSSKZ, QSSEW, QSPTP, QSSHB, QBSHB, QSPRZ, QSZNR, XWHEX, RFUPK, STRKZ, FITPR, XPYOR, LANDL, INTBU, EMCRD, C4EYE, C4EYP, TXGRP, SCTAX, STTAX, STZAL, ORUPZ, NEGBU, SUBAP, PSWSL, PSWBT, PSWTX, PSGRP, XCOLC, AASTA, XCSHA, REACC, REBUK, XUSTPD, PTITM, EMMND, PNNUM, PNHKF, PNEXD, PNCTR, FINRE, RDSTA, RDSTB FROM DFKKMOP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')No*OPBEL_KK Allow NULL? 
3OPUPWRepetition Item in Contract Account Documentnvarchar30NUMC(N'000')NoOPUPW_KK Allow NULL? 
4OPUPKItem number in contract account documentnvarchar40NUMC(N'0000')NoOPUPK_KK Allow NULL? 
5OPUPZSubitem for a Partial Clearing in Documentnvarchar30NUMC(N'000')NoOPUPZ_KK Allow NULL? 
6BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
7GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
8BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
9SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*SEGMT_KK Allow NULL? 
10PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
11AUGSTClearing statuschar10CHAR(N' ')YesAUGST_KK Allow NULL? 
12GPARTBusiness Partner Numbernvarchar100CHAR(N' ')Yes*GPART_KK Allow NULL? 
13VTREFReference Specifications from Contractnvarchar200CHAR(N' ')YesVTREF_KK Allow NULL? 
14VTPOSContract: Item Numbernvarchar60NUMC(N'000000')YesVTPOS_KK Allow NULL? 
15VTRE2Additional Reference Informationnvarchar200CHAR(N' ')YesVTRE2_KK Allow NULL? 
16VKONTContract Account Numbernvarchar120CHAR(N' ')Yes*VKONT_KK Allow NULL? 
17ABWBLNumber of the substitute FI-CA documentnvarchar120CHAR(N' ')YesABWBL_KK Allow NULL? 
18ABWTPCategory of substitute document in FI-CAchar10CHAR(N' ')YesABWTP_KK Allow NULL? 
19ABWKTAlternative contract account for collective billsnvarchar120CHAR(N' ')Yes*ABWVK_KK Allow NULL? 
20APPLKApplication areachar10CHAR(N' ')YesAPPLK_KK Allow NULL? 
21HVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')Yes*HVORG_KK Allow NULL? 
22TVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')Yes*TVORG_KK Allow NULL? 
23KOFIZAccount Determination IDnvarchar20CHAR(N' ')YesKOFIZ_KK Allow NULL? 
24SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART_KK Allow NULL? 
25HKONTGeneral ledger accountnvarchar100CHAR(N' ')Yes*HKONT_KK Allow NULL? 
26MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
27MWSZKZSupplementary Taxnvarchar20CHAR(N' ')Yes*MWSZKZ_KK Allow NULL? 
28XANZAItem is a Down Payment/Down Payment Requestchar10CHAR(N' ')YesXANZA_KK Allow NULL? 
29STAKZType of statistical itemchar10CHAR(N' ')YesSTAKZ_KK Allow NULL? 
30BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
31BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
32OPTXTItem textnvarchar500CHAR(N' ')YesOPTXT_KK Allow NULL? 
33WAERSTransaction Currencynvarchar50CUKY(N' ')Yes*BLWAE_KK Allow NULL? 
34FAEDNDue date for net paymentnvarchar80DATS(N'00000000')YesFAEDN_KK Allow NULL? 
35FAEDSDue Date for Cash Discountnvarchar80DATS(N'00000000')YesFAEDS_KK Allow NULL? 
36VERKZItem Can Only Be Clearedchar10CHAR(N' ')YesVERKZ_KK Allow NULL? 
37STUDTDeferral tonvarchar80DATS(N'00000000')YesSTUDT_KK Allow NULL? 
38SKTPZCash discount ratedecimal53DEC((0))YesSKTPZ_KK
39XMANLExclude Item from Dunning Runchar10CHAR(N' ')YesXMANL_KK Allow NULL? 
40KURSFExchange ratedecimal95DEC((0))YesKURSF_KK
41BETRHAmount In Local Currency With +/- Signsdecimal132CURR((0))YesBETRH_KK
42BETRWAmount in Transaction Currency with +/- Signdecimal132CURR((0))YesBETRW_KK
43BETR2Amount in second parallel currency with +/- signdecimal132CURR((0))YesBETR2_KK
44BETR3Amount in third parallel currency with +/- signdecimal132CURR((0))YesBETR3_KK
45SKFBTAmount eligible for cash discount in document currencydecimal132CURR((0))YesSKFBT_KK
46SBETHTax Amount in Local Currency With +/- Signdecimal132CURR((0))YesSBETH_KK
47SBETWTax Amount in Transaction Currency with +/- Signdecimal132CURR((0))YesSBETW_KK
48SBET2Tax amount in second parallel currencydecimal132CURR((0))YesSBET2_KK
49SBET3Tax amount in third parallel currencydecimal132CURR((0))YesSBET3_KK
50MWSKOAccount for posting taxes for down paymentsnvarchar100CHAR(N' ')Yes*MWSKO_KK Allow NULL? 
51MWVKOAccount for offsetting tax posting in down paymentsnvarchar100CHAR(N' ')Yes*MWVKO_KK Allow NULL? 
52TXRULUpdate Rule for Tax and Tax Clearingchar10CHAR(N' ')YesTXRUL_KK Allow NULL? 
53SPZAHLock Reason for Automatic Paymentchar10CHAR(N' ')Yes*SPZAH_KK Allow NULL? 
54PYMETPayment Methodchar10CHAR(N' ')Yes*PYMET_KK Allow NULL? 
55PYBUKCompany Code for Automatic Payment Transactionsnvarchar40CHAR(N' ')Yes*PYBUK_KK Allow NULL? 
56PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
57GRKEYGrouping Key for Displaying Open Itemsnvarchar30CHAR(N' ')YesGRKEY_KK Allow NULL? 
58PERSLKey for Period Assignmentnvarchar40CHAR(N' ')Yes*PERSL_KK Allow NULL? 
59XAESPPrinting - No Changes Possiblechar10CHAR(N' ')YesXAESP_KK Allow NULL? 
60AUGDTClearing datenvarchar80DATS(N'00000000')YesAUGDT_KK Allow NULL? 
61AUGBLClearing Document or Printed Documentnvarchar120CHAR(N' ')YesAUGBL_KK Allow NULL? 
62AUGBDClearing document posting datenvarchar80DATS(N'00000000')YesAUGBD_KK Allow NULL? 
63AUGRDClearing Reasonnvarchar20CHAR(N' ')Yes*AUGRD_KK Allow NULL? 
64AUGWAClearing currencynvarchar50CUKY(N' ')Yes*AUGWA_KK Allow NULL? 
65AUGBTClearing amount in clearing currencydecimal132CURR((0))YesAUGBT_KK
66AUGBSTax amount in clearing currencydecimal132CURR((0))YesAUGBS_KK
67AUGSKCash Discount Granted/Surcharge Levied in Clearing Currencydecimal132CURR((0))YesAUGSK_KK
68AUGVDValue date for clearingnvarchar80DATS(N'00000000')YesAUGVD_KK Allow NULL? 
69AUGOBItem Canceledchar10CHAR(N' ')YesAUGOB_KK Allow NULL? 
70WHANGNumber of repetition itemsnvarchar30NUMC(N'000')YesWHANG_KK Allow NULL? 
71WHGRPRepetition groupnvarchar30NUMC(N'000')YesDFKKMOPWWHGRP_KK Allow NULL? 
72XEIPHCreate Line Item in General Ledgerchar10CHAR(N' ')YesXEIPH_KK Allow NULL? 
73MAHNVDunning Procedurenvarchar20CHAR(N' ')Yes*MAHNV_KK Allow NULL? 
74MANSPDunning Lock Reasonchar10CHAR(N' ')Yes*MANSP_KK Allow NULL? 
75XAUGPCheck Sample Record Clearingchar10CHAR(N' ')YesXAUGP_KK Allow NULL? 
76ABRZULower Limit of Settlement Periodnvarchar80DATS(N'00000000')YesABRZU_KK Allow NULL? 
77ABRZOUpper Limit of the Billing Periodnvarchar80DATS(N'00000000')YesABRZO_KK Allow NULL? 
78FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP_KK Allow NULL? 
79FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV_KK Allow NULL? 
80FDZTGAdditional Days for Cash Managementnvarchar20NUMC(N'00')YesFDZTG_KK Allow NULL? 
81FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
82XTAUSItem Splitchar10CHAR(N' ')YesXTAUS_KK Allow NULL? 
83AUGRSClearing restrictionchar10CHAR(N' ')YesAUGRS_KK Allow NULL? 
84PYGRPGrouping field for automatic paymentsnvarchar100CHAR(N' ')YesPYGRP_KK Allow NULL? 
85PDTYPCategory of Payment Specificationchar10CHAR(N' ')YesPDTYP_KK Allow NULL? 
86SPERZInterest Lock Reasonchar10CHAR(N' ')Yes*SPERZ_KK Allow NULL? 
87INFOZDoubtful Item Entry/Individual Value Adjustmentnvarchar30NUMC(N'000')YesINFOZ_KK Allow NULL? 
88TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
89TXDATDecisive Date for Calculating Taxesnvarchar80DATS(N'00000000')YesTXDAT_KK Allow NULL? 
90VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
91KONTTAccount Assignment Categorynvarchar20CHAR(N' ')Yes*KONTT_KK Allow NULL? 
92KONTLAcct assnmnt string for industry-specific account assngmentsnvarchar500CHAR(N' ')YesKONTL_KK Allow NULL? 
93OPSTADunning indicatornvarchar30CHAR(N' ')YesOPSTA_KK Allow NULL? 
94BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART_KK Allow NULL? 
95EMGPAAlternative Business Partner for Paymentsnvarchar100CHAR(N' ')Yes*EMGPA_KK Allow NULL? 
96EMBVTBank Details ID of Payeenvarchar40CHAR(N' ')YesEMBVT_KK Allow NULL? 
97EMADRAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
98IKEYInterest Keynvarchar20CHAR(N' ')Yes*IKEY_KK Allow NULL? 
99EUROUStatus of Euro Conversionchar10CHAR(N' ')YesEUROU_KK Allow NULL? 
100XRAGLClearing posting reversedchar10CHAR(N' ')YesXRAGL_KK Allow NULL? 
101ASTKZStatistical Key of the Initiating Itemchar10CHAR(N' ')YesASTKZ_KK Allow NULL? 
102ASBLGNumber of Triggering Documentnvarchar120CHAR(N' ')Yes*ASBLG_KK Allow NULL? 
103XBLNRReference document numbernvarchar160CHAR(N' ')YesXBLNR_KK Allow NULL? 
104INKPSCollection Itemnvarchar30NUMC(N'000')YesINKPS_KK Allow NULL? 
105RNDPSType of Rounding Itemchar10CHAR(N' ')YesRNDPS_KK Allow NULL? 
106QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
107QSSEWWithholding Tax Supplementnvarchar20CHAR(N' ')Yes*QSSEW_KK Allow NULL? 
108QSPTPLine Item Category From Withholding Tax Viewchar10CHAR(N' ')YesQSPTP_KK Allow NULL? 
109QSSHBTax Base Amountdecimal132CURR((0))YesQSSHB_KK
110QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB_KK
111QSPRZWithholding Tax Percentagenvarchar60NUMC(N'000000')YesQSPRZ_KK Allow NULL? 
112QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
113XWHEXVariable Withholding Tax in DFKKOPWHchar10CHAR(N' ')YesXWHEX_KK Allow NULL? 
114RFUPKReference Item In FI-CA Documentnvarchar40NUMC(N'0000')YesRFUPK_KK Allow NULL? 
115STRKZTax Code for Other Taxesnvarchar20CHAR(N' ')Yes*STRKZ_KK Allow NULL? 
116FITPRTax typenvarchar20CHAR(N' ')Yes*J_1AFITP_D Allow NULL? 
117XPYORItem Included in a Payment Orderchar10CHAR(N' ')YesXPYOR_KK Allow NULL? 
118LANDLCountry Supplied (for Tax Notifications)nvarchar30CHAR(N' ')Yes*LANDL_KK Allow NULL? 
119INTBUReason for Automatic Creation of Postingchar10CHAR(N' ')YesINTBU_KK Allow NULL? 
120EMCRDAlternative Payment Card ID in Documentnvarchar60CHAR(N' ')YesEMCRD_KK Allow NULL? 
121C4EYECheck Reason for Workflows Acc. to Dual Control Principlenvarchar20CHAR(N' ')Yes*C4EYE_KK Allow NULL? 
122C4EYPEditing Process To Be Confirmedchar10CHAR(N' ')YesC4EYP_KK Allow NULL? 
123TXGRPGrouping Key for Tax Itemsnvarchar60CHAR(N' ')YesTXGRP_KK Allow NULL? 
124SCTAXTax Portion in FI-CA Local Currencydecimal132CURR((0))YesSCTAX_KK
125STTAXTax Amount as Statistical Information in Document Currencydecimal132CURR((0))YesSTTAX_KK
126STZALStatus of Payment Processingchar10CHAR(N' ')YesSTZAL_KK Allow NULL? 
127ORUPZSubitem Number before Item Splitnvarchar30CHAR(N' ')YesORUPZ_KK Allow NULL? 
128NEGBUControl Field for Negative Postingchar10NUMC(N'0')YesNEGBU_KK Allow NULL? 
129SUBAPSubapplication in Contract Accounts Receivable and Payablechar10CHAR(N' ')YesSUBAP_KK Allow NULL? 
130PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')Yes*PSWSL_KK Allow NULL? 
131PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT_KK
132PSWTXTax Amount for Update in General Ledgerdecimal132CURR((0))YesPSWTX_KK
133PSGRPGrouping Key for Document Itemsnvarchar40CHAR(N' ')YesPSGRP_KK Allow NULL? 
134XCOLCItem Is Included in Collection Casechar10CHAR(N' ')YesXCOLC_KK Allow NULL? 
135AASTAControl Field for Account Assignment Distributionschar10CHAR(N' ')YesAASTA_KK Allow NULL? 
136XCSHADocument Contains Assignments from Cash Flowschar10CHAR(N' ')YesXCSHA_KK Allow NULL? 
137REACCOriginating Account in Cash Flow Anlaysisnvarchar100CHAR(N' ')Yes*REACC_KK Allow NULL? 
138REBUKPartner Company Code for Cash Flow Analysisnvarchar40CHAR(N' ')Yes*REBUK_KK Allow NULL? 
139XUSTPDTax on Sales/Purchases Was Calculated by Documentchar10CHAR(N' ')YesXUSTPD_KK Allow NULL? 
140PTITMStatus of Partner Settlement Using Billable Itemschar10CHAR(N' ')YesPTITM_KK Allow NULL? 
141EMMNDSEPA Mandate Identifiernvarchar60NUMC(N'000000')YesEMMND_KK Allow NULL? 
142PNNUMSEPA: Number of Direct Debit Pre-Notificationnvarchar160CHAR(N' ')YesPNNUM_KK Allow NULL? 
143PNHKFSEPA: Origin of Direct Debit Pre-Notificationnvarchar20CHAR(N' ')YesPNHKF_KK Allow NULL? 
144PNEXDSEPA: Date of Execution of Direct Debit Pre-Notifcationnvarchar80DATS(N'00000000')YesPNEXD_KK Allow NULL? 
145PNCTRSEPA: Requirement for a Pre-Notificationchar10CHAR(N' ')YesPNCTR_KK Allow NULL? 
146FINREContract Account of Final Recipientnvarchar120CHAR(N' ')Yes*FINRE_KK Allow NULL? 
147RDSTACurrent Distribution Statuschar10CHAR(N' ')YesRDSTA_KK Allow NULL? 
148RDSTBLast Distribution Status Reportedchar10CHAR(N' ')YesRDSTB_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
DFKKMOP~0YesYesCLUSTEREDOPUPZ, OPUPK, OPUPW, OPBEL, MANDT
DFKKMOP~1NoNoNONCLUSTEREDXMANL, BUKRS, GPART, AUGST, MANDT
DFKKMOP~2NoNoNONCLUSTEREDAUGBL, MANDT
DFKKMOP~3NoNoNONCLUSTEREDWHGRP, AUGST, ABWBL, MANDT
DFKKMOP~4NoNoNONCLUSTEREDAUGDT, BUKRS, VKONT, AUGST, MANDT