A_BusSolnQtanBundleItem

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_BusSolnQtanBundleItem.
-- 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_BusSolnQtanBundleItem AS
SELECT
  ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentItem AS BusSolutionQuotationItem,
  ServiceDocumentItemUUID AS BusSolnQuotationItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnQuotationItem,
  ServiceDocItemCategory AS BusSolnQtanItemCategory,
  cast(OriginallyRequestedProduct as abap.char(40)) 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,
  cast( ResponsibleEmployee as abap.char( 12 )) AS PersonResponsible,
  cast( ContactPerson as abap.numc( 10 )) AS ContactPerson,
  ConfigurationNumber,
  ContractAccount,
  BillingBlockReason,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime
FROM I_ServiceDocumentItemEnhcd AS BusSolnQtanBundleItem
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_BusSolnQtanItmConfign AS _Configurations ON ConfigurationNumber = _Configurations.VariantConfigurationInstance AND _Configurations.VarConfignInstceBusObjectType = 'CRM_OR_ITM'  -- association [0..*]
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]
;