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

36 columns | Print definition?ERP 6.0  | LASTDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/NEWDEVPROJSAIF development projects3LASTDATELast Datenvarchar80
2/AIF/NEWDEV_IDSAIF new development IDs6LASTDATELast Datenvarchar80
3/AIF/TOPIC_STTopic status5LASTDATELast Datenvarchar80
4/AIF/TOPIC_ST_HTopic status (history table)2LASTDATELast Datenvarchar80
5/AIF/T_TOPICTopic definition7LASTDATELast Datenvarchar80
6/AIF/T_TOPIC_TRTopic definition4LASTDATELast Datenvarchar80
TOPBasic Data
7NCMONIS-HCM: Function Modules for Monitoring Program8LASTDATEIS-HCM: Date of Last Checknvarchar80
TOPContract Accounts Receivable and Payable
8DFKKORDERDUERequests: Due Dates6LASTDATELast Due Datenvarchar80
TOPCross-Application Components
9J_2GLPP3Print Task codes Series and numbers12LASTDATELast date a document was printnvarchar80
TOPData Staging
10RSLDPSELSelection table for fields scheduler40LASTDATEDatenvarchar80
11RSLDPSELHISTSelection Table for Fields of Scheduler - Changes/History41LASTDATEDatenvarchar80
12RSLDPSELSHSelection table for fields scheduler39LASTDATEDatenvarchar80
13RSSMSHAREMDMaster Data4LASTDATESystem Datenvarchar80
TOPDocumentation Tools
14TUCHK1Starting points for the reengineering analysis jobs3LASTDATEDate of Last Changenvarchar80
TOPElectronic Data Interchange
15PRICAT_K010SPrice Catalog: Last Structure of Structures6LASTDATEDate of Last Changenvarchar80
16WRF_PRICAT_010APrice Catalog Generic Structures per Catalog5LASTDATEDate of Last Changenvarchar80
TOPFinancial Accounting
17OFFNUM_CNAssign Number group and Prefix to comp. code and doc. class6LASTDATEDate of last number assignmentnvarchar80
18OFNUM_IT_1Official Numbering by Document Class-enabled ranges(IT)5LASTDATEDate of last number assignmentnvarchar80
19OFNUM_MXAssign Official Numbering with Approval Number10LASTDATEDate of last number assignmentnvarchar80
TOPForms Processing
20FPCONTEXTForm Objects: Context10LASTDATEChanged Onnvarchar80
21FPINTERFACEForm Objects: Interface8LASTDATEChanged Onnvarchar80
22FPLAYOUTForm Objects: Layout7LASTDATEChanged Onnvarchar80
TOPIncentive and Commission Management ICM
23TCACS_RESPACKReserved Areas for ISF Packages6LASTDATEDate on which entry was last changednvarchar80
TOPKnowledge Base
24ISUSRSDB: Table for user recently edited symptoms/solutions4LASTDATE(8-character) Date for SYSTnvarchar80
TOPLocalization
25OFF_NUM_IDSettings for Official Document Numbering Indonesia12LASTDATEDate of last number assignmentnvarchar80
26OFNUM_TW_2Official Numbering by Business Places-enabled ranges(TW)10LASTDATEDate of last number assignmentnvarchar80
TOPMaterial Master
27WGDS_STR_VERSIONStructure version4LASTDATEDate of Last Changenvarchar80
TOPMicrosoft SQL Server
28MSSDWDLLSHolds records on the dlls in the disp+work5LASTDATEnvarchar80
TOPSmart Forms
29SSFXSFBMPSmart Forms: BMP Cache (for XSF Output, for Example)6LASTDATEnvarchar80
30SSFXSFCSSSmart Forms: CSS Cache (for XSF Output, for Example)3LASTDATEnvarchar80
31STXFADMSmart Forms: Administration9LASTDATEChanged Onnvarchar80
32STXSADMSmart Styles: Administration8LASTDATEChanged Onnvarchar80
TOPTranslation Tools
33TRNL_WLWorklists of Translation (Header Data)7LASTDATEDate of Last Changenvarchar80
TOPTransport Organizer
34GTABKEY_MAILGTABKEY Mail Recipient8LASTDATEDate of Last Changenvarchar80
35GTABKEY_TABEXCLTables Excluded from Conflict Check7LASTDATEDate of Last Changenvarchar80
36TRESCReserved Names for Customizing Tables/Objects8LASTDATEDate on which entry was last changednvarchar80