C_SrvcContrItmListRptAndObjPg

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_SrvcContrItmListRptAndObjPg.
-- 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: CSRVCONTRACTITEM

CREATE VIEW C_SrvcContrItmListRptAndObjPg AS
SELECT
  ServiceContractItem.ServiceObjectType AS ServiceObjectType,
  ServiceContractItem.ServiceDocument AS ServiceContract,
  ServiceContractItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceContractItem.ServiceDocumentItem AS ServiceContractItem,
  ServiceContractItem.ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceContractItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  ServiceDocumentItemDescription AS ServiceContractItemDescription,
  tstmp_to_dats( ServiceContrItemStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ServiceContractItemStartDate AS clientNULLasServiceContractItemStartDate,
  tstmp_to_dats( ServiceContrItemEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ServiceContractItemEndDate AS clientNULLasServiceContractItemEndDate,
  ServiceContractItem.ServiceDocumentItemNetAmount AS ServiceContractItemNetAmount,
  ServiceContractItem.ServiceDocItemGrossAmount AS ServiceContractItemGrossAmount,
  ServiceContractItem.TransactionCurrency AS TransactionCurrency,
  ServiceContractItem.ServiceDocumentItemQuantity AS ServiceContractItemQuantity,
  ServiceContractItem.ServiceDocumentItemHasError AS ServiceContractItemHasError,
  ServiceContractItem.ServiceDocItemQuantityUnit AS ServiceContrItemQuantityUnit,
  ServiceContractItem.ServiceDocItemCategory AS ServiceContractItemCategory,
  ServiceContractItem.ServiceDocItemBillingStatus AS ServiceContrItemBillingStatus,
  ParentServiceDocumentItemUUID,
  SettlementPeriodRuleUUID,
  BillingPlanBillingDateRuleUUID,
  cast( '' as abap.char(50)) AS BillingPlanBillingDateRuleName,
  cast( '' as abap.char(50)) AS SettlementPeriodRuleName,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ResponsibleEmployee,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ServiceDocumentItemEnhcd AS ServiceContractItem
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceContract = _ServiceDocItemExt.ServiceOrderItem AND ServiceContractItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN C_SrvcContrItmObjPgSettlmtPerd AS _SrvcContrItmSettlmtPerds ON ServiceObjectType = _SrvcContrItmSettlmtPerds.ServiceObjectType AND ServiceContract = _SrvcContrItmSettlmtPerds.ServiceDocument AND ServiceContractItem = _SrvcContrItmSettlmtPerds.ServiceDocumentItem  -- association [1..*]
LEFT OUTER JOIN C_SrvcContrItmObjPgObjList AS _SrvcContrItemObjects ON ServiceObjectType = _SrvcContrItemObjects.ServiceContractType AND ServiceContract = _SrvcContrItemObjects.ServiceContract AND ServiceContractItem = _SrvcContrItemObjects.ServiceContractItem  -- association [1..*]
LEFT OUTER JOIN C_SrvcContrItmObjPgProdList AS _SrvcContrItemProducts ON ServiceObjectType = _SrvcContrItemProducts.ServiceContractType AND ServiceContract = _SrvcContrItemProducts.ServiceContract AND ServiceContractItem = _SrvcContrItemProducts.ServiceContractItem  -- association [1..*]
LEFT OUTER JOIN C_SrvcContrItmObjPgPrcDets AS _SrvcContrItemPriceDts ON ServiceObjectType = _SrvcContrItemPriceDts.ServiceContractType AND ServiceContract = _SrvcContrItemPriceDts.ServiceContract AND ServiceContractItem = _SrvcContrItemPriceDts.ServiceContractItem  -- association [1..*]
;