I_RFQMailParamSecureBidding

DDL: I_RFQMAILPARAMSECUREBIDDING SQL: IMMRFQMAILSB Type: view BASIC Package: VDM_MM_PUR_RFQ
12 Fields 1 Data Sources

Parameters for RFQ Email Template for Secure Bidding

I_RFQMailParamSecureBidding is a Basic CDS View that provides data about "Parameters for RFQ Email Template for Secure Bidding" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotation) and exposes 12 fields with key field RequestForQuotation. Part of development package VDM_MM_PUR_RFQ.

Data Sources (1)

SourceAliasJoin Type
I_RequestForQuotation _RequestForQuotation from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMMRFQMAILSB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Parameters for RFQ Email Template for Secure Bidding view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation I_RequestForQuotation RequestForQuotation RFQ
PurchasingDocumentType I_RequestForQuotation PurchasingDocumentType RFQ Type
CompanyCode I_RequestForQuotation CompanyCode Receiver Company Code
CompanyCodeName
PurchasingOrganization I_RequestForQuotation PurchasingOrganization Purchasing Organization
PurchasingGroup I_RequestForQuotation PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked I_RequestForQuotation IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_PurchasingGroup I_RequestForQuotation _PurchasingGroup
_PurchasingOrganization I_RequestForQuotation _PurchasingOrganization
Supplier _RFQBlockChainToken Supplier Supplier
EmailAddress _RFQBlockChainToken EmailAddress E-Mail Address
AuthorizationToken _RFQBlockChainToken AuthorizationToken

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_RFQMailParamSecureBidding.
-- 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: IMMRFQMAILSB

CREATE VIEW I_RFQMailParamSecureBidding AS
SELECT
  _RequestForQuotation.RequestForQuotation AS RequestForQuotation,
  _RequestForQuotation.PurchasingDocumentType AS PurchasingDocumentType,
  _RequestForQuotation.CompanyCode AS CompanyCode,
  _RequestForQuotation._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _RequestForQuotation.PurchasingOrganization AS PurchasingOrganization,
  _RequestForQuotation.PurchasingGroup AS PurchasingGroup,
  _RequestForQuotation.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _RequestForQuotation._PurchasingGroup AS _PurchasingGroup,
  _RequestForQuotation._PurchasingOrganization AS _PurchasingOrganization,
  _RFQBlockChainToken.Supplier AS Supplier,
  _RFQBlockChainToken.EmailAddress AS EmailAddress,
  _RFQBlockChainToken.AuthorizationToken AS AuthorizationToken
FROM I_RequestForQuotation AS _RequestForQuotation
;

Learn More