FAC_DART_Z3_Customer

DDL: FAC_DART_Z3_CUSTOMER SQL: FAC_DZCUSTOMER Type: view

Customer Master Data

FAC_DART_Z3_Customer is a CDS View that provides data about "Customer Master Data" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_CustomerAccountGroup, I_CustomerCompany) and exposes 42 fields with key fields CompanyCode, Customer.

3 data source(s) 42 fields

Data Sources (3)

SourceAliasJoin Type
I_Customer Customer left_outer
I_CustomerAccountGroup CustomerAccountGroup left_outer
I_CustomerCompany I_CustomerCompany from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZCUSTOMER view
EndUserText.label Customer Master Data view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CustomerCompany CompanyCode
KEY Customer I_CustomerCompany Customer
OrganizationBPName1 I_Customer OrganizationBPName1
OrganizationBPName2 I_Customer OrganizationBPName2
TaxNumber1 I_Customer TaxNumber1
TaxNumber2 I_Customer TaxNumber2
VATRegistration I_Customer VATRegistration
TradingPartner I_Customer TradingPartner
StreetName
CityName
District
Region
Country
PostalCode
POBox
POBoxPostalCode
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount
ReconciliationAccount I_CustomerCompany ReconciliationAccount
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed
Supplier I_Customer Supplier
IsOneTimeAccount I_Customer IsOneTimeAccount
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice
AddressID I_Customer AddressID
Industry I_Customer Industry
CustomerAccountGroup I_Customer CustomerAccountGroup
AccountGroupName
PaymentTerms I_CustomerCompany PaymentTerms
CreationDate I_Customer CreationDate
CreatedByUser I_Customer CreatedByUser
PaymentMethodsList I_CustomerCompany PaymentMethodsList
HouseNumber
HouseNumberSupplementText
BusinessPartnerName3
BusinessPartnerName4
AlternativePayeeIsAllowed I_Customer AlternativePayeeIsAllowed
DeletionIndicator I_CustomerCompany DeletionIndicator
PaymentMethodSupplement I_CustomerCompany PaymentMethodSupplement
DeletionIsBlocked I_CustomerCompany DeletionIsBlocked
_Customer _Customer
AuthorizationGroup I_CustomerCompany AuthorizationGroup
IsBusinessPurposeCompleted I_CustomerCompany IsBusinessPurposeCompleted
SystemClient System Client 
@AbapCatalog.sqlViewName: 'FAC_DZCUSTOMER'
@EndUserText.label: 'Customer Master Data'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_DART_Z3_Customer
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from    I_CustomerCompany
    left outer join I_Customer             as Customer             on I_CustomerCompany.Customer = Customer.Customer
    left outer join I_CustomerAccountGroup as CustomerAccountGroup on Customer.CustomerAccountGroup = CustomerAccountGroup.CustomerAccountGroup

{
  key I_CustomerCompany.CompanyCode,
  key I_CustomerCompany.Customer,

      Customer.OrganizationBPName1,
      Customer.OrganizationBPName2,
      Customer.TaxNumber1,
      Customer.TaxNumber2,
      Customer.VATRegistration,
      Customer.TradingPartner,

      Customer._StandardAddress.StreetName,
      Customer._StandardAddress.CityName,
      Customer._StandardAddress.District,
      Customer._StandardAddress.Region,
      Customer._StandardAddress.Country,
      Customer._StandardAddress.PostalCode,
      Customer._StandardAddress.POBox,
      Customer._StandardAddress.POBoxPostalCode,

      I_CustomerCompany.AlternativePayerAccount,
      I_CustomerCompany.ReconciliationAccount,
      CustomerSupplierClearingIsUsed,
      Customer.Supplier,
      Customer.IsOneTimeAccount,
      I_CustomerCompany.CustomerHeadOffice,
      Customer.AddressID,
      Customer.Industry,
      Customer.CustomerAccountGroup,
      CustomerAccountGroup._CustomerAccountGroupText[1: Language = $parameters.P_Language].AccountGroupName,
      I_CustomerCompany.PaymentTerms,
      Customer.CreationDate,

      Customer.CreatedByUser,
      I_CustomerCompany.PaymentMethodsList,
      Customer._StandardAddress.HouseNumber,
      Customer._StandardAddress.HouseNumberSupplementText,
      Customer._StandardAddress.BusinessPartnerName3,
      Customer._StandardAddress.BusinessPartnerName4,
      Customer.AlternativePayeeIsAllowed,
      I_CustomerCompany.DeletionIndicator,
      I_CustomerCompany.PaymentMethodSupplement,
      I_CustomerCompany.DeletionIsBlocked,

      /*Add for auth check */
      _Customer,
      I_CustomerCompany.AuthorizationGroup,
      I_CustomerCompany.IsBusinessPurposeCompleted,

      @EndUserText.label: 'System Client'
      $session.client as SystemClient

}

Learn More