A_BusinessSolutionQuotation

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 A_BusinessSolutionQuotation.
-- 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 A_BusinessSolutionQuotation AS
SELECT
  ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentUUID AS BusSolutionQuotationUUID,
  ServiceDocumentType AS BusSolutionQuotationType,
  ServiceDocumentDescription AS BusSolnQtanDescription,
  Language,
  _ExternalReference.BusSolnQtanExtReference AS BusSolnQtanExtReference,
  _BSPExternalReference.BusSolnPrtfloReference AS BusSolnPrtfloReference,
  _LegalCntrctExternalReference.LegalContractExtReference AS LegalContractExtReference,
  ServiceDocumentIsReleased AS BusSolnQuotationIsReleased,
  ServiceDocumentIsRejected AS BusSolnQuotationIsRejected,
  ServiceDocumentHasError,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  cast ( SrvcQtanValidityStartDateTime as crms4_cont_start_dec15 preserving type ) AS BusSolnQtanValdtyStartDateTime,
  cast ( SrvcQtanValidityEndDateTime as crms4_cont_end_dec15 preserving type ) AS BusSolnQtanValdtyEndDateTime,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ResponsibleServiceOrganization AS ServiceOrganizationUnit,
  ServiceOrganization,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  TransactionCurrency,
  PaymentTerms,
  ServiceDocumentCreatedByUser AS CreatedByUser,
  ServiceDocCreationDateTime AS CreationDateTime,
  ServiceDocumentChangedByUser AS LastChangedByUser,
  ServiceDocChangedDateTime AS LastChangeDateTime,
  CustomerPriceGroup,
  BillingBlockReason
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN A_BusSolnQtanServiceItem AS _ServiceItem ON BusinessSolutionQuotation = _ServiceItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanExpenseItem AS _ExpenseItem ON BusinessSolutionQuotation = _ExpenseItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanSrvcPrtItem AS _ServicePartItem ON BusinessSolutionQuotation = _ServicePartItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanSalesItem AS _SalesItem ON BusinessSolutionQuotation = _SalesItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanSubscrpnItem AS _SubscriptionItem ON BusinessSolutionQuotation = _SubscriptionItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanSrvcContrItem AS _ServiceContractItem ON BusinessSolutionQuotation = _ServiceContractItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanBundleItem AS _BundleItem ON BusinessSolutionQuotation = _BundleItem.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanFUPSalesOrder AS _SalesOrder ON BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanFUPSrvcOrder AS _ServiceOrder ON BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanFUPSrvcContr AS _ServiceContract ON BusinessSolutionQuotation = _ServiceContract.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanFUPSubscrpnContr AS _SubscriptionContract ON BusinessSolutionQuotation = _SubscriptionContract.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolutionQuotationText AS _Text ON BusinessSolutionQuotation = _Text.BusinessSolutionQuotation  -- association [0..*]
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 _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND BusinessSolutionQuotation = _Extension.ServiceOrder  -- association [0..1]
;