C_RequestForQuotationEnhWD

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_RequestForQuotationEnhWD.
-- 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: CMMRFQENH

CREATE VIEW C_RequestForQuotationEnhWD AS
SELECT
  I_RequestForQuotationEnhWD.RequestForQuotation AS RequestForQuotation,
  I_RequestForQuotationEnhWD.CompanyCode AS CompanyCode,
  I_RequestForQuotationEnhWD.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_RequestForQuotationEnhWD.PurchasingItemHasHierarchy AS PurchasingItemHasHierarchy,
  I_RequestForQuotationEnhWD.ScenarioIsRelevantForHierarchy AS ScenarioIsRelevantForHierarchy,
  I_RequestForQuotationEnhWD.PurchasingDocumentType AS PurchasingDocumentType,
  I_RequestForQuotationEnhWD.CreationDate AS CreationDate,
  I_RequestForQuotationEnhWD.LastChangeDateTime AS LastChangeDateTime,
  I_RequestForQuotationEnhWD.CreatedByUser AS CreatedByUser,
  cast( _CreatedByUser.UserDescription as vdm_created_by preserving type ) AS FullName,
  I_RequestForQuotationEnhWD.Language AS Language,
  I_RequestForQuotationEnhWD.DocumentCurrency AS DocumentCurrency,
  I_RequestForQuotationEnhWD.PurchasingOrganization AS PurchasingOrganization,
  I_RequestForQuotationEnhWD.PurchasingGroup AS PurchasingGroup,
  I_RequestForQuotationEnhWD.IncotermsVersion AS IncotermsVersion,
  I_RequestForQuotationEnhWD.IncotermsClassification AS IncotermsClassification,
  I_RequestForQuotationEnhWD.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_RequestForQuotationEnhWD.IncotermsLocation1 AS IncotermsLocation1,
  I_RequestForQuotationEnhWD.IncotermsLocation2 AS IncotermsLocation2,
  I_RequestForQuotationEnhWD.PaymentTerms AS PaymentTerms,
  I_RequestForQuotationEnhWD.CashDiscount1Days AS CashDiscount1Days,
  I_RequestForQuotationEnhWD.CashDiscount2Days AS CashDiscount2Days,
  I_RequestForQuotationEnhWD.CashDiscount1Percent AS CashDiscount1Percent,
  I_RequestForQuotationEnhWD.CashDiscount2Percent AS CashDiscount2Percent,
  I_RequestForQuotationEnhWD.NetPaymentDays AS NetPaymentDays,
  I_RequestForQuotationEnhWD.RFQPublishingDate AS RFQPublishingDate,
  I_RequestForQuotationEnhWD.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_RequestForQuotationEnhWD.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_RequestForQuotationEnhWD.TargetAmount AS TargetAmount,
  I_RequestForQuotationEnhWD.CorrespncInternalReference AS CorrespncInternalReference,
  I_RequestForQuotationEnhWD.RFQLifecycleStatus AS RFQLifecycleStatus,
  I_RequestForQuotationEnhWD.RequestForQuotationName AS RequestForQuotationName,
  I_RequestForQuotationEnhWD.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  I_RequestForQuotationEnhWD.LatestRegistrationDate AS LatestRegistrationDate,
  I_RequestForQuotationEnhWD.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_RequestForQuotationEnhWD.FollowOnDocumentType AS FollowOnDocumentType,
  I_RequestForQuotationEnhWD.PurContrValidityStartDate AS PurContrValidityStartDate,
  I_RequestForQuotationEnhWD.PurContrValidityEndDate AS PurContrValidityEndDate,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( '' as mm_approver_id ) AS ApproverUser,
  I_RequestForQuotationEnhWD.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast ('' as boolean) AS IsLglTransIntegEnabled,
  cast ('' as boolean) AS IsChangeDocumentsEnabled,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  _RFQCustomizing.RFQAwardingType AS RFQAwardingType,
  _RFQCustomizing.RFQExternalProcessingType AS RFQExternalProcessingType,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  I_RequestForQuotationEnhWD._CompanyCode AS _CompanyCode,
  I_RequestForQuotationEnhWD._DocumentCurrency AS _DocumentCurrency,
  I_RequestForQuotationEnhWD._IncotermsClassification AS _IncotermsClassification,
  I_RequestForQuotationEnhWD._IncotermsVersion AS _IncotermsVersion,
  I_RequestForQuotationEnhWD._PaymentTerms AS _PaymentTerms,
  I_RequestForQuotationEnhWD._Language AS _Language,
  I_RequestForQuotationEnhWD._PurchasingDocumentType AS _PurchasingDocumentType,
  I_RequestForQuotationEnhWD._PurchasingGroup AS _PurchasingGroup,
  I_RequestForQuotationEnhWD._PurchasingOrganization AS _PurchasingOrganization,
  I_RequestForQuotationEnhWD._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_RequestForQuotationEnhWD._FollowOnDocumentType AS _FollowOnDocumentType,
  I_RequestForQuotationEnhWD._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  I_RequestForQuotationEnhWD._RFQLifecycleStatus AS _RFQLifecycleStatus
FROM I_RequestForQuotationEnhWD
LEFT OUTER JOIN C_RFQItemEnhWD AS _RFQItemEnhWD ON RequestForQuotation = _RFQItemEnhWD.RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN C_RFQBidderEnhWD AS _RFQBidderEnhWD ON RequestForQuotation = _RFQBidderEnhWD.RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN C_SupplierQuotationFacet AS _SupplierQuotation ON RequestForQuotation = _SupplierQuotation.RequestForQuotation AND RequestForQuotation <> ''  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = RequestForQuotation AND _LegalTransaction.LglCntntMIntegrationLink = 'RFQ'  -- association [0..*]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_PaymentTermValueHelp AS _PaymentTermsValueHelp ON _PaymentTermsValueHelp.PaymentTerms = PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsValueHelp ON _IncotermsValueHelp.IncotermsClassification = IncotermsClassification AND _IncotermsValueHelp.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_IncotermsVersionText AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion  -- association [0..*]
LEFT OUTER JOIN C_RFQTypeValueHelp AS _RFQTypeValueHelp ON _RFQTypeValueHelp.RFQType = PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_QTNFollowOnDocumentVH AS _FollowOnDocVH ON _FollowOnDocVH.SupplierQuotationType = PurchasingDocumentType AND _FollowOnDocVH.FollowOnDocumentType = FollowOnDocumentType AND _FollowOnDocVH.FollowOnDocumentCategory = FollowOnDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ContactCard ON _ContactCard.ContactCardType = 'User' AND _ContactCard.ContactCardID = CreatedByUser AND _ContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN P_RFQCustomizing AS _RFQCustomizing ON PurchasingDocumentType = _RFQCustomizing.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN C_RFQChangeDocumentItem AS _RFQChangeDocumentItem ON RequestForQuotation = _RFQChangeDocumentItem.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_RFQItemHierarchyTP AS _RFQItemHierarchyTP ON RequestForQuotation = _RFQItemHierarchyTP.RequestForQuotation  -- association [1..*]
;