R_SubscriptionContractItemTP

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_SubscriptionContractItemTP.
-- 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_SubscriptionContractItemTP AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  SubscriptionContractExternalID,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  ServiceDocumentType,
  SubscrpnContractItemCategory,
  Product,
  SubscrpnProductSpecification,
  Quantity,
  QuantityUnit,
  TransactionCurrency,
  SubscrpnContrItmGrossAmount,
  SubscrpnContrItmNetAmount,
  SubscrpnContrItmNetAmount AS SubscrpnContrItmDspNetAmount,
  SubscrpnContrItmTaxAmount,
  SubscrpnContrItmNetAmount AS SubscrpnContrItmOneTmeNetAmt,
  SubscrpnContrItmGrossAmount AS SubscrpnContrItmOneTmeGrossAmt,
  SubscrpnContrItmTaxAmount AS SubscrpnContrItmOneTmeTaxAmt,
  SbscrContrItmRecrrgChrgNetAmt,
  SbscrContrItmRecrrgChrgGrssAmt,
  SbscrContrItmRecrrgChrgTaxAmt,
  PaymentTerms,
  CAPartnerSettlementRule,
  SubscriptionContrItmDesc,
  SubscriptionContractUUID,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  ParentSubscrpnContractItemUUID,
  SubscrpnOrdProdSelType,
  SubscrpnContrItmIsMainItem,
  Language,
  SbscrContrItmDeliveryPlanType,
  SbscrContrItmDelivPlnPerdRule,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SubscrpnContractItemIsActive,
  SubscrpnContractItemIsRejected,
  SubscrpnContrItmIsCancelled,
  SubscriptionContractItemStatus,
  SubscrpnContrItmHasError,
  SubscrpnContrItmCrdtSts,
  SubscrpnContrActivationStatus,
  SubscrpnContrTimeSliceStatus,
  SbsConItmGTSEmbargoStatus,
  SbsConItmGTSScreeningStatus,
  SbsConItmGTSLglControlStatus,
  SbscrContrItmCanclnProcedure,
  SbscrContrItemCanclnReason,
  SbscrContrItemCanclnParty,
  SubscrpnContrItmRjcnRsn,
  SubscrpnContrItmCanclnDteTme,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SubscrpnContrAutoRnwlIsActv AS SbscrContrAutoRnwlIsActvForDsp,
  SubscrpnContrItmRnwlDteTme,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  SrvcTransChangeProcess,
  SrvcTransChangeProcessType,
  SrvcTransChangeProcessGroup,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  ContractAccount,
  CABillgCycle,
  SubscrpnContrItmBillgPlnCyc,
  CrsCatalogMappingVersionNumber,
  SbscrContrItmRecrrgChrgDurn,
  SbscrContrItmRcrChrDurUnit,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SbscrShContrSvTrMtAgrItmUUID,
  SbscrShContrSvTrMtAgrItmCstPrd,
  SvTrMtAgrItmIsFxdConfign,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  ConfigurationNumber,
  SubscrpnContrItmHasConfign,
  SubscrpnContrItemIsPhased,
  SbscrContrItmPhasedPrdcssrItm,
  SubscrpnContrItmPostgDte,
  SubscrpnContrItmCrtedByUsr,
  SubscrpnContrItmChgdByUsr,
  SubscrpnContrItmCrtnDteTme,
  SubscrpnContrItmChgdDteTme,
  SubscrpnContrItmPrtnRefItm,
  SubscrpnContrItmApptRefObjUUID,
  SubscrpnContrItmApptRefItm,
  SubscrpnContrItmIsWithdrawn,
  SubscrpnContrItmWthdrwlRsn,
  SubscrpnContrItmRfndType,
  SbscrContrItmAcctAssgmtObjType,
  SbscrContrItmAcctAssgmtObject,
  WBSElementExternalID,
  SubscrpnContrSubitemOrigin,
  SubscrpnContrItmBillgPlnType
FROM I_SubscriptionContractItem
LEFT OUTER JOIN I_SbsMssProcgElmntContrItmChg AS _SbsMssProcgElmntContrItmChg ON _SbsMssProcgElmntContrItmChg.SubscriptionContract = SubscriptionContract AND _SbsMssProcgElmntContrItmChg.SubscriptionContractItem = SubscriptionContractItem AND _SbsMssProcgElmntContrItmChg.SubscrpnMassProcgElmntSts <> 'D'  -- association [0..1]
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 R_SbscrContrItmStateTP AS _SbscrContrItmState ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmChgProcTP AS _SbscrContrItmChgProc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmTechRsceTP AS _SubscrpnContrItmTechRsce ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmHistTP AS _SubscrpnContrItmHist ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmDiscTP AS _SubscrpnContrItmDisc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmChrgTP AS _SubscrpnContrItmChrg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmLockHistTP AS _SbscrContrItmLockHist ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmPrElmntTP AS _SubscrpnContrItmPrElmnt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmApptTP AS _SubscrpnContrItmAppt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmDurnTP AS _SubscrpnContrItmDurn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmPrtnTP AS _SubscrpnContrItmPrtn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmRefObjTP AS _SubscrpnContrItmRefObj ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmEquipTP AS _SubscrpnContrItmEquip ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmUsrStsTP AS _SubscrpnContrItmUsrSts ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CnvChrgAllwncDefTP AS _CnvChrgAllwncDef ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CnvChrgAllwncTP AS _CnvChrgAllwnc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmAllwncKeyFigTP AS _SbscrContrItmAllwncKeyFig ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmKeyFigTP AS _SubscrpnContrItmKeyFig ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SubscrpnContrItmDteParamTP AS _SubscrpnContrItmDteParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmNmrcParamTP AS _SubscrpnContrItmNmrcParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmStrParamTP AS _SubscrpnContrItmStrParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmTblParamTP AS _SubscrpnContrItmTblParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmConfignTP AS _SubscrpnContrItmConfign ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmPrdcssrTP AS _SubscrpnContrItmPrdcssr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItmSuccessorTP AS _SubscrpnContrItmSuccessor ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SubscrpnContrItemLongTextTP AS _SubscrpnContrItemLongText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmBlgReqItmTP AS _SbscrContrItmBlgReqItm ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbsConItmCnvChrgCntdObjTP AS _SbsConItmCnvChrgCntdObj ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmCnvChrgParamTP AS _SbscrContrItmCnvChrgParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbsConItmCnvChrgTblParamTP AS _SbsConItmCnvChrgTblParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbsConItmCnvChrgTechRsceTP AS _SbsConItmCnvChrgTechRsce ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SbscrContrItmDeliveryPlanTP AS _SbscrContrItmDeliveryPlan ON /* condition not available in parsed metadata */  -- association [0..*]
;