I_ServiceDocumentItemEnhcd

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_ServiceDocumentItemEnhcd.
-- 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_ServiceDocumentItemEnhcd AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentDescription,
  ServiceDocumentType,
  ServiceDocumentItemPriority,
  PostingDate,
  ServicesRenderedDate,
  SrvcDocItmPostingDateTime,
  SrvcDocItmValdtyStartDateTime,
  SrvcDocItmValdtyEndDateTime,
  ServiceDocumentItemUUID,
  ServiceDocumentItemCharUUID,
  ServiceDocumentItemObjectType,
  ServiceDocumentUUID,
  ParentServiceDocumentItemUUID,
  ServiceDocumentItemDescription,
  Language,
  ServiceDocumentTemplateType,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  IntcoRcvgSalesOrganization,
  MaintenancePlanningPlant,
  WorkCenterInternalID,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  OriginallyRequestedProduct,
  MaterialByCustomer,
  Product,
  ServiceDocItemCategory,
  ProfitCenter,
  ResponsibleCostCenter,
  ControllingArea,
  ProfitCenterDeterminationDate,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  SrvcDocItmRequestedQuantity,
  InvoiceAmountInInvoiceDocCrcy,
  InvoiceQuantity,
  SrvcDocItmDeliveredQuantity,
  SrvcDocItmReleasedQuantity,
  CumulativeConfirmedQuantity,
  SrvcDocItmReldAmtInTransCrcy,
  SrvcDocItmOrdToBaseQtyNmrtr,
  SrvcDocItmOrdToBaseQtyDnmntr,
  OrderToBaseQuantityExponent,
  ServiceDocItemQuantityUnit,
  SrvcDocItemBaseQuantityUnit,
  Batch,
  ValuationType,
  BillingDateTime,
  BillingDocCreationDateTime,
  BillingPlanTimeZone,
  SrvcDocBillingPlanType,
  BillingPriceSourceName,
  cast( '' as abap.char( 16 ) ) AS DocumentDescription,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  ServiceTeam,
  ResponsibleEmployee,
  ServiceEmployee,
  ContactPerson,
  PayerParty,
  BillToParty,
  ShipToParty,
  ServiceDocumentItemStatus,
  ServiceDocumentItemHasError,
  SrvcDocItmIsReleasedForBilling,
  ServiceDocItemBillingStatus,
  ServiceDocumentItemIsOpen,
  SrvcDocItmDeliveryStatus,
  SrvcDocItmGoodsIssueStatus,
  ServiceDocumentItemIsReleased,
  ServiceDocumentItemIsRejected,
  SrvcDocItemIsWithdrawn,
  ServiceDocumentItemIsQuotation,
  SrvcDocItemTransferStatus,
  MaintSrvcOrdExecutionStatus,
  SrvcDocItemExecutionStatus,
  ServiceDocumentItemQuantity,
  TransactionCurrency,
  StatisticsCurrency,
  ExchangeRateType,
  ExchangeRateDate,
  AccountingExchangeRate,
  PaymentTerms,
  PaymentMethod,
  SrvcSEPAMandateRelevance,
  SEPAMandate,
  WBSElementInternalID,
  BillableControl,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  ServiceDocItemGrossAmount,
  PriceReferenceCPQQuotation,
  PriceReferenceCPQQuotationItem,
  PricingDate,
  BillingBlockReason,
  SrvcDocItmBillingRelevance,
  DynItemProcessorPrfl,
  SrvcDocBillingPlanTemplate,
  ProductGroup,
  SrvcMaterialPricingGroup,
  MaterialPricingGroup_2,
  ProductGroup1,
  ProductGroup2,
  ProductGroup3,
  ProductGroup4,
  ProductGroup5,
  ProductHierarchy,
  Industry,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  CustPurOrdDateByShipToParty,
  ServiceDocItemRejectionReason,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  Plant,
  ServiceSchema1Category1UUID,
  ServiceSchema1Category2UUID,
  ServiceSchema1Category3UUID,
  ServiceSchema1Category4UUID,
  ServiceSchema1Category5UUID,
  ServiceSchema1Category6UUID,
  ServiceSchema1Category7UUID,
  ServiceSchema1Category8UUID,
  ServiceSchema1Category9UUID,
  ServiceSchema1Category10UUID,
  SrvcCatztnSchema1,
  SrvcCatztnSchemaCategory1,
  ServiceSchema2Category1UUID,
  ServiceSchema2Category2UUID,
  ServiceSchema2Category3UUID,
  ServiceSchema2Category4UUID,
  ServiceSchema2Category5UUID,
  ServiceSchema2Category6UUID,
  ServiceSchema2Category7UUID,
  ServiceSchema2Category8UUID,
  ServiceSchema2Category9UUID,
  ServiceSchema2Category10UUID,
  SrvcCatztnSchema2,
  SrvcCatztnSchemaCategory2,
  SettlementPeriodRuleUUID,
  BillingPlanBillingDateRuleUUID,
  BillingPlanPriceDateRule,
  BillingPlanIsFinalized,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ResponsibleSalesOrganization,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  RespyMgmtServiceTeam,
  EnterpriseServiceOrganization,
  EnterpriseProjectServiceOrg,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  tstmp_to_dats( RequestedServiceStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceStartDate AS clientNULLasRequestedServiceStartDate,
  tstmp_to_dats( RequestedServiceEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceEndDate AS clientNULLasRequestedServiceEndDate,
  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,
  ServiceFirstResponseByDateTime,
  tstmp_to_dats( ServiceFirstResponseByDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as ServiceFirstResponseByDate AS clientNULLasServiceFirstResponseByDate,
  SrvcDocItemSLADueByDateTime,
  tstmp_to_dats( SrvcDocItemSLADueByDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SrvcDocItemSLADueByDate AS clientNULLasSrvcDocItemSLADueByDate,
  ActualServiceStartDateTime,
  ActualServiceEndDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  PlannedServiceStartDateTime,
  PlannedServiceEndDateTime,
  tstmp_to_dats( PlannedServiceStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PlannedServiceStartDate AS clientNULLasPlannedServiceStartDate,
  tstmp_to_dats( PlannedServiceEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PlannedServiceEndDate AS clientNULLasPlannedServiceEndDate,
  SrvcDocItmTmeSliceStrtDteTme,
  SrvcDocItmTmeSliceEndDteTme,
  SrvcContrItemRenewalDateTime,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServiceWorkDuration,
  ServiceWorkDuration_2,
  ServiceWorkDurationUnit,
  SrvcOrderConfirmationRelevance,
  ServiceTransactionChargeType,
  SrvcTransactionValuationType,
  ResponseProfile,
  ServiceProfile,
  ServiceDuration,
  ServiceDurationUnit,
  TimeSheetOvertimeCategory,
  MasterWarranty,
  ContractAccount,
  ItemOrderProbabilityInPercent,
  QuotationIsAccepted,
  ConfigurationNumber,
  IncotermsPart1,
  IncotermsPart2,
  DeliveryPriority,
  OrderCombinationIsAllowed,
  PartialDeliveryIsAllowed,
  CABillgCycle,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  MaterialPricingGroup,
  CustomerPriceGroup,
  DeliveryGroup,
  DeliveryBlockReason,
  RequestedDeliveryDateTime AS RequestedDeliveryUTCDateTime,
  ErlstConfirmedDeliveryDateTime,
  LtstConfirmedDeliveryDateTime,
  tstmp_to_dats( RequestedDeliveryDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedDeliveryDate AS clientNULLasRequestedDeliveryDate,
  SubscrpnOrdProdSelType,
  SubscriptionContract,
  SrvcTransChangeProcess,
  SrvcTransChangeProcessType,
  SrvcTransChgProcSourceItemUUID,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  SubscrpnContrActivationStatus,
  SubscrpnContrTimeSliceStatus,
  SharingContractID,
  CrsCatalogMappingVersionNumber,
  CustMgmtMstrAgrmtParentItem,
  SubscrpnContractSharingGroupID,
  CAPartnerSettlementRule,
  ChangeProcessGroup,
  BusSolutionQtnItemIsPhased,
  BusSolnQtnItmPhasedPrdcssrItem,
  SubscriptionContractItem,
  SrvcDocItemWithdrawalReason,
  SrvcDocItemRefundType,
  SrvcDocItmRecrrgChrgNetAmount,
  SubscrpnContrTrmsAreSpecified,
  MidBillgCycExprtnIsAllowed,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  SubscriptionContractReference,
  SubscriptionBillingCycle,
  SubscriptionContractExternalID,
  SbscrShContrSvTrMtAgrItmUUID,
  SbscrShContrSvTrMtAgrItmCstPrd,
  SvTrMtAgrItmIsFxdConfign,
  SubscrpnContrItmBillgPlnCyc,
  ServiceDocumentItemCanclnParty,
  ServiceDocumentItmCanclnReason,
  SrvcDocItmCanclnProcedure,
  ServiceDocumentRnwlDuration,
  ServiceDocRnwlDurationUnit,
  ServiceDocExtensionDuration,
  ServiceDocExtnDurationUnit,
  SrvcDocItemGracePeriod,
  SrvcDocItemGracePeriodUnit,
  SrvcDocItmGrcePerdEndDateTime,
  SbscrContrItmBizValdStrtDteTme,
  SbscrContrItmBizValdEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  BillOfMaterialItemNodeNumber,
  ReferenceInHouseRepair,
  ReferenceInHouseRepairItem,
  RefInHouseRepairIsExisting,
  SrvcDocItemCreditStatus,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  SrvcDocItmBslnCostPostgStatus,
  SrvcDocItmContinuousCostStatus,
  SrvcDocItemIsUnplanned,
  ShippingCondition,
  SrvcDocSubitemOrigin,
  SrvcDocItemCategoryUsage,
  SrvcDocItmAcctAssgmtObjectType,
  SrvcDocItmAcctAssgmtObject,
  MaterialSubstitutionReason,
  SrvcDocItmPartReferenceItem,
  SrvcDocItmApptRefObjectUUID,
  SrvcDocItmApptReferenceItem
FROM I_ServiceDocumentItem
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _ServiceDocument ON ServiceObjectType = _ServiceDocument.ServiceObjectType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ParentServiceDocItem ON ParentServiceDocumentItemUUID = _ParentServiceDocItem.ServiceDocumentItemUUID  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ParentServiceDocItem_2 ON ServiceObjectType = _ParentServiceDocItem_2.ServiceObjectType AND ServiceDocument = _ParentServiceDocItem_2.ServiceDocument AND ParentServiceDocumentItemUUID = _ParentServiceDocItem_2.ServiceDocumentItemUUID  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentRefObject AS _ServiceDocItemRefObj ON ServiceObjectType = _ServiceDocItemRefObj.ServiceObjectType AND ServiceDocument = _ServiceDocItemRefObj.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemRefObj.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentRefObject AS _ServiceDocItemMainRefObj ON ServiceObjectType = _ServiceDocItemMainRefObj.ServiceObjectType AND ServiceDocument = _ServiceDocItemMainRefObj.ServiceDocument AND ServiceDocumentItem = _ServiceDocItemMainRefObj.ServiceDocumentItem AND _ServiceDocItemMainRefObj.SrvcRefObjIsMainObject = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentLongText AS _ServiceDocLongText ON ServiceObjectType = _ServiceDocLongText.ServiceObjectType AND ServiceDocument = _ServiceDocLongText.ServiceDocument AND ServiceDocumentItem = _ServiceDocLongText.ServiceDocumentItem AND _ServiceDocLongText.TextObjectCategory = 'CRM_ORDERI'  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocItemNote AS _ServiceDocItemNote ON ServiceDocumentItemUUID = _ServiceDocItemNote.ServiceDocumentItemUUID  -- association [1..*]
LEFT OUTER JOIN I_ServiceDocItemTypeSlsSttg AS _ServiceDocItemTypeSlsSttg ON ServiceDocItemCategory = _ServiceDocItemTypeSlsSttg.ServiceDocItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr AS _ServiceDocItmPredecessor ON ServiceDocumentItemUUID = _ServiceDocItmPredecessor.ServiceDocumentItemUUID AND ServiceDocumentItemObjectType = _ServiceDocItmPredecessor.ServiceDocumentItemObjectType AND _ServiceDocItmPredecessor.CharcLength = 32  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentItemSuccessor AS _ServiceDocItmSuccessor ON ServiceDocumentItemUUID = _ServiceDocItmSuccessor.ServiceDocumentItemUUID AND ServiceDocumentItemObjectType = _ServiceDocItmSuccessor.ServiceDocumentItemObjectType AND _ServiceDocItmSuccessor.CharcLength = 32  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_2 AS _ServiceDocItmPrdcssr_2 ON ServiceDocumentItemCharUUID = _ServiceDocItmPrdcssr_2.ServiceDocumentItemCharUUID  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemSuccssr_2 AS _ServiceDocItmSuccssr_2 ON ServiceDocumentItemCharUUID = _ServiceDocItmSuccssr_2.ServiceDocumentItemCharUUID  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentItemPrdcssr_3 AS _ServiceDocumentItemPrdcssr_3 ON ServiceDocumentItemCharUUID = _ServiceDocumentItemPrdcssr_3.ServiceDocumentItemCharUUID  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemSuccssr_3 AS _ServiceDocumentItemSuccssr_3 ON ServiceDocumentItemCharUUID = _ServiceDocumentItemSuccssr_3.ServiceDocumentItemCharUUID  -- association [0..*]
LEFT OUTER JOIN I_MaterialPricingGroup AS _SrvcMaterialPricingGroup ON SrvcMaterialPricingGroup = _SrvcMaterialPricingGroup.MaterialPricingGroup  -- association [0..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 I_CustMgmtPartner AS _CustMgmtPartner ON ServiceDocument = _CustMgmtPartner.CustMgmtDocument AND ServiceObjectType = _CustMgmtPartner.CustMgmtObjectType AND SrvcDocItmPartReferenceItem = _CustMgmtPartner.CustMgmtDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = 'A'  -- association [0..1]
;