I_SubscriptionOrderItem

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_SubscriptionOrderItem.
-- 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_SubscriptionOrderItem AS
SELECT
  ServiceDocument AS SubscriptionOrder,
  ServiceDocumentItem AS SubscriptionOrderItem,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  ServiceDocItemCategory AS SubscrpnOrdItemCategory,
  ServiceDocumentItemUUID AS SubscriptionOrderItemUUID,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentSubscriptionOrderItem,
  ServiceDocumentItemDescription AS SubscrpnOrdItmDescription,
  Language,
  ServiceDocItemCreationDateTime AS CreationDateTime,
  ServiceDocItemChangedDateTime AS LastChangeDateTime,
  ServiceDocItemCreatedByUser AS CreatedByUser,
  ServiceDocItemChangedByUser AS LastChangedByUser,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  ServiceDocItemRejectionReason AS SubscrpnOrdRjcnReason,
  PurchaseOrderByShipToParty,
  ServiceDocumentItemIsRejected AS SubscrpnOrdItemIsRejected,
  ServiceDocumentItemHasError AS SubscrpnOrdItmHasError,
  SrvcDocItemCreditStatus AS SubscrpnOrdItemCreditStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  cast( ContactPerson as abap.numc( 10 )) AS ContactPerson,
  cast( ResponsibleEmployee as abap.char( 12 )) AS PersonResponsible,
  case when _ShipToDetails.AddressID is null then _ShipToDetailsHeader.AddressID else _ShipToDetails.AddressID end AS ShipToPartyAddressID,
  case when _BillToDetails.AddressID is null then _BillToDetailsHeader.AddressID else _BillToDetails.AddressID end AS BillToPartyAddressIdentifier,
  case when _PayerPartyDetails.AddressID is null then _PayerPartyDetailsHeader.AddressID else _PayerPartyDetails.AddressID end AS PayerToPartyAddressIdentifier,
  PaymentTerms,
  CABillgCycle,
  ContractAccount,
  ServiceContrItemStartDateTime AS SubscrpnContrItmStartDateTime,
  ServiceContrItemEndDateTime AS SubscrpnContrItmEndDateTime,
  SrvcDocItmTmeSliceStrtDteTme AS SbscrContrTimeSliceStrtDteTme,
  SrvcDocItmTmeSliceEndDteTme AS SbscrContrTimeSliceEndDteTme,
  SrvcDocItmGrcePerdEndDateTime AS SbscrContrItmGrcePerdDteTme,
  SbscrContrItmBizValdStrtDteTme,
  SbscrContrItmBizValdEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SrvcContrItemRnwlDuration AS SubscrpnContrArnwlStrtDurn,
  SrvcContrItemRnwlDurationUnit AS SubscrpnContrArnwlStrtDurnUnit,
  cast( SrvcContrItemExtensionDuration as timedura) AS SubscrpnContrAutoRnwlDurn,
  cast(SrvcContrItemExtnDurationUnit as timeunitdu ) AS SubscrpnContrAutoRnwlDurnUnit,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  CrsCatalogMappingVersionNumber,
  ConfigurationNumber,
  BusSolutionQtnItemIsPhased AS SubscrpnOrdItemIsPhased,
  BusSolnQtnItmPhasedPrdcssrItem AS SubscrpnOrdItmPhasedPrdcssrItm,
  ServiceDocumentItemCanclnParty AS SbscrContrItemCanclnParty,
  ServiceDocumentItmCanclnReason AS SbscrContrItemCanclnReason,
  SrvcDocItmCanclnProcedure AS SbscrContrItmCanclnProcedure,
  TransactionCurrency,
  SrvcDocItmRecrrgChrgNetAmount,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  SubscriptionContract AS SubscriptionContractExternalID,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SharingContractID,
  SubscrpnContractSharingGroupID
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdItmStatus ON SubscriptionOrderItemUUID = _SrvcOrdItmStatus.StatusObjectUUID AND ( _SrvcOrdItmStatus.StatusCode = 'I1002' OR _SrvcOrdItmStatus.StatusCode = 'I1003' OR _SrvcOrdItmStatus.StatusCode = 'I1004' OR _SrvcOrdItmStatus.StatusCode = 'I1005' ) AND _SrvcOrdItmStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_SubscriptionOrder AS _SubscriptionOrder ON SubscriptionOrder = _SubscriptionOrder.SubscriptionOrder  -- association [1..1]
LEFT OUTER JOIN I_SubscrpnOrdItemPriceElement AS _ItemPriceElement ON SubscriptionOrder = _ItemPriceElement.SubscriptionOrder AND SubscriptionOrderItem = _ItemPriceElement.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscriptionOrderItemPartner AS _ItemPartner ON SubscriptionOrder = _ItemPartner.SubscriptionOrder AND SubscriptionOrderItem = _ItemPartner.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItemUserStatus AS _ItemUserStatus ON SubscriptionOrder = _ItemUserStatus.SubscriptionOrder AND SubscriptionOrderItem = _ItemUserStatus.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItmAppt AS _ItemAppointment ON SubscriptionOrder = _ItemAppointment.SubscriptionOrder AND SubscriptionOrderItem = _ItemAppointment.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItemDuration AS _ItemDuration ON SubscriptionOrder = _ItemDuration.SubscriptionOrder AND SubscriptionOrderItem = _ItemDuration.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItemExtRef AS _ItemExternalReference ON SubscriptionOrder = _ItemExternalReference.SubscriptionOrder AND SubscriptionOrderItem = _ItemExternalReference.SubscriptionOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnOrdItemConfign AS _ItemConfig ON SubscriptionOrder = _ItemConfig.SubscriptionOrder AND SubscriptionOrderItem = _ItemConfig.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItmFUPContrItm AS _FollowUpContractItem ON SubscriptionOrder = _FollowUpContractItem.SubscriptionOrder AND SubscriptionOrderItem = _FollowUpContractItem.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItmFUPSlsOrdItm AS _FollowUpSalesOrderItem ON SubscriptionOrder = _FollowUpSalesOrderItem.SubscriptionOrder AND SubscriptionOrderItem = _FollowUpSalesOrderItem.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItemCnvChrg AS _ConvergentCharging ON SubscriptionOrder = _ConvergentCharging.SubscriptionOrder AND SubscriptionOrderItem = _ConvergentCharging.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_SubscrpnOrdItemTechRsce AS _TechnicalResource ON SubscriptionOrder = _TechnicalResource.SubscriptionOrder AND SubscriptionOrderItem = _TechnicalResource.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_ChgOrdItmPrdcssrContrItm AS _PredecessorContItem ON SubscriptionOrder = _PredecessorContItem.SubscriptionOrder AND SubscriptionOrderItem = _PredecessorContItem.SubscriptionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElementExternalID  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtPartner AS _ShipToDetails ON _ShipToDetails.CustMgmtObjectType = 'BUS2000265' AND SubscriptionOrder = _ShipToDetails.CustMgmtDocument AND SubscriptionOrderItem = _ShipToDetails.CustMgmtDocumentItem AND ShipToParty = _ShipToDetails.CustMgmtBusinessPartner AND _ShipToDetails.CustMgmtPartFunctionCategory = '0002'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _BillToDetails ON _BillToDetails.CustMgmtObjectType = 'BUS2000265' AND SubscriptionOrder = _BillToDetails.CustMgmtDocument AND SubscriptionOrderItem = _BillToDetails.CustMgmtDocumentItem AND BillToParty = _BillToDetails.CustMgmtBusinessPartner AND _BillToDetails.CustMgmtPartFunctionCategory = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _PayerPartyDetails ON _PayerPartyDetails.CustMgmtObjectType = 'BUS2000265' AND SubscriptionOrder = _PayerPartyDetails.CustMgmtDocument AND SubscriptionOrderItem = _PayerPartyDetails.CustMgmtDocumentItem AND PayerParty = _PayerPartyDetails.CustMgmtBusinessPartner AND _PayerPartyDetails.CustMgmtPartFunctionCategory = '0004'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ShipToDetailsHeader ON _ShipToDetailsHeader.CustMgmtObjectType = 'BUS2000265' AND SubscriptionOrder = _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 = 'BUS2000265' AND SubscriptionOrder = _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 = 'BUS2000265' AND SubscriptionOrder = _PayerPartyDetailsHeader.CustMgmtDocument AND _PayerPartyDetailsHeader.CustMgmtDocumentItem = '000000' AND PayerParty = _PayerPartyDetailsHeader.CustMgmtBusinessPartner AND _PayerPartyDetailsHeader.CustMgmtPartFunctionCategory = '0004'  -- association [0..1]
;