C_Customer360ServiceQuotation

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_Customer360ServiceQuotation.
-- 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: CUST360SRVQTN

CREATE VIEW C_Customer360ServiceQuotation AS
SELECT
  ServiceQuotation.ServiceDocument AS ServiceQuotation,
  ServiceQuotation.ServiceDocumentType AS ServiceDocumentType,
  _ServiceQtanType[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceQuotation.ServiceObjectType AS ServiceObjectType,
  ServiceQuotation.ServiceDocumentDescription AS ServiceQuotationDescription,
  ServiceQuotation.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceQuotation.ServiceDocumentIsQuotation AS ServiceDocumentIsQuotation,
  ServiceQuotation.SoldToParty AS SoldToParty,
  ServiceQuotation.ContactPerson AS ContactPersonBusinessPartnerId,
  ServiceQuotation._ContactPerson.BusinessPartnerName AS ContactPersonFullName,
  ServiceQuotation.ShipToParty AS ShipToParty,
  ServiceQuotation._ShipToParty.BusinessPartnerName AS UICT_ShipToParty,
  ServiceQuotation.PostingDate AS PostingDate,
  ServiceQuotation.RequestedServiceStartDate AS RequestedServiceStartDate,
  ServiceQuotation.RequestedServiceEndDate AS RequestedServiceEndDate,
  ServiceQuotation.ServiceDocCreationDateTime AS ServiceDocCreationDateTime,
  ServiceQuotation.SrvcQuotationValidityStartDate AS SrvcQuotationValidityStartDate,
  ServiceQuotation.SrvcQuotationValidityEndDate AS SrvcQuotationValidityEndDate,
  ServiceQuotation.ServiceDocGrossAmount AS SrvcQtanGrossAmount,
  ServiceQuotation.ServiceDocNetAmount AS SrvcQtanNetAmount,
  ServiceQuotation.ServiceDocTaxAmount AS SrvcQtanTaxAmount,
  ServiceQuotation.TransactionCurrency AS TransactionCurrency,
  ServiceQuotation._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  ServiceQuotation.ServiceDocumentStatus AS ServiceDocumentStatus,
  ServiceQuotation.ServiceDocumentIsRejected AS ServiceDocumentIsRejected,
  ServiceQuotation.ServiceDocumentRejectionReason AS ServiceDocumentRejectionReason,
  _SrvcDocRejectionReasonText[1:Language = $session.system_language].SalesDocumentRjcnReasonName AS SalesDocumentRjcnReasonName,
  cast('' as crms4_qtan_stat_lc_name) AS ServiceQuotationStatusName,
  ServiceQuotation.RespyMgmtServiceTeam AS RespyMgmtServiceTeam,
  ServiceQuotation._ServiceTeamHeader._TeamDescription.TeamDescription AS RespyMgmtServiceTeamDesc,
  ServiceQuotation._ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  ServiceQuotation.SalesOrganization AS SalesOrganization,
  ServiceQuotation._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  ServiceQuotation.DistributionChannel AS DistributionChannel,
  ServiceQuotation._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  ServiceQuotation.Division AS Division,
  ServiceQuotation._Division._Text[1:Language = $session.system_language].DivisionName AS DivisionName,
  ServiceQuotation.SalesOffice AS SalesOffice,
  ServiceQuotation._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  ServiceQuotation.SalesGroup AS SalesGroup,
  ServiceQuotation._SalesGroup._Text[1:Language = $session.system_language].SalesGroupName AS SalesGroupName,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000'].Equipment AS Equipment,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment.Material AS ReferenceProduct,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._FunctionalLocation._FunctionalLocationText[1: Language=$session.system_language].FunctionalLocationName AS FunctionalLocationName,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000'].ProductID AS ProductID,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  ServiceQuotation.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _RespEmployeeVH.FullName AS ResponsibleEmployeeName,
  ServiceQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _RefServiceOrder._ServiceDoc.ServiceDocument AS ServiceOrder,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  ServiceQuotation.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceQuotation.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceQuotation.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceQuotation.ServiceOrganization AS ServiceOrganization,
  ServiceQuotation.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  ServiceQuotation._SoldToParty AS _SoldToParty,
  ServiceQuotation._ContactPerson AS _ContactPerson,
  ServiceQuotation._ShipToParty AS _ShipToParty,
  ServiceQuotation._ServiceDocumentType AS _ServiceDocumentType,
  ServiceQuotation._ServiceDocumentStatus AS _ServiceDocumentStatus,
  ServiceQuotation._SrvcDocumentRejectionReason AS _SrvcDocumentRejectionReason,
  ServiceQuotation._ServiceDocRefObj AS _ServiceDocRefObj,
  ServiceQuotation._SalesOrganization AS _SalesOrganization,
  ServiceQuotation._SalesOffice AS _SalesOffice,
  ServiceQuotation._SalesGroup AS _SalesGroup,
  ServiceQuotation._Division AS _Division,
  ServiceQuotation._DistributionChannel AS _DistributionChannel,
  ServiceQuotation._TransactionCurrency AS _TransactionCurrency,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment AS _Equipment,
  ServiceQuotation._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment._Material AS _Material,
  ServiceQuotation._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  ServiceQuotation._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  ServiceQuotation._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  ServiceQuotation._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
  ServiceQuotation._RespSrvcOrganizationOrgUnit_2 AS _RespSrvcOrganizationOrgUnit_2,
  ServiceQuotation._ServiceObjType AS _ServiceObjType
FROM I_ServiceDocumentEnhcd AS ServiceQuotation
INNER JOIN I_Customer360BusDocSetting AS Customer360BusDocSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ServiceEmployeeVH AS _RespEmployeeVH ON RespEmployeeBusinessPartnerId = _RespEmployeeVH.Employee  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocObjPgNotes AS _ServiceDocumentNotes ON ServiceObjectType = _ServiceDocumentNotes.ServiceObjectType AND ServiceQuotation = _ServiceDocumentNotes.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocObjPgTransHistory AS _ServiceDocumentTransHistory ON ServiceObjectType = _ServiceDocumentTransHistory.ServiceObjectType AND ServiceQuotation = _ServiceDocumentTransHistory.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocObjPgErrorLog AS _ServiceDocumentErrorLog ON ServiceObjectType = _ServiceDocumentErrorLog.ServiceObjectType AND ServiceQuotation = _ServiceDocumentErrorLog.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceQuotation = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocumentPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceQuotation = _PartiesInvolved.CustMgmtDocument AND _PartiesInvolved.CustMgmtDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_SrvcOrderObjPgPricingDets AS _ServiceQtanPriceDets ON ServiceObjectType = _ServiceQtanPriceDets.ServiceObjectType AND ServiceQuotation = _ServiceQtanPriceDets.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceQuotation = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_ServiceQuotationStatus AS _ServiceQtanStatus ON ServiceQuotationStatus = _ServiceQtanStatus.ServiceQuotationStatus  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentSuccessor AS _RefServiceOrder ON ServiceDocumentUUID = _RefServiceOrder.ServiceDocumentUUID AND _RefServiceOrder.ServiceDocSuccessorBusObjType = 'BUS2000116'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceQtanType ON ServiceDocumentType = _ServiceQtanType.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReasonText AS _SrvcDocRejectionReasonText ON ServiceDocumentRejectionReason = _SrvcDocRejectionReasonText.SalesDocumentRjcnReason  -- association [0..*]
LEFT OUTER JOIN I_ServiceQuotationStatusText AS _ServiceQuotationStatusText ON ServiceQuotationStatus = _ServiceQuotationStatusText.ServiceQuotationStatus  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocDateInformation AS _SrvcDateInfo ON ( ServiceQuotation = _SrvcDateInfo.ServiceDocument AND ServiceObjectType = _SrvcDateInfo.ServiceObjectType AND _SrvcDateInfo.ServiceDocumentItem = '000000' ) OR ( ServiceDocumentUUID = _SrvcDateInfo.SrvcMgmtObjectUUID )  -- association [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 P_SrvcQuotation_DueDays AS _SrvcQuotationDueDays ON ServiceQuotation = _SrvcQuotationDueDays.ServiceQuotation  -- association [1..1]
;