KNVV_ADDR_PRC

Transparent Table Application Table
28 Fields 2 CDS Views

Process Records Of OTC 147, Table KNVV_ADDR

KNVV_ADDR_PRC is an SAP database table in S/4HANA. Process Records Of OTC 147, Table KNVV_ADDR. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustAddrDepdntSalesDtaProc view_entity from EXTENSION BP Cust Address Depdnt Sales Data Proc - Extension
I_BPCustAddrDepdntSalesDtaProc view_entity from BASIC Customer Address Dependant Sales Data

Fields (28)

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 source_addrnumber BU_ADDRNUM Address Number
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY spart SPART Division
kunnr KUNNR Customer
adrnr BU_ADDRNUM Address Number
inco1 INCO1 Incoterms
lifsd LIFSD_V DelBlckSalesAr.
vkbur VKBUR Sales Office
vkgrp VKGRP Sales Group
vsbed VSBED Shipping Conditions
vwerk DWERK_EXT Deliver.Plant
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
knvv_addr_eew_cust KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination
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 KNVV_ADDR
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVV_ADDR_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]
    SOURCE_ADDRNUMBER,         -- Address Number [BU_ADDRNUM]
    VKORG,                     -- Sales Org. [VKORG]
    VTWEG,                     -- Distr. Channel [VTWEG]
    SPART,                     -- Division [SPART]
    KUNNR,                     -- Customer [KUNNR]
    ADRNR,                     -- Address Number [BU_ADDRNUM]
    INCO1,                     -- Incoterms [INCO1]
    LIFSD,                     -- DelBlckSalesAr. [LIFSD_V]
    VKBUR,                     -- Sales Office [VKBUR]
    VKGRP,                     -- Sales Group [VKGRP]
    VSBED,                     -- Shipping Conditions [VSBED]
    VWERK,                     -- Deliver.Plant [DWERK_EXT]
    INCOV,                     -- Inco. Version [INCOV]
    INCO2_L,                   -- Inco. Location1 [INCO2_L]
    INCO3_L,                   -- Inco. Location2 [INCO3_L]
    KNVV_ADDR_EEW_CUST,        -- Customer sales addr. dep. extensibility [KNVV_ADDR_EEW_CUST]
    INCO2_KEY,                 -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,                 -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,                 -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    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, SOURCE_ADDRNUMBER, VKORG, VTWEG, SPART)
);

Learn More