KNVA_DFT

Transparent Table Application Table
49 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 49 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 (49)

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 Process 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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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,               -- Process 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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, CUSTOMERUNLOADINGPOINTUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, UNLOADINGPOINTNAME)
);

Learn More