ESH_N_CUSTOMERS_T

DDL: ESH_N_CUSTOMERS_T SQL: ESH_L_CUSTOMERST Type: view
55 Fields 1 Data Sources

ESH_N_CUSTOMERS_T is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CUSTOMER) and exposes 55 fields with key field CUSTOMER.

Data Sources (1)

SourceAliasJoin Type
I_CUSTOMER I_CUSTOMER from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_CUSTOMERST view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY CUSTOMER CUSTOMER Sold-to Party
ADDRESSID ADDRESSID Ship-to address
AUTHORIZATIONGROUP AUTHORIZATIONGROUP AuthorizGroup
BILLINGISBLOCKEDFORCUSTOMER
BPADDRCITYNAME BPADDRCITYNAME Name
BPADDRSTREETNAME BPADDRSTREETNAME Text
BUSINESSPARTNER
BUSINESSPARTNERNAME1 BUSINESSPARTNERNAME1 Name
BUSINESSPARTNERNAME2 BUSINESSPARTNERNAME2 Name 2
CITYNAME CITYNAME Name
COMPANYCODE _CUSTOMERCOMPANY COMPANYCODE Receiver Company Code
CONTACTPERSONDEPARTMENT _CONTACTPERSON CONTACTPERSONDEPARTMENT Department
CONTACTPERSONFUNCTION _CONTACTPERSON CONTACTPERSONFUNCTION Function
COUNTRY
COUNTRYNAME
CREATEDBYUSER
CUSTOMERACCOUNTGROUP CUSTOMERACCOUNTGROUP Account group
DATACONTROLLER1 DATACONTROLLER1 Data Controller
DATACONTROLLER10 DATACONTROLLER10 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
DATACONTROLLERSET DATACONTROLLERSET Data Ctrlr. Set
DELETIONINDICATOR DELETIONINDICATOR Deletion Ind.
DELIVERYISBLOCKED
DISTRIBUTIONCHANNEL
DISTRIBUTIONCHANNELNAME
DIVISION
DIVISIONNAME
EMAILADDRESS
FAXNUMBER
FIRSTNAME
CONTACTPERSONFIRSTNAME _CONTACTPERSON FIRSTNAME First Name
HOUSENUMBER _STANDARDADDRESS HOUSENUMBER House Number
INDUSTRY
INTERNATIONALLOCATIONNUMBER1
LANGUAGE
LASTNAME
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Name 1
ORGANIZATIONBPNAME2 ORGANIZATIONBPNAME2 Name 2
POSTALCODE POSTALCODE Postal Code
POSTINGISBLOCKED
REGION
REGIONNAME
SALESORGANIZATION
SALESORGANIZATIONNAME
SEARCHTERM1
STREETNAME STREETNAME Text
TAXNUMBER1
VATREGISTRATION VATREGISTRATION VAT Registration No.

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 ESH_N_CUSTOMERS_T.
-- 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: ESH_L_CUSTOMERST
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_CUSTOMERS_T AS
SELECT
  CUSTOMER,
  ADDRESSID,
  AUTHORIZATIONGROUP,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].BILLINGISBLOCKEDFORCUSTOMER AS BILLINGISBLOCKEDFORCUSTOMER,
  BPADDRCITYNAME,
  BPADDRSTREETNAME,
  _CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER[1: CORRESPONDENCELANGUAGE = $parameters. P_Language].BUSINESSPARTNER AS BUSINESSPARTNER,
  BUSINESSPARTNERNAME1,
  BUSINESSPARTNERNAME2,
  CITYNAME,
  _CUSTOMERCOMPANY.COMPANYCODE AS COMPANYCODE,
  _CONTACTPERSON.CONTACTPERSONDEPARTMENT AS CONTACTPERSONDEPARTMENT,
  _CONTACTPERSON.CONTACTPERSONFUNCTION AS CONTACTPERSONFUNCTION,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].COUNTRY AS COUNTRY,
  _STANDARDADDRESS._COUNTRY._TEXT[1: LANGUAGE = $parameters. P_Language].COUNTRYNAME AS COUNTRYNAME,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].CREATEDBYUSER AS CREATEDBYUSER,
  CUSTOMERACCOUNTGROUP,
  DATACONTROLLER1,
  DATACONTROLLER10,
  DATACONTROLLER2,
  DATACONTROLLER3,
  DATACONTROLLER4,
  DATACONTROLLER5,
  DATACONTROLLER6,
  DATACONTROLLER7,
  DATACONTROLLER8,
  DATACONTROLLER9,
  DATACONTROLLERSET,
  DELETIONINDICATOR,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].DELIVERYISBLOCKED AS DELIVERYISBLOCKED,
  _CUSTOMERSALESAREA._DISTRIBUTIONCHANNEL.DISTRIBUTIONCHANNEL AS DISTRIBUTIONCHANNEL,
  _CUSTOMERSALESAREA._DISTRIBUTIONCHANNEL._TEXT[1: LANGUAGE = $parameters. P_Language].DISTRIBUTIONCHANNELNAME AS DISTRIBUTIONCHANNELNAME,
  _CUSTOMERSALESAREA._DIVISION.DIVISION AS DIVISION,
  _CUSTOMERSALESAREA._DIVISION._TEXT[1: LANGUAGE = $parameters. P_Language].DIVISIONNAME AS DIVISIONNAME,
  _STANDARDADDRESS._DEFAULTEMAILADDRESS.EMAILADDRESS AS EMAILADDRESS,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].FAXNUMBER AS FAXNUMBER,
  _CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER[1: CORRESPONDENCELANGUAGE = $parameters. P_Language].FIRSTNAME AS FIRSTNAME,
  _CONTACTPERSON.FIRSTNAME AS CONTACTPERSONFIRSTNAME,
  _STANDARDADDRESS.HOUSENUMBER AS HOUSENUMBER,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].INDUSTRY AS INDUSTRY,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].INTERNATIONALLOCATIONNUMBER1 AS INTERNATIONALLOCATIONNUMBER1,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].LANGUAGE AS LANGUAGE,
  _CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER[1: CORRESPONDENCELANGUAGE = $parameters. P_Language].LASTNAME AS LASTNAME,
  ORGANIZATIONBPNAME1,
  ORGANIZATIONBPNAME2,
  POSTALCODE,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].POSTINGISBLOCKED AS POSTINGISBLOCKED,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].REGION AS REGION,
  _STANDARDADDRESS._REGION._REGIONTEXT[1: LANGUAGE = $parameters. P_Language].REGIONNAME AS REGIONNAME,
  _CUSTOMERSALESAREA._SALESORGANIZATION.SALESORGANIZATION AS SALESORGANIZATION,
  _CUSTOMERSALESAREA._SALESORGANIZATION._TEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  _CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER[1: CORRESPONDENCELANGUAGE = $parameters. P_Language].SEARCHTERM1 AS SEARCHTERM1,
  STREETNAME,
  _CUSTOMERTOBUSINESSPARTNER._CUSTOMER[1: LANGUAGE = $parameters. P_Language].TAXNUMBER1 AS TAXNUMBER1,
  VATREGISTRATION
FROM I_CUSTOMER
;

Learn More