P_RO_SAFTCACTGPARTNER_ROX

DDL: P_RO_SAFTCACTGPARTNER_ROX Type: view_entity CONSUMPTION Package: FKK_ID_RO_REP

Partner with Standard Address and Tax Number

P_RO_SAFTCACTGPARTNER_ROX is a Consumption CDS View that provides data about "Partner with Standard Address and Tax Number" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 16 fields with key field BusinessPartner. It has 2 associations to related views. Part of development package FKK_ID_RO_REP.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner BP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_RO_SAFTCActgStdPartAddrTxNr _BPStdAddrTax $projection.BusinessPartner = _BPStdAddrTax.BusinessPartner
[0..1] P_RO_SAFTCActgStdPartAddr _BPStdAddr $projection.BusinessPartner = _BPStdAddr.BusinessPartner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory
BPTaxType _BPStdAddrTax BPTaxType
CountryISOCode _BPStdAddrTax CountryISOCode
IsEuropeanUnionMember _BPStdAddrTax IsEuropeanUnionMember
BPTaxNumber _BPStdAddrTax BPTaxNumber
BPTaxLongNumber _BPStdAddrTax BPTaxLongNumber
VATRegistration _BPStdAddrTax VATRegistration
AddressID _BPStdAddr AddressID
CompanyName _BPStdAddr CompanyName
StreetName _BPStdAddr StreetName
HouseNumber _BPStdAddr HouseNumber
CityName _BPStdAddr CityName
PostalCode _BPStdAddr PostalCode
Region _BPStdAddr Region
Country _BPStdAddr Country 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view entity P_RO_SAFTCACTGPARTNER_ROX as 
    select from I_BusinessPartner                           as BP 
    association [0..1] to P_RO_SAFTCActgStdPartAddrTxNr     as _BPStdAddrTax
        on $projection.BusinessPartner = _BPStdAddrTax.BusinessPartner
    association [0..1] to P_RO_SAFTCActgStdPartAddr        as _BPStdAddr
        on $projection.BusinessPartner = _BPStdAddr.BusinessPartner
{
  key BP.BusinessPartner,
  BP.BusinessPartnerCategory,
  _BPStdAddrTax.BPTaxType,
  _BPStdAddrTax.CountryISOCode,
  _BPStdAddrTax.IsEuropeanUnionMember,
  _BPStdAddrTax.BPTaxNumber,
  _BPStdAddrTax.BPTaxLongNumber,
  _BPStdAddrTax.VATRegistration,
  _BPStdAddr.AddressID,
  _BPStdAddr.CompanyName,
  _BPStdAddr.StreetName,
  _BPStdAddr.HouseNumber,
  _BPStdAddr.CityName,
  _BPStdAddr.PostalCode,
  _BPStdAddr.Region,
  _BPStdAddr.Country
}
where _BPStdAddrTax.BPTaxType <> 'RO9'

Learn More