NSDM_E_MKPF

CDS View
33 Fields 6 CDS Views

Extension for Append JVMKPF on MKPF

NSDM_E_MKPF is a CDS View in S/4HANA. Extension for Append JVMKPF on MKPF. It contains 33 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_MATERIAL_ITEM view left_outer Material items
NSDM_E_U_16768 view from U_16768 Compatibility View
view_gr_head_p view from Header Related Data of Goods Receipt
WB2_DDL_MKPF_MSEG view from Redirection View for Material Documents (without WBGT)
WB2_DDL_MKPF_MSEG_WBGT view inner Redirection View for Material Documents
WCB_DDL_MKPF_MSEG view from Material Documents - Business Volume Determination

Fields (33)

KeyField CDS FieldsUsed in Views
KEY aedat aedat 4
KEY awsys AWSYS 3
KEY bfwms BFWMS 3
KEY bktxt bktxt 4
KEY bla2d BLA2D 3
KEY blart blart 4
KEY blaum blaum,DocumentTypeofRevaluationDoc 5
KEY bldat bldat 4
KEY budat budat 4
KEY cpudt cpudt 4
KEY cputm cputm 4
KEY exnum EXNUM,ForeignTradeNumber 4
KEY fls_rsto FLS_RSTO 1
KEY frath FRATH 3
KEY frbnr FRBNR 3
KEY gts_cusref_no GTS_CUSREF_NO 1
KEY knumv KNUMV 1
KEY le_vbeln LE_VBELN 1
KEY mandt mandt 4
KEY mblnr mblnr 4
KEY mjahr mjahr 4
KEY msr_active MSR_ACTIVE 1
KEY spe_budat_uhr SPE_BUDAT_UHR 1
KEY spe_budat_zone SPE_BUDAT_ZONE 1
KEY spe_logsys SPE_LOGSYS 1
KEY spe_mdnum_ewm SPE_MDNUM_EWM 1
KEY tcode tcode 4
KEY tcode2 TCODE2 3
KEY usnam usnam 4
KEY vgart vgart 4
KEY wever WEVER 3
KEY xabln XABLN 3
KEY xblnr XBLNR 3

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.

-- Extension for Append JVMKPF on MKPF
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MKPF (
    AEDAT,
    AWSYS,
    BFWMS,
    BKTXT,
    BLA2D,
    BLART,
    BLAUM,
    BLDAT,
    BUDAT,
    CPUDT,
    CPUTM,
    EXNUM,
    FLS_RSTO,
    FRATH,
    FRBNR,
    GTS_CUSREF_NO,
    KNUMV,
    LE_VBELN,
    MANDT,
    MBLNR,
    MJAHR,
    MSR_ACTIVE,
    SPE_BUDAT_UHR,
    SPE_BUDAT_ZONE,
    SPE_LOGSYS,
    SPE_MDNUM_EWM,
    TCODE,
    TCODE2,
    USNAM,
    VGART,
    WEVER,
    XABLN,
    XBLNR,
    PRIMARY KEY (AEDAT, AWSYS, BFWMS, BKTXT, BLA2D, BLART, BLAUM, BLDAT, BUDAT, CPUDT, CPUTM, EXNUM, FLS_RSTO, FRATH, FRBNR, GTS_CUSREF_NO, KNUMV, LE_VBELN, MANDT, MBLNR, MJAHR, MSR_ACTIVE, SPE_BUDAT_UHR, SPE_BUDAT_ZONE, SPE_LOGSYS, SPE_MDNUM_EWM, TCODE, TCODE2, USNAM, VGART, WEVER, XABLN, XBLNR)
);

Learn More