A_BusSolnQtanSalesItem

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_BusSolnQtanSalesItem.
-- 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_BusSolnQtanSalesItem 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,
  _LegalCntrctItmExtReference.LegalContractItemExtReference AS LegalContractItemExtReference,
  ItemOrderProbabilityInPercent,
  ServiceDocumentItemIsReleased AS BusSolnQtanItemIsReleased,
  QuotationIsAccepted AS BusSolnQtanItemIsAccepted,
  ServiceDocumentItemIsRejected AS BusSolnQtanItemIsRejected,
  ServiceDocItemRejectionReason AS BusSolnQtanItmRjcnReason,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  PaymentTerms,
  IncotermsPart1,
  IncotermsPart2,
  DeliveryPriority,
  PartialDeliveryIsAllowed,
  OrderCombinationIsAllowed,
  ContractAccount,
  ConfigurationNumber,
  BillingBlockReason,
  BillOfMaterialItemNodeNumber,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  MaterialSubstitutionReason
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_BusSolnQtanItmPriceElement AS _PriceElement ON BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation AND BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemText AS _Text ON BusinessSolutionQuotation = _Text.BusinessSolutionQuotation AND BusSolutionQuotationItem = _Text.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItmFUPSalesOrder AS _SalesOrder ON BusinessSolutionQuotation = _SalesOrder.BusinessSolutionQuotation AND BusSolutionQuotationItem = _SalesOrder.BusSolutionQuotationItem  -- 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 A_BusSolnQtanItmConfign AS _Configurations ON ConfigurationNumber = _Configurations.VariantConfigurationInstance  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BusSolnQtanItmExtReference AS _LegalCntrctItmExtReference ON BusinessSolutionQuotation = _LegalCntrctItmExtReference.BusinessSolutionQuotation AND BusSolutionQuotationItem = _LegalCntrctItmExtReference.BusSolutionQuotationItem AND _LegalCntrctItmExtReference.LegalContractItemExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN A_BusSolnQtanItemScheduleLine AS _BusSolnQtanItmScheduleLine ON BusinessSolutionQuotation = _BusSolnQtanItmScheduleLine.BusinessSolutionQuotation AND BusSolutionQuotationItem = _BusSolnQtanItmScheduleLine.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItmVarCnfStrucNde AS _VarConfignStructureNode ON ConfigurationNumber = _VarConfignStructureNode.VarConfigurationRootInstance  -- association [0..*]
;