I_EngmntProjCustomer

DDL: I_ENGMNTPROJCUSTOMER Type: view BASIC
66 Fields 1 Data Sources

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 Sold-to Party
CustomerName CustomerName Name of Customer
CustomerFullName CustomerFullName Customer Name
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
AddressID AddressID Ship-to address
CustomerClassification CustomerClassification Customer Class.
VATRegistration VATRegistration VAT Registration No.
CustomerAccountGroup CustomerAccountGroup Account group
AuthorizationGroup AuthorizationGroup AuthorizGroup
DeliveryIsBlocked DeliveryIsBlocked Delivery block
PostingIsBlocked PostingIsBlocked Posting Block
BillingIsBlockedForCustomer BillingIsBlockedForCustomer Billing block
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
InternationalLocationNumber1 InternationalLocationNumber1 Location no. 1
IsOneTimeAccount IsOneTimeAccount One-time acct
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Industry Industry Industry Sector
TaxNumberType TaxNumberType Tax number type
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
TaxNumber5 TaxNumber5
CustomerCorporateGroup CustomerCorporateGroup Group
Supplier Supplier Supplier
NielsenRegion NielsenRegion Nielsen ID
IndustryCode1 IndustryCode1 Industry code 1
IndustryCode2 IndustryCode2 Industry code 2
IndustryCode3 IndustryCode3 Industry code 3
IndustryCode4 IndustryCode4 Industry code 4
IndustryCode5 IndustryCode5 Industry code 5
Country Country Venue: Ctry/Reg
OrganizationBPName1 OrganizationBPName1 Name 1
OrganizationBPName2 OrganizationBPName2 Name 2
CityName CityName Name
PostalCode PostalCode Postal Code
StreetName StreetName Text
AlternativePayerAccount AlternativePayerAccount Alternat.payer
DataMediumExchangeIndicator DataMediumExchangeIndicator DME Rec. Code
VATLiability VATLiability Liable for VAT
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
ResponsibleType ResponsibleType Tax Type
FiscalAddress FiscalAddress Fiscal address
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson
DeletionIndicator DeletionIndicator Deletion Ind.
Language Language Report Text Language
_CorrespondingSupplier _CorrespondingSupplier
_CreatedByUser _CreatedByUser
_CustomerAccountGroupText _CustomerAccountGroupText
_CustomerClassification _CustomerClassification
_CustomerCompany _CustomerCompany
_CustomerSalesArea _CustomerSalesArea
_CustomerToBusinessPartner _CustomerToBusinessPartner
_StandardAddress _StandardAddress
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EngmntProjCustomer.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EngmntProjCustomer AS
SELECT
  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,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_Customer
;

Learn More