SEPMRA_C_ALP_Customer

DDL: SEPMRA_C_ALP_CUSTOMER Type: view
6 Fields 1 Data Sources

Customer

SEPMRA_C_ALP_Customer is a CDS View that provides data about "Customer" in SAP S/4HANA. It reads from 1 data source (SEPM_I_CUSTOMER_E) and exposes 6 fields with key field Customer.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_CUSTOMER_E Customer from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRACALPCUST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customer view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Customer Sold-to Party
CompanyName CompanyName Text
EmailAddress EmailAddress E-Mail Address
FaxNumber FaxNumber Fax Number
PhoneNumber PhoneNumber Telephone no.
URL URL URLContract

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 SEPMRA_C_ALP_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.

CREATE VIEW SEPMRA_C_ALP_Customer AS
SELECT
  cast( Customer as snwd_customer_id preserving type ) AS Customer,
  CompanyName,
  EmailAddress,
  FaxNumber,
  PhoneNumber,
  URL
FROM SEPM_I_CUSTOMER_E AS Customer
;

Learn More