A_BusSolnOrderServiceItem

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_BusSolnOrderServiceItem.
-- 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_BusSolnOrderServiceItem AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentItemCharUUID,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocItemCategory AS BusSolnOrdItmCategory,
  OriginallyRequestedProduct AS Product,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnOrdItem,
  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,
  PlannedServiceStartDateTime,
  PlannedServiceEndDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceProfile,
  ResponseProfile,
  BillableControl,
  ServiceDuration,
  ServiceDurationUnit,
  ProfitCenter,
  ServiceDocumentItemNetAmount,
  TransactionCurrency,
  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,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  ConfigurationNumber,
  _ServicePerformer.CustMgmtBusinessPartner AS ServicePerformer,
  _RefServiceContract._ServiceDocItm.ServiceDocument AS ReferenceServiceContract,
  _RefServiceContract._ServiceDocItm.ServiceDocumentItem AS ReferenceServiceContractItem,
  _ServiceContractDetn.StatusIsActive AS SrvcContrDetnIsSpprsd
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 BusinessSolutionOrderItem = _Text.BusinessSolutionOrderItem AND BusinessSolutionOrder = _Text.BusinessSolutionOrder  -- 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 A_BusSolnOrdItmReferenceObject AS _ReferenceObject ON BusinessSolutionOrder = _ReferenceObject.BusinessSolutionOrder AND BusinessSolutionOrderItem = _ReferenceObject.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_2 AS _RefServiceContract ON ServiceDocumentItemCharUUID = _RefServiceContract.ServiceDocumentItemCharUUID AND _RefServiceContract.ServiceDocumentItemObjectType = 'BUS2000140'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _ServiceContractDetn ON BusinessSolutionOrderItemUUID = _ServiceContractDetn.StatusObjectUUID AND _ServiceContractDetn.StatusCode = 'I0994'  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmFUPServiceOrder AS _ServiceOrder ON BusinessSolutionOrder = _ServiceOrder.BusinessSolutionOrder AND BusinessSolutionOrderItem = _ServiceOrder.BusinessSolutionOrderItem  -- association [0..*]
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 I_CustMgmtPartner AS _ServicePerformer ON CustMgmtPartnerFunction = '00000028' AND CustMgmtPartFunctionCategory = '0091' AND BusinessSolutionOrder = _ServicePerformer.CustMgmtDocument AND BusinessSolutionOrderItem = _ServicePerformer.CustMgmtDocumentItem  -- association [0..1]
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_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
;