I_SrvcConfRelBillgListRpt

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 I_SrvcConfRelBillgListRpt.
-- 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 I_SrvcConfRelBillgListRpt AS
SELECT
  ServiceDocumentItem.ServiceObjectType AS ServiceObjectType,
  ServiceDocumentItem.ServiceDocument AS ServiceDocument,
  ServiceDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceDocumentItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  ServiceDocumentItem.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceDocumentItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceConfirmation,
  ServiceDocumentItem.TransactionCurrency AS TransactionCurrency,
  ServiceDocumentItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  ServiceDocumentItem.PostingDate AS PostingDate,
  ServiceDocumentItem.SoldToParty AS SoldToParty,
  ServiceDocumentItem.ServiceTeam AS ServiceTeam,
  ServiceDocumentItem.ServiceDocItemCreationDate AS ServiceConfItemCreationDate,
  ServiceDocumentItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  ServiceDocumentItem.ServiceDocumentItemDescription AS ServiceConfItemDescription,
  ServiceOrder,
  case ServiceDocumentItem.ServiceObjectType when 'BUS2000117' then _ItmPredecessor._ServiceDocItm.ServiceDocumentType when 'BUS2000116' then ServiceDocumentItem.ServiceDocumentType end as ServiceOrderType AS ServiceDocumentTypeendasServiceOrderType,
  ServiceDocumentItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  ServiceDocumentItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceDocumentItem.BillableControl AS BillableControl,
  ParentServiceDocumentItemUUID,
  ServiceDocumentItem.ResponsibleEmployee AS ResponsibleEmployee,
  ServiceDocumentItem.SalesOrganization AS SalesOrganization,
  ServiceDocumentItem.DistributionChannel AS DistributionChannel,
  ServiceDocumentItem.Division AS Division,
  ServiceDocumentItem.SalesOffice AS SalesOffice,
  ServiceDocumentItem.SalesGroup AS SalesGroup,
  ServiceDocumentItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentItem.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentItem.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
  SrvcOrderConfirmationRelevance,
  ParentSrvcOrdItmConfRelevance,
  ParentServiceDocumentItem,
  SrvcDocItemIsBundle,
  ServiceDocumentItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
  ServiceDocumentItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_2 AS _ItmPredecessor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceDocument AS _ServiceConfirmation ON /* join condition not captured in parsed metadata */
;