C_SlsDocFlfmtPurOrderContacts

DDL: C_SLSDOCFLFMTPURORDERCONTACTS SQL: CSOFPURORDERCON Type: view CONSUMPTION

Sales Doc Fulfillment: Purchase Order Contacts

C_SlsDocFlfmtPurOrderContacts is a Consumption CDS View that provides data about "Sales Doc Fulfillment: Purchase Order Contacts" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 5 fields with key fields PurchasingDocument, PurchasingGroup.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument I_PurchasingDocument from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Doc Fulfillment: Purchase Order Contacts view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSOFPURORDERCON view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument
KEY PurchasingGroup PurchasingGroup
EmailAddressasad_smtpadrasEmailAddress
PurchasingDocumentType PurchasingDocumentType
PurchasingOrganization PurchasingOrganization 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S

@EndUserText.label: 'Sales Doc Fulfillment: Purchase Order Contacts'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CSOFPURORDERCON'

define view C_SlsDocFlfmtPurOrderContacts

  as select from I_PurchasingDocument // Purchasing Group


{
  key PurchasingDocument,

  key PurchasingGroup,

      cast( _PurchasingGroup.PurchasingGroupName
      as ad_namtext )                                    as FullName,

      cast ( _PurchasingGroup.PurchasingGroupPhoneNumber
      as ad_tlnmbr )                                     as PhoneNumber,
      
      cast ( _PurchasingGroup.PhoneNumberExtension 
      as ad_tlxtns )                                     as PhoneNumberExtension,   

      cast( _PurchasingGroup.EmailAddress
      as ad_smtpadr )                                    as EmailAddress,

      PurchasingDocumentType,

      PurchasingOrganization
}

where
      _PurchasingGroup.PurchasingGroup <> '   '
  and IsEndOfPurposeBlocked            =  ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGGROUP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More