C_BusSolnQtanItemDEX

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_BusSolnQtanItemDEX.
-- 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 C_BusSolnQtanItemDEX AS
SELECT
  BusSolnQtanItemDEX.ServiceDocument AS BusinessSolutionQuotation,
  BusSolnQtanItemDEX.ServiceDocumentItem AS BusSolutionQuotationItem,
  BusSolnQtanItemDEX.ServiceObjectType AS ServiceObjectType,
  BusSolnQtanItemDEX.ServiceDocumentItemUUID AS BusSolnQuotationItemUUID,
  BusSolnQtanItemDEX._ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnQuotationItem,
  BusSolnQtanItemDEX.ServiceDocItemCategory AS BusSolnQtanItemCategory,
  BusSolnQtanItemDEX.Product AS Product,
  BusSolnQtanItemDEX.MaterialByCustomer AS MaterialByCustomer,
  BusSolnQtanItemDEX.ServiceDocumentItemQuantity AS Quantity,
  BusSolnQtanItemDEX.ServiceDocItemQuantityUnit AS QuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS RequestedQuantitySAPUnit,
  BusSolnQtanItemDEX.ServiceDocumentItemDescription AS BusSolnQtanItemDescription,
  BusSolnQtanItemDEX.Language AS Language,
  _ExternalReference.BusSolnQtanItemExtReference AS BusSolnQtanItemExtReference,
  _LegalCntrctItmExtReference.LegalContractItemExtReference AS LegalContractItemExtReference,
  BusSolnQtanItemDEX.ItemOrderProbabilityInPercent AS ItemOrderProbabilityInPercent,
  BusSolnQtanItemDEX.ServiceDocumentItemIsReleased AS BusSolnQtanItemIsReleased,
  BusSolnQtanItemDEX.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  BusSolnQtanItemDEX.QuotationIsAccepted AS BusSolnQtanItemIsAccepted,
  BusSolnQtanItemDEX.ServiceDocumentItemIsRejected AS BusSolnQtanItemIsRejected,
  BusSolnQtanItemDEX.ServiceDocItemRejectionReason AS BusSolnQtanItmRjcnReason,
  BusSolnQtanItemDEX.SrvcDocItemCreditStatus AS BusSolnQtanItemCreditStatus,
  BusSolnQtanItemDEX.SoldToParty AS SoldToParty,
  BusSolnQtanItemDEX.ShipToParty AS ShipToParty,
  BusSolnQtanItemDEX.BillToParty AS BillToParty,
  BusSolnQtanItemDEX.PayerParty AS PayerParty,
  BusSolnQtanItemDEX.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  BusSolnQtanItemDEX.ContactPerson AS ContactPersonBusinessPartnerId,
  BusSolnQtanItemDEX.PaymentTerms AS PaymentTerms,
  BusSolnQtanItemDEX.CAPartnerSettlementRule AS CAPartnerSettlementRule,
  BusSolnQtanItemDEX.CABillgCycle AS CABillgCycle,
  BusSolnQtanItemDEX.IncotermsPart1 AS IncotermsPart1,
  BusSolnQtanItemDEX.IncotermsPart2 AS IncotermsPart2,
  BusSolnQtanItemDEX.DeliveryPriority AS DeliveryPriority,
  BusSolnQtanItemDEX.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  BusSolnQtanItemDEX.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  BusSolnQtanItemDEX.BillingBlockReason AS BillingBlockReason,
  BusSolnQtanItemDEX.ServiceTransactionChargeType AS ServiceTransactionChargeType,
  BusSolnQtanItemDEX.SrvcTransactionValuationType AS SrvcTransactionValuationType,
  BusSolnQtanItemDEX.ServiceProfile AS ServiceProfile,
  BusSolnQtanItemDEX.ResponseProfile AS ResponseProfile,
  BusSolnQtanItemDEX.MasterWarranty AS MasterWarranty,
  BusSolnQtanItemDEX.BillableControl AS BillableControl,
  BusSolnQtanItemDEX.PlannedServiceStartDateTime AS PlannedServiceStartDateTime,
  BusSolnQtanItemDEX.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  BusSolnQtanItemDEX.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  BusSolnQtanItemDEX.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  cast ( BusSolnQtanItemDEX.ServiceContrItemStartDateTime as crms4_cont_start_dec15 preserving type ) AS ServiceContrItemStartDateTime,
  cast ( BusSolnQtanItemDEX.ServiceContrItemEndDateTime as crms4_cont_end_dec15 preserving type ) AS ServiceContrItemEndDateTime,
  BusSolnQtanItemDEX._BillPlanDateRule.CustMgmtDateRuleName AS SrvcMgmtBillgPlanBillgDateRule,
  BusSolnQtanItemDEX._SettlementDateRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  cast ( BusSolnQtanItemDEX.ServiceContrItemStartDateTime as crms4_cont_start_dec15 preserving type ) AS SubscrpnContrItmStartDateTime,
  _ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationValue AS SubscrpnContrItemExtnDuration,
  _ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnit AS SubscrpnContrItemExtnDurnUnit,
  cast ( BusSolnQtanItemDEX.ServiceContrItemEndDateTime as crms4_cont_end_dec15 preserving type ) AS SubscrpnContrItmEndDateTime,
  BusSolnQtanItemDEX.SubscrpnContrAutoRnwlIsActv AS SubscrpnContrAutoRnwlIsActv,
  BusSolnQtanItemDEX.SrvcDocItmTmeSliceStrtDteTme AS SbscrContrTimeSliceStrtDteTme,
  BusSolnQtanItemDEX.SrvcDocItmTmeSliceEndDteTme AS SbscrContrTimeSliceEndDteTme,
  BusSolnQtanItemDEX.SbscrContrItmBizValdStrtDteTme AS SbscrContrItmBizValdStrtDteTme,
  BusSolnQtanItemDEX.SbscrContrItmBizValdEndDteTme AS SbscrContrItmBizValdEndDteTme,
  BusSolnQtanItemDEX.ContractAccount AS ContractAccount,
  BusSolnQtanItemDEX.RevenueAccountingReference AS RevenueAccountingReference,
  BusSolnQtanItemDEX.RevenueAccountingRefType AS RevenueAccountingRefType,
  BusSolnQtanItemDEX.CrsCatalogMappingVersionNumber AS CrsCatalogMappingVersionNumber,
  BusSolnQtanItemDEX.CustMgmtMasterAgreement AS CustMgmtMasterAgreement,
  BusSolnQtanItemDEX.CustMgmtMstrAgrmtItem AS CustMgmtMstrAgrmtItem,
  BusSolnQtanItemDEX.CustMgmtMstrAgrmtParentItem AS CustMgmtMstrAgrmtParentItem,
  BusSolnQtanItemDEX.SharingContractID AS SharingContractID,
  BusSolnQtanItemDEX.SubscrpnContractSharingGroupID AS SubscrpnContractSharingGroupID,
  cast(BusSolnQtanItemDEX.ConfigurationNumber as cuobj preserving type ) AS ConfigurationNumber,
  BusSolnQtanItemDEX.SubscriptionContract AS CAProviderContract,
  BusSolnQtanItemDEX.ChangeProcessGroup AS ChangeProcessGroup,
  BusSolnQtanItemDEX.BusSolutionQtnItemIsPhased AS BusSolutionQtnItemIsPhased,
  BusSolnQtanItemDEX.BusSolnQtnItmPhasedPrdcssrItem AS BusSolnQtnItmPhasedPrdcssrItem,
  BusSolnQtanItemDEX.SubscriptionContractItem AS SubscriptionContractItem,
  BusSolnQtanItemDEX.SubscriptionContractReference AS SubscriptionContractReference,
  BusSolnQtanItemDEX.ServiceDocumentItemCanclnParty AS SbscrContrItemCanclnParty,
  BusSolnQtanItemDEX.ServiceDocumentItmCanclnReason AS SbscrContrItemCanclnReason,
  BusSolnQtanItemDEX.SrvcDocItmCanclnProcedure AS SbscrContrItmCanclnProcedure,
  BusSolnQtanItemDEX.TransactionCurrency AS TransactionCurrency,
  BusSolnQtanItemDEX.SrvcDocItmRecrrgChrgNetAmount AS SrvcDocItmRecrrgChrgNetAmount,
  BusSolnQtanItemDEX.SrvcDocItmRecrrgChrgTaxAmount AS SrvcDocItmRecrrgChrgTaxAmount,
  BusSolnQtanItemDEX.SrvcDocItmRecrrgChrgGrossAmt AS SrvcDocItmRecrrgChrgGrossAmt,
  BusSolnQtanItemDEX.SrvcDocItmRecrrgChrgDuration AS SrvcDocItmRecrrgChrgDuration,
  BusSolnQtanItemDEX.SrvcDocItmRecrrgChrgDurnUnit AS SrvcDocItmRecrrgChrgDurnUnit,
  BusSolnQtanItemDEX.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  BusSolnQtanItemDEX.SubscrpnContrItmBillgPlnCyc AS SubscrpnContrItmBillgPlnCyc,
  BusSolnQtanItemDEX.WBSElement AS WBSElementExternalID,
  BusSolnQtanItemDEX.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BusSolnQtanItemDEX.PriceReferenceCPQQuotation AS PriceReferenceCPQQuotation,
  BusSolnQtanItemDEX.PriceReferenceCPQQuotationItem AS PriceReferenceCPQQuotationItem,
  BusSolnQtanItemDEX.SrvcDocItmGTSEmbargoStatus AS SrvcDocItmGTSEmbargoStatus,
  BusSolnQtanItemDEX.SrvcDocItmGTSScreeningStatus AS SrvcDocItmGTSScreeningStatus,
  BusSolnQtanItemDEX.SrvcDocItmGTSLglControlStatus AS SrvcDocItmGTSLglControlStatus,
  BusSolnQtanItemDEX.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  case when BusSolnQtanItemDEX.MaterialSubstitutionReason <> '' then BusSolnQtanItemDEX.Product else '' end as SubstituteProduct AS ProductelseendasSubstituteProduct,
  BusSolnQtanItemDEX.ServiceDocumentType AS BusSolutionQuotationType,
  BusSolnQtanItemDEX.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  BusSolnQtanItemDEX.DistributionChannel AS DistributionChannel,
  BusSolnQtanItemDEX.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  BusSolnQtanItemDEX.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  BusSolnQtanItemDEX.SalesOrganization AS SalesOrganization,
  BusSolnQtanItemDEX.Division AS Division,
  BusSolnQtanItemDEX.SalesOffice AS SalesOffice,
  BusSolnQtanItemDEX.SalesGroup AS SalesGroup
FROM I_ServiceDocumentItemEnhcd AS BusSolnQtanItemDEX
INNER JOIN I_BusSolutionQuotationType AS BusSolutionQuotationType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoMAutoRnwlStartDurationUnit ON BusSolnQtanItemDEX.SrvcContrItemRnwlDurationUnit = _UoMAutoRnwlStartDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BusSolnQtanItmExtReference AS _ExternalReference ON BusinessSolutionQuotation = _ExternalReference.BusinessSolutionQuotation AND BusSolutionQuotationItem = _ExternalReference.BusSolutionQuotationItem AND _ExternalReference.BusSolnQtanItemExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN I_BusSolnQtanItmExtReference AS _LegalCntrctItmExtReference ON BusinessSolutionQuotation = _LegalCntrctItmExtReference.BusinessSolutionQuotation AND BusSolutionQuotationItem = _LegalCntrctItmExtReference.BusSolutionQuotationItem AND _LegalCntrctItmExtReference.LegalContractItemExtReference <> ''  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _ServDocDuration ON _ServDocDuration.ServiceObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _ServDocDuration.ServiceDocument AND BusSolutionQuotationItem = _ServDocDuration.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementPeriodRule ON BusSolnQtanItemDEX.SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND BusinessSolutionQuotation = _ServiceDocItemExt.ServiceOrderItem AND BusSolutionQuotationItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;