C_SrvcQtanItemListRptAndObjPg

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_SrvcQtanItemListRptAndObjPg.
-- 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: CSRVCQTANITEM

CREATE VIEW C_SrvcQtanItemListRptAndObjPg AS
SELECT
  ServiceDocument,
  ServiceDocumentItem,
  ServiceObjectType,
  ServiceDocumentItemUUID,
  ServiceDocumentItemDescription,
  ServiceDocumentItemIsQuotation,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader._TeamDescription.TeamDescription AS RespyMgmtServiceTeamDesc,
  _ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  ServiceDocItemRejectionReason AS SrvcQtanItmRejectionReason,
  _SrvcDocItmRejectionReasonText[1:Language = $session.system_language].SalesDocumentRjcnReasonName AS SrvcQtanItmRejectionReasonText,
  OriginallyRequestedProduct,
  _ParentServiceDocItem.OriginallyRequestedProduct AS CustMgmtParentItemProduct,
  case _ParentServiceDocItem.ServiceDocumentItem when '000000' then cast( '' as abap.numc( 10 ) ) else cast( ltrim(_ParentServiceDocItem.ServiceDocumentItem,'0') as abap.numc(10) ) end as ParentServiceDocumentItem AS numc10endasParentServiceDocumentItem,
  _ParentServiceDocItem.ServiceDocumentItemDescription AS CustMgmtParentItemProductName,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  ServiceDocItemCategory,
  TimeSheetOvertimeCategory,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  TransactionCurrency,
  ServiceDocumentItemStatus,
  SrvcDocItemCreditStatus AS SrvcQtanItemCreditStatus,
  _ServiceDocItemMainRefObj.Equipment AS Equipment,
  _ServiceDocItemMainRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocItemMainRefObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _ServiceDocItemMainRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocItemMainRefObj._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  cast( 1 as abap.char( 10 ) ) AS ServiceOrder,
  cast( 1 as abap.int4 ) AS BusinessTransactionDocItem,
  _CustMgmtExtRefHeader.CustMgmtExtRefID AS ServiceQtanExtReference,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  cast( '' as abap.char( 1000 ) ) AS ServiceOrderNoteText,
  PaymentTerms,
  _PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  PostingDate
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN C_SrvcQtanListRptAndObjPg AS _SrvcQtanListRptAndObjPg ON ServiceDocument = _SrvcQtanListRptAndObjPg.ServiceQuotation AND ServiceDocumentType = _SrvcQtanListRptAndObjPg.ServiceDocumentType  -- association [1..1]
LEFT OUTER JOIN P_ServiceDocumentRefObject AS _ServiceDocItemMainRefObj ON ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType AND ServiceDocument = _ServiceDocItemMainRefObj.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocItemTransHistory AS _ServiceDocItemTransHistory ON ServiceObjectType = _ServiceDocItemTransHistory.ServiceObjectType AND ServiceDocument = _ServiceDocItemTransHistory.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemTransHistory.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SrvcOrderItmObjPgPricingDets AS _ServiceQtanItmPriceDets ON ServiceObjectType = _ServiceQtanItmPriceDets.ServiceObjectType AND ServiceDocument = _ServiceQtanItmPriceDets.ServiceDocument AND ServiceDocumentItem = _ServiceQtanItmPriceDets.ServiceDocumentItem  -- association [1..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocItemPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceDocument = _PartiesInvolved.CustMgmtDocument AND ServiceDocumentItem = _PartiesInvolved.CustMgmtDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRefHeader ON ServiceDocument = _CustMgmtExtRefHeader.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRefHeader.CustMgmtObjectType AND _CustMgmtExtRefHeader.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceDocument = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND ServiceDocumentItem = _CustMgmtExtRef.CustMgmtDocumentItem AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0010'  -- association [0..1]
LEFT OUTER JOIN I_ServiceQuotationStatus AS _ServiceQtanItemStatus ON SrvcQtanItemStatus = _ServiceQtanItemStatus.ServiceQuotationStatus  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceQtanType ON ServiceDocumentType = _ServiceQtanType.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN C_SrvcDocDateInformation AS _SrvcDateItemInfo ON ( ServiceDocument = _SrvcDateItemInfo.ServiceDocument AND ServiceObjectType = _SrvcDateItemInfo.ServiceObjectType AND ServiceDocumentItem = _SrvcDateItemInfo.ServiceDocumentItem ) OR ( ServiceDocumentItemUUID = _SrvcDateItemInfo.SrvcMgmtObjectUUID )  -- association [1..*]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcDocSystemStatus ON ServiceDocumentItemUUID = _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 I_SalesDocumentRjcnReasonText AS _SrvcDocItmRejectionReasonText ON SrvcQtanItmRejectionReason = _SrvcDocItmRejectionReasonText.SalesDocumentRjcnReason  -- association [0..*]
;