A_BusSolnOrdSubscrpnBillgItem

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_BusSolnOrdSubscrpnBillgItem.
-- 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_BusSolnOrdSubscrpnBillgItem AS
SELECT
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocItemCategory AS BusSolnOrdItmCategory,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  cast(_QuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) AS BusSolnOrdItmQtyUnitSAPCode,
  cast(_QuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) AS BusSolnOrdItmQtyUnitISOCode,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  _ExternalReference.CustMgmtExtRefID AS BusSolnOrdItmExtReference,
  ServiceDocumentItemNetAmount,
  TransactionCurrency,
  Language,
  ParentServiceDocumentItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentBusSolnOrdItem,
  BusSolnOrdItemBundleProduct,
  BusSolnOrdItemBundleItem,
  ServiceDocumentItemIsReleased AS BusSolnOrdItmIsReleased,
  cast( '' as abap.char( 1 ) ) AS BusSolnOrdItmDistrStatus,
  cast( '' as abap.char( 60 ) ) AS BusSolnOrdItmDistrStatusName,
  cast( '' as abap.char ( 1 )) AS SubscrpnSimulationStatus,
  cast( '' as abap.char( 60 )) AS SubscrpnSimulationStatusName,
  ServiceContrItemStartDateTime AS SubscriptionStartDateTime,
  ServiceContrItemEndDateTime AS SubscriptionEndDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_PRIC_DT'].SrvcDocApptStartDateTime AS SubscrpnBillgItmPrcgDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_BIL_CUT'].SrvcDocApptStartDateTime AS SubscrpnBillgCutoverDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_BIL_CYC'].SrvcDocApptStartDateTime AS SubscrpnBillgCycRefDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_EXP_END'].SrvcDocApptStartDateTime AS SubscrpnExpdTermEndDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_MIN_END'].SrvcDocApptStartDateTime AS SubscrpnMinimumTermEndDateTime,
  _SrvcDocAppointment[1:SrvcDocAppointmentType = 'SUBS_WDR_END'].SrvcDocApptStartDateTime AS SubscrpnWthdrwlPerdEndDateTime,
  cast (0 as abap.dec(13)) AS SubscrpnWithdrawalPeriod,
  cast (0 as abap.dec(13)) AS SubscriptionFixedTerm,
  cast (0 as abap.dec(13)) AS SubscriptionTermOfNotice,
  cast (0 as abap.dec(13)) AS SubscriptionMinimumTerm,
  cast (0 as abap.dec(13)) AS SubscriptionRenewalPeriod,
  cast (0 as abap.dec(13)) AS SubscriptionExpectedTerm,
  cast (0 as abap.dec(13)) AS SubscrpnExpectedTermExtension,
  cast (0 as abap.dec(13)) AS SubscrpnWaiverPeriod,
  cast ( '' as abap.char(12)) AS SubscrpnWvrPeriodUnitSAPCode,
  MidBillgCycExprtnIsAllowed,
  SubscriptionBillingCycle,
  SubscrpnBillgRatePlanCharUUID AS SubscrpnBillgRatePlanUUID,
  ProfitCenter,
  SubscrpnOrdIsPending,
  NrOfBillgCyclesBilledTogether,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContractAccount
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN A_BusinessSolutionOrder AS _BusinessSolutionOrder ON BusinessSolutionOrder = _BusinessSolutionOrder.BusinessSolutionOrder  -- association [1..1]
LEFT OUTER JOIN A_BusSolnOrdItmRateElement AS _RateElements ON BusinessSolutionOrder = _RateElements.BusinessSolutionOrder AND BusinessSolutionOrderItem = _RateElements.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItmSubscrpnPrParam AS _PriceParameters ON BusinessSolutionOrder = _PriceParameters.BusinessSolutionOrder AND BusinessSolutionOrderItem = _PriceParameters.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItmSubscrpnParam AS _SubscriptionParameters ON BusinessSolutionOrder = _SubscriptionParameters.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SubscriptionParameters.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItmSubscrpnPrAgrmt AS _SubscriptionPriceAgreements ON BusinessSolutionOrder = _SubscriptionPriceAgreements.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SubscriptionPriceAgreements.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExternalReference ON BusinessSolutionOrder = _ExternalReference.CustMgmtDocument AND _ExternalReference.CustMgmtObjectType = 'BUS2000172' AND BusinessSolutionOrderItem = _ExternalReference.CustMgmtDocumentItem AND _ExternalReference.CustMgmtExtRefIDType = '0013'  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmFUPSubscrpn AS _SubscriptionBilling ON BusinessSolutionOrder = _SubscriptionBilling.BusinessSolutionOrder AND BusinessSolutionOrderItem = _SubscriptionBilling.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000172' AND BusinessSolutionOrder = _Extension.ServiceOrderItem AND BusinessSolutionOrderItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocAppointment AS _SrvcDocAppointment ON _SrvcDocAppointment.SrvcMgmtObjectUUID = BusinessSolutionOrderItemUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN A_BusSolnOrdItmUserStatus AS _UserStatus ON BusinessSolutionOrder = _UserStatus.BusinessSolutionOrder AND BusinessSolutionOrderItem = _UserStatus.BusinessSolutionOrderItem  -- association [0..*]
LEFT OUTER JOIN A_BusSolnOrdItmPartner AS _Partner ON BusinessSolutionOrder = _Partner.BusinessSolutionOrder AND BusinessSolutionOrderItem = _Partner.BusinessSolutionOrderItem  -- association [0..*]
;