C_SubscriptionContractItemSitn

DDL: C_SUBSCRIPTIONCONTRACTITEMSITN Type: view_entity CONSUMPTION
30 Fields 1 Data Sources

SOM Subcription Contract End Situation

C_SubscriptionContractItemSitn is a Consumption CDS View that provides data about "SOM Subcription Contract End Situation" in SAP S/4HANA. It reads from 1 data source (I_SubscriptionContractItemSitn) and exposes 30 fields with key fields ServiceObjectType, SubscriptionContract, SubscriptionContractItem.

Data Sources (1)

SourceAliasJoin Type
I_SubscriptionContractItemSitn SubscriptionContractItem from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.uniqueIdField SubscriptionContractItemUUID view
EndUserText.label SOM Subcription Contract End Situation view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_SubscriptionContractItemSitn ServiceObjectType Object Type
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocItemCategory ServiceDocItemCategory
Product Product Product Sold
ServiceDocumentItemQuantity ServiceDocumentItemQuantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit
SubscriptionContractExternalID SubscriptionContractExternalID Contract Number
SoldToParty SoldToParty Sold-to Party
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
ResponsibleEmployeeUserID ResponsibleEmployeeUserID User Name
NrOfSbscrContrItemExprdDays NrOfSbscrContrItemExprdDays Days Before Subscription Contract Item End Date
SubscrpnContrItemEndDate SubscrpnContrItemEndDate Subscription Contract Item End Date
SbscrContrItmGrcePerdDteTme SbscrContrItmGrcePerdDteTme Subscription Contract Item Grace Period End Date
NrOfSbscrContrItemGrcePerdDays NrOfSbscrContrItemGrcePerdDays Days Before End of Grace Period for Subscription Contract Item
SubscriptionContractItemUUID SubscriptionContractItemUUID
SubscrpnContrItmCharUUID SubscrpnContrItmCharUUID
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime
SalesOrganizationOrgUnitID I_SubscriptionContractItemSitn SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_SubscriptionContractItemSitn SalesOfficeOrgUnitID
ServiceOrganization ServiceOrganization
SalesGroupOrgUnitID SalesGroupOrgUnitID
SalesOrganization I_SubscriptionContractItemSitn SalesOrganization Sales Organization
DistributionChannel I_SubscriptionContractItemSitn DistributionChannel RefDistCh-Cust/Mat.
Division I_SubscriptionContractItemSitn Division Internal Division ID
SalesOffice I_SubscriptionContractItemSitn SalesOffice Sales Office
SalesGroup I_SubscriptionContractItemSitn SalesGroup Sales Group
_RespEmployee _RespEmployee
_ServiceDocument _ServiceDocument

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_SubscriptionContractItemSitn.
-- 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_SubscriptionContractItemSitn AS
SELECT
  SubscriptionContractItem.ServiceObjectType AS ServiceObjectType,
  SubscriptionContract,
  SubscriptionContractItem,
  ServiceDocumentType,
  ServiceDocItemCategory,
  Product,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  SubscriptionContractExternalID,
  SoldToParty,
  RespEmployeeBusinessPartnerId,
  ResponsibleEmployeeUserID,
  NrOfSbscrContrItemExprdDays,
  SubscrpnContrItemEndDate,
  SbscrContrItmGrcePerdDteTme,
  NrOfSbscrContrItemGrcePerdDays,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  SubscrpnContrItmEndDateTime,
  SubscriptionContractItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SubscriptionContractItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrganization,
  SalesGroupOrgUnitID,
  SubscriptionContractItem.SalesOrganization AS SalesOrganization,
  SubscriptionContractItem.DistributionChannel AS DistributionChannel,
  SubscriptionContractItem.Division AS Division,
  SubscriptionContractItem.SalesOffice AS SalesOffice,
  SubscriptionContractItem.SalesGroup AS SalesGroup
FROM I_SubscriptionContractItemSitn AS SubscriptionContractItem
;

Learn More