R_PPS_PurchaseOrderContactTP

DDL: R_PPS_PURCHASEORDERCONTACTTP Type: view_entity TRANSACTIONAL

PPS Purchase Order Contact

R_PPS_PurchaseOrderContactTP is a Transactional CDS View that provides data about "PPS Purchase Order Contact" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurgDocContactBasic) and exposes 17 fields with key fields PurchaseOrder, PPSContactPersonUUID. It has 5 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurgDocContactBasic I_PPS_PurgDocContactBasic from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.PPSContactPerson = _BusinessPartner.BusinessPartner
[0..1] I_BPEmailAddress _BPMailAddress $projection.PPSContactPerson = _BPMailAddress.BusinessPartner and _BPMailAddress.IsDefaultEmailAddress = 'X'
[0..1] I_BPTelephoneNumber _BPTelephoneNumber $projection.PPSContactPerson = _BPTelephoneNumber.BusinessPartner and _BPTelephoneNumber.IsDefaultPhoneNumber = 'X'
[1..1] I_PPS_ContactCategoryBasic _ContactFunc $projection.PPSContactCategory = _ContactFunc.PPSContactCategory
[1..1] I_PPS_PurgDocCntctCategory _ContactConfig $projection.PPSContactCategory = _ContactConfig.PPSContactCategory and $projection.PurchasingDocumentType = _ContactConfig.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _ContactConfig.PurchasingDocumentCategory

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PPS Purchase Order Contact view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PPSContactPersonUUID PPSContactPersonUUID
PurchasingDocumentCategory PurchasingDocumentCategory
PPSSqncNmbrOfContactPerson PPSSqncNmbrOfContactPerson
PPSContactCategory PPSContactCategory
PPSContactPerson PPSContactPerson
BusinessPartnerName _BusinessPartner BusinessPartnerName
PurchasingDocumentType PurchasingDocumentType
PPSFieldChangeIndicatorBinary
PPSContactFunction _ContactFunc PPSContactFunction
PPSContactCategoryIsMandatory _ContactConfig PPSContactCategoryIsMandatory
_PurchaseOrder _PurchaseOrder
_ContactFunc _ContactFunc
_BusinessPartner _BusinessPartner
_ContactConfig _ContactConfig
_BPMailAddress _BPMailAddress
_BPTelephoneNumber _BPTelephoneNumber 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'PPS Purchase Order Contact'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

//@JIRA-KEY<S4PPS-5595,S4PPS-5904>


define view entity R_PPS_PurchaseOrderContactTP
  as select from I_PPS_PurgDocContactBasic

  association        to parent R_PPS_PurchaseOrderTP as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

  association [0..1] to I_BusinessPartner            as _BusinessPartner   on  $projection.PPSContactPerson = _BusinessPartner.BusinessPartner

  association [0..1] to I_BPEmailAddress             as _BPMailAddress     on  $projection.PPSContactPerson         = _BPMailAddress.BusinessPartner
                                                                           and _BPMailAddress.IsDefaultEmailAddress = 'X'

  association [0..1] to I_BPTelephoneNumber          as _BPTelephoneNumber on  $projection.PPSContactPerson            = _BPTelephoneNumber.BusinessPartner
                                                                           and _BPTelephoneNumber.IsDefaultPhoneNumber = 'X'

  association [1..1] to I_PPS_ContactCategoryBasic   as _ContactFunc       on  $projection.PPSContactCategory = _ContactFunc.PPSContactCategory

  //  association [0..1] to I_PPS_ContactCategoryText    as _ContactText       on  $projection.PPSContactCategory = _ContactText.PPSContactCategory

  //                                                                           and _ContactText.Language          = $session.system_language

  association [1..1] to I_PPS_PurgDocCntctCategory   as _ContactConfig     on  $projection.PPSContactCategory         = _ContactConfig.PPSContactCategory
                                                                           and $projection.PurchasingDocumentType     = _ContactConfig.PurchasingDocumentType
                                                                           and $projection.PurchasingDocumentCategory = _ContactConfig.PurchasingDocumentCategory
{
  key PurchasingDocument                                                                                      as PurchaseOrder,
  key PPSContactPersonUUID,
      PurchasingDocumentCategory,
      PPSSqncNmbrOfContactPerson,
      PPSContactCategory,
      PPSContactPerson,
      _BusinessPartner.BusinessPartnerName,
      PurchasingDocumentType, // @JIRA-KEY S4PPS-13030

      //      _BPMailAddress.EmailAddress,

      //      _BPTelephoneNumber.PhoneNumber,


      //@JIRA-KEY<S4PPS-12976>

      //      cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,

      cast ( hextobin( _PurchaseOrder.PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,
      //      //      _ContactText.PPSContactCategoryText,

      //      _ContactFunc._Text.PPSContactCategoryText,

      _ContactFunc.PPSContactFunction,
      //      _ContactFunc.PPSContactFunctionText,

      @Semantics.booleanIndicator: true
      _ContactConfig.PPSContactCategoryIsMandatory, // @JIRA-KEY S4PPS-13030

      //Association

      _PurchaseOrder,
      //      _ContactText,

      _ContactFunc,
      _BusinessPartner,
      _ContactConfig,
      _BPMailAddress,
      _BPTelephoneNumber
}
where
  PurchasingDocumentCategory = 'F'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_PPS_CONTACTCATEGORYBASIC",
"I_PPS_PURGDOCCNTCTCATEGORY",
"I_PPS_PURGDOCCONTACTBASIC",
"R_PPS_PURCHASEORDERTP"
],
"ASSOCIATED":
[
"I_BPEMAILADDRESS",
"I_BPTELEPHONENUMBER",
"I_BUSINESSPARTNER",
"I_PPS_CONTACTCATEGORYBASIC",
"I_PPS_PURGDOCCNTCTCATEGORY",
"R_PPS_PURCHASEORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More