I_TrdgContrPartAddressDets

DDL: I_TRDGCONTRPARTADDRESSDETS SQL: ITCPARTADDET Type: view BASIC

Interface view for Trading Contract Partner Address details

I_TrdgContrPartAddressDets is a Basic CDS View that provides data about "Interface view for Trading Contract Partner Address details" in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 5 fields with key field ActiveAddressID.

Data Sources (1)

SourceAliasJoin Type
adrc adrc from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITCPARTADDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Interface view for Trading Contract Partner Address details view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ActiveAddressID addrnumber
BusinessPartnerName1 name1
CustomerSupplierCityName city1
CustomerSupplierPostalCode post_code1
CustomerSupplierStreetName street
@AbapCatalog.sqlViewName: 'ITCPARTADDET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Interface view for Trading Contract Partner Address details'
define view I_TrdgContrPartAddressDets 
as select from adrc

{
  key addrnumber as ActiveAddressID,
      name1      as BusinessPartnerName1,
      city1      as CustomerSupplierCityName,
      post_code1 as CustomerSupplierPostalCode,
      street     as CustomerSupplierStreetName
    
} 
 where date_from <= $session.system_date and date_to >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/