I_RFQCompareTP

DDL: I_RFQCOMPARETP SQL: IRFQCOMPARETP Type: view TRANSACTIONAL Package: APPL_MM_PUR_QTN_COMPARE_SD
18 Fields 1 Data Sources 1 Associations

Request For Quotation for Comparison

I_RFQCompareTP is a Transactional CDS View that provides data about "Request For Quotation for Comparison" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotation) and exposes 18 fields with key field RequestForQuotation. It has 1 association to related views. Part of development package APPL_MM_PUR_QTN_COMPARE_SD.

Data Sources (1)

SourceAliasJoin Type
I_RequestForQuotation I_RequestForQuotation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SupplierQuotationCompareTP _SupplierQuotationCompare $projection.RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation

Annotations (18)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey RequestForQuotation view
ObjectModel.semanticKey RequestForQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence MMRFQCOMP_D view
EndUserText.label Request For Quotation for Comparison view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName IRFQCOMPARETP view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation RequestForQuotation RFQ
RequestForQuotationName RequestForQuotationName RFQ Description
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
RFQPublishingDate RFQPublishingDate Publishing Date
QuotationLatestSubmissionDate QuotationLatestSubmissionDate Quot. Deadline
RFQLifecycleStatus RFQLifecycleStatus Status
PurchasingDocument RequestForQuotation RFQ
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_SupplierQuotationCompare _SupplierQuotationCompare
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_RFQLifecycleStatus _RFQLifecycleStatus

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_RFQCompareTP.
-- 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: IRFQCOMPARETP

CREATE VIEW I_RFQCompareTP AS
SELECT
  RequestForQuotation,
  RequestForQuotationName,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  CreatedByUser,
  CreationDate,
  RFQPublishingDate,
  QuotationLatestSubmissionDate,
  RFQLifecycleStatus,
  RequestForQuotation AS PurchasingDocument,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked
FROM I_RequestForQuotation
LEFT OUTER JOIN I_SupplierQuotationCompareTP AS _SupplierQuotationCompare ON RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation  -- association [0..*]
;

Learn More