I_SubscrpnContrItmActvItm

DDL: I_SUBSCRPNCONTRITMACTVITM Type: view_entity BASIC
34 Fields 1 Data Sources 1 Associations

Subscription Contract Active Items

I_SubscrpnContrItmActvItm is a Basic CDS View that provides data about "Subscription Contract Active Items" in SAP S/4HANA. It reads from 1 data source (P_SubscriptionContractItem) and exposes 34 fields with key fields SubscriptionContract, SubscriptionContractExternalID, SubscriptionContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SubscriptionContractItem P_SubscriptionContractItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_SubscriptionContractItem _ParentItem $projection.ParentSubscrpnContractItemUUID = _ParentItem.SubscriptionContractItemUUID and $projection.SubscriptionContract = _ParentItem.SubscriptionContract

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subscription Contract Active Items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractExternalID SubscriptionContractExternalID Contract Number
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
SubscriptionContractItemUUID SubscriptionContractItemUUID Push ItemGU
SubscrpnContrItmCharUUID SubscrpnContrItmCharUUID Object GUID
ParentSubscrpnContractItemUUID ParentSubscrpnContractItemUUID UUID
Product Product Product Sold
SubscrpnContrItmStartDateTime SubscrpnContrItmStartDateTime Contract Start Date
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime Contract End Date
SbscrContrTimeSliceStrtDteTme SbscrContrTimeSliceStrtDteTme Start of Contract TS
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
TransactionCurrency TransactionCurrency Transaction Currency
SubscrpnContrItmNetAmount SubscrpnContrItmNetAmount Net Value
SubscrpnContrItmGrossAmount SubscrpnContrItmGrossAmount Gross Value
SubscrpnContrItmTaxAmount SubscrpnContrItmTaxAmount Tax amount
SubscrpnContractItemIsRejected SubscrpnContractItemIsRejected Cancellation Status
SubscrpnContrTimeSliceStatus SubscrpnContrTimeSliceStatus Time Slice Status
SubscrpnContrItmIsWithdrawn SubscrpnContrItmIsWithdrawn Withdrawal Status
SubscrpnContrItmIsCancelled SubscrpnContrItmIsCancelled
SubscrpnContrItmHasError SubscrpnContrItmHasError Error Status
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Responsible
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentItemObjectType ServiceDocumentItemObjectType Object Type
ServiceDocumentType ServiceDocumentType Transaction Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
ServiceOrganization ServiceOrganization Service Organization

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_SubscrpnContrItmActvItm.
-- 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_SubscrpnContrItmActvItm AS
SELECT
  SubscriptionContract,
  SubscriptionContractExternalID,
  SubscriptionContractItem,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  ParentSubscrpnContractItemUUID,
  Product,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  Quantity,
  QuantityUnit,
  TransactionCurrency,
  SubscrpnContrItmNetAmount,
  SubscrpnContrItmGrossAmount,
  SubscrpnContrItmTaxAmount,
  SubscrpnContractItemIsRejected,
  SubscrpnContrTimeSliceStatus,
  SubscrpnContrItmIsWithdrawn,
  SubscrpnContrItmIsCancelled,
  SubscrpnContrItmHasError,
  RespEmployeeBusinessPartnerId,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  ServiceDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM P_SubscriptionContractItem
LEFT OUTER JOIN P_SubscriptionContractItem AS _ParentItem ON ParentSubscrpnContractItemUUID = _ParentItem.SubscriptionContractItemUUID AND SubscriptionContract = _ParentItem.SubscriptionContract  -- association [0..1]
;

Learn More