R_BPCollsSegmentAssignmentTP

DDL: R_BPCOLLSSEGMENTASSIGNMENTTP Type: view_entity TRANSACTIONAL
27 Fields 2 Data Sources 12 Associations

Business Partner: Collection Segments

R_BPCollsSegmentAssignmentTP is a Transactional CDS View that provides data about "Business Partner: Collection Segments" in SAP S/4HANA. It reads from 2 data sources (I_BPCollectionsSegmentAssgmt, I_BusinessPartnerCustomer) and exposes 27 fields with key fields BusinessPartner, CollectionSegment, BPCollSgmtAssignmentValidTo. It has 12 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BPCollectionsSegmentAssgmt I_BPCollectionsSegmentAssgmt from
I_BusinessPartnerCustomer I_BusinessPartnerCustomer inner

Associations (12)

CardinalityTargetAliasCondition
[0..1] R_CollsAcctCreditMgmtSummary _CollsAcctCreditMgmtSummary $projection.BusinessPartner = _CollsAcctCreditMgmtSummary.BusinessPartner and $projection.CollectionSegment = _CollsAcctCreditMgmtSummary.CollectionSegment
[0..1] I_CollectionsMainContact _CollectionsMainContact $projection.BusinessPartner = _CollectionsMainContact.BusinessPartner and $projection.CollectionSegment = _CollectionsMainContact.CollectionSegment
[0..*] I_CollectionsPaymentTrend _CollectionsPaymentTrend $projection.Customer = _CollectionsPaymentTrend.Customer and $projection.CollectionSegment = _CollectionsPaymentTrend.CollectionSegment
[0..*] I_CollectionsDueDateGrid _CollectionsDueDateGrid $projection.BusinessPartner = _CollectionsDueDateGrid.BusinessPartner and $projection.CollectionSegment = _CollectionsDueDateGrid.CollectionSegment
[0..1] I_CollsAccountStickyNote _CollsAccountStickyNote $projection.Customer = _CollsAccountStickyNote.Customer and $projection.CollectionSegment = _CollsAccountStickyNote.CollectionSegment
[0..*] I_CollectionsAccountNote _CollectionsAccountNote $projection.Customer = _CollectionsAccountNote.Customer and $projection.CollectionSegment = _CollectionsAccountNote.CollectionSegment
[0..1] R_BPCollectionsSgmtQuickView _CollectionsBPQuickView $projection.BusinessPartner = _CollectionsBPQuickView.BusinessPartner and $projection.CollectionSegment = _CollectionsBPQuickView.CollectionSegment
[0..1] R_RblsMgmtUserContactCard _CollectionsSpecialistCard $projection.CollectionSpecialist = _CollectionsSpecialistCard.ContactCardID
[0..*] R_CollsSpecialistSubstitute _CollsSpecialistSubstitute $projection.CollectionGroup = _CollsSpecialistSubstitute.CollectionGroup
[0..1] R_BPCollsSgmtCurrentSubstitute _CurrentSubstitute $projection.BusinessPartner = _CurrentSubstitute.BusinessPartner and $projection.CollectionSegment = _CurrentSubstitute.CollectionSegment and $projection.BPCollSgmtAssignmentValidTo = _CurrentSubstitute.BPCollSgmtAssignmentValidTo
[0..1] R_RblsMgmtUserContactCard _SubstituteCard $projection.CollectionSpecialistSubstitute = _SubstituteCard.ContactCardID
[0..*] R_BPCollsSegmentTmpAssgmtTP _BPCollsSegmentTmpAssgmtTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Business Partner: Collection Segments 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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPCollectionsSegmentAssgmt BusinessPartner Issuing Authority
KEY CollectionSegment I_BPCollectionsSegmentAssgmt CollectionSegment Segment
KEY BPCollSgmtAssignmentValidTo I_BPCollectionsSegmentAssgmt BPCollSgmtAssignmentValidTo Valid Until
BPCollSgmtAssignmentValidFrom I_BPCollectionsSegmentAssgmt BPCollSgmtAssignmentValidFrom Validity Start Time
CollectionGroup I_BPCollectionsSegmentAssgmt CollectionGroup Collection Group
CollectionSpecialist I_BPCollectionsSegmentAssgmt CollectionSpecialist Collection Specialist
CollectionBPMainContactPerson I_BPCollectionsSegmentAssgmt CollectionBPMainContactPerson Main Contact Person
Customer I_BusinessPartnerCustomer Customer Sold-to Party
CollectionSpecialistSubstitute _CurrentSubstitute CollectionSpecialistSubstitute
_BusinessPartner I_BPCollectionsSegmentAssgmt _BusinessPartner
_CollectionGroup I_BPCollectionsSegmentAssgmt _CollectionGroup
_CollectionSegment I_BPCollectionsSegmentAssgmt _CollectionSegment
_CollectionSpecialist I_BPCollectionsSegmentAssgmt _CollectionSpecialist
_MainContactPerson I_BPCollectionsSegmentAssgmt _MainContactPerson
_CollsAcctCreditMgmtSummary _CollsAcctCreditMgmtSummary
_CollectionsMainContact _CollectionsMainContact
_CollectionsPaymentTrend _CollectionsPaymentTrend
_CollectionsDueDateGrid _CollectionsDueDateGrid
_CollsAccountStickyNote _CollsAccountStickyNote
_CollectionsAccountNote _CollectionsAccountNote
_CollectionsBPQuickView _CollectionsBPQuickView
_CollectionsSpecialistCard _CollectionsSpecialistCard
_CollsSpecialistSubstitute _CollsSpecialistSubstitute
_CurrentSubstitute _CurrentSubstitute
_SubstituteCard _SubstituteCard
_CollsMgmtBusinessPartnerTP _CollsMgmtBusinessPartnerTP
_BPCollsSegmentTmpAssgmtTP _BPCollsSegmentTmpAssgmtTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_BPCollsSegmentAssignmentTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_BPCollsSegmentAssignmentTP AS
SELECT
  I_BPCollectionsSegmentAssgmt.BusinessPartner AS BusinessPartner,
  I_BPCollectionsSegmentAssgmt.CollectionSegment AS CollectionSegment,
  I_BPCollectionsSegmentAssgmt.BPCollSgmtAssignmentValidTo AS BPCollSgmtAssignmentValidTo,
  I_BPCollectionsSegmentAssgmt.BPCollSgmtAssignmentValidFrom AS BPCollSgmtAssignmentValidFrom,
  I_BPCollectionsSegmentAssgmt.CollectionGroup AS CollectionGroup,
  I_BPCollectionsSegmentAssgmt.CollectionSpecialist AS CollectionSpecialist,
  I_BPCollectionsSegmentAssgmt.CollectionBPMainContactPerson AS CollectionBPMainContactPerson,
  I_BusinessPartnerCustomer.Customer AS Customer,
  _CurrentSubstitute.CollectionSpecialistSubstitute AS CollectionSpecialistSubstitute,
  I_BPCollectionsSegmentAssgmt._BusinessPartner AS _BusinessPartner,
  I_BPCollectionsSegmentAssgmt._CollectionGroup AS _CollectionGroup,
  I_BPCollectionsSegmentAssgmt._CollectionSegment AS _CollectionSegment,
  I_BPCollectionsSegmentAssgmt._CollectionSpecialist AS _CollectionSpecialist,
  I_BPCollectionsSegmentAssgmt._MainContactPerson AS _MainContactPerson
FROM I_BPCollectionsSegmentAssgmt
INNER JOIN I_BusinessPartnerCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_CollsAcctCreditMgmtSummary AS _CollsAcctCreditMgmtSummary ON BusinessPartner = _CollsAcctCreditMgmtSummary.BusinessPartner AND CollectionSegment = _CollsAcctCreditMgmtSummary.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_CollectionsMainContact AS _CollectionsMainContact ON BusinessPartner = _CollectionsMainContact.BusinessPartner AND CollectionSegment = _CollectionsMainContact.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_CollectionsPaymentTrend AS _CollectionsPaymentTrend ON Customer = _CollectionsPaymentTrend.Customer AND CollectionSegment = _CollectionsPaymentTrend.CollectionSegment  -- association [0..*]
LEFT OUTER JOIN I_CollectionsDueDateGrid AS _CollectionsDueDateGrid ON BusinessPartner = _CollectionsDueDateGrid.BusinessPartner AND CollectionSegment = _CollectionsDueDateGrid.CollectionSegment  -- association [0..*]
LEFT OUTER JOIN I_CollsAccountStickyNote AS _CollsAccountStickyNote ON Customer = _CollsAccountStickyNote.Customer AND CollectionSegment = _CollsAccountStickyNote.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN I_CollectionsAccountNote AS _CollectionsAccountNote ON Customer = _CollectionsAccountNote.Customer AND CollectionSegment = _CollectionsAccountNote.CollectionSegment  -- association [0..*]
LEFT OUTER JOIN R_BPCollectionsSgmtQuickView AS _CollectionsBPQuickView ON BusinessPartner = _CollectionsBPQuickView.BusinessPartner AND CollectionSegment = _CollectionsBPQuickView.CollectionSegment  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CollectionsSpecialistCard ON CollectionSpecialist = _CollectionsSpecialistCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_CollsSpecialistSubstitute AS _CollsSpecialistSubstitute ON CollectionGroup = _CollsSpecialistSubstitute.CollectionGroup  -- association [0..*]
LEFT OUTER JOIN R_BPCollsSgmtCurrentSubstitute AS _CurrentSubstitute ON BusinessPartner = _CurrentSubstitute.BusinessPartner AND CollectionSegment = _CurrentSubstitute.CollectionSegment AND BPCollSgmtAssignmentValidTo = _CurrentSubstitute.BPCollSgmtAssignmentValidTo  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _SubstituteCard ON CollectionSpecialistSubstitute = _SubstituteCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_BPCollsSegmentTmpAssgmtTP AS _BPCollsSegmentTmpAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More