I_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 I_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: IMMRFQENHWD

CREATE VIEW I_RequestForQuotationEnhWD AS
SELECT
  Document.RequestForQuotation AS RequestForQuotation,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.Language AS Language,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.RFQPublishingDate AS RFQPublishingDate,
  Document.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  Document.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  Document.TargetAmount AS TargetAmount,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.RFQLifecycleStatus AS RFQLifecycleStatus,
  Document.RequestForQuotationName AS RequestForQuotationName,
  Document.QuotationEarliestSubmsnDate AS QuotationEarliestSubmsnDate,
  Document.LatestRegistrationDate AS LatestRegistrationDate,
  Document.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  Document.FollowOnDocumentType AS FollowOnDocumentType,
  Document.PurContrValidityStartDate AS PurContrValidityStartDate,
  Document.PurContrValidityEndDate AS PurContrValidityEndDate,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast( ' ' as boolean) AS PurchasingItemHasHierarchy,
  cast('' as vdm_scenarioisrelevantforhier ) AS ScenarioIsRelevantForHierarchy,
  Document._CompanyCode AS _CompanyCode,
  Document._DocumentCurrency AS _DocumentCurrency,
  Document._IncotermsClassification AS _IncotermsClassification,
  Document._IncotermsVersion AS _IncotermsVersion,
  Document._PaymentTerms AS _PaymentTerms,
  Document._PurchasingDocumentType AS _PurchasingDocumentType,
  Document._PurchasingGroup AS _PurchasingGroup,
  Document._PurchasingOrganization AS _PurchasingOrganization,
  Document._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  Document._Language AS _Language,
  Document._CreatedByUser AS _CreatedByUser,
  Document._RFQLifecycleStatus AS _RFQLifecycleStatus,
  Document._FollowOnDocumentType AS _FollowOnDocumentType,
  Document._FollowOnDocumentCategory AS _FollowOnDocumentCategory,
  Document._RFQType AS _RFQType
FROM I_RequestForQuotationEnhanced AS Document
LEFT OUTER JOIN I_RFQItemEnhWD AS _RFQItemEnhWD ON _RFQItemEnhWD.RequestForQuotation = RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_RFQBidderEnhWD AS _RFQBidderEnhWD ON _RFQBidderEnhWD.RequestForQuotation = RequestForQuotation  -- association [1..*]
LEFT OUTER JOIN I_SupplierQuotationEnh AS _SupplierQuotation ON _SupplierQuotation.RequestForQuotation = RequestForQuotation  -- association [0..*]
LEFT OUTER JOIN E_PurchasingDocument AS _RequestQtnExtension ON RequestForQuotation = _RequestQtnExtension .PurchasingDocument  -- association [1..1]
;