I_SubscriptionContractStdVH

DDL: I_SUBSCRIPTIONCONTRACTSTDVH SQL: ISUBSCRCONTRVH Type: view COMPOSITE

Subscription Contract Value Help

I_SubscriptionContractStdVH is a Composite CDS View that provides data about "Subscription Contract Value Help" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 31 fields with key fields ServiceDocumentType, ServiceDocument.

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISUBSCRCONTRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ServiceDocument view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Subscription Contract Value Help view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType
KEY ServiceDocument ServiceDocument
ServiceDocumentDescription ServiceDocumentDescription
ServiceObjectType ServiceObjectType
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SalesOffice SalesOffice
SalesGroup SalesGroup
_ServiceDocumentType _ServiceDocumentType
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ResponsibleEmployee ResponsibleEmployee
_ServiceObjType _ServiceObjType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_RespEmployee _RespEmployee 
@AbapCatalog.sqlViewName: 'ISUBSCRCONTRVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ServiceDocument'
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XL, dataClass: #TRANSACTIONAL }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Subscription Contract Value Help'

define view I_SubscriptionContractStdVH
  as select from I_ServiceDocument
{

  key ServiceDocumentType,
  key ServiceDocument,
      ServiceDocumentDescription,

      ServiceObjectType,
      SoldToParty,
      SalesOrganization,
      DistributionChannel,
      Division,
      SalesOffice,
      SalesGroup,

      _ServiceDocumentType,
      
//      @ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit'

      @ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit_2'      
      SalesOrganizationOrgUnitID,
      
//      @ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit'

      @ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit_2'      
      SalesOfficeOrgUnitID,
      
//      @ObjectModel.foreignKey.association: '_SalesGroupOrgUnit'

      @ObjectModel.foreignKey.association: '_SalesGroupOrgUnit_2'      
      SalesGroupOrgUnitID,
      
      @UI.hidden: true
//      @ObjectModel.foreignKey.association: '_ServiceOrganizationOrgUnit'

      @ObjectModel.foreignKey.association: '_ServiceOrganizationOrgUnit_2'      
      ServiceOrganization,
      
      @UI.hidden: true
      @Consumption.filter.hidden: true 
      @ObjectModel.foreignKey.association: '_RespEmployee'
      ResponsibleEmployee,
      
      
      //Association

      _ServiceObjType,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _SalesOffice,
      _SalesGroup,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOrganizationOrgUnit_2'      
      _SalesOrganizationOrgUnit,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOfficeOrgUnit_2'          
      _SalesOfficeOrgUnit,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesGroupOrgUnit_2'          
      _SalesGroupOrgUnit,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_ServiceOrganizationOrgUnit_2'          
      _ServiceOrganizationOrgUnit,
      _SalesOrganizationOrgUnit_2,
      _SalesOfficeOrgUnit_2,
      _SalesGroupOrgUnit_2,
      _ServiceOrganizationOrgUnit_2,      
      _RespEmployee     
      
}
where
  ServiceObjectType = 'BUS2000266'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTMGMTBUSOBJTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONUNIT",
"I_SERVICEDOCUMENTTYPE",
"I_SRVCMGMTORGANIZATIONUNIT"
],
"BASE":
[
"I_SERVICEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More