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

22 columns | Print definition?ERP 6.0  | ATTRID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/REG_SEREASERE - Attribute Assignment2ATTRIDAttribute IDnvarchar320
2/XFT/REG_SETYASETY - Attribute Assignment2ATTRIDAttribute IDnvarchar320
3/XFT/REG_SEVAVAVSEVA - Variant Attribute Values3ATTRIDAttribute IDnvarchar320
4/XFT/REG_SPTYASPTY- Attribute Assignment2ATTRIDAttribute IDnvarchar320
5/XFT/REG_SPVAVAVSPVA - Variant Attribute Values4ATTRIDAttribute IDnvarchar320
6RSTT_LOGATTRAttributes for Test Entries4ATTRIDVariant IDnvarchar200
TOPEmployee Interaction Center
7THREIC_ATTREIC: Rule Modeler: Attributes3ATTRIDEIC: Rule Modeler: Attributenvarchar100
8THREIC_ATTR_OPEREIC: Rule Modeler: Operator to Attribute Assignments3ATTRIDEIC: Rule Modeler: Attributenvarchar100
9THREIC_ATTR_TEIC: Rule Modeler: Attribute Text4ATTRIDEIC: Rule Modeler: Attributenvarchar100
10THREIC_CONDEIC: Rule Modeler: Conditions4ATTRIDEIC: Rule Modeler: Attributenvarchar100
TOPIntegration Customer Relationship Management
11ECRM_REPL_TABMDG Param. Table for IS-U Sales Replication Error Handling4ATTRIDCharacter field, length 32nvarchar320
12EVER_PC_CONTRPARMast.Data Generator: Attribute Table for Mass Product Change3ATTRIDAttribute Name for Master Data Templatenvarchar320
13EVER_PC_MAP_PARMast.Data Generator: Attribute Table for Mass Product Change4ATTRIDAttribute Name for Master Data Templatenvarchar320
TOPMaster Data
14EPDCRMPRODPARAMTable for Paramaters for Product Ident. of CRM Products4ATTRIDAttribute Namenvarchar200
15EPDCRMPRODPIPSContains the CRM Product-Identifying Parameters4ATTRIDAttribute Namenvarchar200
16EPDPRODAIS-U Master Data Generator: Attribute6ATTRIDAttribute Namenvarchar200
17EPDTYPEAIS-U Master Data Generator: Master Data Template Attributes4ATTRIDAttribute Namenvarchar200
TOPRecords and Case Management
18RMPSREFGENPROFAAttributes in Profile for Indicator Generation3ATTRIDID of Attribute to be Generatednvarchar320
19RMPSREFGENPROFRGeneration Rules in Profile for Indicator Generation RMPS3ATTRIDID of Attribute to be Generatednvarchar320
TOPUser and Authorization Management
20USATTRDEFDirectory of Additional User Attributes2ATTRIDUser Attribute IDnvarchar200
21USATTRDEFTDirectory of Additional User Attributes3ATTRIDUser Attribute IDnvarchar200
22USRATTRAdditional Attributes for Users3ATTRIDUser Attribute IDnvarchar200