C_SuplrQuotationEnhWD

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_SuplrQuotationEnhWD.
-- 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: CMMQTNENHWD

CREATE VIEW C_SuplrQuotationEnhWD AS
SELECT
  I_SuplrQuotationEnhWD.SupplierQuotation AS SupplierQuotation,
  I_SuplrQuotationEnhWD.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SuplrQuotationEnhWD.PurchasingDocumentType AS PurchasingDocumentType,
  I_SuplrQuotationEnhWD.RequestForQuotation AS RequestForQuotation,
  _RequestForQuotation.RFQType AS RFQType,
  _RequestForQuotation.RFQCategory AS RFQCategory,
  _RequestForQuotation.RFQAwardingType AS RFQAwardingType,
  _RequestForQuotation.RequestForQuotationName AS RequestForQuotationName,
  I_SuplrQuotationEnhWD.CompanyCode AS CompanyCode,
  I_SuplrQuotationEnhWD.PurchasingOrganization AS PurchasingOrganization,
  I_SuplrQuotationEnhWD.PurchasingGroup AS PurchasingGroup,
  I_SuplrQuotationEnhWD.Supplier AS Supplier,
  I_SuplrQuotationEnhWD.CreatedByUser AS CreatedByUser,
  _CreatedByUser.UserDescription AS FullName,
  I_SuplrQuotationEnhWD.QuotationSubmissionDate AS QuotationSubmissionDate,
  cast( I_SuplrQuotationEnhWD.TotalNetAmount as vdm_total_net_amount preserving type ) AS TotalNetAmount_H,
  cast( 0 as vdm_total_net_amount ) AS TotalNetAmount,
  I_SuplrQuotationEnhWD.CreationDate AS CreationDate,
  I_SuplrQuotationEnhWD.LastChangeDateTime AS LastChangeDateTime,
  I_SuplrQuotationEnhWD.Language AS Language,
  I_SuplrQuotationEnhWD.DocumentCurrency AS DocumentCurrency,
  I_SuplrQuotationEnhWD.IncotermsVersion AS IncotermsVersion,
  I_SuplrQuotationEnhWD.IncotermsClassification AS IncotermsClassification,
  I_SuplrQuotationEnhWD.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SuplrQuotationEnhWD.IncotermsLocation1 AS IncotermsLocation1,
  I_SuplrQuotationEnhWD.IncotermsLocation2 AS IncotermsLocation2,
  I_SuplrQuotationEnhWD.PaymentTerms AS PaymentTerms,
  I_SuplrQuotationEnhWD.CashDiscount1Days AS CashDiscount1Days,
  I_SuplrQuotationEnhWD.CashDiscount2Days AS CashDiscount2Days,
  I_SuplrQuotationEnhWD.CashDiscount1Percent AS CashDiscount1Percent,
  I_SuplrQuotationEnhWD.CashDiscount2Percent AS CashDiscount2Percent,
  I_SuplrQuotationEnhWD.NetPaymentDays AS NetPaymentDays,
  I_SuplrQuotationEnhWD.PricingProcedure AS PricingProcedure,
  I_SuplrQuotationEnhWD.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  I_SuplrQuotationEnhWD.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  I_SuplrQuotationEnhWD.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_SuplrQuotationEnhWD.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_SuplrQuotationEnhWD.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  I_SuplrQuotationEnhWD.QtnLifecycleStatus AS QtnLifecycleStatus,
  I_SuplrQuotationEnhWD.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  I_SuplrQuotationEnhWD.FollowOnDocumentType AS FollowOnDocumentType,
  I_SuplrQuotationEnhWD.PurContrValidityStartDate AS PurContrValidityStartDate,
  I_SuplrQuotationEnhWD.PurContrValidityEndDate AS PurContrValidityEndDate,
  I_SuplrQuotationEnhWD.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( '' as mm_approver_id ) AS ApproverUser,
  I_SuplrQuotationEnhWD.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast( '' as abap.sstring( 450 ) ) AS NoteTypeListText,
  cast ('' as boolean) AS IsChangeDocumentsEnabled,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  I_SuplrQuotationEnhWD._CatTextInCurrentLang AS _CatTextInCurrentLang,
  I_SuplrQuotationEnhWD._IncotermsClassification AS _IncotermsClassification,
  I_SuplrQuotationEnhWD._IncotermsVersion AS _IncotermsVersion,
  I_SuplrQuotationEnhWD._PurchasingGroup AS _PurchasingGroup,
  I_SuplrQuotationEnhWD._PurchasingOrganization AS _PurchasingOrganization,
  I_SuplrQuotationEnhWD._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  I_SuplrQuotationEnhWD._PurchasingDocumentType AS _PurchasingDocumentType,
  I_SuplrQuotationEnhWD._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  I_SuplrQuotationEnhWD._FollowOnDocumentType AS _FollowOnDocumentType,
  I_SuplrQuotationEnhWD._DocumentCurrency AS _DocumentCurrency,
  I_SuplrQuotationEnhWD._QtnLifecycleStatus AS _QtnLifecycleStatus,
  I_SuplrQuotationEnhWD._CreatedByUser AS _CreatedByUser,
  PurchasingItemHasHierarchy,
  I_SuplrQuotationEnhWD.ScenarioIsRelevantForHierarchy AS ScenarioIsRelevantForHierarchy
FROM I_SuplrQuotationEnhWD
LEFT OUTER JOIN C_SuplrQuotationItemEnhWD AS _SuplrQuotationItemEnhWD ON SupplierQuotation = _SuplrQuotationItemEnhWD.SupplierQuotation  -- association [1..*]
LEFT OUTER JOIN C_RequestForQuotationFacet AS _RequestForQuotation ON _RequestForQuotation.RequestForQuotation = RequestForQuotation  -- association [0..1]
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_SuplrQtnTypeValueHelp AS _SuplrQtnTypeValueHelp ON _SuplrQtnTypeValueHelp.SuplrQtnType = PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_RFQValueHelp AS _RFQValueHelp ON _RFQValueHelp.RequestForQuotation = RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN C_BidderValueHelp AS _BidderValueHelp ON _BidderValueHelp.Supplier = Supplier AND _BidderValueHelp.PurchasingOrganization = PurchasingOrganization  -- 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 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_SuplrQuotationChgDocItem AS _SuplrQuotationChgDocItem ON SupplierQuotation = _SuplrQuotationChgDocItem.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_SuplrQtnItemHierarchyTP AS _SuplrQtnItemHierarchyTP ON SupplierQuotation = _SuplrQtnItemHierarchyTP.SupplierQuotation  -- association [1..*]
;