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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
8OINM101Whse Journal
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data

27 columns | Print definition?ERP 6.0  | SEARCHTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRACFUNCPRMFunction Action Permission relationship10SEARCHTYPESearch Typenvarchar30
2GRACFUNCPRMARCFunction Action Permission Archive10SEARCHTYPESearch Typenvarchar30
3GRACFUNCPRMEXARCFunction Action Permission relationship for Ext Objs-Archive11SEARCHTYPESearch Typenvarchar30
4GRACFUNCPRMEXTFunction Action Permission relationship for Extended Objects11SEARCHTYPESearch Typenvarchar30
5GRACFUNCPRMEXTNFunction Action Permission Extension11SEARCHTYPESearch Typenvarchar30
6GRACFUNCPRMEXTNEFunction Action Permission Extension for Extended Objects12SEARCHTYPESearch Typenvarchar30
7GRACORGRULEOrganization Rules7SEARCHTYPESearch Typenvarchar30
8GRACORGRULEARCOrganization Rules-Archive7SEARCHTYPESearch Typenvarchar30
9TJYEDDIS-M: Electronic Document Delivery13SEARCHTYPEIS-M: Elec.Doc.Delivery Search Strategy for E-Mail Addressesnvarchar10
TOPBusiness Package for Manager Self-Service FI
10FPB_SNI_SEARCHFSearch Criteria in Hierarchy3SEARCHTYPESearch Criterion in Hierarchynvarchar80
11FPB_SNI_SEARCHOObject-specific Search Criteria in Hierarchy3SEARCHTYPESearch Criterion in Hierarchynvarchar80
TOPCustomer Interaction Center
12CCMCSEARCHSearch type to matchcode mapping for CCM contact search3SEARCHTYPESearch typenvarchar200
13CCMCSEARCHMAPMatchcode mapping for CCM contact search3SEARCHTYPESearch typenvarchar200
TOPF4 Help
14DD93SAttributes of an External Index7SEARCHTYPESearch type for search enginesnvarchar10
TOPGRC Access Control Plug-In
15/VIRSA/FUNCTOBJFunction - Objects8SEARCHTYPESearch type AND/OR/NOTnvarchar30
16/VIRSA/ORGRULESOrganizational values7SEARCHTYPESearch type AND/OR/NOTnvarchar30
17/VIRSA/ZCRAUTHAuthorization Objects7SEARCHTYPESearch type AND/OR/NOTnvarchar30
18/VIRSA/ZCRAUTHC1Restricted Critical Authorizations7SEARCHTYPESearch type AND/OR/NOTnvarchar30
19/VIRSA/ZCRAUTHL1SOD Authorization Object7SEARCHTYPESearch type AND/OR/NOTnvarchar30
20/VIRSA/ZCRAUTHL2SOD Authorization Object7SEARCHTYPESearch type AND/OR/NOTnvarchar30
21/VIRSA/ZCRAUTHL3SOD Authorization Object7SEARCHTYPESearch type AND/OR/NOTnvarchar30
22/VIRSA/ZCRAUTHL4SOD Authorization Object7SEARCHTYPESearch type AND/OR/NOTnvarchar30
23/VIRSA/ZCRAUTHL5SOD Authorization Object7SEARCHTYPESearch type AND/OR/NOTnvarchar30
TOPUser and Authorization Management
24USCRAUTHAuthorization Data for Critical Authorizations8SEARCHTYPESearch type AND/ORnvarchar30
25USCRCOMIDPart List for Critical Combinations of Authorizations4SEARCHTYPESearch type AND/ORnvarchar30
26USKRIAEntry of Critical Auths for Report RSUSR0096SEARCHTYPESearch type AND/ORnvarchar30
27USKRIATText table for USKRIA7SEARCHTYPESearch type AND/ORnvarchar30