CRMS4D_KNAR_H

Transparent Table Application Table
88 Fields 4 CDS Views

Knowledge Article Header

CRMS4D_KNAR_H is an SAP database table in S/4HANA. Knowledge Article Header. It contains 88 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CRMS4_KNAR_SEARCH view from Knowledge Article Search
E_KnowledgeArticle view from EXTENSION Knowledge Article Extension
E_SrvcMgmtKnowledgeObject view_entity from EXTENSION Knowledge Article - Extension
I_SrvcMgmtKnowledgeObject view_entity from BASIC Service Management Knowledge Object

Fields (88)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
category CRMT_ACTIVITY_CATEGORY Category
priority CRMT_PRIORITY Priority
class CRMT_ACTIVITY_CLASS Activity class
valid_from CRMS4_KA_VALID_FROM_DATE KA: Valid from Date
valid_to CRMS4_KA_VALID_TO_DATE KA: Valid to Date
header_guid CRMT_OBJECT_GUID Object GUID
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
descr_language CRMT_PROCESS_DESCRIPTION_LANGU Language
template_type CRMT_TEMPLATE_TYPE_DB Templ. Type
created_at_h CRMS4_CREATED_AT Created On
created_by_h CRMT_CREATED_BY Created By
changed_at_h CRMS4_CHANGED_AT Changed On
changed_by_h CRMT_CHANGED_BY Changed By
head_changed_at CRMT_CHANGED_AT Changed On
btx_class CRMT_TRANSACTION_CLASSIFICATN Trans.Classification
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
object_id_ok CRMT_OBJECT_ID_OK ID Valid
verify_date CRMT_VERIFY_DATE Verify Date
header_guid_char CRMT_OBJECT_GUID32 Object GUID
sdm_status_dura CRMS4_SDM_STATUS_DURA Duration Flag
dis_channel CRMT_DISTRIBUTION_CHANNEL Distribution Channel
division CRMT_DIVISION Division
service_org_ori CRMT_SERVICE_ORG_ORIGIN Origin srvc. org.
service_orgr_ori CRMT_SERVICE_ORG_RESP_ORIGIN Origin Sales Org.
sales_org_ori CRMT_SALES_ORG_ORIGIN Origin sales org.
dis_channel_ori CRMT_DIS_CHANNEL_ORIGIN Origin: Distr. chnl
sales_off_ori CRMT_SALES_OFFICE_ORIGIN Origin: Sales office
sales_group_ori CRMT_SALES_GROUP_ORIGIN Origin: Sales group
sales_orgr_ori CRMT_SALES_ORG_RESP_ORIGIN Origin SOrg
division_ori CRMT_DIVISION_ORIGIN Origin: Division
sales_org CRMT_SALES_ORG Sales Org. ID
sales_office CRMT_SALES_OFFICE Sales Office
sales_group CRMT_SALES_GROUP Sales Group
sales_org_resp CRMT_SALES_ORG_RESP Org. Unit (Sales)
service_org CRMT_SERVICE_ORG Service Organization
service_org_resp CRMT_SERVICE_ORG_RESP OU (Service)
sales_org_sd VKORG Sales Org.
sales_office_sd VKBUR Sales Office
sales_group_sd VKGRP Sales Group
enterprise_service_org CRMS4_ENTERPRISE_SERVICE_ORG Ent. Service Org.
service_team_rm CRMS4_SERVICE_TEAM_RM Service Team
service_team_rm_ori CRMS4_SERVICE_TEAM_RM_ORIGIN Origin Service Team
planning_plant IWERK Planning Plant
work_center_object_id LGWID Work Center
person_resp CRMT_PERSON_RESP Employee Resp.
inbox_assigned_to CRMT_PERSON_RESP Employee Resp.
inbox_group_assigned CRMT_RESPONSIBLE_GROUP Responsible Group
inbox_account CRMT_SALESPARTNER Sales Partners
inbox_contact_person CRMT_CONTACT_PERSON Contact Pers.
stat_lifecycle CRMS4_STAT_LIFECYCLE Life Cycle Status
stat_released CRMS4_STAT_RELEASED Release Status
stat_cancelled CRMS4_STAT_CANCELLED Cancellation Status
stat_error CRMS4_STAT_ERROR Error Status
stat_archivable CRMS4_STAT_ARCHIVABLE Archivable
stat_archived CRMS4_STAT_ARCHIVED Archived
stat_open CRMS4_STAT_OPEN Open
inbox_status CRMT_AUI_STATUS Status
catlvlguid01_01 CRM_REP_CAT_GUID_LEV01_S1 Cat. 01-S1
catlvlguid02_01 CRM_REP_CAT_GUID_LEV02_S1 Cat. 02-S1
catlvlguid03_01 CRM_REP_CAT_GUID_LEV03_S1 Cat. 03-S1
catlvlguid04_01 CRM_REP_CAT_GUID_LEV04_S1 Cat. 04-S1
catlvlguid05_01 CRM_REP_CAT_GUID_LEV05_S1 Cat. 05-S1
catlvlguid06_01 CRM_REP_CAT_GUID_LEV06_S1 Cat. 06-S1
catlvlguid07_01 CRM_REP_CAT_GUID_LEV07_S1 Cat. 07-S1
catlvlguid08_01 CRM_REP_CAT_GUID_LEV08_S1 Cat. 08-S1
catlvlguid09_01 CRM_REP_CAT_GUID_LEV09_S1 Cat. 09-S1
catlvlguid10_01 CRM_REP_CAT_GUID_LEV10_S1 Cat. 10-S1
asp_id_01 CRM_ERMS_CAT_AS_ID Schema ID
cat_id_01 CRM_ERMS_CAT_CA_ID Category ID
catlvlguid01_02 CRM_REP_CAT_GUID_LEV01_S2 Cat. 01-S2
catlvlguid02_02 CRM_REP_CAT_GUID_LEV02_S2 Cat. 02-S2
catlvlguid03_02 CRM_REP_CAT_GUID_LEV03_S2 Cat. 03-S2
catlvlguid04_02 CRM_REP_CAT_GUID_LEV04_S2 Cat. 04-S2
catlvlguid05_02 CRM_REP_CAT_GUID_LEV05_S2 Cat. 05-S2
catlvlguid06_02 CRM_REP_CAT_GUID_LEV06_S2 Cat. 06-S2
catlvlguid07_02 CRM_REP_CAT_GUID_LEV07_S2 Cat. 07-S2
catlvlguid08_02 CRM_REP_CAT_GUID_LEV08_S2 Cat. 08-S2
catlvlguid09_02 CRM_REP_CAT_GUID_LEV09_S2 Cat. 09-S2
catlvlguid10_02 CRM_REP_CAT_GUID_LEV10_S2 Cat. 10-S2
asp_id_02 CRM_ERMS_CAT_AS_ID Schema ID
cat_id_02 CRM_ERMS_CAT_CA_ID Category ID
knar_h_dummy_ps CHAR1 Single-Character Flag

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Knowledge Article Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_KNAR_H (
    CLIENT,                  -- Client [MANDT]
    OBJTYPE_H,               -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,               -- Transaction ID [CRMT_OBJECT_ID_DB]
    CATEGORY,                -- Category [CRMT_ACTIVITY_CATEGORY]
    PRIORITY,                -- Priority [CRMT_PRIORITY]
    CLASS,                   -- Activity class [CRMT_ACTIVITY_CLASS]
    VALID_FROM,              -- KA: Valid from Date [CRMS4_KA_VALID_FROM_DATE]
    VALID_TO,                -- KA: Valid to Date [CRMS4_KA_VALID_TO_DATE]
    HEADER_GUID,             -- Object GUID [CRMT_OBJECT_GUID]
    PROCESS_TYPE,            -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,            -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,           -- Description [CRMT_PROCESS_DESCRIPTION]
    DESCR_LANGUAGE,          -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
    TEMPLATE_TYPE,           -- Templ. Type [CRMT_TEMPLATE_TYPE_DB]
    CREATED_AT_H,            -- Created On [CRMS4_CREATED_AT]
    CREATED_BY_H,            -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_H,            -- Changed On [CRMS4_CHANGED_AT]
    CHANGED_BY_H,            -- Changed By [CRMT_CHANGED_BY]
    HEAD_CHANGED_AT,         -- Changed On [CRMT_CHANGED_AT]
    BTX_CLASS,               -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
    AUTH_SCOPE,              -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,          -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    OBJECT_ID_OK,            -- ID Valid [CRMT_OBJECT_ID_OK]
    VERIFY_DATE,             -- Verify Date [CRMT_VERIFY_DATE]
    HEADER_GUID_CHAR,        -- Object GUID [CRMT_OBJECT_GUID32]
    SDM_STATUS_DURA,         -- Duration Flag [CRMS4_SDM_STATUS_DURA]
    DIS_CHANNEL,             -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    DIVISION,                -- Division [CRMT_DIVISION]
    SERVICE_ORG_ORI,         -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
    SERVICE_ORGR_ORI,        -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
    SALES_ORG_ORI,           -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
    DIS_CHANNEL_ORI,         -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
    SALES_OFF_ORI,           -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
    SALES_GROUP_ORI,         -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
    SALES_ORGR_ORI,          -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
    DIVISION_ORI,            -- Origin: Division [CRMT_DIVISION_ORIGIN]
    SALES_ORG,               -- Sales Org. ID [CRMT_SALES_ORG]
    SALES_OFFICE,            -- Sales Office [CRMT_SALES_OFFICE]
    SALES_GROUP,             -- Sales Group [CRMT_SALES_GROUP]
    SALES_ORG_RESP,          -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
    SERVICE_ORG,             -- Service Organization [CRMT_SERVICE_ORG]
    SERVICE_ORG_RESP,        -- OU (Service) [CRMT_SERVICE_ORG_RESP]
    SALES_ORG_SD,            -- Sales Org. [VKORG]
    SALES_OFFICE_SD,         -- Sales Office [VKBUR]
    SALES_GROUP_SD,          -- Sales Group [VKGRP]
    ENTERPRISE_SERVICE_ORG,  -- Ent. Service Org. [CRMS4_ENTERPRISE_SERVICE_ORG]
    SERVICE_TEAM_RM,         -- Service Team [CRMS4_SERVICE_TEAM_RM]
    SERVICE_TEAM_RM_ORI,     -- Origin Service Team [CRMS4_SERVICE_TEAM_RM_ORIGIN]
    PLANNING_PLANT,          -- Planning Plant [IWERK]
    WORK_CENTER_OBJECT_ID,   -- Work Center [LGWID]
    PERSON_RESP,             -- Employee Resp. [CRMT_PERSON_RESP]
    INBOX_ASSIGNED_TO,       -- Employee Resp. [CRMT_PERSON_RESP]
    INBOX_GROUP_ASSIGNED,    -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
    INBOX_ACCOUNT,           -- Sales Partners [CRMT_SALESPARTNER]
    INBOX_CONTACT_PERSON,    -- Contact Pers. [CRMT_CONTACT_PERSON]
    STAT_LIFECYCLE,          -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
    STAT_RELEASED,           -- Release Status [CRMS4_STAT_RELEASED]
    STAT_CANCELLED,          -- Cancellation Status [CRMS4_STAT_CANCELLED]
    STAT_ERROR,              -- Error Status [CRMS4_STAT_ERROR]
    STAT_ARCHIVABLE,         -- Archivable [CRMS4_STAT_ARCHIVABLE]
    STAT_ARCHIVED,           -- Archived [CRMS4_STAT_ARCHIVED]
    STAT_OPEN,               -- Open [CRMS4_STAT_OPEN]
    INBOX_STATUS,            -- Status [CRMT_AUI_STATUS]
    CATLVLGUID01_01,         -- Cat. 01-S1 [CRM_REP_CAT_GUID_LEV01_S1]
    CATLVLGUID02_01,         -- Cat. 02-S1 [CRM_REP_CAT_GUID_LEV02_S1]
    CATLVLGUID03_01,         -- Cat. 03-S1 [CRM_REP_CAT_GUID_LEV03_S1]
    CATLVLGUID04_01,         -- Cat. 04-S1 [CRM_REP_CAT_GUID_LEV04_S1]
    CATLVLGUID05_01,         -- Cat. 05-S1 [CRM_REP_CAT_GUID_LEV05_S1]
    CATLVLGUID06_01,         -- Cat. 06-S1 [CRM_REP_CAT_GUID_LEV06_S1]
    CATLVLGUID07_01,         -- Cat. 07-S1 [CRM_REP_CAT_GUID_LEV07_S1]
    CATLVLGUID08_01,         -- Cat. 08-S1 [CRM_REP_CAT_GUID_LEV08_S1]
    CATLVLGUID09_01,         -- Cat. 09-S1 [CRM_REP_CAT_GUID_LEV09_S1]
    CATLVLGUID10_01,         -- Cat. 10-S1 [CRM_REP_CAT_GUID_LEV10_S1]
    ASP_ID_01,               -- Schema ID [CRM_ERMS_CAT_AS_ID]
    CAT_ID_01,               -- Category ID [CRM_ERMS_CAT_CA_ID]
    CATLVLGUID01_02,         -- Cat. 01-S2 [CRM_REP_CAT_GUID_LEV01_S2]
    CATLVLGUID02_02,         -- Cat. 02-S2 [CRM_REP_CAT_GUID_LEV02_S2]
    CATLVLGUID03_02,         -- Cat. 03-S2 [CRM_REP_CAT_GUID_LEV03_S2]
    CATLVLGUID04_02,         -- Cat. 04-S2 [CRM_REP_CAT_GUID_LEV04_S2]
    CATLVLGUID05_02,         -- Cat. 05-S2 [CRM_REP_CAT_GUID_LEV05_S2]
    CATLVLGUID06_02,         -- Cat. 06-S2 [CRM_REP_CAT_GUID_LEV06_S2]
    CATLVLGUID07_02,         -- Cat. 07-S2 [CRM_REP_CAT_GUID_LEV07_S2]
    CATLVLGUID08_02,         -- Cat. 08-S2 [CRM_REP_CAT_GUID_LEV08_S2]
    CATLVLGUID09_02,         -- Cat. 09-S2 [CRM_REP_CAT_GUID_LEV09_S2]
    CATLVLGUID10_02,         -- Cat. 10-S2 [CRM_REP_CAT_GUID_LEV10_S2]
    ASP_ID_02,               -- Schema ID [CRM_ERMS_CAT_AS_ID]
    CAT_ID_02,               -- Category ID [CRM_ERMS_CAT_CA_ID]
    KNAR_H_DUMMY_PS,         -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID)
);

Learn More