I_RFQITEMENHWD

CDS View

Request For Quotation Item Enhanced

I_RFQITEMENHWD is a CDS View in S/4HANA. Request For Quotation Item Enhanced. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_RFQItemEnhWD view from CONSUMPTION Request For Quotation Item Enhanced
C_RFQItemHierarchyTP view from CONSUMPTION RFQ Hierarchy for Items

Fields (49)

KeyField CDS FieldsUsed in Views
KEY RequestForQuotation RequestForQuotation 2
KEY RequestForQuotationItem RequestForQuotationItem 2
_BaseUnit _BaseUnit 2
_IncotermsClassification _IncotermsClassification 2
_ManufacturerMaterial _ManufacturerMaterial 2
_Material _Material 2
_MaterialGroup _MaterialGroup 2
_OrderQuantityUnit _OrderQuantityUnit 2
_Plant _Plant 2
_ProductType _ProductType 2
_PurchasingDocumentCategory _PurchasingDocumentCategory 2
AddressID AddressID 2
BaseUnit BaseUnit 2
HierarchyDrillState HierarchyDrillState 2
HierarchyLevel HierarchyLevel 2
HierarchyNode HierarchyNode 2
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber 2
HierarchyNodeSubTreeSize HierarchyNodeSubTreeSize 2
HierarchyParentNode HierarchyParentNode 2
IncotermsClassification IncotermsClassification 2
IncotermsTransferLocation IncotermsTransferLocation 2
IsInfoRecordUpdated IsInfoRecordUpdated 1
IsOutline IsOutline 2
IsStatisticalItem IsStatisticalItem 2
ItemDeliveryAddressID ItemDeliveryAddressID 2
ManualDeliveryAddressID ManualDeliveryAddressID 2
Manufacturer Manufacturer 2
ManufacturerMaterial ManufacturerMaterial 2
ManufacturerPartNmbr ManufacturerPartNmbr 2
Material Material 2
MaterialGroup MaterialGroup 2
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 2
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 2
OrderQuantityUnit OrderQuantityUnit 2
PerformancePeriodEndDate PerformancePeriodEndDate 2
PerformancePeriodStartDate PerformancePeriodStartDate 2
Plant Plant 2
ProductType ProductType,PurgDocProductType 2
PurchaseRequisition PurchaseRequisition 2
PurchaseRequisitionItem PurchaseRequisitionItem 2
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentItemText PurchasingDocumentItemText 2
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode 2
PurchasingParentItem PurchasingParentItem 2
PurgConfigurableItemNumber PurgConfigurableItemNumber 1
PurgExternalSortNumber PurgExternalSortNumber 2
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 2
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 2
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2

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.

-- Request For Quotation Item Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RFQITEMENHWD (
    REQUESTFORQUOTATION,
    REQUESTFORQUOTATIONITEM,
    _BASEUNIT,
    _INCOTERMSCLASSIFICATION,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PRODUCTTYPE,
    _PURCHASINGDOCUMENTCATEGORY,
    ADDRESSID,
    BASEUNIT,
    HIERARCHYDRILLSTATE,
    HIERARCHYLEVEL,
    HIERARCHYNODE,
    HIERARCHYNODEORDINALNUMBER,
    HIERARCHYNODESUBTREESIZE,
    HIERARCHYPARENTNODE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINFORECORDUPDATED,
    ISOUTLINE,
    ISSTATISTICALITEM,
    ITEMDELIVERYADDRESSID,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERQUANTITYUNIT,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORDUPDATECODE,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    PRIMARY KEY (REQUESTFORQUOTATION, REQUESTFORQUOTATIONITEM)
);