C_SubscriptionContractItemTP_2

DDL: C_SUBSCRIPTIONCONTRACTITEMTP_2 Type: view_entity CONSUMPTION
82 Fields 1 Data Sources 1 Associations

Subscription Contract Item - TP

C_SubscriptionContractItemTP_2 is a Consumption CDS View that provides data about "Subscription Contract Item - TP" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionContractItemTP) and exposes 82 fields with key fields SubscriptionContract, SubscriptionContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SubscriptionContractItemTP R_SubscriptionContractItemTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_SubscrpnContrAllHierNode_2 _Hierarchy $projection.SubscriptionContract = _Hierarchy.SubscriptionContract and $projection.SubscriptionContractExternalID = _Hierarchy.SubscriptionContractExternalID

Annotations (10)

NameValueLevelField
EndUserText.label Subscription Contract Item - TP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view
Consumption.ranked true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
SubscriptionContractExternalID SubscriptionContractExternalID Contract Number
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentItemObjectType ServiceDocumentItemObjectType
ServiceDocumentType ServiceDocumentType Transaction Type
SubscrpnContractItemCategory SubscrpnContractItemCategory
Product Product Product Sold
ProductNameasProductNamelocalized
SubscrpnProductSpecification SubscrpnProductSpecification
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
TransactionCurrency TransactionCurrency Transaction Currency
SubscrpnContrItmGrossAmount SubscrpnContrItmGrossAmount
SubscrpnContrItmNetAmount SubscrpnContrItmNetAmount
SubscrpnContrItmTaxAmount SubscrpnContrItmTaxAmount
SubscrpnContrItmOneTmeGrossAmt SubscrpnContrItmOneTmeGrossAmt
SubscrpnContrItmOneTmeNetAmt SubscrpnContrItmOneTmeNetAmt
SubscrpnContrItmOneTmeTaxAmt SubscrpnContrItmOneTmeTaxAmt
SbscrContrItmRecrrgChrgGrssAmt SbscrContrItmRecrrgChrgGrssAmt
SbscrContrItmRecrrgChrgNetAmt SbscrContrItmRecrrgChrgNetAmt
SbscrContrItmRecrrgChrgTaxAmt SbscrContrItmRecrrgChrgTaxAmt
SubscrpnContrItmValdtyPerd
SubscrpnContrItmValdtyPerdUnt
SbscrContrItmValdtyPerdUntTxt
PaymentTerms PaymentTerms Pyt Terms
PaymentTermsNamelocalized
CAPartnerSettlementRule CAPartnerSettlementRule Settlement Rule
CAPartnerSettlementRuleTextlocalized
SubscriptionContrItmDesc SubscriptionContrItmDesc
SubscriptionContractItemUUID SubscriptionContractItemUUID
SubscrpnContrItmCharUUID SubscrpnContrItmCharUUID
ParentSubscrpnContractItemUUID ParentSubscrpnContractItemUUID
ParentSubscriptionContractItem _ParentServiceDocItem_2 ServiceDocumentItem Service Document
SubscrpnOrdProdSelType SubscrpnOrdProdSelType
SubscrpnContrItmIsMainItem SubscrpnContrItmIsMainItem
Language Language Report Text Language
SbscrContrItmDeliveryPlanType SbscrContrItmDeliveryPlanType
SrvcDocItmDeliveryPlanTypeTextlocalized
SbscrContrItmDelivPlnPerdRule SbscrContrItmDelivPlnPerdRule
CustMgmtDateRuleTextlocalized
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationNamelocalized
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelNamelocalized
Division Division Internal Division ID
DivisionNamelocalized
SalesOffice SalesOffice Sales Office
SalesOfficeNamelocalized
SalesGroup SalesGroup Sales Group
SalesGroupNamelocalized
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
SubscrpnContractItemIsActive SubscrpnContractItemIsActive
SubscrpnContrActivationStatus SubscrpnContrActivationStatus
SubscrpnContrActvtnStsTextlocalized
SubscrpnContrTimeSliceStatus SubscrpnContrTimeSliceStatus
SubscriptionContractItemStatus SubscriptionContractItemStatus
SubscrpnContrItmHasError SubscrpnContrItmHasError
SubscrpnContrItmCrdtSts SubscrpnContrItmCrdtSts
SubscrpnContractItemIsRejected SubscrpnContractItemIsRejected
SbsConItmGTSEmbargoStatus SbsConItmGTSEmbargoStatus
SbsConItmGTSScreeningStatus SbsConItmGTSScreeningStatus
SbsConItmGTSLglControlStatus SbsConItmGTSLglControlStatus
SubscrpnContrItmIsCancelled SubscrpnContrItmIsCancelled
SbscrContrItmCanclnProcedure SbscrContrItmCanclnProcedure
SbscrContrItemCanclnReason SbscrContrItemCanclnReason
SbscrContrItmCanclnRsnTxtlocalized
SbscrContrItemCanclnParty SbscrContrItemCanclnParty
SbscrContrItemCanclnPartyTextlocalized
SubscrpnContrItmRjcnRsn SubscrpnContrItmRjcnRsn
SalesDocumentRjcnReasonNamelocalized
SbscrContrItmCanclnRecDateTime
SbscrContrItmCanclnReqDateTime
SubscrpnContrItmCanclnDteTme SubscrpnContrItmCanclnDteTme
SubscrpnContrItmStartDateTime SubscrpnContrItmStartDateTime
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime
SbscrContrTimeSliceStrtDteTme SbscrContrTimeSliceStrtDteTme
SbscrContrTimeSliceEndDteTme SbscrContrTimeSliceEndDteTme
SubscrpnContrTrmEndDteTme

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_2.
-- 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_2 AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  SubscriptionContractExternalID,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  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,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentSubscriptionContractItem,
  SubscrpnOrdProdSelType,
  SubscrpnContrItmIsMainItem,
  Language,
  SbscrContrItmDeliveryPlanType,
  _SrvcDocDeliveryPlanType._Text.SrvcDocItmDeliveryPlanTypeText : localized AS SrvcDocItmDeliveryPlanTypeTextlocalized,
  SbscrContrItmDelivPlnPerdRule,
  _SrvcDocItmDelivPlanPeriodRule._CustMgmtDateRuleText.CustMgmtDateRuleText : localized AS CustMgmtDateRuleTextlocalized,
  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
FROM R_SubscriptionContractItemTP
LEFT OUTER JOIN C_SubscrpnContrAllHierNode_2 AS _Hierarchy ON SubscriptionContract = _Hierarchy.SubscriptionContract AND SubscriptionContractExternalID = _Hierarchy.SubscriptionContractExternalID  -- association [0..*]
;

Learn More