ESH_S_CUSTOMERS_T

DDL: ESH_S_CUSTOMERS_T SQL: ESH_U_CUSTOMERST Type: view
56 Fields 1 Data Sources 1 Associations

ESH_S_CUSTOMERS_T is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_CUSTOMERS_T) and exposes 56 fields with key field CUSTOMER. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_N_CUSTOMERS_T ESH_N_CUSTOMERS_T from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_CUSTOMER _CUSTOMEREXT ( $projection.CUSTOMER = _CUSTOMEREXT.CUSTOMER )

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name Customer view
UI.headerInfo.typeName Customer view
UI.headerInfo.typeNamePlural Customers view
Consumption.semanticObject Customer view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value ORGANIZATIONBPNAME2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_CUSTOMERST view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CUSTOMER CUSTOMER Sold-to Party
ADDRESSID ADDRESSID Ship-to address
AUTHORIZATIONGROUP AUTHORIZATIONGROUP AuthorizGroup
BILLINGISBLOCKEDFORCUSTOMER BILLINGISBLOCKEDFORCUSTOMER Billing block
BPADDRCITYNAME BPADDRCITYNAME
BPADDRSTREETNAME BPADDRSTREETNAME
BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
BUSINESSPARTNERNAME1 BUSINESSPARTNERNAME1 Name
BUSINESSPARTNERNAME2 BUSINESSPARTNERNAME2 Name 2
CITYNAME CITYNAME Name
COMPANYCODE COMPANYCODE Receiver Company Code
CONTACTPERSONDEPARTMENT CONTACTPERSONDEPARTMENT Department
CONTACTPERSONFUNCTION CONTACTPERSONFUNCTION Function
COUNTRY COUNTRY Country/Region Key
COUNTRYNAME COUNTRYNAME Country/Region
CREATEDBYUSER CREATEDBYUSER User Name
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 DELIVERYISBLOCKED Delivery block
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DISTRIBUTIONCHANNELNAME DISTRIBUTIONCHANNELNAME Distribution Channel
DIVISION DIVISION Internal Division ID
DIVISIONNAME DIVISIONNAME Division
EMAILADDRESS EMAILADDRESS Email
FAXNUMBER FAXNUMBER Fax Number
FIRSTNAME FIRSTNAME First Name
CONTACTPERSONFIRSTNAME CONTACTPERSONFIRSTNAME First Name
HOUSENUMBER HOUSENUMBER House Number
INDUSTRY INDUSTRY Industry Sector
INTERNATIONALLOCATIONNUMBER1 INTERNATIONALLOCATIONNUMBER1 Location no. 1
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
LANGUAGE LANGUAGE Report Text Language
LASTNAME LASTNAME Last Name
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Name 1
ORGANIZATIONBPNAME2 ORGANIZATIONBPNAME2 Additional Name
POSTALCODE POSTALCODE Postal Code
POSTINGISBLOCKED POSTINGISBLOCKED Posting Block
REGION REGION Venue Region
REGIONNAME REGIONNAME Region
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME SALESORGANIZATIONNAME Sales Organization
SEARCHTERM1 SEARCHTERM1 Search Term
STREETNAME STREETNAME Address
TAXNUMBER1 TAXNUMBER1 Tax Number
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_S_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_U_CUSTOMERST
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_CUSTOMERS_T AS
SELECT
  CUSTOMER,
  ADDRESSID,
  AUTHORIZATIONGROUP,
  BILLINGISBLOCKEDFORCUSTOMER,
  BPADDRCITYNAME,
  BPADDRSTREETNAME,
  BUSINESSPARTNER,
  BUSINESSPARTNERNAME1,
  BUSINESSPARTNERNAME2,
  CITYNAME,
  COMPANYCODE,
  CONTACTPERSONDEPARTMENT,
  CONTACTPERSONFUNCTION,
  COUNTRY,
  COUNTRYNAME,
  CREATEDBYUSER,
  CUSTOMERACCOUNTGROUP,
  DATACONTROLLER1,
  DATACONTROLLER10,
  DATACONTROLLER2,
  DATACONTROLLER3,
  DATACONTROLLER4,
  DATACONTROLLER5,
  DATACONTROLLER6,
  DATACONTROLLER7,
  DATACONTROLLER8,
  DATACONTROLLER9,
  DATACONTROLLERSET,
  DELETIONINDICATOR,
  DELIVERYISBLOCKED,
  DISTRIBUTIONCHANNEL,
  DISTRIBUTIONCHANNELNAME,
  DIVISION,
  DIVISIONNAME,
  EMAILADDRESS,
  FAXNUMBER,
  FIRSTNAME,
  CONTACTPERSONFIRSTNAME,
  HOUSENUMBER,
  INDUSTRY,
  INTERNATIONALLOCATIONNUMBER1,
  ISBUSINESSPURPOSECOMPLETED,
  LANGUAGE,
  LASTNAME,
  ORGANIZATIONBPNAME1,
  ORGANIZATIONBPNAME2,
  POSTALCODE,
  POSTINGISBLOCKED,
  REGION,
  REGIONNAME,
  SALESORGANIZATION,
  SALESORGANIZATIONNAME,
  SEARCHTERM1,
  STREETNAME,
  TAXNUMBER1,
  VATREGISTRATION
FROM ESH_N_CUSTOMERS_T
LEFT OUTER JOIN E_CUSTOMER AS _CUSTOMEREXT ON ( CUSTOMER = _CUSTOMEREXT.CUSTOMER )  -- association [0..1]
;

Learn More