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

66 columns | Print definition?ERP 6.0  | ENTITY_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/I_MED_AENannotated entities characteristic3ENTITY_IDSmall UUIDnvarchar340
2/IWFND/I_MED_ALEAnnotated Language-Dependent Entities Characteristics4ENTITY_IDSmall UUIDnvarchar340
3/IWFND/I_MED_ALKannotated entity language keys3ENTITY_IDSmall UUIDnvarchar340
4/IWFND/I_MED_CDKLanguage-Independent Table for Codelist3ENTITY_IDSmall UUIDnvarchar340
5/IWFND/I_MED_CDLLanguage-Dependent Table for Codelist4ENTITY_IDSmall UUIDnvarchar340
6/IWFND/I_MED_EPCtable to manage internal relationships such as parent-child3ENTITY_IDSmall UUIDnvarchar340
7/IWFND/I_MED_NODnode entity table for meta model3ENTITY_IDSmall UUIDnvarchar340
8/IWFND/I_MED_OPoperation entity for meta model3ENTITY_IDSmall UUIDnvarchar340
9/IWFND/I_MED_PRPproperty entity for meta model3ENTITY_IDSmall UUIDnvarchar340
10/IWFND/I_MED_REFreference entity for meta model3ENTITY_IDSmall UUIDnvarchar340
11/IWFND/I_MED_TXKLanguage-Independent Table for entity texts3ENTITY_IDSmall UUIDnvarchar340
12/IWFND/I_MED_TXRTable for Text references3ENTITY_IDSmall UUIDnvarchar340
13/IWFND/I_MED_TXTLanguage-Dependent Table for Property Texts4ENTITY_IDSmall UUIDnvarchar340
14/IWFND/I_MED_VEHversionable entity headtable for meta model3ENTITY_IDSmall UUIDnvarchar340
15/IWFND/I_RMI_MTFModel Entity Transformation Assignment3ENTITY_IDSmall UUIDnvarchar340
16ACMACCONDITIONACM: Access-Conditions (globally+reusable)2ENTITY_IDACM: ID of an Entitynvarchar300
17ACMTSTACCONDITIOACMTST: ACCondition (Expected test-results)2ENTITY_IDACM: ID of an Entitynvarchar300
18CLB2D_BO_ENTITYCollaboration: Business Object - Entity Assignment5ENTITY_IDCollaboration: Entity IDnvarchar220
19GRFNAPPFLDField Status Configuration by Application Component2ENTITY_IDEntity IDnvarchar200
20GRFNAPPFLDCField Status Configuration by Application Component2ENTITY_IDEntity IDnvarchar200
21GRFNCHGHISTCUSTChange History Customizing2ENTITY_IDEntity IDnvarchar200
22GRFNENTACTIONEntity Actions2ENTITY_IDEntity IDnvarchar200
23GRFNENTCONFIGEntity Configuration3ENTITY_IDEntity IDnvarchar200
24GRFNENTCONFIGCEntity Configuration3ENTITY_IDEntity IDnvarchar200
25GRFNENTFLDEntity and Field Assignment2ENTITY_IDEntity IDnvarchar200
26GRFNENTTABEntity and Tab Assignment2ENTITY_IDEntity IDnvarchar200
27GRFNENTTABCEntity and Tab Assignment2ENTITY_IDEntity IDnvarchar200
28GRFNENTUIEntity UI Configuration2ENTITY_IDEntity IDnvarchar200
29GRFNENTUIBBAPPEntity UIBB Configuration by Application Component2ENTITY_IDEntity IDnvarchar200
30GRFNJOBPCTXJob Step Context5ENTITY_IDEntity IDnvarchar200
31GRFNJOBPRSTCTXJob Step Result - Context5ENTITY_IDEntity IDnvarchar200
32GRFNNAVENTITYNavigation Targets for Entities1ENTITY_IDEntity IDnvarchar200
33GRFNPROCESSProcess1ENTITY_IDEntity IDnvarchar200
34GRFNREGFLDField Status Configuration by Regulation2ENTITY_IDEntity IDnvarchar200
35GRFNREGFLDCField Status Configuration by Regulation2ENTITY_IDEntity IDnvarchar200
36GRFNREGMAPPINGMapping between transaction object and regulation3ENTITY_IDEntity IDnvarchar200
37GRFNREPENTITYSTRReport: Structures for entities1ENTITY_IDEntity IDnvarchar200
38GRFNREPFIELDMAPReport: Special fields for reporting5ENTITY_IDEntity IDnvarchar200
39GRFNREPIMPLHIEREntities with implicit hierarchy1ENTITY_IDEntity IDnvarchar200
40GRRMDIMENTITYAssignment Dimensions to Enities2ENTITY_IDEntity IDnvarchar200
41GRRMOBLEASGNVALLoss Event Assignment to HR Objects - Validity3ENTITY_IDEntity IDnvarchar200
42SADL_GTK_LOGLogging table for SADL Generation Toolkit11ENTITY_IDBusiness Entitynvarchar2550
TOPAuthentication and SSO
43SAML2_POL_AUTHSAML2 Authentication Contexts of Logon Policies3ENTITY_IDSAML2 Entity ID Keyvarbinary160
TOPCollaborative Cross Applications
44/POA/D_CLM_DPLM1Deployment used mappings8ENTITY_IDLocal ID of Content Recordntext10737418230
45/POA/D_CLM_ENT01Content Record4ENTITY_IDLocal ID of Content Recordntext10737418230
46/POA/D_CLM_ENT10Extract Raw Data for Content Record5ENTITY_IDLocal ID of Content Recordntext10737418230
47/POA/D_CLM_IDM01Content Record Identity8ENTITY_IDLocal ID of Content Recordntext10737418230
TOPCollateral Management System
48TCMS_LOC_SASearch Application Details3ENTITY_IDLocator Search Entitynvarchar100
TOPGovernance, Risk and Compliance
49GRFNENTITYBusiness entity1ENTITY_IDEntity IDnvarchar200
50GRFNENTITYTtext table for GRFNENTITY1ENTITY_IDEntity IDnvarchar200
51GRFNFIELDMAPNOT USED! Mapping of fields to entity2ENTITY_IDEntity IDnvarchar200
52GRFNMDCConfiguration of master data objects type changes2ENTITY_IDEntity IDnvarchar200
53GRFNMDC_ENTITYBusiness Entity for Master Data Change Tracking1ENTITY_IDEntity IDnvarchar200
54GRFNMENUAUTHMenu Authorization Entity Mapping2ENTITY_IDEntity IDnvarchar200
55GRFNMENUAUTHCMenu Authorization Entity Mapping - Cust enhance3ENTITY_IDEntity IDnvarchar200
56GRFNOBJTYPEOBJTYPE to OTYPE mapping table4ENTITY_IDEntity IDnvarchar200
57GRFNREPHIERReport: Hierarchy4ENTITY_IDEntity IDnvarchar200
58GRFNREPSTRATEGYReport: Walking Strategy4ENTITY_IDEntity IDnvarchar200
59GRPC_MCF_CUSFLDCustom Field UI configuration3ENTITY_IDEntity IDnvarchar200
60GRPC_MCF_ENTITYMCF Entity definition3ENTITY_IDEntity IDnvarchar200
TOPGRC Risk Management
61GRRMVALIDATIONAnalysis Table3ENTITY_IDEntity IDnvarchar200
TOPProcess Controls
62GRPCCASEREGSTAKEregister stakeholders to notify risk2ENTITY_IDEntity IDnvarchar200
63GRPCOIFCONFOIF configuration table1ENTITY_IDEntity IDnvarchar200
TOPSoftware Agent Framework
64CRMD_EI_LE_ESETEI - LE - Entity Sets - Training Data for Learning4ENTITY_IDLearning Engine: Entity IDvarbinary160
TOPStreamWork ABAP Library
65STWD_BO_ENTITYCollaboration: Business Object - Entity Assignment5ENTITY_IDCollaboration: Entity IDnvarchar220
TOPWeb Service and SOAP - ABAP
66SRT_WSDL_ENTITYWSDL Upload: Entities table4ENTITY_IDWSDL Upload : Entity Identifier (GUID)nvarchar320