C_BusSolnOrdDelivDteSitn1

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 C_BusSolnOrdDelivDteSitn1.
-- 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.
-- SQL view name: CSOLODTECHGNSIT1

CREATE VIEW C_BusSolnOrdDelivDteSitn1 AS
SELECT
  ltrim( SalesItem.BusinessSolutionOrder, '0') AS BusinessSolutionOrder,
  SalesItem.BusinessSolutionOrderItem AS ServiceDocumentItem,
  SalesItem.BusSolnOrdRelatedItem AS BusSolnOrdRelatedItem,
  SalesItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  cast(ltrim(SalesItem.BusinessSolutionOrderItem, '0') as abap.char(45)) AS BusinessSolutionOrderItem,
  SalesItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  _RelatedItem.ServiceDocumentItemObjectType AS BusSolnOrdReltdItmObjectType,
  SalesItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  SalesItem.SrvcDocItmDeliveryStatus AS SrvcDocItmDeliveryStatus,
  case when SalesItem.ServiceDocumentItemObjectType = 'BUS2000131' then cast( ltrim(SalesOrderItem.SalesOrder, '0') as abap.char(10) ) else cast( '' as abap.char(10) ) end as SuccessorReferenceDocument AS char10endasSuccessorReferenceDocument,
  SalesItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  SalesItem._SrvcDocSystemStatus.SrvcMgmtObjectStatus AS SrvcMgmtObjectStatus,
  SalesItem.ServiceDocumentType AS ServiceDocumentType,
  SalesItem.ServiceObjectType AS ServiceObjectType,
  SalesItem.ResponsibleEmployee AS ResponsibleEmployee,
  _RelatedItem._ServiceDocument AS _ServiceDocument,
  _RelatedItem.ServiceObjectType AS BusSolnOrdType,
  _RelatedItem.ServiceDocument AS ServiceDocument,
  SalesItem.SalesOrganization AS SalesOrganization,
  SalesItem.DistributionChannel AS DistributionChannel,
  SalesItem.Division AS Division,
  SalesItem.SalesOffice AS SalesOffice,
  SalesItem.SalesGroup AS SalesGroup,
  SalesItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SalesItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SalesItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SalesItem.ServiceOrganization AS ServiceOrganization,
  SalesItem._SalesOrganization AS _SalesOrganization,
  SalesItem._DistributionChannel AS _DistributionChannel,
  SalesItem._Division AS _Division,
  SalesItem._SalesOffice AS _SalesOffice,
  SalesItem._SalesGroup AS _SalesGroup,
  SalesItem._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  SalesItem._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  SalesItem._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  SalesItem._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  SalesItem._ServiceDocumentType AS _ServiceDocumentType,
  SalesItem._RespEmployee AS _RespEmployee,
  SalesItem._ServiceObjType AS _ServiceObjType,
  SalesItem._SrvcDocSystemStatus AS _SrvcDocSystemStatus
FROM I_BusSolnOrdItemRelationships AS SalesItem
INNER JOIN I_SDDocumentProcessFlow AS SalesDocumentFlow ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesOrderItem AS SalesOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _RelatedItem ON SalesItem.BusinessSolutionOrder = _RelatedItem.ServiceDocument AND SalesItem.BusSolnOrdRelatedItem = _RelatedItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocAppointment AS _EntProjectStartDate ON SalesItem.ServiceDocumentItemUUID = _EntProjectStartDate.SrvcMgmtObjectUUID AND _EntProjectStartDate.SrvcDocAppointmentType = 'PROJSTART'  -- association [0..1]
;