R_CollsMgmtBusinessPartnerTP
Collections Management: Business Partner
R_CollsMgmtBusinessPartnerTP is a Transactional CDS View that provides data about "Collections Management: Business Partner" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartnerCustomer, I_BusinessPartnerToBPRole) and exposes 7 fields with key field BusinessPartner. It has 4 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerCustomer | I_BusinessPartnerCustomer | inner |
| I_BusinessPartnerToBPRole | I_BusinessPartnerToBPRole | inner |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_BusinessPartner | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
| [0..1] | I_Customer | _Customer | $projection.Customer = _Customer.Customer |
| [0..1] | R_BusPartCollsProfileAssgmtTP | _BusPartCollsProfileAssgmtTP | |
| [0..*] | R_BPCollsSegmentAssignmentTP | _BPCollsSegmentAssignmentTP | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| EndUserText.label | Collections Management: Business Partner | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | BusinessPartner | view | |
| ObjectModel.sapObjectNodeType.name | CollectionsManagementAccount | view |
Fields (7)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessPartner | I_BusinessPartner | BusinessPartner | |
| Customer | I_BusinessPartnerCustomer | Customer | ||
| LastChangeDateTime | I_BPCollectionProfileAssgmt | LastChangeDateTime | ||
| _BusinessPartner | _BusinessPartner | |||
| _Customer | _Customer | |||
| _BusPartCollsProfileAssgmtTP | _BusPartCollsProfileAssgmtTP | |||
| _BPCollsSegmentAssignmentTP | _BPCollsSegmentAssignmentTP |
@AccessControl: { authorizationCheck: #CHECK,
personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Collections Management: Business Partner' }
@VDM: { viewType: #TRANSACTIONAL,
lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType: { serviceQuality: #X,
sizeCategory: #L,
dataClass: #TRANSACTIONAL },
semanticKey: [ 'BusinessPartner' ],
representativeKey: 'BusinessPartner',
sapObjectNodeType: { name: 'CollectionsManagementAccount' } }
define root view entity R_CollsMgmtBusinessPartnerTP
as select distinct from I_BusinessPartner
inner join I_BusinessPartnerToBPRole on I_BusinessPartner.BusinessPartner = I_BusinessPartnerToBPRole.BusinessPartner
inner join I_BusinessPartnerCustomer on I_BusinessPartner.BusinessPartner = I_BusinessPartnerCustomer.BusinessPartner
left outer to one join I_BPCollectionProfileAssgmt on I_BusinessPartner.BusinessPartner = I_BPCollectionProfileAssgmt.BusinessPartner
and I_BPCollectionProfileAssgmt.BPCollPrflAssignmentValidTo = '99991231'
// VDM Associations
// Business Partner
association [0..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
// Customer
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
// BO Composition
// Collections Profile
composition [0..1] of R_BusPartCollsProfileAssgmtTP as _BusPartCollsProfileAssgmtTP
// Collections Segment
composition [0..*] of R_BPCollsSegmentAssignmentTP as _BPCollsSegmentAssignmentTP
{
// VDM Fields
key I_BusinessPartner.BusinessPartner,
I_BusinessPartnerCustomer.Customer,
@Semantics: { systemDateTime : { lastChangedAt: true } }
I_BPCollectionProfileAssgmt.LastChangeDateTime,
// Exposed Associations
_BusinessPartner,
_Customer,
// BO Compositions
_BusPartCollsProfileAssgmtTP,
_BPCollsSegmentAssignmentTP
}
where
I_BusinessPartnerToBPRole._BusinessPartnerRole.RoleCategory = 'UDM000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCOLLECTIONPROFILEASSGMT",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERCUSTOMER",
"I_BUSINESSPARTNERROLE",
"I_BUSINESSPARTNERTOBPROLE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"R_BPCOLLSSEGMENTASSIGNMENTTP",
"R_BUSPARTCOLLSPROFILEASSGMTTP"
],
"BASE":
[],
"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