SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7BSEG345Accounting Document Segment
8/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4OVTG52Tax Definition
5ORDR386Sales Order
6INV1265A/R Invoice - Rows
7OJDT100Journal Entry
8OPCH386A/P Invoice
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Real Estate Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VIAKBSEG1691Document Line Item from SCS for InterfaceReal Estate Management
SQL:  selectupdate insert create

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

SELECT MANDTT, VVABBLN, BELEG, POS, JPOSTED, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, MANDT, MAPPE, IBELN, IBELZ, BUKRS, BELNR, BUZEI, SGTXT, SHKZG, UMSKZ, VALUT, ZUMSK, ZUONR, ZFBDT, BSCHL, WRBTR, DMBTR, WERKS, XCPDD, BVTYP, BWKEY, BWTAR, BZDAT, ANLN1, ANLN2, ANBWA, AUFNR, ABPER, MABER, MANSP, MSCHL, KOSTL, KUNNR, KURSR, MWSKZ, FILKD, FDTAG, FDGRP, FDLEV, HZUON, KOART, GSBER, HKONT, HBKID, DBKEY, KOMKZ, SAMKZ, BLART, REBZG, LIFNR, REGUL, CPD, NAME1, NAME2, NAME3, NAME4, STCD1, STCD2, PSTLZ, PSTL2, PSKTO, PFACH, ORT01, STRAS, STKZU, STKZA, REGIO, BKONT, BANKS, BANKN, BANKL, LAND1, EMPFG, DTAWS, DTAMS, MEINS, MENGE, IMMO, DABRZ, POPTS, SWENR, SGENR, SGRNR, SMENR, SNKSL, SEMPSL, BDAT, NABFW, ABZFW, SBERI, VERTT, VERTN, VBEWA, DEPOT, MWSTS, WMWST, ZLSCH, ZLSPR, PRCTR, SAMNR, IMKEY, RKLAMMER, FWBAS, AUGLINFO, AUGLZLSPR, REBZZ, REBZJ, SKFBT, XBLNR, PERNR, RVZBLG, ZTERM, ZINKZ, SVWNR, NEWBK, AUGDT, AUGCP, AUGBL, REBZT, INTRENO, MADAT, MANST, ZE_KUNNR, ZE_PARTNER, ZE_BVTYP, VBUND, XREF1, LZBKZ, LANDL, GJAHR, DFAELL, TXJCD, PRSDT, US_MWSKZ, US_WMWST, US_TXINT, US_TAXIT, US_KTOSL, US_FWBAS, UNKA_STAX, UNKA_KTOSL, UNKA_FWBAS, UNKA_KBETR, RE_AWTYP, RE_AWREF, RE_AWORG, RE_POSNR, RE_KSCHL, FCVAL, XREF1_HD, XREF2_HD, PS_PSP_PNR FROM VIAKBSEG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2VVABBLNSettlement Identification ->Accounting Ref. Doc.Numbernvarchar160CHAR(N' ')NoVVABBLN1 Allow NULL? 
3BELEGAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4POSNumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
5JPOSTEDIndicator for document postedchar10CHAR(N' ')YesREJPOSTED Allow NULL? 
6ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
7ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
8ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
9ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
10ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
11ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
12ZZNFALnvarchar100(N' ')Yes Allow NULL? 
13ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
14ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
15ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
16ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
17ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
18MANDTClientnvarchar30CLNT(N'000')Yes*MANDT Allow NULL? 
19MAPPEGroup name: Batch input session namenvarchar120CHAR(N' ')YesAPQ_GRPN Allow NULL? 
20IBELNInternal doc.numbernvarchar90NUMC(N'000000000')YesVVIBELN Allow NULL? 
21IBELZInternal doc.numbernvarchar90NUMC(N'000000000')YesVVIBELN Allow NULL? 
22BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
23BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
24BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
25SGTXTText Fieldnvarchar500CHAR(N' ')YesTEXT50 Allow NULL? 
26SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
27UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
28VALUTDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
29ZUMSKSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
30ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
31ZFBDTDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
32BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
33WRBTRAmount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
34DMBTRAmount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
35WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
36XCPDDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
37BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
38BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
39BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
40BZDATDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
41ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
42ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
43ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*BWASL Allow NULL? 
44AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
45ABPERPosting period in the form YYYYMMnvarchar60ACCP(N' ')YesBUPER Allow NULL? 
46MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
47MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
48MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
49KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
50KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
51KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
52MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
53FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
54FDTAGDatenvarchar80DATS(N'00000000')YesDATUM Allow NULL? 
55FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
56FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
57HZUONAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
58KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
59GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
60HKONTG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
61HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
62DBKEYDatabase key memorynvarchar600CHAR(N' ')YesDBKEY Allow NULL? 
63KOMKZCompression indicator per account symbolchar10CHAR(N' ')YesKOMPZ Allow NULL? 
64SAMKZMark item for collective purchase orderchar10CHAR(N' ')YesSAMKZ Allow NULL? 
65BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
66REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
67LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
68REGULIndicator: Individual Payee in Documentchar10CHAR(N' ')YesREGUL Allow NULL? 
69CPDCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
70NAME1Employee's last namenvarchar350CHAR(N' ')YesNAME Allow NULL? 
71NAME2Employee's last namenvarchar350CHAR(N' ')YesNAME Allow NULL? 
72NAME3Employee's last namenvarchar350CHAR(N' ')YesNAME Allow NULL? 
73NAME4Employee's last namenvarchar350CHAR(N' ')YesNAME Allow NULL? 
74STCD1Tax Number 1nvarchar160CHAR(N' ')YesSTCD1 Allow NULL? 
75STCD2Tax Number 2nvarchar110CHAR(N' ')YesSTCD2 Allow NULL? 
76PSTLZPostal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
77PSTL2Postal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
78PSKTOAccount Number of Bank Account At Post Officenvarchar160CHAR(N' ')YesPSKTO Allow NULL? 
79PFACHPO Boxnvarchar100CHAR(N' ')YesPFACH Allow NULL? 
80ORT01Data Element Type CHAR Length 35nvarchar350CHAR(N' ')YesCHAR35 Allow NULL? 
81STRASData Element Type CHAR Length 35nvarchar350CHAR(N' ')YesCHAR35 Allow NULL? 
82STKZUCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
83STKZAIndicator: Business Partner Subject to Equalization Tax?char10CHAR(N' ')YesSTKZA Allow NULL? 
84REGIORegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
85BKONTBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
86BANKSCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
87BANKNBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
88BANKLBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
89LAND1Country Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
90EMPFGPayee codenvarchar160CHAR(N' ')YesEMPFG Allow NULL? 
91DTAWSInstruction key for data medium exchangenvarchar20CHAR(N' ')Yes*DTAWS Allow NULL? 
92DTAMSIndicator for Data Medium Exchangechar10CHAR(N' ')YesDTAMS Allow NULL? 
93MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
94MENGEQuantitydecimal133QUAN((0))YesMENGE_D
95IMMOCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
96DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
97POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
98SWENRSite Numbernvarchar80CHAR(N' ')Yes*SWENR Allow NULL? 
99SGENRBuilding Numbernvarchar80CHAR(N' ')Yes*SGENR Allow NULL? 
100SGRNRProperty Number for BEnvarchar80CHAR(N' ')Yes*SGRNR Allow NULL? 
101SMENRNumber of Rental Unitnvarchar80CHAR(N' ')Yes*SMENR Allow NULL? 
102SNKSLService Charge Keynvarchar40CHAR(N' ')Yes*SNKSL Allow NULL? 
103SEMPSLSettlement Unitnvarchar50CHAR(N' ')Yes*SEMPSL Allow NULL? 
104BDATReference datenvarchar80DATS(N'00000000')YesBDAT Allow NULL? 
105NABFWInput tax amount cannot be deducteddecimal132CURR((0))YesNABFW
106ABZFWDeductible input tax amountdecimal132CURR((0))YesABZFW
107SBERICorrection item numbernvarchar100CHAR(N' ')Yes*SBERI Allow NULL? 
108VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
109VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
110VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
111DEPOTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
112MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
113WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
114ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
115ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
116PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
117SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
118IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
119RKLAMMERClassification Number for Finance Projectsnvarchar130CHAR(N' ')YesRKLAMMER Allow NULL? 
120FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
121AUGLINFOAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
122AUGLZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
123REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
124REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
125SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
126XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
127PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
128RVZBLGAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
129ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
130ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
131SVWNRManagement Contract Numbernvarchar130CHAR(N' ')Yes*VVSVWNR Allow NULL? 
132NEWBKCompany Code for the Next Line Itemnvarchar40CHAR(N' ')Yes*NEWBK Allow NULL? 
133AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
134AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
135AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
136REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
137INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
138MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
139MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
140ZE_KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
141ZE_PARTNERPartner numbernvarchar100CHAR(N' ')Yes*SPARTNR Allow NULL? 
142ZE_BVTYPBank type of alternative payernvarchar40CHAR(N' ')YesVVBVTYPABW Allow NULL? 
143VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
144XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
145LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
146LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
147GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
148DFAELLDue datenvarchar80DATS(N'00000000')YesDFAELL Allow NULL? 
149TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
150PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
151US_MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
152US_WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
153US_TXINTIndicator: tax item - RE internal entrychar10CHAR(N' ')YesVVTAXUSINT Allow NULL? 
154US_TAXITIndicator: Tax Itemchar10CHAR(N' ')YesTAXIT Allow NULL? 
155US_KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
156US_FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
157UNKA_STAXIndicator: Tax item - internal entry RE (SCS)char10CHAR(N' ')YesVVUNKATAX Allow NULL? 
158UNKA_KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
159UNKA_FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
160UNKA_KBETRRate (condition amount or percentage) where no scale existsdecimal112CURR((0))YesKBETR_KOND
161RE_AWTYPReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
162RE_AWREFReference Document Numbernvarchar100CHAR(N' ')YesAWREF Allow NULL? 
163RE_AWORGReference Organizational Unitsnvarchar100CHAR(N' ')YesAWORG Allow NULL? 
164RE_POSNRAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
165RE_KSCHLCondition Typenvarchar40CHAR(N' ')Yes*KSCHL Allow NULL? 
166FCVALIndicator: Line Item Contains Foreign Currency Valuationchar10CHAR(N' ')YesFCVAL Allow NULL? 
167XREF1_HDReference Key 1 Internal for Document Headernvarchar200CHAR(N' ')YesXREF1_HD Allow NULL? 
168XREF2_HDReference Key 2 Internal for Document Headernvarchar200CHAR(N' ')YesXREF2_HD Allow NULL? 
169PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
NamePrimaryUniqueTypeColumns
VIAKBSEG~0YesYesCLUSTEREDMANDTT, VVABBLN, BELEG, POS