C_QuotationWl_F1852

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_QuotationWl_F1852.
-- 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: CQUOTWLF1852

CREATE VIEW C_QuotationWl_F1852 AS
SELECT
  SalesQuotation.SalesQuotation AS SalesQuotation,
  SalesQuotation._SoldToParty.CustomerName AS SoldToPartyFullName,
  SalesQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesQuotation.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SalesQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SalesQuotation.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesQuotation.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesQuotation.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesQuotation.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesQuotation.TransactionCurrency AS TransactionCurrency,
  SalesQuotation._TransactionCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  SalesQuotation.TotalNetAmount AS TotalNetAmount,
  SalesQuotation.SalesQuotationDate AS SalesQuotationDate,
  SalesQuotation.SalesQuotationType AS SalesQuotationType,
  _SalesDocumentType.SalesDocumentTypeName AS SalesQuotationTypeName,
  SalesQuotation.SalesOrganization AS SalesOrganization,
  SalesQuotation.DistributionChannel AS DistributionChannel,
  SalesQuotation.OrganizationDivision AS OrganizationDivision,
  SalesQuotation.SalesOffice AS SalesOffice,
  SalesQuotation.SalesGroup AS SalesGroup,
  SalesQuotation.CreationDate AS CreationDate,
  SalesQuotation.LastChangeDate AS LastChangeDate,
  SalesQuotation.CreatedByUser AS CreatedByUser,
  SalesQuotation.LastChangedByUser AS LastChangedByUser,
  SalesQuotation.SDDocumentReason AS SDDocumentReason,
  cast( ' ' as abgru_va) AS SalesDocumentRjcnReason,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_SalesQuotation AS SalesQuotation
LEFT OUTER JOIN P_Quotationwl_Duedays AS _SalesQuotationDueDays ON SalesQuotation = _SalesQuotationDueDays.SalesQuotation  -- association [1..1]
LEFT OUTER JOIN C_Q2CCustomerQuickView AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON SalesOrganization = _DistributionChannel.SalesOrganization AND DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _Division ON SalesOrganization = _Division.SalesOrganization AND DistributionChannel = _Division.DistributionChannel AND OrganizationDivision = _Division.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOffice ON SalesOrganization = _SalesOffice.SalesOrganization AND DistributionChannel = _SalesOffice.DistributionChannel AND OrganizationDivision = _SalesOffice.OrganizationDivision AND SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroup ON SalesOffice = _SalesGroup.SalesOffice AND SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN C_SalesQuotationTypeValueHelp AS _SalesDocumentType ON SalesQuotationType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocAllowedRjcnRsn AS _SalesDocumentRjcnReason ON SalesOrganization = _SalesDocumentRjcnReason.SalesOrganization AND SalesQuotationType = _SalesDocumentRjcnReason.SalesDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocRjcnReason ON SalesDocumentRjcnReason = _SalesDocRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_Quotation_SubsequentDocType AS _SubsequentDocType ON SalesQuotationType = _SubsequentDocType.SourceSalesDocumentType  -- association [0..*]
LEFT OUTER JOIN C_SalesDocumentItemWl AS _SalesDocumentItemWl ON SalesQuotation = _SalesDocumentItemWl.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesQuotation = _Extension.SalesDocument  -- association [1]
;