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
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

166 columns | Print definition?B1 9.3  | 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
11ARSTRoute Stages - History2CodeCodenVarChar500
12ASTCSales Tax Codes1CodeCodenVarChar80
13ATSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
14CSTNWorkstation ID1CodeCodeInt110
15MAP1Input and Output of Mapping2CodeCodeInt110
16MLS1Distribution Lists - Recipients1CodeCodeInt110
17OADFAddress Formats1CodeCodeInt60
18OADMAdministration270CodeCodeInt1101
19OALRAlerts1CodeInternal NumberInt110
20OALTAlerts Template1CodeInternal NumberInt110
21OBDCB1i DI Configuration1CodeCodeInt110
22OBMIBrazilian Multi-Indexer3CodeCodenVarChar100
23OBOICount Widget2CodeCount Widget CodenVarChar150
24OBSIBrazil String Indexer2CodeCodenVarChar300
25OCDTCredit Card Payment1CodeCredit Card Payment CodenVarChar80
26OCFPCFOP for Nota Fiscal2CodeCFOP CodenVarChar60
27OCNTCounties2CodeCounty CodenVarChar70
28OCRYCountries1CodeCodenVarChar30
29OCSNCertificate Series2CodeCodenVarChar40
30OCSTStates1CodeCodenVarChar30
31ODCIIntrastat Configuration3CodeCodenVarChar500
32ODMWData Migration1CodePackage CodeInt110
33OFMLTax Formula Master Table2CodeCodenVarChar200
34OGPCGovernment Payment Code2CodeCodenVarChar60
35OGSPGoods Shipment1CodeCodeVarChar10
36OINDTriangular Deal1CodeCodeVarChar10
37OJPELocal Era Calendar1CodeLocal Era CodeVarChar10
38OLNGUser Language Table1CodeCodeInt110
39OMAOMobile Add-On Setting1CodeCodenVarChar200
40OMLSDistribution List1CodeCodeInt110
41ONFTNota Fiscal Tax Category (Brazil)2CodeTax CategorynVarChar200
42ONOANature of Assessee2CodeCodenVarChar40
43OOCCBoE Occurrence Code2CodeCodenVarChar100
44OPROProperty Object3CodeInput/Output CodeInt110
45OPVLLender - Pelecard1CodeInternal NumberInt110
46ORITDunning Interest Rate1CodeInterest CodenVarChar200
47ORMKRemark 12CodeCodeVarChar10
48ORSTRoute Stages2CodeCodenVarChar500
49OSECSections2CodeCodenVarChar150
50OSSPService Supply1CodeCodeVarChar10
51OSTASales Tax Authorities1CodeCodenVarChar80
52OSTCSales Tax Codes1CodeCodenVarChar80
53OTFCTax Type Combination2CodeCodenVarChar200
54OTPATax Parameter Attributes2CodeAttribute CodenVarChar80
55OTPRTax Return Values2CodeReturn Value CodenVarChar70
56OTPSTax Parameter2CodeCodenVarChar50
57OTSCCST Code for Nota Fiscal2CODECST Code IncomingnVarChar200
58OUDGUser Defaults1CodeCodenVarChar80
59OUDOUser-Defined Object1CodeCodenVarChar200
60RIT1Interest Rates1CodeObject CodenVarChar200
61SMSGSMSG1CodeInternal KeyInt11011=Unique key
62UDG1User Defaults - Documents1CodeCodenVarChar80
63UDG2User Defaults - Credit Cards1CodeCodenVarChar80
64UDG3User Defaults - POS/Cash Register1CodeCodenVarChar80
65UDG4User Defaults - Default POI for Folio Numbering Documents1CodePOI CodenVarChar80
66UDO1User-Defined Objects - Child1CodeCodenVarChar200
67UDO2User-Defined Objects - Find Columns1CodeCodenVarChar200
68UDO3User-Defined Objects - Found Columns1CodeCodenVarChar200
69UDO4User-Defined Objects - Child Table Columns1CodeCodenVarChar200
TOPBanking
70ACH1Checks for Payment - Rows - History8CodeTax DefinitionnVarChar80
71BOE1Bill of Exchange for Payment - Rows8CodeTax DefinitionnVarChar80
72CHD1Checks for Payment Drafts - Rows8CodeTax DefinitionnVarChar80
73CHO1Checks for Payment - Rows8CodeTax DefinitionnVarChar80
74OBCABank Charges Allocation Codes1CodeCodenVarChar30
75OPBDDocument Type1CodeCodenVarChar20
76OPBUBudget ID1CodeBudget ID CodenVarChar1000
77OPFTPortfolio Definitions1CodeCodenVarChar80
78OPPTPayment Type1CodeCodenVarChar20
79OPRSTax Payer Status1CodeCodenVarChar20
80OPYDPayment Run1CodePayment Run CodenVarChar200
81OPYRPayment Reason1CodeCodenVarChar20
82OUBRBranches1CodeCodeInt60
83OUDPDepartments1CodeCodeInt60
TOPBusiness Partners
84OCLOMeetings Location1CodeCodeInt60
85OCLSActivity Subjects1CodeCodeInt60
86OCLTActivity Types1CodeCodeInt60
TOPFinance
87AAC1Asset Classes - Depreciation Areas - History1CodeCodenVarChar200
88AACSAsset Classes - History1CodeCodenVarChar200
89AADTFixed Assets Account Determination - History1CodeCodenVarChar150
90ACS1Asset Classes - Depreciation Areas1CodeCodenVarChar200
91ADPAFixed Asset Depreciation Areas - History1CodeCodenVarChar150
92ADT1Depreciation Types - Rows - History1CodeCodenVarChar150
93ADTPFixed Assets Depreciation Types - History1CodeCodenVarChar150
94AFPRPosting Period-Log2CodePeriod CodenVarChar200
95AVT1Tax Definition1CodeGroup CodenVarChar80
96AVTGTax Definition1CodeCodenVarChar80
97AWH2WTax Definition - Rows22CodeTax CodenVarChar40
98DTP1Depreciation Types - Rows1CodeCodenVarChar150
99FAA1Asset Attributes - Rows1CodeCodeInt110
100OACRAccrual Type1CodeAccrual Type CodenVarChar80
101OACSAsset Classes1CodeCodenVarChar200
102OADGDepreciation Groups1CodeCodenVarChar150
103OADTFixed Assets Account Determination1CodeCodenVarChar150
104OAGSAsset Groups1CodeCodenVarChar150
105OASCAccount Segmentation Categories2CodeCodenVarChar200
106OCDCCash Discount1CodeCash Discount CodenVarChar200
107OCFLCash Flow Additional Trans.1CodeCodeInt110
108OCIGCIG Codes2CodeContract Code IdentificationnVarChar100
109OCUPCUP Codes2CodeUnique Code of ProjectnVarChar150
110ODPAFixed Asset Depreciation Areas1CodeCodenVarChar150
111ODPPDepreciation Type Pools1CodeCodenVarChar20
112ODTPFixed Assets Depreciation Types1CodeCodenVarChar150
113OFAAAsset Attributes1CodeCodeInt110
114OFPRPosting Period2CodePeriod CodenVarChar200
115OFYMFinancial Year Master2CodeCodenVarChar60
116OIDCIndicator1CodeIndicator CodenVarChar20
117OVTGTax Definition1CodeCodenVarChar80
118RCI1Recipient List - Rows1CodeCodeInt110
119VTG1Tax Definition1CodeGroup CodenVarChar80
120WHT2Withholding Tax Definition - Rows22CodeTax CodenVarChar40
121ZRD1POS Daily Summary - Totals3CodeTotalizer CodenVarChar80
TOPGeneral
122ALT2Alerts - Groups1CodeInternal NumberInt110
123APHAProject Management Subproject - History8CodeSubproject No.Int110
124OBFIBrazil Fuel Indexer1CodeFuel CodenVarChar100
125OBNIBrazil Numeric Indexer2CodeCodeInt110
126OCIPConfiguration of Integration Packages2CodePackage CodenVarChar100
127OCPTCockpit Main Table2CodeCockpit CodeInt60
128OKPIKey Performance Indicator Package2CodeKPI CodenVarChar2500
129OPHAProject Management Subproject8CodeSubproject No.Int110
130OPTIPoint of Issue1CodeCodenVarChar50
131OSESOSES1CodeSEFAZ Country CodenVarChar150
132OSRCService App Report Configuration1CodeCodeInt110
133OSSGService App Setting groups1CodeCodeInt110
134OSTSService App Technician settings1CodeCodeInt110
135RLNG????3CodeLanguage codeInt110
136SEWSTSEWST1CodeCodenVarChar80
137SLSCLocal Settings Components CABs2CodeCodenVarChar200
138SLSDLocal Settings1CodeCodenVarChar30
139TYPRTYPR1CODEReport TypenVarChar40
TOPInventory and Production
140AITTProduct Tree - History1CodeParent ItemnVarChar500
141ATT1Bill of Materials - Components - History4CodeChild CodenVarChar500
142ITT1Bill of Materials - Components4CodeComponent CodenVarChar500
143OCYCCycle1CodeCycle CodeInt60
144OITTProduct Tree1CodeParent ItemnVarChar500
145OLCTLocation1CodeLocation CodeInt110
146OPSCProduct Source Code1CodeSource CodeInt60
TOPMarketing Documents
147ORCPRecurring Transaction Template2CodeTemplate CodenVarChar80
TOPMRP
148OFCTSales Forecast2CodeForecast CodenVarChar160
TOPReports
149AEC1Parameters for Various Types of Electronic Communication1CodeCodenVarChar80
150AEC2Electronic Transactions2CodeCodenVarChar80
151AEC4Import Mapping Determination2CodeCodenVarChar80
152AEC6Electronic Protocol DI API Properties1CodeCommunication Type or ProtocolInt1100=Invalid, 1=GEN, 2=EET, 3=CFDI, 4=FPA, 5=MTD
153AECMElectronic Communication Types or Protocols1CodeCommunication Type or ProtocolnVarChar80
154ECM1Parameters for Various Types of Electronic Communication1CodeCodenVarChar80
155ECM2Electronic Transactions2CodeCodenVarChar80
156ECM4Import Mapping Determination2CodeCodenVarChar80
157ECM6Electronic Protocol DI API Properties1CodeCommunication Type or ProtocolInt1100=Invalid, 1=GEN, 2=EET, 3=CFDI, 4=FPA, 5=MTD
158FLT1856 Report - Selection Criteria2CodeCodenVarChar500
159OECMElectronic Communication Types or Protocols1CodeCommunication Type or ProtocolnVarChar80
160OQWZQuery Wizard1CodeQuery CodenVarChar80
161OTRXTransformation Documents2CodeCodenVarChar200
162QWZ1Query Tables1CodeQuery CodenVarChar80
163QWZ2Query Result Fields1CodeQuery CodenVarChar80
164QWZ3Query Condition Fields1CodeQuery CodenVarChar80
165RTYPDocument Type List1CODEReport TypenVarChar40
TOPService
166ORCIRecipient List1CodeCodeInt110