FAC_DART_Z3_Customer

DDL: FAC_DART_Z3_CUSTOMER SQL: FAC_DZCUSTOMER Type: view
42 Fields 3 Data Sources

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.

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 Receiver Company Code
KEY Customer I_CustomerCompany Customer Sold-to Party
OrganizationBPName1 I_Customer OrganizationBPName1 Name 1
OrganizationBPName2 I_Customer OrganizationBPName2 Name 2
TaxNumber1 I_Customer TaxNumber1 VAT Reg. No.
TaxNumber2 I_Customer TaxNumber2 Tax Number 2
VATRegistration I_Customer VATRegistration VAT Registration No.
TradingPartner I_Customer TradingPartner Trading Partner
StreetName
CityName
District
Region
Country
PostalCode
POBox
POBoxPostalCode
AlternativePayerAccount I_CustomerCompany AlternativePayerAccount Alternat.payer
ReconciliationAccount I_CustomerCompany ReconciliationAccount Recon. account
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed Clrg with vend.
Supplier I_Customer Supplier Supplier
IsOneTimeAccount I_Customer IsOneTimeAccount One-time acct
CustomerHeadOffice I_CustomerCompany CustomerHeadOffice Head Office
AddressID I_Customer AddressID Ship-to address
Industry I_Customer Industry Industry Sector
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
AccountGroupName
PaymentTerms I_CustomerCompany PaymentTerms Pyt Terms
CreationDate I_Customer CreationDate Time Stamp
CreatedByUser I_Customer CreatedByUser User Name
PaymentMethodsList I_CustomerCompany PaymentMethodsList Payment Methods
HouseNumber
HouseNumberSupplementText
BusinessPartnerName3
BusinessPartnerName4
AlternativePayeeIsAllowed I_Customer AlternativePayeeIsAllowed Payee in doc.
DeletionIndicator I_CustomerCompany DeletionIndicator Deletion Ind.
PaymentMethodSupplement I_CustomerCompany PaymentMethodSupplement Pmnt Meth. Sup.
DeletionIsBlocked I_CustomerCompany DeletionIsBlocked CoCd del.block
_Customer _Customer
AuthorizationGroup I_CustomerCompany AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_CustomerCompany IsBusinessPurposeCompleted Purpose Completed
SystemClient System Client

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 FAC_DART_Z3_Customer.
-- 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.
-- SQL view name: FAC_DZCUSTOMER
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_DART_Z3_Customer AS
SELECT
  I_CustomerCompany.CompanyCode AS CompanyCode,
  I_CustomerCompany.Customer AS Customer,
  Customer.OrganizationBPName1 AS OrganizationBPName1,
  Customer.OrganizationBPName2 AS OrganizationBPName2,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.TaxNumber2 AS TaxNumber2,
  Customer.VATRegistration AS VATRegistration,
  Customer.TradingPartner AS TradingPartner,
  Customer._StandardAddress.StreetName AS StreetName,
  Customer._StandardAddress.CityName AS CityName,
  Customer._StandardAddress.District AS District,
  Customer._StandardAddress.Region AS Region,
  Customer._StandardAddress.Country AS Country,
  Customer._StandardAddress.PostalCode AS PostalCode,
  Customer._StandardAddress.POBox AS POBox,
  Customer._StandardAddress.POBoxPostalCode AS POBoxPostalCode,
  I_CustomerCompany.AlternativePayerAccount AS AlternativePayerAccount,
  I_CustomerCompany.ReconciliationAccount AS ReconciliationAccount,
  CustomerSupplierClearingIsUsed,
  Customer.Supplier AS Supplier,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  I_CustomerCompany.CustomerHeadOffice AS CustomerHeadOffice,
  Customer.AddressID AS AddressID,
  Customer.Industry AS Industry,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  CustomerAccountGroup._CustomerAccountGroupText[1: Language = $parameters.P_Language].AccountGroupName AS AccountGroupName,
  I_CustomerCompany.PaymentTerms AS PaymentTerms,
  Customer.CreationDate AS CreationDate,
  Customer.CreatedByUser AS CreatedByUser,
  I_CustomerCompany.PaymentMethodsList AS PaymentMethodsList,
  Customer._StandardAddress.HouseNumber AS HouseNumber,
  Customer._StandardAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  Customer._StandardAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  Customer._StandardAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  Customer.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  I_CustomerCompany.DeletionIndicator AS DeletionIndicator,
  I_CustomerCompany.PaymentMethodSupplement AS PaymentMethodSupplement,
  I_CustomerCompany.DeletionIsBlocked AS DeletionIsBlocked,
  I_CustomerCompany.AuthorizationGroup AS AuthorizationGroup,
  I_CustomerCompany.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  $session.client AS SystemClient
FROM I_CustomerCompany
LEFT OUTER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerAccountGroup AS CustomerAccountGroup ON /* join condition not captured in parsed metadata */
;

Learn More