C_SrvcContrListRptAndObjPg

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_SrvcContrListRptAndObjPg.
-- 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: CSRVCCONTRLIST

CREATE VIEW C_SrvcContrListRptAndObjPg AS
SELECT
  ServiceContract.ServiceDocument AS ServiceContract,
  ServiceContract.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  ServiceContract.ServiceDocumentHasError AS ServiceContractHasError,
  ServiceContract.ServiceDocumentStatus AS ServiceContractStatus,
  SrvcDocCreditStatus AS SrvcContrCreditStatus,
  SrvcDocGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus,
  SrvcDocGTSLglControlStatus,
  ServiceContract.SoldToParty AS SoldToParty,
  ServiceContract.ShipToParty AS ShipToParty,
  ServiceContract.BillToParty AS BillToParty,
  ServiceContract.PayerParty AS PayerParty,
  _SoldToParty.BusinessPartnerName AS SoldToPartyName,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _SoldToParty.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  ServiceContract.ServiceDocumentDescription AS ServiceContractDescription,
  tstmp_to_dats( ServiceContractStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ServiceContractStartDate AS clientNULLasServiceContractStartDate,
  tstmp_to_dats( ServiceContractEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ServiceContractEndDate AS clientNULLasServiceContractEndDate,
  ServiceContract.PostingDate AS PostingDate,
  tstmp_to_dats( SrvcContrEarliestStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SrvcContrEarliestStartDate AS clientNULLasSrvcContrEarliestStartDate,
  tstmp_to_dats( SrvcContrLatestEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SrvcContrLatestEndDate AS clientNULLasSrvcContrLatestEndDate,
  ServiceContract.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceContract.ServiceDocNetAmount AS ServiceContractNetAmount,
  ServiceContract.ServiceContractCanclnSts AS ServiceContractCanclnSts,
  ServiceContract.TransactionCurrency AS TransactionCurrency,
  ServiceDocumentUUID,
  cast(bintohex( ServiceDocumentUUID ) as abap.sstring(32)) AS ServiceContractUUID,
  ServiceContract.ServiceDocGrossAmount AS ServiceContractGrossAmount,
  ServiceContract.ServiceObjectType AS ServiceObjectType,
  ServiceContract.ServiceDocumentType AS ServiceDocumentType,
  ServiceContract.ServiceDocBillingStatus AS ServiceDocBillingStatus,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ResponsibleEmployee,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _ResponsibleEmployeeQuickView.BusinessPartnerName AS ResponsibleEmployeeName,
  RefBusinessSolutionOrder,
  _SolutionOrderVH.BusSolnOrdDescription AS BusSolnOrdDescription,
  _SrvcDocSystemStatus.StatusCode AS SystemStatus
FROM I_ServiceDocumentEnhcd AS ServiceContract
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = ServiceDocumentCharUUID AND _SitnInstceIndicator.SitnDefAnchorObject = 'ServiceContractUUID'  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentSoldToPartyVH AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentShipToPartyVH AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentShipToPartyVH AS _BillToParty ON BillToParty = _BillToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentPayerVH AS _PayerParty ON PayerParty = _PayerParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ServiceContractTypeVH AS _ServiceContractTypeVH ON ServiceDocumentType = _ServiceContractTypeVH.ServiceContractType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocBillingStatusVH AS _SrvcDocBillingStatusVH ON ServiceDocBillingStatus = _SrvcDocBillingStatusVH.ServiceDocBillingStatus  -- association [0..1]
LEFT OUTER JOIN C_SrvcContrItmListRptAndObjPg AS _ServiceContractItem ON ServiceObjectType = _ServiceContractItem.ServiceObjectType AND ServiceContract = _ServiceContractItem.ServiceContract  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocObjPgTransHistory AS _ServiceDocumentTransHistory ON ServiceObjectType = _ServiceDocumentTransHistory.ServiceObjectType AND ServiceContract = _ServiceDocumentTransHistory.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocObjPgErrorLog AS _ServiceDocumentErrorLog ON ServiceObjectType = _ServiceDocumentErrorLog.ServiceObjectType AND ServiceContract = _ServiceDocumentErrorLog.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceContract = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentStatusText AS _ServiceDocumentStatusText ON ServiceContractStatus = _ServiceDocumentStatusText.ServiceDocumentStatus AND _ServiceDocumentStatusText.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_ServiceContractStdVH AS _ServiceContractVH ON ServiceContract = _ServiceContractVH.ServiceDocument AND ServiceObjectType = _ServiceContractVH.ServiceObjectType AND ServiceDocumentType = _ServiceContractVH.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BusinessSolutionOrderStdVH AS _SolutionOrderVH ON RefBusinessSolutionOrder = _SolutionOrderVH.BusinessSolutionOrder  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _CustMgmtLifecycleUserStsText ON ServiceContractStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _CustMgmtLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcDocSystemStatus ON ServiceDocumentUUID = _SrvcDocSystemStatus.StatusObjectUUID AND ( _SrvcDocSystemStatus.StatusCode = 'I1002' OR _SrvcDocSystemStatus.StatusCode = 'I1003' OR _SrvcDocSystemStatus.StatusCode = 'I1004' OR _SrvcDocSystemStatus.StatusCode = 'I1005' ) AND _SrvcDocSystemStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtRespEmplQuickVw AS _ResponsibleEmployeeQuickView ON RespEmployeeBusinessPartnerId = _ResponsibleEmployeeQuickView.BusinessPartner  -- association [0..1]
;