KNVA_ADDR

Transparent Table Application Table
36 Fields 1 CDS Views

Customer Master Address dependent Unloading Points

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustUnldgPtAddrDepdntInfo view from BASIC Unloading Points dependent on Address

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kunnr kunnr Customer
KEY adrnr bu_addrnum Address Number
KEY ablad ablad Unloading Point
lfdnr lnrab Seq. number
knfak knkal Cust.calendar
wanid wanid Goods rec.hours
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 Address dependent Unloading Points
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVA_ADDR (
    MANDT,  -- Client [mandt]
    KUNNR,  -- Customer [kunnr]
    ADRNR,  -- Address Number [bu_addrnum]
    ABLAD,  -- Unloading Point [ablad]
    LFDNR,  -- Seq. number [lnrab]
    KNFAK,  -- Cust.calendar [knkal]
    WANID,  -- Goods rec.hours [wanid]
    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, ADRNR, ABLAD)
);

Learn More