I_HeadOfficeVH

DDL: I_HEADOFFICEVH SQL: IHEADOFFICEVH Type: view BASIC

Head Office Account Number

I_HeadOfficeVH is a Basic CDS View that provides data about "Head Office Account Number" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 8 fields with key fields Supplier, CompanyCode. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IHEADOFFICEVH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Supplier view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Head Office Account Number view
Consumption.ranked true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode CompanyCode
SupplierName _Supplier SupplierName Name
OrganizationBPName1 _Supplier OrganizationBPName1
OrganizationBPName2 _Supplier OrganizationBPName2
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'IHEADOFFICEVH'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #BASIC

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'Supplier'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Head Office Account Number' 
@Consumption.ranked: true

define view I_HeadOfficeVH
  as select from I_SupplierCompany
  association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
{
            @ObjectModel.text.element: 'SupplierName'
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #HIGH
  key       Supplier,
      //--[ GENERATED:012:GlBfhyJl7kY4i6}7dD1KRG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.75
            @Search.ranking: #LOW
            @ObjectModel.foreignKey.association: '_CompanyCode'
  key       CompanyCode,
            @EndUserText.label: 'Name'
            _Supplier.SupplierName as SupplierName,
            @UI.hidden: true
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
            @Consumption.filter.hidden: true
            _Supplier.OrganizationBPName1,
            @UI.hidden: true
            @Search.defaultSearchElement: true
            @Search.fuzzinessThreshold: 0.8
            @Search.ranking: #LOW
             @Consumption.filter.hidden: true
            _Supplier.OrganizationBPName2,
            @UI.hidden: true
            AuthorizationGroup,
             @UI.hidden: true
            IsBusinessPurposeCompleted, //added for DCL

            
            _CompanyCode
}  
  
  
  
  
  
  
  
  
  
  
  
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More