A_BusSolnOrderSalesItem

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_BusSolnOrderSalesItem.
-- 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_BusSolnOrderSalesItem AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentItemCharUUID,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocItemCategory AS BusSolnOrdItmCategory,
  OriginallyRequestedProduct AS Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  cast(_QuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) AS BusSolnOrdItmQtyUnitSAPCode,
  cast(_QuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) AS BusSolnOrdItmQtyUnitISOCode,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  Language,
  _ExternalReference.CustMgmtExtRefID AS BusSolnOrdItmExtReference,
  ItemOrderProbabilityInPercent,
  PaymentTerms,
  IncotermsPart1,
  IncotermsPart2,
  Plant,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnOrdItem,
  ServiceDocumentItemIsReleased AS BusSolnOrdItmIsReleased,
  ServiceDocumentItemIsRejected AS BusSolnOrdItmIsRejected,
  cast( '' as abap.char( 1 ) ) AS BusSolnOrdItmDistrStatus,
  cast( '' as abap.char( 60 ) ) AS BusSolnOrdItmDistrStatusName,
  ServiceDocItemRejectionReason AS BusSolnOrdItmRjcnReason,
  _RejectionReasonText.SalesDocumentRjcnReasonName AS BusSolnOrdItmRjcnReasonText,
  SrvcDocItmDeliveryStatus,
  _DeliveryStatusText.SrvcDocDeliveryStatusText AS SrvcDocDeliveryStatusText,
  ServiceDocItemBillingStatus,
  BillingBlockReason,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  DeliveryPriority,
  PartialDeliveryIsAllowed,
  OrderCombinationIsAllowed,
  DeliveryBlockReason,
  RequestedDeliveryUTCDateTime,
  ServiceDocumentItemNetAmount,
  TransactionCurrency,
  ProfitCenter,
  PurchaseOrderByCustomer,
  SrvcMaterialPricingGroup AS MaterialPricingGroup,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  DeliveryGroup,
  _CPQQuotationItem.ServiceDocumentItemPredecessor AS CPQQuotationItem,
  ConfigurationNumber
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_BusinessSolutionOrder AS _BusinessSolutionOrder ON BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder  -- association [1..1]
LEFT OUTER JOIN A_BusSolutionOrderItemText AS _Text ON BusinessSolutionOrder = _Text.BusinessSolutionOrder AND BusinessSolutionOrderItem = _Text.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrderItemScheduleLine AS _ScheduleLine ON BusinessSolutionOrder = _ScheduleLine.BusinessSolutionOrder AND BusinessSolutionOrderItem = _ScheduleLine.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrderItemPriceElement AS _PriceElement ON BusinessSolutionOrder = _PriceElement.BusinessSolutionOrder AND BusinessSolutionOrderItem = _PriceElement.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReasonText AS _RejectionReasonText ON BusSolnOrdItmRjcnReason = _RejectionReasonText.SalesDocumentRjcnReason AND Language = _RejectionReasonText.Language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocDeliveryStatusText AS _DeliveryStatusText ON Language = _DeliveryStatusText.Language AND SrvcDocItmDeliveryStatus = _DeliveryStatusText.SrvcDocItmDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExternalReference ON BusinessSolutionOrder = _ExternalReference.CustMgmtDocument AND _ExternalReference.CustMgmtObjectType = 'BUS2000172' AND BusinessSolutionOrderItem = _ExternalReference.CustMgmtDocumentItem AND _ExternalReference.CustMgmtExtRefIDType = '0013'  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmFUPSalesOrder AS _SalesOrder ON BusinessSolutionOrder = _SalesOrder.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SalesOrder.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000172' AND BusinessSolutionOrder = _Extension.ServiceOrderItem AND BusinessSolutionOrderItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmUserStatus AS _UserStatus ON BusinessSolutionOrder = _UserStatus.BusinessSolutionOrder AND BusinessSolutionOrderItem = _UserStatus.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItmConfiguration AS _Configurations ON ConfigurationNumber = _Configurations.VariantConfigurationInstance  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_3 AS _CPQQuotationItem ON ServiceDocumentItemCharUUID = _CPQQuotationItem.ServiceDocumentItemCharUUID AND _CPQQuotationItem.ServiceDocItmPrdcssrBusObjType = 'CPQQUOTI'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
;