R_ServiceContractItemTP

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_ServiceContractItemTP.
-- 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_ServiceContractItemTP AS
SELECT
  ServiceDocument AS ServiceContract,
  cast(ServiceDocumentItem as crms4_number_int preserving type) AS ServiceContractItem,
  ServiceDocumentDescription AS ServiceContractDescription,
  ServiceObjectType,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentServiceContractItem,
  ServiceDocItemCategory AS ServiceContractItemCategory,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  ServiceDocumentItemDescription AS ServiceContractItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  SoldToPartyCountry,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceDocItemBillingStatus AS ServiceContrItemBillingStatus,
  ServiceDocumentItemIsRejected AS ServiceContractItemIsRejected,
  ServiceDocumentItemHasError AS ServiceContractItemHasError,
  SrvcDocItemTransferStatus,
  SrvcDocItemCreditStatus AS SrvcContrItemCreditStatus,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ResponseProfile,
  ServiceProfile,
  ProfitCenter,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  TransactionCurrency,
  ServiceDocumentItemCanclnParty AS ServiceContractItemCanclnParty,
  ServiceDocumentItmCanclnReason AS ServiceContractItmCanclnReason,
  SettlementPeriodRuleUUID,
  _SettlementPeriodRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  BillingPlanBillingDateRuleUUID,
  _BillingPlanBillingDateRule.CustMgmtDateRuleName AS SrvcMgmtBillgPlanBillgDateRule,
  BillingBlockReason,
  BillingPlanPriceDateRule,
  BillingPlanIsFinalized,
  ContractAccount,
  _ExtRefServiceContract.CustMgmtExtRefID AS SrvcContrExternalReference,
  _ExtRefServiceContractItem.CustMgmtExtRefID AS SrvcContrItmExternalReference,
  _ExtRefServiceQtan.CustMgmtExtRefID AS ServiceQtanExtReference,
  _ExtRefServiceQtanItem.CustMgmtExtRefID AS ServiceQtanItemExtReference,
  cast( _RefServiceTemplate.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS RefServiceContractTemplate,
  cast( _RefServiceTemplate.BusinessTransactionDocItem as crms4_number_int ) AS RefServiceContractTemplateItem,
  SrvcDocItmPartReferenceItem,
  SrvcDocItmApptRefObjectUUID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  PurchaseOrderByCustomer
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdItmStatus ON ServiceContractItemUUID = _SrvcOrdItmStatus.StatusObjectUUID AND ( _SrvcOrdItmStatus.StatusCode = 'I1002' OR _SrvcOrdItmStatus.StatusCode = 'I1003' OR _SrvcOrdItmStatus.StatusCode = 'I1004' OR _SrvcOrdItmStatus.StatusCode = 'I1005' ) AND _SrvcOrdItmStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceContract ON _ExtRefServiceContract.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceContract.CustMgmtDocument AND _ExtRefServiceContract.CustMgmtExtRefIDType = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceContractItem ON _ExtRefServiceContractItem.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceContractItem.CustMgmtDocument AND ServiceContractItem = _ExtRefServiceContractItem.CustMgmtDocumentItem AND _ExtRefServiceContractItem.CustMgmtExtRefIDType = '0004'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceQtan ON _ExtRefServiceQtan.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceQtan.CustMgmtDocument AND _ExtRefServiceQtan.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceQtanItem ON _ExtRefServiceQtanItem.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceQtanItem.CustMgmtDocument AND ServiceContractItem = _ExtRefServiceQtanItem.CustMgmtDocumentItem AND _ExtRefServiceQtanItem.CustMgmtExtRefIDType = '0010'  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocItemDocumentFlow AS _RefServiceTemplate ON ServiceContract = _RefServiceTemplate.ServiceDocument AND ServiceContractItem = _RefServiceTemplate.ServiceDocumentItem AND _RefServiceTemplate.PrdcssrSuccssrDocObjectType = 'BUS2000112' AND _RefServiceTemplate.ServiceDocumentTemplateType is not initial AND _RefServiceTemplate.ServiceObjectType = 'BUS2000112'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementPeriodRule ON SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _BillingPlanBillingDateRule ON BillingPlanBillingDateRuleUUID = _BillingPlanBillingDateRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodInCountryVH AS _PaymentMethodVH ON PaymentMethod = _PaymentMethodVH.PaymentMethod AND SoldToPartyCountry = _PaymentMethodVH.Country  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocLifecycleStatusText AS _SrvcDocLifecycleStatusText ON ServiceContractItemStatus = _SrvcDocLifecycleStatusText.ServiceDocumentStatus  -- association [1..*]
LEFT OUTER JOIN I_ServiceDocBillingStatusText AS _ServiceDocBillingStatusText ON ServiceContrItemBillingStatus = _ServiceDocBillingStatusText.ServiceDocBillingStatus  -- association [1..*]
LEFT OUTER JOIN I_SrvcDocTransferStatusText AS _SrvcDocTransferStatusText ON SrvcDocItemTransferStatus = _SrvcDocTransferStatusText.SrvcDocTransferStatus  -- association [1..*]
LEFT OUTER JOIN I_SrvcDocRejectionStatusText AS _SrvcDocRejectionStatusText ON ServiceContractItemIsRejected = _SrvcDocRejectionStatusText.ServiceDocumentIsRejected  -- association [1..*]
LEFT OUTER JOIN I_BillingBlockReasonText AS _BillingBlockReasonText ON BillingBlockReason = _BillingBlockReasonText.BillingBlockReason  -- association [1..*]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [1..*]
LEFT OUTER JOIN I_ServiceDocItemCategoryText AS _ServiceDocItemCategoryText ON ServiceContractItemCategory = _ServiceDocItemCategoryText.ServiceDocItemCategory  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON QuantityUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [1..*]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON TransactionCurrency = _CurrencyText.Currency  -- association [1..*]
LEFT OUTER JOIN I_CustMgmtDateRuleText AS _SrvcMgmtDateRuleText ON SrvcMgmtBillgPlanBillgDateRule = _SrvcMgmtDateRuleText.CustMgmtDateRuleName  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtDateRuleText AS _SettlementPeriodRuleText ON SettlementPeriodRule = _SettlementPeriodRuleText.CustMgmtDateRuleName  -- association [0..*]
LEFT OUTER JOIN I_ServiceCancellationPartyText AS _ServiceCancellationPartyText ON ServiceContractItemCanclnParty = _ServiceCancellationPartyText.ServiceContractCanclnParty  -- association [1..*]
LEFT OUTER JOIN I_ServiceCanclnReasonText AS _ServiceCanclnReasonText ON ServiceContractItmCanclnReason = _ServiceCanclnReasonText.ServiceContrCancellationReason  -- association [1..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_ServiceDocumentItemEnhcd.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceContract = _Extension.ServiceOrderItem AND ServiceContractItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN R_SrvcContrItemPartnerTP AS _SrvcContrItmPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemPriceElementTP AS _SrvcContrItmPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemUserStatusTP AS _SrvcContrItemUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmFUPBillgDocTP AS _SrvcContrItmFUPBillgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmFUPSrvcOrdTP AS _SrvcContrItmFUPSrvcOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemRefObjectTP AS _SrvcContrItemRefObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemProductTP AS _SrvcContrItemProductTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmBillgReqItemTP AS _SrvcContrItmBillgReqItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemDurationTP AS _SrvcContrItemDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemAppointmentTP AS _SrvcContrItemAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemLongTextTP AS _SrvcContrItemLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;