C_SrvcConfirmationItem

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_SrvcConfirmationItem.
-- 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: CCONFITEMORD

CREATE VIEW C_SrvcConfirmationItem AS
SELECT
  ServiceDocumentItem.ServiceObjectType AS ServiceObjectType,
  ServiceDocumentItem.ServiceDocument AS ServiceDocument,
  ServiceDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceDocumentItemUUID,
  ServiceDocumentItemCharUUID,
  ServiceDocumentItem.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceDocument.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
  ServiceDocumentItemObjectType,
  ServiceDocument.ServiceDocumentDescription AS ServiceDocumentDescription,
  ServiceDocument._ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  cast( 0 as abap.dec( 24, 3 ) ) AS ManualNetPriceAmtInDocCrcy,
  cast( '' as abap.cuky( 5 ) ) AS NetPriceQuantityUnit,
  cast(3 as abap.int4) AS UICT_ManualNetPriceAmt,
  ServiceDocumentItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  _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,
  ServiceDocumentItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
  ServiceDocumentItemDescription,
  ServiceDocumentItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  _ServiceDocItemCategory._ServiceDocItemCategoryText[1:Language = $session.system_language].ServiceDocItemCategoryName AS ServiceDocItemCategoryName,
  ServiceDocumentItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  ServiceDocumentItem.ServiceDocumentItemQuantity AS ServiceDocumentItemQuantity,
  ServiceDocumentItem.TransactionCurrency AS TransactionCurrency,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  cast(3 as abap.int4) AS UICT_ActualServiceDuration,
  ServiceDocumentItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocument.ServiceDocumentStatus AS ServiceDocumentStatus,
  ServiceDocument.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  ServiceDocument.ServiceDocumentIsReleased AS ServiceDocumentIsReleased,
  _SelectProcurementStatus.SrvcDocItemProcmtStatus AS SrvcDocItemProcmtStatus,
  _ServiceDocItemCategory.StatusProfile AS StatusProfile,
  ServiceDocumentItem.BillingPriceSourceName AS BillingPriceSourceName,
  ServiceDocumentItem.DocumentDescription AS DocumentDescription,
  cast( '' as crmt_boolean ) AS MaterialComponentIsSparePart,
  ServiceDocumentItem.BillableControl AS BillableControl,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.OriginallyRequestedProduct AS CustMgmtParentItemProduct,
  _ParentServiceDocItem.ServiceDocumentItemDescription AS CustMgmtParentItemProductName,
  ServiceDocumentItem.ResponsibleEmployee AS ResponsibleEmployee,
  ServiceDocumentItem.SoldToParty AS SoldToParty,
  ServiceDocumentItem.ServiceEmployee AS ServiceEmployee,
  TimeSheetOvertimeCategory,
  cast(3 as abap.int4) AS UICT_TimeSheetOvertimeCategory,
  ActualServiceStartDateTime,
  cast(3 as abap.int4) AS UICT_ActualSrvcStartDateTime,
  BillingDateTime,
  BillingDocCreationDateTime,
  ServiceDocItemBillingStatus,
  ServiceDocumentItem.PaymentTerms AS PaymentTerms,
  ServiceDocumentItem.PayerParty AS PayerParty,
  ServiceDocumentItem.BillToParty AS BillToParty,
  ServiceDocumentItem.SalesOrganization AS SalesOrganization,
  ServiceDocumentItem.DistributionChannel AS DistributionChannel,
  ServiceDocumentItem.Division AS Division,
  ServiceDocumentItem.SalesOffice AS SalesOffice,
  ServiceDocumentItem.SalesGroup AS SalesGroup,
  case ServiceDocumentItem.ServiceObjectType when 'BUS2000117' then _SrvcOrderFUPSrvcConfirmation.ServiceOrder when 'BUS2000116' then ServiceDocumentItem.ServiceDocument end as ServiceOrder AS ServiceDocumentendasServiceOrder,
  ServiceDocument.ServiceConfirmationIsFinal AS ServiceConfirmationIsFinal,
  ServiceDocumentItem.SrvcDocItemIsUnplanned AS SrvcOrdItemIsUnplanned,
  cast( '' as abap.char( 10 ) ) AS SrvcConfirmationDocFinalText,
  ServiceDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SrvcOrderFUPSrvcConfirmation.ServiceDocumentPredecessorUUID AS ServiceDocumentPredecessorUUID,
  _ServiceDocItemAggrgdActl.TotalQuantity AS TotalQuantity,
  ServiceDocumentItem.PostingDate AS PostingDate,
  ServiceDocumentItemHasError,
  ServiceDocument.ServiceDocumentHasError AS ServiceDocumentHasError,
  ServiceDocumentItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentItem.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentItem._SoldToParty AS _SoldToParty,
  ServiceDocumentItem._ServiceEmployee AS _ServiceEmployee,
  ServiceDocumentItem._PaymentTerms AS _PaymentTerms,
  ServiceDocumentItem._BillableControl AS _BillableControl,
  ServiceDocument._ServiceDocHasError AS _ServiceDocHasError
FROM I_ServiceDocumentItemEnhcd AS ServiceDocumentItem
LEFT OUTER JOIN I_SrvcOrderFUPSrvcConfirmation AS _SrvcOrderFUPSrvcConfirmation ON ServiceDocumentUUID = _SrvcOrderFUPSrvcConfirmation.ServiceDocumentUUID  -- association [1..*]
LEFT OUTER JOIN I_StatusCode AS _StatusCode ON SrvcDocItemProcmtStatus = _StatusCode.StatusCode AND statusprofile = _StatusCode.StatusProfile  -- association [0..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 P_SelectProcurementStatus AS _SelectProcurementStatus ON ServiceDocumentItemUUID = _SelectProcurementStatus.StatusObjectUUID  -- association [1..1]
LEFT OUTER JOIN P_SrvcOrdItemAggrgdActuals AS _ServiceDocItemAggrgdActl ON ServiceDocumentItemCharUUID = _ServiceDocItemAggrgdActl.ServiceDocumentItemCharUUID  -- association [0..1]
LEFT OUTER JOIN C_SrvcConfTransHistory AS _SrvcConfTransHistory ON ServiceObjectType = _SrvcConfTransHistory.ServiceObjectType AND ServiceDocument = _SrvcConfTransHistory.ServiceDocument AND ServiceDocumentItem = _SrvcConfTransHistory.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SrvcConfItmObjPgPricingDets AS _ServiceConfItmPriceDets ON ServiceObjectType = _ServiceConfItmPriceDets.ServiceObjectType AND ServiceDocument = _ServiceConfItmPriceDets.ServiceDocument AND ServiceDocumentItem = _ServiceConfItmPriceDets.ServiceDocumentItem  -- association [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 C_ServiceDocObjPgErrorLog AS _ServiceDocumentErrorLog ON ServiceObjectType = _ServiceDocumentErrorLog.ServiceObjectType AND ServiceDocument = _ServiceDocumentErrorLog.ServiceDocument  -- 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_SrvcDocDateInformation AS _SrvcDateItemInfo ON ( ServiceDocument = _SrvcDateItemInfo.ServiceDocument AND ServiceObjectType = _SrvcDateItemInfo.ServiceObjectType AND ServiceDocumentItem = _SrvcDateItemInfo.ServiceDocumentItem ) OR ( ServiceDocumentItemUUID = _SrvcDateItemInfo.SrvcMgmtObjectUUID )  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocItemUserStatus AS _SrvcDocItemUserStatus ON ServiceDocumentItemUUID = _SrvcDocItemUserStatus.StatusObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _SrvcDocCustMgmtLCUsrStsTxt ON _SrvcDocCustMgmtLCUsrStsTxt.CustMgmtLifecycleUserStatus = ServiceDocumentStatus AND _SrvcDocCustMgmtLCUsrStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _SrvcDocItmCustMgmtLCUsrStsTxt ON _SrvcDocItmCustMgmtLCUsrStsTxt.CustMgmtLifecycleUserStatus = ServiceDocumentItemStatus AND _SrvcDocItmCustMgmtLCUsrStsTxt.Language = $session.system_language  -- association [0..1]
;