I_SUBSCRIPTIONCONTRACT

CDS View

Subscription Contract

I_SUBSCRIPTIONCONTRACT is a CDS View in S/4HANA. Subscription Contract. It contains 1 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 1 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_SubscriptionContractAppt view_entity inner COMPOSITE Contract Appointment
I_SubscrpnContrUserStatus view_entity inner COMPOSITE Contract User Status
R_CnvChrgAllwncCntdObjTP view_entity from TRANSACTIONAL Counter of CC Allowance -TP
R_CnvChrgAllwncDefDetTP view_entity from TRANSACTIONAL Detail of CC Allowance Definition - TP
R_CnvChrgAllwncDefTP view_entity from TRANSACTIONAL Allowance Definition of CC - TP
R_CnvChrgAllwncParamTP view_entity from TRANSACTIONAL Parameter of CC Allowance - TP
R_CnvChrgAllwncTP view_entity from TRANSACTIONAL Allowance of Convergent Charging - TP
R_SbsConItmBlgReqItmPrcElmTP view_entity inner TRANSACTIONAL Billing Request Price Element - TP
R_SbscrContrItmAllwncKeyFigTP view_entity from TRANSACTIONAL KPIs of Contract Item Allowance - TP
R_SubscriptionContractTP view_entity from TRANSACTIONAL Subscription Contract - TP
R_SubscrpnContrChgProcTP view_entity from TRANSACTIONAL Change Process of Contract - TP
R_SubscrpnContrItmKeyFigTP view_entity from TRANSACTIONAL KPIs of Contract Item - TP
R_SubscrpnContrItmPrElmntTP view_entity inner TRANSACTIONAL Contract Item Price Element - TP
R_SubscrpnContrKeyFigureTP view_entity from TRANSACTIONAL KPIs of Contract - TP

Fields (1)

KeyField CDS FieldsUsed in Views
KEY SubscriptionContract SubscriptionContract 4 
@EndUserText.label: 'Subscription Contract'

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   representativeKey: 'SubscriptionContract',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_SubscriptionContract
  as select from I_ServiceDocumentEnhcd

  association [0..*] to I_SubscriptionContractItem as _Item                       on  $projection.SubscriptionContract = _Item.SubscriptionContract

  association [0..1] to I_ServiceDocumentStatus    as _SubscriptionContractStatus on  $projection.SubscriptionContractStatus = _SubscriptionContractStatus.ServiceDocumentStatus


  association [0..1] to E_ServiceDocument          as _Extension                  on  _Extension.ServiceCategory       = 'BUS2000266'
                                                                                  and $projection.SubscriptionContract = _Extension.ServiceOrder

{
  key ServiceDocument              as SubscriptionContract,
      ServiceDocumentType          as SubscriptionContractType,
      @Semantics.text: true
      ServiceDocumentDescription   as SubscrpnContractDescription,
      ServiceDocumentUUID          as SubscriptionContractUUID,
      ServiceObjectType,
      ServiceDocumentType,

      Language,
      PostingDate                  as SubscriptionContractPostingDte,

      /* STATUS */
      @ObjectModel.foreignKey.association: '_SubscriptionContractStatus'
      ServiceDocumentStatus        as SubscriptionContractStatus,

      @Semantics.booleanIndicator: true
      case
        when ServiceDocumentStatus = 'C' then 'X'
        when ServiceDocumentStatus <> 'C' then ''
      end                          as SubscrpnContractIsCompleted,

      @Semantics.booleanIndicator: true
      ServiceDocumentHasError      as SubscriptionContractHasError,

      /* PRICING */
      PricingDocument,
      PricingProcedure,

      /* Organizational units with the S/4 SD codes */
      SalesOrganization,
      SalesOffice,
      SalesGroup,

      /* ORGANIZATION UNIT */
      SalesOrganizationOrgUnitID,
      SalesOfficeOrgUnitID,
      SalesGroupOrgUnitID,
      DistributionChannel,
      Division,
      ServiceOrganization,

      /* PARTNER */
      SoldToParty,
      ShipToParty,
      BillToParty,
      PayerParty,
      @ObjectModel.foreignKey.association: '_ContactPerson'
      ContactPerson                as ContactPersonBusinessPartnerId,
      @ObjectModel.foreignKey.association: '_RespEmployee'
      ResponsibleEmployee          as RespEmployeeBusinessPartnerId,

      /* EXTERNAL REFERENCE*/
      PurchaseOrderByCustomer,

      ServiceDocumentCreatedByUser as CreatedByUser,
      @Semantics.dateTime:true
      ServiceDocCreationDateTime   as CreationDateTime,
      ServiceDocumentChangedByUser as LastChangedByUser,
      @Semantics.dateTime:true
      ServiceDocChangedDateTime    as LastChangeDateTime,

      //Associations

      _ServiceObjType,
      _SoldToParty,
      _ShipToParty,
      _BillToParty,
      _PayerParty,
      _SalesOrganization,
      _SalesOffice,
      _SalesGroup,
      _SalesOrganizationOrgUnit_2,
      _SalesOfficeOrgUnit_2,
      _SalesGroupOrgUnit_2,
      _DistributionChannel,
      _Division,
      _ServiceOrganizationOrgUnit_2,
      _ContactPerson,
      _RespEmployee,
      _SubscriptionContractStatus,

      _Item

}
where
  ServiceObjectType = 'BUS2000266'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTMGMTBUSOBJTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SERVICEDOCUMENTSTATUS",
"I_SRVCMGMTORGANIZATIONUNIT",
"I_SUBSCRIPTIONCONTRACTITEM"
],
"BASE":
[
"I_SERVICEDOCUMENTENHCD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More