MMQTNITEMENH_D

Transparent Table Application Table
71 Fields 1 CDS Views

I_SUPLRQUOTATIONENHWD I_SUPLRQUOTATIONITEMENHWD

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SuplrQtnItemHierNdeRltnDraft view from BASIC Source View for Draft RFQ itms Hierarchy

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
supplierquotation EBELN Purchasing Doc.
supplierquotationitem VDM_SUPPLIERQUOTATIONITEM Supplier Quotation Item
purchasingdocumentcategory BSTYP Doc. Category
purchasingdocumentitemtext TXZ01 Short Text
material MATNR Material
producttype PRODUCT_TYPE Product Type Group
manufacturermaterial EMATNR Material
suppliermaterialnumber IDNLF Supp. Mat. No.
manufacturerpartnmbr MFRPN Mfr Part Number
manufacturer MFRNR Manufacturer
materialgroup MATKL Material Group
plant EWERK Plant
manualdeliveryaddressid ADRNR_MM Address
referencedeliveryaddressid ADRN2 Address
addressid ADRNR Address
itemdeliveryaddressid ADRNR_MM Address
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
schedulelinedeliverydate MM_A_DELIVERY_DATE Delivery Date
schedulelineorderquantity ETMEN Scheduled Qty
awardedquantity VDM_AWARDED_QUANTITY Awarded Quantity
performanceperiodstartdate VDM_PERFORMANCEPERIODSTARTDATE Start of Performance Period
performanceperiodenddate VDM_PERFORMANCEPERIODENDDATE End of Performance Period
orderpriceunit BBPRM Order Price Un.
orderpriceunittoorderunitnmrtr BPUMZ Qty Conversion
ordpriceunittoorderunitdnmntr BPUMN Qty Conversion
orderquantityunit BSTME Order Unit
orderitemqtytobaseqtynmrtr UMBSZ Equal To
orderitemqtytobaseqtydnmntr UMBSN Denominator
purgdocpricedate PREDT Price Date
baseunit LAGME Base Unit
netamount VDM_QTN_NET_AMOUNT Quotation Net Value
grossamount BBWERT Gross value
effectiveamount EFFWR Effective value
netpriceamount BPREI Net Price
netpricequantity VDM_PRICE_UNIT Price Unit
documentcurrency WAERS Currency
purchaserequisition BANFN Purchase Req.
purchaserequisitionitem BNFPO Requisn. item
requestforquotation RFQ_ID RFQ
requestforquotationitem RFQ_ITEM Item Number for RFQ
isinforecordupdated MM_RFQ_INFREC_UPDATE Info Record Update
purchasinginforecordupdatecode SPINF InfoUpdate
purchasinginforecord INFNR Info Record
purchasingdocumentitemcategory PSTYP Item Category
purchasingparentitem UEBPO H-Lev. Item
isstatisticalitem STAPO Statistical
hierarchynode RSNODEEXT Hier.node
hierarchyparentnode RSNODEEXT Hier.node
hierarchylevel abap.int4
hierarchynodesubtreesize abap.int4
hierarchydrillstate abap.char
hierarchynodeordinalnumber abap.int8
isoutline MMPUR_IS_ITEMSET Item Set
purgconfigurableitemnumber EXLIN Hierarchy Number
purgdocaggrgdsubitemcategory UPVOR Sub-items
purgexternalsortnumber EXSNR External Sort No.
hasactiveentity SDRAFT_HAS_ACTIVE Has active
addrdraftuuid /BOBF/UUID Key
addrisdraftentity SDRAFT_IS_DRAFT Is draft
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_ekpo_incl_eew_ps EKPO_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_SUPLRQUOTATIONITEMENHWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMQTNITEMENH_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    SUPPLIERQUOTATION,               -- Purchasing Doc. [EBELN]
    SUPPLIERQUOTATIONITEM,           -- Supplier Quotation Item [VDM_SUPPLIERQUOTATIONITEM]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [BSTYP]
    PURCHASINGDOCUMENTITEMTEXT,      -- Short Text [TXZ01]
    MATERIAL,                        -- Material [MATNR]
    PRODUCTTYPE,                     -- Product Type Group [PRODUCT_TYPE]
    MANUFACTURERMATERIAL,            -- Material [EMATNR]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [IDNLF]
    MANUFACTURERPARTNMBR,            -- Mfr Part Number [MFRPN]
    MANUFACTURER,                    -- Manufacturer [MFRNR]
    MATERIALGROUP,                   -- Material Group [MATKL]
    PLANT,                           -- Plant [EWERK]
    MANUALDELIVERYADDRESSID,         -- Address [ADRNR_MM]
    REFERENCEDELIVERYADDRESSID,      -- Address [ADRN2]
    ADDRESSID,                       -- Address [ADRNR]
    ITEMDELIVERYADDRESSID,           -- Address [ADRNR_MM]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    INCOTERMSLOCATION1,              -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,              -- Inco. Location2 [INCO3_L]
    SCHEDULELINEDELIVERYDATE,        -- Delivery Date [MM_A_DELIVERY_DATE]
    SCHEDULELINEORDERQUANTITY,       -- Scheduled Qty [ETMEN]
    AWARDEDQUANTITY,                 -- Awarded Quantity [VDM_AWARDED_QUANTITY]
    PERFORMANCEPERIODSTARTDATE,      -- Start of Performance Period [VDM_PERFORMANCEPERIODSTARTDATE]
    PERFORMANCEPERIODENDDATE,        -- End of Performance Period [VDM_PERFORMANCEPERIODENDDATE]
    ORDERPRICEUNIT,                  -- Order Price Un. [BBPRM]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Qty Conversion [BPUMZ]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Qty Conversion [BPUMN]
    ORDERQUANTITYUNIT,               -- Order Unit [BSTME]
    ORDERITEMQTYTOBASEQTYNMRTR,      -- Equal To [UMBSZ]
    ORDERITEMQTYTOBASEQTYDNMNTR,     -- Denominator [UMBSN]
    PURGDOCPRICEDATE,                -- Price Date [PREDT]
    BASEUNIT,                        -- Base Unit [LAGME]
    NETAMOUNT,                       -- Quotation Net Value [VDM_QTN_NET_AMOUNT]
    GROSSAMOUNT,                     -- Gross value [BBWERT]
    EFFECTIVEAMOUNT,                 -- Effective value [EFFWR]
    NETPRICEAMOUNT,                  -- Net Price [BPREI]
    NETPRICEQUANTITY,                -- Price Unit [VDM_PRICE_UNIT]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    PURCHASEREQUISITION,             -- Purchase Req. [BANFN]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [BNFPO]
    REQUESTFORQUOTATION,             -- RFQ [RFQ_ID]
    REQUESTFORQUOTATIONITEM,         -- Item Number for RFQ [RFQ_ITEM]
    ISINFORECORDUPDATED,             -- Info Record Update [MM_RFQ_INFREC_UPDATE]
    PURCHASINGINFORECORDUPDATECODE,  -- InfoUpdate [SPINF]
    PURCHASINGINFORECORD,            -- Info Record [INFNR]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [PSTYP]
    PURCHASINGPARENTITEM,            -- H-Lev. Item [UEBPO]
    ISSTATISTICALITEM,               -- Statistical [STAPO]
    HIERARCHYNODE,                   -- Hier.node [RSNODEEXT]
    HIERARCHYPARENTNODE,             -- Hier.node [RSNODEEXT]
    HIERARCHYLEVEL,                  -- abap.int4
    HIERARCHYNODESUBTREESIZE,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.char
    HIERARCHYNODEORDINALNUMBER,      -- abap.int8
    ISOUTLINE,                       -- Item Set [MMPUR_IS_ITEMSET]
    PURGCONFIGURABLEITEMNUMBER,      -- Hierarchy Number [EXLIN]
    PURGDOCAGGRGDSUBITEMCATEGORY,    -- Sub-items [UPVOR]
    PURGEXTERNALSORTNUMBER,          -- External Sort No. [EXSNR]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    ADDRDRAFTUUID,                   -- Key [/BOBF/UUID]
    ADDRISDRAFTENTITY,               -- Is draft [SDRAFT_IS_DRAFT]
    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_EKPO_INCL_EEW_PS,          -- Ext. Include [EKPO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More