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

153 columns | Print definition?B1 9.2  | NAME

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