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

CREATE VIEW I_SuplrQuotationEnhWD AS
SELECT
  Document.SupplierQuotation AS SupplierQuotation,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  Document.Supplier AS Supplier,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.Language AS Language,
  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.PricingProcedure AS PricingProcedure,
  Document.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  cast( Document.ExchangeRate as wkurs preserving type ) AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.RequestForQuotation AS RequestForQuotation,
  Document.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.QuotationLatestSubmissionDate AS QuotationLatestSubmissionDate,
  Document.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  Document.QtnLifecycleStatus AS QtnLifecycleStatus,
  Document.FollowOnDocumentCategory AS FollowOnDocumentCategory,
  Document.FollowOnDocumentType AS FollowOnDocumentType,
  Document.PurContrValidityStartDate AS PurContrValidityStartDate,
  Document.PurContrValidityEndDate AS PurContrValidityEndDate,
  Document.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _SuplrQtnCalcFields.TotalNetAmount AS TotalNetAmount,
  cast( ' ' as boolean) AS PurchasingItemHasHierarchy,
  cast('' as vdm_scenarioisrelevantforhier ) AS ScenarioIsRelevantForHierarchy
FROM I_SupplierQuotationEnh AS Document
LEFT OUTER JOIN I_SuplrQuotationItemEnhWD AS _SuplrQuotationItemEnhWD ON _SuplrQuotationItemEnhWD.SupplierQuotation = SupplierQuotation  -- association [1..*]
LEFT OUTER JOIN I_RequestForQuotationEnhanced AS _RequestForQuotation ON _RequestForQuotation.RequestForQuotation = RequestForQuotation  -- association [0..1]
LEFT OUTER JOIN P_SuplrQtnCalcFields_TR AS _SuplrQtnCalcFields ON _SuplrQtnCalcFields.SupplierQuotation = SupplierQuotation  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _RequestForQuotationExtension ON SupplierQuotation = _RequestForQuotationExtension.PurchasingDocument  -- association [1..1]
;