I_BPCompanyAddressVH

DDL: I_BPCOMPANYADDRESSVH SQL: IBPCOMADDRVH Type: view COMPOSITE
2 Fields 1 Data Sources

Value Help for Company Address

I_BPCompanyAddressVH is a Composite CDS View that provides data about "Value Help for Company Address" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerAddress) and exposes 2 fields with key fields BusinessPartner, AddressNumber.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerAddress I_BusinessPartnerAddress from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPCOMADDRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value Help for Company Address view
ObjectModel.representativeKey AddressNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY AddressNumber AddressNumber Src Address No

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_BPCompanyAddressVH.
-- 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: IBPCOMADDRVH

CREATE VIEW I_BPCompanyAddressVH AS
SELECT
  BusinessPartner,
  AddressNumber
FROM I_BusinessPartnerAddress
;

Learn More