KNVA_PRC

Transparent Table Application Table
49 Fields 1 CDS Views

Process Records Of OTC 147, Table KNVA

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPCustomerUnloadingPointProc view_entity from BASIC BP Customer Partner Unloading Point Data

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY ablad ABLAD Unloading Point
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
kunnr KUNNR Customer
lfdnr LNRAB Seq. number
knfak KNKAL Cust.calendar
wanid WANID Goods rec.hours
tpqua TPQUA Means Transp. Qual
tpgrp TPGRP Means of Transp. Grp
stzkl STZKL Wait Time Class
stzzu STZZU Wait Time Surcharge
moab1 WAMOAB1 Monday
mobi1 WAMOBI1 Monday
moab2 WAMOAB2 Monday
mobi2 WAMOBI2 Monday
diab1 WADIAB1 Tuesday
dibi1 WADIBI1 Tuesday
diab2 WADIAB2 Tuesday
dibi2 WADIBI2 Tuesday
miab1 WAMIAB1 Wednesday
mibi1 WAMIBI1 Wednesday
miab2 WAMIAB2 Wednesday
mibi2 WAMIBI2 Wednesday
doab1 WADOAB1 Thursday
dobi1 WADOBI1 Thursday
doab2 WADOAB2 Thursday
dobi2 WADOBI2 Thursday
frab1 WAFRAB1 Friday
frbi1 WAFRBI1 Friday
frab2 WAFRAB2 Friday
frbi2 WAFRBI2 Friday
saab1 WASAAB1 Saturday
sabi1 WASABI1 Saturday
saab2 WASAAB2 Saturday
sabi2 WASABI2 Saturday
soab1 WASOAB1 Sunday
sobi1 WASOBI1 Sunday
soab2 WASOAB2 Sunday
sobi2 WASOBI2 Sunday
defab DEFAB Default unld.pt
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
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 KNVA
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVA_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    ABLAD,                     -- Unloading Point [ABLAD]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    KUNNR,                     -- Customer [KUNNR]
    LFDNR,                     -- Seq. number [LNRAB]
    KNFAK,                     -- Cust.calendar [KNKAL]
    WANID,                     -- Goods rec.hours [WANID]
    TPQUA,                     -- Means Transp. Qual [TPQUA]
    TPGRP,                     -- Means of Transp. Grp [TPGRP]
    STZKL,                     -- Wait Time Class [STZKL]
    STZZU,                     -- Wait Time Surcharge [STZZU]
    MOAB1,                     -- Monday [WAMOAB1]
    MOBI1,                     -- Monday [WAMOBI1]
    MOAB2,                     -- Monday [WAMOAB2]
    MOBI2,                     -- Monday [WAMOBI2]
    DIAB1,                     -- Tuesday [WADIAB1]
    DIBI1,                     -- Tuesday [WADIBI1]
    DIAB2,                     -- Tuesday [WADIAB2]
    DIBI2,                     -- Tuesday [WADIBI2]
    MIAB1,                     -- Wednesday [WAMIAB1]
    MIBI1,                     -- Wednesday [WAMIBI1]
    MIAB2,                     -- Wednesday [WAMIAB2]
    MIBI2,                     -- Wednesday [WAMIBI2]
    DOAB1,                     -- Thursday [WADOAB1]
    DOBI1,                     -- Thursday [WADOBI1]
    DOAB2,                     -- Thursday [WADOAB2]
    DOBI2,                     -- Thursday [WADOBI2]
    FRAB1,                     -- Friday [WAFRAB1]
    FRBI1,                     -- Friday [WAFRBI1]
    FRAB2,                     -- Friday [WAFRAB2]
    FRBI2,                     -- Friday [WAFRBI2]
    SAAB1,                     -- Saturday [WASAAB1]
    SABI1,                     -- Saturday [WASABI1]
    SAAB2,                     -- Saturday [WASAAB2]
    SABI2,                     -- Saturday [WASABI2]
    SOAB1,                     -- Sunday [WASOAB1]
    SOBI1,                     -- Sunday [WASOBI1]
    SOAB2,                     -- Sunday [WASOAB2]
    SOBI2,                     -- Sunday [WASOBI2]
    DEFAB,                     -- Default unld.pt [DEFAB]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    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, ABLAD, ASSIGNMENT_ID)
);

Learn More