MMRFQITEMENH_D

Transparent Table Application Table
50 Fields 2 CDS Views

I_REQUESTFORQUOTATIONENHWD I_RFQITEMENHWD

MMRFQITEMENH_D is an SAP database table in S/4HANA. I_REQUESTFORQUOTATIONENHWD I_RFQITEMENHWD. It contains 50 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RFQItemDraftForManagePurReqn view from BASIC I-View to Display RFQ Item Draft Data Created from PR
P_RFQItemHierNodeRelationDraft view from BASIC Source View for Draft RFQ itms Hierarchy

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
requestforquotationitem vdm_requestforquotationitem RFQ Item
requestforquotation ebeln Purchasing Doc.
purchasingdocumentcategory bstyp Doc. Category
purchasingdocumentitemtext txz01 Short Text
material matnr Material
producttype product_type Product Type Group
manufacturermaterial vdm_manufacturer_material Material
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 vdm_requested_quantity Requested Quantity
performanceperiodstartdate vdm_performanceperiodstartdate Start of Performance Period
performanceperiodenddate vdm_performanceperiodenddate End of Performance Period
orderquantityunit bstme Order Unit
orderitemqtytobaseqtynmrtr umbsz Equal To
orderitemqtytobaseqtydnmntr umbsn Denominator
baseunit lagme Base Unit
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item
isinforecordupdated mm_rfq_infrec_update Info Record Update
purchasinginforecordupdatecode spinf InfoUpdate
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

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_REQUESTFORQUOTATIONENHWD I_RFQITEMENHWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMRFQITEMENH_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                 -- Key [/bobf/uuid]
    REQUESTFORQUOTATIONITEM,         -- RFQ Item [vdm_requestforquotationitem]
    REQUESTFORQUOTATION,             -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [bstyp]
    PURCHASINGDOCUMENTITEMTEXT,      -- Short Text [txz01]
    MATERIAL,                        -- Material [matnr]
    PRODUCTTYPE,                     -- Product Type Group [product_type]
    MANUFACTURERMATERIAL,            -- Material [vdm_manufacturer_material]
    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,       -- Requested Quantity [vdm_requested_quantity]
    PERFORMANCEPERIODSTARTDATE,      -- Start of Performance Period [vdm_performanceperiodstartdate]
    PERFORMANCEPERIODENDDATE,        -- End of Performance Period [vdm_performanceperiodenddate]
    ORDERQUANTITYUNIT,               -- Order Unit [bstme]
    ORDERITEMQTYTOBASEQTYNMRTR,      -- Equal To [umbsz]
    ORDERITEMQTYTOBASEQTYDNMNTR,     -- Denominator [umbsn]
    BASEUNIT,                        -- Base Unit [lagme]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    ISINFORECORDUPDATED,             -- Info Record Update [mm_rfq_infrec_update]
    PURCHASINGINFORECORDUPDATECODE,  -- InfoUpdate [spinf]
    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]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More