C_Arberp_Qteqout_Rfq_Item

DDL: C_ARBERP_QTEQOUT_RFQ_ITEM SQL: CARBQTEQOUT_ITEM Type: view CONSUMPTION
28 Fields 1 Data Sources 2 Associations

Consumition view for Request for Quotation item

C_Arberp_Qteqout_Rfq_Item is a Consumption CDS View that provides data about "Consumition view for Request for Quotation item" in SAP S/4HANA. It reads from 1 data source (I_RFQItemEnhanced) and exposes 28 fields with key fields RequestForQuotation, RequestForQuotationItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RFQItemEnhanced I_RFQItemEnhanced from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaterialGroupText _materialgrouptext _materialgrouptext.MaterialGroup = I_RFQItemEnhanced.MaterialGroup
[0..*] I_IncotermsClassificationText _IncotermsClassificationText _IncotermsClassificationText.IncotermsClassification = $projection.IncotermsClassification

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CARBQTEQOUT_ITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumition view for Request for Quotation item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation I_RFQItemEnhanced RequestForQuotation RFQ
KEY RequestForQuotationItem I_RFQItemEnhanced RequestForQuotationItem RFQ Item
PurchasingDocumentCategory I_RFQItemEnhanced PurchasingDocumentCategory Doc. Category
PurchasingDocumentItemText I_RFQItemEnhanced PurchasingDocumentItemText Short Text
Material I_RFQItemEnhanced Material Vehicle Model
ManufacturerMaterial I_RFQItemEnhanced ManufacturerMaterial MPN: Material
ManufacturerPartNmbr I_RFQItemEnhanced ManufacturerPartNmbr Mfr Part Number
Manufacturer I_RFQItemEnhanced Manufacturer Manufacturer
MaterialGroup I_RFQItemEnhanced MaterialGroup Product Group
Language _RFQ Language Report Text Language
MaterialGroupTextasMaterialGroupText
Plant I_RFQItemEnhanced Plant Valuation Area
PlantName
ManualDeliveryAddressID I_RFQItemEnhanced ManualDeliveryAddressID Address Number
ReferenceDeliveryAddressID I_RFQItemEnhanced ReferenceDeliveryAddressID Reference Address
IncotermsClassification I_RFQItemEnhanced IncotermsClassification Incoterms
IncotermsTransferLocation I_RFQItemEnhanced IncotermsTransferLocation Incoterms 2
IncotermsLocation1 I_RFQItemEnhanced IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_RFQItemEnhanced IncotermsLocation2 Inco. Location2
ScheduleLineDeliveryDate I_RFQItemEnhanced ScheduleLineDeliveryDate Delivery Date
ScheduleLineOrderQuantity I_RFQItemEnhanced ScheduleLineOrderQuantity Scheduled Qty
OrderQuantityUnit I_RFQItemEnhanced OrderQuantityUnit Sales Unit
OrderItemQtyToBaseQtyNmrtr I_RFQItemEnhanced OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr I_RFQItemEnhanced OrderItemQtyToBaseQtyDnmntr Denominator
BaseUnit I_RFQItemEnhanced BaseUnit Unit of Measure
PurchaseRequisition I_RFQItemEnhanced PurchaseRequisition Requisition
PurchaseRequisitionItem I_RFQItemEnhanced PurchaseRequisitionItem Requisn. item
_RequestForQuotation _RequestForQuotation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Arberp_Qteqout_Rfq_Item.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CARBQTEQOUT_ITEM

CREATE VIEW C_Arberp_Qteqout_Rfq_Item AS
SELECT
  I_RFQItemEnhanced.RequestForQuotation AS RequestForQuotation,
  I_RFQItemEnhanced.RequestForQuotationItem AS RequestForQuotationItem,
  I_RFQItemEnhanced.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RFQItemEnhanced.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_RFQItemEnhanced.Material AS Material,
  I_RFQItemEnhanced.ManufacturerMaterial AS ManufacturerMaterial,
  I_RFQItemEnhanced.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_RFQItemEnhanced.Manufacturer AS Manufacturer,
  I_RFQItemEnhanced.MaterialGroup AS MaterialGroup,
  _RFQ.Language AS Language,
  coalesce (_materialgrouptext[1: Language = Language].MaterialGroupText, _materialgrouptext[1: Language = 'E'].MaterialGroupText) as MaterialGroupText AS MaterialGroupTextasMaterialGroupText,
  I_RFQItemEnhanced.Plant AS Plant,
  I_RFQItemEnhanced._Plant.PlantName AS PlantName,
  I_RFQItemEnhanced.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_RFQItemEnhanced.ReferenceDeliveryAddressID AS ReferenceDeliveryAddressID,
  I_RFQItemEnhanced.IncotermsClassification AS IncotermsClassification,
  I_RFQItemEnhanced.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RFQItemEnhanced.IncotermsLocation1 AS IncotermsLocation1,
  I_RFQItemEnhanced.IncotermsLocation2 AS IncotermsLocation2,
  I_RFQItemEnhanced.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_RFQItemEnhanced.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  I_RFQItemEnhanced.OrderQuantityUnit AS OrderQuantityUnit,
  I_RFQItemEnhanced.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_RFQItemEnhanced.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_RFQItemEnhanced.BaseUnit AS BaseUnit,
  I_RFQItemEnhanced.PurchaseRequisition AS PurchaseRequisition,
  I_RFQItemEnhanced.PurchaseRequisitionItem AS PurchaseRequisitionItem
FROM I_RFQItemEnhanced
LEFT OUTER JOIN I_MaterialGroupText AS _materialgrouptext ON _materialgrouptext.MaterialGroup = I_RFQItemEnhanced.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON _IncotermsClassificationText.IncotermsClassification = IncotermsClassification  -- association [0..*]
;

Learn More