R_SubscriptionOrderItemTP

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 R_SubscriptionOrderItemTP.
-- 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 R_SubscriptionOrderItemTP AS
SELECT
  SubscriptionOrder,
  SubscriptionOrderItem,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  SubscrpnOrdItemCategory,
  SubscriptionOrderItemUUID,
  ParentSubscriptionOrderItem,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  Product,
  SubscrpnOrdItmDescription,
  Quantity,
  QuantityUnit,
  SubscrpnOrdRjcnReason,
  PurchaseOrderByShipToParty,
  CustPurOrdDateByShipToParty,
  SubscrpnOrdItemIsNew,
  SubscrpnOrdItemIsInProcess,
  SubscrpnOrdItemIsReleased,
  SubscrpnOrdItemIsCompleted,
  SubscrpnOrdItemIsRejected,
  SubscrpnOrdItmHasError,
  SubscrpnOrdItemCreditStatus,
  SubsOrdItmGTSEmbargoStatus,
  SubsOrdItmGTSScreeningStatus,
  SubsOrdItmGTSLglControlStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson,
  PersonResponsible,
  ShipToPartyAddressID,
  BillToPartyAddressIdentifier,
  PayerToPartyAddressIdentifier,
  PaymentTerms,
  CABillgCycle,
  ContractAccount,
  SubscrpnContrItmStartDateTime,
  _SubscrpnContrItemExtnDuration.SrvcDocDurationValue AS SubscrpnContrItemExtnDuration,
  cast( '' as abap.char(12) ) AS SubscrpnContrItemExtnDurnUnit,
  _SubscrpnContrItemExtnDuration.SrvcDocDurationUnitSAPCode AS SbscrContrItmExtnDurnUntSAPCd,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SubscrpnContrArnwlStrtDurn,
  SubscrpnContrArnwlStrtDurnUnit,
  _SubscrpnContrArStrtDurnUnit.SrvcDocDurationUnitSAPCode AS SbsConArnwlStrtDurnUntSAPCode,
  SubscrpnContrAutoRnwlDurn,
  SubscrpnContrAutoRnwlDurnUnit,
  _SubscrpnContrAutoRnwlDurnUnit.SrvcDocDurationUnitSAPCode AS SbscrContrArnwlDurnUntSAPCode,
  _SbscrContrItmGrcePerd.SrvcDocDurationValue AS SbscrContrItmGrcePerd,
  _SbscrContrItmGrcePerd.SrvcDocDurationUnitSAPCode AS SbscrContrItmGrcePerdUntSAPCd,
  SbscrContrItmGrcePerdDteTme,
  SbscrContrItmBizValdEndDteTme,
  SbscrContrItmBizValdStrtDteTme,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  CrsCatalogMappingVersionNumber,
  ConfigurationNumber,
  SubscrpnOrdItemIsPhased,
  SubscrpnOrdItmPhasedPrdcssrItm,
  SbscrContrItemCanclnParty,
  SbscrContrItemCanclnReason,
  SbscrContrItmCanclnProcedure,
  cast( 0 as crms4_canc_receive ) AS SbscrContrItmCanclnRecDateTime,
  cast( 0 as crms4_canc_request ) AS SbscrContrItmCanclnReqDateTime,
  SettlementPeriodRule,
  SbscrOrdItmDelivPlnPeriodRule,
  DelivPlanFirstDeliveryDateTime,
  TransactionCurrency,
  _ISOCurrency.CurrencyISOCode AS TransactionCurrencyISOCode,
  SrvcDocItmRecrrgChrgNetAmount,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  SubscriptionContractExternalID,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  WBSElementExternalID,
  BillOfMaterialItemNodeNumber,
  cast( '00000000' as timestamp ) AS SrvcDocItmProdConfignDateTime
FROM I_SubscriptionOrderItem
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON _QuantityUnit.UnitOfMeasure = I_SubscriptionOrderItem.QuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _SubscrpnContrItemExtnDuration ON _SubscrpnContrItemExtnDuration.ServiceObjectType = 'BUS2000265' AND SubscriptionOrder = _SubscrpnContrItemExtnDuration.ServiceDocument AND SubscriptionOrderItem = _SubscrpnContrItemExtnDuration.ServiceDocumentItem AND 'CONTDURA' = _SubscrpnContrItemExtnDuration.SrvcDocDurationType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _SubscrpnContrAutoRnwlDurnUnit ON _SubscrpnContrAutoRnwlDurnUnit.ServiceObjectType = 'BUS2000265' AND SubscriptionOrder = _SubscrpnContrAutoRnwlDurnUnit.ServiceDocument AND SubscriptionOrderItem = _SubscrpnContrAutoRnwlDurnUnit.ServiceDocumentItem AND 'AR_EXTENSION' = _SubscrpnContrAutoRnwlDurnUnit.SrvcDocDurationType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _SbscrContrItmGrcePerd ON _SbscrContrItmGrcePerd.ServiceObjectType = 'BUS2000265' AND SubscriptionOrder = _SbscrContrItmGrcePerd.ServiceDocument AND SubscriptionOrderItem = _SbscrContrItmGrcePerd.ServiceDocumentItem AND 'GRACE_PERIOD' = _SbscrContrItmGrcePerd.SrvcDocDurationType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentDurationEnhcd AS _SubscrpnContrArStrtDurnUnit ON _SubscrpnContrArStrtDurnUnit.ServiceObjectType = 'BUS2000265' AND SubscriptionOrder = _SubscrpnContrArStrtDurnUnit.ServiceDocument AND SubscriptionOrderItem = _SubscrpnContrArStrtDurnUnit.ServiceDocumentItem AND 'AR_PERIOD' = _SubscrpnContrArStrtDurnUnit.SrvcDocDurationType  -- 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 _ServiceDocDuration ON _ServiceDocDuration.ServiceObjectType = 'BUS2000265' AND SubscriptionOrder = _ServiceDocDuration.ServiceDocument AND SubscriptionOrderItem = _ServiceDocDuration.ServiceDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _ISOCurrency ON TransactionCurrency = _ISOCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000265' AND SubscriptionOrder = _Extension.ServiceOrderItem AND SubscriptionOrderItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN R_SubscrpnOrdItmPrcElmntTP AS _ItemPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemTechRsceTP AS _TechnicalResourceTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemUserStatusTP AS _ItemUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemPartnerTP AS _ItemPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmApptTP AS _ItemAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemDurationTP AS _ItemDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmTblParamTP AS _TableParametersTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmStrParamTP AS _StringParametersTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmNmrcParamTP AS _NumericParametersTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmDteParamTP AS _DateParametersTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemConfignTP AS _ItemConfigTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmFUPContrItmTP AS _FollowUpContractItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmFUPSlsOrdItmTP AS _FollowUpSalesOrderItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChgOrdItemPrdcssrQtanItmTP AS _PredecessorQtanItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChgOrdItmPrdcssrContrItmTP AS _PredecessorContItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemBlgReqItmTP AS _SubscrpnOrdItemBlgReqItmTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItmDeliveryPlanTP AS _SubscrpnOrdItemDelivPlnTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnOrdItemLongTextTP AS _SubsOrderItemTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;