C_LCMContactsOrgValueHelp

DDL: C_LCMCONTACTSORGVALUEHELP SQL: CLCMCONTCTORGVH Type: view CONSUMPTION
34 Fields 1 Data Sources 3 Associations

Value Help for Contact Org. of BP

C_LCMContactsOrgValueHelp is a Consumption CDS View that provides data about "Value Help for Contact Org. of BP" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 34 fields with key fields Customer, CompanyCode. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Customer _Customer from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_BusinessPartnerCustCo _BusinessPartnerCustCo $projection.Customer = _BusinessPartnerCustCo.Customer
[0..*] I_CustomerCompany _CustomerCompany $projection.Customer = _CustomerCompany.Customer
[1..1] I_Customer_to_BusinessPartner _CustomerBusinessPartner $projection.Customer = _CustomerBusinessPartner.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CLCMCONTCTORGVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey Customer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value Help for Contact Org. of BP view
Consumption.ranked true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer Sold-to Party
KEY CompanyCode _CustomerCompany CompanyCode Receiver Company Code
BusinessPartner
BusinessPartnerName Business Partner Name
Country I_Customer Country Venue: Ctry/Reg
CityName I_Customer CityName Name
StreetName I_Customer StreetName Text
HouseNumber _StandardAddress HouseNumber House Number
PostalCode I_Customer PostalCode Postal Code
PhoneNumber
EmailAddresselseendasEmailAddress
LglCntntMCustomerFirstName
LglCntntMCustomerSecondName
LglCntntMCustomerOrgFirstName Name 1
LglCntntMCustomerOrgSecondName Name 2
LglCntntMCustomerGrpFirstName
LglCntntMCustomerGrpSecondName
_BusinessPartnerCustCo _BusinessPartnerCustCo
_CustomerCompany _CustomerCompany
_CustomerBusinessPartner _CustomerBusinessPartner
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
AuthorizationGroup I_Customer AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted Purpose Completed
DataControllerSet I_Customer DataControllerSet Data Ctrlr. Set
DataController1 I_Customer DataController1 Data Controller
DataController2 I_Customer DataController2 Data Controller
DataController3 I_Customer DataController3 Data Controller
DataController4 I_Customer DataController4 Data Controller
DataController5 I_Customer DataController5 Data Controller
DataController6 I_Customer DataController6 Data Controller
DataController7 I_Customer DataController7 Data Controller
DataController8 I_Customer DataController8 Data Controller
DataController9 I_Customer DataController9 Data Controller
DataController10 I_Customer DataController10 Data Controller

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 C_LCMContactsOrgValueHelp.
-- 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: CLCMCONTCTORGVH

CREATE VIEW C_LCMContactsOrgValueHelp AS
SELECT
  _Customer.Customer AS Customer,
  _CustomerCompany.CompanyCode AS CompanyCode,
  _CustomerBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _Customer.Country AS Country,
  _Customer.CityName AS CityName,
  _Customer.StreetName AS StreetName,
  _StandardAddress.HouseNumber AS HouseNumber,
  _Customer.PostalCode AS PostalCode,
  _StandardAddress._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  case when _DefaultEmailAddress.EmailAddress is not initial then _DefaultEmailAddress.EmailAddress when _DefaultEmailAddr.EmailAddress is not initial then _DefaultEmailAddr.EmailAddress else '' end as EmailAddress AS EmailAddresselseendasEmailAddress,
  _CustomerBusinessPartner._BusinessPartner.FirstName AS LglCntntMCustomerFirstName,
  _CustomerBusinessPartner._BusinessPartner.LastName AS LglCntntMCustomerSecondName,
  _CustomerBusinessPartner._BusinessPartner.OrganizationBPName1 AS LglCntntMCustomerOrgFirstName,
  _CustomerBusinessPartner._BusinessPartner.OrganizationBPName2 AS LglCntntMCustomerOrgSecondName,
  _CustomerBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 AS LglCntntMCustomerGrpFirstName,
  _CustomerBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 AS LglCntntMCustomerGrpSecondName,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.DataControllerSet AS DataControllerSet,
  _Customer.DataController1 AS DataController1,
  _Customer.DataController2 AS DataController2,
  _Customer.DataController3 AS DataController3,
  _Customer.DataController4 AS DataController4,
  _Customer.DataController5 AS DataController5,
  _Customer.DataController6 AS DataController6,
  _Customer.DataController7 AS DataController7,
  _Customer.DataController8 AS DataController8,
  _Customer.DataController9 AS DataController9,
  _Customer.DataController10 AS DataController10
FROM I_Customer AS _Customer
LEFT OUTER JOIN I_BusinessPartnerCustCo AS _BusinessPartnerCustCo ON Customer = _BusinessPartnerCustCo.Customer  -- association [0..*]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer  -- association [0..*]
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerBusinessPartner ON Customer = _CustomerBusinessPartner.Customer  -- association [1..1]
;

Learn More