KNA1_ADDR_PRC

Transparent Table Application Table
25 Fields 2 CDS Views

Process Records Of OTC 147, Table KNA1_ADDR

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustAddrDepdntInfoProcess view_entity from EXTENSION BP Customer Address Depdnt Info Proc - Extension
I_BPCustAddrDepdntInfoProcess view_entity from BASIC BP Customer Address Dependent Information

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 source_addrnumber BU_ADDRNUM Address Number
kunnr KUNNR Customer
adrnr BU_ADDRNUM Address Number
bahne BAHNE Express station
bahns BAHNS Train station
cityc CITYC City Code
counc COUNC County Code
exabl EXABL Unloading pts
kna1_addr_eew_cust KNA1_ADDR_EEW_CUST Customer General addr. dep. extensibility
j_1iexcd J_1IEXCD ECC No.
j_1iexrn J_1IEXRN Excise Reg. No.
j_1iexrg J_1IEXRG Excise Range
j_1iexdi J_1IEXDI Excise Division
j_1iexco J_1IEXCO Commissionerate
j_1iexcicu J_1IEXCICU Exc.Ind.Cust.
gst_tds J_1IGSTTDS TDS Registration
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_ADDR
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNA1_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]
    KUNNR,                     -- Customer [KUNNR]
    ADRNR,                     -- Address Number [BU_ADDRNUM]
    BAHNE,                     -- Express station [BAHNE]
    BAHNS,                     -- Train station [BAHNS]
    CITYC,                     -- City Code [CITYC]
    COUNC,                     -- County Code [COUNC]
    EXABL,                     -- Unloading pts [EXABL]
    KNA1_ADDR_EEW_CUST,        -- Customer General addr. dep. extensibility [KNA1_ADDR_EEW_CUST]
    J_1IEXCD,                  -- ECC No. [J_1IEXCD]
    J_1IEXRN,                  -- Excise Reg. No. [J_1IEXRN]
    J_1IEXRG,                  -- Excise Range [J_1IEXRG]
    J_1IEXDI,                  -- Excise Division [J_1IEXDI]
    J_1IEXCO,                  -- Commissionerate [J_1IEXCO]
    J_1IEXCICU,                -- Exc.Ind.Cust. [J_1IEXCICU]
    GST_TDS,                   -- TDS Registration [J_1IGSTTDS]
    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)
);

Learn More