I_EngmntProjCustomer

DDL: I_ENGMNTPROJCUSTOMER Type: view BASIC Package: CPD_CDS

Engagement Project Customer

I_EngmntProjCustomer is a Basic CDS View (Dimension) that provides data about "Engagement Project Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 48 fields with key field Customer. Part of development package CPD_CDS.

1 data source(s) 48 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IENGPROJCUST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Engagement Project Customer view
ObjectModel.representativeKey Customer view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #BASIC view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
CustomerName BPCustomerName
CustomerFullName BPCustomerFullName
CreatedByUser CreatedByUser
CreationDate CreationDate
AddressID AddressID
CustomerClassification CustomerClassification
VATRegistration VATRegistration
CustomerAccountGroup CustomerAccountGroup
AuthorizationGroup AuthorizationGroup
DeliveryIsBlocked DeliveryIsBlocked
PostingIsBlocked PostingIsBlocked
BillingIsBlockedForCustomer BillingIsBlockedForCustomer
OrderIsBlockedForCustomer OrderIsBlockedForCustomer
InternationalLocationNumber1 InternationalLocationNumber1
IsOneTimeAccount IsOneTimeAccount
TaxJurisdiction TaxJurisdiction
Industry Industry
TaxNumberType TaxNumberType
TaxNumber1 TaxNumber1
TaxNumber2 TaxNumber2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
TaxNumber5 TaxNumber5
CustomerCorporateGroup CustomerCorporateGroup
Supplier Supplier
NielsenRegion NielsenRegion
IndustryCode1 IndustryCode1
IndustryCode2 IndustryCode2
IndustryCode3 IndustryCode3
IndustryCode4 IndustryCode4
IndustryCode5 IndustryCode5
Country Country
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
CityName CityName
PostalCode PostalCode
StreetName StreetName
AlternativePayerAccount AlternativePayerAccount
DataMediumExchangeIndicator DataMediumExchangeIndicator
VATLiability VATLiability
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
ResponsibleType ResponsibleType
FiscalAddress FiscalAddress
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson
DeletionIndicator DeletionIndicator
Language Language
_StandardAddress _StandardAddress 
@AbapCatalog: {
  sqlViewName: 'IENGPROJCUST',
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData: {
    blockingIndicator: [ 'IsBusinessPurposeCompleted' ],
    blocking: #REQUIRED
  },
  privilegedAssociations: [ '_StandardAddress' ]
}
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: false
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Engagement Project Customer'
@ObjectModel: {
  representativeKey: 'Customer',
  usageType: {
    serviceQuality: #B,
    sizeCategory: #XL,
    dataClass: #MASTER
  }
}
@Metadata: {
  allowExtensions: true,
  ignorePropagatedAnnotations: false
}
@VDM: {
  lifecycle.contract.type: #NONE,
  viewType: #BASIC
}
define view I_EngmntProjCustomer
  as select from I_Customer
{

      //I_Customer

  @ObjectModel.text.element: ['CustomerName']
  key Customer,
  @Semantics.text:true
      BPCustomerName as CustomerName,
      BPCustomerFullName as CustomerFullName,
      CreatedByUser,
      CreationDate,
      AddressID,
      CustomerClassification,
      VATRegistration,
      CustomerAccountGroup,
      AuthorizationGroup,
      DeliveryIsBlocked,
      PostingIsBlocked, 
      BillingIsBlockedForCustomer,
      OrderIsBlockedForCustomer,
      InternationalLocationNumber1,
      IsOneTimeAccount,
      TaxJurisdiction,
      Industry,
      TaxNumberType,
      TaxNumber1,
      TaxNumber2,
      TaxNumber3,
      TaxNumber4,
      TaxNumber5,
      CustomerCorporateGroup,
      Supplier,
      NielsenRegion,
      IndustryCode1,
      IndustryCode2,
      IndustryCode3,
      IndustryCode4,
      IndustryCode5,
      Country,
      OrganizationBPName1,
      OrganizationBPName2,
      CityName,
      PostalCode,
      StreetName,
      AlternativePayerAccount,
      DataMediumExchangeIndicator,
      VATLiability,
      IsBusinessPurposeCompleted,
      ResponsibleType,
      FiscalAddress,
      NFPartnerIsNaturalPerson,
      DeletionIndicator,
      Language,
      _StandardAddress
}
//where IsBusinessPurposeCompleted <> 'X' // Do not add where condition because this view is used in fact sheet and data privacy specialist must see the blocked data.

// Access of blocked data is handled by DCL, so only the special authorizatons can see blocked data.

Learn More