P_SalesOrderFlfmtContact2

DDL: P_SALESORDERFLFMTCONTACT2 SQL: PSOFContact2 Type: view COMPOSITE
15 Fields 2 Data Sources

P_SalesOrderFlfmtContact2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CustomerContacts, I_SalesDocument) and exposes 15 fields with key field SalesDocument.

Data Sources (2)

SourceAliasJoin Type
I_CustomerContacts CC inner
I_SalesDocument SDH from

Parameters (1)

NameTypeDefault
P_SalesOrder vbeln_va

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSOFContact2 view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
Customer I_CustomerContacts Customer Sold-to Party
CustomerName
FirstName I_CustomerContacts FirstName First Name
LastName I_CustomerContacts LastName Last Name
ContactPersonFunction I_CustomerContacts ContactPersonFunction Function
InternationalPhoneNumber I_CustomerContacts InternationalPhoneNumber Telephone no.
PhoneNumber I_CustomerContacts PhoneNumber Telephone no.
PhoneNumberExtension I_CustomerContacts PhoneNumberExtension Extension
InternationalMobilePhoneNumber I_CustomerContacts InternationalMobilePhoneNumber
MobilePhoneNumber I_CustomerContacts MobilePhoneNumber Telephone
EmailAddress I_CustomerContacts EmailAddress E-Mail Address
PartnerFunction
ContactIsExternal
ContactIsInternal

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_SalesOrderFlfmtContact2.
-- 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: PSOFContact2
-- Parameters: P_SalesOrder : vbeln_va

CREATE VIEW P_SalesOrderFlfmtContact2 AS
SELECT
  SalesDocument,
  CC.Customer AS Customer,
  CC._Customer.CustomerName AS CustomerName,
  CC.FirstName AS FirstName,
  CC.LastName AS LastName,
  CC.ContactPersonFunction AS ContactPersonFunction,
  CC.InternationalPhoneNumber AS InternationalPhoneNumber,
  CC.PhoneNumber AS PhoneNumber,
  CC.PhoneNumberExtension AS PhoneNumberExtension,
  CC.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CC.MobilePhoneNumber AS MobilePhoneNumber,
  CC.EmailAddress AS EmailAddress,
  'AG' AS PartnerFunction,
  cast('X' as external_contact) AS ContactIsExternal,
  cast('' as internal_contact) AS ContactIsInternal
FROM I_SalesDocument AS SDH
INNER JOIN I_CustomerContacts AS CC ON /* join condition not captured in parsed metadata */
;

Learn More