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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0/ATL/AANLCP791Periodic Asset-value fields, like anlc, for all areas
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, ANLN1, ANLN2, GJAHR, PERAF, AFABE, ZUJHR, ZUCOD, AFBLPE, AFBANZ, XAFAR, NDABJ, NDABP, ANDSJ, ANDSP, RSTCK, KANSW, KAUFW, KINVZ, KNAFA, KSAFA, KAAFA, KMAFA, KZINW, KAUFN, KANZA, KVOST, AUFWP, NAFAP, SAFAP, AAFAP, MAFAP, ZINSP, AUFNP, AUFWB, NAFAG, SAFAG, AAFAG, MAFAG, ZINSG, AUFNG, ANSWL, ABGAN, ANSAZ, AUFWM, INVZM, NAFAM, SAFAM, AAFAM, MAFAM, ZINSM, AUFNM, ZUSNA, ZUSSA, ZUSAA, ZUSMA, AUFWV, INVZV, NAFAV, SAFAV, AAFAV, MAFAV, AUFNV, AUFWL, INVZL, NAFAL, SAFAL, AAFAL, MAFAL, AUFNL, ANUPD, KSANS, SANSL, PSTBEG, PSTEND, PSTCALC, PSTPER, DOWNP FROM /ATL/AANLCP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3ANLN1Main Asset Numbernvarchar120CHAR(N' ')No*ANLN1 Allow NULL? 
4ANLN2Asset Subnumbernvarchar40CHAR(N' ')No*ANLN2 Allow NULL? 
5GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
6PERAFDepreciation calculation periodnvarchar30NUMC(N'000')NoPERAF Allow NULL? 
7AFABEReal depreciation areanvarchar20NUMC(N'00')No*/ATL/AAFABE Allow NULL? 
8ZUJHRAsset acquisition yearnvarchar40NUMC(N'0000')No/ATL/AGJAHR Allow NULL? 
9ZUCODSub-classification of asset acquisitionsnvarchar40NUMC(N'0000')No/ATL/AUCOD Allow NULL? 
10AFBLPEPeriod in which last depreciation was postednvarchar30NUMC(N'000')YesAFBLPE Allow NULL? 
11AFBANZNumber of depreciation posting runs in the periodnvarchar20NUMC(N'00')YesAFBANZ Allow NULL? 
12XAFARIndicator: Errors in depreciationchar10NUMC(N'0')YesXAFAR Allow NULL? 
13NDABJExpired useful life in years at start of the fiscal yearnvarchar30NUMC(N'000')YesNDABJ Allow NULL? 
14NDABPExpired useful life in periods at start of fiscal yearnvarchar30NUMC(N'000')YesNDABP Allow NULL? 
15ANDSJYrs Expired up to Fisc.Yr Start from Start of Spec.Dep.nvarchar30NUMC(N'000')YesANDSJ Allow NULL? 
16ANDSPExpired useful life in periods during FY from SDep start datnvarchar30NUMC(N'000')YesANDSP Allow NULL? 
17RSTCKNumber of units depreciated in unit-of-prod. depreciationdecimal150DEC((0))YesRSTCK
18KANSWCumulative acquisition and production costsdecimal132CURR((0))YesKANSW
19KAUFWCumulative revaluation on the replacement valuedecimal132CURR((0))YesKAUFW
20KINVZCumulative investment grantsdecimal132CURR((0))YesKINVZ
21KNAFAAccumulated ordinary depreciationdecimal132CURR((0))YesKNAFA
22KSAFACumulative special depreciationdecimal132CURR((0))YesKSAFA
23KAAFACumulative unplanned depreciationdecimal132CURR((0))YesKAAFA
24KMAFACumulative reserves transferdecimal132CURR((0))YesKMAFA
25KZINWCumulative interestdecimal132CURR((0))YesKZINW
26KAUFNCumulative revaluation of ordinary depreciationdecimal132CURR((0))YesKAUFN
27KANZACumulative down paymentsdecimal132CURR((0))YesKANZA
28KVOSTCumulative input taxdecimal132CURR((0))YesKVOST
29AUFWPPlanned revaluation on replacement valuedecimal132CURR((0))YesAUFWP
30NAFAPPlanned ordinary depreciation for the yeardecimal132CURR((0))YesNAFAP
31SAFAPPlanned special depreciation for the yeardecimal132CURR((0))YesSAFAP
32AAFAPScheduled unplanned depreciation for the yeardecimal132CURR((0))YesAAFAP
33MAFAPPlanned transfer of reserves for the yeardecimal132CURR((0))YesMAFAP
34ZINSPInterest planned for the yeardecimal132CURR((0))Yes/ATL/AINSP
35AUFNPPlanned revaluation of accumulated ordinary depreciationdecimal132CURR((0))YesAUFNP
36AUFWBRevaluation posted on replacement valuedecimal132CURR((0))YesAUFWB
37NAFAGOrdinary depreciation posted in the current yeardecimal132CURR((0))YesNAFAG
38SAFAGSpecial depreciation posted in the current fiscal yeardecimal132CURR((0))YesSAFAG
39AAFAGUnplanned depreciation posted for the yeardecimal132CURR((0))YesAAFAG
40MAFAGAcquisition value reducing depreciation posted for the yeardecimal132CURR((0))YesMAFAG
41ZINSGInterest posted for the yeardecimal132CURR((0))Yes/ATL/AINSG
42AUFNGPosted revaluation of accumulated ordinary depreciationdecimal132CURR((0))YesAUFNG
43ANSWLTransactions for the year affecting asset valuesdecimal132CURR((0))YesANSWL
44ABGANTotal retirements and retiring transfersdecimal132CURR((0))YesABGAN
45ANSAZDown payments on assetdecimal132CURR((0))YesANSAZ
46AUFWMManual revaluation on replacement valuedecimal132CURR((0))YesAUFWM
47INVZMInvestment grant for the yeardecimal132CURR((0))YesINVZM
48NAFAMManually planned ordinary depreciation for the yeardecimal132CURR((0))YesNAFAM
49SAFAMManual special depreciation planned for the yeardecimal132CURR((0))YesSAFAM
50AAFAMManual unplanned depreciation for the yeardecimal132CURR((0))YesAAFAM
51MAFAMManual transfer of reserves for the yeardecimal132CURR((0))YesMAFAM
52ZINSMManual interest planned for the yeardecimal132CURR((0))Yes/ATL/AINSM
53AUFNMManual revaluation of cumulative ordinary depreciationdecimal132CURR((0))YesAUFNM
54ZUSNAWrite-up on ordinary depreciationdecimal132CURR((0))Yes/ATL/AUSNA
55ZUSSAWrite-up on special depreciationdecimal132CURR((0))Yes/ATL/AUSSA
56ZUSAAWrite-up on unplanned depreciationdecimal132CURR((0))Yes/ATL/AUSAA
57ZUSMAWrite-up on acquisition value reducing depreciationdecimal132CURR((0))Yes/ATL/AUSMA
58AUFWVProportional cumulative revaluation on replacement valuedecimal132CURR((0))YesAUFWV
59INVZVProportional cumulative investment grantsdecimal132CURR((0))YesINVZV
60NAFAVProportional accumulated ordinary depreciationdecimal132CURR((0))YesNAFAV
61SAFAVProportional cumulative special depreciationdecimal132CURR((0))YesSAFAV
62AAFAVProportional cumulative unplanned depreciationdecimal132CURR((0))YesAAFAV
63MAFAVProportional cumulative transfer of reservesdecimal132CURR((0))YesMAFAV
64AUFNVProportional cum. revaluation on ordinary depreciationdecimal132CURR((0))YesAUFNV
65AUFWLProportional revaluation for the year on replacement valuedecimal132CURR((0))YesAUFWL
66INVZLProportional investment grant for the yeardecimal132CURR((0))YesINVZL
67NAFALProportional ordinary depreciation for the yeardecimal132CURR((0))YesNAFAL
68SAFALProportional special depreciation for the yeardecimal132CURR((0))YesSAFAL
69AAFALProportional unplanned depreciation for the yeardecimal132CURR((0))YesAAFAL
70MAFALProportional transfer of reserves for the yeardecimal132CURR((0))YesMAFAL
71AUFNLProportional revaluation of annual ordinary dep.decimal132CURR((0))YesAUFNL
72ANUPDIndicator: Type of change to tablechar10CHAR(N' ')YesANUPD Allow NULL? 
73KSANSCumulative statistical acquisition valuedecimal132CURR((0))YesKSANS
74SANSLStatistical aquisition value of current yeardecimal132CURR((0))YesSANSL
75PSTBEGFI-AA: Posting depreciation as of period xynvarchar30NUMC(N'000')YesPSTBEG Allow NULL? 
76PSTENDFI-AA: Posting depreciation up to period xynvarchar30NUMC(N'000')YesPSTEND Allow NULL? 
77PSTCALCFI-AA: New calculation of depreciation during postingchar10CHAR(N' ')YesPSTCALC Allow NULL? 
78PSTPERFI-AA: Depreciation calculation from period Xnvarchar30NUMC(N'000')YesPSTPER Allow NULL? 
79DOWNPDown payments on assetdecimal132CURR((0))YesANSAZ
NamePrimaryUniqueTypeColumns
/ATL/AANLCP~0YesYesCLUSTEREDZUCOD, ZUJHR, AFABE, PERAF, GJAHR, ANLN2, ANLN1, BUKRS, MANDT