A_BusinessSolutionOrder

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_BusinessSolutionOrder.
-- 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_BusinessSolutionOrder AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentUUID AS BusinessSolutionOrderUUID,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  Language,
  _ExternalReference.CustMgmtExtRefID AS BusSolnOrdExtReference,
  PaymentTerms,
  ServiceDocumentCreatedByUser AS CreatedByUser,
  ServiceDocCreationDateTime AS CreationDateTime,
  ServiceDocumentChangedByUser AS LastChangedByUser,
  ServiceDocChangedDateTime AS LastChangeDateTime,
  ServiceDocumentIsReleased AS BusSolnOrdIsReleased,
  ServiceDocumentHasError,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocNetAmount,
  TransactionCurrency,
  cast ( _CPQQuotation.CustMgmtPrdcssrTransactionKey as abap.char( 10 ) ) AS CPQQuotation,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN A_BusSolnOrderServiceItem AS _ServiceItem ON BusinessSolutionOrder = _ServiceItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrderExpenseItem AS _ExpenseItem ON BusinessSolutionOrder = _ExpenseItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdSrvcPrtItem AS _ServicePartItem ON BusinessSolutionOrder = _ServicePartItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrderSalesItem AS _SalesItem ON BusinessSolutionOrder = _SalesItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdSrvcContractItem AS _ServiceContractItem ON BusinessSolutionOrder = _ServiceContractItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdSubscrpnBillgItem AS _SubscriptionBillingItem ON BusinessSolutionOrder = _SubscriptionBillingItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdEntProjectItem AS _EnterpriseProjectItem ON BusinessSolutionOrder = _EnterpriseProjectItem.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusinessSolutionOrderText AS _Text ON BusinessSolutionOrder = _Text.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrderFUPSalesOrder AS _SalesOrder ON BusinessSolutionOrder = _SalesOrder.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdFUPServiceOrder AS _ServiceOrder ON BusinessSolutionOrder = _ServiceOrder.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdFUPServiceContract AS _ServiceContract ON BusinessSolutionOrder = _ServiceContract.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdFUPSubscrpn AS _SubscriptionBilling ON BusinessSolutionOrder = _SubscriptionBilling.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdFUPEntProject AS _EnterpriseProject ON BusinessSolutionOrder = _EnterpriseProject.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItemRelationships AS _ItemRelationships ON BusinessSolutionOrder = _ItemRelationships.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExternalReference ON _ExternalReference.CustMgmtObjectType = 'BUS2000172' AND BusinessSolutionOrder = _ExternalReference.CustMgmtDocument AND _ExternalReference.CustMgmtExtRefIDType = '0012'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000172' AND BusinessSolutionOrder = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdUserStatus AS _UserStatus ON BusinessSolutionOrder = _UserStatus.BusinessSolutionOrder  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _CPQQuotation ON BusinessSolutionOrderUUID = _CPQQuotation.ServiceDocumentUUID AND _CPQQuotation.ServiceDocPrdcssrBusObjType = 'CPQQUOTH'  -- association [0..1]
;