I_PT_SalesDocPartnerAddr

DDL: I_PT_SALESDOCPARTNERADDR SQL: IPTSDPRTNRADDR Type: view COMPOSITE

Sales Document Partner Addr for Portugal

I_PT_SalesDocPartnerAddr is a Composite CDS View that provides data about "Sales Document Partner Addr for Portugal" in SAP S/4HANA. It reads from 1 data source (I_PT_CustomerAddressVersion) and exposes 10 fields with key fields Customer, PortugueseDigitalSignatureDate, PortugueseDigitalSignatureTime. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_PT_CustomerAddressVersion I_PT_CustomerAddressVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PT_CustomerAddressHistory _Address _Address.Customer = $projection.Customer and _Address.PortugueseCustomerVersion = $projection.PortugueseCustomerVersion

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPTSDPRTNRADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Sales Document Partner Addr for Portugal view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY PortugueseDigitalSignatureDate PortugueseDigitalSignatureDate
KEY PortugueseDigitalSignatureTime PortugueseDigitalSignatureTime
PortugueseCustomerVersion PortugueseCustomerVersion
HouseNumber _Address HouseNumber
StreetName _Address StreetName
CustAddressNumber
CityName _Address CityName
PostalCode _Address PostalCode
Country _Address Country 
@AbapCatalog.sqlViewName: 'IPTSDPRTNRADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Sales Document Partner Addr for Portugal'
define view I_PT_SalesDocPartnerAddr  as select from I_PT_CustomerAddressVersion
  association [0..1] to I_PT_CustomerAddressHistory as _Address on  _Address.Customer                  = $projection.Customer
                                                                and _Address.PortugueseCustomerVersion = $projection.PortugueseCustomerVersion
          //   association [0..1] to I_Address as _region on _Address.AddressID = $projection.AddressID

{
  key Customer,
  key PortugueseDigitalSignatureDate,
  key PortugueseDigitalSignatureTime,
      PortugueseCustomerVersion,
      _Address.HouseNumber                                                as HouseNumber,
      _Address.StreetName                                                 as StreetName,
      coalesce(concat(_Address.HouseNumber,_Address.StreetName),'omisso') as CustAddressNumber,
      _Address.CityName                                                   as CityName,
      _Address.PostalCode                                                 as PostalCode,
     // _region.Region                                                     as Region,

      _Address.Country                                                    as Country
}

Learn More