I_RfqBidder_Api01

DDL: I_RFQBIDDER_API01 SQL: IMMRFQBDDRAPI01 Type: view BASIC Package: VDM_MM_PUR_RFQ
5 Fields 1 Data Sources 1 Associations

Bidder in Request for Quotation

I_RfqBidder_Api01 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_RfqBidder_Api01 is a Basic CDS View that provides data about "Bidder in Request for Quotation" in SAP S/4HANA. It reads from 1 data source (I_RFQBidder) and exposes 5 fields with key fields RequestForQuotation, PartnerCounter, PartnerFunction. It has 1 association to related views. Part of development package VDM_MM_PUR_RFQ.

SAP Help Documentation

CategoryRequest for Quotation
StatusReleased
Purpose
This CDS view retrieves a list of the suppliers that have been invited to participate in the bidding process for the request for quotation. This CDS view provides the prerequisites for answering the following business question: Which bidders are invited to an RFQ?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: Purchasing organization Purchasing group Purchasing document type These restriction types are edited in the Maintain Business Roles app. Users who want to run reports using this CDS view must have the authorization to display the following data: Purchasing organization Purchasing group Purchasing document type The following authorization objects are required:

Structure
This view relates to the following SAP object types: RequestForQuotation SupplierQuotation Main parameters and filters of the CDS view The main filters are as follows: RequestForQuotation : allows you to filter by number of the RFQ. Supplier : allows you to filter by the ID of the bidder.

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-RFQ-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view retrieves a list of the suppliers that have been invited to participate in the bidding process for the request for quotation.</p> <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li> <p>Which bidders are invited to an RFQ?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_RFQBidder I_RFQBidder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Requestforquotation_Api01 _RequestForQuotation $projection.RequestForQuotation = _RequestForQuotation.RequestForQuotation

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMMRFQBDDRAPI01 view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bidder in Request for Quotation view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation I_RFQBidder RequestForQuotation Purchasing Document Number
KEY PartnerCounter I_RFQBidder PartnerCounter Partner counter
KEY PartnerFunction Partner Function
Supplier I_RFQBidder Supplier Account Number of Supplier
_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 I_RfqBidder_Api01.
-- 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: IMMRFQBDDRAPI01

CREATE VIEW I_RfqBidder_Api01 AS
SELECT
  I_RFQBidder.RequestForQuotation AS RequestForQuotation,
  I_RFQBidder.PartnerCounter AS PartnerCounter,
  cast( I_RFQBidder.PartnerFunction as parvw ) AS PartnerFunction,
  I_RFQBidder.Supplier AS Supplier
FROM I_RFQBidder
LEFT OUTER JOIN I_Requestforquotation_Api01 AS _RequestForQuotation ON RequestForQuotation = _RequestForQuotation.RequestForQuotation  -- association [1..1]
;

Learn More