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

19 columns | Print definition?ERP 6.0  | USERTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1LAW2D_CONTLAW 2.0: User types included in another user type2USERTYPUser Type IDsnvarchar20
2ZSKSYSUSERuser in den IDES-Systemen19USERTYPnvarchar10
TOPSecurity
3LAW_CONTUser Types Included in Another User Type1USERTYPID for the User Types of the SAP Systemnvarchar20
4LAW_S_URES2Total Result of User Consolidation2USERTYPID for the User Types of the SAP Systemnvarchar20
5LAW_UPGRUser Types Created During Upgrade1USERTYPID for the User Types of the SAP Systemnvarchar20
6LAW_URES2Total Result of User Consolidation2USERTYPID for the User Types of the SAP Systemnvarchar20
7LAW_UTYPESResult of License Measurement Consolidation2USERTYPID for the User Types of the SAP Systemnvarchar20
TOPUser and Authorization Management
8TUGRPField Assignment for User Types1USERTYPID for the User Types of the SAP Systemnvarchar20
9TUL_AUCESSSystem Measurement: List of Unsuitable User Types1USERTYPID for the User Types of the SAP Systemnvarchar20
10TUTYHLPMass Maintain Price Categories3USERTYPID for the User Types of the SAP Systemnvarchar20
11TUTYPSAP System User Type Texts2USERTYPID for the User Types of the SAP Systemnvarchar20
12TUTYPASystem measurement: User types with attributes1USERTYPID for the User Types of the SAP Systemnvarchar20
13TUTYPASYSCUA: Available Features in Child System3USERTYPCUA: Available Features in Child Systemnvarchar20
14TUTYPNOWSYSSystem Measurement: System-Specific Active User Types4USERTYPID for the User Types of the SAP Systemnvarchar20
15TUTYPPSystem Measurement: Authorizations for User Classes3USERTYPID for the User Types of the SAP Systemnvarchar20
16TUTYPPLAssigning user types to price lists2USERTYPID for the User Types of the SAP Systemnvarchar20
17USRSYSUPPLCUA: Assignment of User Types to Price Lists4USERTYPID for the User Types in the System Landscapenvarchar20
18USRSYSUTPACUA: System Measurement: User Types with Attributes3USERTYPID for the User Types in the System Landscapenvarchar20
19USRSYSUTYPCUA: Texts for User Types in SAP System4USERTYPID for the User Types in the System Landscapenvarchar20