SAP Knowledge Warehouse Tables

Are you looking for the right table related to SAP Knowledge Warehouse Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Knowledge Warehouse (KM-KW) module.

Top 10 tables in Knowledge Warehouse

TableDescription
ACL_ACTVTACL: Activities
ACL_ACTGRTACL: Role Descriptions
CUSTCONT1KEN: Document Contents Table (Import/Export)
TXDPLOIOSAP KW: Instances of Logical Info Objects
PROD_D_SUBKWSTAT: Definition of PROD_DOCU Sub-Structures
KWN_NODERGeneral Structure Storage References
TXDPPHRIPREPF: Attributes of Incoming Relationships for PHIOs
TXMLPHREPREPF: Attributes of Outgoing Relationships for PHIOs
TXMLPHNMPREPF: Attributes of Target Anchor Relationships
TXMLPHNMKW: Use of Target Anchors in Physical Objects

List of tables in Knowledge Warehouse

TableDescription
ACL_ACTVTACL: Activities
ACL_ACTGRTACL: Role Descriptions
CUSTCONT1KEN: Document Contents Table (Import/Export)
TXDPLOIOSAP KW: Instances of Logical Info Objects
PROD_D_SUBKWSTAT: Definition of PROD_DOCU Sub-Structures
KWN_NODERGeneral Structure Storage References
TXDPPHRIPREPF: Attributes of Incoming Relationships for PHIOs
TXMLPHREPREPF: Attributes of Outgoing Relationships for PHIOs
TXMLPHNMPREPF: Attributes of Target Anchor Relationships
TXMLPHNMKW: Use of Target Anchors in Physical Objects
TXDPPHRISAP KW: Incoming Links of Physical Info Objects
TXDPLORESAP KW: Outgoing Links of Logical Info Objects
TXML_NODEXML: table of nodes
TXMLLOIOKEN: Instances of Logical Information Objects
TXMLCHKFKW: File Name of Last Check-out
TXMLPHPRKW: Physical Information Object Attributes
TXMLPHRIKW: Incoming Links of Physical Information Objects
TXML_NODETXML: General Structure Storage Node Names
KWNPHREPREPF: Attributes of Outgoing Relationships for PHIOs
HLPTXTHelp: Topic titles
ACL_OBJTPACL: Object Types
SACL_MBAccess Control List Member
QMM_PHHRQMM: Outgoing Hyperlinks from Physical Info Objects
TXMLLOPRKEN: Attributes of Logical Information Objects
TXMLCHKOKW: Physical Information Object Check-out Data
QMM_IDXSTAQMM: Status Table for Indexing Info Objects
IWB0COMPKWSTAT: Table (Component/Scenario and GBU/IBU)
CUSTLOIOKEN: Instances of Logical Information Objects
IWB7PHFSAP KW: Physical Info Object Files
IWBARDELSDOK: Relation with both partners
IWB2REPRKEN: Relationship Attributes
IWB5PHHRPREPF: Attributes of Hyperlink Relationships
QMM_PHREQMM: Outgoing Relations of Physical Info Objects
SKW_AGRPSUser Groups
IWBUUIDVALValues with Generated Key (GUID)
IWB1PHPRKW: Physical Information Object Attributes
TXDPCHKFSAP KW: File Name of Last Check-Out
KWN_NODENode Table for General Structure Storage
QMM_PHRIPREPF: Attributes of Incoming Relationships for PHIOs
CUSTLOREKEN: Outgoing Links of Logical Information Objects
IWB7PHRISAP KW: Incoming Links of Physical Info Objects
QMM_LOIOTQMM: Descriptions of Logical Info Objects
IWB1PHFKW: Physical Information Object Files
IWB2PHRIKW: Incoming Links of Physical Information Objects
IWB5PHPRKW: Physical Information Object Attributes
IWB0LORIKW: Incoming Links of Physical Information Objects
IWB7CHKOSAP KW: Check-Out Data of Physical Info Object
KWN_NODETGeneral Structure Storage Node Names
IWB5PHRIKW: Incoming Links of Physical Information Objects
TXDPIDXSTASDOK: Status Table for Document Indexing: IWB1
KWDELTA_WLIWB: Worklist for Delta Delivery (Content)
IWB2NODERGeneral Structure Storage References
IWB7PHRESAP KW: Outgoing Links of Physical Info Objects
PRD_ASSIGNKWSTAT: Assignment of Product Context
IWEXTSYMBSKEn: Html Export Text Symbols
CUSTNODERGeneral Structure Storage References
IWSTDGRAFTKEn: Standard Graphic - Text
IWB_EHP_F4Value Table for EHP / SP / APPL (for IWB_EHP_CONTEXTH)
IWB0PHFKW: Physical Information Object Files
IWB1CONT1KEN: Document Contents Table (Import/Export)
QMM_PHHRPREPF: Attributes of Hyperlink Relationships
KWNLORIKW: Incoming Links of Physical Information Objects
IWB2REKEN: Instances of Relationships
IWB1PHHRKW: Outgoing Hyperlinks from Physical Objects
CUSTPHREKW: Outgoing Links of Physical Information Objects
IWREFERENCIWB: Info Object Where-Used References
IWB7PHNMPREPF: Attributes of Target Anchor Relationships
IWB5PHFKW: Physical Information Object Files
IWB_WF_IOInfo Objects in the Workflow Package
IWBREORG_SReorg report settings
IWCODEPAGEKEN Codepage info (which CP is used for a language)
QMM_PHNMPREPF: Attributes of Target Anchor Relationships
IWB7NODERGeneral Structure Storage References
IWB_BF_EHP_IOAAssignments Between BF/EHP/Structures in Application System
IWB5LOIOTKEN: Description of Logical Information Objects
IWB_NEWRELREORG: Save newly created Relation
CUSTLOIOTKEN: Description of Logical Information Objects
IWH_31_LNK3.1: Help Links (only for customer solution for 3.1)
IWTESTFCTTKEn: Supported test functions - Short description
IWB7IDXSTASDOK: Status Table for Document Indexing: IWB1
HLPREFEXTHelp: Assign structure to Winhelp project names
IWB2CHKFKW: File Name of Last Check-out
ACL_OBJTPGACL: Roles for Object Types
CUSTNODETGeneral Structure Storage Node Names
IWEXPHIOHTML Export Services Phio List of HTML Generation
IWB0PHNMPREPF: Attributes of Target Anchor Relationships
CUSTNODENode Table for General Structure Storage
ACL_MAINACL: ACL Information
CUSTLOPRKEN: Attributes of Logical Information Objects
SACL_ACTActivate Access Control Lists
IWB1PHNMKW: Use of Target Anchors in Physical Objects
IWB2CONT1KEN: Document Contents Table (Import/Export)
KWDELTA_TRIWB: Transport Requests for Delta Delivery
ACL_ACTVTTACL: Activity Descriptions
KWNLOPRKEN: Attributes of Logical Information Objects
IWIKS2STATIWB: IO Info Read per User
IWAUTHFCTFunction for Authorization Check
IWB2PHFKW: Physical Information Object Files
IWB7PHRIPREPF: Attributes of Incoming Relationships for PHIOs
IWINDUSTRYKEN: Industry sectors and their root sectors
TXDPCHKOSAP KW: Check-Out Data of Physical Info Object
IWB_BF_EHP_IOVAssignments Between BF/EHP and KW Structures (History)
IWB1REPRKEN: Relationship Attributes
IWB_BF_EHP_IOHAssignments Between BF/EHP and KW Structures
KWNPHREKW: Outgoing Links of Physical Information Objects
PROD_DETLDKWSTAT: Detailed Output Table
IWNODEICONIWB: Structure display icon management
IWCOMP_RESKW System Results for Comparision of Content
IWBSETTINGKEN: Settings (valid versions, etc.)
IWB7PHHRSAP KW: Outgoing Links of Physical Info Objects
IWB1PHRIKW: Incoming Links of Physical Information Objects
IWFLDRGRPTFolder groups
IWB0PHREPREPF: Attributes of Outgoing Relationships for PHIOs
SKW_ACLSAll Access Control Lists
IWEXRULESKEn: Html Export Dispatching Rules
TXDPLORISAP KW: Incoming Links of Physical Info Objects
IWB7LOIOTSAP KW: Description of Logical Info Objects
IWB0NODETGeneral Structure Storage Node Names
IWB_MACRO_PARAParameter Table for Macro Control
IWB2NODENode Table for General Structure Storage
IWCLTYPEIWB: Assignment of I/O classes to I/O types
TXDPPHRESAP KW: Outgoing Links of Physical Info Objects
IWEXTSYMBTKEn: Html Export Text Symbols
ACL_OBJTPTACL: Object Type Descriptions
IWSYSTEMKEN: Where-used list maintenance systems
IWB7LOIOSAP KW: Instances of Logical Info Objects
CUSTPHRIKW: Incoming Links of Physical Information Objects
HLPREFHelp: Assign topic to structures
QMM_PHNMQMM: Use of Target Anchors in Physical Info Objects
IWB1LOIOKEN: Instances of Logical Information Objects
IWB_EHP_CONTEXTHAssignments Between EHP / SP / APPL and KW Contexts
QMM_CHKOQMM: Check-out Data for a Physical Info Object
QMM_PHPRQMM: Attributes of Physical Info Objects
SKWACLRTAccess Control Lists: Runtime Table
QMM_NODERQMM: General Structure Storage References
IWREADPHIOIWB: PHIOs Read per User
IWB0REPRKEN: Relationship Attributes
TXMLPHHRKW: Outgoing Hyperlinks from Physical Objects
IWEXRTABTKEn: Html Export Number Areas for File Names (Text)
IWBENTRY_UKEn: Info Object Browser Defaults
IWB0NODERGeneral Structure Storage References
KWNPHFKW: Physical Information Object Files
IWB0LOREKEN: Outgoing Links of Logical Information Objects
IWB1LORIKW: Incoming Links of Physical Information Objects
IWSUBSCRKW: Info objects Subscription
IWB7PHHRPREPF: Attributes of Hyperlink Relationships
IWB5PHREKW: Outgoing Links of Physical Information Objects
IWR3LFOLDFolders with Context and Destination for Help Links Check
IWB_EHP_CONTEXTVAssignments: EHP / SP / APPL and KW Contexts (History)
KWNPHRIKW: Incoming Links of Physical Information Objects
IWEXDESTKEn: Html Export Destinations
IWB0CONT1KEN: Document Contents Table (Import/Export)
IWEXRTABKEn: Html Export Number Areas for File Names
QMM_LOREQMM: Outgoing Relationships of Logical Info Objects
ACL_OWNERACL: Owner of ACL (with Change Authorization)
IWB0PHHRPREPF: Attributes of Hyperlink Relationships
IWB1LOPRKEN: Attributes of Logical Information Objects
CUSTPHPRKW: Physical Information Object Attributes
KWD_RETROFIT2Retrofit for IWBTRAIN & XML_TRAIN: Initial Folders & Results
KWD_RFC2BIRFC Destinations for Different Contexts
TXMLPHIOKW: Instances of Physical Information Objects
IWB2NODETGeneral Structure Storage Node Names
TXDPPHHRPREPF: Attributes of Hyperlink Relationships
KWDEL_HEADContent Deletion Report: History
IWB1RDELSDOK: Relation with both partners
IWREADLOIOIWB: LOIOs Read per User
IWB0CHKOKW: Physical Information Object Check-out Data
KWNPHRIPREPF: Attributes of Incoming Relationships for PHIOs
QMM_PHRIQMM: Incoming Relationships of Physical Info Objects
KWD_CL_VSPVirus Scan Profile for PHIO Class
QMM_LORIQMM: Incoming Relationships of Logical Info Objects
IWBENTRY_VKEn: Info Object Browser Defaults
KWNIDXSTASDOK: Status Table for Indexing Documents: IWB2
IWB2PDELKW: Instances of Deleted Physical Information Objects
IWDISPLAYInfo Workbench: Categories
TXMLLORIKW: Incoming Links of Physical Information Objects
IWEXTENDEnhancement Information: Add-On and Customer
ACL_ACTGREACL: Activities in Roles
IWB0CHKFKW: File Name of Last Check-out
IWB5PHNMKW: Use of Target Anchors in Physical Objects
IWB1CHKFKW: File Name of Last Check-out
IWDISPLAYTInfo Workbench: Category texts
TXMLPHHRPREPF: Attributes of Hyperlink Relationships
KWNCHKOKW: Physical Information Object Check-out Data
CUSTLORIKW: Incoming Links of Physical Information Objects
QMM_PHIOQMM: Instances of Physical Info Objects
IWNODETDEFIWB: Default node classification (environment-specific)
TXDPPHHRSAP KW: Outgoing Links of Physical Info Objects
IWB5PHRIPREPF: Attributes of Incoming Relationships for PHIOs
CUSTPHFKW: Physical Information Object Files
IWB0PHPRKW: Physical Information Object Attributes
IWB0REKEN: Instances of Relationships
IWB2PHNMKW: Use of Target Anchors in Physical Objects
TXMLPHRIPREPF: Attributes of Incoming Relationships for PHIOs
IWB0PHREKW: Outgoing Links of Physical Information Objects
KWNLOREKEN: Outgoing Links of Logical Information Objects
IWEXSERVERKEn: Html Export Systems
IWB7CHKFSAP KW: File Name of Last Check-Out
CUSTIDXSTASDOK: Status Table for Indexing Documents: IWB1
IWADMData for KEN Administration
IWBWFHEADWorkflow Package
IWBWFATTRAttributes of the Info Objects in the Workflow Package
IWB7PHPRSAP KW: Attributes of Physical Info Objects
IWAREADESTKEN: AREA-Specific Destinations (for KEN Interfaces)
IWPROPVALTValid Attribute Values (Classes or Area-Specific)
KWNPHNMKW: Use of Target Anchors in Physical Objects
IWEXSTATUSKEn: Html Export Status
ACL_CACHEACL: Cache Table for ACL Access
KWDEL_RES_OBJContent Deletion Report: Details for Info Objects
ACL_ACTGRACL: Roles
KWFOLDERSFolders that are processed by 'Reorg' Report
CUSTPHIOKW: Instances of Physical Information Objects
IWB2PHIOKW: Instances of Physical Information Objects
IWB_BF_F4Value Table for Business Functions (for IWB_BF_EHP_IOH)
IWIKSVARTKW: Template Variables for IKS Replacement (Description)
IWB5LORIKW: Incoming Links of Physical Information Objects
QMM_LOPRQMM: Attributes of Logical Info Objects
KWNLOIOKEN: Instances of Logical Information Objects
CUSTPHNMKW: Use of Target Anchors in Physical Objects
TXDPLOIOTSAP KW: Description of Logical Info Objects
IWB0PHNMKW: Use of Target Anchors in Physical Objects
IWB0PHIOKW: Instances of Physical Information Objects
IWB0PHRIPREPF: Attributes of Incoming Relationships for PHIOs
IWB0PHHRKW: Outgoing Hyperlinks from Physical Objects
TXDPPHPRSAP KW: Attributes of Physical Info Objects
IWEXTODOKEn: Html Export Request List
IWB7NODENode Table for General Structure Storage
IWICONIWB: Icon store
IWB2RDELSDOK: Relation with both partners
IWSTDGRAFKEn: Standard Graphics
IWB0PHRIKW: Incoming Links of Physical Information Objects
IWB5PHNMPREPF: Attributes of Target Anchor Relationships
IWEXDONEKEn: Html Export History
IWB2LOIOKEN: Instances of Logical Information Objects
ACL_OBJTPAACL: Activities for Object Types
IWB_EHP_SWCAssignment of Enhancement Package to Software Component
IWB1PDELKW: Instances of Deleted Physical Information Objects
IWB7PHNMSAP KW: Use of Target Anchors in Physical Objects
IWAUTHFCTTFunction for Authorization Check
IWEXTENDTEnhancement Information - Text Table
TXDPPHNMSAP KW: Use of Target Anchors in Physical Objects
IWBREORGKEn: Status of Reorganization
IWBKEPDESTKEPlicator Data for Logical Destinations
TXMLIDXSTASDOK: Status Table for Indexing Documents: IWB1
KWNPHNMPREPF: Attributes of Target Anchor Relationships
PRD_SUBSTRKWSTAT: Definition of Product Sub-Structures
TXMLLOIOTKEN: Description of Logical Information Objects
IWB5PHIOKW: Instances of Physical Information Objects
IWBKEYWRDTInfo Workbench: Keywords (language-dependent information)
IWB2LORIKW: Incoming Links of Physical Information Objects
TXDPPHFSAP KW: Physical Info Object Files
IWB7LORISAP KW: Incoming Links of Physical Info Objects
IWB7PHREPREPF: Attributes of Outgoing Relationships for PHIOs
CUSTCHKFKW: File Name of Last Check-out
IWR3LRESResults of Help Links Check
TXDPPHIOSAP KW: Instances of Physical Info Objects
QMM_LOIOQMM: Instances of Logical Information Objects
CUSTPHHRKW: Outgoing Hyperlinks from Physical Objects
IWEXEXOPTSKEn: Html Export Options
IWB1PHIOKW: Instances of Physical Information Objects
IWBKEPKEP Data for Scheduling Training
IWB0NODENode Table for General Structure Storage
IWEXINDXKEn: Html Export Analysis Data (INDX)
IWB7LORESAP KW: Outgoing Links of Logical Info Objects
ACL_ACEACL: Entry for Authorized Users
QMM_CHKFQMM: File Name of Last Check-out
IWB0LOPRKEN: Attributes of Logical Information Objects
IWPROPVALValid Attribute Values (Classes or Area-Specific)
IWB0LOIOTKEN: Description of Logical Information Objects
KWNPHPRKW: Physical Information Object Attributes
SKWACTGRPRoles
TXML_NODERXML: General Structure Storage References
QMM_CONT1QMM: Table for Document Contents (Import/Export)
KWD_RETROFIT1Retrofit for IWBHELP: Initial Folders and Results
IWB2PHHRKW: Outgoing Hyperlinks from Physical Objects
IWFLDRGRPFolder groups
CUSTCHKOKW: Physical Information Object Check-out Data
IWB1LOIOTKEN: Description of Logical Information Objects
IWB1CHKOKW: Physical Information Object Check-out Data
IWB0LOIOKEN: Instances of Logical Information Objects
KWD_RETROFITHRetrofit: Header Info
IWCOMP_OBJThe Comparative Objects with Context and Destination
QMM_NODETQMM: General Structure Storage Node Names
KWD_RETROFIT4<> IWBHELP/TRAIN, XML_DOCU/TRAIN: Initial Folders & Results
TXMLPHREKW: Outgoing Links of Physical Information Objects
IWB7LOPRSAP KW: Attributes of Logical Info Objects
IWEXADDHTML Export: Export Alias and Structure Object (ID + Class)
KWD_RETROFIT3Retrofit for XML_DOCU: Initial Folders and Results
IWDOCFRMTDocument Formats that are Supported in KW
QMM_PHREPREPF: Attributes of Outgoing Relationships for PHIOs
IWB1PHREKW: Outgoing Links of Physical Information Objects
TXDPPHNMPREPF: Attributes of Target Anchor Relationships
IWB5CHKFKW: File Name of Last Check-out
TXMLPHFKW: Physical Information Object Files
IWB1LOREKEN: Outgoing Links of Logical Information Objects
KWH_BGBackground Processes for Knowledge Warehouse
IWTESTFCTSSupported KEN test functions
IWB1REKEN: Instances of Relationships
IWRELFRZEKEN releases
IWB1NODENode Table for General Structure Storage
HLPREFMHelp: Assign topics to M links
IWB1NODETGeneral Structure Storage Node Names
IWB5PHHRKW: Outgoing Hyperlinks from Physical Objects
IWOBJECTIWB: Repository for Info Objects
IWB2PHREKW: Outgoing Links of Physical Information Objects
IWB5CHKOKW: Physical Information Object Check-out Data
TXDPPHREPREPF: Attributes of Outgoing Relationships for PHIOs
IWB7NODETGeneral Structure Storage Node Names
IWBKEP2KEP Data for Scheduling Training: Context
IWBENTRY_MIWB: Info Object Browser defaults
IWB5LOPRKEN: Attributes of Logical Information Objects
IWIKSVARKW: Template Variables for IKS Replacement
IWRELEASEKEN releases
IWSYSTEMTKEN: Where-used list (texts) maintenance systems
IWTESTUSERKEN: KEN user in test mode
IWBKMIGStatistics for keyword migration
IWB2LOREKEN: Outgoing Links of Logical Information Objects
IWSTRANSStructures Designated for Translation
IWBSTATEHIERUsed to hierarchize table IWPROPVAL
IWBKEYWRDInfo Workbench: Keywords (language-independent information)
IWB5LOREKEN: Outgoing Links of Logical Information Objects
IWB5PHREPREPF: Attributes of Outgoing Relationships for PHIOs
KWCHAINKEN: Industry sectors and their root sectors
TXDPLOPRSAP KW: Attributes of Logical Info Objects
IWB2LOIOTKEN: Description of Logical Information Objects
IWB7PHIOSAP KW: Instances of Physical Info Objects
KWNPHHRKW: Outgoing Hyperlinks from Physical Objects
KWNPHHRPREPF: Attributes of Hyperlink Relationships
KWNLOIOTKEN: Description of Logical Information Objects
IWTREFERENCIWB: Info Object Where-Used References
IWB2CHKOKW: Physical Information Object Check-out Data
IWB2PHPRKW: Physical Information Object Attributes
KWNPHIOKW: Instances of Physical Information Objects
KWNCHKFKW: File Name of Last Check-out
IWEXEXOPTTKEn: Html Export Options (Text)
IWB2LOPRKEN: Attributes of Logical Information Objects
IWBAPDELKW: Instances of Deleted Physical Information Objects
QMM_NODEQMM: Node Table for General Structure Storage
IWB5LOIOKEN: Instances of Logical Information Objects
IWB5IDXSTASDOK: Status Table for Indexing Documents: IWB1
SKW_ACLSTAccess Control Lists: Text Tables
IWBENTRY_SKEn: Info Object Browser Defaults
TXMLLOREKEN: Outgoing Links of Logical Information Objects
IWB1NODERGeneral Structure Storage References
QMM_PHFQMM: Files of Physical Info Objects