I_ServiceDocumentItem

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_ServiceDocumentItem.
-- 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_ServiceDocumentItem AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS ServiceDocument,
  number_int AS ServiceDocumentItem,
  description_h AS ServiceDocumentDescription,
  process_type AS ServiceDocumentType,
  priority AS ServiceDocumentItemPriority,
  posting_date AS PostingDate,
  srv_rendered_date AS ServicesRenderedDate,
  cast( order_date as crms4_order_date preserving type ) AS SrvcDocItmPostingDateTime,
  cast( valid_from as crms4_valid_from preserving type ) AS SrvcDocItmValdtyStartDateTime,
  cast( valid_to as crms4_valid_to preserving type ) AS SrvcDocItmValdtyEndDateTime,
  item_guid AS ServiceDocumentItemUUID,
  item_guid_char AS ServiceDocumentItemCharUUID,
  objtype_i AS ServiceDocumentItemObjectType,
  header_guid AS ServiceDocumentUUID,
  parent AS ParentServiceDocumentItemUUID,
  description_i AS ServiceDocumentItemDescription,
  itm_language AS Language,
  template_type AS ServiceDocumentTemplateType,
  created_at_i AS ServiceDocItemCreationDateTime,
  changed_at_i AS ServiceDocItemChangedDateTime,
  created_by_i AS ServiceDocItemCreatedByUser,
  changed_by_i AS ServiceDocItemChangedByUser,
  ordered_prod AS OriginallyRequestedProduct,
  cast ( partner_prod as matnr_ku ) AS MaterialByCustomer,
  product_id AS Product,
  itm_type AS ServiceDocItemCategory,
  profit_center AS ProfitCenter,
  cost_center AS ResponsibleCostCenter,
  kokrs AS ControllingArea,
  profit_determine_date AS ProfitCenterDeterminationDate,
  refbussolnord AS RefBusinessSolutionOrder,
  refbussolnorditm AS RefBusinessSolutionOrderItem,
  receiving_sales_org AS IntcoRcvgSalesOrganization,
  planning_plant AS MaintenancePlanningPlant,
  work_center_object_id AS WorkCenterInternalID,
  ordered_quantity AS SrvcDocItmRequestedQuantity,
  billed_value AS InvoiceAmountInInvoiceDocCrcy,
  billed_quantity AS InvoiceQuantity,
  dlv_quantity AS SrvcDocItmDeliveredQuantity,
  released_quantity AS SrvcDocItmReleasedQuantity,
  confirmed_qty AS CumulativeConfirmedQuantity,
  released_value AS SrvcDocItmReldAmtInTransCrcy,
  process_qty_num AS SrvcDocItmOrdToBaseQtyNmrtr,
  process_qty_den AS SrvcDocItmOrdToBaseQtyDnmntr,
  exponent10 AS OrderToBaseQuantityExponent,
  process_qty_unit AS ServiceDocItemQuantityUnit,
  base_qty_unit AS SrvcDocItemBaseQuantityUnit,
  Batch,
  valuation_type_mat AS ValuationType,
  bill_date AS BillingDateTime,
  invcr_date AS BillingDocCreationDateTime,
  billplan_timezone AS BillingPlanTimeZone,
  billplan_type AS SrvcDocBillingPlanType,
  billplan_template_id AS SrvcDocBillingPlanTemplate,
  price_source AS BillingPriceSourceName,
  sold_to_party AS SoldToParty,
  sold_to_country AS SoldToPartyCountry,
  sold_to_region AS SoldToPartyRegion,
  service_team AS ServiceTeam,
  person_resp AS ResponsibleEmployee,
  service_employee AS ServiceEmployee,
  contact_person AS ContactPerson,
  payer AS PayerParty,
  bill_to_party AS BillToParty,
  ship_to_party AS ShipToParty,
  stat_lifecycle AS ServiceDocumentItemStatus,
  stat_error AS ServiceDocumentItemHasError,
  stat_billing AS ServiceDocItemBillingStatus,
  stat_for_billing AS SrvcDocItmIsReleasedForBilling,
  stat_open AS ServiceDocumentItemIsOpen,
  stat_delivery AS SrvcDocItmDeliveryStatus,
  stat_goods_issue AS SrvcDocItmGoodsIssueStatus,
  stat_released AS ServiceDocumentItemIsReleased,
  stat_cancelled AS ServiceDocumentItemIsRejected,
  stat_withdrawn AS SrvcDocItemIsWithdrawn,
  stat_quotation AS ServiceDocumentItemIsQuotation,
  stat_transfer AS SrvcDocItemTransferStatus,
  stat_maintenance AS MaintSrvcOrdExecutionStatus,
  stat_maintenance AS SrvcDocItemExecutionStatus,
  order_qty AS ServiceDocumentItemQuantity,
  currency AS TransactionCurrency,
  ref_currency AS StatisticsCurrency,
  exchg_type AS ExchangeRateType,
  exchg_date AS ExchangeRateDate,
  exchg_rate AS AccountingExchangeRate,
  pmnttrms AS PaymentTerms,
  payment_method AS PaymentMethod,
  sepa_on AS SrvcSEPAMandateRelevance,
  mandate_id AS SEPAMandate,
  wbs_element AS WBSElementInternalID,
  ac_indicator AS BillableControl,
  net_value_i AS ServiceDocumentItemNetAmount,
  tax_amount_i AS ServiceDocumentItemTaxAmount,
  gross_value_i AS ServiceDocItemGrossAmount,
  cpq_price_ref_header_id AS PriceReferenceCPQQuotation,
  cpq_price_ref_item_id AS PriceReferenceCPQQuotationItem,
  price_date AS PricingDate,
  billing_block AS BillingBlockReason,
  billing_relevance AS SrvcDocItmBillingRelevance,
  dip_profile AS DynItemProcessorPrfl,
  prod_pr_group AS ProductGroup,
  prod_pr_group AS SrvcMaterialPricingGroup,
  prod_pr_group AS MaterialPricingGroup_2,
  prc_group1 AS ProductGroup1,
  prc_group2 AS ProductGroup2,
  prc_group3 AS ProductGroup3,
  prc_group4 AS ProductGroup4,
  prc_group5 AS ProductGroup5,
  prod_hierarchy AS ProductHierarchy,
  Industry,
  po_number_sold AS PurchaseOrderByCustomer,
  po_number_ship AS PurchaseOrderByShipToParty,
  po_date_ship AS CustPurOrdDateByShipToParty,
  rejection AS ServiceDocItemRejectionReason,
  cust_group AS CustomerGroup,
  cust_group1 AS AdditionalCustomerGroup1,
  cust_group2 AS AdditionalCustomerGroup2,
  cust_group3 AS AdditionalCustomerGroup3,
  cust_group4 AS AdditionalCustomerGroup4,
  cust_group5 AS AdditionalCustomerGroup5,
  Plant,
  catlvlguid01_01 AS ServiceSchema1Category1UUID,
  catlvlguid02_01 AS ServiceSchema1Category2UUID,
  catlvlguid03_01 AS ServiceSchema1Category3UUID,
  catlvlguid04_01 AS ServiceSchema1Category4UUID,
  catlvlguid05_01 AS ServiceSchema1Category5UUID,
  catlvlguid06_01 AS ServiceSchema1Category6UUID,
  catlvlguid07_01 AS ServiceSchema1Category7UUID,
  catlvlguid08_01 AS ServiceSchema1Category8UUID,
  catlvlguid09_01 AS ServiceSchema1Category9UUID,
  catlvlguid10_01 AS ServiceSchema1Category10UUID,
  asp_id_01 AS SrvcCatztnSchema1,
  cat_id_01 AS SrvcCatztnSchemaCategory1,
  catlvlguid01_02 AS ServiceSchema2Category1UUID,
  catlvlguid02_02 AS ServiceSchema2Category2UUID,
  catlvlguid03_02 AS ServiceSchema2Category3UUID,
  catlvlguid04_02 AS ServiceSchema2Category4UUID,
  catlvlguid05_02 AS ServiceSchema2Category5UUID,
  catlvlguid06_02 AS ServiceSchema2Category6UUID,
  catlvlguid07_02 AS ServiceSchema2Category7UUID,
  catlvlguid08_02 AS ServiceSchema2Category8UUID,
  catlvlguid09_02 AS ServiceSchema2Category9UUID,
  catlvlguid10_02 AS ServiceSchema2Category10UUID,
  asp_id_02 AS SrvcCatztnSchema2,
  cat_id_02 AS SrvcCatztnSchemaCategory2,
  billplan_d_rule_period_date AS SettlementPeriodRuleUUID,
  billplan_d_rule_bill_date AS BillingPlanBillingDateRuleUUID,
  billplan_d_rule_price_date AS BillingPlanPriceDateRule,
  BillingPlanIsFinalized,
  sales_org AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  dis_channel AS DistributionChannel,
  Division,
  sales_org_resp AS ResponsibleSalesOrganization,
  service_org AS ServiceOrganization,
  service_org_resp AS ResponsibleServiceOrganization,
  sales_org_sd AS SalesOrganization,
  sales_office_sd AS SalesOffice,
  sales_group_sd AS SalesGroup,
  service_team_rm AS RespyMgmtServiceTeam,
  enterprise_service_org AS EnterpriseServiceOrganization,
  proj_org_id AS EnterpriseProjectServiceOrg,
  srv_cust_beg AS RequestedServiceStartDateTime,
  srv_cust_end AS RequestedServiceEndDateTime,
  contstart AS ServiceContrItemStartDateTime,
  contend AS ServiceContrItemEndDateTime,
  srv_rfirst AS ServiceFirstResponseByDateTime,
  srv_rready AS SrvcDocItemSLADueByDateTime,
  srvc_actual AS ActualServiceStartDateTime,
  srvc_act_to AS ActualServiceEndDateTime,
  srq_work_dura AS ServiceWorkDuration,
  srq_work_dura_2 AS ServiceWorkDuration_2,
  srq_work_unit AS ServiceWorkDurationUnit,
  cont_start_ts AS SrvcDocItmTmeSliceStrtDteTme,
  cont_end_ts AS SrvcDocItmTmeSliceEndDteTme,
  auto_renew_start AS SrvcContrItemRenewalDateTime,
  auto_renew_period AS SrvcContrItemRnwlDuration,
  auto_renew_period_unit AS SrvcContrItemRnwlDurationUnit,
  auto_renew_exten AS SrvcContrItemExtensionDuration,
  auto_renew_exten_unit AS SrvcContrItemExtnDurationUnit,
  spla_planfr AS PlannedServiceStartDateTime,
  spla_planto AS PlannedServiceEndDateTime,
  grace_period AS SrvcDocItemGracePeriod,
  grace_period_unit AS SrvcDocItemGracePeriodUnit,
  grace_period_end AS SrvcDocItmGrcePerdEndDateTime,
  biz_valid_start AS SbscrContrItmBizValdStrtDteTme,
  biz_valid_end AS SbscrContrItmBizValdEndDteTme,
  itm_usage AS SrvcDocSubitemOrigin,
  itm_type_usage AS SrvcDocItemCategoryUsage,
  cast(ac_object_type as crmt_ac_object_type_no_conv preserving type ) AS SrvcDocItmAcctAssgmtObjectType,
  ac_assignment AS SrvcDocItmAcctAssgmtObject,
  srv_conf_time AS ActualServiceDuration,
  srv_conf_tunit AS ActualServiceDurationUnit,
  confirm_relevant AS SrvcOrderConfirmationRelevance,
  service_type AS ServiceTransactionChargeType,
  valuation_type AS SrvcTransactionValuationType,
  srv_escal AS ResponseProfile,
  srv_serwi AS ServiceProfile,
  duration AS ServiceDuration,
  duration_unit AS ServiceDurationUnit,
  overtime_cat AS TimeSheetOvertimeCategory,
  warranty_id AS MasterWarranty,
  contract_account AS ContractAccount,
  probability AS ItemOrderProbabilityInPercent,
  stat_accepted AS QuotationIsAccepted,
  int_obj_no AS ConfigurationNumber,
  incoterms1 AS IncotermsPart1,
  incoterms2 AS IncotermsPart2,
  dlv_prio AS DeliveryPriority,
  ordercombind AS OrderCombinationIsAllowed,
  part_dlv_itm AS PartialDeliveryIsAllowed,
  ci_billing_cycle AS CABillgCycle,
  revacc_refid AS RevenueAccountingReference,
  revacc_reftype AS RevenueAccountingRefType,
  gross_weight_i AS ItemGrossWeight,
  net_weight_i AS ItemNetWeight,
  weight_unit_i AS ItemWeightUnit,
  volume_i AS ItemVolume,
  volume_unit_i AS ItemVolumeUnit,
  price_grp AS MaterialPricingGroup,
  price_grp AS CustomerPriceGroup,
  dlv_group AS DeliveryGroup,
  delivery_block AS DeliveryBlockReason,
  first_conf_date AS ErlstConfirmedDeliveryDateTime,
  latest_conf_date AS LtstConfirmedDeliveryDateTime,
  cast(first_req_date as tzntstmps) AS RequestedDeliveryDateTime,
  prod_sel_type AS SubscrpnOrdProdSelType,
  ci_contract_id AS SubscriptionContract,
  btmf_process AS SrvcTransChangeProcess,
  btmf_process_type AS SrvcTransChangeProcessType,
  ci_contract_item AS SrvcTransChgProcSourceItemUUID,
  ma_head_objid AS CustMgmtMasterAgreement,
  ma_item_objid AS CustMgmtMstrAgrmtItem,
  stat_activation AS SubscrpnContrActivationStatus,
  stat_cont_ts AS SubscrpnContrTimeSliceStatus,
  pool_agr_ref AS SharingContractID,
  ccm_version AS CrsCatalogMappingVersionNumber,
  ma_root_objid AS CustMgmtMstrAgrmtParentItem,
  sharing_group_id AS SubscrpnContractSharingGroupID,
  ci_partner_rule AS CAPartnerSettlementRule,
  ChangeProcessGroup,
  phase_indicator AS BusSolutionQtnItemIsPhased,
  successor_of AS BusSolnQtnItmPhasedPrdcssrItem,
  cont_ref_item AS SubscriptionContractItem,
  withdrawal_reason AS SrvcDocItemWithdrawalReason,
  refund_code AS SrvcDocItemRefundType,
  recurring_charge AS SrvcDocItmRecrrgChrgNetAmount,
  default_terms_ovrwrt AS SubscrpnContrTrmsAreSpecified,
  midbillcycexprtnallwd AS MidBillgCycExprtnIsAllowed,
  recurring_tax AS SrvcDocItmRecrrgChrgTaxAmount,
  recurring_gross AS SrvcDocItmRecrrgChrgGrossAmt,
  rec_duration AS SrvcDocItmRecrrgChrgDuration,
  rec_time_unit AS SrvcDocItmRecrrgChrgDurnUnit,
  cont_ref AS SubscriptionContractReference,
  subscrpnbillgcycle AS SubscriptionBillingCycle,
  SubscriptionContractExternalID,
  ma_share_ref AS SbscrShContrSvTrMtAgrItmUUID,
  ma_share_ref_prod_id AS SbscrShContrSvTrMtAgrItmCstPrd,
  ci_billing_plan_cycle AS SubscrpnContrItmBillgPlnCyc,
  cancparty AS ServiceDocumentItemCanclnParty,
  canc_reason AS ServiceDocumentItmCanclnReason,
  cancproc AS SrvcDocItmCanclnProcedure,
  auto_renew_period AS ServiceDocumentRnwlDuration,
  auto_renew_period_unit AS ServiceDocRnwlDurationUnit,
  auto_renew_exten AS ServiceDocExtensionDuration,
  auto_renew_exten_unit AS ServiceDocExtnDurationUnit,
  auto_renew_indicator AS SubscrpnContrAutoRnwlIsActv,
  ref_inhouse_repair AS ReferenceInHouseRepair,
  ref_inhouse_repair_item AS ReferenceInHouseRepairItem,
  has_ref_inhouse_repair AS RefInHouseRepairIsExisting,
  bom_item_node_number AS BillOfMaterialItemNodeNumber,
  stat_credit AS SrvcDocItemCreditStatus,
  stat_gts_embargo AS SrvcDocItmGTSEmbargoStatus,
  stat_gts_screening AS SrvcDocItmGTSScreeningStatus,
  stat_gts_legal_control AS SrvcDocItmGTSLglControlStatus,
  stat_bsln_cost_postg AS SrvcDocItmBslnCostPostgStatus,
  stat_cont_cost_calc AS SrvcDocItmContinuousCostStatus,
  is_unplanned_item AS SrvcDocItemIsUnplanned,
  ship_cond AS ShippingCondition,
  subst_reason AS MaterialSubstitutionReason,
  item_no_partner AS SrvcDocItmPartReferenceItem,
  ref_guid_appt AS SrvcDocItmApptRefObjectUUID,
  item_no_appt AS SrvcDocItmApptReferenceItem
FROM crms4d_serv_i
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _RespEmployee ON ResponsibleEmployee = _RespEmployee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServiceTeam ON ServiceTeam = _ServiceTeam.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServiceEmployee ON ServiceEmployee = _ServiceEmployee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContactPerson ON ContactPerson = _ContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _PayerParty ON PayerParty = _PayerParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BillToParty ON BillToParty = _BillToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocItemCategory AS _ServiceDocItemCategory ON ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentPriority AS _ServiceDocItemPriority ON ServiceDocumentItemPriority = _ServiceDocItemPriority.ServiceDocumentPriority  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentStatus AS _ServiceDocItemStatus ON ServiceDocumentItemStatus = _ServiceDocItemStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocLifecycleStatus AS _SrvcDocItmLifecycleStatus ON ServiceDocumentItemStatus = _SrvcDocItmLifecycleStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocBillingStatus AS _ServiceDocItemBillingStatus ON ServiceDocItemBillingStatus = _ServiceDocItemBillingStatus.ServiceDocBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocRelForBillgSts AS _SrvcDocItemIsRelForBillgSts ON SrvcDocItmIsReleasedForBilling = _SrvcDocItemIsRelForBillgSts.ServiceDocIsReleasedForBilling  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocErrorStatus AS _ServiceDocItemHasError ON ServiceDocumentItemHasError = _ServiceDocItemHasError.ServiceDocumentHasError  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocOpenStatus AS _ServiceDocumentIsOpen ON ServiceDocumentItemIsOpen = _ServiceDocumentIsOpen.ServiceDocumentIsOpen  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _ServiceDocument ON ServiceObjectType = _ServiceDocument.ServiceObjectType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [1..1]
LEFT OUTER JOIN I_CustMgmtBusObjType AS _ServiceObjType ON ServiceObjectType = _ServiceObjType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReason ON BillingBlockReason = _BillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingRequestItem AS _BillingRequestItem ON ServiceObjectType = _BillingRequestItem.ServiceObjectType AND ServiceDocument = _BillingRequestItem.ServiceDocument AND ServiceDocumentItem = _BillingRequestItem.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_ServiceProductList AS _ServiceProductList ON ServiceObjectType = _ServiceProductList.ServiceObjectType AND ServiceDocument = _ServiceProductList.ServiceDocument AND ServiceDocumentItem = _ServiceProductList.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON ServiceDocItemQuantityUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit_2 ON SrvcDocItemBaseQuantityUnit = _BaseUnit_2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SalesUnit ON ServiceDocItemQuantityUnit = _SalesUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ServiceDurationUnit ON ServiceDurationUnit = _ServiceDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualServiceDurationUnit ON ActualServiceDurationUnit = _ActualServiceDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SrvcContrItemExtnDurationUnit ON SrvcContrItemExtnDurationUnit = _SrvcContrItemExtnDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SrvcContrItemRnwlDurationUnit ON SrvcContrItemRnwlDurationUnit = _SrvcContrItemRnwlDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON ItemVolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON ItemWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocPaymentMethod AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND ( SalesOrganization = _PaymentMethod.SalesOrganization OR SalesOrganizationOrgUnitID = _PaymentMethod.OrgUnitTypeIDConcatenated )  -- association [0..1]
LEFT OUTER JOIN I_SrvcSEPAMandateRelevance AS _SrvcSEPAMandateRelevance ON SrvcSEPAMandateRelevance = _SrvcSEPAMandateRelevance.SrvcSEPAMandateRelevance  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentFixedPrice AS _FixedPrice ON ServiceObjectType = _FixedPrice.ServiceObjectType AND ServiceDocument = _FixedPrice.ServiceDocument AND ServiceDocumentItem = _FixedPrice.PricingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _StatusObjItemStatus ON ServiceDocumentItemUUID = _StatusObjItemStatus.StatusObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _ServiceOrganizationOrgUnit ON ServiceOrganization = _ServiceOrganizationOrgUnit.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _RespSrvcOrganizationOrgUnit ON ResponsibleServiceOrganization = _RespSrvcOrganizationOrgUnit.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesOrganizationOrgUnit ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesOfficeOrgUnit ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesGroupOrgUnit ON SalesGroupOrgUnitID = _SalesGroupOrgUnit.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOrganizationOrgUnit_2 ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOfficeOrgUnit_2 ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesGroupOrgUnit_2 ON SalesGroupOrgUnitID = _SalesGroupOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ServiceOrganizationOrgUnit_2 ON ServiceOrganization = _ServiceOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _RespSrvcOrganizationOrgUnit_2 ON ResponsibleServiceOrganization = _RespSrvcOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _ServiceDocOvertimeCat ON TimeSheetOvertimeCategory = _ServiceDocOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _Industry ON Industry = _Industry.Industry  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _ServiceDocItemRejectionReason ON ServiceDocItemRejectionReason = _ServiceDocItemRejectionReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_Region AS _SoldToPartyRegion ON SoldToPartyRegion = _SoldToPartyRegion.Region AND SoldToPartyCountry = _SoldToPartyRegion.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SoldToPartyCountry ON SoldToPartyCountry = _SoldToPartyCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseServiceOrg AS _EnterpriseServiceOrg ON EnterpriseServiceOrganization = _EnterpriseServiceOrg.EnterpriseServiceOrganization  -- 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_CustMgmtDateRule AS _BillPlanDateRule ON BillingPlanBillingDateRuleUUID = _BillPlanDateRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementDateRule ON SettlementPeriodRuleUUID = _SettlementDateRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_ResponseProfile AS _ResponseProfile ON ResponseProfile = _ResponseProfile.ResponseProfile  -- association [0..1]
LEFT OUTER JOIN I_ServiceProfile AS _ServiceProfile ON ServiceProfile = _ServiceProfile.ServiceProfile  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnItmTechResource AS _TechResource ON ServiceObjectType = _TechResource.ServiceObjectType AND ServiceDocument = _TechResource.ServiceDocument AND ServiceDocumentItem = _TechResource.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtMasterAgrmtItem AS _MasterAgrmtItem ON _MasterAgrmtItem.ServiceObjectType = 'BUS2000267' AND CustMgmtMasterAgreement = _MasterAgrmtItem.CustMgmtMasterAgreement AND CustMgmtMstrAgrmtItem = _MasterAgrmtItem.CustMgmtMstrAgrmtItem  -- association [0..1]
LEFT OUTER JOIN I_BillableControl AS _BillableControl ON BillableControl = _BillableControl.BillableControl  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtProductHierarchy AS _SrvcMgmtProductHierarchy ON ProductHierarchy = _SrvcMgmtProductHierarchy.SrvcProductHierarchy  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _SrvcMaterialPricingGroup ON SrvcMaterialPricingGroup = _SrvcMaterialPricingGroup.MaterialPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialPricingGroup AS _MaterialPricingGroup_2 ON MaterialPricingGroup_2 = _MaterialPricingGroup_2.MaterialPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1 ON ProductGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2 ON ProductGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3 ON ProductGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4 ON ProductGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5 ON ProductGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocTransferStatus AS _SrvcDocItemTransferStatus ON SrvcDocItemTransferStatus = _SrvcDocItemTransferStatus.SrvcDocTransferStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemCreditStatus AS _SrvcDocItemCreditStatus ON SrvcDocItemCreditStatus = _SrvcDocItemCreditStatus.SrvcDocItemCreditStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItmGTSStatus AS _SrvcDocItmGTSEmbargoStatus ON SrvcDocItmGTSEmbargoStatus = _SrvcDocItmGTSEmbargoStatus.SrvcDocItmGTSStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItmGTSStatus AS _SrvcDocItmGTSLglControlStatus ON SrvcDocItmGTSLglControlStatus = _SrvcDocItmGTSLglControlStatus.SrvcDocItmGTSStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItmGTSStatus AS _SrvcDocItmGTSScreeningStatus ON SrvcDocItmGTSScreeningStatus = _SrvcDocItmGTSScreeningStatus.SrvcDocItmGTSStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItmBslnCostPostgStat AS _SrvcDocItmBslnCostPostgStat ON SrvcDocItmBslnCostPostgStatus = _SrvcDocItmBslnCostPostgStat.SrvcDocItmBslnCostPostgStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItmBslnCostPostgStat AS _SrvcDocItmContinuousCostStat ON SrvcDocItmContinuousCostStatus = _SrvcDocItmContinuousCostStat.SrvcDocItmBslnCostPostgStatus  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocExecutionStatus AS _SrvcDocExecutionStatus ON SrvcDocItemExecutionStatus = _SrvcDocExecutionStatus.SrvcDocExecutionStatus AND ServiceDocumentItemIsQuotation = _SrvcDocExecutionStatus.ServiceDocumentIsQuotation  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _SrvcDocIsQuotation ON ServiceDocumentItemIsQuotation = _SrvcDocIsQuotation.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_SrvcDocItemBillgRlvnce AS _SrvcDocItemBillgRlvnce ON SrvcDocItmBillingRelevance = _SrvcDocItemBillgRlvnce.SrvcDocItmBillingRelevance  -- association [1..1]
LEFT OUTER JOIN I_SrvcMgmtBillgPlanTemplate AS _SrvcMgmtBillgPlanTemplate ON SrvcDocBillingPlanTemplate = _SrvcMgmtBillgPlanTemplate.SrvcDocBillingPlanTemplate  -- association [0..1]
;