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
  SrvcDocCreditStatus AS SrvcContrCreditStatus,
  SrvcDocGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus,
  SrvcDocGTSLglControlStatus,
  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,
  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,
  ServiceDocumentUUID,
  cast(bintohex( ServiceDocumentUUID ) as abap.sstring(32)) AS ServiceContractUUID,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ResponsibleEmployee,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  RefBusinessSolutionOrder,
  ServiceContract.ServiceDocument AS ServiceContract,
  ServiceContract.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
  ServiceContract.ServiceDocumentHasError AS ServiceContractHasError,
  ServiceContract.ServiceDocumentStatus AS ServiceContractStatus,
  ServiceContract.SoldToParty AS SoldToParty,
  ServiceContract.ShipToParty AS ShipToParty,
  ServiceContract.BillToParty AS BillToParty,
  ServiceContract.PayerParty AS PayerParty,
  ServiceContract.ServiceDocumentDescription AS ServiceContractDescription,
  ServiceContract.PostingDate AS PostingDate,
  ServiceContract.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceContract.ServiceDocNetAmount AS ServiceContractNetAmount,
  ServiceContract.ServiceContractCanclnSts AS ServiceContractCanclnSts,
  ServiceContract.TransactionCurrency AS TransactionCurrency,
  ServiceContract.ServiceDocGrossAmount AS ServiceContractGrossAmount,
  ServiceContract.ServiceObjectType AS ServiceObjectType,
  ServiceContract.ServiceDocumentType AS ServiceDocumentType,
  ServiceContract.ServiceDocBillingStatus AS ServiceDocBillingStatus,
  _ResponsibleEmployeeQuickView.BusinessPartnerName AS ResponsibleEmployeeName,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  _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,
  _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]
;