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  | KBLP
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
Financial Accounting :: Funds Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KBLP1161Document Item: Manual Document EntryFunds Management
SQL:  selectupdate insert create

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

SELECT MANDT, BELNR, BLPOS, VRGNG, ERFAS, ERDAT, AENDE, AEDAT, PTEXT, ERLKZ, ERLDAT, LOEKZ, WTGES, MENGE, MEINH, PREIS, PEINH, PRMEN, PRUMN, PRUMZ, KSTAR, FIPOS, AUFNR, KOSTL, PSPNR, FISTL, GEBER, FDATK, MATNR, LIFNR, ERLAR, ERL_PSPNR, XSENDER, XEMPFGR, AUFPL, APLZL, SKOSTL, SAUFNR, NPLNR, HWGES, WTABB, HWABB, CWTFREE, WTABG, HWABG, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, STATS, BLPKZ, CONSUMEKZ, UEBTO, ABGWAERS, WKAPP, CARRYOV, ACCHANG, LNRZA, REFBLTYP, REFBELNR, REFBLPOS, REFSETERLK, WTGESAPP, HWGESAPP, DELTAWTAPP, DELTAHWAPP, SAKNR, KUNNR, KURSUP, DATUP, WTFREE, HWFREE, EWSCOUNT, RFPOS, WTORIG, HWORIG, POSLOCK, PMACTIVE, FIPEX, FKBER, TOLOV, GRANT_NBR, GSBER, MEASURE, IMKEY, DABRZ, PEROP_BEG, PEROP_END, PPA_EX_IND, BUDGET_PD, PDATE, DATE_FROM, DATE_TO, FMFGUS_KEY, FM_SPLIT_BATCH, FM_SPLIT_BEGRU, VORNR, REVSUM, REVAPPSUM, EF_GROUP_NUMBER, MWSKZ, TXJCD, WMWST, MWSTS, NETBTR, NETHW, GROSBTR, GROSHW FROM KBLP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BELNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')NoKBLKKBLNR Allow NULL? 
3BLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')NoKBLPOS Allow NULL? 
4VRGNGBusiness Transactionnvarchar40CHAR(N' ')NoTJ01KBLVORGANG Allow NULL? 
5ERFASCreated bynvarchar120CHAR(N' ')NoKBLERF Allow NULL? 
6ERDATEntry datenvarchar80DATS(N'00000000')NoKBLERDAT Allow NULL? 
7AENDELast changed bynvarchar120CHAR(N' ')NoKBLAEN Allow NULL? 
8AEDATDate of Last Changenvarchar80DATS(N'00000000')NoKBLAEDAT Allow NULL? 
9PTEXTItem Textnvarchar500CHAR(N' ')NoSGTXT Allow NULL? 
10ERLKZCompletion indicator for line itemchar10CHAR(N' ')NoKBLERLKZ Allow NULL? 
11ERLDATCompletion datenvarchar80DATS(N'00000000')NoKBLERLDAT Allow NULL? 
12LOEKZDeletion Indicatorchar10CHAR(N' ')NoKBLLOEKZ Allow NULL? 
13WTGESTotal reserved amount in transaction currencydecimal152CURR((0))NoKBLWTG
14MENGEReserved quantitydecimal133QUAN((0))NoKBLMENGE
15MEINHUnit of Measurenvarchar30UNIT(N' ')NoT006CO_MEINH Allow NULL? 
16PREISPricedecimal152CURR((0))NoKBLPREIS
17PEINHPrice Unitdecimal50DEC((0))NoPEINH
18PRMENPrice unitnvarchar30UNIT(N' ')NoT006KBLPRMEN Allow NULL? 
19PRUMNDenominator for converting price unit into quantitydecimal50DEC((0))NoKBLPRUMN
20PRUMZCounter for converting price unit into quantitydecimal50DEC((0))NoKBLPRUMZ
21KSTARCost Elementnvarchar100CHAR(N' ')NoCSKAKSTAR Allow NULL? 
22FIPOSCommitment itemnvarchar140CHAR(N' ')NoFMFXPOFIPOS_XPO Allow NULL? 
23AUFNROrder Numbernvarchar120CHAR(N' ')NoAUFKAUFNR Allow NULL? 
24KOSTLCost Centernvarchar100CHAR(N' ')NoCSKSKOSTL Allow NULL? 
25PSPNRWork breakdown structure element (WBS element)nvarchar80NUMC(N'00000000')NoPRPSPS_PSP_ELE Allow NULL? 
26FISTLFunds Centernvarchar160CHAR(N' ')NoFMFCTRFISTL Allow NULL? 
27GEBERFundnvarchar100CHAR(N' ')NoFMFINCODEBP_GEBER Allow NULL? 
28FDATKCosts due onnvarchar80DATS(N'00000000')NoKBLFDATK Allow NULL? 
29MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
30LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')NoLFA1LIFNR Allow NULL? 
31ERLARRev.elem.nvarchar100CHAR(N' ')NoCSKAKBLERLAR Allow NULL? 
32ERL_PSPNRWBS Elementnvarchar80NUMC(N'00000000')NoPRPSPS_POSNR Allow NULL? 
33XSENDERIndicator: Senderchar10CHAR(N' ')NoXSENDER Allow NULL? 
34XEMPFGRIndicator: Receiverchar10CHAR(N' ')NoXEMPFGR Allow NULL? 
35AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')NoCO_AUFPL Allow NULL? 
36APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')No*CO_APLZL Allow NULL? 
37SKOSTLSender Cost Centernvarchar100CHAR(N' ')Yes*SKOSTL Allow NULL? 
38SAUFNRSender ordernvarchar120CHAR(N' ')YesAUFKSAUFNR Allow NULL? 
39NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
40HWGESTotal value in local currencydecimal152CURR((0))YesKBLHWG
41WTABBAmount used in budgetdecimal152CURR((0))YesFMWTABB
42HWABBReduction amount in budgetdecimal152CURR((0))YesFMHWABB
43CWTFREEAvailable amount in transaction currency (character)nvarchar160CHAR(N' ')YesCWTFREE Allow NULL? 
44WTABGFunds reservation amount reduceddecimal152CURR((0))YesKBLWTABG
45HWABGFunds reservation amount reduceddecimal152CURR((0))YesKBLWTABG
46ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
47ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
48ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
49ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
50ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
51ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
52ZZNFALnvarchar100(N' ')Yes Allow NULL? 
53ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
54ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
55ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
56ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
57ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
58STATSFunds Management Statistical Indicatorchar10CHAR(N' ')YesFMRE_STATS Allow NULL? 
59BLPKZBlocking Indicator (Item)char10CHAR(N' ')YesBLPKZ Allow NULL? 
60CONSUMEKZUsage may exceed reserved amount without limitchar10CHAR(N' ')YesFMCONSUME Allow NULL? 
61UEBTOTolerance limit for overrundecimal41DEC((0))YesFMUEBTO
62ABGWAERSReduction in local currency onlychar10CHAR(N' ')YesFMABGWAERS Allow NULL? 
63WKAPPItem approvedchar10CHAR(N' ')YesWKAPP Allow NULL? 
64CARRYOVDo not carry forward open documents in the fiscal year chgechar10CHAR(N' ')YesCARRYOV Allow NULL? 
65ACCHANGFM account assignment can be changed in follow-on documentchar10CHAR(N' ')YesFM_ACCHANG Allow NULL? 
66LNRZAAccount Number of the Alternative Payeenvarchar100CHAR(N' ')Yes*LNRZA Allow NULL? 
67REFBLTYPReference doc.category: funds precommitment or reservationnvarchar30NUMC(N'000')YesREFBLTYP Allow NULL? 
68REFBELNRReference document number: reservation/funds precommitmentnvarchar100CHAR(N' ')Yes*REFKBLNR Allow NULL? 
69REFBLPOSItem in reference documentnvarchar30NUMC(N'000')Yes*REFKBLPOS Allow NULL? 
70REFSETERLKUsed earmarked funds set to "Complete"char10CHAR(N' ')YesREFSETERLK Allow NULL? 
71WTGESAPPItem amount to be released (transaction currency)decimal152CURR((0))YesWTGESAPP
72HWGESAPPItem amount to be released (local currency)decimal152CURR((0))YesHWGESAPP
73DELTAWTAPPAmount change to be approved (transaction currency)decimal152CURR((0))YesDELTAWTAPP
74DELTAHWAPPAmount change to be approved (local currency)decimal152CURR((0))YesDELTAHWAPP
75SAKNRG/L Account Numbernvarchar100CHAR(N' ')YesSKA1SAKNR Allow NULL? 
76KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
77KURSUPLast revaluation ratedecimal95DEC((0))YesKURSU
78DATUPDate of last revaluationnvarchar80DATS(N'00000000')YesDATU Allow NULL? 
79WTFREEOpen amount (transaction currency)decimal152CURR((0))YesFMWTFREE
80HWFREEOpen amount (local currency)decimal152CURR((0))YesFMHWFREE
81EWSCOUNTNumber of history records in KBLEnvarchar50NUMC(N'00000')YesFMEWSCOUNT Allow NULL? 
82RFPOSReference line itemnvarchar100CHAR(N' ')YesAWPOS Allow NULL? 
83WTORIGOriginal Amount in Transaction Currencydecimal152CURR((0))YesFMWTORIG
84HWORIGOriginal amount in local currencydecimal152CURR((0))YesFMHWORIG
85POSLOCKEarmarked funds item blocknvarchar20CHAR(N' ')YesFMRESLOCKSFMRPOSLOCK Allow NULL? 
86PMACTIVEIndicator: Amount Change Only with Value Adjustment Documentchar10CHAR(N' ')YesFMRPMACTIVE Allow NULL? 
87FIPEXCommitment Itemnvarchar240CHAR(N' ')Yes*FM_FIPEX Allow NULL? 
88FKBERFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
89TOLOVIndicator: Override Global (Percentage-Based) Tolerancechar10CHAR(N' ')YesFMRTOLOV Allow NULL? 
90GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
91GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
92MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
93IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
94DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
95PEROP_BEGPeriod of Performance Startnvarchar80DATS(N'00000000')YesFM_PEROP_LOW Allow NULL? 
96PEROP_ENDPeriod of Performance Endnvarchar80DATS(N'00000000')YesFM_PEROP_HIGH Allow NULL? 
97PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
98BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
99PDATEITFM: Peremption Datenvarchar80DATS(N'00000000')YesITFM_PDATE Allow NULL? 
100DATE_FROMContract Period From Datenvarchar80DATS(N'00000000')YesSAFM_DATE_FROM Allow NULL? 
101DATE_TOContract Period To Datenvarchar80DATS(N'00000000')YesSAFM_DATE_TO Allow NULL? 
102FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
103FM_SPLIT_BATCHBatch to group results from an PSM assignment distributionnvarchar30NUMC(N'000')YesFMSP_SPLIT_BATCH Allow NULL? 
104FM_SPLIT_BEGRUAuthorization group for PSM account assignment distributionnvarchar40CHAR(N' ')Yes*FMSP_SPLIT_AUTG Allow NULL? 
105VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
106REVSUMTotal of all revaluations per line (approved amount)decimal152CURR((0))YesREVSUM
107REVAPPSUMTotal of all revaluations per line (amount to be approved)decimal152CURR((0))YesREVAPPSUM
108EF_GROUP_NUMBERGrouping Number for Earmarked Fundsnvarchar100NUMC(N'0000000000')YesEF_GROUP_NUMBER Allow NULL? 
109MWSKZCard Document: Tax on Sales/Purchases Codenvarchar20CHAR(N' ')YesT007ACRMWSKZ Allow NULL? 
110TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
111WMWSTCard Document: Tax on Sales/Purchases Paiddecimal152CURR((0))YesCRWMWST
112MWSTSCard Document: Tax on Sales/Purchases Paid in Local Currencydecimal152CURR((0))YesCRMWSTS
113NETBTRCard Document: Net Amount Paiddecimal152CURR((0))YesCRNETBTR
114NETHWCard Document: Net Amount Paid in Local Currencydecimal152CURR((0))YesCRNETDMBTR
115GROSBTRCard Document: Gross Amount Paiddecimal152CURR((0))YesCRGROSBTR
116GROSHWCard Document: Gross Amount Paid in Local Currencydecimal152CURR((0))YesCRGROSHW
NamePrimaryUniqueTypeColumns
KBLP~0YesYesCLUSTEREDBLPOS, BELNR, 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