C_SrvOrderItemListRptAndObjPg

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_SrvOrderItemListRptAndObjPg.
-- 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: CSRVORDERITEM

CREATE VIEW C_SrvOrderItemListRptAndObjPg AS
SELECT
  ServiceDocument,
  ServiceDocumentItem,
  ServiceObjectType,
  ServiceDocumentItemUUID,
  _ServiceDocumentItem.OriginallyRequestedProduct AS CustMgmtParentItemProduct,
  _ServiceDocumentItem.ServiceDocumentItemDescription AS CustMgmtParentItemProductName,
  OriginallyRequestedProduct,
  ServiceDocItemQuantityUnit,
  ServiceDocumentItemDescription,
  ServiceDocItemCategory,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemQuantity,
  TransactionCurrency,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  cast(3 as abap.int4) AS UxFcActualServiceDuration,
  ServiceDocumentItemStatus,
  ServiceDocumentUUID,
  ServiceDocumentDescription,
  ServiceDocumentItemObjectType,
  ParentServiceDocumentItemUUID,
  PurchaseOrderByCustomer,
  ServiceDocumentItemPriority,
  ServiceDocumentType,
  PostingDate,
  SoldToPartyCountry,
  SoldToPartyRegion,
  ServiceTeam,
  SoldToParty,
  ServiceEmployee,
  _SelectProcurementStatus.SrvcDocItemProcmtStatus AS StatusCode,
  TimeSheetOvertimeCategory,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  cast(3 as abap.int4) AS UxFcTimeSheetOvertimeCategory,
  _ServiceDocItemMainRefObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _ServiceDocItemMainRefObj.Equipment AS Equipment,
  _ServiceDocItemMainRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocItemMainRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocItemMainRefObj._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  ResponsibleEmployee,
  ContactPerson,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceDocumentItemHasError,
  ServiceDocItemBillingStatus,
  SrvcDocItmIsReleasedForBilling,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  BillableControl,
  PaymentTerms,
  PayerParty,
  BillToParty,
  _ServiceDocItemNote.ServiceOrderNoteText AS ServiceOrderNoteText,
  cast( '' as crmt_boolean ) AS MaterialComponentIsSparePart,
  cast (PayerParty as char10) AS Customer,
  _SelectProcurementStatus.StatusProfile AS StatusProfile,
  ServiceDocItemRejectionReason,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM I_ServiceDocumentItemEnhcd
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 P_SelectProcurementStatus AS _SelectProcurementStatus ON ServiceDocumentItemUUID = _SelectProcurementStatus.StatusObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_StatusCode AS _StatusCode ON StatusCode = _StatusCode.StatusCode AND statusprofile = _StatusCode.StatusProfile  -- association [0..1]
LEFT OUTER JOIN C_SrvcOrderItmObjPgPricingDets AS _ServiceOrderItmPriceDets ON ServiceObjectType = _ServiceOrderItmPriceDets.ServiceObjectType AND ServiceDocument = _ServiceOrderItmPriceDets.ServiceDocument AND ServiceDocumentItem = _ServiceOrderItmPriceDets.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_SrvcBillableItemVH AS _ServiceDocItemAcctgInd ON BillableControl = _ServiceDocItemAcctgInd.BillableControl  -- 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_ServiceDocumentItem AS _ServiceDocumentItem ON ParentServiceDocumentItemUUID = _ServiceDocumentItem.ServiceDocumentItemUUID  -- 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 = '0002'  -- association [0..1]
;