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

84 columns | Print definition?ERP 6.0  | AUTH_GROUP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_ACTIVTYPActivity Template4AUTH_GROUPAuthorization Groupnvarchar40
2/IAM/C_AUTHGRAuthorization Group3AUTH_GROUPAuthorization Groupnvarchar40
3/IAM/C_AUTHGR_TAuthorization Group4AUTH_GROUPAuthorization Groupnvarchar40
4/IAM/C_CODEGRCode Group4AUTH_GROUPAuthorization Groupnvarchar40
5/IAM/D_ACT_ROOTRoot12AUTH_GROUPAuthorization Groupnvarchar40
6/IAM/D_I_ROOTRoot node DB table11AUTH_GROUPAuthorization Groupnvarchar40
7DMC_MT_HEADERDMC: Header Record of a Mass Data Transfer7AUTH_GROUPAuthorization Groupnvarchar200
8DYNABAPHDRHeader Table for Dynamic ABAP Coding14AUTH_GROUPAuthorization Groupnvarchar80
9GRACOBJECTAUTHcontains object(user/role/profile) auth for legacy system9AUTH_GROUPAuthorization Namenvarchar1000
TOPAP-LIM Logistics Inventory Management Engine
10/LIME/HU_I003LIME - HU Key SSCC6AUTH_GROUPAuthorization Groupnvarchar40
11/LIME/HU_S003Shadow Table for LIME - SSCC6AUTH_GROUPAuthorization Groupnvarchar40
12/LIME/LOC_I001LIME - Location Key Plant, Storage Location (R/3)7AUTH_GROUPAuthorization Groupnvarchar40
13/LIME/LOC_I002LIME - Location Key Plant (R/3)6AUTH_GROUPAuthorization Groupnvarchar40
14/LIME/LOC_I003LIME - Location Key GLN6AUTH_GROUPAuthorization Groupnvarchar40
15/LIME/LOC_I004LIME - Location Key DUNS+46AUTH_GROUPAuthorization Groupnvarchar40
16/LIME/LOC_I005LIME - Location Key APO Location (F&R)6AUTH_GROUPAuthorization Groupnvarchar40
17/LIME/LOC_I006LIME - Location Key Location GUID (ICH)6AUTH_GROUPAuthorization Groupnvarchar40
18/LIME/LOC_I007LIME - Location Key Partner (incl. R/3)7AUTH_GROUPAuthorization Groupnvarchar40
19/LIME/LOC_I008LIME - Location Key Means of Transport, Code (incl. R/3)7AUTH_GROUPAuthorization Groupnvarchar40
20/LIME/LOC_S001Shadow Table for LIME - Plant, Storage Location (R/3)7AUTH_GROUPAuthorization Groupnvarchar40
21/LIME/LOC_S002Shadow Table for LIME - Plant (R/3)6AUTH_GROUPAuthorization Groupnvarchar40
22/LIME/LOC_S003Shadow Table for LIME - GLN6AUTH_GROUPAuthorization Groupnvarchar40
23/LIME/LOC_S004Shadow Table for LIME - DUNS+46AUTH_GROUPAuthorization Groupnvarchar40
24/LIME/LOC_S005Shadow Table for LIME - APO Location (F&R)6AUTH_GROUPAuthorization Groupnvarchar40
25/LIME/LOC_S006Shadow Table for LIME - Location GUID (ICH)6AUTH_GROUPAuthorization Groupnvarchar40
26/LIME/LOC_S007Shadow Table for LIME - Partner (incl. R/3)7AUTH_GROUPAuthorization Groupnvarchar40
27/LIME/LOC_S008Shadow Table for LIME - Means of Transport, Code (incl. R/3)7AUTH_GROUPAuthorization Groupnvarchar40
28/LIME/PN_ITEMTable to Save Prima Nota Item Data82AUTH_GROUPAuthorization Groupnvarchar40
29/LIME/STOCK_I001LIME - Stock Key Material (R/3)8AUTH_GROUPAuthorization Groupnvarchar40
30/LIME/STOCK_I002LIME - Stock Key Material, Batch (R/3)9AUTH_GROUPAuthorization Groupnvarchar40
31/LIME/STOCK_I003LIME - Stock Key GTIN, Variant9AUTH_GROUPAuthorization Groupnvarchar40
32/LIME/STOCK_I005LIME - Stock Key APO Material (F&R)8AUTH_GROUPAuthorization Groupnvarchar40
33/LIME/STOCK_I006LIME - Stock Key Product GUID, Version (ICH)9AUTH_GROUPAuthorization Groupnvarchar40
34/LIME/STOCK_I011LIME - Stock Key Sales Order Stock (R/3)10AUTH_GROUPAuthorization Groupnvarchar40
35/LIME/STOCK_I012LIME - Stock Key Sales Order Stock, Batch (R/3)11AUTH_GROUPAuthorization Groupnvarchar40
36/LIME/STOCK_I021LIME - Stock Key Project Stock (R/3)9AUTH_GROUPAuthorization Groupnvarchar40
37/LIME/STOCK_I022LIME - Stock Key Project Stock, Batch (R/3)10AUTH_GROUPAuthorization Groupnvarchar40
38/LIME/STOCK_S001Shadow Table for LIME - Material (R/3)8AUTH_GROUPAuthorization Groupnvarchar40
39/LIME/STOCK_S002Shadow Table for LIME - Material, Batch (R/3)9AUTH_GROUPAuthorization Groupnvarchar40
40/LIME/STOCK_S003Shadow Table for LIME - GTIN, Variant9AUTH_GROUPAuthorization Groupnvarchar40
41/LIME/STOCK_S005Shadow Table for LIME - APO Material (F&R)8AUTH_GROUPAuthorization Groupnvarchar40
42/LIME/STOCK_S006Shadow Table for LIME - Product GUID, Version (ICH)9AUTH_GROUPAuthorization Groupnvarchar40
43/LIME/STOCK_S011Shadow Table for LIME - Sales Order Stock (R/3)10AUTH_GROUPAuthorization Groupnvarchar40
44/LIME/STOCK_S012Shadow Table for LIME - Sales Order Stock, Batch (R/3)11AUTH_GROUPAuthorization Groupnvarchar40
45/LIME/STOCK_S021Shadow Table for LIME - Project Stock (R/3)9AUTH_GROUPAuthorization Groupnvarchar40
46/LIME/STOCK_S022Shadow Table for LIME - Project Stock, Batch (R/3)10AUTH_GROUPAuthorization Groupnvarchar40
TOPAudit Management
47PLMC_AUTHAudit - Authorization Group2AUTH_GROUPAuthorization Groupnvarchar60
48PLMC_AUTHTAudit-Authorization Group, Text3AUTH_GROUPAuthorization Groupnvarchar60
49PLMM_AUDITAudit5AUTH_GROUPAuthorization Groupnvarchar60
50PLMM_AUDITPLANAudit Plan4AUTH_GROUPAuthorization Groupnvarchar60
51PLMM_AUDIT_ACTAudit - Corrective Action3AUTH_GROUPAuthorization Groupnvarchar60
52PLMM_QUEST_HQuestion List10AUTH_GROUPAuthorization Groupnvarchar60
53PLMM_QUEST_RESAudit Question/Reply List/Item6AUTH_GROUPAuthorization Groupnvarchar60
TOPCentral Part of Product Master
54COMC_PR_AUTHGRAuthorization Groups for Product Master Maintenance2AUTH_GROUPAuthorization Groupnvarchar40
55COMC_PR_AUTHGR_TAuthorization Group Descriptions3AUTH_GROUPAuthorization Groupnvarchar40
56COMM_PRCATProduct Category4AUTH_GROUPAuthorization Groupnvarchar40
57COMM_PRCATHProduct Category: History5AUTH_GROUPAuthorization Groupnvarchar40
TOPCountry-Specific Objects
58DMEE_TYPE_ABADMEE: Supported Tree Types14AUTH_GROUPAuthorization Groupnvarchar40
TOPCross-Application Components
59/IXOS/DC_TCHIERHierarchy of a view18AUTH_GROUPAuthority group in node typesnvarchar100
TOPExpenditure Certification
60FMEUFOPHDefine Operation Header23AUTH_GROUPFM: General Authorization Groupnvarchar100
TOPFSCM In-House Cash
61IHC_TAB_AUTH_GRPIHC:Authorization Groups for Amount-Dependent Authorizations2AUTH_GROUPAuthorization Group for Amount-Dependent Authorizationsnvarchar120
TOPFunds Management
62FMIUROpen Interval Rules for updating FM8AUTH_GROUPAuthorization Groupnvarchar40
TOPGlobal Trade Services
63/SAPSLL/L_IG01GTS - Location Table for Customs Warehouse IDs6AUTH_GROUPAuthorization Groupnvarchar40
64/SAPSLL/L_SG01GTS: Shadow Location Table for Customs Warehouse IDs6AUTH_GROUPAuthorization Groupnvarchar40
65/SAPSLL/S_IG01GTS - Make-to-Order Stock (Duty Unpaid)14AUTH_GROUPAuthorization Groupnvarchar40
66/SAPSLL/S_IG02GTS - Stock12AUTH_GROUPAuthorization Groupnvarchar40
67/SAPSLL/S_SG01GTS - Make-to-Order Stock (Duty Unpaid)14AUTH_GROUPAuthorization Groupnvarchar40
68/SAPSLL/S_SG02GTS - Shadow Stock12AUTH_GROUPAuthorization Groupnvarchar40
TOPLocalization
69DMEE_TREE_TYPEDMEE: Supported Tree Types14AUTH_GROUPAuthorization Groupnvarchar40
TOPLocations Location Structure
70EHFNDD_LOC_REVLocation - Revisions21AUTH_GROUPLocation Authorization Groupnvarchar210
TOPMarket Risk Analyzer
71JBRREGDRule Definition5AUTH_GROUPAuthorization Groupnvarchar40
72JBRRHCheck Table for Risk Hierarchy6AUTH_GROUPAuthorization Groupnvarchar40
73JBRRHHCheck Table for the Risk Hierarchy (History)7AUTH_GROUPAuthorization Groupnvarchar40
74JBRRH_BACKBackup Table JBRRH (Required for Transport Imports)6AUTH_GROUPAuthorization Groupnvarchar40
TOPMaster Data
75GMSPCLASSSponsored Class Master9AUTH_GROUPGrants Management: Authorization Groupsnvarchar100
76GMSPPROGRAMSponsored program master12AUTH_GROUPGrants Management: Authorization Groupsnvarchar100
77GMSTATNETGrants Management Status Network14AUTH_GROUPAuthority Groupnvarchar100
78GMSTATNET_INTGrants Management Status Network12AUTH_GROUPAuthority Groupnvarchar100
TOPOwnership
79GHO_OWN_TRO_HDRTransfer of Ownership Header Table12AUTH_GROUPTechnical object authorization groupnvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
80TFACT_SETFacts Set3AUTH_GROUPFact Set Authorization Groupnvarchar40
81TFACT_SET_PARTFact Set Parts8AUTH_GROUPFact Type Authorization Groupnvarchar40
82TFACT_TYPE_PARTFact Type Parts9AUTH_GROUPFact Type Authorization Groupnvarchar40
TOPRapid Applications
83AXT_RUN_RAP_APPRapid application5AUTH_GROUPAuthorization Groupnvarchar40
TOPTransaction Manager
84IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts28AUTH_GROUPAuthorization Groupnvarchar40