C_LCMSupplierValueHelp

DDL: C_LCMSUPPLIERVALUEHELP SQL: CLCMSUPPLVH Type: view CONSUMPTION Package: ODATA_LCM_LT
33 Fields 1 Data Sources 2 Associations 1 OData Services

Supplier Value Help

C_LCMSupplierValueHelp is a Consumption CDS View that provides data about "Supplier Value Help" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 33 fields with key fields Supplier, CompanyCode. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F2640). Part of development package ODATA_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BusinessPartnerSuplrCo _BusinessPartnerSuplrCo $projection.Supplier = _BusinessPartnerSuplrCo.Supplier
[1..1] I_Supplier_to_BusinessPartner _SupplierBusinessPartner $projection.Supplier = _SupplierBusinessPartner.Supplier

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CLCMSUPPLVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_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 Supplier view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Supplier Value Help view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2640 ASQL_F2640 C2 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY CompanyCode _BusinessPartnerSuplrCo CompanyCode Receiver Company Code
BusinessPartner
BusinessPartnerName Business Partner Name
CityName _AddressRepresentation CityName Name
PostalCode _AddressRepresentation PostalCode Postal Code
Region _AddressRepresentation Region Venue Region
Country _AddressRepresentation Country Venue: Ctry/Reg
StreetName _AddressRepresentation StreetName Text
PhoneNumber
EmailAddress
LglCntntMSupplierFirstName
LglCntntMSupplierLastName
LglCntntMSupplierOrgFirstName
LglCntntMSupplierOrgSecondName
LglCntntMSupplierGrpFirstName
LglCntntMSupplierGrpSecondName
_BusinessPartnerSuplrCo _BusinessPartnerSuplrCo
_SupplierBusinessPartner _SupplierBusinessPartner
AuthorizationGroup AuthorizationGroup AuthorizGroup
SupplierAccountGroup SupplierAccountGroup Account group
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
DataControllerSet I_Supplier DataControllerSet Data Ctrlr. Set
DataController1 I_Supplier DataController1 Data Controller
DataController2 I_Supplier DataController2 Data Controller
DataController3 I_Supplier DataController3 Data Controller
DataController4 I_Supplier DataController4 Data Controller
DataController5 I_Supplier DataController5 Data Controller
DataController6 I_Supplier DataController6 Data Controller
DataController7 I_Supplier DataController7 Data Controller
DataController8 I_Supplier DataController8 Data Controller
DataController9 I_Supplier DataController9 Data Controller
DataController10 I_Supplier 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_LCMSupplierValueHelp.
-- 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: CLCMSUPPLVH

CREATE VIEW C_LCMSupplierValueHelp AS
SELECT
  Supplier,
  _BusinessPartnerSuplrCo.CompanyCode AS CompanyCode,
  _SupplierBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _SupplierBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _AddressRepresentation.CityName AS CityName,
  _AddressRepresentation.PostalCode AS PostalCode,
  _AddressRepresentation.Region AS Region,
  _AddressRepresentation.Country AS Country,
  _AddressRepresentation.StreetName AS StreetName,
  _AddressRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _AddressRepresentation._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  _SupplierBusinessPartner._BusinessPartner.FirstName AS LglCntntMSupplierFirstName,
  _SupplierBusinessPartner._BusinessPartner.LastName AS LglCntntMSupplierLastName,
  _SupplierBusinessPartner._BusinessPartner.OrganizationBPName1 AS LglCntntMSupplierOrgFirstName,
  _SupplierBusinessPartner._BusinessPartner.OrganizationBPName2 AS LglCntntMSupplierOrgSecondName,
  _SupplierBusinessPartner._BusinessPartner.GroupBusinessPartnerName1 AS LglCntntMSupplierGrpFirstName,
  _SupplierBusinessPartner._BusinessPartner.GroupBusinessPartnerName2 AS LglCntntMSupplierGrpSecondName,
  AuthorizationGroup,
  SupplierAccountGroup,
  IsBusinessPurposeCompleted,
  I_Supplier.DataControllerSet AS DataControllerSet,
  I_Supplier.DataController1 AS DataController1,
  I_Supplier.DataController2 AS DataController2,
  I_Supplier.DataController3 AS DataController3,
  I_Supplier.DataController4 AS DataController4,
  I_Supplier.DataController5 AS DataController5,
  I_Supplier.DataController6 AS DataController6,
  I_Supplier.DataController7 AS DataController7,
  I_Supplier.DataController8 AS DataController8,
  I_Supplier.DataController9 AS DataController9,
  I_Supplier.DataController10 AS DataController10
FROM I_Supplier
LEFT OUTER JOIN I_BusinessPartnerSuplrCo AS _BusinessPartnerSuplrCo ON Supplier = _BusinessPartnerSuplrCo.Supplier  -- association [0..*]
LEFT OUTER JOIN I_Supplier_to_BusinessPartner AS _SupplierBusinessPartner ON Supplier = _SupplierBusinessPartner.Supplier  -- association [1..1]
;

Learn More