MMQTNENH_D

Transparent Table Application Table
53 Fields 1 CDS Views

I_SUPLRQUOTATIONENHWD I_SUPLRQUOTATIONENHWD

MMQTNENH_D is an SAP database table in S/4HANA. I_SUPLRQUOTATIONENHWD I_SUPLRQUOTATIONENHWD. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierQuotationDraft view from BASIC Draft view for Supplier Quotation

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
supplierquotation VDM_SUPPLIERQUOTATION Quotation
companycode BUKRS Company Code
purchasingdocumentcategory EBSTYP Doc. Category
purchasingdocumenttype VDM_QTN_DOC_TYPE Quotation Type
supplier MD_SUPPLIER Supplier
createdbyuser MMPUR_ERNAM Created By
creationdate MMPUR_ERDAT Created On
lastchangedatetime CHANGEDATETIME Last Changed
language SPRAS Language
documentcurrency WAERS Currency
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
paymentterms FARP_DZTERM Payment Terms
cashdiscount1days DZBD1T Days 1
cashdiscount2days DZBD2T Days 2
cashdiscount1percent DZBD1P CD Percentage 1
cashdiscount2percent DZBD2P CD Percentage 2
netpaymentdays DZBD3T Days Net
pricingprocedure KALSM_D Procedure
purchasingdocumentcondition KNUMV Doc. Condition
purchasingorganization EKORG_LL Purchasing Organization
purchasinggroup BKGRP Purch. Group
purchasingdocumentorderdate EBDAT Document Date
exchangerate WKURS Exchange Rate
exchangerateisfixed KUFIX Fixed Exch.Rate
requestforquotation VDM_REQUESTFORQUOTATION RFQ
supplierquotationexternalid ANGNR Quotation
quotationsubmissiondate IHRAN Quotation Date
quotationlatestsubmissiondate ANGAB Quot. Deadline
bindingperiodvalidityenddate EBNDT Binding Period
qtnlifecyclestatus VDM_QTN_LFST_CD Status
followondocumentcategory FOLLOWONDOCCAT Follow-On Document Category
followondocumenttype FOLLOWONDOCTYPE Follow-On Document Type
purcontrvaliditystartdate KDATB_LL Valid From
purcontrvalidityenddate KDATE_LL Valid To
purchasecontracttargetamount KTWRT Target Value
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
purchasingdocumentdeletioncode ELOEK Del. Indicator
totalnetamount abap.curr
purchasingitemhashierarchy BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
scenarioisrelevantforhierarchy VDM_SCENARIOISRELEVANTFORHIER Scenario is relevant for Hierarchy
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_ekko_incl_eew_ps EKKO_INCL_EEW Ext. Include

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.

-- I_SUPLRQUOTATIONENHWD I_SUPLRQUOTATIONENHWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMQTNENH_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    SUPPLIERQUOTATION,               -- Quotation [VDM_SUPPLIERQUOTATION]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [EBSTYP]
    PURCHASINGDOCUMENTTYPE,          -- Quotation Type [VDM_QTN_DOC_TYPE]
    SUPPLIER,                        -- Supplier [MD_SUPPLIER]
    CREATEDBYUSER,                   -- Created By [MMPUR_ERNAM]
    CREATIONDATE,                    -- Created On [MMPUR_ERDAT]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    LANGUAGE,                        -- Language [SPRAS]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    INCOTERMSVERSION,                -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,              -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,              -- Inco. Location2 [INCO3_L]
    PAYMENTTERMS,                    -- Payment Terms [FARP_DZTERM]
    CASHDISCOUNT1DAYS,               -- Days 1 [DZBD1T]
    CASHDISCOUNT2DAYS,               -- Days 2 [DZBD2T]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [DZBD1P]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [DZBD2P]
    NETPAYMENTDAYS,                  -- Days Net [DZBD3T]
    PRICINGPROCEDURE,                -- Procedure [KALSM_D]
    PURCHASINGDOCUMENTCONDITION,     -- Doc. Condition [KNUMV]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGDOCUMENTORDERDATE,     -- Document Date [EBDAT]
    EXCHANGERATE,                    -- Exchange Rate [WKURS]
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [KUFIX]
    REQUESTFORQUOTATION,             -- RFQ [VDM_REQUESTFORQUOTATION]
    SUPPLIERQUOTATIONEXTERNALID,     -- Quotation [ANGNR]
    QUOTATIONSUBMISSIONDATE,         -- Quotation Date [IHRAN]
    QUOTATIONLATESTSUBMISSIONDATE,   -- Quot. Deadline [ANGAB]
    BINDINGPERIODVALIDITYENDDATE,    -- Binding Period [EBNDT]
    QTNLIFECYCLESTATUS,              -- Status [VDM_QTN_LFST_CD]
    FOLLOWONDOCUMENTCATEGORY,        -- Follow-On Document Category [FOLLOWONDOCCAT]
    FOLLOWONDOCUMENTTYPE,            -- Follow-On Document Type [FOLLOWONDOCTYPE]
    PURCONTRVALIDITYSTARTDATE,       -- Valid From [KDATB_LL]
    PURCONTRVALIDITYENDDATE,         -- Valid To [KDATE_LL]
    PURCHASECONTRACTTARGETAMOUNT,    -- Target Value [KTWRT]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [ELOEK]
    TOTALNETAMOUNT,                  -- abap.curr
    PURCHASINGITEMHASHIERARCHY,      -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    SCENARIOISRELEVANTFORHIERARCHY,  -- Scenario is relevant for Hierarchy [VDM_SCENARIOISRELEVANTFORHIER]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_EKKO_INCL_EEW_PS,          -- Ext. Include [EKKO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More