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
9OPOR386Purchase Order
10OVTG52Tax Definition

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

154 columns | Print definition?B1 9.3  | TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1APFSPersonal Fields Setup - History14TypeData ClassificationVarChar10NN=Not Personal, P=Personal, S=Sensitive Personal
2CSPISolution Packager Information3TypeParameter TypenVarChar200
3MAP1Input and Output of Mapping3TypeTypenVarChar100NACRYSTAL=Crystal Report, CSV=CSV File, NA=Not Avalible, TXT=Text File, XML=XML File
4OALRAlerts2TypeTypeVarChar10AA=Alert, M=Message
5OALTAlerts Template3TypeTypeVarChar10US=System Alert, U=User Alert
6OBRWBrowser Widget3TypeTypeInt6000=Web Site, 1=App
7OCMNCustomized Menu4TypeMenu TypeVarChar10C
8OLLFLegal List Format14TypeFormat TypenVarChar50LAR=Electronic Document, ARA=Electronic Authority Report, CFDD=CFDi Electronic Document, CFDIM=CFDI Electronic Input Message Document, CFDP=CFDi Electronic Payment & Reconciliation Document, CFDT=CFDI Electronic Transfer Document, CFDWS=CFDi Electronic Mapping for Web Service, EETD=EET Electronic Document, EETWS=EET Electronic Mapping for W
9OMAOMobile Add-On Setting4TypeTypeVarChar10MH=Home, M=Module
10OPFSPersonal Fields Setup14TypeData ClassificationVarChar10NN=Not Personal, P=Personal, S=Sensitive Personal
11OPROProperty Object4TypeProperty TypenVarChar60StrinStrin=String, XML=XML
12OSTASales Tax Authorities6TypeTypeInt110
13OSUSSupport Usage Statistics3TypeTypeInt110
14OUDOUser-Defined Object5TYPEObject TypeVarChar1011=Master Data, 3=Document
15OVMCValue Mapping Communication Object4TypeTypenVarChar20MDMD=Master Data, TR=Transaction
16OWJBWorkflow Job Entity7TypeTypenVarChar2500
17TCD4Withholding Tax Code Determination4TypeWTax Code TypeVarChar10LL=Line Item WT Code, P=AP Default WT Code, R=AR Default WT Code
18TCD5Tax Code by Usage5TypeTax Code TypeVarChar10LL=Line Item Tax Code, P=A/P Default Tax Code, R=A/R Default Tax Code
TOPBanking
19OPFTPortfolio Definitions3TypeTypeVarChar10CB=Bill of Exchange, C=Cheque
20OPYMPayment Methods for Payment Wizard3TypeTypeVarChar10I=Incoming, O=Outgoing
TOPBusiness Partners
21ACPNCampaign3TypeCampaign TypeVarChar10EE=E-Mail, F=Fax, M=Mail, O=Other, P=Phone Call, S=SMS, T=Meeting, W=Web
22AOATBlanket Agreement9TypeAgreement TypeVarChar10GG=General, S=Specific
23OCLSActivity Subjects3TypeRelated TypeInt60-1
24OCPNCampaign3TypeCampaign TypeVarChar10EE=E-Mail, F=Fax, M=Mail, O=Other, P=Phone Call, S=SMS, T=Meeting, W=Web
25OOATBlanket Agreement9TypeAgreement TypeVarChar10GG=General, S=Specific
TOPFinance
26AJD2Withholding Tax - History16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
27AWHTWithholding Tax12TypeWithholding TypeVarChar10VI=Income Tax Withholding, V=VAT Withholding
28BTF2Journal Voucher Withholding Tax - History16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
29JDT2Withholding Tax - History16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
30JST1TDS Adjustment - Rows18TypeWithholding Tax TypeVarChar10I=Incoming Tax Withholding, V=VAT Withholding
31OASGAccount Segmentation4TypeTypeVarChar10AA=Alphanumeric, N=Numeric
32OWHTWithholding Tax12TypeWithholding TypeVarChar10VI=Income Tax Withholding, V=VAT Withholding
TOPGeneral
33AHFCHide Functions Configuration - History4TypeTypenVarChar6000=System, 1=User
34ATSHProject Management Time Sheet - Header - History4TypeTypeVarChar10EE=Employee, O=Other, U=User
35BSJ1Backend Scheduling Sub Tasks3TypeTask TypenVarChar500
36ELCFGELCFG3TypenVarChar100
37FORMFORM resource5TypeForm typeInt11000=Resize Document, 1=Dialog Box, 3=No Title Document, 4=Fixed Document, 5=Resize No Title Document, 6=Toolbar, 7=Fixed No Minimize
38ITMRITMR4TypeTypeInt6010=Text field, 11=Picture field, 12=User field, 1=Page header, 2=Start of report, 3=Repetitive area header, 4=Repetitive area, 5=Repetitive area footer, 6=End of report, 7=Page footer
39KPI1Key Performance Indicator Field3TypeKPI Field TypeInt110
40KPI2Key Performance Indicator Scope3TypeKPI Scope TypenVarChar2500
41KPI3Key Performance Indicator Parameter or Filter3TypeTypenVarChar200
42MFLDMetaData Tables Fields6TypeTypeVarChar10AA=DB Alpha, B=DB Binary, D=DB Date, I=DB Auto Key, M=DB Memo, N=DB Numeric
43MTBLMetaData Tables3TypeTable TypeInt6011=User OM, 2=User, 3=System OM, 4=System
44NCP1New Cockpit Tile3TypeTypenVarChar200
45NCP2New Cockpit Tile2TypeTypenVarChar200
46OBSJBackend scheduling job2TypeJob TypenVarChar1000
47OBTABrazil - Tax Adjustment7TypeTypeInt60110=ICMS-ST Obligations to Pay or Paid - Own Operations, 11=Adjustment of IPI Appraisal, 12=Adjustment of PIS Appraisal, 13=Adjustment of COFINS appraisal, 1=Referred Collection Document, 2=Other Obligations, Adjustments, and Information Originating from Fiscal Documents, 3=Adjustment of ICMS Appraisal, 4=Adjustment and Additional Informati
48OCPTCockpit Main Table18TypeTypeVarChar10UT=Template, U=User
49OCUCCUS Configuration2TypeTypeInt110
50OHFCHide Functions Configuration4TypeTypenVarChar6000=System, 1=User
51ONCPNew Cockpit Table10TypeTypeVarChar10TT=Template, U=User
52OPMXPayroll13TypeTypeVarChar10PE=Expenses, P=Payroll
53OPTIPoint of Issue3TypeTypeVarChar10PE=Domestic Electronic, F=Fiscal, P=Domestic Printing, T=Export Electronic, X=Export Printing
54OTSHProject Management Time Sheet - Header4TypeTypeVarChar10EE=Employee, O=Other, U=User
55PACTPervasive's Insight to Action3TypeInsight to Action TypenVarChar500
56RFRMFORM resource9TypeForm typeInt11000=Resize Document, 1=Dialog Box, 3=No Title Document, 4=Fixed Document, 5=Resize No Title Document, 6=Toolbar
57SCUCSCUC2TypeTypeInt110
58SLSCLocal Settings Components CABs4TypeTypeVarChar10C=Chart of accounts, H=HANA Content, L=CR Layout, O=Objects, P=CR Report, R=Reports
59SXRELXLR Event Log2TypeTypeInt110
60SXRETXLR Enum Types3typetypeInt110
61SXRPDXLR Property Definitions7typetypeInt1100
62SXRTEXLR Terms3TypeTypeInt110
63UDABUDAB4typeDashboard TypeVarChar10
64WPK1Dashboard Packages' Parameter or Filter3TypeTypenVarChar200
65XAP2XAPP Widget3TypeWidget TypenVarChar2500
66XAP3XAP Filter4TypeType of filternVarChar2500
TOPHuman Resources
67AHE1Absence Information9typeAbsence TypeInt110
68AHE2Education5typeEducation TypeInt110
69AHEMEmployees - History7typeEmployee TypeInt110
70HEM1Absence Information9typeAbsence TypeInt110
71HEM2Education5typeEducation TypeInt110
72OHEMEmployees7typeEmployee TypeInt110
TOPInventory and Production
73AEDGDiscount Groups2TypeTypeVarChar10A=All BPs, C=Customer Group, S=Specific BP, V=Vendor Group
74ATT1Bill of Materials - Components - History24TypeComponent TypeInt1104-18=Text, 290=Resource, 4=Item
75AWORProduction Order - History6TypeProduction Order TypeVarChar10SD=Disassembly, P=Special, S=Standard
76IGE5Goods Issue - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
77IGN5Goods Receipt - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
78ITT1Bill of Materials - Components24TypeComponent TypeInt1104-18=Text, 290=Resource, 4=Item
79OCYCCycle8TypeCycle TypeVarChar10CC=Cycle, M=MRP
80OEDGDiscount Groups2TypeTypeVarChar10A=All BPs, C=Customer Group, S=Specific BP, V=Vendor Group
81OWORProduction Order6TypeProduction Order TypeVarChar10SD=Disassembly, P=Special, S=Standard
82UWORProduction Order6TypeProduction Order TypeVarChar10SD=Disassembly, P=Special, S=Standard
83WTQ5Inventory Transfer Request - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
84WTR5Inventory Transfer - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
TOPMarketing Documents
85ADO25Mktg Docs - Amt Per VAT Grp - History10TypeTypeInt11011=Discount by Tax
86ADO5Withholding Tax - History16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
87CIN25Correction Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
88CIN5AR Correction Invoice - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
89CPI25A/P Correction Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
90CPI5Withholding Tax Data16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
91CPV25A/P Correction Invoice Reversal - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
92CPV5A/P Correction Invoice Reversal - WTax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
93CSI25A/R Correction Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
94CSI5A/R Correction Invoice - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
95CSV25A/R Correction Invoice Reversal - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
96CSV5A/R Correction Invoice Reversal - WTax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
97DLN25Delivery - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
98DLN5Delivery - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
99DPI25A/R Down Payment - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
100DPI5A/R Down Payment - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
101DPO25A/P Down Payment - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
102DPO5A/P Down Payment - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
103DRF25Draft - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
104DRF5Draft Documents - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
105IEI25Incoming Excise Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
106IEI5Incoming Excise Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
107IGE25Goods Issue - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
108IGN25Goods Receipt - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
109INV25A/R Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
110INV5A/R Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
111OEI25Outgoing Excise Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
112OEI5Outgoing Excise Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
113PCH25A/P Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
114PCH5A/P Invoice - Withholding Tax Data16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
115PDN25Goods Receipt PO - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
116PDN5Goods Reciept PO - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
117POR25Purchase Order - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
118POR5Purchase Order - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
119PQT25Purchase Quotation - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
120PQT5Purchase Quotation - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
121PRQ25Purchase Request - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
122PRQ5Purchase Request - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
123PRR25Goods Return Request - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
124PRR5A/P Return Request - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
125QUT25Sales Quotation - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
126QUT5Sales Quotation - Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
127RDN25Returns - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
128RDN5Returns - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
129RDR25Sales Order - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
130RDR5Sales Order - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
131RIN25A/R Credit Memo - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
132RIN5A/R Credit Memo - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
133RPC25A/P Credit Memo - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
134RPC5A/P Credit Memo - Withholding Tax16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
135RPD25Goods Return - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
136RPD5Goods Return - Withholding Tax Data16TypeWithholding TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
137RRR25Return Request - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
138RRR5A/R Return Request - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
139SFC25Self Credit Memo - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
140SFC5Self Credit Memo - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
141SFI25Self Invoice - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
142SFI5Self Invoice - Withholding Tax16TypeWithholding Tax TypeVarChar10I=Income Tax Withholding, V=VAT Withholding
143WTQ25Inventory Transfer Request - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
144WTR25Inventory Transfer - Amt Per VAT Grp10TypeTypeInt11011=Discount by Tax
TOPReports
145AEC1Parameters for Various Types of Electronic Communication16TypeUI TypeInt60
146ECM1Parameters for Various Types of Electronic Communication16TypeUI TypeInt60
147EJB2Docs List for ERV-JAb Wizard5TypeTypenVarChar30PDF=PDF, XML=XML
148GDP1General Data Protection Wizard - Personal Fields Setup8TypeTypeVarChar10NN=Not Relevant, P=Personal, S=Sensitive
149IRD1Report Definition - Rows2TypeTypeInt11011=XLSX
150OIRDReport Definition2TypeTypeInt1101
151OTRXTransformation Documents4TypeTypenVarChar80XSLTXSLT=XSLT Document
152RDFLDocument Standards6TYPETypeVarChar10LL=Layout, P=Print Sequence
153RITMReporting Element4TypeTypeInt6010=Text Field, 11=Picture Field, 12=User Field, 1=Page Header, 2=Start of Report, 3=Repetitive Area Header, 4=Repetitive Area, 5=Repetitive Area Footer, 6=End of Report, 7=Page Footer
154RTYPDocument Type List9TYPETypeVarChar10LL=Layout, P=Print Sequence