C_SupplierValueHelp
Supplier Value Help
C_SupplierValueHelp 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 29 fields with key fields Supplier, CompanyCode.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_Supplier | I_Supplier | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CSUPVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| EndUserText.label | Supplier Value Help | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view |
Fields (29)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Supplier | Supplier | ||
| KEY | CompanyCode | _SupplierCompany | CompanyCode | |
| SupplierName | SupplierName | |||
| AuthorizationGroup | AuthorizationGroup | |||
| SupplierAccountGroup | SupplierAccountGroup | |||
| Country | Country | |||
| StreetName | StreetName | |||
| CityName | CityName | |||
| PostalCode | PostalCode | |||
| PhoneNumber1 | PhoneNumber1 | |||
| EmailAddress | ||||
| SupplierClerk | _SupplierCompany | SupplierClerk | ||
| SupplierClerkURL | _SupplierCompany | SupplierClerkURL | ||
| AccountingClerkPhoneNumber | _SupplierCompany | AccountingClerkPhoneNumber | ||
| AccountingClerkFaxNumber | _SupplierCompany | AccountingClerkFaxNumber | ||
| AccountingClerk | _SupplierCompany | AccountingClerk | ||
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | |||
| DataControllerSet | DataControllerSet | |||
| DataController1 | DataController1 | |||
| DataController2 | DataController2 | |||
| DataController3 | DataController3 | |||
| DataController4 | DataController4 | |||
| DataController5 | DataController5 | |||
| DataController6 | DataController6 | |||
| DataController7 | DataController7 | |||
| DataController8 | DataController8 | |||
| DataController9 | DataController9 | |||
| DataController10 | DataController10 | |||
| _SupplierCompany | _SupplierCompany |
@AbapCatalog.sqlViewName: 'CSUPVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
//@AccessControl.privilegedAssociations: [ '_UserContactCard' ]
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.dataCategory: #VALUE_HELP
@EndUserText.label: 'Supplier Value Help'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
usageType.serviceQuality: #C,
usageType.sizeCategory: #L,
usageType.dataClass: #MIXED
}
@Search.searchable: true
define view C_SupplierValueHelp as
select from I_Supplier
{
@Search: { defaultSearchElement: true, ranking: #HIGH }
@Consumption.semanticObject: 'Supplier'
@UI.lineItem.position:10
key Supplier,
@Search: { defaultSearchElement: true, ranking: #HIGH }
@UI.lineItem.position:30
key _SupplierCompany.CompanyCode, // no association->no VH handling
@UI.lineItem.position:20
SupplierName,
AuthorizationGroup,
SupplierAccountGroup,
@Search: { defaultSearchElement: true, ranking: #HIGH }
Country,
StreetName,
@Search: { defaultSearchElement: true, ranking: #HIGH }
CityName,
@Search: { defaultSearchElement: true, ranking: #HIGH }
PostalCode,
PhoneNumber1,
cast (_StandardAddress._DefaultEmailAddress.EmailAddress as supplist_smtpadr preserving type) as EmailAddress,
_SupplierCompany.SupplierClerk,
_SupplierCompany.SupplierClerkURL,
_SupplierCompany.AccountingClerkPhoneNumber,
_SupplierCompany.AccountingClerkFaxNumber,
_SupplierCompany.AccountingClerk,
@UI.hidden: true
IsBusinessPurposeCompleted,
@Consumption.hidden: true
DataControllerSet,
@Consumption.hidden: true
DataController1,
@Consumption.hidden: true
DataController2,
@Consumption.hidden: true
DataController3,
@Consumption.hidden: true
DataController4,
@Consumption.hidden: true
DataController5,
@Consumption.hidden: true
DataController6,
@Consumption.hidden: true
DataController7,
@Consumption.hidden: true
DataController8,
@Consumption.hidden: true
DataController9,
@Consumption.hidden: true
DataController10,
_SupplierCompany
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_SUPPLIERCOMPANY"
],
"BASE":
[
"I_SUPPLIER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA