KNA1_KSSK_PRC

Transparent Table Application Table
25 Fields 1 CDS Views

Process Records Of OTC 147, Table KNA1_KSSK

KNA1_KSSK_PRC is an SAP database table in S/4HANA. Process Records Of OTC 147, Table KNA1_KSSK. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPCustClfnClAssgmtProcess view_entity from BASIC Customer classification class assignment

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Process Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY mafid KLMAF Object/Class
KEY klart KLASSENART Class Type
KEY adzhl ADZHL Int. counter
KEY source_clint MDC_SOURCE_CLINT Source CLINT
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
zaehl POSNUMMER Pos.
statu CLSTATUS Status
stdcl STDCLASS Std class
rekri REKRI_CL Recursive
aennr AENNR Change Number
datuv DATUV Valid From
lkenz LKENZ Deletion Ind.
datub DATUB to
class KLASSE_D Class
clint CLINT Int. Class No.
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID

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.

-- Process Records Of OTC 147, Table KNA1_KSSK
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1_KSSK_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Process Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    MAFID,                     -- Object/Class [KLMAF]
    KLART,                     -- Class Type [KLASSENART]
    ADZHL,                     -- Int. counter [ADZHL]
    SOURCE_CLINT,              -- Source CLINT [MDC_SOURCE_CLINT]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    ZAEHL,                     -- Pos. [POSNUMMER]
    STATU,                     -- Status [CLSTATUS]
    STDCL,                     -- Std class [STDCLASS]
    REKRI,                     -- Recursive [REKRI_CL]
    AENNR,                     -- Change Number [AENNR]
    DATUV,                     -- Valid From [DATUV]
    LKENZ,                     -- Deletion Ind. [LKENZ]
    DATUB,                     -- to [DATUB]
    CLASS,                     -- Class [KLASSE_D]
    CLINT,                     -- Int. Class No. [CLINT]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, MAFID, KLART, ADZHL, SOURCE_CLINT, ASSIGNMENT_ID)
);

Learn More