A_BusSolnQtanExpenseItem

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_BusSolnQtanExpenseItem.
-- 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_BusSolnQtanExpenseItem AS
SELECT
  ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentItem AS BusSolutionQuotationItem,
  ServiceDocumentItemUUID AS BusSolnQuotationItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnQuotationItem,
  ServiceDocItemCategory AS BusSolnQtanItemCategory,
  OriginallyRequestedProduct AS Product,
  MaterialByCustomer,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS RequestedQuantitySAPUnit,
  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,
  BillingBlockReason,
  BillOfMaterialItemNodeNumber,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  PlannedServiceStartDateTime,
  PlannedServiceEndDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  MaterialSubstitutionReason,
  MasterWarranty,
  BillableControl,
  ContractAccount
FROM I_ServiceDocumentItemEnhcd
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_BusSolnQtanItmFUPSrvcOrder AS _ServiceOrder ON BusinessSolutionQuotation = _ServiceOrder.BusinessSolutionQuotation AND BusSolutionQuotationItem = _ServiceOrder.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusinessSolutionQuotation AS _BusinessSolutionQuotation ON BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation  -- 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]
;