C_Arberp_Qteqout_Rfq

DDL: C_ARBERP_QTEQOUT_RFQ SQL: CARBQTEQOUT_RFQ Type: view CONSUMPTION

Consumption view Request for Quotation

C_Arberp_Qteqout_Rfq is a Consumption CDS View that provides data about "Consumption view Request for Quotation" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotationEnhanced) and exposes 45 fields with key field RequestForQuotation. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RequestForQuotationEnhanced I_RequestForQuotationEnhanced from

Associations (4)

CardinalityTargetAliasCondition
[1..*] C_Arberp_Qteqout_Rfq_Item _Item $projection.RequestForQuotation = _Item.RequestForQuotation
[0..1] C_Arberp_Address _CompanyCodeAddress _CompanyCodeAddress.AddressID = $projection.CompanyCodeAddressID
[1..*] C_Arberp_Qteqout_Bidder _Bidder $projection.RequestForQuotation = _Bidder.RequestForQuotation
[1..1] P_RFQDocumentType _DocumentType $projection.PurchasingDocumentType = _DocumentType.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _DocumentType.PurchasingDocumentCategory

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CARBQTEQOUT_RFQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view Request for Quotation 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 (45)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation I_RequestForQuotationEnhanced RequestForQuotation RFQ
RequestForQuotationName I_RequestForQuotationEnhanced RequestForQuotationName RFQ Description
CompanyCode I_RequestForQuotationEnhanced CompanyCode Receiver Company Code
CompanyCodeName
CompanyCodeAddressID
PurchasingDocumentCategory I_RequestForQuotationEnhanced PurchasingDocumentCategory Doc. Category
PurchasingDocumentType I_RequestForQuotationEnhanced PurchasingDocumentType RFQ Type
CreatedByUser I_RequestForQuotationEnhanced CreatedByUser User Name
CreationDate I_RequestForQuotationEnhanced CreationDate Time Stamp
Language I_RequestForQuotationEnhanced Language Report Text Language
PurchasingOrganization I_RequestForQuotationEnhanced PurchasingOrganization Purchasing Organization
PurchasingOrganizationName
PurchasingGroup I_RequestForQuotationEnhanced PurchasingGroup Purchasing Group
PurchasingGroupName
DocumentCurrency I_RequestForQuotationEnhanced DocumentCurrency Document Currency
IncotermsClassification I_RequestForQuotationEnhanced IncotermsClassification Incoterms
IncotermsTransferLocation I_RequestForQuotationEnhanced IncotermsTransferLocation Incoterms 2
IncotermsVersion I_RequestForQuotationEnhanced IncotermsVersion Inco. Version
IncotermsLocation1 I_RequestForQuotationEnhanced IncotermsLocation1 Inco. Location1
IncotermsLocation2 I_RequestForQuotationEnhanced IncotermsLocation2 Inco. Location2
PaymentTerms I_RequestForQuotationEnhanced PaymentTerms Pyt Terms
CashDiscount1Days I_RequestForQuotationEnhanced CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days I_RequestForQuotationEnhanced CashDiscount2Days Days from Baseline Date for Payment
CashDiscount1Percent I_RequestForQuotationEnhanced CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent I_RequestForQuotationEnhanced CashDiscount2Percent Disc. Percent 2
NetPaymentDays I_RequestForQuotationEnhanced NetPaymentDays Net Pmt Terms Period
RFQPublishingDate I_RequestForQuotationEnhanced RFQPublishingDate Publishing Date
QuotationLatestSubmissionDate I_RequestForQuotationEnhanced QuotationLatestSubmissionDate Quot. Deadline
BindingPeriodValidityEndDate I_RequestForQuotationEnhanced BindingPeriodValidityEndDate Binding Period
RFQAwardingType _DocumentType RFQAwardingType
RFQcXMLProcessType _DocumentType RFQcXMLProcessType
_CompanyCode I_RequestForQuotationEnhanced _CompanyCode
_DocumentCurrency I_RequestForQuotationEnhanced _DocumentCurrency
_IncotermsClassification I_RequestForQuotationEnhanced _IncotermsClassification
_PurchasingDocumentType I_RequestForQuotationEnhanced _PurchasingDocumentType
_PurchasingGroup I_RequestForQuotationEnhanced _PurchasingGroup
_PurchasingOrganization I_RequestForQuotationEnhanced _PurchasingOrganization
_PurchasingDocumentCategory I_RequestForQuotationEnhanced _PurchasingDocumentCategory
_RequestForQuotationItem I_RequestForQuotationEnhanced _RequestForQuotationItem
_RFQBidder I_RequestForQuotationEnhanced _RFQBidder
_SupplierQuotation I_RequestForQuotationEnhanced _SupplierQuotation
IsEndOfPurposeBlocked I_RequestForQuotationEnhanced IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_Item _Item
_CompanyCodeAddress _CompanyCodeAddress
_Bidder _Bidder

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.
-- 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_RFQ

CREATE VIEW C_Arberp_Qteqout_Rfq AS
SELECT
  I_RequestForQuotationEnhanced.RequestForQuotation AS RequestForQuotation,
  I_RequestForQuotationEnhanced.RequestForQuotationName AS RequestForQuotationName,
  I_RequestForQuotationEnhanced.CompanyCode AS CompanyCode,
  I_RequestForQuotationEnhanced._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_RequestForQuotationEnhanced._CompanyCode.AddressID AS CompanyCodeAddressID,
  I_RequestForQuotationEnhanced.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RequestForQuotationEnhanced.PurchasingDocumentType AS PurchasingDocumentType,
  I_RequestForQuotationEnhanced.CreatedByUser AS CreatedByUser,
  I_RequestForQuotationEnhanced.CreationDate AS CreationDate,
  I_RequestForQuotationEnhanced.Language AS Language,
  I_RequestForQuotationEnhanced.PurchasingOrganization AS PurchasingOrganization,
  I_RequestForQuotationEnhanced._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_RequestForQuotationEnhanced.PurchasingGroup AS PurchasingGroup,
  I_RequestForQuotationEnhanced._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  I_RequestForQuotationEnhanced.DocumentCurrency AS DocumentCurrency,
  I_RequestForQuotationEnhanced.IncotermsClassification AS IncotermsClassification,
  I_RequestForQuotationEnhanced.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RequestForQuotationEnhanced.IncotermsVersion AS IncotermsVersion,
  I_RequestForQuotationEnhanced.IncotermsLocation1 AS IncotermsLocation1,
  I_RequestForQuotationEnhanced.IncotermsLocation2 AS IncotermsLocation2,
  I_RequestForQuotationEnhanced.PaymentTerms AS PaymentTerms,
  I_RequestForQuotationEnhanced.CashDiscount1Days AS CashDiscount1Days,
  I_RequestForQuotationEnhanced.CashDiscount2Days AS CashDiscount2Days,
  I_RequestForQuotationEnhanced.CashDiscount1Percent AS CashDiscount1Percent,
  I_RequestForQuotationEnhanced.CashDiscount2Percent AS CashDiscount2Percent,
  I_RequestForQuotationEnhanced.NetPaymentDays AS NetPaymentDays,
  I_RequestForQuotationEnhanced.RFQPublishingDate AS RFQPublishingDate,
  I_RequestForQuotationEnhanced.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_RequestForQuotationEnhanced.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  _DocumentType.RFQAwardingType AS RFQAwardingType,
  _DocumentType.RFQcXMLProcessType AS RFQcXMLProcessType,
  I_RequestForQuotationEnhanced._CompanyCode AS _CompanyCode,
  I_RequestForQuotationEnhanced._DocumentCurrency AS _DocumentCurrency,
  I_RequestForQuotationEnhanced._IncotermsClassification AS _IncotermsClassification,
  I_RequestForQuotationEnhanced._PurchasingDocumentType AS _PurchasingDocumentType,
  I_RequestForQuotationEnhanced._PurchasingGroup AS _PurchasingGroup,
  I_RequestForQuotationEnhanced._PurchasingOrganization AS _PurchasingOrganization,
  I_RequestForQuotationEnhanced._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_RequestForQuotationEnhanced._RequestForQuotationItem AS _RequestForQuotationItem,
  I_RequestForQuotationEnhanced._RFQBidder AS _RFQBidder,
  I_RequestForQuotationEnhanced._SupplierQuotation AS _SupplierQuotation,
  I_RequestForQuotationEnhanced.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_RequestForQuotationEnhanced
LEFT OUTER JOIN C_Arberp_Qteqout_Rfq_Item AS _Item ON RequestForQuotation = _Item.RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN C_Arberp_Address AS _CompanyCodeAddress ON _CompanyCodeAddress.AddressID = CompanyCodeAddressID  -- association [0..1]
LEFT OUTER JOIN C_Arberp_Qteqout_Bidder AS _Bidder ON RequestForQuotation = _Bidder.RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN P_RFQDocumentType AS _DocumentType ON PurchasingDocumentType = _DocumentType.PurchasingDocumentType AND PurchasingDocumentCategory = _DocumentType.PurchasingDocumentCategory  -- association [1..1]
;