KNVA_DFT

Transparent Table Application Table
43 Fields 1 CDS Views

Draft table for entity I_BPCUSTUNLOADINGPOINTGOVTP

KNVA_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCUSTUNLOADINGPOINTGOVTP. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPCustUnloadingPointGovDraft view_entity from BASIC Draft BP Customer Unloading Point

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY customerunloadingpointuuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
KEY unloadingpointname ablad Unloading Point
unloadingpointnameforedit ablad Unloading Point
bpassignmentid mdg_bp_assignment_id Assignment ID
mdchgprocessstep mdc_process_step_no Step Number
customer kunnr Customer
customerfactorycalendercode knkal Cust.calendar
bpgoodsreceivinghourscode wanid Goods rec.hours
isdfltbpunloadingpoint defab Default unld.pt
mondaymorningopeningtime wamoab1 Monday
mondaymorningclosingtime wamobi1 Monday
mondayafternoonopeningtime wamoab2 Monday
mondayafternoonclosingtime wamobi2 Monday
tuesdaymorningopeningtime wadiab1 Tuesday
tuesdaymorningclosingtime wadibi1 Tuesday
tuesdayafternoonopeningtime wadiab2 Tuesday
tuesdayafternoonclosingtime wadibi2 Tuesday
wednesdaymorningopeningtime wamiab1 Wednesday
wednesdaymorningclosingtime wamibi1 Wednesday
wednesdayafternoonopeningtime wamiab2 Wednesday
wednesdayafternoonclosingtime wamibi2 Wednesday
thursdaymorningopeningtime wadoab1 Thursday
thursdaymorningclosingtime wadobi1 Thursday
thursdayafternoonopeningtime wadoab2 Thursday
thursdayafternoonclosingtime wadobi2 Thursday
fridaymorningopeningtime wafrab1 Friday
fridaymorningclosingtime wafrbi1 Friday
fridayafternoonopeningtime wafrab2 Friday
fridayafternoonclosingtime wafrbi2 Friday
saturdaymorningopeningtime wasaab1 Saturday
saturdaymorningclosingtime wasabi1 Saturday
saturdayafternoonopeningtime wasaab2 Saturday
saturdayafternoonclosingtime wasabi2 Saturday
sundaymorningopeningtime wasoab1 Sunday
sundaymorningclosingtime wasobi1 Sunday
sundayafternoonopeningtime wasoab2 Sunday
sundayafternoonclosingtime wasobi2 Sunday
masterdataiscurrent abap_boolean Truth Value

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.

-- Draft table for entity I_BPCUSTUNLOADINGPOINTGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVA_DFT (
    MANDT,                          -- Client [mandt]
    BUSINESSPARTNERUUID,            -- UUID [sysuuid_x]
    CUSTOMERUNLOADINGPOINTUUID,     -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,        -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [mdc_source_id]
    UNLOADINGPOINTNAME,             -- Unloading Point [ablad]
    UNLOADINGPOINTNAMEFOREDIT,      -- Unloading Point [ablad]
    BPASSIGNMENTID,                 -- Assignment ID [mdg_bp_assignment_id]
    MDCHGPROCESSSTEP,               -- Step Number [mdc_process_step_no]
    CUSTOMER,                       -- Customer [kunnr]
    CUSTOMERFACTORYCALENDERCODE,    -- Cust.calendar [knkal]
    BPGOODSRECEIVINGHOURSCODE,      -- Goods rec.hours [wanid]
    ISDFLTBPUNLOADINGPOINT,         -- Default unld.pt [defab]
    MONDAYMORNINGOPENINGTIME,       -- Monday [wamoab1]
    MONDAYMORNINGCLOSINGTIME,       -- Monday [wamobi1]
    MONDAYAFTERNOONOPENINGTIME,     -- Monday [wamoab2]
    MONDAYAFTERNOONCLOSINGTIME,     -- Monday [wamobi2]
    TUESDAYMORNINGOPENINGTIME,      -- Tuesday [wadiab1]
    TUESDAYMORNINGCLOSINGTIME,      -- Tuesday [wadibi1]
    TUESDAYAFTERNOONOPENINGTIME,    -- Tuesday [wadiab2]
    TUESDAYAFTERNOONCLOSINGTIME,    -- Tuesday [wadibi2]
    WEDNESDAYMORNINGOPENINGTIME,    -- Wednesday [wamiab1]
    WEDNESDAYMORNINGCLOSINGTIME,    -- Wednesday [wamibi1]
    WEDNESDAYAFTERNOONOPENINGTIME,  -- Wednesday [wamiab2]
    WEDNESDAYAFTERNOONCLOSINGTIME,  -- Wednesday [wamibi2]
    THURSDAYMORNINGOPENINGTIME,     -- Thursday [wadoab1]
    THURSDAYMORNINGCLOSINGTIME,     -- Thursday [wadobi1]
    THURSDAYAFTERNOONOPENINGTIME,   -- Thursday [wadoab2]
    THURSDAYAFTERNOONCLOSINGTIME,   -- Thursday [wadobi2]
    FRIDAYMORNINGOPENINGTIME,       -- Friday [wafrab1]
    FRIDAYMORNINGCLOSINGTIME,       -- Friday [wafrbi1]
    FRIDAYAFTERNOONOPENINGTIME,     -- Friday [wafrab2]
    FRIDAYAFTERNOONCLOSINGTIME,     -- Friday [wafrbi2]
    SATURDAYMORNINGOPENINGTIME,     -- Saturday [wasaab1]
    SATURDAYMORNINGCLOSINGTIME,     -- Saturday [wasabi1]
    SATURDAYAFTERNOONOPENINGTIME,   -- Saturday [wasaab2]
    SATURDAYAFTERNOONCLOSINGTIME,   -- Saturday [wasabi2]
    SUNDAYMORNINGOPENINGTIME,       -- Sunday [wasoab1]
    SUNDAYMORNINGCLOSINGTIME,       -- Sunday [wasobi1]
    SUNDAYAFTERNOONOPENINGTIME,     -- Sunday [wasoab2]
    SUNDAYAFTERNOONCLOSINGTIME,     -- Sunday [wasobi2]
    MASTERDATAISCURRENT,            -- Truth Value [abap_boolean]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, CUSTOMERUNLOADINGPOINTUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, UNLOADINGPOINTNAME)
);

Learn More