P_SlsDocFlfmtSDDocContacts1

DDL: P_SLSDOCFLFMTSDDOCCONTACTS1 SQL: PSOFSDDOCCONT1 Type: view CONSUMPTION Package: ODATA_SD_SOF

P_SlsDocFlfmtSDDocContacts1

P_SlsDocFlfmtSDDocContacts1 is a Consumption CDS View that provides data about "P_SlsDocFlfmtSDDocContacts1" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartnerContact, I_SDDocumentCompletePartners) and exposes 13 fields with key fields SDDocument, Personnel, ContactPerson, Customer, CustomerContact. Part of development package ODATA_SD_SOF.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartnerContact Contacts inner
I_SDDocumentCompletePartners Partners from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSOFSDDOCCONT1 view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SDDocument I_SDDocumentCompletePartners SDDocument
KEY Personnel I_SDDocumentCompletePartners Personnel
KEY ContactPerson I_SDDocumentCompletePartners ContactPerson
KEY Customer I_SDDocumentCompletePartners Customer
KEY CustomerContact I_BusinessPartnerContact BusinessPartnerPerson
ContactPersonFunction I_BusinessPartnerContact ContactPersonFunction
FullName
FamilyName
FirstName
EmailAddress
MobilePhoneNumber
PhoneNumber
_ContactPersonFunction _ContactPersonFunction 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PSOFSDDOCCONT1'
define view P_SlsDocFlfmtSDDocContacts1

  as select from I_SDDocumentCompletePartners as Partners
    inner join   I_BusinessPartnerContact     as Contacts on Partners.Customer = Contacts.BusinessPartnerCompany
{
  key Partners.SDDocument,
  key Partners.Personnel,
  key Partners.ContactPerson,
  key Partners.Customer,
  key Contacts.BusinessPartnerPerson as CustomerContact,

      Contacts.ContactPersonFunction,

      @Semantics.name.fullName: true
      cast (' '   as ad_namtext )                                    as   FullName,

      @Semantics.name.familyName: true
      cast ( Contacts.LastName as ad_namelas )                       as   FamilyName,

      @Semantics.name.familyName: true
      cast ( Contacts.FirstName  as ad_namefir )                     as   FirstName,

      @Semantics.eMail.address: true
      @Semantics.eMail.type:  #WORK
      cast ( Contacts.EmailAddress as ad_smtpadr )                   as   EmailAddress,

      @Semantics.telephone.type: #CELL
      cast (Contacts.MobilePhoneNumber as ad_mbnmbr1 )               as   MobilePhoneNumber,

      @Semantics.telephone.type: #WORK
      cast ( Contacts.PhoneNumber as ad_tlnmbr )                     as   PhoneNumber,

      _ContactPersonFunction
}

where
  (
       PartnerFunction = 'AG'
    or PartnerFunction = 'WE'
    or PartnerFunction = 'RE'
    or PartnerFunction = 'RG'
  )
  and  SDDocumentItem  = '000000'
  and  IsDefaultAddress = 'X'

group by

  Partners.SDDocument,
  //  Partners.PartnerFunction,

  Partners.Personnel,
  Partners.ContactPerson,
  Partners.Customer,
  Contacts.BusinessPartnerPerson,
  Contacts.ContactPersonFunction,
  Contacts.LastName,
  Contacts.FirstName,
  Contacts.EmailAddress,
  Contacts.MobilePhoneNumber,
  Contacts.PhoneNumber

Learn More