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,
  RequestedServiceStartDateTime,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesOfficeOrgUnitID,
  SalesGroup,
  SalesGroupOrgUnitID,
  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,
  ServiceDocNetAmount,
  SrvcDocGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus,
  SrvcDocGTSLglControlStatus
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 A_BusSolnQtanQualification AS _Qualification ON BusinessSolutionQuotation = _Qualification.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND BusinessSolutionQuotation = _Extension.ServiceOrder  -- association [0..1]
;