R_PurContrAddressTP

DDL: R_PURCONTRADDRESSTP Type: view_entity TRANSACTIONAL

Purchase Contract Address

R_PurContrAddressTP is a Transactional CDS View that provides data about "Purchase Contract Address" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAddress) and exposes 49 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 49 fields

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAddress I_PurCtrAddress from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Contract Address view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
AddressID AddressID
Plant Plant
CareOfName CareOfName
AdditionalStreetSuffixName AdditionalStreetSuffixName
CorrespondenceLanguage CorrespondenceLanguage
PrfrdCommMediumType PrfrdCommMediumType
POBox POBox
POBoxIsWithoutNumber POBoxIsWithoutNumber
POBoxPostalCode POBoxPostalCode
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingRegion POBoxDeviatingRegion
POBoxDeviatingCountry POBoxDeviatingCountry
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
AddressTimeZone AddressTimeZone
FullName FullName
CityName CityName
DistrictName District
ProcmtHubCityCode CityCode
HomeCityName HomeCityName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
StreetName StreetName
StreetPrefixName StreetPrefixName
AdditionalStreetPrefixName AdditionalStreetPrefixName
StreetSuffixName StreetSuffixName
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
PurContrCountyText County
FormOfAddress FormOfAddress
ConsigneeName3 ConsigneeName3
ConsigneeName4 ConsigneeName4
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
PhoneNumber PhoneNumber
MobilePhoneNumber MobilePhoneNumber
AddressFaxNumber FaxNumber
EmailAddress EmailAddress
LastChangeDateTime _PurContract LastChangeDateTime
_PurContract _PurContract
_PurchaseContractItem _PurchaseContractItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Address'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  [ 'PurchaseContract','PurchaseContractItem' ]

@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@Metadata.ignorePropagatedAnnotations: true
define view entity R_PurContrAddressTP
  as select from I_PurCtrAddress
  association to parent R_PurchaseContractItemTP as _PurchaseContractItem on  _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
                                                                          and _PurchaseContractItem.PurchaseContract     = $projection.PurchaseContract
  association to R_PurchaseContractTP            as _PurContract          on  _PurContract.PurchaseContract = $projection.PurchaseContract
{
  key PurchaseContract,
  key PurchaseContractItem,
      AddressID,
      Plant,
      CareOfName,
      AdditionalStreetSuffixName,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      FullName,
      CityName,
      District                             as DistrictName,
      CityCode                             as ProcmtHubCityCode,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      County                             as PurContrCountyText,
      FormOfAddress,
      ConsigneeName3,
      ConsigneeName4,
      TaxJurisdiction,
      TransportZone,
      PhoneNumber,
      MobilePhoneNumber,
      FaxNumber                            as AddressFaxNumber,
      EmailAddress,

      @Semantics.systemDateTime.lastChangedAt: true
      _PurContract.LastChangeDateTime as LastChangeDateTime,

      /* Associations */
      _PurContract,
      _PurchaseContractItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRADDRESS",
"R_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_PURCHASECONTRACTITEMTP",
"R_PURCHASECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More