I_CollsCustomerVH

DDL: I_COLLSCUSTOMERVH Type: view COMPOSITE Package: ODATA_PROCREC_COMMONS
9 Fields 1 Data Sources 2 Associations 3 OData Services

Customer VH

I_CollsCustomerVH is a Composite CDS View that provides data about "Customer VH" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 9 fields with key field Customer. It has 2 associations to related views. It is exposed through 3 OData services (ASQL_F0702A, ASQL_F4710, ASQL_F5999). Part of development package ODATA_PROCREC_COMMONS.

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Customer_VH _CustomerVH $projection.Customer = _CustomerVH.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICLLCSTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Customer VH view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
Search.searchable true view
Consumption.ranked true view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F0702A ASQL_F0702A C2 NOT_RELEASED
ASQL_F4710 ASQL_F4710 C2 NOT_RELEASED
ASQL_F5999 ASQL_F5999 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Country Country Venue: Ctry/Reg
CityName CityName Name
StreetName StreetName Text
OrganizationBPName1 OrganizationBPName1 Name 1
OrganizationBPName2 OrganizationBPName2 Name 2
_Customer _Customer
_CustomerVH _CustomerVH

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 I_CollsCustomerVH.
-- 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 I_CollsCustomerVH AS
SELECT
  Customer,
  CustomerName,
  Country,
  CityName,
  StreetName,
  OrganizationBPName1,
  OrganizationBPName2
FROM I_Customer
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer_VH AS _CustomerVH ON Customer = _CustomerVH.Customer  -- association [0..1]
;

Learn More