A_SubscriptionContractItem

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_SubscriptionContractItem.
-- 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_SubscriptionContractItem AS
SELECT
  ServiceDocument AS SubscriptionContract,
  ServiceDocumentItem AS SubscriptionContractItem,
  SubscriptionContract AS SubscriptionContractExternalID,
  ServiceDocItemCategory AS SubscrpnContractItemCategory,
  cast( OriginallyRequestedProduct as abap.char( 40 )) AS Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS RequestedQuantityISOUnit,
  _UnitOfMeasure.UnitOfMeasureSAPCode AS RequestedQuantitySAPUnit,
  TransactionCurrency,
  ServiceDocItemGrossAmount AS SubscrpnContrItmGrossAmount,
  ServiceDocumentItemNetAmount AS SubscrpnContrItmNetAmount,
  ServiceDocumentItemTaxAmount AS SubscrpnContrItmTaxAmount,
  SrvcDocItmRecrrgChrgNetAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  ServiceDocumentItemDescription AS SubscriptionContrItmDesc,
  Language,
  cast('' as crms4_number_int) AS ParentItem,
  cast('' as abap.char(1)) AS SbscrContrItmTmeSliceStatus,
  SrvcDocItmGTSEmbargoStatus AS SbsConItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus AS SbsConItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus AS SbsConItmGTSLglControlStatus,
  SrvcDocItmCanclnProcedure AS SbscrContrItmCanclnProcedure,
  ServiceDocumentItmCanclnReason AS SbscrContrItemCanclnReason,
  ServiceDocumentItemCanclnParty AS SbscrContrItemCanclnParty,
  ServiceDocumentItemIsRejected AS SubscrpnContractItemIsRejected,
  ServiceContrItemStartDateTime AS SubscrpnContrItmStartDateTime,
  ServiceContrItemEndDateTime AS SubscrpnContrItmEndDateTime,
  SrvcDocItmTmeSliceStrtDteTme AS SbscrContrTimeSliceStrtDteTme,
  SrvcDocItmTmeSliceEndDteTme AS SbscrContrTimeSliceEndDteTme,
  _ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationValue AS SubscrpnContrItemDuration,
  _ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnit AS SubscrpnContrItemDurnUnit,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnitISOCode as crms4_som_ctr_dur_isocd_unit preserving type ) AS SubscrpnContrItmDurnUntISOCode,
  cast(_ServDocDuration[1:SrvcDocDurationType = 'CONTDURA'].SrvcDocDurationUnitSAPCode as crms4_som_ctr_dur_meinsint ) AS SubscrpnContrItmDurnUntSAPCode,
  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,
  SrvcContrItemRenewalDateTime AS SubscrpnContrItmRnwlDteTme,
  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,
  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,
  SoldToParty,
  ShipToParty,
  cast( ResponsibleEmployee as abap.char( 12 )) AS PersonResponsible,
  BillToParty,
  PayerParty,
  cast( ContactPerson as abap.numc( 10 )) AS ContactPerson,
  ContractAccount,
  CABillgCycle,
  CrsCatalogMappingVersionNumber,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  ConfigurationNumber,
  ChangeProcessGroup AS SrvcTransChangeProcessGroup,
  SrvcTransChangeProcess,
  BusSolutionQtnItemIsPhased AS SubscrpnContrItemIsPhased,
  BusSolnQtnItmPhasedPrdcssrItem AS SbscrContrItmPhasedPrdcssrItm,
  PurchaseOrderByShipToParty,
  CustPurOrdDateByShipToParty,
  _ExternalReference[1:SubscrpnContrItmRefType = '0018'].SbscrContrPrdcssrExtID AS SbscrContrPrdcssrExtID,
  _ExternalReference[1:SubscrpnContrItmRefType = '0019'].SbscrContrSuccssrExtID AS SbscrContrSuccssrExtID,
  _ExternalReference[1:SubscrpnContrItmRefType = '0021' ].LegalContractExtReference AS LegalContractExtReference,
  _ExternalReference[1:SubscrpnContrItmRefType = '0022' ].LegalContractItemExtReference AS LegalContractItemExtReference,
  BillOfMaterialItemNodeNumber,
  _SettlementPeriodRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  SrvcDocItemDelivPlanPeriodRule AS SbscrContrItmDelivPlnPerdRule,
  DelivPlanFirstDeliveryDateTime,
  cast( 0 as timestamp ) AS SrvcDocItmProdConfignDateTime,
  PriceReferenceCPQQuotation,
  PriceReferenceCPQQuotationItem,
  PricingDate
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_SubscrpnContrItmPrElmnt AS _PriceElement ON SubscriptionContract = _PriceElement.SubscriptionContract AND SubscriptionContractItem = _PriceElement.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmTechRsce AS _TechnicalResource ON SubscriptionContract = _TechnicalResource.SubscriptionContract AND SubscriptionContractItem = _TechnicalResource.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmText AS _Text ON SubscriptionContract = _Text.SubscriptionContract AND SubscriptionContractItem = _Text.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmConfign AS _Configuration ON ConfigurationNumber = _Configuration.VariantConfigurationInstance  -- association [0..*]
LEFT OUTER JOIN A_SubscriptionContract AS _SubscriptionContract ON SubscriptionContract = _SubscriptionContract.SubscriptionContract  -- association [1]
LEFT OUTER JOIN A_SubscrpnContrItmDteParam AS _DateParameter ON SubscriptionContract = _DateParameter.SubscriptionContract AND SubscriptionContractItem = _DateParameter.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmStrParam AS _StringParameter ON SubscriptionContract = _StringParameter.SubscriptionContract AND SubscriptionContractItem = _StringParameter.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmNmrcParam AS _NumericParameter ON SubscriptionContract = _NumericParameter.SubscriptionContract AND SubscriptionContractItem = _NumericParameter.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmTblParam AS _TableParameter ON SubscriptionContract = _TableParameter.SubscriptionContract AND SubscriptionContractItem = _TableParameter.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000266' AND SubscriptionContract = _Extension.ServiceOrderItem AND SubscriptionContractItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnContrItmExtRef AS _ExternalReference ON SubscriptionContract = _ExternalReference.SubscriptionContract AND SubscriptionContractItem = _ExternalReference.SubscriptionContractItem  -- association [0..1]
LEFT OUTER JOIN A_SbscrContrItmPrdcssrQtnItm AS _PredecessorSolnQtnItem ON SubscriptionContract = _PredecessorSolnQtnItem.SubscriptionContract AND SubscriptionContractItem = _PredecessorSolnQtnItem.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SbscrContrItmPrdcssrOrdItm AS _PredecessorSubscrpnOrdItem ON SubscriptionContract = _PredecessorSubscrpnOrdItem.SubscriptionContract AND SubscriptionContractItem = _PredecessorSubscrpnOrdItem.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SbscrContrItmFUPOrdItm AS _FollowUpSubscrpnOrdItem ON SubscriptionContract = _FollowUpSubscrpnOrdItem.SubscriptionContract AND SubscriptionContractItem = _FollowUpSubscrpnOrdItem.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SubscrpnContrItmPrtn AS _ItemPartner ON SubscriptionContract = _ItemPartner.SubscriptionContract AND SubscriptionContractItem = _ItemPartner.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoMPrimaryTime ON _UoMPrimaryTime.IsPrimaryUnitForISOCode = 'X' AND _UoMPrimaryTime.UnitOfMeasureDimension = 'TIME'  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _ServDocDuration ON _ServDocDuration.ServiceObjectType = 'BUS2000266' AND SubscriptionContract = _ServDocDuration.ServiceDocument AND SubscriptionContractItem = _ServDocDuration.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoMAutoRnwlStartDurationUnit ON I_ServiceDocumentItemEnhcd.SrvcContrItemRnwlDurationUnit = _UoMAutoRnwlStartDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementPeriodRule ON I_ServiceDocumentItemEnhcd.SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN A_SubscrpnContrItmBillgReqItem AS _BillingRequestItem ON SubscriptionContract = _BillingRequestItem.SubscriptionContract AND SubscriptionContractItem = _BillingRequestItem.SubscriptionContractItem  -- association [0..*]
LEFT OUTER JOIN A_SbscrContrItmDeliveryPlan AS _DeliveryPlanItem ON SubscriptionContract = _DeliveryPlanItem.SubscriptionContract AND SubscriptionContractItem = _DeliveryPlanItem.SubscriptionContractItem  -- association [0..*]
;