I_PrepaymentAddressVH

DDL: I_PREPAYMENTADDRESSVH SQL: IPPMGADDVH Type: view BASIC

Address for Prepayment

I_PrepaymentAddressVH is a Basic CDS View that provides data about "Address for Prepayment" in SAP S/4HANA. It reads from 2 data sources (I_BusPartTaxTypeText, I_BusPartAddrDepdntTaxNmbr) and exposes 4 fields with key fields BusinessPartner, AddressNumber.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_BusPartTaxTypeText _TaxCategoryTxt inner
I_BusPartAddrDepdntTaxNmbr AddressDepTax from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGADDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
EndUserText.label Address for Prepayment view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddrDepdntTaxNmbr BusinessPartner
KEY AddressNumber I_BusPartAddrDepdntTaxNmbr BusinessPartnerAddressID
TaxTypeName I_BusPartTaxTypeText TaxTypeName
BPTaxNumber I_BusPartAddrDepdntTaxNmbr BPTaxNumber 
@AbapCatalog.sqlViewName          : 'IPPMGADDVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey          : true
@ClientHandling.algorithm         : #SESSION_VARIABLE
@AccessControl.authorizationCheck : #CHECK
@AccessControl.personalData.blocking : #REQUIRED
@VDM.viewType                     : #BASIC
@ObjectModel:{
    usageType:{
    sizeCategory: #S,
    dataClass: #CUSTOMIZING,
    serviceQuality: #A
    }
}
@Metadata.ignorePropagatedAnnotations : true
@Search.searchable                    : true
@EndUserText.label                    : 'Address for Prepayment'

define view I_PrepaymentAddressVH
  as select from I_BusPartAddrDepdntTaxNmbr as AddressDepTax

    inner join   I_BusPartTaxTypeText       as _TaxCategoryTxt on  _TaxCategoryTxt.BPTaxType = AddressDepTax.BPTaxType
                                                               and _TaxCategoryTxt.Language  = $session.system_language

{

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
  key AddressDepTax.BusinessPartner,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
  key AddressDepTax.BusinessPartnerAddressID as AddressNumber,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      _TaxCategoryTxt.TaxTypeName,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      AddressDepTax.BPTaxNumber

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

Learn More