P_CustomerByExternalID

DDL: P_CUSTOMERBYEXTERNALID SQL: PDDFCUSTBYEXTID Type: view CONSUMPTION
4 Fields 1 Data Sources

P_CustomerByExternalID is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 4 fields with key fields Customer, BusinessPartner, BPIdentificationType, BPIdentificationNumber.

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDDFCUSTBYEXTID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer Sold-to Party
KEY BusinessPartner BuPaIdentification BusinessPartner Issuing Authority
KEY BPIdentificationType BuPaIdentification BPIdentificationType ID Type
KEY BPIdentificationNumber BuPaIdentification BPIdentificationNumber Logical System

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 P_CustomerByExternalID.
-- 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: PDDFCUSTBYEXTID

CREATE VIEW P_CustomerByExternalID AS
SELECT
  I_Customer.Customer AS Customer,
  BuPaIdentification.BusinessPartner AS BusinessPartner,
  BuPaIdentification.BPIdentificationType AS BPIdentificationType,
  BuPaIdentification.BPIdentificationNumber AS BPIdentificationNumber
FROM I_Customer
;

Learn More