C_BusSolutionQuotationDEX

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_BusSolutionQuotationDEX.
-- 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.

CREATE VIEW C_BusSolutionQuotationDEX AS
SELECT
  SolutionQuotation.ServiceDocument AS BusinessSolutionQuotation,
  SolutionQuotation.ServiceObjectType AS ServiceObjectType,
  SolutionQuotation.ServiceDocumentUUID AS BusSolutionQuotationUUID,
  SolutionQuotation.ServiceDocumentType AS BusSolutionQuotationType,
  SolutionQuotation.ServiceDocumentDescription AS BusSolnQtanDescription,
  SolutionQuotation.Language AS Language,
  _ExternalReference.BusSolnQtanExtReference AS BusSolnQtanExtReference,
  _BSPExternalReference.BusSolnPrtfloReference AS BusSolnPrtfloReference,
  _LegalCntrctExternalReference.LegalContractExtReference AS LegalContractExtReference,
  SolutionQuotation.ServiceDocumentIsReleased AS BusSolnQuotationIsReleased,
  SolutionQuotation.ServiceDocumentStatus AS ServiceDocumentStatus,
  SolutionQuotation.ServiceDocumentIsRejected AS BusSolnQuotationIsRejected,
  SolutionQuotation.ServiceDocumentHasError AS ServiceDocumentHasError,
  SolutionQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SolutionQuotation.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SolutionQuotation.SrvcQtanValidityStartDateTime AS SrvcQtanValidityStartDateTime,
  cast ( SolutionQuotation.SrvcQtanValidityStartDateTime as crms4_cont_start_dec15 preserving type ) AS BusSolnQtanValdtyStartDateTime,
  cast ( SolutionQuotation.SrvcQtanValidityEndDateTime as crms4_cont_end_dec15 preserving type ) AS BusSolnQtanValdtyEndDateTime,
  SolutionQuotation.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  SolutionQuotation.SalesOrganization AS SalesOrganization,
  SolutionQuotation.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SolutionQuotation.DistributionChannel AS DistributionChannel,
  SolutionQuotation.Division AS Division,
  SolutionQuotation.SalesOffice AS SalesOffice,
  SolutionQuotation.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SolutionQuotation.SalesGroup AS SalesGroup,
  SolutionQuotation.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SolutionQuotation.ResponsibleServiceOrganization AS ServiceOrganizationUnit,
  SolutionQuotation.ServiceOrganization AS ServiceOrganization,
  SolutionQuotation.SoldToParty AS SoldToParty,
  SolutionQuotation.ShipToParty AS ShipToParty,
  SolutionQuotation.BillToParty AS BillToParty,
  SolutionQuotation.PayerParty AS PayerParty,
  SolutionQuotation.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  SolutionQuotation.ContactPerson AS ContactPersonBusinessPartnerId,
  SolutionQuotation.TransactionCurrency AS TransactionCurrency,
  SolutionQuotation.PaymentTerms AS PaymentTerms,
  SolutionQuotation.ServiceDocumentCreatedByUser AS CreatedByUser,
  SolutionQuotation.ServiceDocCreationDateTime AS CreationDateTime,
  SolutionQuotation.ServiceDocumentChangedByUser AS LastChangedByUser,
  SolutionQuotation.ServiceDocChangedDateTime AS LastChangeDateTime,
  SolutionQuotation.SrvcDocAcctAssgmtObjectType AS SrvcDocAcctAssgmtObjectType,
  SolutionQuotation.SrvcDocAcctAssgmtObject AS SrvcDocAcctAssgmtObject,
  SolutionQuotation.CustomerPriceGroup AS CustomerPriceGroup,
  SolutionQuotation.BillingBlockReason AS BillingBlockReason,
  SolutionQuotation.ServiceDocNetAmount AS ServiceDocNetAmount,
  SolutionQuotation.SrvcDocGTSEmbargoStatus AS SrvcDocGTSEmbargoStatus,
  SolutionQuotation.SrvcDocGTSScreeningStatus AS SrvcDocGTSScreeningStatus,
  SolutionQuotation.SrvcDocGTSLglControlStatus AS SrvcDocGTSLglControlStatus
FROM I_ServiceDocumentEnhcd AS SolutionQuotation
INNER JOIN I_BusSolutionQuotationType AS BusSolutionQuotationType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusSolnQtanExtReference AS _ExternalReference ON BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation AND _ExternalReference.BusSolnQtanExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN I_BusSolnQtanExtReference AS _BSPExternalReference ON BusinessSolutionQuotation = _BSPExternalReference.BusinessSolutionQuotation AND _BSPExternalReference.BusSolnPrtfloReference <> ''  -- association [0..1]
LEFT OUTER JOIN I_BusSolnQtanExtReference AS _LegalCntrctExternalReference ON BusinessSolutionQuotation = _LegalCntrctExternalReference.BusinessSolutionQuotation AND _LegalCntrctExternalReference.LegalContractExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND BusinessSolutionQuotation = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;