R_ServiceConfirmationTP

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_ServiceConfirmationTP.
-- 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_ServiceConfirmationTP AS
SELECT
  ServiceDocument AS ServiceConfirmation,
  ServiceDocumentType AS ServiceConfirmationType,
  ServiceDocumentUUID AS ServiceConfirmationUUID,
  ServiceDocumentDescription AS ServiceConfirmationDescription,
  Language,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  ServiceObjectType,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceEmployee,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  _StatusCancelled.StatusIsActive AS ServiceConfirmationIsCanceled,
  ServiceDocumentStatus AS ServiceConfirmationStatus,
  ServiceDocIsReleasedForBilling AS SrvcConfReldForBillingStatus,
  ServiceDocBillingStatus AS SrvcConfBillingStatus,
  ServiceConfirmationIsFinal,
  ServiceDocumentHasError AS ServiceConfirmationHasError,
  SrvcDocTransferStatus,
  SrvcDocRejectionStatus,
  ServiceDocumentPriority,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  _CustMgmtExtRef.CustMgmtExtRefID AS SrvcConfExtReference,
  cast( _RefServiceOrder.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS ReferenceServiceOrder,
  ShippingCondition
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceConfirmation = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0014'  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocDocumentFlow AS _RefServiceOrder ON ServiceConfirmationUUID = _RefServiceOrder.ServiceDocumentUUID AND _RefServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000116' AND _RefServiceOrder.ServiceObjectType = 'BUS2000117'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcConfStatus ON ServiceConfirmationUUID = _SrvcConfStatus.StatusObjectUUID AND ( _SrvcConfStatus.StatusCode = 'I1002' OR _SrvcConfStatus.StatusCode = 'I1003' OR _SrvcConfStatus.StatusCode = 'I1005' ) AND _SrvcConfStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _StatusCancelled ON ServiceConfirmationUUID = _StatusCancelled.StatusObjectUUID AND _StatusCancelled.StatusCode = 'I1096'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceConfirmation = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN R_ServiceConfirmationItemTP AS _ServiceConfirmationItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfPartnerTP AS _SrvcConfPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfRefObjectTP AS _SrvcConfReferenceObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfFUPBillgDocTP AS _BillingDocumentFollowupTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfFUPTimeSheetTP AS _TimeSheetFollowupTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfPriceElementTP AS _SrvcConfPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfAppointmentTP AS _SrvcConfAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfDurationTP AS _SrvcConfDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfUserStatusTP AS _SrvcConfUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcConfLongTextTP AS _SrvcConfLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;