I_PT_CustomerAddressHistory

DDL: I_PT_CUSTOMERADDRESSHISTORY SQL: IPTADRHST Type: view BASIC

PT Customer Address History

I_PT_CustomerAddressHistory is a Basic CDS View that provides data about "PT Customer Address History" in SAP S/4HANA. It reads from 1 data source (sipt_hist_kunnr) and exposes 17 fields with key fields Customer, PortugueseCustomerVersion. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
sipt_hist_kunnr History from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..*] I_Address_2 _Address $projection.AddressID = _Address.AddressID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPTADRHST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PT Customer Address History view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Customer kunnr
KEY PortugueseCustomerVersion adrnr_ver
AddressID adrnr
OrganizationBPName1 name1
OrganizationBPName2 name2
CityName city1
StreetName street
StreetPrefixName str_suppl1
AdditionalStreetPrefixName str_suppl2
StreetSuffixName str_suppl3
HouseNumber house_num1
AdditionalStreetSuffixName location
PostalCode post_code1
POBox po_box
Country country
_Customer _Customer
_Address _Address 
@AbapCatalog.sqlViewName: 'IPTADRHST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('BLOCKED_DATA_INCLUDED')
@EndUserText.label: 'PT Customer Address History'
define view I_PT_CustomerAddressHistory
  as select from sipt_hist_kunnr as History
  association [1..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
  association [0..*] to I_Address_2  as _Address  on $projection.AddressID = _Address.AddressID

{
  key kunnr                                                                          as Customer,
  key adrnr_ver                                                                      as PortugueseCustomerVersion,
  
      adrnr                                                                          as AddressID,
      name1                                                                          as OrganizationBPName1,
      name2                                                                          as OrganizationBPName2,
      city1                                                                          as CityName,
      street                                                                         as StreetName,
      str_suppl1                                                                     as StreetPrefixName,
      str_suppl2                                                                     as AdditionalStreetPrefixName,
      str_suppl3                                                                     as StreetSuffixName,
      house_num1                                                                     as HouseNumber,
      location                                                                       as AdditionalStreetSuffixName,
      post_code1                                                                     as PostalCode,
      po_box                                                                         as POBox,
      country                                                                        as Country,
      
      /* Associations */
      //FOR DPP AUTHORIZATION CHECK      

      _Customer,
      _Address
      
}
where
  nation = ' ';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SIPT_HIST_KUNNR"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More