C_Alternativepayeevhtemp

DDL: C_ALTERNATIVEPAYEEVHTEMP SQL: CALTVPAYEEVHTEMP Type: view CONSUMPTION

Account Number of Alternative Payee

C_Alternativepayeevhtemp is a Consumption CDS View that provides data about "Account Number of Alternative Payee" in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 12 fields with key fields AlternativePayee, CompanyCode. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CALTVPAYEEVHTEMP view
ObjectModel.representativeKey AlternativePayee view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Account Number of Alternative Payee view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AlternativePayee Supplier
KEY CompanyCode CompanyCode
SupplierName _Supplier SupplierName Name
OrganizationBPName1 _Supplier OrganizationBPName1
OrganizationBPName2 _Supplier OrganizationBPName2
BPSupplierName _Supplier BPSupplierName Name
BusinessPartnerName1 _Supplier BusinessPartnerName1
BusinessPartnerName2 _Supplier BusinessPartnerName2
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
_CompanyCode _CompanyCode
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'CALTVPAYEEVHTEMP'
@ObjectModel.representativeKey: 'AlternativePayee'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Account Number of Alternative Payee'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

define view C_Alternativepayeevhtemp
  as select from I_SupplierCompany

  association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
{
          //--[ GENERATED:011:GFBfhyK17jY4gdBtF410gW

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

          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.75
          @Search.ranking: #HIGH
          @ObjectModel.text.element: 'SupplierName'
  key     Supplier    as AlternativePayee,
          //--[ GENERATED:011:GFBfhyK17jY4gdBtF410gW

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

          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.75
          @Search.ranking: #HIGH
          @ObjectModel.foreignKey.association:'_CompanyCode'
  key     CompanyCode as CompanyCode,
          @EndUserText.label: 'Name'
          _Supplier.SupplierName,
          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.8
          @Search.ranking: #HIGH
          @Consumption.filter.hidden: true
          _Supplier.OrganizationBPName1,
          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.8
          @Search.ranking: #HIGH
          @Consumption.filter.hidden: true
          _Supplier.OrganizationBPName2,


          //        For increased field length

          @EndUserText.label: 'Name'
          _Supplier.BPSupplierName,
          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.8
          @Search.ranking: #HIGH
          @Consumption.filter.hidden: true
          _Supplier.BusinessPartnerName1,
          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.8
          @Search.ranking: #HIGH
          @Consumption.filter.hidden: true
          _Supplier.BusinessPartnerName2,

          @UI.hidden: true
          @Consumption.filter.hidden: true
          AuthorizationGroup,
          @UI.hidden: true
          @Consumption.filter.hidden: true
          IsBusinessPurposeCompleted,

          _CompanyCode,
          _Supplier

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

Learn More