C_BusSolnOrdPlndDteSitn2

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_BusSolnOrdPlndDteSitn2.
-- 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: CSRVCPLNDTERCHD2

CREATE VIEW C_BusSolnOrdPlndDteSitn2 AS
SELECT
  ltrim( ServiceDocumentItem.BusinessSolutionOrder, '0' ) AS BusinessSolutionOrder,
  cast( ltrim(ServiceDocumentItem.BusinessSolutionOrderItem, '0' ) as abap.numc(6)) AS BusinessSolutionOrderItem,
  ServiceDocumentItem.ServiceObjectType AS ServiceObjectType,
  BusSolnOrdRelatedItem,
  ServiceDocumentItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  ServiceDocumentItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  cast(ltrim(FollowUpDocumentItem.ServiceDocument, '0') as abap.char(10)) AS SuccessorReferenceDocument,
  RelatedItem.ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  division( tstmp_seconds_between(tstmp_current_utctimestamp(), ServiceDocumentItem.PlannedServiceStartDateTime, 'NULL' ), 86400, 0) AS NrOfDaysBeforeRequestedEndDate,
  ServiceDocumentItem.SalesOrganization AS SalesOrganization,
  ServiceDocumentItem.DistributionChannel AS DistributionChannel,
  ServiceDocumentItem.Division AS Division,
  ServiceDocumentItem.SalesOffice AS SalesOffice,
  ServiceDocumentItem.SalesGroup AS SalesGroup,
  ServiceDocumentItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentItem.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocumentItem.ResponsibleEmployee AS ResponsibleEmployee,
  ServiceDocumentItem.ServiceEmployee AS ServiceEmployee,
  ServiceDocumentItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocumentItem. _SrvcDocItmLifecycleStatus AS _SrvcDocItmLifecycleStatus,
  ServiceDocumentItem._SalesOrganization AS _SalesOrganization,
  ServiceDocumentItem._DistributionChannel AS _DistributionChannel,
  ServiceDocumentItem._Division AS _Division,
  ServiceDocumentItem._SalesOffice AS _SalesOffice,
  ServiceDocumentItem._SalesGroup AS _SalesGroup,
  ServiceDocumentItem._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  ServiceDocumentItem._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  ServiceDocumentItem._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  ServiceDocumentItem._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  ServiceDocumentItem._ServiceDocumentType AS _ServiceDocumentType,
  ServiceDocumentItem._RespEmployee AS _RespEmployee
FROM I_BusSolnOrdItemRelationships AS ServiceDocumentItem
INNER JOIN I_ServiceDocumentItemSuccssr_2 AS ServiceDocItemSuccessor ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemEnhcd AS FollowUpDocumentItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS RelatedItem ON ServiceDocumentItem.BusinessSolutionOrder = RelatedItem.ServiceDocument AND ServiceDocumentItem.BusSolnOrdRelatedItem = RelatedItem.ServiceDocumentItem AND RelatedItem.ServiceObjectType = 'BUS2000172'  -- association [0..1]
;