C_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 C_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 C_SubscriptionContractItemTP AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  SubscriptionContractExternalID,
  ServiceObjectType,
  ServiceDocumentType,
  SubscrpnContractItemCategory,
  Product,
  _Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  SubscrpnProductSpecification,
  Quantity,
  QuantityUnit,
  TransactionCurrency,
  SubscrpnContrItmGrossAmount,
  SubscrpnContrItmNetAmount,
  SubscrpnContrItmTaxAmount,
  SubscrpnContrItmOneTmeGrossAmt,
  SubscrpnContrItmOneTmeNetAmt,
  SubscrpnContrItmOneTmeTaxAmt,
  SbscrContrItmRecrrgChrgGrssAmt,
  SbscrContrItmRecrrgChrgNetAmt,
  SbscrContrItmRecrrgChrgTaxAmt,
  _SubscrpnContrItmDurn[1:SubscrpnContrTmeDurnType = 'CONTDURA'].SubscrpnContrTmeDurnValue AS SubscrpnContrItmValdtyPerd,
  _SubscrpnContrItmDurn[1:SubscrpnContrTmeDurnType = 'CONTDURA'].SubscrpnContrTimeDurnUnit AS SubscrpnContrItmValdtyPerdUnt,
  _SubscrpnContrItmDurn[1:SubscrpnContrTmeDurnType = 'CONTDURA']._SrvcDocDurationUnitText[1:Language = $session.system_language ].SrvcDocDurationUnitText AS SbscrContrItmValdtyPerdUntTxt,
  PaymentTerms,
  _PaymentTerms._Text.PaymentTermsName : localized AS PaymentTermsNamelocalized,
  CAPartnerSettlementRule,
  _CAPartnerSettlementRule._Text.CAPartnerSettlementRuleText : localized AS CAPartnerSettlementRuleTextlocalized,
  SubscriptionContrItmDesc,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  ParentSubscrpnContractItemUUID,
  SubscrpnOrdProdSelType,
  SubscrpnContrItmIsMainItem,
  Language,
  SalesOrganization,
  _SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  DistributionChannel,
  _DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  Division,
  _Division._Text.DivisionName : localized AS DivisionNamelocalized,
  SalesOffice,
  _SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SubscrpnContractItemIsActive,
  SubscrpnContrActivationStatus,
  _SubscrpnContrItmActvtnSts._Text.SubscrpnContrActvtnStsText : localized AS SubscrpnContrActvtnStsTextlocalized,
  SubscrpnContrTimeSliceStatus,
  SubscriptionContractItemStatus,
  SubscrpnContrItmHasError,
  SubscrpnContrItmCrdtSts,
  SubscrpnContractItemIsRejected,
  SbsConItmGTSEmbargoStatus,
  SbsConItmGTSScreeningStatus,
  SbsConItmGTSLglControlStatus,
  SubscrpnContrItmIsCancelled,
  SbscrContrItmCanclnProcedure,
  SbscrContrItemCanclnReason,
  _SbscrContrItmCanclnRsn._Text.SbscrContrItmCanclnRsnTxt : localized AS SbscrContrItmCanclnRsnTxtlocalized,
  SbscrContrItemCanclnParty,
  _SbscrContrItmCanclnPty._Text.SbscrContrItemCanclnPartyText : localized AS SbscrContrItemCanclnPartyTextlocalized,
  SubscrpnContrItmRjcnRsn,
  _ServiceDocItemRejectionReason._Text.SalesDocumentRjcnReasonName : localized AS SalesDocumentRjcnReasonNamelocalized,
  _SubscrpnContrItmAppt[1:SubscrpnContrApptType = 'CANCRECEIVE'].SubscrpnContrApptStrtDteTme AS SbscrContrItmCanclnRecDateTime,
  _SubscrpnContrItmAppt[1:SubscrpnContrApptType = 'CANCREQUEST'].SubscrpnContrApptStrtDteTme AS SbscrContrItmCanclnReqDateTime,
  SubscrpnContrItmCanclnDteTme,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  _SubscrpnContrItmAppt[1:SubscrpnContrApptType = 'ISTRUNTMEND'].SubscrpnContrApptStrtDteTme AS SubscrpnContrTrmEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SbscrContrAutoRnwlIsActvForDsp,
  SubscrpnContrItmRnwlDteTme,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  PurchaseOrderByCustomer,
  PurchaseOrderByShipToParty,
  SoldToParty,
  ShipToParty,
  RespEmployeeBusinessPartnerId,
  ContactPersonBusinessPartnerId,
  BillToParty,
  PayerParty,
  ContractAccount,
  CABillgCycle,
  _BillgCycle._CABillgCycleText.CABillgCycleText : localized AS CABillgCycleTextlocalized,
  SubscrpnContrItmBillgPlnCyc,
  CrsCatalogMappingVersionNumber,
  SbscrContrItmRecrrgChrgDurn,
  SbscrContrItmRcrChrDurUnit,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SvTrMtAgrItmIsFxdConfign,
  SbscrShContrSvTrMtAgrItmUUID,
  SbscrShContrSvTrMtAgrItmCstPrd,
  SharingContractID,
  SubscrpnContractSharingGroupID,
  _SubscrpnContrItmShrngGrp._Text[1:Language = $session.system_language ].SubscrpnContrSharingGroupDesc AS SubscrpnContrSharingGroupDesc,
  ConfigurationNumber,
  SubscrpnContrItmHasConfign,
  SrvcTransChangeProcessGroup,
  SubscrpnContrItemIsPhased,
  SbscrContrItmPhasedPrdcssrItm,
  SubscrpnContrItmPostgDte,
  SubscrpnContrItmCrtedByUsr,
  SubscrpnContrItmChgdByUsr,
  SubscrpnContrItmCrtnDteTme,
  SubscrpnContrItmChgdDteTme,
  _ExternalReference[1:SubscrpnContrItmRefType = '0018'].SbscrContrPrdcssrExtID AS SbscrContrPrdcssrExtID,
  _ExternalReference[1:SubscrpnContrItmRefType = '0019'].SbscrContrSuccssrExtID AS SbscrContrSuccssrExtID,
  SubscrpnContrItmIsWithdrawn,
  SubscrpnContrItmWthdrwlRsn,
  _SubscrpnContrItmWthdrwlRsn._Text.SbscrContrItmWthdrwlRsnTxt : localized AS SbscrContrItmWthdrwlRsnTxtlocalized,
  SubscrpnContrItmRfndType,
  _SubscrpnContrItmRfndType._Text.SubscrpnContrItmRfndTypeTxt : localized AS SubscrpnContrItmRfndTypeTxtlocalized,
  _SubscrpnContrItmAppt[1:SubscrpnContrApptType = 'WITHDRAW_END'].SubscrpnContrApptStrtDteTme AS SubscrpnContrItmWthdrwlDteTme,
  _SubscrpnContrItmAppt[1:SubscrpnContrApptType = 'GRACE_END'].SubscrpnContrApptStrtDteTme AS SbscrContrItmGrcePerdDteTme,
  SbscrContrItmAcctAssgmtObjType,
  SbscrContrItmAcctAssgmtObject,
  SubscrpnContrSubitemOrigin,
  WBSElementExternalID,
  SubscrpnContrItmBillgPlnType,
  virtual SbscrContrStateTypeText : abap.char(60) AS char60,
  virtual SubscrpnContrItmAllwncInfoTxt : abap.string AS string,
  virtual SubscrpnContrItmExprdDurnQty : abap.quan( 13, 0) AS quan130,
  virtual SbscrContrItemExprdDaysCritlty : abap.int1 AS int1,
  virtual SubscrpnContrItmTitleDspTxt : abap.string( 256 ) AS string256,
  virtual SubscrpnContrItmHasSitns : boolean AS virtualSubscrpnContrItmHasSitnsboolean,
  virtual SubscrpnContrItmRefObjEquip : equnr AS virtualSubscrpnContrItmRefObjEquipequnr,
  virtual SubscrpnContrItmDiscKey : disckey_kk AS virtualSubscrpnContrItmDiscKeydisckey_kk,
  virtual SubscrpnContrItmChrgKey : disckey_kk AS virtualSubscrpnContrItmChrgKeydisckey_kk,
  virtual UICT_SrvcTransMstrAgrmtID : boolean AS virtualUICT_SrvcTransMstrAgrmtIDboolean,
  virtual UICT_Cancellation : boolean AS virtualUICT_Cancellationboolean,
  virtual UICT_AutoRenewal : boolean AS virtualUICT_AutoRenewalboolean,
  virtual UICT_RelatedDocument : boolean AS virtualUICT_RelatedDocumentboolean,
  virtual UICT_Withdrawal : boolean AS virtualUICT_Withdrawalboolean,
  virtual UICT_StatusIsCancelled : boolean AS virtualUICT_StatusIsCancelledboolean,
  virtual UICT_StatusIsWithdrawn : boolean AS virtualUICT_StatusIsWithdrawnboolean,
  virtual UICT_StatusIsRejected : boolean AS virtualUICT_StatusIsRejectedboolean,
  virtual UICT_StatusHasError : boolean AS virtualUICT_StatusHasErrorboolean,
  virtual UICT_ContractStatus : boolean AS virtualUICT_ContractStatusboolean,
  virtual UICT_PriceDetails : boolean AS virtualUICT_PriceDetailsboolean,
  virtual UICT_BillingPlan : boolean AS virtualUICT_BillingPlanboolean,
  virtual UICT_WBSElementExternalID : boolean AS virtualUICT_WBSElementExternalIDboolean,
  virtual UICT_AccountAssignment : boolean AS virtualUICT_AccountAssignmentboolean,
  _BillToParty.BusinessPartnerFullName AS BillToPartyName,
  _ContactPerson.BusinessPartnerName AS ContactPersonName,
  _ContractAccountPartner.ContractAccountName AS ContractAccountName,
  _CrsCtlgUsableMappingVersion.CrsCtlgMappgVersionDescription AS CrsCtlgMappgVersionDescription,
  _CrsCtlgUsableMappingVersion.CrossCatalogMappingVersionUUID AS CrossCatalogMappingVersionUUID,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentSubscriptionContractItem,
  _PayerParty.BusinessPartnerFullName AS PayerPartyName,
  _RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  _SbscrShContrSvTrMtAgrItm.SrvcTransMstrAgrmtID AS SbscrShContrSvTrMtAgrID,
  _SbscrShContrSvTrMtAgrItm.SrvcTransMstrAgrmtItem AS SbscrShContrSvTrMtAgrItm,
  _ShipToParty.BusinessPartnerName AS ShipToPartyName,
  _SoldToParty.BusinessPartnerName AS SoldToPartyName,
  _SrvcDocDurationUnitText.SrvcDocDurationUnitText AS SbscrContrItmRcrChrDurUnitText,
  _SrvcTransMasterAgreementItem.SrvcTransMstrAgrmtItmCustProd AS CustMgmtMstrAgrmtCustomProdID,
  _WBSElementBasicData.WBSDescription AS WBSDescription
FROM R_SubscriptionContractItemTP
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = SubscrpnContrItmCharUUID AND _SitnInstceIndicator.SitnDefAnchorObject = 'SubscriptionContractItemUUID'  -- association [0..1]
;