KNA1_DRAD_PRC

Transparent Table Application Table
32 Fields 1 CDS Views

Process Records Of OTC 147, Table KNA1_DRAD

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPCustDocumentAssgmtProc view_entity from BASIC BP Customer Document Assignment

Fields (32)

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 dokar DOKAR Document Type
KEY doknr DOKNR Document
KEY dokvr DOKVR Doc. Version
KEY doktl DOKTL_D Document Part
KEY dokob DOKOB Object
KEY obzae OBZAE Obj.Ctr
KEY objky OBJKY Object Key
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
kunnr KUNNR Customer
vrkstat VRKSTAT Link status
vrkstat1 STAT_OBVK Object link status
vobj TABELLE Table
vkey OBJKY Object Key
vdir DRADDIR Active
viewflag CV_VIEW_FLAG View indocator
delflag DEL_DRAD_FLAG Deletion ind.
longtext_id LONGTEXT_ID DMS: GUID for Allocation of Long Texts
cad_pos CAD_POS CAD
cm_fixed DMS_CM_FIXED Fixed
archflag DMS_ARCH_FLAG Arch. Flag
dummy_drad_incl_eew_ps DRAD_INCL_EEW Data Element for Document Info Recoed Object Link
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
bo_altkey DMS_BO_ALTKEY Alternate Key
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

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_DRAD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1_DRAD_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]
    DOKAR,                     -- Document Type [DOKAR]
    DOKNR,                     -- Document [DOKNR]
    DOKVR,                     -- Doc. Version [DOKVR]
    DOKTL,                     -- Document Part [DOKTL_D]
    DOKOB,                     -- Object [DOKOB]
    OBZAE,                     -- Obj.Ctr [OBZAE]
    OBJKY,                     -- Object Key [OBJKY]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    KUNNR,                     -- Customer [KUNNR]
    VRKSTAT,                   -- Link status [VRKSTAT]
    VRKSTAT1,                  -- Object link status [STAT_OBVK]
    VOBJ,                      -- Table [TABELLE]
    VKEY,                      -- Object Key [OBJKY]
    VDIR,                      -- Active [DRADDIR]
    VIEWFLAG,                  -- View indocator [CV_VIEW_FLAG]
    DELFLAG,                   -- Deletion ind. [DEL_DRAD_FLAG]
    LONGTEXT_ID,               -- DMS: GUID for Allocation of Long Texts [LONGTEXT_ID]
    CAD_POS,                   -- CAD [CAD_POS]
    CM_FIXED,                  -- Fixed [DMS_CM_FIXED]
    ARCHFLAG,                  -- Arch. Flag [DMS_ARCH_FLAG]
    DUMMY_DRAD_INCL_EEW_PS,    -- Data Element for Document Info Recoed Object Link [DRAD_INCL_EEW]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    BO_ALTKEY,                 -- Alternate Key [DMS_BO_ALTKEY]
    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]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, DOKAR, DOKNR, DOKVR, DOKTL, DOKOB, OBZAE, OBJKY, ASSIGNMENT_ID)
);

Learn More