A_BusSolnOrdEntProjectItem

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_BusSolnOrdEntProjectItem.
-- 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_BusSolnOrdEntProjectItem AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocItemCategory AS BusSolnOrdItmCategory,
  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,
  ServiceDocumentItemNetAmount,
  TransactionCurrency,
  _ExternalReference.CustMgmtExtRefID AS BusSolnOrdItmExtReference,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnOrdItem,
  ServiceDocumentItemIsReleased AS BusSolnOrdItmIsReleased,
  SoldToParty,
  _ProjectManager.CustMgmtBusinessPartner AS ProjectManager,
  cast(ResponsibleEmployee as abap.char( 12 ) ) AS PersonResponsible,
  tstmp_to_dats( _EnterpriseProjectDates[1:SrvcDocAppointmentType = 'PROJSTART'].SrvcDocApptStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as ProjectStartDate AS clientNULLasProjectStartDate,
  tstmp_to_dats( _EnterpriseProjectDates[1:SrvcDocAppointmentType = 'PROJEND'].SrvcDocApptStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client,'NULL' ) as ProjectEndDate AS clientNULLasProjectEndDate,
  ResponsibleCostCenter,
  ProfitCenter,
  EnterpriseProjectServiceOrg,
  ServiceDocumentItemCharUUID,
  case _ProjectLinkage.ServiceDocumentItmRelationType when 'SOL1' then _EnterpriseProject.Project else '' end as LinkedProject AS ProjectelseendasLinkedProject
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_BusinessSolutionOrder AS _BusinessSolutionOrder ON BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder  -- association [1..1]
LEFT OUTER JOIN A_BusSolnOrdItmFUPEntProject AS _EnterpriseProject ON BusinessSolutionOrder = _EnterpriseProject.BusinessSolutionOrder AND BusinessSolutionOrderItem = _EnterpriseProject.BusinessSolutionOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocAppointment AS _EnterpriseProjectDates ON BusinessSolutionOrderItemUUID = _EnterpriseProjectDates.SrvcMgmtObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtPartner AS _ProjectManager ON BusinessSolutionOrder = _ProjectManager.CustMgmtDocument AND BusinessSolutionOrderItem = _ProjectManager.CustMgmtDocumentItem AND _ProjectManager.CustMgmtPartFunctionCategory = '0093' AND _ProjectManager.CustMgmtObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN A_BusSolutionOrderItemText AS _Text ON BusinessSolutionOrder = _Text.BusinessSolutionOrder AND BusinessSolutionOrderItem = _Text.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 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 I_ServiceDocumentItemSuccssr_3 AS _ProjectLinkage ON _ProjectLinkage.ServiceDocumentItmRelationType = 'SOL1' AND _ProjectLinkage.ServiceDocItmSuccssrBusObjType = 'CPMPROJI' AND ServiceDocumentItemCharUUID = _ProjectLinkage.ServiceDocumentItemCharUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
;