R_SubscriptionContractTP
Subscription Contract - TP
R_SubscriptionContractTP is a Transactional CDS View that provides data about "Subscription Contract - TP" in SAP S/4HANA. It reads from 1 data source (I_SubscriptionContract) and exposes 59 fields with key field SubscriptionContract. It has 12 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SubscriptionContract | I_SubscriptionContract | from |
Associations (12)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_SbsMssProcgElmContrDocChg | _SbsMssProcgElmContrDocChg | _SbsMssProcgElmContrDocChg.SubscriptionContract = $projection.SubscriptionContract and _SbsMssProcgElmContrDocChg.SubscrpnMassProcgElmntSts <> 'D' |
| [0..1] | E_ServiceDocument | _Extension | _Extension.ServiceCategory = 'BUS2000266' and $projection.SubscriptionContract = _Extension.ServiceOrder |
| [0..*] | R_SubscriptionContractItemTP | _Item | |
| [0..*] | R_SubscrpnContrPartnerTP | _SubscrpnContrPartner | |
| [0..*] | R_SubscrpnContrUserStatusTP | _SubscrpnContrUserStatus | |
| [0..*] | R_SubscrpnContrDurnTP | _SubscrpnContrDurn | |
| [0..*] | R_SubscrpnContrApptTP | _SubscrpnContrAppt | |
| [0..1] | R_SubscrpnContrKeyFigureTP | _SubscrpnContrKeyFigure | |
| [0..*] | R_SubscrpnContrChgProcTP | _SubscrpnContrChgProc | |
| [0..*] | R_SubscrpnContrPrdcssrTP | _SubscrpnContrPrdcssr | |
| [0..*] | R_SubscrpnContrSuccessorTP | _SubscrpnContrSuccessor | |
| [0..*] | R_SubscrpnContrLongTextTP | _SubscrpnContrLongText | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Subscription Contract - TP | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.sapObjectNodeType.name | SubscriptionContract | view | |
| ObjectModel.representativeKey | SubscriptionContract | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (59)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SubscriptionContract | SubscriptionContract | ||
| SubscriptionContractType | SubscriptionContractType | |||
| SubscrpnContractDescription | SubscrpnContractDescription | |||
| SubscriptionContractUUID | SubscriptionContractUUID | |||
| ServiceObjectType | ServiceObjectType | |||
| Language | Language | |||
| SubscriptionContractPostingDte | SubscriptionContractPostingDte | |||
| SubscriptionContractStatus | SubscriptionContractStatus | |||
| SubscrpnContractIsCompleted | SubscrpnContractIsCompleted | |||
| SubscriptionContractHasError | SubscriptionContractHasError | |||
| ServiceDocumentType | ServiceDocumentType | |||
| SalesOrganization | SalesOrganization | |||
| SalesOffice | SalesOffice | |||
| SalesGroup | SalesGroup | |||
| SalesOrganizationOrgUnitID | SalesOrganizationOrgUnitID | |||
| SalesOfficeOrgUnitID | SalesOfficeOrgUnitID | |||
| SalesGroupOrgUnitID | SalesGroupOrgUnitID | |||
| DistributionChannel | DistributionChannel | |||
| Division | Division | |||
| ServiceOrganization | ServiceOrganization | |||
| SoldToParty | SoldToParty | |||
| ShipToParty | ShipToParty | |||
| BillToParty | BillToParty | |||
| PayerParty | PayerParty | |||
| ContactPersonBusinessPartnerId | ContactPersonBusinessPartnerId | |||
| RespEmployeeBusinessPartnerId | RespEmployeeBusinessPartnerId | |||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeDateTime | LastChangeDateTime | |||
| _ServiceObjType | _ServiceObjType | |||
| _SoldToParty | _SoldToParty | |||
| _ShipToParty | _ShipToParty | |||
| _BillToParty | _BillToParty | |||
| _PayerParty | _PayerParty | |||
| _RespEmployee | _RespEmployee | |||
| _ContactPerson | _ContactPerson | |||
| _SalesOrganization | _SalesOrganization | |||
| _SalesOffice | _SalesOffice | |||
| _SalesGroup | _SalesGroup | |||
| _SalesOrganizationOrgUnit_2 | _SalesOrganizationOrgUnit_2 | |||
| _SalesOfficeOrgUnit_2 | _SalesOfficeOrgUnit_2 | |||
| _SalesGroupOrgUnit_2 | _SalesGroupOrgUnit_2 | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _ServiceOrganizationOrgUnit_2 | _ServiceOrganizationOrgUnit_2 | |||
| _SubscriptionContractStatus | _SubscriptionContractStatus | |||
| _SbsMssProcgElmContrDocChg | _SbsMssProcgElmContrDocChg | |||
| _Item | _Item | |||
| _SubscrpnContrPartner | _SubscrpnContrPartner | |||
| _SubscrpnContrUserStatus | _SubscrpnContrUserStatus | |||
| _SubscrpnContrDurn | _SubscrpnContrDurn | |||
| _SubscrpnContrAppt | _SubscrpnContrAppt | |||
| _SubscrpnContrKeyFigure | _SubscrpnContrKeyFigure | |||
| _SubscrpnContrChgProc | _SubscrpnContrChgProc | |||
| _SubscrpnContrPrdcssr | _SubscrpnContrPrdcssr | |||
| _SubscrpnContrSuccessor | _SubscrpnContrSuccessor | |||
| _SubscrpnContrLongText | _SubscrpnContrLongText |
@EndUserText.label: 'Subscription Contract - TP'
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
},
sapObjectNodeType.name: 'SubscriptionContract',
representativeKey: 'SubscriptionContract',
semanticKey: ['SubscriptionContract']
}
@Metadata.ignorePropagatedAnnotations: true
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
define root view entity R_SubscriptionContractTP
as select from I_SubscriptionContract
composition [0..*] of R_SubscriptionContractItemTP as _Item
composition [0..*] of R_SubscrpnContrPartnerTP as _SubscrpnContrPartner
composition [0..*] of R_SubscrpnContrUserStatusTP as _SubscrpnContrUserStatus
composition [0..*] of R_SubscrpnContrDurnTP as _SubscrpnContrDurn
composition [0..*] of R_SubscrpnContrApptTP as _SubscrpnContrAppt
composition [0..1] of R_SubscrpnContrKeyFigureTP as _SubscrpnContrKeyFigure
composition [0..*] of R_SubscrpnContrChgProcTP as _SubscrpnContrChgProc
composition [0..*] of R_SubscrpnContrPrdcssrTP as _SubscrpnContrPrdcssr
composition [0..*] of R_SubscrpnContrSuccessorTP as _SubscrpnContrSuccessor
composition [0..*] of R_SubscrpnContrLongTextTP as _SubscrpnContrLongText
association [0..1] to I_SbsMssProcgElmContrDocChg as _SbsMssProcgElmContrDocChg on _SbsMssProcgElmContrDocChg.SubscriptionContract = $projection.SubscriptionContract
and _SbsMssProcgElmContrDocChg.SubscrpnMassProcgElmntSts <> 'D'
association [0..1] to E_ServiceDocument as _Extension on _Extension.ServiceCategory = 'BUS2000266'
and $projection.SubscriptionContract = _Extension.ServiceOrder
{
key SubscriptionContract,
SubscriptionContractType,
SubscrpnContractDescription,
SubscriptionContractUUID,
ServiceObjectType,
Language,
SubscriptionContractPostingDte,
@ObjectModel.foreignKey.association: '_SubscriptionContractStatus'
SubscriptionContractStatus,
@Semantics.booleanIndicator: true
SubscrpnContractIsCompleted,
@Semantics.booleanIndicator: true
SubscriptionContractHasError,
ServiceDocumentType,
/* Organizational units with the S/4 SD codes */
SalesOrganization,
SalesOffice,
SalesGroup,
/* ORGANIZATION UNIT */
SalesOrganizationOrgUnitID,
SalesOfficeOrgUnitID,
SalesGroupOrgUnitID,
DistributionChannel,
Division,
ServiceOrganization,
SoldToParty,
ShipToParty,
BillToParty,
PayerParty,
@ObjectModel.foreignKey.association: '_ContactPerson'
ContactPersonBusinessPartnerId,
@ObjectModel.foreignKey.association: '_RespEmployee'
RespEmployeeBusinessPartnerId,
/* EXTERNAL REFERENCE*/
PurchaseOrderByCustomer,
CreatedByUser,
@Semantics.dateTime:true
CreationDateTime,
LastChangedByUser,
@Semantics.dateTime:true
LastChangeDateTime,
/* PARTNER ASSOCIATION */
_ServiceObjType,
_SoldToParty,
_ShipToParty,
_BillToParty,
_PayerParty,
_RespEmployee,
_ContactPerson,
/* ORGANIZATION ASSOCIATION */
_SalesOrganization,
_SalesOffice,
_SalesGroup,
_SalesOrganizationOrgUnit_2,
_SalesOfficeOrgUnit_2,
_SalesGroupOrgUnit_2,
_DistributionChannel,
_Division,
_ServiceOrganizationOrgUnit_2,
_SubscriptionContractStatus,
_SbsMssProcgElmContrDocChg,
/* RAP BO COMPOSITIONS */
_Item,
_SubscrpnContrPartner,
_SubscrpnContrUserStatus,
_SubscrpnContrDurn,
_SubscrpnContrAppt,
_SubscrpnContrKeyFigure,
_SubscrpnContrChgProc,
_SubscrpnContrPrdcssr,
_SubscrpnContrSuccessor,
_SubscrpnContrLongText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSCRIPTIONCONTRACT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTMGMTBUSOBJTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SBSMSSPROCGELMCONTRDOCCHG",
"I_SERVICEDOCUMENTSTATUS",
"I_SRVCMGMTORGANIZATIONUNIT",
"R_SUBSCRIPTIONCONTRACTITEMTP",
"R_SUBSCRPNCONTRAPPTTP",
"R_SUBSCRPNCONTRCHGPROCTP",
"R_SUBSCRPNCONTRDURNTP",
"R_SUBSCRPNCONTRKEYFIGURETP",
"R_SUBSCRPNCONTRLONGTEXTTP",
"R_SUBSCRPNCONTRPARTNERTP",
"R_SUBSCRPNCONTRPRDCSSRTP",
"R_SUBSCRPNCONTRSUCCESSORTP",
"R_SUBSCRPNCONTRUSERSTATUSTP"
],
"BASE":
[
"I_SUBSCRIPTIONCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA