C_QuotationFs

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_QuotationFs.
-- 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: CQUOTATIONFS

CREATE VIEW C_QuotationFs AS
SELECT
  SalesQuotation,
  concat_with_space(I_SalesQuotation._SalesQuotationType._Text[1: Language=$session.system_language ].SalesDocumentTypeName, ltrim(SalesQuotation, '0'), 1) AS SalesDocumentTypeName,
  I_SalesQuotation.SalesQuotationType AS SalesQuotationType,
  I_SalesQuotation.SoldToParty AS SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast ( _ShipToParty.Customer as kunwe ) AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  I_SalesQuotation.OverallSDProcessStatus AS OverallSDProcessStatus,
  I_SalesQuotation.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  I_SalesQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  I_SalesQuotation.SalesQuotationApprovalReason AS SalesQuotationApprovalReason,
  I_SalesQuotation.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  I_SalesQuotation.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  I_SalesQuotation.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  I_SalesQuotation.TransactionCurrency AS TransactionCurrency,
  TotalNetAmount,
  cast( concat_with_space( concat( concat( _SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName, concat_with_space(',',_DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName,1) ), ',' ), _OrganizationDivision._Text[1: Language=$session.system_language].DivisionName ,1) as txt_vtrber) as SalesAreaDesc AS DivisionName1astxt_vtrberasSalesAreaDesc,
  I_SalesQuotation.SalesOrganization AS SalesOrganization,
  I_SalesQuotation.DistributionChannel AS DistributionChannel,
  I_SalesQuotation.OrganizationDivision AS OrganizationDivision,
  cast( I_SalesQuotation._Partner[ PartnerFunction = 'ZM' ].Personnel as resp_empl preserving type ) AS ResponsibleEmployee,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  I_SalesQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  I_SalesQuotation.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser
FROM I_SalesQuotation
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON SalesQuotation = _SDDocumentPartnerCard.SDDocument AND _SDDocumentPartnerCard.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_SalesQuotationPartner AS _ShipToParty ON SalesQuotation = _ShipToParty.SalesQuotation AND _ShipToParty.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN C_QuotationitemFs AS _QuotationitemFs ON SalesQuotation = _QuotationitemFs.SalesQuotation  -- association [0..*]
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 E_SalesDocumentBasic AS _Extension ON SalesQuotation = _Extension.SalesDocument  -- association [1]
;