R_BusSolnOrdItmPartnerAddrTP
Business Soln Ord Item Partner Address - TP
R_BusSolnOrdItmPartnerAddrTP is a Transactional CDS View that provides data about "Business Soln Ord Item Partner Address - TP" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItem, R_SrvcDocItemPartnerAddress) and exposes 42 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 1 association to related views. Part of development package CRMS4_SOLUTION_ORDER_RAP.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentItem | BusinessSolutionOrderItem | inner |
| R_SrvcDocItemPartnerAddress | ServicePartnerAddress | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_BusinessSolutionOrderTP | _BusinessSolutionOrderTP | $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Business Soln Ord Item Partner Address - TP | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view |
Fields (42)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessSolutionOrder | R_SrvcDocItemPartnerAddress | ServiceDocument | |
| KEY | BusinessSolutionOrderItem | R_SrvcDocItemPartnerAddress | ServiceDocumentItem | |
| KEY | CustMgmtPartnerFunction | R_SrvcDocItemPartnerAddress | CustMgmtPartnerFunction | |
| KEY | CustMgmtBusinessPartner | R_SrvcDocItemPartnerAddress | CustMgmtBusinessPartner | |
| AddressID | R_SrvcDocItemPartnerAddress | AddressID | ||
| AddressPersonID | R_SrvcDocItemPartnerAddress | AddressPersonID | ||
| AddressObjectType | R_SrvcDocItemPartnerAddress | AddressObjectType | ||
| AddresseeFullName | R_SrvcDocItemPartnerAddress | AddresseeFullName | ||
| CityName | R_SrvcDocItemPartnerAddress | CityName | ||
| CorrespondenceLanguage | R_SrvcDocItemPartnerAddress | CorrespondenceLanguage | ||
| Country | R_SrvcDocItemPartnerAddress | Country | ||
| DistrictName | R_SrvcDocItemPartnerAddress | DistrictName | ||
| EmailAddress | R_SrvcDocItemPartnerAddress | EmailAddress | ||
| FaxAreaCodeSubscriberNumber | R_SrvcDocItemPartnerAddress | FaxAreaCodeSubscriberNumber | ||
| FaxExtensionNumber | R_SrvcDocItemPartnerAddress | FaxExtensionNumber | ||
| FaxNumberCountry | R_SrvcDocItemPartnerAddress | FaxNumberCountry | ||
| FormOfAddress | R_SrvcDocItemPartnerAddress | FormOfAddress | ||
| HouseNumber | R_SrvcDocItemPartnerAddress | HouseNumber | ||
| MobileNumber | R_SrvcDocItemPartnerAddress | MobileNumber | ||
| MobilePhoneCountry | R_SrvcDocItemPartnerAddress | MobilePhoneCountry | ||
| OrganizationName1 | R_SrvcDocItemPartnerAddress | OrganizationName1 | ||
| OrganizationName2 | R_SrvcDocItemPartnerAddress | OrganizationName2 | ||
| OrganizationName3 | R_SrvcDocItemPartnerAddress | OrganizationName3 | ||
| OrganizationName4 | R_SrvcDocItemPartnerAddress | OrganizationName4 | ||
| PersonFamilyName | R_SrvcDocItemPartnerAddress | PersonFamilyName | ||
| PersonGivenName | R_SrvcDocItemPartnerAddress | PersonGivenName | ||
| PhoneExtensionNumber | R_SrvcDocItemPartnerAddress | PhoneExtensionNumber | ||
| PhoneNumber | R_SrvcDocItemPartnerAddress | PhoneNumber | ||
| PhoneNumberCountry | R_SrvcDocItemPartnerAddress | PhoneNumberCountry | ||
| POBox | R_SrvcDocItemPartnerAddress | POBox | ||
| POBoxPostalCode | R_SrvcDocItemPartnerAddress | POBoxPostalCode | ||
| PostalCode | R_SrvcDocItemPartnerAddress | PostalCode | ||
| Region | R_SrvcDocItemPartnerAddress | Region | ||
| StreetName | R_SrvcDocItemPartnerAddress | StreetName | ||
| StreetPrefixName1 | R_SrvcDocItemPartnerAddress | StreetPrefixName1 | ||
| StreetPrefixName2 | R_SrvcDocItemPartnerAddress | StreetPrefixName2 | ||
| StreetSuffixName1 | R_SrvcDocItemPartnerAddress | StreetSuffixName1 | ||
| StreetSuffixName2 | R_SrvcDocItemPartnerAddress | StreetSuffixName2 | ||
| TaxJurisdiction | R_SrvcDocItemPartnerAddress | TaxJurisdiction | ||
| TransportZone | R_SrvcDocItemPartnerAddress | TransportZone | ||
| _BusSolnOrdItmPartnerTP | _BusSolnOrdItmPartnerTP | |||
| _BusinessSolutionOrderTP | _BusinessSolutionOrderTP |
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Business Soln Ord Item Partner Address - TP'
@ObjectModel: {
usageType: {dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L}
}
define view entity R_BusSolnOrdItmPartnerAddrTP
as select from R_SrvcDocItemPartnerAddress as ServicePartnerAddress
inner join I_ServiceDocumentItem as BusinessSolutionOrderItem on ServicePartnerAddress.ServiceDocument = BusinessSolutionOrderItem.ServiceDocument
and ServicePartnerAddress.ServiceDocumentItem = BusinessSolutionOrderItem.ServiceDocumentItem
and BusinessSolutionOrderItem.ServiceObjectType = 'BUS2000172'
association to parent R_BusSolnOrdItmPartnerTP as _BusSolnOrdItmPartnerTP on $projection.BusinessSolutionOrder = _BusSolnOrdItmPartnerTP.BusinessSolutionOrder
and $projection.BusinessSolutionOrderItem = _BusSolnOrdItmPartnerTP.BusinessSolutionOrderItem
and $projection.CustMgmtPartnerFunction = _BusSolnOrdItmPartnerTP.CustMgmtPartnerFunction
and $projection.CustMgmtBusinessPartner = _BusSolnOrdItmPartnerTP.CustMgmtBusinessPartner
association [0..1] to R_BusinessSolutionOrderTP as _BusinessSolutionOrderTP on $projection.BusinessSolutionOrder = _BusinessSolutionOrderTP.BusinessSolutionOrder
{
@ObjectModel.foreignKey.association: '_BusinessSolutionOrderTP'
key ServicePartnerAddress.ServiceDocument as BusinessSolutionOrder,
key ServicePartnerAddress.ServiceDocumentItem as BusinessSolutionOrderItem,
key ServicePartnerAddress.CustMgmtPartnerFunction,
key ServicePartnerAddress.CustMgmtBusinessPartner,
ServicePartnerAddress.AddressID,
ServicePartnerAddress.AddressPersonID,
ServicePartnerAddress.AddressObjectType,
ServicePartnerAddress.AddresseeFullName,
ServicePartnerAddress.CityName,
ServicePartnerAddress.CorrespondenceLanguage,
ServicePartnerAddress.Country,
ServicePartnerAddress.DistrictName,
ServicePartnerAddress.EmailAddress,
ServicePartnerAddress.FaxAreaCodeSubscriberNumber,
ServicePartnerAddress.FaxExtensionNumber,
ServicePartnerAddress.FaxNumberCountry,
ServicePartnerAddress.FormOfAddress,
ServicePartnerAddress.HouseNumber,
ServicePartnerAddress.MobileNumber,
ServicePartnerAddress.MobilePhoneCountry,
ServicePartnerAddress.OrganizationName1,
ServicePartnerAddress.OrganizationName2,
ServicePartnerAddress.OrganizationName3,
ServicePartnerAddress.OrganizationName4,
ServicePartnerAddress.PersonFamilyName,
ServicePartnerAddress.PersonGivenName,
ServicePartnerAddress.PhoneExtensionNumber,
ServicePartnerAddress.PhoneNumber,
ServicePartnerAddress.PhoneNumberCountry,
ServicePartnerAddress.POBox,
ServicePartnerAddress.POBoxPostalCode,
ServicePartnerAddress.PostalCode,
ServicePartnerAddress.Region,
ServicePartnerAddress.StreetName,
ServicePartnerAddress.StreetPrefixName1,
ServicePartnerAddress.StreetPrefixName2,
ServicePartnerAddress.StreetSuffixName1,
ServicePartnerAddress.StreetSuffixName2,
ServicePartnerAddress.TaxJurisdiction,
ServicePartnerAddress.TransportZone,
//Associations
_BusSolnOrdItmPartnerTP,
_BusinessSolutionOrderTP
}
where
ServicePartnerAddress.CustMgmtObjectType = 'BUS2000172'
and ServicePartnerAddress.ServiceDocumentItem is not initial
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