KNVP_PRC

Transparent Table Application Table

Master Data Consolidation: Process Table for KNVP

KNVP_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for KNVP. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPCustPartnerFunctionsProc view_entity from BASIC BP Customer Partner Functions Data

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
kunnr kunnr Customer
kunn2 kunn2 Customer
lifnr lifnr Supplier
pernr pernr_d Personnel No.
parnr parnr Contact Person
knref knref Partner desc.
defpa defpa Default Partner
adrnr bu_addrnum Address Number
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.

-- Master Data Consolidation: Process Table for KNVP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVP_PRC (
    MANDT,                     -- Client [mandt]
    KUNNR,                     -- Customer [kunnr]
    KUNN2,                     -- Customer [kunn2]
    LIFNR,                     -- Supplier [lifnr]
    PERNR,                     -- Personnel No. [pernr_d]
    PARNR,                     -- Contact Person [parnr]
    KNREF,                     -- Partner desc. [knref]
    DEFPA,                     -- Default Partner [defpa]
    ADRNR,                     -- Address Number [bu_addrnum]
    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 (MANDT)
);