I_SUPLRQUOTATIONITEMENHWD

CDS View
56 Fields 2 CDS Views

Supplier Quotation Item Enhanced

I_SUPLRQUOTATIONITEMENHWD is a CDS View in S/4HANA. Supplier Quotation Item Enhanced. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SuplrQtnItemHierarchyTP view from CONSUMPTION QTN Hierarchy for Items
C_SuplrQuotationItemEnhWD view from CONSUMPTION Supplier Quotation Item Enhanced

Fields (56)

KeyField CDS FieldsUsed in Views
KEY SupplierQuotation SupplierQuotation 2
KEY SupplierQuotationItem SupplierQuotationItem 2
_DocumentCurrency _DocumentCurrency 2
_ManufacturerMaterial _ManufacturerMaterial 2
_Material _Material 2
_MaterialGroup _MaterialGroup 2
_Plant _Plant 2
_ProductType _ProductType 2
_PurgDocumentCategory _PurgDocumentCategory 2
AddressID AddressID 2
AwardedQuantity AwardedQuantity 2
DocumentCurrency DocumentCurrency 2
EffectiveAmount EffectiveAmount 2
GrossAmount GrossAmount 2
HierarchyDrillState HierarchyDrillState 2
HierarchyLevel HierarchyLevel 2
HierarchyNode HierarchyNode 2
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber 2
HierarchyNodeSubTreeSize HierarchyNodeSubTreeSize 2
HierarchyParentNode HierarchyParentNode 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
NetAmount NetAmount 2
NetPriceAmount NetPriceAmount 2
NetPriceQuantity NetPriceQuantity 2
OrderPriceUnit OrderPriceUnit 2
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 2
OrderQuantityUnit OrderQuantityUnit 2
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 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
PurchasingInfoRecord PurchasingInfoRecord 2
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode 2
PurchasingParentItem PurchasingParentItem 2
PurgConfigurableItemNumber PurgConfigurableItemNumber 2
PurgExternalSortNumber PurgExternalSortNumber 2
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 2
RequestForQuotation RequestForQuotation 2
RequestForQuotationItem RequestForQuotationItem 2
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 2
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2
SupplierMaterialNumber SupplierMaterialNumber 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.

-- Supplier Quotation Item Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPLRQUOTATIONITEMENHWD (
    SUPPLIERQUOTATION,
    SUPPLIERQUOTATIONITEM,
    _DOCUMENTCURRENCY,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _PLANT,
    _PRODUCTTYPE,
    _PURGDOCUMENTCATEGORY,
    ADDRESSID,
    AWARDEDQUANTITY,
    DOCUMENTCURRENCY,
    EFFECTIVEAMOUNT,
    GROSSAMOUNT,
    HIERARCHYDRILLSTATE,
    HIERARCHYLEVEL,
    HIERARCHYNODE,
    HIERARCHYNODEORDINALNUMBER,
    HIERARCHYNODESUBTREESIZE,
    HIERARCHYPARENTNODE,
    ISINFORECORDUPDATED,
    ISOUTLINE,
    ISSTATISTICALITEM,
    ITEMDELIVERYADDRESSID,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDUPDATECODE,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    REQUESTFORQUOTATION,
    REQUESTFORQUOTATIONITEM,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    SUPPLIERMATERIALNUMBER,
    PRIMARY KEY (SUPPLIERQUOTATION, SUPPLIERQUOTATIONITEM)
);

Learn More