A_ServiceConfirmationItem

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 A_ServiceConfirmationItem.
-- 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.

CREATE VIEW A_ServiceConfirmationItem AS
SELECT
  ServiceDocument AS ServiceConfirmation,
  ServiceDocumentItem AS ServiceConfirmationItem,
  ServiceDocumentItemUUID AS ServiceConfirmationItemUUID,
  ServiceDocumentItemDescription AS ServiceConfItemDescription,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  Language,
  OriginallyRequestedProduct AS Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  Batch,
  ValuationType,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServiceDocItemCategory AS ServiceConfItemCategory,
  ServiceEmployee AS ExecutingServiceEmployee,
  _ServicePerformer.CustMgmtPartner AS ServicePerformer,
  BillableControl,
  _RefServiceOrder.ReferenceServiceOrder AS ReferenceServiceOrder,
  _RefServiceOrder.ReferenceServiceOrderItem AS ReferenceServiceOrderItem,
  cast('' as crms4_is_unplanned_item preserving type) AS RefSrvcOrdItemIsUnplanned,
  _RefServiceContract.ReferenceServiceContract AS ReferenceServiceContract,
  _RefServiceContract.ReferenceServiceContractItem AS ReferenceServiceContractItem,
  ShippingCondition,
  RequestedDeliveryUTCDateTime AS ErlstRequestedDeliveryDateTime,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentServiceConfItem,
  ActualServiceStartDateTime,
  ActualServiceEndDateTime,
  ServicesRenderedDate,
  _CustMgmtExtRef.CustMgmtExtRefID AS FSMServiceConfirmationItem,
  SrvcDocItmPartReferenceItem,
  SrvcDocItmApptReferenceItem,
  SrvcDocItmApptRefObjectUUID,
  MaterialSubstitutionReason,
  TimeSheetOvertimeCategory,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ServiceTransactionChargeType,
  SrvcTransactionValuationType,
  ContractAccount
FROM I_ServiceDocumentItemEnhcd AS ServiceConfirmationItem
LEFT OUTER JOIN A_ServiceConfirmationItemText AS _Text ON ServiceConfirmation = _Text.ServiceConfirmation AND ServiceConfirmationItem = _Text.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN A_ServiceConfItmRefObject AS _ReferenceObject ON ServiceConfirmation = _ReferenceObject.ServiceConfirmation AND ServiceConfirmationItem = _ReferenceObject.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN A_ServiceConfItmRefSrvcOrd AS _RefServiceOrder ON ServiceConfirmationItemUUID = _RefServiceOrder.ServiceConfirmationItemUUID  -- association [1]
LEFT OUTER JOIN P_ServiceConfItmRefSrvcContr AS _RefServiceContract ON ServiceConfirmationItemUUID = _RefServiceContract.ServiceConfirmationItemUUID  -- association [0..1]
LEFT OUTER JOIN A_ServiceConfItemPriceElement AS _PricingElement ON ServiceConfirmation = _PricingElement.ServiceConfirmation AND ServiceConfirmationItem = _PricingElement.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN A_ServiceConfirmation AS _ServiceConfirmation ON ServiceConfirmation = _ServiceConfirmation.ServiceConfirmation  -- association [1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000117' AND ServiceConfirmation = _Extension.ServiceOrderItem AND ServiceConfirmationItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON _CustMgmtExtRef.CustMgmtObjectType = 'BUS2000117' AND ServiceConfirmation = _CustMgmtExtRef.CustMgmtDocument AND ServiceConfirmationItem = _CustMgmtExtRef.CustMgmtDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ServicePerformer ON CustMgmtPartnerFunction = '00000028' AND CustMgmtPartFunctionCategory = '0091' AND ServiceConfirmation = _ServicePerformer.CustMgmtDocument AND ServiceConfirmationItem = _ServicePerformer.CustMgmtDocumentItem  -- association [0..1]
LEFT OUTER JOIN A_ServiceConfItemUserStatus AS _SrvcConfItemUserStatus ON ServiceConfirmation = _SrvcConfItemUserStatus.ServiceConfirmation AND ServiceConfirmationItem = _SrvcConfItemUserStatus.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN A_SrvcConfItemPartner AS _Partner ON ServiceConfirmation = _Partner.ServiceConfirmation AND ServiceConfirmationItem = _Partner.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN A_SrvcConfItemDuration AS _Duration ON ServiceConfirmation = _Duration.ServiceConfirmation AND ServiceConfirmationItem = _Duration.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN A_SrvcConfItemAppointment AS _Appointment ON ServiceConfirmation = _Appointment.ServiceConfirmation AND ServiceConfirmationItem = _Appointment.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = ServiceConfirmationItem.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN A_SrvcConfItemSerialNumber AS _SrvcConfItemSerialNumber ON ServiceConfirmation = _SrvcConfItemSerialNumber.ServiceConfirmation AND ServiceConfirmationItem = _SrvcConfItemSerialNumber.ServiceConfirmationItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementCO ON _WBSElementCO.WBSElement = ServiceConfirmationItem.WBSElement  -- association [0..1]
LEFT OUTER JOIN A_SrvcConfItmTransHistory AS _SrvcConfItmTransHistory ON ServiceConfirmation = _SrvcConfItmTransHistory.ServiceConfirmation AND ServiceConfirmationItem = _SrvcConfItmTransHistory.ServiceConfirmationItem  -- association [0..*]
;