I_CollsInvoiceRelatedPrms2P

DDL: I_COLLSINVOICERELATEDPRMS2P Type: view COMPOSITE Package: UDM_COLL_CDS

Promise To Pay Related to Invoice

I_CollsInvoiceRelatedPrms2P is a Composite CDS View that provides data about "Promise To Pay Related to Invoice" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoiceRelatedObject) and exposes 21 fields with key fields LogicalSystem, ObjectType, ObjectKey, RelationToLinkedObject, CaseUniqueID. It has 3 associations to related views. Part of development package UDM_COLL_CDS.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoiceRelatedObject I_CollsInvoiceRelatedObject from

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICOLLSINVRELP2P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Promise To Pay Related to Invoice view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CaseUniqueID view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem
KEY ObjectType ObjectType
KEY ObjectKey ObjectKey
KEY RelationToLinkedObject RelationToLinkedObject
KEY CaseUniqueID CaseUniqueID
ObjectClassification ObjectClassification
ObjectIsConfirmed ObjectIsConfirmed
ObjectIsVoided ObjectIsVoided
CompanyCode CompanyCode
AccountingDocument AccountingDocument
FiscalYear FiscalYear
AccountingDocumentItem AccountingDocumentItem
CaseID CaseID
CaseCreatedBy _CollsPromiseToPay CaseCreatedBy
CaseLastChangedBy _CollsPromiseToPay CaseLastChangedBy
CaseClosedBy _CollsPromiseToPay CaseClosedBy
_CaseAttribute _CaseAttribute
_CollsPromiseToPay _CollsPromiseToPay
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard 
@AbapCatalog: { sqlViewName: 'ICOLLSINVRELP2P',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText.label: 'Promise To Pay Related to Invoice'
@VDM: { viewType: #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #X,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL },
                semanticKey: [ 'CaseUniqueID', 'CaseID' ],
                representativeKey: 'CaseUniqueID' }

define root view I_CollsInvoiceRelatedPrms2P
  as select from I_CollsInvoiceRelatedObject

  // VDM Associations

  // Created By Contact Card

  association [0..1] to R_RblsMgmtUserContactCard as _CreatedByContactCard on $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID

  // Changed By Contact Card

  association [0..1] to R_RblsMgmtUserContactCard as _ChangedByContactCard on $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID

  // Closed By Contact Card

  association [0..1] to R_RblsMgmtUserContactCard as _ClosedByContactCard  on $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID

{

      // VDM Fields

  key LogicalSystem,
  key ObjectType,
  key ObjectKey,
  key RelationToLinkedObject,
  key CaseUniqueID,
      ObjectClassification,
      ObjectIsConfirmed,
      ObjectIsVoided,
      CompanyCode,
      AccountingDocument,
      FiscalYear,
      AccountingDocumentItem,
      CaseID,

      @ObjectModel: { foreignKey: { association: '_CreatedByContactCard' } }
      _CollsPromiseToPay.CaseCreatedBy     as CaseCreatedBy,

      @ObjectModel: { foreignKey: { association: '_ChangedByContactCard' } }
      _CollsPromiseToPay.CaseLastChangedBy as CaseLastChangedBy,

      @ObjectModel: { foreignKey: { association: '_ClosedByContactCard' } }
      _CollsPromiseToPay.CaseClosedBy      as CaseClosedBy,

      // Exposed Associations

      _CaseAttribute,
      _CollsPromiseToPay,
      _CreatedByContactCard,
      _ChangedByContactCard,
      _ClosedByContactCard

}

where
      RelationToLinkedObject =  'P1'
  and ObjectType             =  'BSEG'
  and ObjectIsVoided         <> 'X'

Learn More