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

50 columns | Print definition?ERP 6.0  | UNIQUE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOBF/AU_DAC_UPDUsed by Unit Tests of FUGR /BOPF/CL_DAC_UPDATE3UNIQUE_IDnvarchar100
2OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN11UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
3OIUY6_WY_ASU_DTRoyalty 2.0 - WY - Auto Suspend Detail10UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
4OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)50UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
5OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface50UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
6OIUY6_WY_LEASERoyalty 2.0 - WY - Lease Data3UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
7OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data11UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
8OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist47UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
9OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions47UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
10OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details49UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
11OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)50UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
12OIUY6_WY_PRICERoyalty 2.0 - WY - Report Pricing4UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
13OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History47UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
14OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)48UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
15OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)47UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
16OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions47UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
17OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)48UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
18OIUY6_WY_RPDTCRoyalty 2.0 - WY - Lease/Unit Report Detail - CA5UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
19OIUY6_WY_RPDTDRoyalty 2.0 - WY - Report Details6UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
20OIUY6_WY_RPDTMRoyalty 2.0 - WY - Lease/Unit Report Detail - Masters5UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
21OIUY6_WY_RPDTPRoyalty 2.0 - WY - Lease/Unit Report Detail - Production5UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
22OIUY6_WY_RPDTSRoyalty 2.0 - WY - Lease/Unit Report Detail - PR/CA Summar5UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
23OIUY6_WY_RPDTURoyalty 2.0 - WY - Report Details Unit5UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
24OIUY6_WY_SOLEDTRoyalty 2.0 - WY Statute of Limitation Exception Detail4UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
25OIUY6_WY_ZVOLRoyalty 2.0 - WY - Zero Volume Master6UNIQUE_IDRoyalty 2.0 - Wyoming - PSAnvarchar200
26T7UNPF_FI_OPRHDOperation Header3UNIQUE_IDUnique IDnvarchar150
27T7UNPF_HR_CHILDChild details4UNIQUE_IDUnique IDnvarchar150
28T7UNPF_HR_CNTRCContract details4UNIQUE_IDOrg Global Unique IDnvarchar150
29T7UNPF_HR_DEPNDDependent details4UNIQUE_IDUnique IDnvarchar150
30T7UNPF_HR_DSDuty Station details4UNIQUE_IDOrg Global Unique IDnvarchar150
31T7UNPF_HR_LANGLanguage Allowance4UNIQUE_IDOrg Global Unique IDnvarchar150
32T7UNPF_HR_LWOPLeave Without Pay4UNIQUE_IDOrg Global Unique IDnvarchar150
33T7UNPF_HR_OPRHDOperation Header3UNIQUE_IDUnique IDnvarchar150
34T7UNPF_HR_PARTParttime Details4UNIQUE_IDOrg Global Unique IDnvarchar150
35T7UNPF_HR_SALSalary details4UNIQUE_IDOrg Global Unique IDnvarchar150
36T7UNPF_HR_SECONStaff Secondment details4UNIQUE_IDOrg Global Unique IDnvarchar150
37T7UNPF_HR_SEPStaff Member Separation details4UNIQUE_IDOrg Global Unique IDnvarchar150
38T7UNPF_HR_STAFFStaff Member Table4UNIQUE_IDOrg Global Unique IDnvarchar150
TOPCentral Part of Product Master
39COMC_ALTID_TYPEControl Data for Alternative Product IDs14UNIQUE_IDIndicator: Alternative ID Type is Uniquenvarchar10
TOPData Staging
40RSICSDELSTATStatistics on Records in Requests After Selective Deletion8UNIQUE_IDUser field for cluster PC (national)nvarchar250
41RSICSDELSTATCTRLControl Table for RSICSDELSTAT for Selective Deletion12UNIQUE_IDUser field for cluster PC (national)nvarchar250
TOPeCATT Extended Computer Aided Test Tool
42ECWD_RESOURCESeCATT: Database Table for WD Resources (HTML)1UNIQUE_IDnvarchar650
TOPOffice Suite Program
43SOSP_T_BKT_PERFMBook Keeping table for Performance2UNIQUE_IDGUIDnvarchar320
44SOSP_T_MAP_INFOMapping Information2UNIQUE_IDGUIDnvarchar320
45SOSP_T_STAT_ACTNStatus Transition - Action customization2UNIQUE_IDGUIDnvarchar320
TOPSecurity
46LAW_ERRORError Text Table for License Administration Workbench1UNIQUE_IDNumeric Character Field, Length 10nvarchar100
47LAW_GROUPINGTemporary Table for Grouping Users20UNIQUE_IDNumeric Character Field, Length 10nvarchar100
48LAW_RESULTResult of License Measurement Consolidation1UNIQUE_IDLAW: Unique Identification Within the LAWnvarchar100
49LAW_UNIQUEGrouped User Data20UNIQUE_IDNumeric Character Field, Length 10nvarchar100
50LAW_UTYPESResult of License Measurement Consolidation1UNIQUE_IDNumeric Character Field, Length 10nvarchar100