I_BuSoPrtfloSubscrpnContrItmTP

DDL: I_BUSOPRTFLOSUBSCRPNCONTRITMTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Transact. Process.: Subscr. Contr. Item

I_BuSoPrtfloSubscrpnContrItmTP is a Transactional CDS View that provides data about "Transact. Process.: Subscr. Contr. Item" in SAP S/4HANA. It reads from 1 data source (I_BuSoPrtfloSubscrpnContrItm) and exposes 29 fields with key fields BusinessSolutionPortfolio, SubscriptionContract, SubscriptionContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BuSoPrtfloSubscrpnContrItm I_BuSoPrtfloSubscrpnContrItm from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocumentItem _SubscriptionContractItem $projection.SubscriptionContract = _SubscriptionContractItem.ServiceDocument and $projection.SubscriptionContractItem = _SubscriptionContractItem.ServiceDocumentItem and _SubscriptionContractItem.ServiceObjectType = 'BUS2000266'

Annotations (7)

NameValueLevelField
EndUserText.label Transact. Process.: Subscr. Contr. Item view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionPortfolio BusinessSolutionPortfolio Transaction ID
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
clientNULLasSubscrpnContrItemStartDate
clientNULLasSubscrpnContrItemEndDate
Currency _BusinessSolutionPortfolio Currency Valuation Crcy
ServiceObjectType _SubscriptionContractItem ServiceObjectType Object Type
ServiceDocumentType _SubscriptionContractItem ServiceDocumentType Transaction Type
SalesOrganization _SubscriptionContractItem SalesOrganization Sales Organization
DistributionChannel _SubscriptionContractItem DistributionChannel RefDistCh-Cust/Mat.
Division _SubscriptionContractItem Division Internal Division ID
SalesOffice _SubscriptionContractItem SalesOffice Sales Office
SalesGroup _SubscriptionContractItem SalesGroup Sales Group
SubscrpnContrItmStartDateTime _SubscriptionContractItem ServiceContrItemStartDateTime
SubscrpnContrItmEndDateTime _SubscriptionContractItem ServiceContrItemEndDateTime
TransactionCurrency _SubscriptionContractItem TransactionCurrency Transaction Currency
SoldToParty _SubscriptionContractItem SoldToParty Sold-to Party
ResponsibleEmployee _SubscriptionContractItem ResponsibleEmployee Employee Resp.
SalesOrganizationOrgUnitID _SubscriptionContractItem SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID _SubscriptionContractItem SalesOfficeOrgUnitID
SalesGroupOrgUnitID _SubscriptionContractItem SalesGroupOrgUnitID
ServiceOrganization _SubscriptionContractItem ServiceOrganization
BusSolnPrtfloLastChgDateTime _BusinessSolutionPortfolio LastChangeDateTime Timestamp
_BusinessSolutionPortfolio _BusinessSolutionPortfolio
_SubscriptionContractItem _SubscriptionContractItem

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_BuSoPrtfloSubscrpnContrItmTP.
-- 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_BuSoPrtfloSubscrpnContrItmTP AS
SELECT
  BusinessSolutionPortfolio,
  SubscriptionContract,
  SubscriptionContractItem,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  tstmp_to_dats( _SubscriptionContractItem.ServiceContrItemStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SubscrpnContrItemStartDate AS clientNULLasSubscrpnContrItemStartDate,
  tstmp_to_dats( _SubscriptionContractItem.ServiceContrItemEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SubscrpnContrItemEndDate AS clientNULLasSubscrpnContrItemEndDate,
  _BusinessSolutionPortfolio.Currency AS Currency,
  _SubscriptionContractItem.ServiceObjectType AS ServiceObjectType,
  _SubscriptionContractItem.ServiceDocumentType AS ServiceDocumentType,
  _SubscriptionContractItem.SalesOrganization AS SalesOrganization,
  _SubscriptionContractItem.DistributionChannel AS DistributionChannel,
  _SubscriptionContractItem.Division AS Division,
  _SubscriptionContractItem.SalesOffice AS SalesOffice,
  _SubscriptionContractItem.SalesGroup AS SalesGroup,
  _SubscriptionContractItem.ServiceContrItemStartDateTime AS SubscrpnContrItmStartDateTime,
  _SubscriptionContractItem.ServiceContrItemEndDateTime AS SubscrpnContrItmEndDateTime,
  _SubscriptionContractItem.TransactionCurrency AS TransactionCurrency,
  _SubscriptionContractItem.SoldToParty AS SoldToParty,
  _SubscriptionContractItem.ResponsibleEmployee AS ResponsibleEmployee,
  _SubscriptionContractItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _SubscriptionContractItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _SubscriptionContractItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _SubscriptionContractItem.ServiceOrganization AS ServiceOrganization,
  _BusinessSolutionPortfolio.LastChangeDateTime AS BusSolnPrtfloLastChgDateTime
FROM I_BuSoPrtfloSubscrpnContrItm
LEFT OUTER JOIN I_ServiceDocumentItem AS _SubscriptionContractItem ON SubscriptionContract = _SubscriptionContractItem.ServiceDocument AND SubscriptionContractItem = _SubscriptionContractItem.ServiceDocumentItem AND _SubscriptionContractItem.ServiceObjectType = 'BUS2000266'  -- association [0..1]
;

Learn More