KNVA

Transparent Table Application Table
39 Fields 1 CDS Views

Customer Master Unloading Points

KNVA is an SAP database table in S/4HANA. Customer Master Unloading Points. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustomerUnloadingPoint view from BASIC Customer Unloading Point

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY ablad ABLAD Unloading Point
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

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.

-- Customer Master Unloading Points
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVA (
    MANDT,  -- Client [MANDT]
    KUNNR,  -- Customer [KUNNR]
    ABLAD,  -- Unloading Point [ABLAD]
    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]
    PRIMARY KEY (MANDT, KUNNR, ABLAD)
);

Learn More