P_CustNameCombinedSDMSts

DDL: P_CUSTNAMECOMBINEDSDMSTS Type: view_entity COMPOSITE
22 Fields 2 Data Sources

P_CustNameCombinedSDMSts is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, kna1) and exposes 22 fields with key fields Customer, BusinessPartner, ReferenceType, BusinessPartner, ReferenceType.

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment I_BPMultipleAssignment union_all
kna1 kna1 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Customer kna1 kunnr Stock customer
KEY BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
KEY ReferenceType
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory Partner Cat.
PersonNumber I_BusinessPartner PersonNumber Person Number
AddressNumber I_BPCurrentDefaultAddress AddressID Ship-to address
OrganizationName1 I_Address_2 OrganizationName1 Name
OrganizationName2 I_Address_2 OrganizationName2 Name 2
NameText I_Address_2 AddresseeFullName Full Name
char81endasNameCombinedCalc
NameCombined kna1 namecombined
BPObjectIDaskunnrasCustomer
KEY BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
KEY ReferenceType
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory Partner Cat.
PersonNumber I_BusinessPartner PersonNumber Person Number
AddressNumber I_BPCurrentDefaultAddress AddressID Ship-to address
OrganizationName1 I_Address_2 OrganizationName1 Name
OrganizationName2 I_Address_2 OrganizationName2 Name 2
NameText I_Address_2 AddresseeFullName Full Name
char81endasNameCombinedCalc
NameCombined kna1 namecombined

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_CustNameCombinedSDMSts.
-- 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 P_CustNameCombinedSDMSts AS
SELECT
  kna1.kunnr AS Customer,
  I_BusinessPartner.BusinessPartner AS BusinessPartner,
  cast('CUSTOMER' as abap.char( 15 )) AS ReferenceType,
  I_BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  I_BusinessPartner.PersonNumber AS PersonNumber,
  I_BPCurrentDefaultAddress.AddressID AS AddressNumber,
  I_Address_2.OrganizationName1 AS OrganizationName1,
  I_Address_2.OrganizationName2 AS OrganizationName2,
  I_Address_2.AddresseeFullName AS NameText,
  case when I_BusinessPartner.BusinessPartnerCategory = '1' then cast( coalesce( I_Address_2.AddresseeFullName, ' ') as abap.char( 81 ) ) when I_BusinessPartner.BusinessPartnerCategory = '2' or I_BusinessPartner.BusinessPartnerCategory = '3' then cast( concat_with_space( coalesce( I_Address_2.OrganizationName1, ' '), coalesce( I_Address_2.OrganizationName2, ' '), 1 ) as abap.char( 81 ) ) else cast( '' as abap.char( 81 ) ) end as NameCombinedCalc AS char81endasNameCombinedCalc,
  kna1.namecombined AS NameCombined,
  cast( case when case when I_BusinessPartner.BusinessPartnerCategory = '1' then cast( coalesce( I_Address_2.AddresseeFullName, ' ') as abap.char( 81 ) ) when I_BusinessPartner.BusinessPartnerCategory = '2' or I_BusinessPartner.BusinessPartnerCategory = '3' then cast( concat_with_space( coalesce( I_Address_2.OrganizationName1, ' '), coalesce( I_Address_2.OrganizationName2, ' '), 1 ) as abap.char( 81 ) ) else cast( '' as abap.char( 81 ) ) end = kna1.namecombined then '01' else '00' end as sdm_status_value_done ) as sdm_version AS BPObjectIDaskunnrasCustomer
FROM kna1
-- UNION ALL with additional select branch(es): I_BPMultipleAssignment
;

Learn More