I_EngmntProjCustomer

DDL: I_ENGMNTPROJCUSTOMER Type: view BASIC

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 66 fields with key field Customer.

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 (66)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
CustomerName CustomerName
CustomerFullName CustomerFullName
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
_CorrespondingSupplier _CorrespondingSupplier
_CreatedByUser _CreatedByUser
_CustomerAccountGroupText _CustomerAccountGroupText
_CustomerClassification _CustomerClassification
_CustomerCompany _CustomerCompany
_CustomerSalesArea _CustomerSalesArea
_CustomerToBusinessPartner _CustomerToBusinessPartner
_StandardAddress _StandardAddress
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
@AbapCatalog: {
  sqlViewName: 'IENGPROJCUST',
//  preserveKey: true,

  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: {
//  private: false,

  lifecycle.contract.type: #NONE,
  viewType: #BASIC
}
define view I_EngmntProjCustomer
  as select from I_Customer
{

      //I_Customer

  key Customer,
      CustomerName,
      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,
      /* Associations */
      //I_Customer

      _CorrespondingSupplier,
      _CreatedByUser,
      _CustomerAccountGroupText,
      _CustomerClassification,
      _CustomerCompany,
      _CustomerSalesArea,
      _CustomerToBusinessPartner,
      _StandardAddress,

      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController1,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController2,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController3,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController4,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController6,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController7,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController8,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController9,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController10


}
//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.

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_CUSTOMERACCOUNTGROUPTEXT",
"I_CUSTOMERCLASSIFICATION",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERSALESAREA",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_SUPPLIER",
"I_USER"
],
"BASE":
[
"I_CUSTOMER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/