R_ServiceConfirmationItemTP

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 R_ServiceConfirmationItemTP.
-- 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 R_ServiceConfirmationItemTP AS
SELECT
  ServiceDocument AS ServiceConfirmation,
  ServiceDocumentItem AS ServiceConfirmationItem,
  ServiceDocumentItemObjectType,
  ServiceDocItemCategory AS ServiceConfItemCategory,
  ServiceDocumentItemUUID AS ServiceConfirmationItemUUID,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentServiceConfItem,
  ServiceDocumentItemDescription AS ServiceConfItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  ServiceObjectType,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  Batch,
  ValuationType,
  Plant,
  StorageLocation,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceEmployee AS ExecutingServiceEmployee,
  _ServicePerformer.CustMgmtPartner AS ServicePerformer,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ServiceDocumentItemStatus AS ServiceConfirmationItemStatus,
  SrvcDocItmIsReleasedForBilling AS SrvcConfItmReldForBillgStatus,
  ServiceDocItemBillingStatus AS SrvcConfItemBillingStatus,
  ServiceDocumentItemHasError AS SrvcConfItemHasError,
  SrvcDocItemTransferStatus,
  ActualServiceStartDateTime,
  ActualServiceEndDateTime,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServicesRenderedDate,
  ServiceTransactionChargeType,
  SrvcTransactionValuationType,
  TimeSheetOvertimeCategory,
  MasterWarranty,
  SrvcDocItemIsUnderWarranty,
  TransactionCurrency,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  BillableControl,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  ContractAccount,
  PurchaseOrderByCustomer,
  _CustMgmtExtRef.CustMgmtExtRefID AS SrvcConfItemExtReference,
  _CustMgmtHeaderExtRef.CustMgmtExtRefID AS SrvcConfExtReference,
  cast(_RefServiceOrder.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS ReferenceServiceOrder,
  cast( _RefServiceOrder.BusinessTransactionDocItem as crms4_number_int ) AS ReferenceServiceOrderItem,
  cast(_RefServiceContract.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS ReferenceServiceContract,
  cast(_RefServiceContract.BusinessTransactionDocItem as crms4_number_int ) AS ReferenceServiceContractItem,
  SrvcDocItmPartReferenceItem,
  SrvcDocItmApptRefObjectUUID,
  SrvcDocItmApptReferenceItem,
  ShippingCondition,
  _RefServiceOrder._ServiceDocumentItemEnhcd.SrvcDocItemIsUnplanned AS RefSrvcOrdItemIsUnplanned,
  MaterialSubstitutionReason,
  OriginallyRequestedProduct
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceConfirmation = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND ServiceConfirmationItem = _CustMgmtExtRef.CustMgmtDocumentItem AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0015'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtHeaderExtRef ON ServiceConfirmation = _CustMgmtHeaderExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtHeaderExtRef.CustMgmtObjectType AND _CustMgmtHeaderExtRef.CustMgmtExtRefIDType = '0014'  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocItemDocumentFlow AS _RefServiceOrder ON ServiceConfirmation = _RefServiceOrder.ServiceDocument AND ServiceConfirmationItem = _RefServiceOrder.ServiceDocumentItem AND _RefServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000116' AND _RefServiceOrder.ServiceObjectType = 'BUS2000117'  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocItemDocumentFlow AS _RefServiceContract ON ServiceConfirmation = _RefServiceContract.ServiceDocument AND ServiceConfirmationItem = _RefServiceContract.ServiceDocumentItem AND _RefServiceContract.PrdcssrSuccssrDocObjectType = 'BUS2000112' AND _RefServiceContract.ServiceObjectType = 'BUS2000117'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ServicePerformer ON _ServicePerformer.CustMgmtPartnerFunction = '00000028' AND _ServicePerformer.CustMgmtPartFunctionCategory = '0091' AND ServiceConfirmation = _ServicePerformer.CustMgmtDocument AND ServiceConfirmationItem = _ServicePerformer.CustMgmtDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcConfItmStatus ON ServiceConfirmationItemUUID = _SrvcConfItmStatus.StatusObjectUUID AND ( _SrvcConfItmStatus.StatusCode = 'I1002' OR _SrvcConfItmStatus.StatusCode = 'I1003' OR _SrvcConfItmStatus.StatusCode = 'I1005' ) AND _SrvcConfItmStatus.StatusIsActive = 'X'  -- association [0..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_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_ServiceDocumentItemEnhcd.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_SrvcConfItemPriceElementTP AS _SrvcConfItemPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemPartnerTP AS _SrvcConfItemPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemRefObjectTP AS _SrvcConfItemRefObjTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemSerialNumberTP AS _SrvcConfItemSerialNumberTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItmFUPBillgDocTP AS _SrvcConfItmFUPBillgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItmFUPBillgDocReqTP AS _SrvcConfItmFUPBillgDocReqTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItmFUPTimeSheetTP AS _SrvcConfItmFUPTimeSheetTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItmFUPMatlDocumentTP AS _SrvcConfItmFUPMatlDocumentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItmFUPCtrlgDocTP AS _SrvcConfItmFUPCtrlgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemAppointmentTP AS _SrvcConfItemAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemDurationTP AS _SrvcConfItemDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemUserStatusTP AS _SrvcConfItemUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfItemLongTextTP AS _SrvcConfItemLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;