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

177 columns | Print definition?B1 9.3  | NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ASTCSales Tax Codes2NameNamenVarChar1000
2ASTTSales Tax Authorities Type2NameType NamenVarChar400
3AWMGWorkflow Manager4NameNamenVarChar2540
4AWTSWorkflow Engine Task Table7NameNamenVarChar2540
5CDPMDynamic Permission2NameNamenVarChar640
6CSPISolution Packager Information2NameParameter NamenVarChar500
7GFL2Grid Filter Name5NameNamenVarChar1000
8MAP2Mapping Input and Output Relation5NameParameter NamenVarChar200
9MDC1Master Data Cleanup - Log5NameNamenVarChar1000
10OADFAddress Formats2NameNamenVarChar500
11OALTAlerts Template2NameNamenVarChar2540
12OBOICount Widget3NameNamenVarChar1000
13OBRWBrowser Widget2NameBrowser Widget NamenVarChar1000
14OCDTCredit Card Payment2NameCredit Card Payment NamenVarChar300
15OCMNCustomized Menu2NameMenu Item NamenVarChar1000
16OCNTCounties5NameCounty NamenVarChar1000
17OCRYCountries2NameNamenVarChar1000
18OCSCCrystal Server Configuration2NameServer NamenVarChar1000
19OCSTStates3NameNamenVarChar1000
20ODMWData Migration2NamePackage NamenVarChar200
21OENCEncryption Types1NameNamenVarChar1000
22OFRMFile Format2NameFile Format NamenVarChar1000
23OGSPGoods Shipment2NameNamenVarChar500
24OINDTriangular Deal2NameNamenVarChar500
25OLLFLegal List Format2NameElectronic File NamenVarChar1000
26OLNGUser Language Table3NameLanguagenVarChar300
27OMAOMobile Add-On Setting2NameNamenVarChar2000
28OMDCMaster Data Cleanup2NameMaster Data Cleanup NamenVarChar1000
29OMLSDistribution List2NameNamenVarChar300
30OMPSMap Services2NameNamenVarChar200
31OPROProperty Object5NameProperty NamenVarChar500
32OPVLLender - Pelecard2NameNamenVarChar500
33ORITDunning Interest Rate2NameInterest NamenVarChar500
34ORLSReference Links Sources2NameNamenVarChar1000
35OSSPService Supply2NameNamenVarChar500
36OSTASales Tax Authorities2NameNamenVarChar1000
37OSTCSales Tax Codes2NameNamenVarChar1000
38OSTTSales Tax Authorities Type2NameType NamenVarChar400
39OUDGUser Defaults2NameNamenVarChar200
40OUDOUser-Defined Object2NameNamenVarChar1000
41OUPTUser Autorization Tree2NameNamenVarChar640
42OWMGWorkflow Manager4NameNamenVarChar2540
43OWSTConfirmation Level2NameNamenVarChar200
44OWTIWorkflow Timer Definition2NameNamenVarChar500
45OWTMApproval Templates2NameNamenVarChar200
46OWTSWorkflow Engine Task Table7NameNamenVarChar2540
47SPRGApplication Start3NameApplication NamenVarChar1280
TOPBanking
48OBCABank Charges Allocation Codes2NameDescriptionnVarChar500
49OPFTPortfolio Definitions2NameNamenVarChar500
50OPYDPayment Run2NamePayment Run NamenVarChar500
51OUBRBranches2NameBranches NamenVarChar200
52OUDPDepartments2NameDepartments NamenVarChar200
TOPBusiness Partners
53ACPNCampaign2NameCampaign NamenVarChar1000
54ACPRContact Persons - History3NameContact Person NamenVarChar500
55OCLAActivity Status2nameStatus NamenVarChar300
56OCLOMeetings Location2NameNamenVarChar500
57OCLSActivity Subjects2NameNamenVarChar200
58OCLTActivity Types2NameNamenVarChar200
59OCPNCampaign2NameCampaign NamenVarChar1000
60OCPRContact Persons3NameContact Person NamenVarChar500
61OPRTPartners2NameNamenVarChar150
TOPFinance
62AACSAsset Classes - History2NameNamenVarChar1000
63AFPRPosting Period-Log3NamePeriod NamenVarChar200
64AVTGTax Definition2NameNamenVarChar500
65OACGAccount Category2NameNamenVarChar400
66OACRAccrual Type2NameAccrual Type NamenVarChar300
67OACSAsset Classes2NameNamenVarChar1000
68OASCAccount Segmentation Categories3NameNamenVarChar1000
69OASGAccount Segmentation2NameNamenVarChar1000
70OBGSBudget Scenario2NameNamenVarChar1000
71OFAAAsset Attributes2NameNamenVarChar1000
72OFPRPosting Period3NamePeriod NamenVarChar200
73OFRCFinancial Report Categories3NameNamenVarChar2540
74OFRTFinancial Report Templates2NameNamenVarChar1000
75OIDCIndicator2NameIndicator NamenVarChar500
76OSCMSpecial Ledger - Analytical Accounting Configuration Rules: Material6NameRule NamenVarChar1000
77OSCRSpecial Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses6NameRule NamenVarChar1000
78OSHRShareholder's Rights and Interests Report History2NameReport NamenVarChar400
79OSVTDefine Summary VAT Report Type2NameSummary VAT Report TypenVarChar2540
80OVTGTax Definition2NameNamenVarChar500
TOPGeneral
81APHAProject Management Subproject - History3NAMENamenVarChar2540
82APMGProject Management Document - History3NAMEProject NamenVarChar2540
83CFN1Default Common Functions5NameNamenVarChar1000
84COLMCOLM resource3NameTable NamenVarChar640
85ELCFGELCFG2NamenVarChar1000
86FORMFORM resource3NameForm namenVarChar640
87ITEMItem Resource3NameForm NamenVarChar640
88LOCLLocalizations Table3NameNamenVarChar320
89MFLDMetaData Tables Fields3NameField NamenVarChar200
90MHKYMetaData Tables HKeys3NameKey NamenVarChar100
91MTBLMetaData Tables1NameTable NamenVarChar50
92OCIPConfiguration of Integration Packages3NamePackage NamenVarChar2540
93OCPTCockpit Main Table3NameNamenVarChar200
94OFNSFolio Numbering - Series2NameNamenVarChar1000
95OGPAGross Profit Adjustment2NameGross Profit Adjustment NamenVarChar1000
96OKPIKey Performance Indicator Package3NameKPI NamenVarChar2500
97ONCPNew Cockpit Table2NameNamenVarChar1000
98OPHAProject Management Subproject3NAMENamenVarChar2540
99OPMGProject Management Document3NAMEProject NamenVarChar2540
100OPRIBrowser Access Printers2NamePrinter NamenVarChar2500
101OPSTService Call Problem Subtype2NameNamenVarChar200
102OSSGService App Setting groups2NameNamenVarChar1000
103OWDTWidget Table2NameWidget NamenVarChar200
104OXAPXAPP Master Data2NameName of XAPPnVarChar2500
105PACTPervasive's Insight to Action2NameInsight to Action NamenVarChar2500
106PMC1Project Management Configuration - Phase Types2NamePhase NamenVarChar1000
107PMC2Project Management Configuration - Stages Setup2NameStage NamenVarChar1000
108PMC3Project Management Configuration - Area2NameArea NamenVarChar1000
109PMC4Project Management Configuration - Priority2NamePriority NamenVarChar1000
110PMC6Project Management Configuration - Tasks2NameTask NamenVarChar1000
111RFRMFORM resource4NameForm namenVarChar640
112RFTLFITL resource4NameFITL namenVarChar640
113RLNG????4NameLanguage namenVarChar500
114RMTLMITL resource4NameMITL namenVarChar640
115RMTXMATX resource4NameMATX namenVarChar640
116ROBJTM Import/Export Obj2NameNamenVarChar1000
117RSTISTRI resource4NameSTRL namenVarChar640
118RSTRSTRL resource4NameSTRL namenVarChar640
119RUSRResource Users2NameUser NamenVarChar300
120SEWH1SEWH14NameAddOn NamenVarChar400
121SEWSTSEWST2NameNamenVarChar300
122SLSCLocal Settings Components CABs3NameNamenVarChar1000
123SLSDLocal Settings2NameNamenVarChar1000
124SPARSPAR2NameNamenVarChar2540
125STRIString list item resource3NameSTRL namenVarChar640
126STRLString List resource3NameSTRL namenVarChar640
127SWDPSWDP2NameDeployment NamenVarChar2540
128SWIDSWID1NameNamenVarChar2000
129SWPDSWPD5NameWF process definition namenVarChar2540
130SWRSSWRS2NameWorkflow Resouce NamenVarChar2540
131SXRCDXLR Class Definitions2namenamenVarChar500
132SXRDBXLR Databases1NameNamenVarChar500
133SXRETXLR Enum Types2namenamenVarChar500
134SXREVXLR Enum Values2namenamenVarChar500
135SXRMEXLR Members5NameNamenVarChar2440
136SXROBXLR Objects3namenamenVarChar500
137SXRPDXLR Property Definitions4namenamenVarChar500
138SXRROXLR Relations4NameNamenVarChar500
139TABLTable resource3NameTable namenVarChar640
140TYPRTYPR2NAMEType NamenVarChar2500
141UDABUDAB3nameDashboard NamenVarChar500
142XAP1Page of XAPP3NamePage namenVarChar2500
143XAP3XAP Filter3NameName of filternVarChar2500
144XSXAXS XApp Registration Info2NAMENAMEnVarChar2540
TOPHuman Resources
145OHEDEducation Types2nameNamenVarChar200
146OHPSEmployee Position2namePosition NamenVarChar200
147OHSTEmployee Status2nameNamenVarChar200
148OHTMEmployee Teams2nameTeam NamenVarChar200
149OHTRTermination Reason2nameNamenVarChar200
150OHTYEmployee Types2nameNamenVarChar200
TOPInventory and Production
151AITTProduct Tree - History25NameProduct DescriptionnVarChar1000
152APKLPick List - History2NameNamenVarChar1550
153ATT2BOM - Route Stages - History5NameStage NamenVarChar1000
154AWO4Production Order - Route Stages - History5NameStage NamenVarChar1000
155ITT2BOM - Route Stages5NameStage NamenVarChar1000
156OCYCCycle2NameCycle NamenVarChar200
157OITTProduct Tree25NameProduct DescriptionnVarChar1000
158OPKLPick List2NameNamenVarChar1550
159UWOR4Production Order - Route Stages5NameStage NamenVarChar1000
160WOR4Production Order - Route Stages5NameStage NamenVarChar1000
TOPMarketing Documents
161GPA2Gross Profit Adjustments - Parameters2NameWizard Parameters NamenVarChar1000
TOPMRP
162OFCTSales Forecast3NameForecast NamenVarChar1000
TOPReports
163OIRCInteractive Report Category3NameCategory NamenVarChar2540
164OQWZQuery Wizard2NameQuery NamenVarChar500
165OSOIStatement of Import Wizard2NameNamenVarChar1000
166RTYPDocument Type List2NAMEType NamenVarChar2500
167SRA3Scheduled Report Recipients5NameNamenVarChar1550
168XROBJXLR Company Report Objects2NameNamenVarChar500
TOPSales Opportunities
169AOPROpportunity36NameOpportunity NamenVarChar1000
170OCMTCompetitors2NameNamenVarChar150
171OOPROpportunity36NameOpportunity NamenVarChar1000
TOPService
172ORCIRecipient List2NameNamenVarChar300
173OSCOService Call Origins2NameNamenVarChar200
174OSCPService Call Problem Types2NameNamenVarChar200
175OSCSService Call Statuses2NameNamenVarChar200
176OSCTService Call Types2NameNamenVarChar200
177OSSTService Call Solution Statuses2NameNamenVarChar200