A_BusSolnQtanSubscrpnItem

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 A_BusSolnQtanSubscrpnItem.
-- 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 A_BusSolnQtanSubscrpnItem AS
SELECT
  ServiceDocument AS BusinessSolutionQuotation,
  ServiceDocumentItem AS BusSolutionQuotationItem,
  ServiceDocumentItemUUID AS BusSolnQuotationItemUUID,
  ServiceDocItemCategory AS BusSolnQtanItemCategory,
  OriginallyRequestedProduct AS Product,
  MaterialByCustomer,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  ServiceDocumentItemDescription AS BusSolnQtanItemDescription,
  Language,
  ItemOrderProbabilityInPercent,
  ServiceDocumentItemIsReleased AS BusSolnQtanItemIsReleased,
  QuotationIsAccepted AS BusSolnQtanItemIsAccepted,
  ServiceDocumentItemIsRejected AS BusSolnQtanItemIsRejected,
  ServiceDocItemRejectionReason AS BusSolnQtanItmRjcnReason,
  SrvcDocItemCreditStatus AS BusSolnQtanItemCreditStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ResponsibleEmployee AS PersonResponsible,
  ContactPerson,
  cast( '' as ad_addrnum ) AS ShipToPartyAddressID,
  cast( '' as ad_addrnum ) AS BillToPartyAddressIdentifier,
  case when _PayerPartyDetails.AddressID is null then _PayerPartyDetailsHeader.AddressID else _PayerPartyDetails.AddressID end AS PayerToPartyAddressIdentifier,
  PaymentTerms,
  CABillgCycle,
  cast ( 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(_ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnitISOCode as crms4_som_ext_dur_isocd_unit preserving type ) AS SbscrContrItmExtnDurnUntISOCd,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnitSAPCode as crms4_som_ext_dur_meinsint ) AS SbscrContrItmExtnDurnUntSAPCd,
  cast ( ServiceContrItemEndDateTime as crms4_cont_end_dec15 preserving type ) AS SubscrpnContrItmEndDateTime,
  SubscrpnContrAutoRnwlIsActv,
  _ServDocDuration[1:SrvcDocDurationType = 'AR_EXTENSION'].SrvcDocDurationValue AS SubscrpnContrAutoRnwlDurn,
  _ServDocDuration[1:SrvcDocDurationType = 'AR_EXTENSION'].SrvcDocDurationUnit AS SubscrpnContrAutoRnwlDurnUnit,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'AR_EXTENSION'].SrvcDocDurationUnitISOCode as crms4_ar_dur_isocd_unit preserving type ) AS SbscrContrArnwlDurnUntISOCode,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'AR_EXTENSION'].SrvcDocDurationUnitSAPCode as crms4_ar_dur_meinsint ) AS SbscrContrArnwlDurnUntSAPCode,
  SrvcContrItemRnwlDuration AS SubscrpnContrArnwlStrtDurn,
  SrvcContrItemRnwlDurationUnit AS SubscrpnContrArnwlStrtDurnUnit,
  cast( _UoMAutoRnwlStartDurationUnit.UnitOfMeasureISOCode as crms4_ar_strt_isocd_unit preserving type ) AS SbsConArnwlStrtDurnUntISOCode,
  cast( _UoMAutoRnwlStartDurationUnit.UnitOfMeasureSAPCode as crms4_ar_strt_meinsint preserving type ) AS SbsConArnwlStrtDurnUntSAPCode,
  SrvcDocItmTmeSliceStrtDteTme AS SbscrContrTimeSliceStrtDteTme,
  SrvcDocItmTmeSliceEndDteTme AS SbscrContrTimeSliceEndDteTme,
  SrvcContrItemRenewalDateTime AS SubscrpnContrItmRnwlDteTme,
  SbscrContrItmBizValdStrtDteTme,
  SbscrContrItmBizValdEndDteTme,
  SrvcDocItmGrcePerdEndDateTime AS SbscrContrItmGrcePerdDteTme,
  _ServDocDuration[1:SrvcDocDurationType = 'GRACE_PERIOD'].SrvcDocDurationValue AS SbscrContrItmGrcePerd,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'GRACE_PERIOD'].SrvcDocDurationUnitISOCode as crms4_som_grce_dur_isocd_unit preserving type ) AS SbscrContrItmGrcePerdUntISOCd,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'GRACE_PERIOD'].SrvcDocDurationUnitSAPCode as crms4_som_grce_dur_meinsint ) AS SbscrContrItmGrcePerdUntSAPCd,
  ContractAccount,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  CrsCatalogMappingVersionNumber,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  ConfigurationNumber,
  ChangeProcessGroup,
  BusSolutionQtnItemIsPhased,
  BusSolnQtnItmPhasedPrdcssrItem,
  SubscriptionContractItem,
  SubscriptionContractReference,
  ServiceDocumentItemCanclnParty AS SbscrContrItemCanclnParty,
  ServiceDocumentItmCanclnReason AS SbscrContrItemCanclnReason,
  SrvcDocItmCanclnProcedure AS SbscrContrItmCanclnProcedure,
  cast( 0 as abap.dec(15) ) AS SbscrContrItmCanclnRecDateTime,
  cast( 0 as abap.dec(15) ) AS SbscrContrItmCanclnReqDateTime,
  TransactionCurrency,
  SrvcDocItmRecrrgChrgNetAmount,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  cast( '' as crms4_som_rc_ch_dur_isocd_unit ) AS SrvcDocItmRcrChrDurUnitISOCode,
  cast( '' as crms4_som_rc_ch_dur_meinsint ) AS SrvcDocItmRcrChrDurUnitSAPCode,
  PurchaseOrderByShipToParty,
  SubscrpnContrItmBillgPlnCyc,
  BillOfMaterialItemNodeNumber,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime,
  PriceReferenceCPQQuotation,
  PriceReferenceCPQQuotationItem,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  MaterialSubstitutionReason,
  I_ServiceDocumentItemEnhcd.SubscriptionContract AS CAProviderContract,
  _ExternalReference.BusSolnQtanItemExtReference AS BusSolnQtanItemExtReference,
  _LegalCntrctItmExtReference.LegalContractItemExtReference AS LegalContractItemExtReference,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnQuotationItem,
  _SettlementPeriodRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS RequestedQuantitySAPUnit
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_BusSolnQtanItmPriceElement AS _PriceElement ON BusinessSolutionQuotation = _PriceElement.BusinessSolutionQuotation AND BusSolutionQuotationItem = _PriceElement.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemText AS _Text ON BusSolutionQuotationItem = _Text.BusSolutionQuotationItem AND BusinessSolutionQuotation = _Text.BusinessSolutionQuotation  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemTechRsce AS _TechnicalResource ON BusinessSolutionQuotation = _TechnicalResource.BusinessSolutionQuotation AND BusSolutionQuotationItem = _TechnicalResource.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BSQItmTechRsceWithSlot AS _TechnicalResourceWithSlot ON BusinessSolutionQuotation = _TechnicalResourceWithSlot.BusinessSolutionQuotation AND BusSolutionQuotationItem = _TechnicalResourceWithSlot.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BuSoQtanItmFUPSubscrpnContr AS _SubscriptionContract ON BusinessSolutionQuotation = _SubscriptionContract.BusinessSolutionQuotation AND BusSolutionQuotationItem = _SubscriptionContract.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusinessSolutionQuotation AS _BusinessSolutionQuotation ON BusinessSolutionQuotation = _BusinessSolutionQuotation.BusinessSolutionQuotation  -- association [1..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 E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND BusinessSolutionQuotation = _Extension.ServiceOrderItem AND BusSolutionQuotationItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN A_BusSolnQtanItemDteParam AS _DateParameters ON BusinessSolutionQuotation = _DateParameters.BusinessSolutionQuotation AND BusSolutionQuotationItem = _DateParameters.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemStrParam AS _StringParameters ON BusinessSolutionQuotation = _StringParameters.BusinessSolutionQuotation AND BusSolutionQuotationItem = _StringParameters.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemNmrcParam AS _NumericParameters ON BusinessSolutionQuotation = _NumericParameters.BusinessSolutionQuotation AND BusSolutionQuotationItem = _NumericParameters.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItemTblParam AS _TableParameters ON BusinessSolutionQuotation = _TableParameters.BusinessSolutionQuotation AND BusSolutionQuotationItem = _TableParameters.BusSolutionQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnQtanItmConfign AS _Configurations ON ConfigurationNumber = _Configurations.VariantConfigurationInstance AND _Configurations.VarConfignInstceBusObjectType = 'CRM_OR_ITM'  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtPartner AS _ShipToDetails ON _ShipToDetails.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _ShipToDetails.CustMgmtDocument AND BusSolutionQuotationItem = _ShipToDetails.CustMgmtDocumentItem AND ShipToParty = _ShipToDetails.CustMgmtBusinessPartner AND _ShipToDetails.CustMgmtPartFunctionCategory = '0002'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _BillToDetails ON _BillToDetails.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _BillToDetails.CustMgmtDocument AND BusSolutionQuotationItem = _BillToDetails.CustMgmtDocumentItem AND BillToParty = _BillToDetails.CustMgmtBusinessPartner AND _BillToDetails.CustMgmtPartFunctionCategory = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _PayerPartyDetails ON _PayerPartyDetails.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _PayerPartyDetails.CustMgmtDocument AND BusSolutionQuotationItem = _PayerPartyDetails.CustMgmtDocumentItem AND PayerParty = _PayerPartyDetails.CustMgmtBusinessPartner AND _PayerPartyDetails.CustMgmtPartFunctionCategory = '0004'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ShipToDetailsHeader ON _ShipToDetailsHeader.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _ShipToDetailsHeader.CustMgmtDocument AND _ShipToDetailsHeader.CustMgmtDocumentItem = '000000' AND ShipToParty = _ShipToDetailsHeader.CustMgmtBusinessPartner AND _ShipToDetailsHeader.CustMgmtPartFunctionCategory = '0002'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _BillToDetailsHeader ON _BillToDetailsHeader.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _BillToDetailsHeader.CustMgmtDocument AND _BillToDetailsHeader.CustMgmtDocumentItem = '000000' AND BillToParty = _BillToDetailsHeader.CustMgmtBusinessPartner AND _BillToDetailsHeader.CustMgmtPartFunctionCategory = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _PayerPartyDetailsHeader ON _PayerPartyDetailsHeader.CustMgmtObjectType = 'BUS2000116' AND BusinessSolutionQuotation = _PayerPartyDetailsHeader.CustMgmtDocument AND _PayerPartyDetailsHeader.CustMgmtDocumentItem = '000000' AND PayerParty = _PayerPartyDetailsHeader.CustMgmtBusinessPartner AND _PayerPartyDetailsHeader.CustMgmtPartFunctionCategory = '0004'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoMAutoRnwlStartDurationUnit ON I_ServiceDocumentItemEnhcd.SrvcContrItemRnwlDurationUnit = _UoMAutoRnwlStartDurationUnit.UnitOfMeasure  -- 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 I_ServiceDocumentItemEnhcd.SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN A_BusSolnQtanItmBillgReqItem AS _BillingRequestItem ON BusinessSolutionQuotation = _BillingRequestItem.BusinessSolutionQuotation AND BusSolutionQuotationItem = _BillingRequestItem.BusSolutionQuotationItem  -- association [0..*]
;