A_BusSolnQtanServiceItem

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_BusSolnQtanServiceItem.
-- 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_BusSolnQtanServiceItem AS
SELECT
  ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentItem AS BusSolutionQuotationItem,
  ServiceDocumentItemUUID AS BusSolnQuotationItemUUID,
  ServiceDocumentItemCharUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnQuotationItem,
  ServiceDocItemCategory AS BusSolnQtanItemCategory,
  OriginallyRequestedProduct AS Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  ServiceDocumentItemDescription AS BusSolnQtanItemDescription,
  Language,
  _ExternalReference.BusSolnQtanItemExtReference AS BusSolnQtanItemExtReference,
  ItemOrderProbabilityInPercent,
  ServiceDocumentItemIsReleased AS BusSolnQtanItemIsReleased,
  QuotationIsAccepted AS BusSolnQtanItemIsAccepted,
  ServiceDocumentItemIsRejected AS BusSolnQtanItemIsRejected,
  ServiceDocItemRejectionReason AS BusSolnQtanItmRjcnReason,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  PaymentTerms,
  ServiceTransactionChargeType,
  SrvcTransactionValuationType,
  _ReferenceServiceContract._ServiceDocItm.ServiceDocument AS ReferenceServiceContract,
  _ReferenceServiceContract._ServiceDocItm.ServiceDocumentItem AS ReferenceServiceContractItem,
  ServiceProfile,
  ResponseProfile,
  MasterWarranty,
  BillableControl,
  ContractAccount,
  BillingBlockReason,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime,
  ConfigurationNumber
FROM I_ServiceDocumentItemEnhcd AS BusSolnQtanServiceItem
LEFT OUTER JOIN A_BusSolnQtanItmPriceElement AS _PriceElement ON BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation AND BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanSrvcItmRefObj AS _ReferenceObject ON BusinessSolutionQuotation = _ReferenceObject.BusinessSolutionQuotation AND BusSolutionQuotationItem = _ReferenceObject.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemText AS _Text ON BusSolutionQuotationItem = _Text.BusSolutionQuotationItem AND BusinessSolutionQuotation = _Text.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusinessSolutionQuotation AS _BusinessSolutionQuotation ON BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation  -- association [1..1]
LEFT OUTER JOIN A_BusSolnQtanItmFUPSrvcOrder AS _ServiceOrder ON BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation AND BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_2 AS _ReferenceServiceContract ON ServiceDocumentItemCharUUID = _ReferenceServiceContract.ServiceDocumentItemCharUUID AND _ReferenceServiceContract.ServiceDocumentItemObjectType = 'BUS2000140'  -- association [1..1]
LEFT OUTER JOIN I_BusSolnQtanItmExtReference AS _ExternalReference ON BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation AND BusSolutionQuotationItem = _ExternalReference.BusSolutionQuotationItem AND _ExternalReference.BusSolnQtanItemExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND BusinessSolutionQuotation = _Extension.ServiceOrderItem AND BusSolutionQuotationItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN A_BusSolnQtanItmConfign AS _Configurations ON ConfigurationNumber = _Configurations.VariantConfigurationInstance  -- association [0..*]
;