P_SubscriptionContractItem

DDL: P_SUBSCRIPTIONCONTRACTITEM Type: view_entity BASIC
44 Fields 1 Data Sources

Subscription Contract Item

P_SubscriptionContractItem is a Basic CDS View that provides data about "Subscription Contract Item" in SAP S/4HANA. It reads from 1 data source (crms4d_serv_i) and exposes 44 fields with key fields SubscriptionContract, SubscriptionContractItem.

Data Sources (1)

SourceAliasJoin Type
crms4d_serv_i crms4d_serv_i from

Annotations (8)

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

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract object_id Transaction ID
KEY SubscriptionContractItem number_int Item Number in Doc.
SubscriptionContrItmDesc description_i Short Text
SubscriptionContractItemUUID item_guid Push ItemGU
SubscrpnContrItmCharUUID item_guid_char Object GUID
TransactionCurrency currency Valuation Crcy
SubscrpnContrItmNetAmount net_value_i Net Value
SubscrpnContrItmGrossAmount gross_value_i Gross Value
SubscrpnContrItmTaxAmount tax_amount_i Tax amount
ParentSubscrpnContractItemUUID parent UUID
SubscrpnContrItmStartDateTime contstart Contract Start Date
SubscrpnContrItmEndDateTime contend Contract End Date
SubscrpnContrActivationStatus stat_activation Activation Status
SbscrContrTimeSliceStrtDteTme cont_start_ts Start of Contract TS
SbscrContrTimeSliceEndDteTme cont_end_ts End of Contract TS
SubscrpnContractItemIsRejected stat_cancelled Cancellation Status
Quantity order_qty PO Quantity
QuantityUnit process_qty_unit Sales Unit
SrvcTransChangeProcess btmf_process Process of Maint. FW
SrvcTransChangeProcessType btmf_process_type Process Type
SrvcTransChangeProcessGroup changeprocessgroup BTMF Process Group
BusSolutionQtnItemIsPhased phase_indicator Phase Indicator
BusSolnQtnItmPhasedPrdcssrItem successor_of Item Number in Doc.
Product product_id Simulated Product ID
SubscrpnContrTimeSliceStatus stat_cont_ts Time Slice Status
SubscrpnOrdProdSelType prod_sel_type Prod.Selection Type
SalesOrganizationOrgUnitID sales_org Sales Organization
SalesOfficeOrgUnitID sales_office Sales Office
SalesGroupOrgUnitID sales_group Sales Group
DistributionChannel dis_channel Distribution Channel
Division division Internal Division ID
ServiceOrganization service_org Service Organization
SalesOrganization sales_org_sd Sales Org.
SalesOffice sales_office_sd Sales Office
SalesGroup sales_group_sd Sales Group
RespEmployeeBusinessPartnerId person_resp Employee Responsible
ServiceObjectType objtype_h Trans. Cat.
ServiceDocumentItemObjectType objtype_i Object Type
ServiceDocumentType process_type Type of Data
SbscrShContrSvTrMtAgrItmUUID ma_share_ref MA MainItem Ref
SbscrShContrSvTrMtAgrItmCstPrd ma_share_ref_prod_id Custom Product ID
SubscrpnContrItmBillgPlnCyc ci_billing_plan_cycle Billing Plan Cycle
SubscrpnContrItmIsWithdrawn stat_withdrawn Withdrawal Status
SubscrpnContrItmHasError stat_error Error Status

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 P_SubscriptionContractItem.
-- 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 P_SubscriptionContractItem AS
SELECT
  object_id AS SubscriptionContract,
  number_int AS SubscriptionContractItem,
  description_i AS SubscriptionContrItmDesc,
  item_guid AS SubscriptionContractItemUUID,
  item_guid_char AS SubscrpnContrItmCharUUID,
  currency AS TransactionCurrency,
  net_value_i AS SubscrpnContrItmNetAmount,
  gross_value_i AS SubscrpnContrItmGrossAmount,
  tax_amount_i AS SubscrpnContrItmTaxAmount,
  parent AS ParentSubscrpnContractItemUUID,
  contstart AS SubscrpnContrItmStartDateTime,
  contend AS SubscrpnContrItmEndDateTime,
  stat_activation AS SubscrpnContrActivationStatus,
  cont_start_ts AS SbscrContrTimeSliceStrtDteTme,
  cont_end_ts AS SbscrContrTimeSliceEndDteTme,
  stat_cancelled AS SubscrpnContractItemIsRejected,
  order_qty AS Quantity,
  process_qty_unit AS QuantityUnit,
  btmf_process AS SrvcTransChangeProcess,
  btmf_process_type AS SrvcTransChangeProcessType,
  changeprocessgroup AS SrvcTransChangeProcessGroup,
  phase_indicator AS BusSolutionQtnItemIsPhased,
  successor_of AS BusSolnQtnItmPhasedPrdcssrItem,
  product_id AS Product,
  stat_cont_ts AS SubscrpnContrTimeSliceStatus,
  prod_sel_type AS SubscrpnOrdProdSelType,
  sales_org AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  dis_channel AS DistributionChannel,
  Division,
  service_org AS ServiceOrganization,
  sales_org_sd AS SalesOrganization,
  sales_office_sd AS SalesOffice,
  sales_group_sd AS SalesGroup,
  person_resp AS RespEmployeeBusinessPartnerId,
  objtype_h AS ServiceObjectType,
  objtype_i AS ServiceDocumentItemObjectType,
  process_type AS ServiceDocumentType,
  ma_share_ref AS SbscrShContrSvTrMtAgrItmUUID,
  ma_share_ref_prod_id AS SbscrShContrSvTrMtAgrItmCstPrd,
  ci_billing_plan_cycle AS SubscrpnContrItmBillgPlnCyc,
  stat_withdrawn AS SubscrpnContrItmIsWithdrawn,
  stat_error AS SubscrpnContrItmHasError
FROM crms4d_serv_i
;

Learn More