C_BidderValueHelp

DDL: C_BIDDERVALUEHELP SQL: CBIDDERVH Type: view CONSUMPTION
29 Fields 1 Data Sources 3 Associations

Bidder Value Help

C_BidderValueHelp is a Consumption CDS View that provides data about "Bidder Value Help" in SAP S/4HANA. It reads from 1 data source (I_SuplrContactCard) and exposes 29 fields with key fields Supplier, PurchasingOrganization. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SuplrContactCard _Supplier from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_SupplierPurchasingOrg _SupplierPurchasingOrg $projection.Supplier = _SupplierPurchasingOrg.Supplier
[0..1] I_PurchasingOrganization _PurchasingOrganization _PurchasingOrganization.PurchasingOrganization = $projection.purchasingorganization
[1..*] I_CountryText _CountryText $projection.Country = _CountryText.Country

Annotations (14)

NameValueLevelField
ObjectModel.representativeKey Supplier view
ObjectModel.semanticKey Supplier view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Bidder Value Help view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName CBIDDERVH view
Consumption.ranked true view
Search.searchable true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_SuplrContactCard ContactCardID Vendor no.
KEY PurchasingOrganization _SupplierPurchasingOrg PurchasingOrganization Purchasing Organization
SupplierName I_SuplrContactCard FullName Name
AddressID I_SuplrContactCard AddressID Ship-to address
FormattedAddress
PhoneNumber I_SuplrContactCard PhoneNumber Telephone no.
MobilePhoneNumber I_SuplrContactCard MobilePhoneNumber Telephone
EmailAddress I_SuplrContactCard EmailAddress E-Mail Address
Country I_SuplrContactCard Country Venue: Ctry/Reg
CityName I_SuplrContactCard CityName Name
PostalCode I_SuplrContactCard PostalCode Postal Code
StreetName I_SuplrContactCard StreetName Text
AuthorizationGroup I_SuplrContactCard AuthorizationGroup AuthorizGroup
SupplierAccountGroup I_SuplrContactCard SupplierAccountGroup Account group
IsBusinessPurposeCompleted I_SuplrContactCard IsBusinessPurposeCompleted Purpose Completed
DataController1 I_SuplrContactCard DataController1 Data Controller
DataController2 I_SuplrContactCard DataController2 Data Controller
DataController3 I_SuplrContactCard DataController3 Data Controller
DataController4 I_SuplrContactCard DataController4 Data Controller
DataController5 I_SuplrContactCard DataController5 Data Controller
DataController6 I_SuplrContactCard DataController6 Data Controller
DataController7 I_SuplrContactCard DataController7 Data Controller
DataController8 I_SuplrContactCard DataController8 Data Controller
DataController9 I_SuplrContactCard DataController9 Data Controller
DataController10 I_SuplrContactCard DataController10 Data Controller
DataControllerSet I_SuplrContactCard DataControllerSet Data Ctrlr. Set
_CountryText _CountryText
_PurchasingOrganization _PurchasingOrganization
_SupplierPurchasingOrg _SupplierPurchasingOrg

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_BidderValueHelp.
-- 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: CBIDDERVH

CREATE VIEW C_BidderValueHelp AS
SELECT
  _Supplier.ContactCardID AS Supplier,
  _SupplierPurchasingOrg.PurchasingOrganization AS PurchasingOrganization,
  _Supplier.FullName AS SupplierName,
  _Supplier.AddressID AS AddressID,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  _Supplier.PhoneNumber AS PhoneNumber,
  _Supplier.MobilePhoneNumber AS MobilePhoneNumber,
  _Supplier.EmailAddress AS EmailAddress,
  _Supplier.Country AS Country,
  _Supplier.CityName AS CityName,
  _Supplier.PostalCode AS PostalCode,
  _Supplier.StreetName AS StreetName,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM I_SuplrContactCard AS _Supplier
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON Supplier = _SupplierPurchasingOrg.Supplier  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = purchasingorganization  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country  -- association [1..*]
;

Learn More