P_BusinessPartnerDefaultAddr

DDL: P_BUSINESSPARTNERDEFAULTADDR Type: view_entity CONSUMPTION Package: FKK_ID_PL_REP

Business Partner Default Address

P_BusinessPartnerDefaultAddr is a Consumption CDS View that provides data about "Business Partner Default Address" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerDefaultAddr) and exposes 10 fields with key fields BusinessPartner, BusinessPartnerAddressID. It has 1 association to related views. Part of development package FKK_ID_PL_REP.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerDefaultAddr I_BusinessPartnerDefaultAddr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_Address_2 _AddressDefaultRepresentation $projection.BusinessPartnerAddressID = _AddressDefaultRepresentation.AddressID and _AddressDefaultRepresentation.AddressRepresentationCode is initial

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 (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BusinessPartnerAddressID BusinessPartnerAddressID
clientNULLasValidityStartDate
clientNULLasValidityEndDate
IsStandardAddress IsStandardAddress
PersonNumber PersonNumber
PrfrdCommMediumType PrfrdCommMediumType
CorrespondenceLanguage CorrespondenceLanguage
AuthorizationGroup AuthorizationGroup
_AddressDefaultRepresentation _AddressDefaultRepresentation
@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_BusinessPartnerDefaultAddr
  as select from I_BusinessPartnerDefaultAddr
  association [0..*] to I_Address_2          as _AddressDefaultRepresentation on  $projection.BusinessPartnerAddressID                    = _AddressDefaultRepresentation.AddressID
                                                                              and _AddressDefaultRepresentation.AddressRepresentationCode is initial
{
  key BusinessPartner,
  key BusinessPartnerAddressID,
      tstmp_to_dats( ValidityStartDate,
                abap_system_timezone( $session.client,'NULL' ),
                $session.client,
                'NULL' ) as ValidityStartDate,
      tstmp_to_dats( ValidityEndDate,
                abap_system_timezone( $session.client,'NULL' ),
                $session.client,
                'NULL' ) as ValidityEndDate,                        
      IsStandardAddress,
      PersonNumber,
      PrfrdCommMediumType,
      CorrespondenceLanguage,
      AuthorizationGroup,
      /* Associations */      
      _AddressDefaultRepresentation      
}