TVWA

Transparent Table Customizing Table
30 Fields 3 CDS Views

Customers: Goods receiving hours (default values)

TVWA is an SAP database table in S/4HANA. Customers: Goods receiving hours (default values). It contains 30 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPGoodsReceivingHour view from BASIC BP Goods Receiving Hour
I_BPGoodsReceivingHoursVH view from BASIC Goods receiving hours
I_SiteGoodsReceivingHrsCodeVH view from BASIC Site Goods Receiving Hours

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY 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

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.

-- Customers: Goods receiving hours (default values)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVWA (
    MANDT,  -- Client [MANDT]
    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]
    PRIMARY KEY (MANDT, WANID)
);

Learn More