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
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

150 columns | Print definition?B1 9.2  | CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1AAD1Administration Extension-Log15CodeCodeInt1101
2AADMAdministration - Log270CodeCodeInt1101
3ACFPCFOP for Nota Fiscal2CodeCFOP CodenVarChar60
4ADM1Administration Extension15CodeCodeInt1101
5ADM2Administration Electronic Report1CodeCodeInt110
6AFMLTax Formula Master Table2CodeCodenVarChar200
7ALR1Queue of messages to be sent1CodeInternal NumberInt110
8ALR2Dynamic message data row1CodeInternal NumberInt110
9ALR3Dynamic message data cells1CodeInternal NumberInt110
10ALT1Alerts - Users1CodeInternal NumberInt110
11ASTCSales Tax Codes1CodeCodenVarChar80
12ATSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
13CSTNWorkstation ID1CodeCodeInt110
14MAP1Input and Output of Mapping2CodeCodeInt110
15MLS1Distribution Lists - Recipients1CodeCodeInt110
16OADFAddress Formats1CodeCodeInt60
17OADMAdministration270CodeCodeInt1101
18OALRAlerts1CodeInternal NumberInt110
19OALTAlerts Template1CodeInternal NumberInt110
20OBDCB1i DI Configuration1CodeCodeInt110
21OBMIBrazilian Multi-Indexer3CodeCodenVarChar100
22OBOICount Widget2CodeCount Widget CodenVarChar150
23OBSIBrazil String Indexer2CodeCodenVarChar300
24OCDTCredit Card Payment1CodeCredit Card Payment CodenVarChar80
25OCFPCFOP for Nota Fiscal2CodeCFOP CodenVarChar60
26OCNTCounties2CodeCounty CodenVarChar70
27OCRYCountries1CodeCodenVarChar30
28OCSNCertificate Series2CodeCodenVarChar40
29OCSTStates1CodeCodenVarChar30
30ODCIIntrastat Configuration3CodeCodenVarChar500
31ODMWData Migration1CodePackage CodeInt110
32OFMLTax Formula Master Table2CodeCodenVarChar200
33OGPCGovernment Payment Code2CodeCodenVarChar60
34OGSPGoods Shipment1CodeCodeVarChar10
35OINDTriangular Deal1CodeCodeVarChar10
36OJPELocal Era Calendar1CodeLocal Era CodeVarChar10
37OLNGUser Language Table1CodeCodeInt110
38OMAOMobile Add-On Setting1CodeCodenVarChar200
39OMLSDistribution List1CodeCodeInt110
40ONFTNota Fiscal Tax Category (Brazil)2CodeTax CategorynVarChar200
41ONOANature of Assessee2CodeCodenVarChar40
42OOCCBoE Occurrence Code2CodeCodenVarChar100
43OPROProperty Object3CodeInput/Output CodeInt110
44OPVLLender - Pelecard1CodeInternal NumberInt110
45ORITDunning Interest Rate1CodeInterest CodenVarChar200
46ORMKRemark 12CodeCodeVarChar10
47OSECSections2CodeCodenVarChar150
48OSSPService Supply1CodeCodeVarChar10
49OSTASales Tax Authorities1CodeCodenVarChar80
50OSTCSales Tax Codes1CodeCodenVarChar80
51OTFCTax Type Combination2CodeCodenVarChar200
52OTPATax Parameter Attributes2CodeAttribute CodenVarChar80
53OTPRTax Return Values2CodeReturn Value CodenVarChar70
54OTPSTax Parameter2CodeCodenVarChar50
55OTSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
56OUDGUser Defaults1CodeCodenVarChar80
57OUDOUser-Defined Object1CodeCodenVarChar200
58RIT1Interest Rates1CodeObject CodenVarChar200
59SMSGSMSG1CodeInternal KeyInt11011=Unique key
60UDG1User Defaults - Documents1CodeCodenVarChar80
61UDG2User Defaults - Credit Cards1CodeCodenVarChar80
62UDO1User-Defined Objects - Child1CodeCodenVarChar200
63UDO2User-Defined Objects - Find Columns1CodeCodenVarChar200
64UDO3User-Defined Objects - Found Columns1CodeCodenVarChar200
65UDO4User-Defined Objects - Child Table Columns1CodeCodenVarChar200
TOPBanking
66ACH1Checks for Payment - Rows - History8CodeTax DefinitionnVarChar80
67BOE1Bill of Exchange for Payment - Rows8CodeTax DefinitionnVarChar80
68CHD1Checks for Payment Drafts - Rows8CodeTax DefinitionnVarChar80
69CHO1Checks for Payment - Rows8CodeTax DefinitionnVarChar80
70OBCABank Charges Allocation Codes1CodeCodenVarChar30
71OPBDDocument Type1CodeCodenVarChar20
72OPBUBudget ID1CodeBudget ID CodenVarChar1000
73OPFTPortfolio Definitions1CodeCodenVarChar80
74OPPTPayment Type1CodeCodenVarChar20
75OPRSTax Payer Status1CodeCodenVarChar20
76OPYDPayment Run1CodePayment Run CodenVarChar200
77OPYRPayment Reason1CodeCodenVarChar20
78OUBRBranches1CodeCodeInt60
79OUDPDepartments1CodeCodeInt60
TOPBusiness Partners
80OCLOMeetings Location1CodeCodeInt60
81OCLSActivity Subjects1CodeCodeInt60
82OCLTActivity Types1CodeCodeInt60
TOPFinance
83AAC1Asset Classes - Depreciation Areas - History1CodeCodenVarChar200
84AACSAsset Classes - History1CodeCodenVarChar200
85AADTFixed Assets Account Determination - History1CodeCodenVarChar150
86ACS1Asset Classes - Depreciation Areas1CodeCodenVarChar200
87ADPAFixed Asset Depreciation Areas - History1CodeCodenVarChar150
88ADT1Depreciation Types - Rows - History1CodeCodenVarChar150
89ADTPFixed Assets Depreciation Types - History1CodeCodenVarChar150
90AFPRPosting Period-Log2CodePeriod CodenVarChar200
91AVT1Tax Definition1CodeGroup CodenVarChar80
92AVTGTax Definition1CodeCodenVarChar80
93AWH2WTax Definition - Rows22CodeTax CodenVarChar40
94DTP1Depreciation Types - Rows1CodeCodenVarChar150
95FAA1Asset Attributes - Rows1CodeCodeInt110
96OACRAccrual Type1CodeAccrual Type CodenVarChar80
97OACSAsset Classes1CodeCodenVarChar200
98OADGDepreciation Groups1CodeCodenVarChar150
99OADTFixed Assets Account Determination1CodeCodenVarChar150
100OAGSAsset Groups1CodeCodenVarChar150
101OASCAccount Segmentation Categories2CodeCodenVarChar200
102OCDCCash Discount1CodeCodenVarChar200
103OCFLCash Flow Additional Trans.1CodeCodeInt110
104OCIGCIG Codes2CodeContract Code IdentificationnVarChar100
105OCUPCUP Codes2CodeUnique Code of ProjectnVarChar150
106ODPAFixed Asset Depreciation Areas1CodeCodenVarChar150
107ODPPDepreciation Type Pools1CodeCodenVarChar20
108ODTPFixed Assets Depreciation Types1CodeCodenVarChar150
109OFAAAsset Attributes1CodeCodeInt110
110OFPRPosting Period2CodePeriod CodenVarChar200
111OFYMFinancial Year Master2CodeCodenVarChar60
112OIDCIndicator1CodeIndicator CodenVarChar20
113OVTGTax Definition1CodeCodenVarChar80
114VTG1Tax Definition1CodeGroup CodenVarChar80
115WHT2Withholding Tax Definition - Rows22CodeTax CodenVarChar40
116ZRD1POS Daily Summary - Totals3CodeTotalizer CodenVarChar80
TOPGeneral
117OBFIBrazil Fuel Indexer1CodeFuel CodenVarChar100
118OBNIBrazil Numeric Indexer2CodeCodeInt110
119OCIPConfiguration of Integration Packages2CodePackage CodenVarChar100
120OCPTCockpit Main Table2CodeCockpit CodeInt60
121OKPIKey Performance Indicator Package2CodeKPI CodenVarChar2500
122OPTIPoint of Issue1CodeCodenVarChar50
123OSESOSES1CodeSEFAZ Country CodenVarChar150
124RLNGRLNG3CodeLanguage codeInt110
125SEWSTSEWST1CodeCodenVarChar80
126SLSCLocal Settings Components CABs2CodeCodenVarChar200
127SLSDLocal Settings1CodeCodenVarChar30
128TYPRTYPR1CODEReport TypenVarChar40
TOPInventory and Production
129AITTProduct Tree - History1CodeParent ItemnVarChar200
130ATT1Bill of Materials - Components - History3CodeChild CodenVarChar200
131ITT1Bill of Materials - Components3CodeComponent CodenVarChar200
132OCYCCycle1CodeCycle CodeInt60
133OITTProduct Tree1CodeParent ItemnVarChar200
134OLCTLocation1CodeLocation CodeInt110
135OPSCProduct Source Code1CodeSource CodeInt60
TOPMarketing Documents
136ORCPRecurring Transaction Template2CodeTemplate CodenVarChar80
TOPMRP
137OFCTSales Forecast2CodeForecast CodenVarChar160
TOPReports
138AEC1Parameters for Various Types of Electronic Communication1CodeCodeVarChar10
139AEC2Electronic Transactions2CodeCodeVarChar10
140AECMElectronic Communication Types or Protocols1CodeCommunication Type or ProtocolVarChar10
141ECM1Parameters for Various Types of Electronic Communication1CodeCodeVarChar10
142ECM2Electronic Transactions2CodeCodeVarChar10
143FLT1856 Report - Selection Criteria2CodeCodenVarChar500
144OECMElectronic Communication Types or Protocols1CodeCommunication Type or ProtocolVarChar10
145OQWZQuery Wizard1CodeQuery CodenVarChar80
146OTRXTransformation Documents2CodeCodenVarChar200
147QWZ1Query Tables1CodeQuery CodenVarChar80
148QWZ2Query Result Fields1CodeQuery CodenVarChar80
149QWZ3Query Condition Fields1CodeQuery CodenVarChar80
150RTYPDocument Type List1CODEReport TypenVarChar40