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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
1ERP EHP76.0FILUD_AA_MASTER511SAFT: FI Asset master data and values
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, ANLN1, ANLN2, GJAHR, AFABE, BDATU, ADATU, ANLKL, KTOGR, ZUGDT, AKTIV, BSTDT, LIFNR, LAND1, TXT50, AGABG, INVSL, AFASL, NDJAR, NDPER, SAPRZ, NAPRZ, SCHRW, KANSW, KNAFA, KSAFA, KAAFA, ANSWL, NAFAG, SAFAG, AAFAG, MAFAG, ABGAN, INVZM, NAFAL, AAFAL, SAFAL, BWASL, BWAGRP, GITCOL, BWATYP, ANBTR, ASSET_ADDITION, ASSET_TRANSFER, ASSET_DISPOSAL, INV_SUPPORT, APC_BEGIN, APC_END, NBV_BEGIN, NBV_END FROM FILUD_AA_MASTER
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3ANLN1Main Asset Numbernvarchar120CHAR(N' ')NoANLHANLN1 Allow NULL? 
4ANLN2Asset Subnumbernvarchar40CHAR(N' ')NoANLAANLN2 Allow NULL? 
5GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
6AFABEReal depreciation areanvarchar20NUMC(N'00')NoT093AFABE_D Allow NULL? 
7BDATUDate validity endsnvarchar80DATS(N'00000000')NoBDATU Allow NULL? 
8ADATUDate for beginning of validitynvarchar80DATS(N'00000000')YesADATU Allow NULL? 
9ANLKLAsset Classnvarchar80CHAR(N' ')Yes*ANLKL Allow NULL? 
10KTOGRAccount determinationnvarchar80CHAR(N' ')Yes*KTOGR Allow NULL? 
11ZUGDTAsset value date of the first postingnvarchar80DATS(N'00000000')YesDZUGDAT Allow NULL? 
12AKTIVAsset capitalization datenvarchar80DATS(N'00000000')YesAKTIVD Allow NULL? 
13BSTDTAsset purchase order datenvarchar80DATS(N'00000000')YesBSTDT Allow NULL? 
14LIFNRAccount number of vendor (other key word)nvarchar100CHAR(N' ')Yes*AM_LIFNR Allow NULL? 
15LAND1Asset's country of originnvarchar30CHAR(N' ')Yes*AM_LAND1 Allow NULL? 
16TXT50Asset descriptionnvarchar500CHAR(N' ')YesTXA50_ANLT Allow NULL? 
17AGABGDepreciation calculation start datenvarchar80DATS(N'00000000')YesAFABG Allow NULL? 
18INVSLInvestment support keynvarchar20CHAR(N' ')Yes*INVSL Allow NULL? 
19AFASLDepreciation keynvarchar40CHAR(N' ')Yes*AFASL Allow NULL? 
20NDJARPlanned useful life in yearsnvarchar30NUMC(N'000')YesNDJAR Allow NULL? 
21NDPERPlanned useful life in periodsnvarchar30NUMC(N'000')YesNDPER Allow NULL? 
22SAPRZSpecial depreciation percentage ratedecimal74DEC((0))YesSAPRZ
23NAPRZOrdinary depreciation percentage ratedecimal74DEC((0))YesNAPRZ
24SCHRWAsset scrap valuedecimal132CURR((0))YesSCHRW
25KANSWCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
26KNAFAAccumulated ordinary depreciationdecimal132CURR((0))YesKNAFA
27KSAFACumulative special depreciationdecimal132CURR((0))YesKSAFA
28KAAFACumulative unplanned depreciationdecimal132CURR((0))YesKAAFA
29ANSWLTransactions for the year affecting asset valuesdecimal132CURR((0))YesANSWL
30NAFAGOrdinary depreciation posted in the current yeardecimal132CURR((0))YesNAFAG
31SAFAGSpecial depreciation posted in the current fiscal yeardecimal132CURR((0))YesSAFAG
32AAFAGUnplanned depreciation posted for the yeardecimal132CURR((0))YesAAFAG
33MAFAGAcquisition value reducing depreciation posted for the yeardecimal132CURR((0))YesMAFAG
34ABGANTotal retirements and retiring transfersdecimal132CURR((0))YesABGAN
35INVZMInvestment grant for the yeardecimal132CURR((0))YesINVZM
36NAFALProportional ordinary depreciation for the yeardecimal132CURR((0))YesNAFAL
37AAFALProportional unplanned depreciation for the yeardecimal132CURR((0))YesAAFAL
38SAFALProportional special depreciation for the yeardecimal132CURR((0))YesSAFAL
39BWASLAsset Transaction Typenvarchar30CHAR(N' ')Yes*BWASL Allow NULL? 
40BWAGRPTransaction type groupnvarchar20CHAR(N' ')Yes*BWAGRP Allow NULL? 
41GITCOLClassification of transaction type groupchar10CHAR(N' ')YesGITCOL Allow NULL? 
42BWATYPTransaction type categorychar10CHAR(N' ')YesBWATYP Allow NULL? 
43ANBTRAmount posteddecimal132CURR((0))YesANBTR
44ASSET_ADDITIONAmount posteddecimal132CURR((0))YesANBTR
45ASSET_TRANSFERAmount posteddecimal132CURR((0))YesANBTR
46ASSET_DISPOSALAmount posteddecimal132CURR((0))YesANBTR
47INV_SUPPORTAmount posteddecimal132CURR((0))YesANBTR
48APC_BEGINCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
49APC_ENDCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
50NBV_BEGINCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
51NBV_ENDCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
NamePrimaryUniqueTypeColumns
FILUD_AA_MASTER~0YesYesCLUSTEREDBDATU, AFABE, GJAHR, ANLN2, ANLN1, BUKRS, MANDT