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  | ANLA
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 :: Asset Accounting :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ANLA1418Asset Master Record SegmentBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, ANLN1, ANLN2, ANLKL, GEGST, ANLAR, ERNAM, ERDAT, AENAM, AEDAT, XLOEV, XSPEB, FELEI, KTOGR, XOPVW, ANLTP, ZUJHR, ZUPER, ZUGDT, AKTIV, ABGDT, DEAKT, GPLAB, BSTDT, ORD41, ORD42, ORD43, ORD44, ANLUE, ZUAWA, ANEQK, ANEQS, LIFNR, LAND1, LIEFE, HERST, EIGKZ, AIBN1, AIBN2, AIBDT, URJHR, URWRT, ANTEI, PROJN, EAUFN, MEINS, MENGE, TYPBZ, IZWEK, INKEN, IVDAT, INVZU, VMGLI, XVRMW, WRTMA, EHWRT, AUFLA, EHWZU, EHWNR, GRUVO, GREIN, GRBND, GRBLT, GRLFD, FLURK, FLURN, FIAMT, STADT, GRUND, FEINS, GRUFL, INVNR, VBUND, SPRAS, TXT50, TXA50, XLTXID, XVERID, XTCHID, XKALID, XHERID, XLEAID, LEAFI, LVDAT, LKDAT, LEABG, LEJAR, LEPER, LRYTH, LEGEB, LBASW, LKAUF, LMZIN, LZINS, LTZBW, LKUZA, LKUZI, LLAVB, LEANZ, LVTNR, LETXT, XAKTIV, ANUPD, LBLNR, XV0DT, XV0NM, XV1DT, XV1NM, XV2DT, XV2NM, XV3DT, XV3NM, XV4DT, XV4NM, XV5DT, XV5NM, XV6DT, XV6NM, AIMMO, OBJNR, LEART, LVORS, GDLGRP, POSNR, XERWRT, XAFABCH, XANLGR, MCOA1, XINVM, SERNR, UMWKZ, LRVDAT, ACT_CHANGE_PM, HAS_TDDP, LAST_REORG_DATE, INTERNAL_CODE, APPROVAL_NUMBER, APPROVAL_VERSION, BOGUS_ANLN1, ASSET_VERSION FROM ANLA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT093CBUKRS Allow NULL? 
3ANLN1Main Asset Numbernvarchar120CHAR(N' ')NoANLHANLN1 Allow NULL? 
4ANLN2Asset Subnumbernvarchar40CHAR(N' ')NoANLN2 Allow NULL? 
5ANLKLAsset Classnvarchar80CHAR(N' ')YesANKAANLKL Allow NULL? 
6GEGSTTechnical asset numbernvarchar80CHAR(N' ')YesGEGST Allow NULL? 
7ANLARAsset typesnvarchar50CHAR(N' ')YesANLAR Allow NULL? 
8ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
9ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
10AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
11AEDATChanged onnvarchar80DATS(N'00000000')YesAEDAT_ANLA Allow NULL? 
12XLOEVIndicator: Account marked for deletion?char10CHAR(N' ')YesXLOEV Allow NULL? 
13XSPEBIndicator: Asset Locked to Acquisition Postingschar10CHAR(N' ')YesXSPEB_ANLA Allow NULL? 
14FELEIScreen layout for Asset Accountingnvarchar40CHAR(N' ')Yes*FELEI Allow NULL? 
15KTOGRAccount determinationnvarchar80CHAR(N' ')YesT095AKTOGR Allow NULL? 
16XOPVWAsset under construct. with line item settlementchar10CHAR(N' ')YesOPVWA Allow NULL? 
17ANLTPAsset Categorychar10NUMC(N'0')YesANLTP Allow NULL? 
18ZUJHRFiscal year in which first acquisition was postednvarchar40NUMC(N'0000')YesDZUJAHR Allow NULL? 
19ZUPERPeriod in which first acquisition was postednvarchar30NUMC(N'000')YesDZUPER Allow NULL? 
20ZUGDTAsset value date of the first postingnvarchar80DATS(N'00000000')YesDZUGDAT Allow NULL? 
21AKTIVAsset capitalization datenvarchar80DATS(N'00000000')YesAKTIVD Allow NULL? 
22ABGDTAsset value date for the last retirementnvarchar80DATS(N'00000000')YesABGDAT Allow NULL? 
23DEAKTDeactivation datenvarchar80DATS(N'00000000')YesDEAKT Allow NULL? 
24GPLABPlanned retirement datenvarchar80DATS(N'00000000')YesGPLAB Allow NULL? 
25BSTDTAsset purchase order datenvarchar80DATS(N'00000000')YesBSTDT Allow NULL? 
26ORD41Evaluation group 1nvarchar40CHAR(N' ')YesT087ORD41 Allow NULL? 
27ORD42Evaluation group 2nvarchar40CHAR(N' ')YesT087ORD42 Allow NULL? 
28ORD43Evaluation group 3nvarchar40CHAR(N' ')YesT087ORD43 Allow NULL? 
29ORD44Evaluation group 4nvarchar40CHAR(N' ')YesT087ORD44 Allow NULL? 
30ANLUEAsset super numbernvarchar120CHAR(N' ')YesT087UANLUE Allow NULL? 
31ZUAWAKey for sorting according to assignment numbersnvarchar30CHAR(N' ')YesTZUNDZUAWA Allow NULL? 
32ANEQKIndicator: Historical managementchar10NUMC(N'0')YesANEQK Allow NULL? 
33ANEQSCompleteness indicator for the assetchar10NUMC(N'0')YesANEQS Allow NULL? 
34LIFNRAccount number of vendor (other key word)nvarchar100CHAR(N' ')YesLFA1AM_LIFNR Allow NULL? 
35LAND1Asset's country of originnvarchar30CHAR(N' ')YesT005AM_LAND1 Allow NULL? 
36LIEFEName of asset suppliernvarchar300CHAR(N' ')YesLIEFE Allow NULL? 
37HERSTManufacturer of assetnvarchar300CHAR(N' ')YesHERST Allow NULL? 
38EIGKZProperty indicatorchar10CHAR(N' ')YesT097EIGKZ Allow NULL? 
39AIBN1Original asset that was transferrednvarchar120CHAR(N' ')Yes*AIBN1 Allow NULL? 
40AIBN2Original asset that was transferrednvarchar40CHAR(N' ')Yes*AIBN2 Allow NULL? 
41AIBDTOriginal acquisition date of AuC/ transferred assetnvarchar80DATS(N'00000000')YesAIBDT Allow NULL? 
42URJHRFiscal year of original acquisitionnvarchar40NUMC(N'0000')YesURJHR Allow NULL? 
43URWRTOriginal acquisition valuedecimal132CURR((0))YesURWRT
44ANTEIIn-house production percentagedecimal52DEC((0))YesANTEI
45PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
46EAUFNInvestment Ordernvarchar120CHAR(N' ')Yes*AM_AUFNR Allow NULL? 
47MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
48MENGEQuantitydecimal133QUAN((0))YesAM_MENGE
49TYPBZAsset type namenvarchar150CHAR(N' ')YesTYPBZ_ANLA Allow NULL? 
50IZWEKReason for investmentnvarchar20CHAR(N' ')YesT087IIZWEK Allow NULL? 
51INKENInventory indicatorchar10CHAR(N' ')YesINKEN Allow NULL? 
52IVDATLast inventory datenvarchar80DATS(N'00000000')YesIVDAT_ANLA Allow NULL? 
53INVZUSupplementary inventory specificationsnvarchar150CHAR(N' ')YesINVZU_ANLA Allow NULL? 
54VMGLIProperty classification keynvarchar40CHAR(N' ')YesT092VMGLI Allow NULL? 
55XVRMWManual net worth tax valuechar10CHAR(N' ')YesXVRMW Allow NULL? 
56WRTMAManual net worth tax valuedecimal132CURR((0))YesWRTMA
57EHWRTAssessed valuedecimal132CURR((0))YesEHWRT
58AUFLADate of conveyancenvarchar80DATS(N'00000000')YesAUFLA_ANLA Allow NULL? 
59EHWZUDate of last notice of assessmentnvarchar80DATS(N'00000000')YesEHWZU_ANLA Allow NULL? 
60EHWNRTax number of the notice of assessmentnvarchar160CHAR(N' ')YesEHWNR_ANLA Allow NULL? 
61GRUVOLand Register ofnvarchar80DATS(N'00000000')YesGRUVO_ANLA Allow NULL? 
62GREINLand register entry onnvarchar80DATS(N'00000000')YesGREIN_ANLA Allow NULL? 
63GRBNDLand register volumenvarchar50CHAR(N' ')YesGRBND_ANLA Allow NULL? 
64GRBLTLand register pagenvarchar50CHAR(N' ')YesGRBLT_ANLA Allow NULL? 
65GRLFDLand register entry: Sequence numbernvarchar40CHAR(N' ')YesGRLFD_ANLA Allow NULL? 
66FLURKLand register map numbernvarchar40CHAR(N' ')YesFLURK_ANLA Allow NULL? 
67FLURNPlot numbernvarchar100CHAR(N' ')YesFLURN_ANLA Allow NULL? 
68FIAMTLocal tax officenvarchar250CHAR(N' ')YesFIAMT Allow NULL? 
69STADTMunicipalitynvarchar250CHAR(N' ')YesORT01_ANLA Allow NULL? 
70GRUNDReason for manual valuation of net assetsnvarchar30CHAR(N' ')YesT098GRUND Allow NULL? 
71FEINSArea unitnvarchar30UNIT(N' ')YesT006FEINS Allow NULL? 
72GRUFLSurface areadecimal133QUAN((0))YesGRUFL
73INVNRInventory numbernvarchar250CHAR(N' ')YesINVNR_ANLA Allow NULL? 
74VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
75SPRASLanguage Keychar10LANG(N' ')YesT002SPRAS Allow NULL? 
76TXT50Asset descriptionnvarchar500CHAR(N' ')YesTXA50_ANLT Allow NULL? 
77TXA50Additional asset descriptionnvarchar500CHAR(N' ')YesTXA50_MORE Allow NULL? 
78XLTXIDIndicator: Long text activechar10CHAR(N' ')YesXLTXID Allow NULL? 
79XVERIDLong text indicator:Property valueschar10CHAR(N' ')YesXVERID Allow NULL? 
80XTCHIDIndicator: Technical view long textchar10CHAR(N' ')YesXTCHID Allow NULL? 
81XKALIDIndicator: Long text activechar10CHAR(N' ')YesXKALID Allow NULL? 
82XHERIDIndicator: Long text for manufacturer/originchar10CHAR(N' ')YesXHERID Allow NULL? 
83XLEAIDIndicator: Leasing data long textchar10CHAR(N' ')YesXLEAID Allow NULL? 
84LEAFILeasing companynvarchar100CHAR(N' ')YesLFA1LEAFI Allow NULL? 
85LVDATLeasing agreement datenvarchar80DATS(N'00000000')YesLVDAT Allow NULL? 
86LKDATLeasing agreement notice datenvarchar80DATS(N'00000000')YesLKDAT Allow NULL? 
87LEABGLease start datenvarchar80DATS(N'00000000')YesLEABG Allow NULL? 
88LEJARLength of lease in yearsnvarchar30NUMC(N'000')YesLEJAR Allow NULL? 
89LEPERLength of lease in periodsnvarchar30NUMC(N'000')YesLEPER Allow NULL? 
90LRYTHLease payment cyclenvarchar30NUMC(N'000')YesLRYTH Allow NULL? 
91LEGEBPeriodic lease payment paid to leasing company/lessordecimal132CURR((0))YesLEGEB
92LBASWLeasing base value as newdecimal132CURR((0))YesLBASW
93LKAUFLeased asset purchase pricedecimal132CURR((0))YesLKAUF
94LMZINLeasing monthly interest rate (Capital Lease)decimal74DEC((0))YesLMZIN
95LZINSLeasing interest rate (capital lease)decimal74DEC((0))YesLZINS
96LTZBWPosting date of the last lease paymentnvarchar80DATS(N'00000000')YesLTZBW Allow NULL? 
97LKUZATotal of posted leasing paymentsdecimal132CURR((0))YesLKUZA
98LKUZITotal leasing interest posteddecimal132CURR((0))YesLKUZI
99LLAVBTotal of long-term leasing liabilitydecimal132CURR((0))YesLLAVB
100LEANZNumber of lease paymentsdecimal50DEC((0))YesLEANZ
101LVTNRLeasing agreement numbernvarchar150CHAR(N' ')YesLVTNR Allow NULL? 
102LETXTLeasing data textnvarchar500CHAR(N' ')YesLETXT Allow NULL? 
103XAKTIVIndicator: Capitalize fixed assetchar10CHAR(N' ')YesXAKTIV Allow NULL? 
104ANUPDIndicator: Type of change to tablechar10CHAR(N' ')YesANUPD Allow NULL? 
105LBLNRNo. of last document with which posting to asset was madenvarchar100CHAR(N' ')YesLBLNR Allow NULL? 
106XV0DTChange date: View 0nvarchar80DATS(N'00000000')YesXV0DT Allow NULL? 
107XV0NMName of person in charge, who changed View0nvarchar120CHAR(N' ')YesXV0NM Allow NULL? 
108XV1DTChange date: View 1nvarchar80DATS(N'00000000')YesXV1DT Allow NULL? 
109XV1NMName of person in charge, who changed view 1nvarchar120CHAR(N' ')YesXV1NM Allow NULL? 
110XV2DTChange date: View 2nvarchar80DATS(N'00000000')YesXV2DT Allow NULL? 
111XV2NMName of the person in charge, who changed view 2nvarchar120CHAR(N' ')YesXV2NM Allow NULL? 
112XV3DTChange date: View 3nvarchar80DATS(N'00000000')YesXV3DT Allow NULL? 
113XV3NMName of the person in charge, who changed view 3nvarchar120CHAR(N' ')YesXV3NM Allow NULL? 
114XV4DTChange date: View 4nvarchar80DATS(N'00000000')YesXV4DT Allow NULL? 
115XV4NMName of the person in charge, who changed view 4nvarchar120CHAR(N' ')YesXV4NM Allow NULL? 
116XV5DTChange date:View 5nvarchar80DATS(N'00000000')YesXV5DT Allow NULL? 
117XV5NMName of the person in charge who changed view 5nvarchar120CHAR(N' ')YesXV5NM Allow NULL? 
118XV6DTChange date:View 6nvarchar80DATS(N'00000000')YesXV6DT Allow NULL? 
119XV6NMName of the person in charge who changed view 6nvarchar120CHAR(N' ')YesXV6NM Allow NULL? 
120AIMMOIndicator: real estatechar10NUMC(N'0')YesAIMMO Allow NULL? 
121OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
122LEARTLeasing typenvarchar20CHAR(N' ')YesT083LLEART Allow NULL? 
123LVORSAdvance paymentschar10CHAR(N' ')YesLVORS Allow NULL? 
124GDLGRPEvaluation group 5nvarchar80CHAR(N' ')YesT087GGDLGRP Allow NULL? 
125POSNRWBS element investment projectnvarchar80NUMC(N'00000000')YesPRPSAM_POSNR Allow NULL? 
126XERWRTIndicator: Ignore memo valuechar10CHAR(N' ')YesXERWRT Allow NULL? 
127XAFABCHAsset acquired usedchar10CHAR(N' ')YesXAFABCH Allow NULL? 
128XANLGRIndicator: Asset is a group assetchar10CHAR(N' ')NoXANLGR_1 Allow NULL? 
129MCOA1Search term for matchcode searchnvarchar300CHAR(N' ')YesMCOA1 Allow NULL? 
130XINVMAsset under Construction for Investment Measureschar10CHAR(N' ')YesIM_XINVM Allow NULL? 
131SERNRSerial numbernvarchar180CHAR(N' ')YesAM_SERNR Allow NULL? 
132UMWKZReason for environmental investmentnvarchar50CHAR(N' ')YesT087KAM_UMWKZ Allow NULL? 
133LRVDATDate of last revaluationnvarchar80DATS(N'00000000')YesAM_LRVDAT Allow NULL? 
134ACT_CHANGE_PMChange Asset Master Record from Equipment Masterchar10CHAR(N' ')YesAAPM_ACT_CHANGE_PM Allow NULL? 
135HAS_TDDPAsset Has Time-Dependent Valuation Parameters in ANLBZAchar10CHAR(N' ')YesHAS_TDDP Allow NULL? 
136LAST_REORG_DATEDate of Last Reorganizationnvarchar80DATS(N'00000000')YesFAA_LAST_REORG Allow NULL? 
137INTERNAL_CODEInternal codenvarchar100CHAR(N' ')Yes/ATL/INTERNAL_CODE Allow NULL? 
138APPROVAL_NUMBERApproval document numbernvarchar150CHAR(N' ')Yes/ATL/APPROVAL_NUMBER Allow NULL? 
139APPROVAL_VERSIONApproval versionnvarchar30CHAR(N' ')Yes/ATL/APPROVAL_VERSION Allow NULL? 
140BOGUS_ANLN1bogus asset numbernvarchar120CHAR(N' ')Yes/ATL/BOGUS_ANLN1 Allow NULL? 
141ASSET_VERSIONAsset versionnvarchar30CHAR(N' ')Yes/ATL/ASSET_VERSION Allow NULL? 
NamePrimaryUniqueTypeColumns
ANLA~0YesYesCLUSTEREDANLN2, ANLN1, BUKRS, MANDT
ANLA~ANoNoNONCLUSTEREDANLKL, MCOA1, BUKRS, MANDT
ANLA~BNoNoNONCLUSTEREDANLN2, ANLN1, MANDT, BUKRS, ANLKL
ANLA~CNoNoNONCLUSTEREDANLN2, ANLN1, MANDT, BUKRS, ANLUE
ANLA~ENoNoNONCLUSTEREDMANDT, BUKRS, EAUFN
ANLA~INoNoNONCLUSTEREDMANDT, BUKRS, INVNR
ANLA~KNoNoNONCLUSTEREDANLN2, ANLN1, MANDT, BUKRS, XANLGR
ANLA~PNoNoNONCLUSTEREDMANDT, BUKRS, POSNR

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