I_SupplierCompanyVH

DDL: I_SUPPLIERCOMPANYVH SQL: ISUPLRCOMPVH Type: view COMPOSITE Package: VDM_MD_BP
7 Fields 1 Data Sources 5 OData Services

Supplier Company

I_SupplierCompanyVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_SupplierCompanyVH is a Composite CDS View that provides data about "Supplier Company" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 7 fields with key fields Supplier, CompanyCode. It is exposed through 5 OData services (ASQL_F0735, ASQL_F2550, ASQL_F2789, ...). Part of development package VDM_MD_BP.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-BP-2CL
CapabilitiesData Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLRCOMPVH view
EndUserText.label Supplier Company view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Search.searchable true view
ObjectModel.representativeKey Supplier view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F0735 ASQL_F0735 C2 NOT_RELEASED
ASQL_F2550 ASQL_F2550 C2 NOT_RELEASED
ASQL_F2789 ASQL_F2789 C2 NOT_RELEASED
ASQL_F2790 ASQL_F2790 C2 NOT_RELEASED
ASQL_F4051 ASQL_F4051 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Account Number of Supplier
KEY CompanyCode CompanyCode Receiver Company Code
_Supplier _Supplier
Country _Supplier Country Country/Region Key
BPSupplierName _Supplier BPSupplierName Supplier Name
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
_CompanyCode _CompanyCode

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_SupplierCompanyVH.
-- 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: ISUPLRCOMPVH

CREATE VIEW I_SupplierCompanyVH AS
SELECT
  Supplier,
  CompanyCode,
  _Supplier.Country AS Country,
  _Supplier.BPSupplierName AS BPSupplierName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_SupplierCompany
;

Learn More